kc.sql.svn-base

来自「这是基于spring +hibernate的项目」· SVN-BASE 代码 · 共 308 行 · 第 1/5 页

CREATE TABLE `image` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `newname` varchar(255) default NULL,
  `size` bigint(20) default NULL,
  `uploadtime` varchar(30) default NULL,
  `dish_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `dish_id` (`dish_id`),
  CONSTRAINT `image_ibfk_1` FOREIGN KEY (`dish_id`) REFERENCES `dish` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `member` table : 
#

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

#
# Structure for the `order` table : 
#

CREATE TABLE `order` (
  `id` bigint(20) NOT NULL auto_increment,
  `member_id` bigint(20) NOT NULL default '0',
  `orderDate` varchar(30) default NULL,
  `totalPrice` double(15,3) NOT NULL default '0.000',
  PRIMARY KEY  (`id`),
  KEY `member_id` (`member_id`),
  CONSTRAINT `order_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Structure for the `lineitem` table : 
#

CREATE TABLE `lineitem` (
  `id` bigint(20) NOT NULL auto_increment,
  `dish_id` bigint(20) NOT NULL default '0',
  `order_id` bigint(20) NOT NULL default '0',
  `quantity` int(11) NOT NULL default '0',
  `unitPrice` double(11,0) NOT NULL default '0',
  PRIMARY KEY  (`id`),