Skip to main content
summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorrescobar2011-03-01 15:38:54 -0500
committerRyan D. Brooks2011-03-01 15:38:54 -0500
commitb65415d399b26b6d910780097e12597f4033af58 (patch)
tree445d2d81fa92f6ed554c0f413b66289cdbf3a54e /plugins/org.eclipse.osee.framework.core.datastore
parent8230531ff8b01e8a6fe53da331ad63180efdc736 (diff)
downloadorg.eclipse.osee-b65415d399b26b6d910780097e12597f4033af58.tar.gz
org.eclipse.osee-b65415d399b26b6d910780097e12597f4033af58.tar.xz
org.eclipse.osee-b65415d399b26b6d910780097e12597f4033af58.zip
feature[ats_LCBBP]: Update OSEE Schema table namespaces
Diffstat (limited to 'plugins/org.eclipse.osee.framework.core.datastore')
-rw-r--r--plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml72
1 files changed, 36 insertions, 36 deletions
diff --git a/plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml b/plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml
index 8d85fc2469..bef6084cf2 100644
--- a/plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml
+++ b/plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml
@@ -17,13 +17,13 @@
<Constraint schema="OSEE" id="OSEE_ARTS__ART_TYPE_ID_FK" type="FOREIGN KEY" appliesTo="ART_TYPE_ID" deferrable="true">
<References schema="OSEE" table="OSEE_ARTIFACT_TYPE" column="ART_TYPE_ID" />
</Constraint>
- <Index id="OSEE_ARTS__ART_ID_IDX" tablespace="osee_index">
+ <Index id="OSEE_ARTS__ART_ID_IDX" tablespace="osee_data">
<AppliesTo id="ART_ID"/>
</Index>
- <Index id="OSEE_ARTS__GUID_IDX" tablespace="osee_index">
+ <Index id="OSEE_ARTS__GUID_IDX" tablespace="osee_data">
<AppliesTo id="GUID"/>
</Index>
- <Index id="OSEE_ARTS__ART_TYPE_ID_IDX" tablespace="osee_index">
+ <Index id="OSEE_ARTS__ART_TYPE_ID_IDX" tablespace="osee_data">
<AppliesTo id="ART_TYPE_ID"/>
</Index>
</Table>
@@ -34,7 +34,7 @@
<Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
<Column id="TRANSACTION_ID" type="INTEGER" />
<Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Index id="OSEE_JOIN_ART__Q_A_B_T_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_JOIN_ART__Q_A_B_T_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="QUERY_ID"/>
<AppliesTo id="ART_ID"/>
<AppliesTo id="BRANCH_ID"/>
@@ -46,7 +46,7 @@
<Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
<Column id="ID" type="INTEGER" />
<Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Index id="OSEE_JOIN_ID__Q_I_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_JOIN_ID__Q_I_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="QUERY_ID"/>
<AppliesTo id="ID"/>
</Index>
@@ -56,7 +56,7 @@
<Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
<Column id="SESSION_ID" defaultValue="not null" type="VARCHAR" limits="28" />
<Column id="TABLE_NAME" defaultValue="not null" type="VARCHAR" limits="28"/>
- <Index id="OSEE_JOIN_CLEANUP__Q_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_JOIN_CLEANUP__Q_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="QUERY_ID"/>
</Index>
</Table>
@@ -64,7 +64,7 @@
<Table name="OSEE_JOIN_CHAR_ID" schema="OSEE" tablespace="osee_data">
<Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
<Column id="ID" defaultValue="not null" type="VARCHAR" limits="4000"/>
- <Index id="OSEE_JOIN_CHAR__Q_IDX" tablespace="osee_index">
+ <Index id="OSEE_JOIN_CHAR__Q_IDX" tablespace="osee_data">
<AppliesTo id="QUERY_ID"/>
</Index>
</Table>
@@ -77,7 +77,7 @@
<Column id="IMAGE" type="BLOB" />
<Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_AR_PK" type="PRIMARY KEY" appliesTo="ART_TYPE_ID" />
<Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_G_IDX" type="UNIQUE" appliesTo="ART_TYPE_GUID" />
- <Index id="OSEE_ARTIFACT_TYPE_N_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_ARTIFACT_TYPE_N_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="NAME"/>
</Index>
</Table>
@@ -118,31 +118,31 @@
<Column id="VALUE" limits="4000" type="VARCHAR" />
<Column id="URI" limits="200" type="VARCHAR" />
<Constraint schema="OSEE" id="OSEE_ATTRIBUTE_AT_G_PK" type="PRIMARY KEY" appliesTo="ATTR_ID, GAMMA_ID" />
- <Index id="OSEE_ATTRIBUTE_ATT_IDX" tablespace="osee_index">
+ <Index id="OSEE_ATTRIBUTE_ATT_IDX" tablespace="osee_data">
<AppliesTo id="ATTR_TYPE_ID"/>
</Index>
- <Index id="OSEE_ATTRIBUTE_V_IDX" mySqlIgnore="true" tablespace="osee_index">
+ <Index id="OSEE_ATTRIBUTE_V_IDX" mySqlIgnore="true" tablespace="osee_data">
<AppliesTo id="VALUE"/>
</Index>
- <Index id="OSEE_ATTRIBUTE_AR_V_IDX" mySqlIgnore="true" tablespace="osee_index">
+ <Index id="OSEE_ATTRIBUTE_AR_V_IDX" mySqlIgnore="true" tablespace="osee_data">
<AppliesTo id="ART_ID"/>
<AppliesTo id="VALUE"/>
</Index>
- <Index id="OSEE_ATTRIBUTE_AR_G_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_ATTRIBUTE_AR_G_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="ART_ID"/>
<AppliesTo id="GAMMA_ID"/>
</Index>
- <Index id="OSEE_ATTRIBUTE_G_AT_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_ATTRIBUTE_G_AT_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="GAMMA_ID"/>
<AppliesTo id="ATTR_ID"/>
</Index>
- <Index id="OSEE_ATTRIBUTE_G_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_ATTRIBUTE_G_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="GAMMA_ID"/>
</Index>
- <Index id="OSEE_ATTRIBUTE_AT_IDX" tablespace="osee_index">
+ <Index id="OSEE_ATTRIBUTE_AT_IDX" tablespace="osee_data">
<AppliesTo id="ATTR_ID"/>
</Index>
- <Index id="OSEE_ATTRIBUTE_AR_IDX" mySqlIgnore="true" tablespace="osee_index">
+ <Index id="OSEE_ATTRIBUTE_AR_IDX" mySqlIgnore="true" tablespace="osee_data">
<AppliesTo id="ART_ID"/>
</Index>
</Table>
@@ -188,7 +188,7 @@
<Constraint schema="OSEE" id="ATTR_PROVIDER_TYPE_ID_FK" type="FOREIGN KEY" appliesTo="ATTR_PROVIDER_TYPE_ID" deferrable="true">
<References schema="OSEE" table="OSEE_ATTRIBUTE_PROVIDER_TYPE" column="ATTR_PROVIDER_TYPE_ID" />
</Constraint>
- <Index id="OSEE_ATTRIBUTE_TYPE_N_IDX" tablespace="osee_index">
+ <Index id="OSEE_ATTRIBUTE_TYPE_N_IDX" tablespace="osee_data">
<AppliesTo id="NAME"/>
</Index>
</Table>
@@ -216,14 +216,14 @@
<Constraint schema="OSEE" id="OSEE_RELATION__REL_TYPE_FK" type="FOREIGN KEY" appliesTo="REL_LINK_TYPE_ID" deferrable="true">
<References schema="OSEE" table="OSEE_RELATION_LINK_TYPE" column="REL_LINK_TYPE_ID" />
</Constraint>
- <Index id="OSEE_RELATION__R_G_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_RELATION__R_G_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="REL_LINK_ID"/>
<AppliesTo id="GAMMA_ID"/>
</Index>
- <Index id="OSEE_RELATION__A_IDX" tablespace="osee_index">
+ <Index id="OSEE_RELATION__A_IDX" tablespace="osee_data">
<AppliesTo id="A_ART_ID"/>
</Index>
- <Index id="OSEE_RELATION__B_IDX" tablespace="osee_index">
+ <Index id="OSEE_RELATION__B_IDX" tablespace="osee_data">
<AppliesTo id="B_ART_ID"/>
</Index>
</Table>
@@ -268,7 +268,7 @@
<References schema="OSEE" table="OSEE_TX_DETAILS" column="TRANSACTION_ID"" />
</Constraint>
-->
- <Index id="OSEE_BRANCH_A_IDX" tablespace="osee_index">
+ <Index id="OSEE_BRANCH_A_IDX" tablespace="osee_data">
<AppliesTo id="ARCHIVED" />
</Index>
</Table>
@@ -285,7 +285,7 @@
<Constraint schema="OSEE" id="OSEE_TXS__BRANCH_FK" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
<References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
</Constraint>
- <Index id="OSEE_TXS_B_G_C_M_T_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_TXS_B_G_C_M_T_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="BRANCH_ID"/>
<AppliesTo id="GAMMA_ID"/>
<AppliesTo id="TX_CURRENT"/>
@@ -294,7 +294,7 @@
</Index>
</Table>
- <Table name="OSEE_TXS_ARCHIVED" schema="OSEE" tablespace="osee_secondary">
+ <Table name="OSEE_TXS_ARCHIVED" schema="OSEE" tablespace="osee_archive">
<Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
<Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
<Column id="TX_CURRENT" defaultValue="not null" type="smallint" />
@@ -306,7 +306,7 @@
<Constraint schema="OSEE" id="OSEE_TXSA__BRANCH_FK" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
<References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
</Constraint>
- <Index id="OSEE_TXSA_B_G_C_M_T_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_TXSA_B_G_C_M_T_IDX" type="UNIQUE" tablespace="osee_archive">
<AppliesTo id="BRANCH_ID"/>
<AppliesTo id="GAMMA_ID"/>
<AppliesTo id="TX_CURRENT"/>
@@ -327,11 +327,11 @@
<Constraint schema="OSEE" id="BRANCH_ID_FK1" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
<References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
</Constraint>
- <Index id="OSEE_TX_DETAILS_B_TX_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_TX_DETAILS_B_TX_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="BRANCH_ID"/>
<AppliesTo id="TRANSACTION_ID" />
</Index>
- <Index id="OSEE_TX_DETAILS_TX_B_IDX" type="UNIQUE" tablespace="osee_index">
+ <Index id="OSEE_TX_DETAILS_TX_B_IDX" type="UNIQUE" tablespace="osee_data">
<AppliesTo id="TRANSACTION_ID" />
<AppliesTo id="BRANCH_ID"/>
</Index>
@@ -416,10 +416,10 @@
<Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
<Column id="CODED_TAG_ID" defaultValue="not null" type="BIGINT" />
<Constraint schema="OSEE" id="OSEE_SEARCH_TAGS__PK" type="PRIMARY KEY" appliesTo="CODED_TAG_ID, GAMMA_ID" />
- <Index id="OSEE_SEARCH_TAGS_C_IDX" tablespace="osee_index">
+ <Index id="OSEE_SEARCH_TAGS_C_IDX" tablespace="osee_data">
<AppliesTo id="CODED_TAG_ID"/>
</Index>
- <Index id="OSEE_SEARCH_TAGS_G_IDX" tablespace="osee_index">
+ <Index id="OSEE_SEARCH_TAGS_G_IDX" tablespace="osee_data">
<AppliesTo id="GAMMA_ID"/>
</Index>
</Table>
@@ -429,7 +429,7 @@
<Column id="CODED_TAG_ID" defaultValue="not null" type="BIGINT" />
<Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
<Constraint schema="OSEE" id="OSEE_JOIN_SEARCH_TAGS_Q_C_PK" type="PRIMARY KEY" appliesTo="QUERY_ID, CODED_TAG_ID" />
- <Index id="OSEE_JOIN_SEARCH_TAGS_Q_IDX" tablespace="osee_index">
+ <Index id="OSEE_JOIN_SEARCH_TAGS_Q_IDX" tablespace="osee_data">
<AppliesTo id="QUERY_ID"/>
</Index>
</Table>
@@ -499,7 +499,7 @@
<Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
<Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
<Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Index id="OSEE_JOIN_TRANSACTION_Q_IDX" tablespace="osee_index">
+ <Index id="OSEE_JOIN_TRANSACTION_Q_IDX" tablespace="osee_data">
<AppliesTo id="QUERY_ID"/>
</Index>
</Table>
@@ -530,7 +530,7 @@
<Column id="ID1" defaultValue="not null" type="BIGINT" />
<Column id="ID2" defaultValue="not null" type="BIGINT" />
<Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Index id="OSEE_JOIN_EXPORT_IMPORT_Q_IDX" tablespace="osee_index">
+ <Index id="OSEE_JOIN_EXPORT_IMPORT_Q_IDX" tablespace="osee_data">
<AppliesTo id="QUERY_ID"/>
</Index>
</Table>
@@ -568,11 +568,11 @@
<Constraint schema="OSEE" id="OSEE_IMPORT_INDEX_MAP_II_FK" type="FOREIGN KEY" appliesTo="SEQUENCE_ID" deferrable="true">
<References schema="OSEE" table="OSEE_IMPORT_MAP" column="SEQUENCE_ID" />
</Constraint>
- <Index id="OSEE_IMPORT_INDEX_MAP_IO_IDX" tablespace="osee_index">
+ <Index id="OSEE_IMPORT_INDEX_MAP_IO_IDX" tablespace="osee_data">
<AppliesTo id="SEQUENCE_ID"/>
<AppliesTo id="ORIGINAL_ID"/>
</Index>
- <Index id="OSEE_IMPORT_INDEX_MAP_IM_IDX" tablespace="osee_index">
+ <Index id="OSEE_IMPORT_INDEX_MAP_IM_IDX" tablespace="osee_data">
<AppliesTo id="SEQUENCE_ID"/>
<AppliesTo id="MAPPED_ID"/>
</Index>
@@ -611,10 +611,10 @@
<!-- __________________________________________________________ -->
<!-- Coverage Temp -->
<!-- __________________________________________________________ -->
- <Table name="OSEE_CVG_TESTUNITS">
+ <Table name="OSEE_CVG_TESTUNITS" schema="OSEE" tablespace="osee_data">
<Column id="NAME_ID" limits="8,0" type="DECIMAL" />
<Column id="NAME" limits="255" type="VARCHAR" />
- <Constraint schema="OSEE" id="CVG_NAME_ID_PK" type="UNIQUE" appliesTo="NAME_ID" />
+ <Constraint schema="OSEE" id="CVG_NAME_ID_PK" type="UNIQUE" appliesTo="NAME_ID" />
</Table>
-</TableConfig> \ No newline at end of file
+</TableConfig>

Back to the top