svnno****@sourc*****
svnno****@sourc*****
2008年 12月 15日 (月) 22:43:27 JST
Revision: 1609
http://svn.sourceforge.jp/view?root=pal&view=rev&rev=1609
Author: shinsuke
Date: 2008-12-15 22:43:27 +0900 (Mon, 15 Dec 2008)
Log Message:
-----------
added files for mysql.
Added Paths:
-----------
userinfo/trunk/src/main/config/erd/mysql/
userinfo/trunk/src/main/config/erd/mysql/userinfo.erd
userinfo/trunk/src/main/config/sql/mysql/
userinfo/trunk/src/main/config/sql/mysql/drop.sql
userinfo/trunk/src/main/config/sql/mysql/others/
userinfo/trunk/src/main/config/sql/mysql/others/0-userinfo.dml
userinfo/trunk/src/main/config/sql/mysql/others/addresslist.ddl
userinfo/trunk/src/main/config/sql/mysql/others/board.ddl
userinfo/trunk/src/main/config/sql/mysql/others/board.dml
userinfo/trunk/src/main/config/sql/mysql/others/bookmark.ddl
userinfo/trunk/src/main/config/sql/mysql/others/bookmark.dml
userinfo/trunk/src/main/config/sql/mysql/others/notepad.ddl
userinfo/trunk/src/main/config/sql/mysql/others/notepad.dml
userinfo/trunk/src/main/config/sql/mysql/others/scheduler.ddl
userinfo/trunk/src/main/config/sql/mysql/others/timecard.ddl
userinfo/trunk/src/main/config/sql/mysql/others/timecard.dml
userinfo/trunk/src/main/config/sql/mysql/others/todolist.ddl
userinfo/trunk/src/main/config/sql/mysql/userinfo.ddl
-------------- next part --------------
Added: userinfo/trunk/src/main/config/erd/mysql/userinfo.erd
===================================================================
--- userinfo/trunk/src/main/config/erd/mysql/userinfo.erd (rev 0)
+++ userinfo/trunk/src/main/config/erd/mysql/userinfo.erd 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,941 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<net.java.amateras.db.visual.model.RootModel>
+ <children>
+ <net.java.amateras.db.visual.model.TableModel>
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>user_info</tableName>
+ <logicalName>User Information</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>user_id</columnName>
+ <logicalName>User ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>given_name</columnName>
+ <logicalName>Given Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>family_name</columnName>
+ <logicalName>Family Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>middle_name</columnName>
+ <logicalName>Middle Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>50</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>given_name_desc</columnName>
+ <logicalName>Given Name Descritpion</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>family_name_desc</columnName>
+ <logicalName>Family Name Description</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>nickname</columnName>
+ <logicalName>Nickname</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>gender</columnName>
+ <logicalName>Gender</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[7]/columnType"/>
+ <size>1</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>birth_date</columnName>
+ <logicalName>Birth Date</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>DATE</name>
+ <logicalName>Date</logicalName>
+ <supportSize>false</supportSize>
+ <type>91</type>
+ </columnType>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>email</columnName>
+ <logicalName>Email</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>url</columnName>
+ <logicalName>URL</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>telephone</columnName>
+ <logicalName>Telephone</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>40</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>locale</columnName>
+ <logicalName>Locale</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>5</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>role_id</columnName>
+ <logicalName>Default Role ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>group_id</columnName>
+ <logicalName>Default Group ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_time</columnName>
+ <logicalName>Created Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>TIMESTAMP</name>
+ <logicalName>Datetime</logicalName>
+ <supportSize>false</supportSize>
+ <type>93</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_by</columnName>
+ <logicalName>Created By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_time</columnName>
+ <logicalName>Updated Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_by</columnName>
+ <logicalName>Updated By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_time</columnName>
+ <logicalName>Deleted Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_by</columnName>
+ <logicalName>Deleted By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>versionNo</columnName>
+ <logicalName>Version No.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>INTEGER</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>false</supportSize>
+ <type>4</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>185</x>
+ <y>199</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_user_to_group</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>group_id</columnName>
+ <logicalName>Group ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[15]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>group_info</tableName>
+ <logicalName>Group Information</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>name</columnName>
+ <logicalName>Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>description</columnName>
+ <logicalName>Description</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>email</columnName>
+ <logicalName>Email</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>url</columnName>
+ <logicalName>URL</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>telephone</columnName>
+ <logicalName>Telephone</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>40</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_time</columnName>
+ <logicalName>Created Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_by</columnName>
+ <logicalName>Created By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_time</columnName>
+ <logicalName>Updated Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_by</columnName>
+ <logicalName>Updated By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_time</columnName>
+ <logicalName>Deleted Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_by</columnName>
+ <logicalName>Deleted By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>versionNo</columnName>
+ <logicalName>Version No.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[22]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>40</x>
+ <y>719</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections/>
+ <targetConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_group</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>group_id</columnName>
+ <logicalName>Group ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>group_mapping</tableName>
+ <logicalName>Group Mapping</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>id</columnName>
+ <logicalName>ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>INTEGER</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>false</supportSize>
+ <type>4</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>true</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>user_id</columnName>
+ <logicalName>User ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>44</x>
+ <y>40</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_user</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../../../../../../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ </sourceConnections>
+ <targetConnections/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </source>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ </targetConnections>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </target>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_user_to_role</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>role_id</columnName>
+ <logicalName>Role ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[14]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>role_info</tableName>
+ <logicalName>Role Information</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>name</columnName>
+ <logicalName>Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>description</columnName>
+ <logicalName>Description</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>email</columnName>
+ <logicalName>Email</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>url</columnName>
+ <logicalName>URL</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>telephone</columnName>
+ <logicalName>Telephone</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>40</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_time</columnName>
+ <logicalName>Created Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_by</columnName>
+ <logicalName>Created By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_time</columnName>
+ <logicalName>Updated Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_by</columnName>
+ <logicalName>Updated By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_time</columnName>
+ <logicalName>Deleted Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_by</columnName>
+ <logicalName>Deleted By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>versionNo</columnName>
+ <logicalName>Version No.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[22]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>364</x>
+ <y>719</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections/>
+ <targetConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_role</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>role_id</columnName>
+ <logicalName>Role ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>role_mapping</tableName>
+ <logicalName>Role Mapping</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>id</columnName>
+ <logicalName>ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>INT</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>false</supportSize>
+ <type>4</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>true</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>user_id</columnName>
+ <logicalName>User ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>372</x>
+ <y>40</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_user</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../../../../../../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ </sourceConnections>
+ <targetConnections/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </source>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ </targetConnections>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </target>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ </sourceConnections>
+ <targetConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel"/>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel"/>
+ </targetConnections>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.TableModel>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel/target"/>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target"/>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source"/>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source"/>
+ </children>
+ <dommains/>
+ <dialectName>MySQL</dialectName>
+ <logicalMode>false</logicalMode>
+ <jarFile></jarFile>
+ <jdbcDriver>sun.jdbc.odbc.JdbcOdbc</jdbcDriver>
+ <jdbcUrl></jdbcUrl>
+ <jdbcUser></jdbcUser>
+ <jdbcPassword></jdbcPassword>
+ <jdbcSchema></jdbcSchema>
+ <jdbcCatalog></jdbcCatalog>
+ <includeView>false</includeView>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.RootModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+</net.java.amateras.db.visual.model.RootModel>
\ No newline at end of file
Added: userinfo/trunk/src/main/config/sql/mysql/drop.sql
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/drop.sql (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/drop.sql 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,37 @@
+DROP TABLE postal;
+DROP TABLE contact;
+DROP TABLE custom;
+DROP TABLE person;
+DROP TABLE company;
+DROP TABLE message_content;
+DROP TABLE message_attachment;
+DROP TABLE reply;
+DROP TABLE category_access;
+DROP TABLE message;
+DROP TABLE attachment;
+DROP TABLE category;
+DROP TABLE bookmark_link;
+DROP TABLE bookmark_category;
+DROP TABLE notepad_content;
+DROP TABLE notepad;
+DROP TABLE notepad_category;
+DROP TABLE facility_schedule_mapping;
+DROP TABLE facility_content;
+DROP TABLE facility;
+DROP TABLE facility_group;
+DROP TABLE event_schedule_content;
+DROP TABLE event_schedule_mapping;
+DROP TABLE event_schedule;
+DROP TABLE monthly_working_report;
+DROP TABLE working_type;
+DROP TABLE daily_report;
+DROP TABLE monthly_report;
+DROP TABLE employee;
+DROP TABLE todo_mapping;
+DROP TABLE todo_category;
+DROP TABLE todo;
+DROP TABLE role_mapping;
+DROP TABLE group_mapping;
+DROP TABLE user_info;
+DROP TABLE role_info;
+DROP TABLE group_info;
Added: userinfo/trunk/src/main/config/sql/mysql/others/0-userinfo.dml
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/0-userinfo.dml (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/0-userinfo.dml 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,2 @@
+insert into user_info (user_id, created_time, created_by, updated_time, updated_by, versionno) values ('admin', '2008-10-15 17:17:37', 'admin', '2008-10-15 17:17:37', 'admin', 0);
+
Added: userinfo/trunk/src/main/config/sql/mysql/others/addresslist.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/addresslist.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/addresslist.ddl 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,95 @@
+/**********************************
+Table Name: Company
+**********************************/
+CREATE TABLE company(
+ id BIGINT(19) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ user_id VARCHAR(255),
+ name VARCHAR(200),
+ name_desc VARCHAR(200),
+ department VARCHAR(200),
+ building VARCHAR(200),
+ street VARCHAR(200),
+ city VARCHAR(100),
+ state VARCHAR(100),
+ postal_code VARCHAR(30),
+ country VARCHAR(200),
+ telephone1 VARCHAR(40),
+ telephone2 VARCHAR(40),
+ fax1 VARCHAR(40),
+ fax2 VARCHAR(40),
+ url VARCHAR(255),
+ is_public VARCHAR(1) DEFAULT 'T',
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 1,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: Person
+**********************************/
+CREATE TABLE person(
+ id BIGINT(19) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ user_id VARCHAR(255),
+ given_name VARCHAR(100),
+ given_name_desc VARCHAR(100),
+ family_name VARCHAR(100),
+ family_name_desc VARCHAR(100),
+ middle_name VARCHAR(50),
+ name_prefix VARCHAR(30),
+ name_suffix VARCHAR(30),
+ nickname VARCHAR(100),
+ job_title VARCHAR(50),
+ is_public VARCHAR(1) DEFAULT 'T',
+ company_id BIGINT(19),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 1,
+ FOREIGN KEY (company_id) REFERENCES company (id),
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: Custom
+**********************************/
+CREATE TABLE custom(
+ id BIGINT(19) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ person_id BIGINT(19) NOT NULL,
+ value VARCHAR(255),
+ sort_order INTEGER NOT NULL,
+ FOREIGN KEY (person_id) REFERENCES person (id)
+);
+
+/**********************************
+Table Name: Contact
+**********************************/
+CREATE TABLE contact(
+ id BIGINT(19) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ person_id BIGINT(19) NOT NULL,
+ name VARCHAR(20) NOT NULL,
+ value VARCHAR(255),
+ FOREIGN KEY (person_id) REFERENCES person (id)
+);
+
+/**********************************
+Table Name: Postal
+**********************************/
+CREATE TABLE postal(
+ person_id BIGINT(19) NOT NULL PRIMARY KEY,
+ building VARCHAR(200),
+ street VARCHAR(200),
+ city VARCHAR(100),
+ state VARCHAR(100),
+ postal_code VARCHAR(30),
+ country VARCHAR(100),
+ FOREIGN KEY (person_id) REFERENCES person (id)
+);
+
Added: userinfo/trunk/src/main/config/sql/mysql/others/board.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/board.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/board.ddl 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,115 @@
+/**********************************
+Table Name: Category
+**********************************/
+CREATE TABLE category(
+ id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ sort_order INTEGER NOT NULL DEFAULT 0,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0
+);
+
+/**********************************
+Table Name: Attachment
+**********************************/
+CREATE TABLE attachment(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ data MEDIUMBLOB NOT NULL,
+ name VARCHAR(255),
+ size INTEGER,
+ content_type VARCHAR(40),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL
+);
+
+/**********************************
+Table Name: Message
+**********************************/
+CREATE TABLE message(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ display_name VARCHAR(100) NOT NULL,
+ title VARCHAR(200) NOT NULL,
+ status VARCHAR(1) NOT NULL DEFAULT 'E',
+ start_time DATETIME,
+ end_time DATETIME,
+ has_reply VARCHAR(1) NOT NULL DEFAULT 'T',
+ category_id INTEGER NOT NULL DEFAULT 0,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (category_id) REFERENCES category (id)
+);
+
+/**********************************
+Table Name: Category Access
+**********************************/
+CREATE TABLE category_access(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(255) NOT NULL,
+ access_type INTEGER NOT NULL,
+ category_id INTEGER NOT NULL,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ versionNo INT NOT NULL DEFAULT 0,
+ FOREIGN KEY (category_id) REFERENCES category (id)
+);
+
+/**********************************
+Table Name: Reply
+**********************************/
+CREATE TABLE reply(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ display_name VARCHAR(100) NOT NULL,
+ content VARCHAR(4000),
+ message_id BIGINT(20) NOT NULL,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ FOREIGN KEY (message_id) REFERENCES message (id)
+);
+
+/**********************************
+Table Name: Message Attachment
+**********************************/
+CREATE TABLE message_attachment(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ memo VARCHAR(100),
+ versionable VARCHAR(1) NOT NULL DEFAULT 'F',
+ message_id BIGINT(20) NOT NULL,
+ attachment_id BIGINT(20) NOT NULL,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (message_id) REFERENCES message (id),
+ FOREIGN KEY (attachment_id) REFERENCES attachment (id)
+);
+
+/**********************************
+Table Name: Message Content
+**********************************/
+CREATE TABLE message_content(
+ message_id BIGINT(20) NOT NULL PRIMARY KEY,
+ content VARCHAR(4000),
+ FOREIGN KEY (message_id) REFERENCES message (id)
+);
+
+CREATE INDEX IDX_title_for_message ON message (title);
+
+CREATE INDEX IDX_content_for_message_content ON message_content (content);
+
Added: userinfo/trunk/src/main/config/sql/mysql/others/board.dml
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/board.dml (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/board.dml 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,4 @@
+insert into category (id, name, created_time, created_by, sort_order, updated_time, updated_by, versionno) values (1, 'TOP', '2008-10-06 16:17:41', 'admin', 1, '2008-10-06 16:17:41', 'admin', 0);
+insert into category_access (id, name, created_time, created_by, updated_time, updated_by, versionno, access_type, category_id) values (1, 'role::user', '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0, 4, 1);
+
+
Added: userinfo/trunk/src/main/config/sql/mysql/others/bookmark.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/bookmark.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/bookmark.ddl 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,48 @@
+/**********************************
+Table Name: Bookmark Category
+**********************************/
+CREATE TABLE bookmark_category(
+ id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ memo VARCHAR(200),
+ type VARCHAR(1) NOT NULL DEFAULT 'P',
+ sort_order INTEGER NOT NULL DEFAULT 0,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (created_by) REFERENCES user_info (user_id),
+ FOREIGN KEY (updated_by) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: Bookmark Link
+**********************************/
+CREATE TABLE bookmark_link(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ memo VARCHAR(200),
+ url VARCHAR(255) NOT NULL DEFAULT 'E',
+ type VARCHAR(1) NOT NULL,
+ sort_order INTEGER NOT NULL DEFAULT 0,
+ category_id INTEGER DEFAULT 0,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (category_id) REFERENCES bookmark_category (id),
+ FOREIGN KEY (created_by) REFERENCES user_info (user_id),
+ FOREIGN KEY (updated_by) REFERENCES user_info (user_id)
+);
+
+
+CREATE INDEX IDX_created_by_for_bookmark_category ON bookmark_category (created_by);
+
+CREATE INDEX IDX_created_by_and_category_id_for_link ON bookmark_link (created_by, category_id);
+
Added: userinfo/trunk/src/main/config/sql/mysql/others/bookmark.dml
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/bookmark.dml (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/bookmark.dml 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,2 @@
+insert into bookmark_category (id, name, created_time, created_by, sort_order, updated_time, updated_by, versionno, memo, type) values (1, '(Unclassified)', '2008-10-15 17:17:37', 'admin', 1, '2008-10-15 17:17:37', 'admin', 0, '', 'P');
+insert into bookmark_category (id, name, created_time, created_by, sort_order, updated_time, updated_by, versionno, memo, type) values (2, '(Shared)', '2008-10-15 17:17:37', 'admin', 1, '2008-10-15 17:17:37', 'admin', 0, '', 'P');
Added: userinfo/trunk/src/main/config/sql/mysql/others/notepad.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/notepad.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/notepad.ddl 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,53 @@
+/**********************************
+Table Name: Notepad Category
+**********************************/
+CREATE TABLE notepad_category(
+ id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ type VARCHAR(1) NOT NULL DEFAULT 'P',
+ sort_order INTEGER NOT NULL DEFAULT 0,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (created_by) REFERENCES user_info (user_id),
+ FOREIGN KEY (updated_by) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: Notepad
+**********************************/
+CREATE TABLE notepad(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ title VARCHAR(100) NOT NULL,
+ sort_order INTEGER NOT NULL DEFAULT 0,
+ category_id INTEGER DEFAULT 0,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (category_id) REFERENCES notepad_category (id),
+ FOREIGN KEY (created_by) REFERENCES user_info (user_id),
+ FOREIGN KEY (updated_by) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: Notepad Content
+**********************************/
+CREATE TABLE notepad_content(
+ id BIGINT(20) NOT NULL PRIMARY KEY,
+ content VARCHAR(4000),
+ FOREIGN KEY (id) REFERENCES notepad (id)
+);
+
+
+CREATE INDEX IDX_created_by_for_notepad_category ON notepad_category (created_by);
+
+CREATE INDEX IDX_created_by_and_category_id_for_notepad ON notepad (created_by, category_id);
+
Added: userinfo/trunk/src/main/config/sql/mysql/others/notepad.dml
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/notepad.dml (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/notepad.dml 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,2 @@
+insert into notepad_category (id, name, created_time, created_by, sort_order, updated_time, updated_by, versionno, type) values (1, '(Unclassified)', '2008-10-15 17:17:37', 'admin', 1, '2008-10-15 17:17:37', 'admin', 0, 'P');
+insert into notepad_category (id, name, created_time, created_by, sort_order, updated_time, updated_by, versionno, type) values (2, '(Shared)', '2008-10-15 17:17:37', 'admin', 1, '2008-10-15 17:17:37', 'admin', 0, 'P');
Added: userinfo/trunk/src/main/config/sql/mysql/others/scheduler.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/scheduler.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/scheduler.ddl 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,96 @@
+/**********************************
+Table Name: Event Schedule
+**********************************/
+CREATE TABLE event_schedule(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ title VARCHAR(100) NOT NULL,
+ location VARCHAR(100),
+ start_date DATE NOT NULL,
+ start_time TIME,
+ end_date DATE,
+ end_time TIME,
+ secret VARCHAR(1) NOT NULL DEFAULT 'F',
+ type VARCHAR(10) NOT NULL,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL
+);
+
+/**********************************
+Table Name: Event Schedule Mapping
+**********************************/
+CREATE TABLE event_schedule_mapping(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ schedule_id BIGINT(20) NOT NULL,
+ user_id VARCHAR(255) NOT NULL,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id),
+ FOREIGN KEY (schedule_id) REFERENCES event_schedule (id)
+);
+
+/**********************************
+Table Name: Event Schedule Content
+**********************************/
+CREATE TABLE event_schedule_content(
+ id BIGINT(20) NOT NULL PRIMARY KEY,
+ content VARCHAR(1000),
+ FOREIGN KEY (id) REFERENCES event_schedule (id)
+);
+
+/**********************************
+Table Name: Facility Group
+**********************************/
+CREATE TABLE facility_group(
+ id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ sort_order INTEGER NOT NULL DEFAULT 1,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0
+);
+
+/**********************************
+Table Name: Facility
+**********************************/
+CREATE TABLE facility(
+ id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ sort_order INTEGER NOT NULL DEFAULT 1,
+ group_id INTEGER NOT NULL,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (group_id) REFERENCES facility_group (id)
+);
+
+/**********************************
+Table Name: Facility Content
+**********************************/
+CREATE TABLE facility_content(
+ id INTEGER NOT NULL PRIMARY KEY,
+ content VARCHAR(1000),
+ FOREIGN KEY (id) REFERENCES facility (id)
+);
+
+/**********************************
+Table Name: Facility Schedule Mapping
+**********************************/
+CREATE TABLE facility_schedule_mapping(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ schedule_id BIGINT(20) NOT NULL,
+ facility_id INTEGER NOT NULL,
+ FOREIGN KEY (schedule_id) REFERENCES event_schedule (id),
+ FOREIGN KEY (facility_id) REFERENCES facility (id)
+);
+
Added: userinfo/trunk/src/main/config/sql/mysql/others/timecard.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/timecard.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/timecard.ddl 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,98 @@
+/**********************************
+Table Name: Employee
+**********************************/
+CREATE TABLE employee(
+ id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ username VARCHAR(255) NOT NULL,
+ manager VARCHAR(255) NOT NULL,
+ is_available VARCHAR(1) NOT NULL DEFAULT 'T',
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (username) REFERENCES user_info (user_id),
+ FOREIGN KEY (manager) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: Monthly Report
+**********************************/
+CREATE TABLE monthly_report(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ year INTEGER NOT NULL,
+ month INTEGER NOT NULL,
+ status INTEGER NOT NULL DEFAULT 1,
+ std_working_days DOUBLE NOT NULL DEFAULT 0,
+ working_time BIGINT(20) NOT NULL DEFAULT 0,
+ std_working_time BIGINT(20) NOT NULL DEFAULT 0,
+ over_time BIGINT(20) NOT NULL DEFAULT 0,
+ mnt_over_time BIGINT(20) NOT NULL DEFAULT 0,
+ employee_id INTEGER NOT NULL,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (employee_id) REFERENCES employee (id)
+);
+
+/**********************************
+Table Name: Daily Report
+**********************************/
+CREATE TABLE daily_report(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ date INTEGER NOT NULL,
+ day_of_week INTEGER NOT NULL,
+ date_type INTEGER NOT NULL,
+ working_type INTEGER NOT NULL DEFAULT 1,
+ status INTEGER NOT NULL DEFAULT 1,
+ start_time TIME,
+ end_time TIME,
+ break_time TIME,
+ otj_time TIME,
+ working_time BIGINT(20),
+ memo VARCHAR(200),
+ monthly_report_id BIGINT(20) NOT NULL DEFAULT 0,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ versionNo INTEGER NOT NULL DEFAULT 0,
+ FOREIGN KEY (monthly_report_id) REFERENCES monthly_report (id)
+);
+
+/**********************************
+Table Name: Working Type
+**********************************/
+CREATE TABLE working_type(
+ id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ value INTEGER NOT NULL,
+ type VARCHAR(10) NOT NULL,
+ parent_id INTEGER DEFAULT 1,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL DEFAULT 0
+);
+
+/**********************************
+Table Name: Monthly Working Report
+**********************************/
+CREATE TABLE monthly_working_report(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ value DOUBLE NOT NULL,
+ monthly_report_id BIGINT(20) NOT NULL,
+ working_type_id INTEGER NOT NULL,
+ FOREIGN KEY (working_type_id) REFERENCES working_type (id),
+ FOREIGN KEY (monthly_report_id) REFERENCES monthly_report (id)
+);
+
Added: userinfo/trunk/src/main/config/sql/mysql/others/timecard.dml
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/timecard.dml (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/timecard.dml 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,21 @@
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (1, 'Work', 1, 'WORK', NULL, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (2, 'WorkOnHoliday', 2, 'WORK', NULL, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (3, 'WorkOnHolidayAm', 3, 'WORK_AM', 2, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (4, 'WorkOnHolidayPm', 4, 'WORK_PM', 2, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (5, 'Holiday', 200, 'OFF', NULL, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (6, 'DayOffWithPay', 20, 'PAIDOFF',NULL, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (7, 'AmOffWithPay', 21, 'PAIDOFF_AM', 6, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (8, 'PmOffWithPay', 22, 'PAIDOFF_PM', 6, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (9, 'BereavementLeave', 30, 'PAIDOFF', NULL, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (10, 'BereavementLeaveAm', 31, 'PAIDOFF_AM', 9, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (11, 'BereavementLeavePm', 32, 'PAIDOFF_PM', 9, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (12, 'SickLeave', 40, 'PAIDOFF', NULL, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (13, 'SickLeaveAm', 41, 'PAIDOFF_AM', 12, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (14, 'SickLeavePm', 42, 'PAIDOFF_PM', 12, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (15, 'DayOff', 100, 'OFF', NULL, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (16, 'AmOff', 101, 'OFF_AM', 15, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (17, 'PmOff', 102, 'OFF_PM', 15, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (18, 'SubstituteHoliday', 110, 'OFF', NULL, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (19, 'SubstituteHolidayAm', 111, 'OFF_AM', 18, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+insert into working_type (id, name, value, type, parent_id, created_time, created_by, updated_time, updated_by, versionno) values (20, 'SubstituteHolidayPm', 112, 'OFF_PM', 18, '2008-10-06 16:17:41', 'admin', '2008-10-06 16:17:41', 'admin', 0);
+
Added: userinfo/trunk/src/main/config/sql/mysql/others/todolist.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/others/todolist.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/others/todolist.ddl 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,60 @@
+/**********************************
+Table Name: ToDo
+**********************************/
+CREATE TABLE todo(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ description VARCHAR(200),
+ priority INTEGER NOT NULL,
+ status INTEGER NOT NULL,
+ start_date TIMESTAMP,
+ end_date TIMESTAMP,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL,
+ FOREIGN KEY (created_by) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: ToDo Category
+**********************************/
+CREATE TABLE todo_category(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ sort_order INTEGER NOT NULL DEFAULT 1,
+ user_id VARCHAR(255) NOT NULL,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: ToDo Mapping
+**********************************/
+CREATE TABLE todo_mapping(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ status INT NOT NULL,
+ memo VARCHAR(255),
+ todo_id BIGINT(20) NOT NULL,
+ user_id VARCHAR(255) NOT NULL,
+ category_id BIGINT(20),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id),
+ FOREIGN KEY (todo_id) REFERENCES todo (id),
+ FOREIGN KEY (category_id) REFERENCES todo_category (id)
+);
+
Added: userinfo/trunk/src/main/config/sql/mysql/userinfo.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/mysql/userinfo.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/mysql/userinfo.ddl 2008-12-15 13:43:27 UTC (rev 1609)
@@ -0,0 +1,96 @@
+DROP TABLE role_mapping;
+DROP TABLE group_mapping;
+DROP TABLE user_info;
+DROP TABLE role_info;
+DROP TABLE group_info;
+
+/**********************************
+Table Name: Group Information
+**********************************/
+CREATE TABLE group_info(
+ group_id VARCHAR(255) NOT NULL PRIMARY KEY,
+ name VARCHAR(100),
+ description VARCHAR(255),
+ email VARCHAR(255),
+ url VARCHAR(255),
+ telephone VARCHAR(40),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL
+);
+
+/**********************************
+Table Name: Role Information
+**********************************/
+CREATE TABLE role_info(
+ role_id VARCHAR(255) NOT NULL PRIMARY KEY,
+ name VARCHAR(100),
+ description VARCHAR(255),
+ email VARCHAR(255),
+ url VARCHAR(255),
+ telephone VARCHAR(40),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL
+);
+
+/**********************************
+Table Name: User Information
+**********************************/
+CREATE TABLE user_info(
+ user_id VARCHAR(255) NOT NULL PRIMARY KEY,
+ given_name VARCHAR(100),
+ family_name VARCHAR(100),
+ middle_name VARCHAR(50),
+ given_name_desc VARCHAR(100),
+ family_name_desc VARCHAR(100),
+ nickname VARCHAR(100),
+ gender VARCHAR(1),
+ birth_date DATE,
+ email VARCHAR(255),
+ url VARCHAR(255),
+ telephone VARCHAR(40),
+ locale VARCHAR(5),
+ role_id VARCHAR(255),
+ group_id VARCHAR(255),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL,
+ FOREIGN KEY (group_id) REFERENCES group_info (group_id),
+ FOREIGN KEY (role_id) REFERENCES role_info (role_id)
+);
+
+/**********************************
+Table Name: Group Mapping
+**********************************/
+CREATE TABLE group_mapping(
+ id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ user_id VARCHAR(255) NOT NULL,
+ group_id VARCHAR(255) NOT NULL,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id),
+ FOREIGN KEY (group_id) REFERENCES group_info (group_id)
+);
+
+/**********************************
+Table Name: Role Mapping
+**********************************/
+CREATE TABLE role_mapping(
+ id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ user_id VARCHAR(255) NOT NULL,
+ role_id VARCHAR(255) NOT NULL,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id),
+ FOREIGN KEY (role_id) REFERENCES role_info (role_id)
+);
+