aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPacien TRAN-GIRARD2015-01-27 18:01:45 +0100
committerPacien TRAN-GIRARD2015-01-27 18:27:51 +0100
commitafe377a9b10b5c1b2badc74d4b9b636e7c4d0cbf (patch)
treee6808c16b8bf7b7a2cd79435706465181cbe4295
parent999d0ebce6b2f4ba39ee55daa52ca33f5fac657c (diff)
downloadminibay-afe377a9b10b5c1b2badc74d4b9b636e7c4d0cbf.tar.gz
Add E-R model and SQL bootstrap scripts
Diffstat
-rw-r--r--res/schema/minibay.dmd9
-rw-r--r--res/schema/minibay/ChangeRequests.local2
-rw-r--r--res/schema/minibay/businessinfo/Business Information.xml8
-rw-r--r--res/schema/minibay/businessinfo/Objects.local2
-rw-r--r--res/schema/minibay/datatypes/DDLSelection.local2
-rw-r--r--res/schema/minibay/datatypes/DataTypes.xml16
-rw-r--r--res/schema/minibay/datatypes/Diagrams.local4
-rw-r--r--res/schema/minibay/datatypes/Objects.local5
-rw-r--r--res/schema/minibay/datatypes/structuredtype/seg_0/47E390DE-0671-C4B1-8428-0F45CBEE18F8.xml11
-rw-r--r--res/schema/minibay/datatypes/structuredtype/seg_0/F72C39E0-D1CA-8821-2AD7-A1E95A37D3D1.xml11
-rw-r--r--res/schema/minibay/datatypes/subviews/4AA8E83E-8FAC-A475-6B57-13D01BB3E387.xml24
-rw-r--r--res/schema/minibay/dl_settings.xml324
-rw-r--r--res/schema/minibay/dmd_open.local6
-rw-r--r--res/schema/minibay/logical/Diagrams.local4
-rw-r--r--res/schema/minibay/logical/Logical.xml8
-rw-r--r--res/schema/minibay/logical/Objects.local12
-rw-r--r--res/schema/minibay/logical/entity/seg_0/3A87C5DB-E5A1-CE50-3315-E79CB15E1228.xml102
-rw-r--r--res/schema/minibay/logical/entity/seg_0/ADB5EC5D-6870-9678-9422-AAA505740C3D.xml101
-rw-r--r--res/schema/minibay/logical/entity/seg_0/D47DA6D6-F140-D137-757D-FD7E2F1B55CA.xml187
-rw-r--r--res/schema/minibay/logical/entity/seg_0/E1F3B5D8-12CA-9627-E01E-00A1D51AB53D.xml138
-rw-r--r--res/schema/minibay/logical/entity/seg_0/FB734E67-6DAD-A373-0EEF-340D8DBF48CA.xml100
-rw-r--r--res/schema/minibay/logical/relation/seg_0/1125CCDF-89CF-01D3-9666-49A7CC4CBC92.xml19
-rw-r--r--res/schema/minibay/logical/relation/seg_0/42B8135F-87F5-C085-3218-D88EFB3E6203.xml19
-rw-r--r--res/schema/minibay/logical/relation/seg_0/DC612F12-BEE0-AF2C-7503-B6E88D578157.xml20
-rw-r--r--res/schema/minibay/logical/relation/seg_0/F75CBC45-CE7F-353E-B31B-D5F43263CA20.xml19
-rw-r--r--res/schema/minibay/logical/subviews/1A00F641-9556-69A8-7292-6AA910122438.xml70
-rw-r--r--res/schema/minibay/mapping/DeletedMap_RM6F3F2070-29A1-00AF-1AD3-2218FC930021.xml3
-rw-r--r--res/schema/minibay/mapping/ExtendedMap.xml3
-rw-r--r--res/schema/minibay/mapping/ExtendedMap_RM6F3F2070-29A1-00AF-1AD3-2218FC930021.xml123
-rw-r--r--res/schema/minibay/pm/Objects.local2
-rw-r--r--res/schema/minibay/pm/Process Model.xml8
-rw-r--r--res/schema/minibay/rdbms/minibay_RDBMSSites.xml6
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021.xml8
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/DDLSelection.local2
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/Diagrams.local4
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/Objects.local12
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/foreignkey/seg_0/3ABB9634-C302-8E4C-9215-083A5E469F86.xml14
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/foreignkey/seg_0/44EE13EE-175C-E47F-87D3-5D3E8571A5EC.xml14
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/foreignkey/seg_0/709BDA5C-F4F9-4A75-3E9C-2C01D253B0D9.xml14
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/foreignkey/seg_0/89F56A68-E07C-6CD2-AB7B-24EB24E91A92.xml14
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/subviews/379DB4C6-2F45-4810-44AF-A5AA8E6D04F3.xml70
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/table/seg_0/21011472-5971-4464-1A69-2C11177EF980.xml155
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/table/seg_0/33BF4BA5-F13A-C490-06B1-9559D6D1C043.xml112
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/table/seg_0/580F4069-7399-0BCA-A3CF-27A67097B73C.xml96
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/table/seg_0/9BF011C2-2115-7B5C-9B1A-442B8B783E18.xml80
-rw-r--r--res/schema/minibay/rel/6F3F2070-2218FC930021/table/seg_0/DBA87DEA-098E-76C7-7AFC-164582BCD879.xml127
-rw-r--r--res/sql/data/orcl_bids.sql12
-rw-r--r--res/sql/data/orcl_charges.sql6
-rw-r--r--res/sql/data/orcl_items.sql10
-rw-r--r--res/sql/data/orcl_transactions.sql38
-rw-r--r--res/sql/data/orcl_users.sql13
-rw-r--r--res/sql/data/pg_bids.sql9
-rw-r--r--res/sql/data/pg_charges.sql4
-rw-r--r--res/sql/data/pg_items.sql6
-rw-r--r--res/sql/data/pg_transactions.sql38
-rw-r--r--res/sql/data/pg_users.sql12
-rw-r--r--res/sql/functions/orcl_current_datetime.sql10
-rw-r--r--res/sql/functions/orcl_gen_uuid.sql11
-rw-r--r--res/sql/functions/pg_current_datetime.sql10
-rw-r--r--res/sql/functions/pg_gen_uuid.sql9
-rw-r--r--res/sql/orcl_all.sql301
-rw-r--r--res/sql/pg_all.sql265
-rw-r--r--res/sql/tables/orcl_add_constraints_defaults.sql36
-rw-r--r--res/sql/tables/orcl_ddl.sql113
-rw-r--r--res/sql/tables/pg_add_constraints_defaults.sql26
-rw-r--r--res/sql/tables/pg_ddl.sql113
-rw-r--r--res/sql/views/orcl_accounts.sql31
-rw-r--r--res/sql/views/orcl_sales.sql49
-rw-r--r--res/sql/views/pg_accounts.sql31
-rw-r--r--res/sql/views/pg_sales.sql32
70 files changed, 3275 insertions, 0 deletions
diff --git a/res/schema/minibay.dmd b/res/schema/minibay.dmd
new file mode 100644
index 0000000..a6a3b67
--- /dev/null
+++ b/res/schema/minibay.dmd
@@ -0,0 +1,9 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<OSDM_Design class="oracle.dbtools.crest.model.design.Design" name="minibay" id="EF4FFDE4-2BC8-95B9-99BC-4441CD6E1B05" version="3.5">
3<createdBy>trangirp</createdBy>
4<createdTime>2015-01-06 16:33:26 UTC</createdTime>
5<generatorID>Généré par l&apos;utilisateur</generatorID>
6<ownerDesignName>éBé</ownerDesignName>
7<capitalNames>false</capitalNames>
8<designId>EF4FFDE4-2BC8-95B9-99BC-4441CD6E1B05</designId>
9</OSDM_Design> \ No newline at end of file
diff --git a/res/schema/minibay/ChangeRequests.local b/res/schema/minibay/ChangeRequests.local
new file mode 100644
index 0000000..a96a81e
--- /dev/null
+++ b/res/schema/minibay/ChangeRequests.local
@@ -0,0 +1,2 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<oracle.dbtools.crest.model.design.Design/> \ No newline at end of file
diff --git a/res/schema/minibay/businessinfo/Business Information.xml b/res/schema/minibay/businessinfo/Business Information.xml
new file mode 100644
index 0000000..9ee514e
--- /dev/null
+++ b/res/schema/minibay/businessinfo/Business Information.xml
@@ -0,0 +1,8 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<BusinessInfoDesign class="oracle.dbtools.crest.model.businessinfo.BusinessInfoDesign" name="Business Information" id="13E39FD5-69E0-62BF-3203-9DBC9ECC6E92">
3<createdBy>trangirp</createdBy>
4<createdTime>2015-01-06 16:33:26 UTC</createdTime>
5<generatorID>Généré par l&apos;utilisateur</generatorID>
6<ownerDesignName>éBé</ownerDesignName>
7<shouldBeOpen>false</shouldBeOpen>
8</BusinessInfoDesign> \ No newline at end of file
diff --git a/res/schema/minibay/businessinfo/Objects.local b/res/schema/minibay/businessinfo/Objects.local
new file mode 100644
index 0000000..2b5a68f
--- /dev/null
+++ b/res/schema/minibay/businessinfo/Objects.local
@@ -0,0 +1,2 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<oracle.dbtools.crest.model.businessinfo.BusinessInfoDesign/> \ No newline at end of file
diff --git a/res/schema/minibay/datatypes/DDLSelection.local b/res/schema/minibay/datatypes/DDLSelection.local
new file mode 100644
index 0000000..cd4b12c
--- /dev/null
+++ b/res/schema/minibay/datatypes/DDLSelection.local
@@ -0,0 +1,2 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<oracle.dbtools.crest.model.design.datatypes.DataTypesDesign objectID="6A200C4F-FFE6-9E1F-3FF4-D1708B284C23"/> \ No newline at end of file
diff --git a/res/schema/minibay/datatypes/DataTypes.xml b/res/schema/minibay/datatypes/DataTypes.xml
new file mode 100644
index 0000000..d4722d2
--- /dev/null
+++ b/res/schema/minibay/datatypes/DataTypes.xml
@@ -0,0 +1,16 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<DataTypesDesign class="oracle.dbtools.crest.model.design.datatypes.DataTypesDesign" name="DataTypes" id="6A200C4F-FFE6-9E1F-3FF4-D1708B284C23" mainViewID="4AA8E83E-8FAC-A475-6B57-13D01BB3E387">
3<createdBy>trangirp</createdBy>
4<createdTime>2015-01-06 16:33:26 UTC</createdTime>
5<generatorID>Généré par l&apos;utilisateur</generatorID>
6<ownerDesignName>éBé</ownerDesignName>
7<shouldBeOpen>false</shouldBeOpen>
8<collectionOfRefsPrefix>array_ref_</collectionOfRefsPrefix>
9<collectionPrefix>array_</collectionPrefix>
10<defaultArrayLimit>10</defaultArrayLimit>
11<defaultCollectionType_Kind>ARRAY</defaultCollectionType_Kind>
12<defaultCollectionType_Suffix>_Array</defaultCollectionType_Suffix>
13<embeddedStructuredTypePrefix>inst_</embeddedStructuredTypePrefix>
14<referencePrefix>ref_</referencePrefix>
15<useRoleInAssociationEndAsName>true</useRoleInAssociationEndAsName>
16</DataTypesDesign> \ No newline at end of file
diff --git a/res/schema/minibay/datatypes/Diagrams.local b/res/schema/minibay/datatypes/Diagrams.local
new file mode 100644
index 0000000..449994e
--- /dev/null
+++ b/res/schema/minibay/datatypes/Diagrams.local
@@ -0,0 +1,4 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<oracle.dbtools.crest.model.design.datatypes.DataTypesDesign>
3 <object objectType="main_view" objectID="4AA8E83E-8FAC-A475-6B57-13D01BB3E387" name="" visible="false"/>
4</oracle.dbtools.crest.model.design.datatypes.DataTypesDesign> \ No newline at end of file
diff --git a/res/schema/minibay/datatypes/Objects.local b/res/schema/minibay/datatypes/Objects.local
new file mode 100644
index 0000000..ed6e962
--- /dev/null
+++ b/res/schema/minibay/datatypes/Objects.local
@@ -0,0 +1,5 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<oracle.dbtools.crest.model.design.datatypes.DataTypesDesign>
3 <object objectType="StructuredType" objectID="F72C39E0-D1CA-8821-2AD7-A1E95A37D3D1" name="XMLTYPE" seqName="seg_0"/>
4 <object objectType="StructuredType" objectID="47E390DE-0671-C4B1-8428-0F45CBEE18F8" name="SDO_GEOMETRY" seqName="seg_0"/>
5</oracle.dbtools.crest.model.design.datatypes.DataTypesDesign> \ No newline at end of file
diff --git a/res/schema/minibay/datatypes/structuredtype/seg_0/47E390DE-0671-C4B1-8428-0F45CBEE18F8.xml b/res/schema/minibay/datatypes/structuredtype/seg_0/47E390DE-0671-C4B1-8428-0F45CBEE18F8.xml
new file mode 100644
index 0000000..c3aa9eb
--- /dev/null
+++ b/res/schema/minibay/datatypes/structuredtype/seg_0/47E390DE-0671-C4B1-8428-0F45CBEE18F8.xml
@@ -0,0 +1,11 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<StructuredType class="oracle.dbtools.crest.model.design.datatypes.StructuredType" name="SDO_GEOMETRY" directorySegmentName="seg_0" id="47E390DE-0671-C4B1-8428-0F45CBEE18F8">
3<createdBy>trangirp</createdBy>
4<createdTime>2015-01-06 16:33:26 UTC</createdTime>
5<generatorID>Généré par l&apos;utilisateur</generatorID>
6<ownerDesignName>minibay</ownerDesignName>
7<visible>false</visible>
8<predefined>true</predefined>
9<final>false</final>
10<instantiable>true</instantiable>
11</StructuredType> \ No newline at end of file
diff --git a/res/schema/minibay/datatypes/structuredtype/seg_0/F72C39E0-D1CA-8821-2AD7-A1E95A37D3D1.xml b/res/schema/minibay/datatypes/structuredtype/seg_0/F72C39E0-D1CA-8821-2AD7-A1E95A37D3D1.xml
new file mode 100644
index 0000000..085823d
--- /dev/null
+++ b/res/schema/minibay/datatypes/structuredtype/seg_0/F72C39E0-D1CA-8821-2AD7-A1E95A37D3D1.xml
@@ -0,0 +1,11 @@
1<?xml version = '1.0' encoding = 'UTF-8'?>
2<StructuredType class="oracle.dbtools.crest.model.design.datatypes.StructuredType" name="XMLTYPE" directorySegmentName="seg_0" id="F72C39E0-D1CA-8821-2AD7-A1E95A37D3D1">
3<createdBy>trangirp</createdBy>
4<createdTime>2015-01-06 16:33:26 UTC</createdTime>
5<generatorID>Généré par l&apos;utilisateur</generatorID>
6<ownerDesignName>minibay</ownerDesignName>
7<visible>false</visible>
8<predefined>true</predefined>
9<final>false</final>
10<instantiable>true</instantiable>