[pal-cvs 3949] [1684] updated db.

svnno****@sourc***** svnno****@sourc*****
2009年 1月 20日 (火) 18:01:07 JST


Revision: 1684
          http://svn.sourceforge.jp/view?root=pal&view=rev&rev=1684
Author:   shinsuke
Date:     2009-01-20 18:01:07 +0900 (Tue, 20 Jan 2009)

Log Message:
-----------
updated db.

Modified Paths:
--------------
    userinfo/trunk/src/main/config/sql/others/scheduler.ddl
    userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.data.db


-------------- next part --------------
Modified: userinfo/trunk/src/main/config/sql/others/scheduler.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/others/scheduler.ddl	2009-01-20 06:46:16 UTC (rev 1683)
+++ userinfo/trunk/src/main/config/sql/others/scheduler.ddl	2009-01-20 09:01:07 UTC (rev 1684)
@@ -1,7 +1,6 @@
-
-/**********************************
-Table Name: Event Schedule
-**********************************/
+/**********************************/
+/* Table Name: Event Schedule */
+/**********************************/
 CREATE TABLE event_schedule(
   id BIGINT(20) NOT NULL IDENTITY PRIMARY KEY,
   title VARCHAR(100) NOT NULL,
@@ -12,6 +11,7 @@
   end_time TIME,
   secret VARCHAR(1) DEFAULT 'F' NOT NULL,
   type VARCHAR(10) NOT NULL,
+  parent_id BIGINT(20),
   created_time TIMESTAMP NOT NULL,
   created_by VARCHAR(255) NOT NULL,
   updated_time TIMESTAMP NOT NULL,
@@ -21,9 +21,9 @@
   versionNo INTEGER NOT NULL
 );
 
-/**********************************
-Table Name: Event Schedule Mapping
-**********************************/
+/**********************************/
+/* Table Name: Event Schedule Mapping */
+/**********************************/
 CREATE TABLE event_schedule_mapping(
   id BIGINT(20) NOT NULL IDENTITY PRIMARY KEY,
   schedule_id BIGINT(20) NOT NULL,
@@ -32,18 +32,18 @@
   FOREIGN KEY (schedule_id) REFERENCES event_schedule (id)
 );
 
-/**********************************
-Table Name: Event Schedule Content
-**********************************/
+/**********************************/
+/* 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
-**********************************/
+/**********************************/
+/* Table Name: Facility Group */
+/**********************************/
 CREATE TABLE facility_group(
   id INTEGER NOT NULL IDENTITY PRIMARY KEY,
   name VARCHAR(100) NOT NULL,
@@ -57,9 +57,9 @@
   versionNo INTEGER DEFAULT 0 NOT NULL
 );
 
-/**********************************
-Table Name: Facility
-**********************************/
+/**********************************/
+/* Table Name: Facility */
+/**********************************/
 CREATE TABLE facility(
   id INTEGER NOT NULL IDENTITY PRIMARY KEY,
   name VARCHAR(100) NOT NULL,
@@ -75,18 +75,18 @@
   FOREIGN KEY (group_id) REFERENCES facility_group (id)
 );
 
-/**********************************
-Table Name: Facility Content
-**********************************/
+/**********************************/
+/* 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
-**********************************/
+/**********************************/
+/* Table Name: Facility Schedule Mapping */
+/**********************************/
 CREATE TABLE facility_schedule_mapping(
   id BIGINT(20) NOT NULL IDENTITY PRIMARY KEY,
   schedule_id BIGINT(20) NOT NULL,

Modified: userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.data.db
===================================================================
(Binary files differ)


pal-cvs メーリングリストの案内