cebi.sql

CEBI电子商务网站 基于JSP+javaBean结构

# MySQL-Front 3.2  (Build 14.3)

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: 127.0.0.1    Database: cebi
# ------------------------------------------------------
# Server version 5.0.45-community-nt

#
# Table structure for table sp
#

DROP TABLE IF EXISTS `sp`;
CREATE TABLE `sp` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(21) default NULL,
  `jg` float(11,2) default NULL,
  `sl` int(7) default NULL,
  `date` timestamp NULL default CURRENT_TIMESTAMP,
  `fl` varchar(17) default NULL,
  `img` varchar(100) default NULL,
  `jianjie` varchar(800) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table sp
#

INSERT INTO `sp` VALUES (1,'多普达钻石手机',1,3,'2008-11-12 15:46:01','手机',NULL,NULL);
INSERT INTO `sp` VALUES (2,'惠普6515B笔记本电脑',3,3,'2008-11-12 15:46:12','笔记本电脑',NULL,NULL);
INSERT INTO `sp` VALUES (3,'诺基亚N96',2,3,'2008-11-12 23:33:39','手机',NULL,NULL);
INSERT INTO `sp` VALUES (4,'国产杂牌手机',2.33,3,'2008-11-12 23:34:03','手机',NULL,NULL);
INSERT INTO `sp` VALUES (5,'IBMX30',2.99,5,'2008-11-12 23:34:42','笔记本电脑',NULL,NULL);
INSERT INTO `sp` VALUES (6,'rr',2,2,'2008-11-13 02:07:25','其他',NULL,NULL);
INSERT INTO `sp` VALUES (7,'呃呃呃',22,33,'2008-11-13 02:07:42','其他',NULL,NULL);
INSERT INTO `sp` VALUES (8,'衣服',4,2,'2008-11-13 02:09:51','生活用品',NULL,NULL);
INSERT INTO `sp` VALUES (9,'ee',NULL,NULL,'2008-11-13 19:55:30',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (10,'ff',NULL,NULL,'2008-11-13 19:55:35',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (11,'ggg',NULL,NULL,'2008-11-13 19:55:39',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (12,'g',NULL,NULL,'2008-11-13 19:55:42',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (13,'gn',NULL,NULL,'2008-11-13 19:55:48',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (14,'oo',NULL,NULL,'2008-11-13 19:55:51',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (15,'ll',NULL,NULL,'2008-11-13 19:55:54',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (16,'sasds',NULL,NULL,'2008-11-13 19:55:58',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (17,'vdcvd',NULL,NULL,'2008-11-13 19:56:00',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (18,'cdfcd',NULL,NULL,'2008-11-13 19:56:06',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (19,'dsds',NULL,NULL,'2008-11-13 19:56:09',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (20,'ds',NULL,NULL,'2008-11-13 19:56:13',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (21,'dvds',NULL,NULL,'2008-11-13 19:56:17',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (22,'d',NULL,NULL,'2008-11-13 19:56:21',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (23,'asdas',NULL,NULL,'2008-11-13 19:56:24',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (24,'dad',NULL,NULL,'2008-11-13 19:56:27',NULL,NULL,NULL);
INSERT INTO `sp` VALUES (25,'ds',NULL,NULL,'2008-11-13 20:43:48',NULL,NULL,NULL);

#
# Table structure for table users
#

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(21) default NULL,
  `pass` varchar(15) default NULL,
  `sex` varchar(9) default NULL,
  `dianhua` varchar(15) default NULL,
  `dizhi` varchar(60) default NULL,
  `email` varchar(21) default NULL,
  `beizhu` varchar(200) default NULL,
  `money` float(11,2) default '10000.00',
  `date` timestamp NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table users
#

INSERT INTO `users` VALUES (1,'q','q',NULL,'q','q',NULL,NULL,10000,'2008-11-13 03:37:15');
INSERT INTO `users` VALUES (2,'s','ss',NULL,'s','s',NULL,NULL,10000,'2008-11-13 03:38:27');
INSERT INTO `users` VALUES (3,'f','f',NULL,'f','f',NULL,NULL,10000,'2008-11-13 03:40:38');
INSERT INTO `users` VALUES (4,'f','f',NULL,'f','f',NULL,NULL,10000,'2008-11-13 13:29:44');
INSERT INTO `users` VALUES (5,'a','a',NULL,'a','a',NULL,NULL,10000,'2008-11-13 18:41:17');
INSERT INTO `users` VALUES (6,'y','y','y','y','y','y','y',10000,'2008-11-13 23:40:52');
INSERT INTO `users` VALUES (7,'cd','d','d','d','d','d','d',10000,'2008-11-13 23:45:11');
INSERT INTO `users` VALUES (8,'k','k','k','k','k','k','k',10000,'2008-11-13 23:45:27');

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;