128kc.sql.svn-base

这是基于spring +hibernate的项目

CREATE TABLE `image` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `newname` varchar(50) default NULL,
  `size` int(11) default NULL,
  `uploadtime` varchar(30) default NULL,
  `dish_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8


CREATE TABLE `dishsort` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `remark` text,
  `seq` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE `dish` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `remark` text,
  `dishsort_id` int(11) NOT NULL default '0',
  `hot` int(11) NOT NULL default '0',
  `price` double(15,2) default NULL,
  `memberprice` double(15,2) default NULL,
  `senddate` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `newsTitle` varchar(50) default NULL,
  `newsAuthor` varchar(20) default NULL,
  `newsFrom` varchar(20) default NULL,
  `newsDate` varchar(30) default NULL,
  `newsContent` text,
  `fileName` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.pure.domain">
	<class name="com.pure.domain.Image" table="image" dynamic-update="false" dynamic-insert="false">
		<id column="id" name="id" type="long">
			<generator class="native" />
		</id>
		<property column="name" length="100" name="name" type="java.lang.String" />
		<property column="newname" length="255" name="newName" type="java.lang.String" />
		<property column="size"  name="size" type="java.lang.Long" />
		<property column="uploadtime" length="30" name="uploadTime" type="java.lang.String" />
		<many-to-one name="dish" class="com.pure.domain.Dish" cascade="all" outer-join="auto" update="true" insert="true" access="property" column="dish_id" not-null="true"/>
	</class>
</hibernate-mapping>