资源描述：
《美食数据库代码》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、/*NavicatMySQLDataTransferSourceServer:localhostSourceServerVersion:50157SourceHost:localhost:3306SourceDatabase:db_eateryTargetServerType:MYSQLTargetServerVersion:50157FileEncoding:65001Date:2013-09-2012:57:57*/SETFOREIGN_KEY_CHECKS=0;-------------------------
2、-------Tablestructureforadmin------------------------------DROPTABLEIFEXISTS`admin`;CREATETABLE`admin`(`ID`int(4)NOTNULLAUTO_INCREMENT,`AdminType`int(4)DEFAULTNULL,`AdminName`char(12)DEFAULTNULL,`LoginName`char(12)DEFAULTNULL,`LoginPwd`char(12)DEFAULTNULL,PRIMA
3、RYKEY(`ID`))ENGINE=InnoDBAUTO_INCREMENT=10DEFAULTCHARSET=gb2312;--------------------------------Recordsofadmin------------------------------INSERTINTO`admin`VALUES('1','0','超级管理员','admin','admin');INSERTINTO`admin`VALUES('2','1','普通管理员','kongle','123456');INSER
4、TINTO`admin`VALUES('9','1','孔乐','kl','123');--------------------------------Tablestructureforcart------------------------------DROPTABLEIFEXISTS`cart`;CREATETABLE`cart`(`ID`int(4)NOTNULLAUTO_INCREMENT,`Member`int(4)NOTNULL,`Money`decimal(9,2)DEFAULTNULL,`CartSt
5、atus`int(4)DEFAULTNULL,PRIMARYKEY(`ID`))ENGINE=InnoDBAUTO_INCREMENT=14DEFAULTCHARSET=gb2312;--------------------------------Recordsofcart------------------------------INSERTINTO`cart`VALUES('1','1','97.80','1');INSERTINTO`cart`VALUES('2','1','38.00','1');INSERT
6、INTO`cart`VALUES('5','1','12.00','1');INSERTINTO`cart`VALUES('6','1','40.00','1');INSERTINTO`cart`VALUES('7','2','86.40','1');INSERTINTO`cart`VALUES('8','2','0.00','0');INSERTINTO`cart`VALUES('9','1','40.00','1');INSERTINTO`cart`VALUES('10','1','8.00','1');INSE
7、RTINTO`cart`VALUES('11','1','9.50','1');INSERTINTO`cart`VALUES('12','1','12.00','1');INSERTINTO`cart`VALUES('13','3','52.50','1');--------------------------------Tablestructureforcartselectedmer------------------------------DROPTABLEIFEXISTS`cartselectedmer`;CR
8、EATETABLE`cartselectedmer`(`ID`int(4)NOTNULLAUTO_INCREMENT,`Cart`int(4)NOTNULL,`Merchandise`int(4)NOTNULL,`Number`int(4)NOTNULLDEFAULT'1',`Price`decimal(8,2)NOTNULLDEFAULT'0
