Changeset 17945

Timestamp:

08/24/08 20:30:50 (3 months ago)

Author:

tincholiguori

Message:

project space properties changes

Files:

• trunk/core/db/oracle/create-scripts/versions/8.5.0/new/tables/data.sql (modified) (1 diff)
• trunk/core/db/oracle/create-scripts/versions/8.5.0/new/tables/tables.sql (modified) (1 diff)

trunk/core/db/oracle/create-scripts/versions/8.5.0/new/tables/data.sql

@@ -5971 +5971 @@
-prompt Enabling foreign key constraints for PN_NOTIFICATION_OBJECT_TYPE...
-alter table PN_NOTIFICATION_OBJECT_TYPE enable constraint NOTIFICATION_OBJECT_TYPE_FK1;
+
+prompt
+prompt Inserting combo value for project space properties
+prompt
+insert into PN_PROJECT_SPACE_META_COMBO (PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) 
+values (7, 'Deductible Expense', 'Deductible Expense');
+insert into PN_PROJECT_SPACE_META_COMBO (PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) 
+values (7, 'Current Expense', 'Current Expense');
+insert into PN_PROJECT_SPACE_META_COMBO (PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) 
+values (7, 'Capital Expense', 'Capital Expense');
+insert into PN_PROJECT_SPACE_META_COMBO (PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) 
+values (6, 'Marketing', 'Marketing');
+insert into PN_PROJECT_SPACE_META_COMBO (PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) 
+values (6, 'Manufacturing', 'Manufacturing');
+insert into PN_PROJECT_SPACE_META_COMBO (PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) 
+values (6, 'Administration', 'Administration');
+insert into PN_PROJECT_SPACE_META_COMBO (PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) 
+values (6, 'Services', 'Services');
+insert into PN_PROJECT_SPACE_META_COMBO (PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) 
+values (6, 'Sales', 'Sales');
+insert into PN_PROJECT_SPACE_META_COMBO (PROPERTY_ID, COMBO_VALUE, COMBO_LABEL) 
+values (6, 'RD', 'RD');
-
-prompt 

trunk/core/db/oracle/create-scripts/versions/8.5.0/new/tables/tables.sql

@@ -7212 +7212 @@
-create index TIMELOG_IDX2 on PN_TIMELOG (OBJECT_ID) TABLESPACE INDEX01;
-
+prompt
+prompt Creating table PN_PROJECT_SPACE_META_COMBO
+prompt ======================================
+prompt
+create table PN_PROJECT_SPACE_META_COMBO
+(       
+        PROPERTY_ID             NUMBER(3) not null,
+        COMBO_VALUE     VARCHAR2(500) not null,
+        COMBO_LABEL     VARCHAR2(500) not null
+) ;
+
+alter table PN_PROJECT_SPACE_META_COMBO
+  add constraint PN_PROJECT_SPACE_META_COMBO_PK primary key (PROPERTY_ID, COMBO_VALUE);