svnno****@sourc*****
svnno****@sourc*****
2007年 7月 19日 (木) 06:11:47 JST
Revision: 304
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=304
Author: takeharu
Date: 2007-07-19 06:11:47 +0900 (Thu, 19 Jul 2007)
Log Message:
-----------
updated pompei db shema
Modified Paths:
--------------
pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml
-------------- next part --------------
Modified: pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml 2007-07-18 21:11:19 UTC (rev 303)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml 2007-07-18 21:11:47 UTC (rev 304)
@@ -288,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"
@@ -306,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"