kc.sql.svn-base

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

# EMS MySQL Manager Lite 3.4.0.4
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : kc


SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `kc`
    CHARACTER SET 'utf8'
    COLLATE 'utf8_general_ci';

USE `kc`;

#
# Structure for the `about` table : 
#

CREATE TABLE `about` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `content` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `admin` table : 
#

CREATE TABLE `admin` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(20) default NULL,
  `password` varchar(20) default NULL,
  `loginip` varchar(20) default NULL,
  `logintime` varchar(30) default NULL,
  `logincount` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `dishsort` table : 
#

CREATE TABLE `dishsort` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `remark` varchar(255) default NULL,
  `seq` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `dish` table : 
#

CREATE TABLE `dish` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `about` varchar(255) default NULL,
  `shtick` varchar(255) default NULL,
  `material` varchar(255) default NULL,
  `hot` int(11) default NULL,
  `price` double default NULL,
  `memberprice` double default NULL,
  `isnew` varchar(255) default NULL,
  `senddate` varchar(255) default NULL,
  `dishSort_id` bigint(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK2F0D9A58641C3B` (`dishSort_id`),
  CONSTRAINT `FK2F0D9A58641C3B` FOREIGN KEY (`dishSort_id`) REFERENCES `dishsort` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `helper` table : 
#

CREATE TABLE `helper` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `content` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#