Menu
▾
▴
[GeoNetwork-commit] SF.net SVN: geonetwork: [554] trunk/gast/setup
|
From: <aca...@us...> - 2007-07-05 16:42:13
|
Revision: 554
http://geonetwork.svn.sourceforge.net/geonetwork/?rev=554&view=rev
Author: acarboni
Date: 2007-07-05 09:42:15 -0700 (Thu, 05 Jul 2007)
Log Message:
-----------
Added 'Relations' table
Modified Paths:
--------------
trunk/gast/setup/database.druid
trunk/gast/setup/sql/create-db-mckoi.sql
trunk/gast/setup/sql/create-db-mysql.sql
trunk/gast/setup/sql/create-db-oracle.sql
trunk/gast/setup/sql/create-db-postgres.sql
Modified: trunk/gast/setup/database.druid
===================================================================
--- trunk/gast/setup/database.druid 2007-07-05 16:39:31 UTC (rev 553)
+++ trunk/gast/setup/database.druid 2007-07-05 16:42:15 UTC (rev 554)
@@ -2,8 +2,8 @@
<project version="2">
<attribs>
- <attrib name="build">139</attrib>
- <attrib name="serial">63004</attrib>
+ <attrib name="build">140</attrib>
+ <attrib name="serial">63301</attrib>
</attribs>
<database>
<attribs>
@@ -139,9 +139,6 @@
</list>
</sqlMapping>
</oraSql>
- <mckoiSql>
- <output>/my/work/fao/geonetwork/cvs/geonetwork/trunk/gast/setup/sql/create-db-mckoi.sql</output>
- </mckoiSql>
<pgSql>
<output>/my/work/fao/geonetwork/cvs/geonetwork/trunk/gast/setup/sql/create-db-postgres.sql</output>
<sqlMapping type="l">
@@ -157,6 +154,9 @@
</list>
</sqlMapping>
</pgSql>
+ <mckoiSql>
+ <output>/my/work/fao/geonetwork/cvs/geonetwork/trunk/gast/setup/sql/create-db-mckoi.sql</output>
+ </mckoiSql>
</SqlGenModule>
</modsConfig>
<modsUsage>
@@ -903,42 +903,42 @@
</idx>
<ts>0</ts>
</oraSql>
- <pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
- <mckoiSql>
+ </mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
+ </pgSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -1293,42 +1293,42 @@
</list>
</idx>
</oraSql>
- <mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
- <pgSql>
+ </pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
+ </mckoiSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -1445,42 +1445,42 @@
</idx>
<ts>0</ts>
</oraSql>
- <mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
- <pgSql>
+ </pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
+ </mckoiSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -1553,6 +1553,156 @@
<modsConfig/>
</field>
</table>
+ <table>
+ <vars>
+ <list>
+ <header>
+ <elem>name</elem>
+ <elem>type</elem>
+ <elem>value</elem>
+ <elem>descr</elem>
+ </header>
+ </list>
+ </vars>
+ <triggers/>
+ <rules/>
+ <attribs>
+ <attrib name="comment"/>
+ <attrib name="name">Relations</attrib>
+ <attrib name="id">63005</attrib>
+ <attrib name="schema"/>
+ <attrib name="tempPK"/>
+ <attrib name="tempFK"/>
+ <attrib name="tempOther"/>
+ <attrib name="sqlCommands"/>
+ </attribs>
+ <modsConfig>
+ <SqlGenModule>
+ <stdSql>
+ <idx type="l">
+ <list>
+ <header>
+ <elem type="i">id</elem>
+ <elem type="s">index</elem>
+ <elem type="s">name</elem>
+ </header>
+ <row>
+ <elem>61528</elem>
+ <elem>Idx1</elem>
+ <elem/>
+ </row>
+ </list>
+ </idx>
+ </stdSql>
+ <oraSql>
+ <idx type="l">
+ <list>
+ <header>
+ <elem type="i">id</elem>
+ <elem type="s">index</elem>
+ <elem type="s">name</elem>
+ <elem type="i">ts</elem>
+ <elem type="b">bitmap</elem>
+ <elem type="b">stats</elem>
+ <elem type="b">noSort</elem>
+ </header>
+ <row>
+ <elem>61528</elem>
+ <elem>Idx1</elem>
+ <elem/>
+ <elem>0</elem>
+ <elem>false</elem>
+ <elem>false</elem>
+ <elem>false</elem>
+ </row>
+ </list>
+ </idx>
+ </oraSql>
+ <pgSql>
+ <idx type="l">
+ <list>
+ <header>
+ <elem type="i">id</elem>
+ <elem type="s">index</elem>
+ <elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
+ </header>
+ <row>
+ <elem>61528</elem>
+ <elem>Idx1</elem>
+ <elem/>
+ <elem>default</elem>
+ <elem/>
+ </row>
+ </list>
+ </idx>
+ </pgSql>
+ <mckoiSql>
+ <idx type="l">
+ <list>
+ <header>
+ <elem type="i">id</elem>
+ <elem type="s">index</elem>
+ <elem type="s">name</elem>
+ </header>
+ <row>
+ <elem>61528</elem>
+ <elem>Idx1</elem>
+ <elem/>
+ </row>
+ </list>
+ </idx>
+ </mckoiSql>
+ </SqlGenModule>
+ </modsConfig>
+ <field>
+ <fieldAttribs>
+ <attribs>
+ <attrib name="54374"/>
+ <attrib name="61528">false</attrib>
+ <attrib name="17">false</attrib>
+ <attrib name="15">true</attrib>
+ <attrib name="340">false</attrib>
+ </attribs>
+ </fieldAttribs>
+ <attribs>
+ <attrib name="comment"/>
+ <attrib name="matchType">s</attrib>
+ <attrib name="refField">0</attrib>
+ <attrib name="name">id</attrib>
+ <attrib name="id">63012</attrib>
+ <attrib name="onDelete">n</attrib>
+ <attrib name="onUpdate">n</attrib>
+ <attrib name="refTable">0</attrib>
+ <attrib name="type">5</attrib>
+ </attribs>
+ <modsConfig/>
+ </field>
+ <field>
+ <fieldAttribs>
+ <attribs>
+ <attrib name="54374"/>
+ <attrib name="61528">false</attrib>
+ <attrib name="17">false</attrib>
+ <attrib name="15">true</attrib>
+ <attrib name="340">false</attrib>
+ </attribs>
+ </fieldAttribs>
+ <attribs>
+ <attrib name="comment"/>
+ <attrib name="matchType">s</attrib>
+ <attrib name="refField">0</attrib>
+ <attrib name="name">relatedId</attrib>
+ <attrib name="id">63013</attrib>
+ <attrib name="onDelete">n</attrib>
+ <attrib name="onUpdate">n</attrib>
+ <attrib name="refTable">0</attrib>
+ <attrib name="type">5</attrib>
+ </attribs>
+ <modsConfig/>
+ </field>
+ </table>
</folder>
<folder>
<attribs>
@@ -1626,42 +1776,42 @@
</idx>
<ts>0</ts>
</oraSql>
- <mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
- <pgSql>
+ </pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
+ </mckoiSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -1845,42 +1995,42 @@
</list>
</idx>
</oraSql>
- <pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
- <mckoiSql>
+ </mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
+ </pgSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -2020,42 +2170,42 @@
</idx>
<ts>0</ts>
</oraSql>
- <pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
- <mckoiSql>
+ </mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
+ </pgSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -2247,42 +2397,42 @@
</list>
</idx>
</oraSql>
- <pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
- <mckoiSql>
+ </mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
+ </pgSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -2428,42 +2578,42 @@
</idx>
<ts>0</ts>
</oraSql>
- <mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
- <pgSql>
+ </pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
+ </mckoiSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -2624,42 +2774,42 @@
</list>
</idx>
</oraSql>
- <mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
- <pgSql>
+ </pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
+ </mckoiSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -2774,42 +2924,42 @@
</list>
</idx>
</oraSql>
- <pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
- <mckoiSql>
+ </mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
+ </pgSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -2957,42 +3107,42 @@
</list>
</idx>
</oraSql>
- <mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
- <pgSql>
+ </pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
+ </mckoiSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -3107,42 +3257,42 @@
</list>
</idx>
</oraSql>
- <mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
- <pgSql>
+ </pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
+ </mckoiSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -3426,42 +3576,42 @@
</list>
</idx>
</oraSql>
- <pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
- <mckoiSql>
+ </mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
+ </pgSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -3946,42 +4096,42 @@
</idx>
<ts>0</ts>
</oraSql>
- <pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
- <mckoiSql>
+ </mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
+ </pgSql>
</SqlGenModule>
</modsConfig>
<field>
@@ -4121,42 +4271,42 @@
</idx>
<ts>0</ts>
</oraSql>
- <pgSql>
+ <mckoiSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
- <elem type="s">access</elem>
- <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
- <elem>default</elem>
- <elem/>
</row>
</list>
</idx>
- </pgSql>
- <mckoiSql>
+ </mckoiSql>
+ <pgSql>
<idx type="l">
<list>
<header>
<elem type="i">id</elem>
<elem type="s">index</elem>
<elem type="s">name</elem>
+ <elem type="s">access</elem>
+ <elem type="s">where</elem>
</header>
<row>
<elem>61528</elem>
<elem>Idx1</elem>
<elem/>
+ <elem>default</elem>
+ <elem/>
</row>
</list>
</idx>
- </mckoiSql>
+ </pgSql>
</SqlGenModule>
</modsConfig>
<field>
Modified: trunk/gast/setup/sql/create-db-mckoi.sql
===================================================================
--- trunk/gast/setup/sql/create-db-mckoi.sql 2007-07-05 16:39:31 UTC (rev 553)
+++ trunk/gast/setup/sql/create-db-mckoi.sql 2007-07-05 16:42:15 UTC (rev 554)
@@ -1,7 +1,7 @@
-- ======================================================================
-- === Sql Script for Database : Geonet
-- ===
--- === Build : 139
+-- === Build : 140
-- ======================================================================
CREATE TABLE Metadata
@@ -27,6 +27,16 @@
-- ======================================================================
+CREATE TABLE Relations
+ (
+ id int,
+ relatedId int,
+
+ primary key(id,relatedId)
+ );
+
+-- ======================================================================
+
CREATE TABLE Categories
(
id int,
Modified: trunk/gast/setup/sql/create-db-mysql.sql
===================================================================
--- trunk/gast/setup/sql/create-db-mysql.sql 2007-07-05 16:39:31 UTC (rev 553)
+++ trunk/gast/setup/sql/create-db-mysql.sql 2007-07-05 16:42:15 UTC (rev 554)
@@ -1,7 +1,7 @@
-- ======================================================================
-- === Sql Script for Database : Geonet
-- ===
--- === Build : 139
+-- === Build : 140
-- ======================================================================
CREATE TABLE Metadata
@@ -27,6 +27,16 @@
-- ======================================================================
+CREATE TABLE Relations
+ (
+ id int,
+ relatedId int,
+
+ primary key(id,relatedId)
+ );
+
+-- ======================================================================
+
CREATE TABLE Categories
(
id int,
Modified: trunk/gast/setup/sql/create-db-oracle.sql
===================================================================
--- trunk/gast/setup/sql/create-db-oracle.sql 2007-07-05 16:39:31 UTC (rev 553)
+++ trunk/gast/setup/sql/create-db-oracle.sql 2007-07-05 16:42:15 UTC (rev 554)
@@ -1,7 +1,7 @@
REM ======================================================================
REM === Sql Script for Database : Geonet
REM ===
-REM === Build : 139
+REM === Build : 140
REM ======================================================================
CREATE TABLE Metadata
@@ -26,6 +26,15 @@
REM ======================================================================
+CREATE TABLE Relations
+ (
+ id int,
+ relatedId int,
+ primary key(id,relatedId)
+ );
+
+REM ======================================================================
+
CREATE TABLE Categories
(
id int,
Modified: trunk/gast/setup/sql/create-db-postgres.sql
===================================================================
--- trunk/gast/setup/sql/create-db-postgres.sql 2007-07-05 16:39:31 UTC (rev 553)
+++ trunk/gast/setup/sql/create-db-postgres.sql 2007-07-05 16:42:15 UTC (rev 554)
@@ -1,7 +1,7 @@
-- ======================================================================
-- === Sql Script for Database : Geonet
-- ===
--- === Build : 139
+-- === Build : 140
-- ======================================================================
CREATE TABLE Metadata
@@ -27,6 +27,16 @@
-- ======================================================================
+CREATE TABLE Relations
+ (
+ id int,
+ relatedId int,
+
+ primary key(id,relatedId)
+ );
+
+-- ======================================================================
+
CREATE TABLE Categories
(
id int,
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|