Menu
▾
▴
[GeoNetwork-commit] geonetwork/setup database.druid,1.16,1.17
|
From: Roberto G. <rgi...@us...> - 2006-10-20 18:03:32
|
Update of /cvsroot/geonetwork/geonetwork/setup In directory sc8-pr-cvs2.sourceforge.net:/tmp/cvs-serv30153/setup Modified Files: database.druid Log Message: added subtemplates; not implemented yet, added now due to switch to subversion Index: database.druid =================================================================== RCS file: /cvsroot/geonetwork/geonetwork/setup/database.druid,v retrieving revision 1.16 retrieving revision 1.17 diff -C2 -d -r1.16 -r1.17 *** database.druid 15 Oct 2006 16:58:09 -0000 1.16 --- database.druid 20 Oct 2006 18:03:29 -0000 1.17 *************** *** 3,8 **** <project version="2"> <attribs> ! <attrib name="build">120</attrib> ! <attrib name="serial">60992</attrib> </attribs> <database> --- 3,8 ---- <project version="2"> <attribs> ! <attrib name="build">123</attrib> ! <attrib name="serial">61525</attrib> </attribs> <database> *************** *** 83,96 **** </list> </fieldAttribs> - <vars> - <list> - <header> - <elem>name</elem> - <elem>type</elem> - <elem>value</elem> - <elem>descr</elem> - </header> - </list> - </vars> <modsConfig> <SqlGenModule> --- 83,86 ---- *************** *** 129,135 **** </sqlMapping> </oraSql> - <mckoiSql> - <output>/my/work/fao/geonetwork/cvs/geonetwork/setup/sql/create-db-mckoi.sql</output> - </mckoiSql> <pgSql> <output>/my/work/fao/geonetwork/cvs/geonetwork/setup/sql/create-db-postgres.sql</output> --- 119,122 ---- *************** *** 147,150 **** --- 134,140 ---- </sqlMapping> </pgSql> + <mckoiSql> + <output>/my/work/fao/geonetwork/cvs/geonetwork/setup/sql/create-db-mckoi.sql</output> + </mckoiSql> </SqlGenModule> </modsConfig> *************** *** 617,621 **** <attribs> <attrib name="name">-UnNamed-</attrib> ! <attrib name="sqlCode">create unique index atai on Metadata(uuid)</attrib> </attribs> <modsConfig/> --- 607,611 ---- <attribs> <attrib name="name">-UnNamed-</attrib> ! <attrib name="sqlCode">alter table Metadata add column title varchar(255);</attrib> </attribs> <modsConfig/> *************** *** 801,805 **** <attrib name="name">Metadata</attrib> <attrib name="id">44101</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 791,794 ---- *************** *** 828,832 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">id</attrib> --- 817,820 ---- *************** *** 850,854 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">uuid</attrib> --- 838,841 ---- *************** *** 872,876 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">schemaId</attrib> --- 859,862 ---- *************** *** 894,898 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">isTemplate</attrib> --- 880,883 ---- *************** *** 926,930 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">isHarvested</attrib> --- 911,914 ---- *************** *** 948,952 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">createDate</attrib> --- 932,935 ---- *************** *** 970,974 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">changeDate</attrib> --- 953,956 ---- *************** *** 992,996 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">data</attrib> --- 974,977 ---- *************** *** 1014,1018 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">source</attrib> --- 995,998 ---- *************** *** 1036,1040 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">sourceUri</attrib> --- 1016,1019 ---- *************** *** 1047,1050 **** --- 1026,1071 ---- <modsConfig/> </field> + <field> + <fieldAttribs> + <attribs> + <attrib name="54374"/> + <attrib name="17">false</attrib> + <attrib name="15">false</attrib> + <attrib name="340">false</attrib> + </attribs> + </fieldAttribs> + <attribs> + <attrib name="comment"/> + <attrib name="refField">0</attrib> + <attrib name="name">title</attrib> + <attrib name="id">60994</attrib> + <attrib name="onDelete">n</attrib> + <attrib name="onUpdate">n</attrib> + <attrib name="refTable">0</attrib> + <attrib name="type">53372</attrib> + </attribs> + <modsConfig/> + </field> + <field> + <fieldAttribs> + <attribs> + <attrib name="54374"/> + <attrib name="17">false</attrib> + <attrib name="15">false</attrib> + <attrib name="340">false</attrib> + </attribs> + </fieldAttribs> + <attribs> + <attrib name="comment"/> + <attrib name="refField">0</attrib> + <attrib name="name">root</attrib> + <attrib name="id">61259</attrib> + <attrib name="onDelete">n</attrib> + <attrib name="onUpdate">n</attrib> + <attrib name="refTable">0</attrib> + <attrib name="type">53372</attrib> + </attribs> + <modsConfig/> + </field> </table> <table> *************** *** 1065,1069 **** <attrib name="name">MetadataCateg</attrib> <attrib name="id">54156</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1086,1089 ---- *************** *** 1083,1087 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">44102</attrib> <attrib name="name">metadataId</attrib> --- 1103,1106 ---- *************** *** 1105,1109 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">54021</attrib> <attrib name="name">categoryId</attrib> --- 1124,1127 ---- *************** *** 1134,1138 **** <attrib name="name">OperationAllowed</attrib> <attrib name="id">51311</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1152,1155 ---- *************** *** 1161,1165 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">51648</attrib> <attrib name="name">groupId</attrib> --- 1178,1181 ---- *************** *** 1183,1187 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">44102</attrib> <attrib name="name">metadataId</attrib> --- 1199,1202 ---- *************** *** 1205,1209 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">51878</attrib> <attrib name="name">operationId</attrib> --- 1220,1223 ---- *************** *** 1240,1244 **** <attrib name="name">Groups</attrib> <attrib name="id">51647</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1254,1257 ---- *************** *** 1267,1271 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">id</attrib> --- 1280,1283 ---- *************** *** 1289,1293 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">name</attrib> --- 1301,1304 ---- *************** *** 1311,1315 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">description</attrib> --- 1322,1325 ---- *************** *** 1333,1337 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">email</attrib> --- 1343,1346 ---- *************** *** 1355,1359 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">51028</attrib> <attrib name="name">referrer</attrib> --- 1364,1367 ---- *************** *** 1384,1388 **** <attrib name="name">GroupsDes</attrib> <attrib name="id">57899</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1392,1395 ---- *************** *** 1402,1406 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">51648</attrib> <attrib name="name">idDes</attrib> --- 1409,1412 ---- *************** *** 1424,1428 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">57906</attrib> <attrib name="name">langId</attrib> --- 1430,1433 ---- *************** *** 1446,1450 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">label</attrib> --- 1451,1454 ---- *************** *** 1475,1479 **** <attrib name="name">UserGroups</attrib> <attrib name="id">51752</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1479,1482 ---- *************** *** 1502,1506 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">51028</attrib> <attrib name="name">userId</attrib> --- 1505,1508 ---- *************** *** 1524,1528 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">51648</attrib> <attrib name="name">groupId</attrib> --- 1526,1529 ---- *************** *** 1559,1563 **** <attrib name="name">Categories</attrib> <attrib name="id">54017</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1560,1563 ---- *************** *** 1577,1581 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">id</attrib> --- 1577,1580 ---- *************** *** 1599,1603 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">name</attrib> --- 1598,1601 ---- *************** *** 1628,1632 **** <attrib name="name">CategoriesDes</attrib> <attrib name="id">57900</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1626,1629 ---- *************** *** 1646,1650 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">54021</attrib> <attrib name="name">idDes</attrib> --- 1643,1646 ---- *************** *** 1668,1672 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">57906</attrib> <attrib name="name">langId</attrib> --- 1664,1667 ---- *************** *** 1690,1694 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">label</attrib> --- 1685,1688 ---- *************** *** 1725,1729 **** <attrib name="name">Settings</attrib> <attrib name="id">1536</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1719,1722 ---- *************** *** 1752,1756 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">id</attrib> --- 1745,1748 ---- *************** *** 1774,1778 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">1537</attrib> <attrib name="name">parentId</attrib> --- 1766,1769 ---- *************** *** 1796,1800 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">name</attrib> --- 1787,1790 ---- *************** *** 1818,1822 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">value</attrib> --- 1808,1811 ---- *************** *** 1847,1851 **** <attrib name="name">Languages</attrib> <attrib name="id">57905</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1836,1839 ---- *************** *** 1865,1869 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">id</attrib> --- 1853,1856 ---- *************** *** 1887,1891 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">name</attrib> --- 1874,1877 ---- *************** *** 1916,1920 **** <attrib name="name">KnownNodes</attrib> <attrib name="id">57288</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 1902,1905 ---- *************** *** 1934,1938 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">siteId</attrib> --- 1919,1922 ---- *************** *** 1956,1960 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">name</attrib> --- 1940,1943 ---- *************** *** 1983,1987 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">host</attrib> --- 1966,1969 ---- *************** *** 2005,2009 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">port</attrib> --- 1987,1990 ---- *************** *** 2027,2031 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">servlet</attrib> --- 2008,2011 ---- *************** *** 2049,2053 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">icon</attrib> --- 2029,2032 ---- *************** *** 2084,2088 **** <attrib name="name">Operations</attrib> <attrib name="id">51877</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 2063,2066 ---- *************** *** 2111,2115 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">id</attrib> --- 2089,2092 ---- *************** *** 2133,2137 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">name</attrib> --- 2110,2113 ---- *************** *** 2155,2159 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">reserved</attrib> --- 2131,2134 ---- *************** *** 2175,2182 **** <elem>value</elem> <elem>descr</elem> - <elem>name</elem> - <elem>type</elem> - <elem>value</elem> - <elem>descr</elem> </header> </list> --- 2150,2153 ---- *************** *** 2188,2192 **** <attrib name="name">OperationsDes</attrib> <attrib name="id">60329</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 2159,2162 ---- *************** *** 2215,2221 **** <attribs> <attrib name="comment"/> - <attrib name="name">idDes</attrib> <attrib name="refField">51878</attrib> ! <attrib name="matchType">s</attrib> <attrib name="id">60330</attrib> <attrib name="onDelete">n</attrib> --- 2185,2190 ---- <attribs> <attrib name="comment"/> <attrib name="refField">51878</attrib> ! <attrib name="name">idDes</attrib> <attrib name="id">60330</attrib> <attrib name="onDelete">n</attrib> *************** *** 2237,2243 **** <attribs> <attrib name="comment"/> - <attrib name="name">langId</attrib> <attrib name="refField">57906</attrib> ! <attrib name="matchType">s</attrib> <attrib name="id">60331</attrib> <attrib name="onDelete">n</attrib> --- 2206,2211 ---- <attribs> <attrib name="comment"/> <attrib name="refField">57906</attrib> ! <attrib name="name">langId</attrib> <attrib name="id">60331</attrib> <attrib name="onDelete">n</attrib> *************** *** 2259,2265 **** <attribs> <attrib name="comment"/> - <attrib name="name">label</attrib> <attrib name="refField">0</attrib> ! <attrib name="matchType">s</attrib> <attrib name="id">60332</attrib> <attrib name="onDelete">n</attrib> --- 2227,2232 ---- <attribs> <attrib name="comment"/> <attrib name="refField">0</attrib> ! <attrib name="name">label</attrib> <attrib name="id">60332</attrib> <attrib name="onDelete">n</attrib> *************** *** 2294,2298 **** <attrib name="name">Regions</attrib> <attrib name="id">59071</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 2261,2264 ---- *************** *** 2312,2316 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">id</attrib> --- 2278,2281 ---- *************** *** 2334,2338 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">north</attrib> --- 2299,2302 ---- *************** *** 2356,2360 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">south</attrib> --- 2320,2323 ---- *************** *** 2378,2382 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">west</attrib> --- 2341,2344 ---- *************** *** 2400,2404 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">east</attrib> --- 2362,2365 ---- *************** *** 2429,2433 **** <attrib name="name">RegionsDes</attrib> <attrib name="id">59084</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 2390,2393 ---- *************** *** 2447,2451 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">59072</attrib> <attrib name="name">idDes</attrib> --- 2407,2410 ---- *************** *** 2469,2473 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">57906</attrib> <attrib name="name">langId</attrib> --- 2428,2431 ---- *************** *** 2491,2495 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">label</attrib> --- 2449,2452 ---- *************** *** 2526,2530 **** <attrib name="name">Users</attrib> <attrib name="id">51027</attrib> - <attrib name="schema"/> <attrib name="tempPK"/> <attrib name="tempFK"/> --- 2483,2486 ---- *************** *** 2553,2557 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">id</attrib> --- 2509,2512 ---- *************** *** 2575,2579 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">username</attrib> --- 2530,2533 ---- *************** *** 2597,2601 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">password</attrib> --- 2551,2554 ---- *************** *** 2619,2623 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">surname</attrib> --- 2572,2575 ---- *************** *** 2641,2645 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">name</attrib> --- 2593,2596 ---- *************** *** 2663,2667 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">profile</attrib> --- 2614,2617 ---- *************** *** 2685,2689 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">address</attrib> --- 2635,2638 ---- *************** *** 2707,2711 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">state</attrib> --- 2656,2659 ---- *************** *** 2729,2733 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">zip</attrib> --- 2677,2680 ---- *************** *** 2751,2755 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">country</attrib> --- 2698,2701 ---- *************** *** 2773,2777 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">email</attrib> --- 2719,2722 ---- *************** *** 2795,2799 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">organisation</attrib> --- 2740,2743 ---- *************** *** 2817,2821 **** <attribs> <attrib name="comment"/> - <attrib name="matchType">s</attrib> <attrib name="refField">0</attrib> <attrib name="name">kind</attrib> --- 2761,2764 ---- |