svnno****@sourc*****
svnno****@sourc*****
2008年 11月 18日 (火) 21:29:52 JST
Revision: 1371
http://svn.sourceforge.jp/view?root=pal&view=rev&rev=1371
Author: shinsuke
Date: 2008-11-18 21:29:52 +0900 (Tue, 18 Nov 2008)
Log Message:
-----------
integrated db.
Modified Paths:
--------------
userinfo/trunk/src/main/resources/jdbc.dicon
userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.1.log.db
userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.data.db
userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.index.db
Added Paths:
-----------
userinfo/trunk/README.txt
userinfo/trunk/src/main/config/sql/others/
userinfo/trunk/src/main/config/sql/others/0-userinfo.dml
userinfo/trunk/src/main/config/sql/others/addresslist.ddl
userinfo/trunk/src/main/config/sql/others/board.ddl
userinfo/trunk/src/main/config/sql/others/board.dml
userinfo/trunk/src/main/config/sql/others/bookmark.ddl
userinfo/trunk/src/main/config/sql/others/bookmark.dml
userinfo/trunk/src/main/config/sql/others/notepad.ddl
userinfo/trunk/src/main/config/sql/others/notepad.dml
userinfo/trunk/src/main/config/sql/others/scheduler.ddl
userinfo/trunk/src/main/config/sql/others/timecard.ddl
userinfo/trunk/src/main/config/sql/others/todolist.ddl
-------------- next part --------------
Added: userinfo/trunk/README.txt
===================================================================
--- userinfo/trunk/README.txt (rev 0)
+++ userinfo/trunk/README.txt 2008-11-18 12:29:52 UTC (rev 1371)
@@ -0,0 +1,7 @@
+--------
+Start DB
+--------
+
+$ cd [portal_home]/webapps/userinfo/WEB-INF/db
+$ java -jar ../lib/h2-1.0.79.jar org.h2.tools.Server &
+
Property changes on: userinfo/trunk/README.txt
___________________________________________________________________
Name: svn:eol-style
+ native
Added: userinfo/trunk/src/main/config/sql/others/0-userinfo.dml
===================================================================
--- userinfo/trunk/src/main/config/sql/others/0-userinfo.dml (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/0-userinfo.dml 2008-11-18 12:29:52 UTC (rev 1371)
@@ -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/others/addresslist.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/others/addresslist.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/addresslist.ddl 2008-11-18 12:29:52 UTC (rev 1371)
@@ -0,0 +1,95 @@
+/**********************************
+Table Name: Company
+**********************************/
+CREATE TABLE company(
+ id BIGINT(19) NOT NULL IDENTITY PRIMARY KEY,
+ 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 DEFAULT 1 NOT NULL,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: Person
+**********************************/
+CREATE TABLE person(
+ id BIGINT(19) NOT NULL IDENTITY PRIMARY KEY,
+ 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 DEFAULT 1 NOT NULL,
+ 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 IDENTITY PRIMARY KEY,
+ 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 IDENTITY PRIMARY KEY,
+ 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/others/board.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/others/board.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/board.ddl 2008-11-18 12:29:52 UTC (rev 1371)
@@ -0,0 +1,116 @@
+
+/**********************************
+Table Name: Category
+**********************************/
+CREATE TABLE category(
+ id INTEGER NOT NULL IDENTITY PRIMARY KEY,
+ name VARCHAR(100) NOT NULL,
+ sort_order INTEGER DEFAULT 0 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 DEFAULT 0 NOT NULL
+);
+
+/**********************************
+Table Name: Attachment
+**********************************/
+CREATE TABLE attachment(
+ id BIGINT(20) NOT NULL IDENTITY PRIMARY KEY,
+ data BLOB 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 IDENTITY PRIMARY KEY,
+ display_name VARCHAR(100) NOT NULL,
+ title VARCHAR(200) NOT NULL,
+ status VARCHAR(1) DEFAULT 'E' NOT NULL,
+ start_time DATETIME,
+ end_time DATETIME,
+ has_reply VARCHAR(1) DEFAULT 'T' NOT NULL,
+ category_id INTEGER DEFAULT 0 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 DEFAULT 0 NOT NULL,
+ FOREIGN KEY (category_id) REFERENCES category (id)
+);
+
+/**********************************
+Table Name: Category Access
+**********************************/
+CREATE TABLE category_access(
+ id BIGINT(20) NOT NULL IDENTITY PRIMARY KEY,
+ 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 DEFAULT 0 NOT NULL,
+ FOREIGN KEY (category_id) REFERENCES category (id)
+);
+
+/**********************************
+Table Name: Reply
+**********************************/
+CREATE TABLE reply(
+ id BIGINT(20) NOT NULL IDENTITY PRIMARY KEY,
+ 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 IDENTITY PRIMARY KEY,
+ memo VARCHAR(100),
+ versionable VARCHAR(1) DEFAULT 'F' NOT NULL,
+ 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 DEFAULT 0 NOT NULL,
+ 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/others/board.dml
===================================================================
--- userinfo/trunk/src/main/config/sql/others/board.dml (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/board.dml 2008-11-18 12:29:52 UTC (rev 1371)
@@ -0,0 +1,3 @@
+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/others/bookmark.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/others/bookmark.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/bookmark.ddl 2008-11-18 12:29:52 UTC (rev 1371)
@@ -0,0 +1,49 @@
+
+/**********************************
+Table Name: Bookmark Category
+**********************************/
+CREATE TABLE bookmark_category(
+ id INTEGER NOT NULL IDENTITY PRIMARY KEY,
+ name VARCHAR(100) NOT NULL,
+ memo VARCHAR(200),
+ type VARCHAR(1) DEFAULT 'P' NOT NULL,
+ sort_order INTEGER DEFAULT 0 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 DEFAULT 0 NOT NULL,
+ 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 IDENTITY PRIMARY KEY,
+ name VARCHAR(100) NOT NULL,
+ memo VARCHAR(200),
+ url VARCHAR(255) DEFAULT 'E' NOT NULL,
+ type VARCHAR(1) NOT NULL,
+ sort_order INTEGER DEFAULT 0 NOT NULL,
+ 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 DEFAULT 0 NOT NULL,
+ 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/others/bookmark.dml
===================================================================
--- userinfo/trunk/src/main/config/sql/others/bookmark.dml (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/bookmark.dml 2008-11-18 12:29:52 UTC (rev 1371)
@@ -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/others/notepad.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/others/notepad.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/notepad.ddl 2008-11-18 12:29:52 UTC (rev 1371)
@@ -0,0 +1,54 @@
+
+/**********************************
+Table Name: Notepad Category
+**********************************/
+CREATE TABLE notepad_category(
+ id INTEGER NOT NULL IDENTITY PRIMARY KEY,
+ name VARCHAR(100) NOT NULL,
+ type VARCHAR(1) DEFAULT 'P' NOT NULL,
+ sort_order INTEGER DEFAULT 0 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 DEFAULT 0 NOT NULL,
+ 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 IDENTITY PRIMARY KEY,
+ title VARCHAR(100) NOT NULL,
+ sort_order INTEGER DEFAULT 0 NOT NULL,
+ 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 DEFAULT 0 NOT NULL,
+ 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/others/notepad.dml
===================================================================
--- userinfo/trunk/src/main/config/sql/others/notepad.dml (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/notepad.dml 2008-11-18 12:29:52 UTC (rev 1371)
@@ -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/others/scheduler.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/others/scheduler.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/scheduler.ddl 2008-11-18 12:29:52 UTC (rev 1371)
@@ -0,0 +1,43 @@
+
+/**********************************
+Table Name: Event Schedule
+**********************************/
+CREATE TABLE event_schedule(
+ id BIGINT(20) NOT NULL IDENTITY PRIMARY KEY,
+ 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) DEFAULT 'F' NOT NULL,
+ 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 IDENTITY PRIMARY KEY,
+ 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)
+);
+
Added: userinfo/trunk/src/main/config/sql/others/timecard.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/others/timecard.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/timecard.ddl 2008-11-18 12:29:52 UTC (rev 1371)
@@ -0,0 +1,74 @@
+
+/**********************************
+Table Name: Employee
+**********************************/
+CREATE TABLE employee(
+ id INTEGER NOT NULL IDENTITY PRIMARY KEY,
+ username VARCHAR(255) NOT NULL,
+ manager VARCHAR(255) NOT NULL,
+ paid_holidays DOUBLE DEFAULT 0 NOT NULL,
+ is_available VARCHAR(1) DEFAULT 'T' 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 DEFAULT 0 NOT NULL,
+ 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 IDENTITY PRIMARY KEY,
+ year INTEGER NOT NULL,
+ month INTEGER NOT NULL,
+ status INTEGER DEFAULT 1 NOT NULL,
+ working_days DOUBLE DEFAULT 0 NOT NULL,
+ std_working_days DOUBLE DEFAULT 0 NOT NULL,
+ holidays DOUBLE DEFAULT 0 NOT NULL,
+ paid_holidays DOUBLE DEFAULT 0 NOT NULL,
+ working_time BIGINT(20) DEFAULT 0 NOT NULL,
+ std_working_time BIGINT(20) DEFAULT 0 NOT NULL,
+ over_time BIGINT(20) DEFAULT 0 NOT NULL,
+ mnt_over_time BIGINT(20) DEFAULT 0 NOT NULL,
+ 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 DEFAULT 0 NOT NULL,
+ FOREIGN KEY (employee_id) REFERENCES employee (id)
+);
+
+/**********************************
+Table Name: Daily Report
+**********************************/
+CREATE TABLE daily_report(
+ id BIGINT(20) NOT NULL IDENTITY PRIMARY KEY,
+ date INTEGER NOT NULL,
+ day_of_week INTEGER NOT NULL,
+ date_type INTEGER NOT NULL,
+ working_type INTEGER DEFAULT 1 NOT NULL,
+ status INTEGER DEFAULT 1 NOT NULL,
+ start_time TIME,
+ end_time TIME,
+ break_time TIME,
+ otj_time TIME,
+ working_time BIGINT(20),
+ memo VARCHAR(200),
+ monthly_report_id BIGINT(20) DEFAULT 0 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 INTEGER DEFAULT 0 NOT NULL,
+ FOREIGN KEY (monthly_report_id) REFERENCES monthly_report (id)
+);
+
+
Added: userinfo/trunk/src/main/config/sql/others/todolist.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/others/todolist.ddl (rev 0)
+++ userinfo/trunk/src/main/config/sql/others/todolist.ddl 2008-11-18 12:29:52 UTC (rev 1371)
@@ -0,0 +1,61 @@
+
+/**********************************
+Table Name: ToDo
+**********************************/
+CREATE TABLE todo(
+ id BIGINT(20) NOT NULL IDENTITY PRIMARY KEY,
+ 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 IDENTITY PRIMARY KEY,
+ name VARCHAR(100) NOT NULL,
+ sort_order INTEGER DEFAULT 1 NOT NULL,
+ 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 IDENTITY PRIMARY KEY,
+ 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)
+);
+
Modified: userinfo/trunk/src/main/resources/jdbc.dicon
===================================================================
--- userinfo/trunk/src/main/resources/jdbc.dicon 2008-11-18 12:22:18 UTC (rev 1370)
+++ userinfo/trunk/src/main/resources/jdbc.dicon 2008-11-18 12:29:52 UTC (rev 1371)
@@ -40,9 +40,9 @@
"org.h2.Driver"
</property>
<property name="URL">
- "jdbc:h2:file:" + container.getComponent(@java.lang.Class ＠ forName("javax.servlet.ServletContext")).getRealPath("/WEB-INF/db/userinfo")
+ "jdbc:h2:tcp://localhost:9092/userinfo"
</property>
- <!-- "jdbc:h2:tcp://localhost:9092/userinfo" -->
+ <!-- "jdbc:h2:file:" + container.getComponent(@java.lang.Class ＠ forName("javax.servlet.ServletContext")).getRealPath("/WEB-INF/db/userinfo") -->
<property name="user">"sa"</property>
<property name="password">""</property>
</component>
Modified: userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.1.log.db
===================================================================
(Binary files differ)
Modified: userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.data.db
===================================================================
(Binary files differ)
Modified: userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.index.db
===================================================================
(Binary files differ)