svnno****@sourc*****
svnno****@sourc*****
2007年 7月 19日 (木) 06:11:19 JST
Revision: 303 http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=303 Author: takeharu Date: 2007-07-19 06:11:19 +0900 (Thu, 19 Jul 2007) Log Message: ----------- updated pompei db shema Modified Paths: -------------- pompei/trunk/dbflute/schema/project-schema-pompei.xml -------------- next part -------------- Modified: pompei/trunk/dbflute/schema/project-schema-pompei.xml =================================================================== --- pompei/trunk/dbflute/schema/project-schema-pompei.xml 2007-07-18 21:10:37 UTC (rev 302) +++ pompei/trunk/dbflute/schema/project-schema-pompei.xml 2007-07-18 21:11:19 UTC (rev 303) @@ -82,8 +82,10 @@ name="BANNERS_HISTORY_DATE" required="true" type="TIMESTAMP"/> </table> <table name="CATEGORIES"> - <column dbType="INTEGER" javaType="java.math.BigDecimal" - name="CATEGORIES_ID" primaryKey="true" required="true" type="INTEGER"/> + <column autoIncrement="true" dbType="INTEGER" + default="AUTOINCREMENT: start 1 increment 1" + javaType="java.math.BigDecimal" name="CATEGORIES_ID" + primaryKey="true" required="true" type="INTEGER"/> <column dbType="VARCHAR" javaType="String" name="CATEGORIES_IMAGE" size="64" type="VARCHAR"/> <column dbType="INTEGER" default="0" @@ -105,6 +107,9 @@ primaryKey="true" required="true" type="INTEGER"/> <column dbType="VARCHAR" javaType="String" name="CATEGORIES_NAME" required="true" size="32" type="VARCHAR"/> + <foreign-key foreignTable="CATEGORIES" name="SQL070718023316900"> + <reference foreign="CATEGORIES_ID" local="CATEGORIES_ID"/> + </foreign-key> </table> <table name="CONFIGURATION"> <column dbType="INTEGER" javaType="java.math.BigDecimal" @@ -283,8 +288,10 @@ name="SORT_ORDER" type="INTEGER"/> </table> <table name="MANUFACTURERS"> - <column dbType="INTEGER" javaType="java.math.BigDecimal" - name="MANUFACTURERS_ID" primaryKey="true" required="true" type="INTEGER"/> + <column autoIncrement="true" dbType="INTEGER" + default="AUTOINCREMENT: start 1 increment 1" + javaType="java.math.BigDecimal" name="MANUFACTURERS_ID" + primaryKey="true" required="true" type="INTEGER"/> <column dbType="VARCHAR" javaType="String" name="MANUFACTURERS_NAME" required="true" size="32" type="VARCHAR"/> <column dbType="VARCHAR" javaType="String" @@ -301,11 +308,18 @@ name="LANGUAGES_ID" primaryKey="true" required="true" type="INTEGER"/> <column dbType="VARCHAR" javaType="String" name="MANUFACTURERS_URL" required="true" size="255" type="VARCHAR"/> + <column dbType="VARCHAR" javaType="String" + name="MANUFACTURERS_SHORT_DESC" size="100" type="VARCHAR"/> + <column dbType="VARCHAR" javaType="String" + name="MANUFACTURERS_LONG_DESC" size="1000" type="VARCHAR"/> <column dbType="INTEGER" default="0" javaType="java.math.BigDecimal" name="URL_CLICKED" required="true" type="INTEGER"/> <column dbType="TIMESTAMP" javaType="java.sql.Timestamp" name="DATE_LAST_CLICK" type="TIMESTAMP"/> + <foreign-key foreignTable="MANUFACTURERS" name="SQL070719032256430"> + <reference foreign="MANUFACTURERS_ID" local="MANUFACTURERS_ID"/> + </foreign-key> </table> <table name="NEWSLETTERS"> <column dbType="INTEGER" javaType="java.math.BigDecimal"