|
From: <sv...@de...> - 2005-05-18 16:24:56
|
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
|