kc.sql.svn-base

来自「spring+hibernate做的网上订餐系统」· SVN-BASE 代码 · 共 421 行 · 第 1/5 页

# Structure for the `images` table : 
#

CREATE TABLE `images` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `newname` varchar(255) default NULL,
  `size` bigint(20) default NULL,
  `uploadtime` varchar(255) default NULL,
  `dish_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `FKB95A827829A3AD5B` (`dish_id`),
  CONSTRAINT `FKB95A827829A3AD5B` FOREIGN KEY (`dish_id`) REFERENCES `dish` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `member` table : 
#

CREATE TABLE `member` (
  `id` bigint(20) NOT NULL auto_increment,
  `username` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `sex` varchar(255) default NULL,
  `birthday` varchar(255) default NULL,
  `idcard` varchar(255) default NULL,
  `company` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `tel` varchar(255) default NULL,
  `handset` varchar(255) default NULL,
  `loginip` varchar(255) default NULL,
  `logintime` varchar(255) default NULL,
  `logincount` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `orders` table : 
#

CREATE TABLE `orders` (
  `id` bigint(20) NOT NULL auto_increment,
  `member_id` bigint(20) NOT NULL default '0',
  `orderDate` varchar(30) default NULL,
  `totalPrice` double default NULL,
  `newname` varchar(50) default NULL,
  `newcompany` varchar(200) default NULL,
  `newaddress` varchar(200) default NULL,
  `newemail` varchar(50) default NULL,
  `newtel` varchar(20) default NULL,
  `newhandset` varchar(20) default NULL,
  `state` char(1) default 'N',
  PRIMARY KEY  (`id`),
  KEY `FKC3DF62E5AE27991B` (`member_id`),
  CONSTRAINT `FKC3DF62E5AE27991B` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `line_items` table : 
#

CREATE TABLE `line_items` (
  `order_id` bigint(20) NOT NULL default '0',
  `quantity` int(11) default NULL,
  `unitprice` double default NULL,
  `totalPrice` double default NULL,
  `dish_id` bigint(20) default NULL,
  `line_number` int(11) NOT NULL default '0',
  PRIMARY KEY  (`order_id`,`line_number`),
  KEY `FK8BE33B5447B6939` (`order_id`),
  KEY `FK8BE33B529A3AD5B` (`dish_id`),
  CONSTRAINT `FK8BE33B529A3AD5B` FOREIGN KEY (`dish_id`) REFERENCES `dish` (`id`),
  CONSTRAINT `FK8BE33B5447B6939` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `newssort` table : 
#

CREATE TABLE `newssort` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `code` varchar(255) default NULL,