svnno****@sourc*****
svnno****@sourc*****
2008年 11月 23日 (日) 10:05:51 JST
Revision: 1408
http://svn.sourceforge.jp/view?root=pal&view=rev&rev=1408
Author: shinsuke
Date: 2008-11-23 10:05:51 +0900 (Sun, 23 Nov 2008)
Log Message:
-----------
updated db.
Modified Paths:
--------------
userinfo/trunk/src/main/config/sql/others/scheduler.ddl
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
-------------- next part --------------
Modified: userinfo/trunk/src/main/config/sql/others/scheduler.ddl
===================================================================
--- userinfo/trunk/src/main/config/sql/others/scheduler.ddl 2008-11-23 00:59:49 UTC (rev 1407)
+++ userinfo/trunk/src/main/config/sql/others/scheduler.ddl 2008-11-23 01:05:51 UTC (rev 1408)
@@ -41,3 +41,57 @@
FOREIGN KEY (id) REFERENCES event_schedule (id)
);
+/**********************************
+Table Name: Facility Group
+**********************************/
+CREATE TABLE facility_group(
+ id INTEGER NOT NULL IDENTITY PRIMARY KEY,
+ name VARCHAR(100) NOT NULL,
+ sort_order INTEGER DEFAULT 1 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: Facility
+**********************************/
+CREATE TABLE facility(
+ id INTEGER NOT NULL IDENTITY PRIMARY KEY,
+ name VARCHAR(100) NOT NULL,
+ sort_order INTEGER DEFAULT 1 NOT NULL,
+ 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 DEFAULT 0 NOT NULL,
+ 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 IDENTITY PRIMARY KEY,
+ 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)
+);
+
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)