jsp乐趣大型购物系统

CREATE TABLE `tbs001` ( `Tbs001_inc` int unsigned NOT NULL auto_increment, `Id` varchar(20) NOT NULL, `nickname` varchar(40) not null, `pwd` Varchar(60) NOT NULL, `Email` Varchar(60) NOT NULL, `Name` Varchar(40), `Address` Varchar(100), zipcode char(6), `Tel` Varchar(40), fax varchar(40), `Mobilephone` Varchar(40), `birthday` date, `vocation` varchar(40), `Create_time` Datetime NOT NULL, `Log_time` Datetime NOT NULL, `Type` int NOT NULL default 0, `Status` Char(2) NOT NULL, PRIMARY KEY (`tbs001_inc`,`id`,`nickname`) ) TYPE=MyISAM; CREATE TABLE `tbs002` ( `Tbs002_inc` int unsigned NOT NULL auto_increment, `Name` varchar(50) NOT NULL, `parentid` int NOT NULL default 0, Is_banner char(2) not null default '00', Sort int not null default 100, `Status` Char(2) NOT NULL default '00', PRIMARY KEY (`tbs002_inc`) ) TYPE=MyISAM; CREATE TABLE `tbs003` ( `Tbs003_inc` int unsigned NOT NULL auto_increment, `Tbs001_inc` int NOT NULL, Tbs002_inc int NOT NULL, `parentid` int NOT NULL, author varchar(40) not null, Title varchar(100) not null, url varchar(150) not null default '0', Is_banner char(2) not null default '00', Article_type char(2) not null default '00', pick varchar(100) , Content text not null, Create_time Datetime not null , type Char(2) default '00', url_type Char(1) not null default 0, Sort int not null default 100, `Status` Char(2) NOT NULL default '00', PRIMARY KEY (`tbs003_inc`) ) TYPE=MyISAM; CREATE TABLE tbs004 ( Tbs004_inc int unsigned NOT NULL auto_increment, Tbs001_inc int NOT NULL, nickname varchar(40), Tbs003_inc int NOT NULL, Content Text not null, ip varchar(20) not null, sort int not null default 100, Create_time Datetime not null , Status Char(2) NOT NULL default '00', PRIMARY KEY (tbs004_inc) ) TYPE=MyISAM; CREATE TABLE `tbs005` ( `Tbs005_inc` int unsigned NOT NULL auto_increment, `id` varchar(20) NOT NULL, title varchar(100) not null, Content Text not null, Low_valid_date date not null, Hight_valid_date date not null, sort int not null default 100, Create_time Datetime not null , `Status` Char(2) NOT NULL default '00', PRIMARY KEY (`tbs005_inc`) ) TYPE=MyISAM; CREATE TABLE `tbs006` ( `Tbs006_inc` int unsigned NOT NULL auto_increment, `id` varchar(20) NOT NULL, brief varchar(200) not null, web_url varchar(150) not null, image_url varchar(150) not null, type char(2) not null, sort int not null, Create_time Datetime not null , `Status` Char(2) NOT NULL default '00', PRIMARY KEY (`tbs006_inc`) ) TYPE=MyISAM; CREATE TABLE `tbs051` ( `Tbs051_inc` int unsigned NOT NULL auto_increment, `Catalog_id` int NOT NULL, `name` varchar(255) not null, `Keywords` Varchar(50) NOT NULL, brief varchar(200) not null, `Product_intr` Text NOT NULL, `manufacturer` Varchar(100), market_price int, `Price` int, `Member_price` int, cost_price int, `Currency_id` Char(5) not null, `Type` Char(2) not null, position char(2) not null, `is_supply` Char(2) not null default '00', `Create_id` Char(20), `Create_date` DATETIME NOT NULL, update_date Datetime, update_id varchar(20), Sort int default 100, `Status` Char(2) NOT NULL, PRIMARY KEY (`tbs051_inc`) ) TYPE=MyISAM; CREATE TABLE `tbs052` ( `Tbs052_inc` int unsigned NOT NULL auto_increment, `Tbs051_inc` int, Img_url varchar(150), brief varchar(200), Position char(10), `Create_id` Char(20), `Create_time` DATEtime NOT NULL, Sort int default 100, `Status` Char(2) NOT NULL, PRIMARY KEY (`tbs052_inc`) ) TYPE=MyISAM; CREATE TABLE `tbs053` ( `Tbs053_inc` int unsigned NOT NULL auto_increment, `Tbs051_inc` int, title varchar(50), content text, Ip varchar(20), `Create_id` Char(20), `Create_time` DATEtime NOT NULL, `update_time` DATEtime NOT NULL, Sort int default 100, `Status` Char(2) NOT NULL, PRIMARY KEY (`tbs053_inc`) ) TYPE=MyISAM; CREATE TABLE `tbs053` ( `Tbs053_inc` int unsigned NOT NULL auto_increment, `Tbs052_inc` int, Title varchar(50), Content varchar(255), `id` varchar(20), `Create_date` DATE NOT NULL, Sort int default 100, `Status` Char(2) NOT NULL, PRIMARY KEY (`tbs053_inc`) ) TYPE=MyISAM; CREATE TABLE `tap001` ( `Tap001_inc` int unsigned NOT NULL auto_increment, tbs051_inc int not null, `Goodsname` varchar(255) NOT NULL, Member_rice int not null, Access_price int not null, Cost_price int not null, Ordernum int not null, Membertotalprice int not null, Totalprice int not null, costtotalprice int not null, Confirm_type Char(2) not null, Pay_type Char(2) not null, remark text, `nickname` varchar(40) not null, `Email` Varchar(60) NOT NULL, `Name` Varchar(40), `Address` Varchar(100), zipcode char(6), `Tel` Varchar(40), fax varchar(40), `Mobilephone` Varchar(40), `Create_time` Datetime NOT NULL, Create_id varchar(20) not null, `update_time` Datetime NOT NULL, update_id varchar(20), `reason` text, sendgoods char(2), `Status` Char(5) NOT NULL, PRIMARY KEY (`tap001_inc`) ) TYPE=MyISAM; CREATE TABLE `tcd001` ( `Tcd001_inc` int unsigned NOT NULL auto_increment, `Name` varchar(50) not null, Sort int not null default 100, `Is_banner` char(2) not null, Positon char(10) not null, Parentid int not null, Create_time datetime not null, create_id varchar(20) not null, `Status` Char(2) NOT NULL, PRIMARY KEY (`tcd001_inc`) ) TYPE=MyISAM; CREATE TABLE `tcd002` ( id char(2) not null, `Name` varchar(50) not null, `Status` Char(2) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; CREATE TABLE `tcd003` ( typeid char(2) not null, `Name` varchar(50) not null, `Status` Char(2) NOT NULL, PRIMARY KEY (typeid) ) TYPE=MyISAM; CREATE TABLE `tcd004` ( typeid char(5) not null, `Name` varchar(50) not null, `Status` Char(2) NOT NULL, PRIMARY KEY (typeid) ) TYPE=MyISAM; CREATE TABLE `tsy001` ( `Tsy001_inc` int unsigned NOT NULL auto_increment, `id` varchar(20), Name varchar(50), pwd varchar(60), `Create_date` DATE NOT NULL, type int default 0, Sort int default 100, `Status` Char(2) NOT NULL, PRIMARY KEY (`tsy001_inc`,id) ) TYPE=MyISAM;