kc.sql.svn-base

来自「这是基于spring +hibernate的项目」· SVN-BASE 代码 · 共 308 行 · 第 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 'gbk'
    COLLATE 'gbk_chinese_ci';

USE `kc`;

#
# Structure for the `about` table : 
#

CREATE TABLE `about` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `content` text,
  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(100) 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(100) 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` char(1) default 'N',
  `senddate` varchar(30) default NULL,
  `dishSort_id` bigint(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `dishSort_id` (`dishSort_id`),
  CONSTRAINT `dish_ibfk_1` FOREIGN KEY (`dishSort_id`) REFERENCES `dishsort` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Structure for the `image` table : 
#