netshop.sql

网络书店

# MySQL-Front 3.1  (Build 13.0)



# Host: localhost   Database: netshop
# ------------------------------------------------------
# Server version 3.23.39

CREATE DATABASE `netshop`;
USE `netshop`;

#
# Table structure for table attention
#

CREATE TABLE `attention` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `userID` bigint(20) unsigned default '0',
  `goodsID` bigint(20) unsigned default '0',
  `tag` int(4) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;


#
# Table structure for table discussion
#

CREATE TABLE `discussion` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `goodsID` bigint(20) unsigned default '0',
  `authorID` bigint(20) unsigned default '0',
  `authorName` varchar(100) default NULL,
  `content` text,
  `createDate` date default '0000-00-00',
  `disType` int(4) unsigned default '1',
  `tag` int(4) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Table structure for table email
#

CREATE TABLE `email` (
  `ID` bigint(20) NOT NULL auto_increment,
  `subject` varchar(200) NOT NULL default '',
  `content` text,
  `sender` varchar(200) NOT NULL default '',
  `receiver` varchar(200) NOT NULL default '',
  `createDatetime` datetime default '0000-00-00 00:00:00',
  `mailType` int(10) default '0',
  `tag` int(10) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;


#
# Table structure for table goods
#

CREATE TABLE `goods` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `title` varchar(100) default NULL,
  `description` text,
  `issuer` bigint(20) unsigned default '0',
  `goodsField` bigint(20) unsigned default '0',
  `linkMan` varchar(50) default NULL,
  `telephone` varchar(20) default NULL,
  `goodsURL` varchar(50) default NULL,
  `price` bigint(20) unsigned default '0',
  `createDate` date default '0000-00-00',
  `goodsType` int(4) unsigned default '2',
  `tag` int(4) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;


#
# Table structure for table goodsField
#

CREATE TABLE `goodsField` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `tag` int(4) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Table structure for table users
#

CREATE TABLE `users` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `userName` varchar(50) NOT NULL default '',
  `userPassword` varchar(50) NOT NULL default '',
  `email` varchar(50) default NULL,
  `sex` int(4) default '0',
  `identityID` varchar(20) default '000000000000000000',
  `shopName` varchar(100) default NULL,
  `shopIntro` text,
  `shopper` varchar(100) default NULL,
  `realName` varchar(20) default NULL,
  `mainFields` bigint(20) unsigned default '0',
  `telephone` varchar(20) default NULL,
  `createDate` date default '0000-00-00',
  `sysRole` int(4) unsigned default '1',
  `tag` int(4) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Dumping data for table users
#

INSERT INTO `users` VALUES (1,'admin','admin',NULL,0,'000000000000000000',NULL,NULL,NULL,NULL,0,NULL,'0000-00-00',0,0);