学Java-图书销售系统-数据库结构 - 编程入门网
作者 佚名技术
来源 NET编程
浏览
发布时间 2012-06-18
| int(11) NOT NULL auto_increment COMMENT ''流水号'',
`username` varchar(20) collate utf8_unicode_ci NOT NULL COMMENT ''用户名'',
`password` varchar(50) collate utf8_unicode_ci NOT NULL COMMENT ''密码'',
PRIMARY KEY (`Id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `t_book` VALUES (''1'', ''Java基础12'', ''25.01'', ''0'');
INSERT INTO `t_book` VALUES (''2'', ''Java高级编程'', ''89.23'', ''2'');
INSERT INTO `t_book` VALUES (''3'', ''跟老紫竹学Java'', ''50.45'', ''3'');
INSERT INTO `t_book` VALUES (''4'', ''Java大全'', ''111.00'', ''4'');
INSERT INTO `t_bookstockhistory` VALUES (''1'', ''3'', ''1'', ''1'', ''50.45'', ''2008-07-25 12:27:21'', null);
INSERT INTO `t_bookstockhistory` VALUES (''2'', ''2'', ''1'', ''99'', ''89.23'', ''2008-07-25 12:29:18'', null);
INSERT INTO `t_bookstockhistory` VALUES (''3'', ''3'', ''1'', ''0'', ''50.45'', ''2008-07-25 12:29:18'', null);
INSERT INTO `t_bookstockhistory` VALUES (''4'', ''1'', ''1'', ''0'', ''25.01'', ''2008-07-25 13:32:24'', ''会员购买'');
INSERT INTO `t_order` VALUES (''7'', ''2'', ''2238'', ''2008-07-25 11:33:27'', null);
INSERT INTO `t_order` VALUES (''8'', ''2'', ''165'', ''2008-07-25 11:52:38'', null);
INSERT INTO `t_order` VALUES (''9'', ''2'', ''25'', ''2008-07-25 11:58:51'', null);
INSERT INTO `t_order` VALUES (''10'', ''2'', ''25'', ''2008-07-25 12:00:00'', null);
INSERT INTO `t_order` VALUES (''11'', ''2'', ''140'', ''2008-07-25 12:29:18'', null);
INSERT INTO `t_order` VALUES (''12'', ''1'', ''25'', ''2008-07-25 13:32:24'', null);
INSERT INTO `t_orderbook` VALUES (''5'', ''7'', ''1'', ''11'');
INSERT INTO `t_orderbook` VALUES (''6'', ''7'', ''2'', ''22'');
INSERT INTO `t_orderbook` VALUES (''7'', ''8'', ''1'', ''1'');
INSERT INTO `t_orderbook` VALUES (''8'', ''8'', ''2'', ''1'');
INSERT INTO `t_orderbook` VALUES (''9'', ''8'', ''3'', ''1'');
INSERT INTO `t_orderbook` VALUES (''10'', ''9'', ''1'', ''1'');
INSERT INTO `t_orderbook` VALUES (''11'', ''10'', ''1'', ''1'');
INSERT INTO `t_orderbook` VALUES (''12'', ''11'', ''2'', ''1'');
INSERT INTO `t_orderbook` VALUES (''13'', ''11'', ''3'', ''1'');
INSERT INTO `t_orderbook` VALUES (''14'', ''12'', ''1'', ''1'');
INSERT INTO `t_user` VALUES (''1'', ''admin'', ''admin'');
INSERT INTO `t_user` VALUES (''2'', ''user'', ''user'');
INSERT INTO `t_user` VALUES (''3'', ''test'', ''test''); |
凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢! |
你可能对下面的文章感兴趣
关于学Java-图书销售系统-数据库结构 - 编程入门网的所有评论
