[H2-commits] r1081 - humano2/trunk/core/schema/mssql

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Author: marijn
Date: 2005-05-18 12:24:51 -0400 (Wed, 18 May 2005)
New Revision: 1081

Modified:
   humano2/trunk/core/schema/mssql/mssql-1-metadata.sql
   humano2/trunk/core/schema/mssql/mssql-2-formulas.sql
   humano2/trunk/core/schema/mssql/mssql-3-view.sql
   humano2/trunk/core/schema/mssql/mssql-4-extendedAttributes.sql
   humano2/trunk/core/schema/mssql/mssql-5-rules.sql
   humano2/trunk/core/schema/mssql/mssql-6-form.sql
   humano2/trunk/core/schema/mssql/mssql-7-report.sql
   humano2/trunk/core/schema/mssql/mssql-8-folder.sql
Log:
 * Updating to be sync with pgsql model.


Modified: humano2/trunk/core/schema/mssql/mssql-1-metadata.sql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

--- humano2/trunk/core/schema/mssql/mssql-1-metadata.sql	2005-05-18 15:20=
:22 UTC (rev 1080)
+++ humano2/trunk/core/schema/mssql/mssql-1-metadata.sql	2005-05-18 16:24=
:51 UTC (rev 1081)
@@ -6,7 +6,7 @@
 -- the Free Software Foundation; either version 2 of the License, or
 -- (at your option) any later version.   =20
 --
--- $Id: pgsql-1-metadata.sql 941 2005-05-10 07:07:42Z marijn $
+-- $Id$
=20
 -- Este archivo contiene el eschema para la base de datos PostgreSQL de
 -- La meta data y sistema de Humano2.
@@ -45,7 +45,7 @@
  primary key ("id_entity")
 );
=20
-Create table "Boolean"
+Create table "boolean"
 (
 	"id_entity"	Integer		NOT NULL,
 	"displayText"	Varchar(20),		-- FIXME.
@@ -202,6 +202,14 @@
  primary key ("id_entity")
 );
=20
+Create table "version"
+(
+	"id_entity"	Integer		NOT NULL,
+	"versionItem"	Varchar(50),=09
+	"versionValue"	Varchar(50),=09
+ primary key ("id_entity")
+);
+
 /* Create Foreign Keys */
 ALTER TABLE "Boolean" 		ADD CONSTRAINT FK_Boolean_attribute 	FOREIGN KEY=
  (id_entity) REFERENCES "attribute" ("id_entity") ON DELETE CASCADE
 Alter table "dateTime"		ADD CONSTRAINT FK_dateTime_attribute 	FOREIGN KE=
Y  (id_entity) references "attribute"	("id_entity") ON DELETE CASCADE;
@@ -240,11 +248,11 @@
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (39,1,'file','file',5,'f');
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (80,1, 'option','option',3,'f');
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (81,1,'pertinence','pertinence',5,'f');
-INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (82,1,'Boolean','Boolean',5,'f');
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (82,1,'boolean','boolean',5,'f');
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (130,1,'optionGroup','optionGroup',3,'f');
 INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (149,1,'displayAttribute','displayAttribute',3,'f=
');
-
-SET IDENTITY_INSERT "entity" ON=20
+INSERT INTO "class"  ("id_entity","classType","sysName","name","parentId=
","isAbstract")  VALUES (153,1,'version','version',3,'f');
+
 INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (1,10,2,NULL,NULL);
 INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (2,10,2,NULL,NULL);
 INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (3,10,2,NULL,NULL);
@@ -378,6 +386,11 @@
 INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (150,10,39,NULL,NULL);
 INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (151,10,81,NULL,NULL);
 INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (152,10,13,NULL,NULL);
+INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (153,10,2,NULL,NULL);
+INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (154,10,8,NULL,NULL);
+INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (155,10,8,NULL,NULL);
+INSERT INTO "entity"  ("id_entity","domainId","class","delDate","status"=
)  VALUES (156,10,153,NULL,NULL);
+
 SET IDENTITY_INSERT "entity" Off
=20
 =20
@@ -416,8 +429,8 @@
 INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (53,13,'cols','=
cols',0,'t','t','f','t','f','f','f','t',null);
 INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (54,13,'rows','=
rows',0,'t','t','f','t','f','t','f','t',null);
 INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (55,13,'isHtml'=
,'isHtml',0,'f','t','f','t','f','f','f','t',null);
-INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (56,14,'From','=
From',0,'f','t','f','f','f','t','f','t',null);
-INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (57,14,'To','To=
',0,'f','t','f','f','f','f','f','t',null);
+INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (56,14,'from','=
from',0,'f','t','f','f','f','t','f','t',null);
+INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (57,14,'to','to=
',0,'f','t','f','f','f','f','f','t',null);
 INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (60,15,'groupTy=
pe','group',0,'f','t','f','f','f','t','f','t',null);
 INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (61,5,'isObliga=
tory','isObligatory',0,'f','t','f','t','f','f','f','t',null);
 INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (62,5,'isActive=
','isActive',0,'f','t','f','f','f','f','f','t',null);
@@ -457,9 +470,10 @@
 INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (137,81,'visual=
Attrib','visualAttrib',0,'f','t','f','t','f','f','f','t',null);
 INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (150,149,'xslt'=
,'xslt',0,'t','t','f','t','f','t','f','t',null);
 INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (151,149,'attTy=
peRef','attTypeRef',0,'t','t','f','t','f','f','f','t',null);
-INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (152,81,'filter=
View','filterView',0,'t','f','f','f','f','f','f','t',null);
+INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (152,81,'filter=
View','filterView',0,'f','t','f','f','f','f','f','t',null);
+INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (154,153,'versi=
onItem','versionItem',0,'t','t','f','f','f','t','t','f',null);
+INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (155,153,'versi=
onValue','versionValue',0,'t','t','f','f','f','f','f','f',null);
=20
-
 INSERT INTO "numeric"  ("id_entity","decimals","max","min","default")  V=
ALUES (17,2,NULL,0,NULL);
 INSERT INTO "numeric"  ("id_entity","decimals","max","min","default")  V=
ALUES (24,2,NULL,0,NULL);
 INSERT INTO "numeric"  ("id_entity","decimals","max","min","default")  V=
ALUES (41,2,NULL,0,NULL);
@@ -491,6 +505,8 @@
 INSERT INTO "textline"  ("id_entity","maxLength","minLength","dispSize")=
  VALUES (76,20,1,20);
 INSERT INTO "textline"  ("id_entity","maxLength","minLength","dispSize")=
  VALUES (84,20,0,20);
 INSERT INTO "textline"  ("id_entity","maxLength","minLength","dispSize")=
  VALUES (131,20,1,20);
+INSERT INTO "textline"  ("id_entity","maxLength","minLength","dispSize")=
  VALUES (154,50,1,50);
+INSERT INTO "textline"  ("id_entity","maxLength","minLength","dispSize")=
  VALUES (155,50,1,50);
=20
=20
 INSERT INTO "dateTime"  ("id_entity","format","dispHours","custom")  VAL=
UES (36,116,118,NULL);
@@ -517,16 +533,18 @@
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (20,20,5,'n:1',NULL);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (22,22,80,'n:1',NULL);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (25,128,26,'n:m',NULL);-- ok
-INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (126,127,26,'n:m',25);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (31,31,1,'n:1',NULL);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (34,34,6,'n:1',NULL);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (35,35,2,'n:1',NULL); -- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (40,40,2,'n:1',NULL);   -- ok
+INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (51,51,80,'n:1',NULL);
+INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (52,52,80,'n:1',NULL);
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (56,56,2,'n:1',NULL);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (57,57,2,'n:1',NULL);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (60,60,130,'n:1',NULL);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (70,70,5,'n:1',NULL);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (71,71,2,'n:1',NULL);-- ok
+INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (126,127,26,'n:m',25);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (127,127,6,'n:1',25);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (128,128,7,'n:1',25);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (129,129,81,'n:1',NULL);-- ok
@@ -535,24 +553,21 @@
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (137,137,5,'n:1',NULL);-- ok
 INSERT INTO "pertinence"  ("id_entity","owner","to","ratio","parentPerti=
nence")  VALUES (151,151,2,'n:1',NULL);-- ok
=20
-
 INSERT INTO "optionGroup"  ("id_entity","optionGroupName")  VALUES (132,=
'Formato fecha');
 INSERT INTO "optionGroup"  ("id_entity","optionGroupName")  VALUES (133,=
'Formato hora');
 INSERT INTO "optionGroup"  ("id_entity","optionGroupName")  VALUES (135,=
'Display');
=20
-
 INSERT INTO "choice"  ("id_entity","groupType")  VALUES (51,132);
 INSERT INTO "choice"  ("id_entity","groupType")  VALUES (52,133);
 INSERT INTO "choice"  ("id_entity","groupType")  VALUES (134,135);		-- a=
ca ? decimales
=20
-
 INSERT INTO "option"  ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption")  VALUES (116,132,'dd/mm/aaaa',NULL,'t',1);
 INSERT INTO "option"  ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption")  VALUES (117,132,'mm/dd/aaaa',NULL,'t',2);
 INSERT INTO "option"  ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption")  VALUES (118,133,'none',NULL,'t',1);
 INSERT INTO "option"  ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption")  VALUES (119,133,'hh:mm',NULL,'t',2);
 INSERT INTO "option"  ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption")  VALUES (120,133,'hh:mm:ss',NULL,'t',NULL);
=20
-INSERT INTO "displayAttribute"  ("id_entity","attTypeRef","xslt")  VALUE=
S (138,82,'Boolean');
+INSERT INTO "displayAttribute"  ("id_entity","attTypeRef","xslt")  VALUE=
S (138,82,'boolean');
 INSERT INTO "displayAttribute"  ("id_entity","attTypeRef","xslt")  VALUE=
S (139,87,'currency');
 INSERT INTO "displayAttribute"  ("id_entity","attTypeRef","xslt")  VALUE=
S (140,81,'pertinence');
 INSERT INTO "displayAttribute"  ("id_entity","attTypeRef","xslt")  VALUE=
S (141,13,'text');
@@ -590,6 +605,8 @@
=20
 INSERT INTO "file"  ("id_entity","maxsize") VALUES(150,10000000);
=20
+INSERT INTO "version" ("id_entity", "versionItem", "versionValue") VALUE=
S ('156', 'MetaData', '5.0.0');
+
 -- Agregando algunas indices para agilizar el metamodelo.
 CREATE INDEX entity_class_idx ON entity ("class");
 CREATE INDEX attribute_classid_idx ON attribute ("classId");


Property changes on: humano2/trunk/core/schema/mssql/mssql-1-metadata.sql
___________________________________________________________________
Name: svn:keywords
   + Id


Property changes on: humano2/trunk/core/schema/mssql/mssql-2-formulas.sql
___________________________________________________________________
Name: svn:keywords
   + Id


Property changes on: humano2/trunk/core/schema/mssql/mssql-3-view.sql
___________________________________________________________________
Name: svn:keywords
   + Id


Property changes on: humano2/trunk/core/schema/mssql/mssql-4-extendedAttr=
ibutes.sql
___________________________________________________________________
Name: svn:keywords
   + Id


Property changes on: humano2/trunk/core/schema/mssql/mssql-5-rules.sql
___________________________________________________________________
Name: svn:keywords
   + Id


Property changes on: humano2/trunk/core/schema/mssql/mssql-6-form.sql
___________________________________________________________________
Name: svn:keywords
   + Id


Property changes on: humano2/trunk/core/schema/mssql/mssql-7-report.sql
___________________________________________________________________
Name: svn:keywords
   + Id


Property changes on: humano2/trunk/core/schema/mssql/mssql-8-folder.sql
___________________________________________________________________
Name: svn:keywords
   + Id



