innodb128kc.sql.svn-base

这是基于spring +hibernate的项目

# 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 `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,
  `remark` varchar(255) default NULL,
  `hot` int(11) default NULL,
  `price` double default NULL,
  `memberprice` double default NULL,
  `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 : 
#

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 `news` table : 
#

CREATE TABLE `news` (
  `id` bigint(20) NOT NULL auto_increment,
  `newsTitle` varchar(50) default NULL,
  `newsAuthor` varchar(50) default NULL,
  `newsFrom` varchar(50) default NULL,
  `newsDate` varchar(50) default NULL,
  `newsContent` varchar(255) default NULL,
  `fileName` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;