Menu
▾
▴
[H2-commits] r1082 - humano2/trunk/core/schema/mssql
|
From: <sv...@de...> - 2005-05-18 16:58:29
|
Author: marcelo
Date: 2005-05-18 12:58:10 -0400 (Wed, 18 May 2005)
New Revision: 1082
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:
* Updated the MsSQl schema, replaced char(1) to BIT so that the c# code=
Convert.ToBoolean does not crash.=20
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 16:24=
:51 UTC (rev 1081)
+++ humano2/trunk/core/schema/mssql/mssql-1-metadata.sql 2005-05-18 16:58=
:10 UTC (rev 1082)
@@ -19,16 +19,16 @@
"sysAttName" Varchar(50) NOT NULL,
"attName" Varchar(50) NOT NULL,
"order" Numeric(10,2) NOT NULL DEFAULT 0,
- "isObligatory" char(1) NOT NULL DEFAULT 'f', -- No se puede crear si e=
sto es true, pero el attributo no esta definido
- "isActive" char(1) NOT NULL DEFAULT 't', -- Es activo (=3D habilitado)=
en el definicion del class
- "isSearchable" char(1) NOT NULL DEFAULT 't', -- Se debe habilitar para=
full-text search.=20
- "isEditable" char(1) NOT NULL DEFAULT 't', -- Si se puede editar una v=
ez creado.
- "isSelfLookup" char(1) NOT NULL DEFAULT 'f', -- Para si este attributo=
tiene la posibilidad de hacer un drilldown.
- "isPrimary" char(1) NOT NULL DEFAULT 'f', -- Si es llave primaria (UNI=
QUE, NOT NULL)
- "isUnique" char(1) NOT NULL DEFAULT 'f', -- Si es el valor del attribu=
to es unico en la class.
- "isVirtual" char(1) NOT NULL DEFAULT 'f', -- Si el atributo es virtual=
no genera una columna
+ "isObligatory" Bit NOT NULL DEFAULT 0, -- No se puede crear si esto es=
true, pero el attributo no esta definido
+ "isActive" Bit NOT NULL DEFAULT 1, -- Es activo (=3D habilitado) en el=
definicion del class
+ "isSearchable" Bit NOT NULL DEFAULT 1, -- Se debe habilitar para full-=
text search.=20
+ "isEditable" Bit NOT NULL DEFAULT 1, -- Si se puede editar una vez cre=
ado.
+ "isSelfLookup" Bit NOT NULL DEFAULT 0, -- Para si este attributo tiene=
la posibilidad de hacer un drilldown.
+ "isPrimary" Bit NOT NULL DEFAULT 0, -- Si es llave primaria (UNIQUE, N=
OT NULL)
+ "isUnique" Bit NOT NULL DEFAULT 0, -- Si es el valor del attributo es =
unico en la class.
+ "isVirtual" Bit NOT NULL DEFAULT 0, -- Si el atributo es virtual no ge=
nera una columna
"descAtt" text, -- Descripcion del attributo.
- "protection" char(1) NOT NULL DEFAULT 'f', -- Para que no se puede bo=
rrar a nivel del builder (=3D anti-condoro)
+ "protection" Bit NOT NULL DEFAULT 0, -- Para que no se puede borrar a=
nivel del builder (=3D anti-condoro)
"display" Integer,
primary key ("id_entity")
);
@@ -40,12 +40,12 @@
"group" Integer NOT NULL, -- Grupo de opciones a la que pertenece la=
opcion
"value" Varchar(50) NOT NULL,
"parent" Integer, -- Para relaciones entre opciones, Region, Comuna.
- "isActiveOption" char(1) not null default 't', -- Si es activo.
+ "isActiveOption" Bit not null default 1, -- Si es activo.
"orderOption" Numeric(10,2),
primary key ("id_entity")
);
=20
-Create table "boolean"
+Create table "Boolean"
(
"id_entity" Integer NOT NULL,
"displayText" Varchar(20), -- FIXME.
@@ -61,8 +61,8 @@
"sysName" Varchar(50) NOT NULL, -- Nombre de la tabla en la BD
"name" Varchar(50) NOT NULL, -- Nombre explicativo, human name
"parentId" Integer, -- Clase padre, de la cual se hereda.
- "isAbstract" char(1) NOT NULL default 'f', -- significa que no se pued=
e instanciar solo (como entity)
- "isHidden" char(1) NOT NULL default 'f', -- significa que el class no =
es visible al usuario.=09
+ "isAbstract" Bit NOT NULL default 0, -- significa que no se puede inst=
anciar solo (como entity)
+ "isHidden" Bit NOT NULL default 0, -- significa que el class no es vis=
ible al usuario.=09
"descClass" text,
primary key ("id_entity")
);
@@ -110,7 +110,7 @@
"maxsize" integer NOT NULL, -- Tamano maximo para subir en Kilobytes.
"path" Varchar(50), -- Ubicacion en el sistema de archivos.
"extensions" Varchar(50), -- Extenciones de archivos permitidos.
- "link" char(1), -- FIXME
+ "link" Bit, -- FIXME
primary key ("id_entity")
);
=20
@@ -157,7 +157,7 @@
"id_entity" Integer NOT NULL,
"rows" Integer NOT NULL, -- Numero of rows for the TextArea
"cols" Integer NOT NULL, -- Numero of columns for the TextArea
- "isHtml" char(1) NOT NULL DEFAULT 'f',
+ "isHtml" Bit NOT NULL DEFAULT 0,
primary key ("id_entity")
);
=20
@@ -232,27 +232,28 @@
INSERT INTO "classType" ("id_entity","sysClassTypeName","parentClassTyp=
e") VALUES (27,'component',NULL);
INSERT INTO "classType" ("id_entity","sysClassTypeName","parentClassTyp=
e") VALUES (29,'solutionData',NULL);
=20
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (1,1, 'classType','classType',3,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (2,1, 'class','class',3,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (3,1, 'entity','entity',NULL,'t');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (5,1, 'attribute','attribute',3,'t');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (6,27, 'domain','domain',3,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (7,27, 'user','user',3,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (8,1, 'textline','textline',5,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (9,1, 'numeric','numeric',5,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (12,1,'dateTime','dateTime',5,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (13,1,'text','text',5,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (14,1,'inheritance','inheritance',5,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (15,1,'choice','choice',81,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (26,27,'user_domain','user_domain',3,'f');
-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 (130,1,'optionGroup','optionGroup',3,'f');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (149,1,'displayAttribute','displayAttribute',3,'f=
');
-INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (153,1,'version','version',3,'f');
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (1,1, 'classType','classType',3,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (2,1, 'class','class',3,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (3,1, 'entity','entity',NULL,1);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (5,1, 'attribute','attribute',3,1);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (6,27, 'domain','domain',3,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (7,27, 'user','user',3,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (8,1, 'textline','textline',5,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (9,1, 'numeric','numeric',5,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (12,1,'dateTime','dateTime',5,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (13,1,'text','text',5,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (14,1,'inheritance','inheritance',5,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (15,1,'choice','choice',81,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (26,27,'user_domain','user_domain',3,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (39,1,'file','file',5,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (80,1, 'option','option',3,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (81,1,'pertinence','pertinence',5,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (82,1,'Boolean','Boolean',5,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (130,1,'optionGroup','optionGroup',3,0);
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (149,1,'displayAttribute','displayAttribute',3,0)=
;
+INSERT INTO "class" ("id_entity","classType","sysName","name","parentId=
","isAbstract") VALUES (153,1,'version','version',3,0);
=20
+SET IDENTITY_INSERT "entity" ON=20
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);
@@ -390,89 +391,88 @@
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
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (4,1,'parentCla=
ssType','parentId',4,'t','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 (16,6,'domainNa=
me','name',1,'t','t','t','t','t','t','f','t',null);
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (17,6,'statusDo=
main','status',2,'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 (18,7,'email','=
email',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 (19,7,'pass','p=
ass',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 (20,80,'group',=
'group',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 (21,80,'value',=
'value',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 (22,80,'parent'=
,'parent',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 (23,80,'isActiv=
eOption','isActive',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 (24,80,'orderOp=
tion','order',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","isVirtual","protection","display") VALUES (25=
,7,'domains','domains',0,'f','t','f','f','t','f','f','t','t',null);
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (30,1,'sysClass=
TypeName','sysName',0,'t','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 (31,2,'classTyp=
e','classType',0,'t','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 (32,2,'sysName'=
,'sysName',0,'t','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 (33,2,'parentId=
','parentId',0,'t','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 (34,3,'domainId=
','domainId',0,'t','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 (35,3,'class','=
class',0,'t','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 (36,3,'delDate'=
,'delDate',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 (37,3,'status',=
'status',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 (40,5,'classId'=
,'classId',0,'t','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 (41,5,'order','=
order',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 (42,5,'attName'=
,'name',-1,'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 (43,8,'maxLengt=
h','maximum size',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 (44,8,'minLengt=
h','minimum size',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 (45,8,'defaultT=
ext','default',0,'f','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 (46,8,'dispSize=
','dispSize',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 (47,9,'decimals=
','decimals',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 (48,9,'max','ma=
x',0,'f','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 (49,9,'min','mi=
n',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 (50,9,'default'=
,'default',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 (51,12,'format'=
,'format',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 (52,12,'dispHou=
rs','dispHours',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 (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 (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);
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (63,5,'isSearch=
able','isSearchable',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 (64,5,'isEditab=
le','isEditable',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 (65,5,'isSelfLo=
okup','isSelfLookup',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 (66,2,'name','n=
ame',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 (67,5,'isPrimar=
y','isPrimary',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 (68,12,'custom'=
,'custom',0,'f','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 (69,5, 'protect=
ion','protection',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 (70,81,'owner',=
'owner',0,'t','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 (71,81,'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 (72,81,'ratio',=
'ratio',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 (76,82,'display=
Text','displayText',0,'f','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 (77,82,'numTrue=
Value','numTrueValue',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 (78,82,'numFals=
eValue','numFalseValue',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 (83,39,'maxsize=
','maxsize',1,'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 (84,39,'path','=
path',2,'f','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 (85,39,'extensi=
ons','extensions',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 (86,39,'link','=
link',4,'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 (102,2,'isAbstr=
act','isAbstract',5,'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 (103,5,'sysAttN=
ame','sysName',0,'t','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 (104,3,'createD=
ate','createDate',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 (105,3,'modDate=
','modDate',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 (106,5,'isUniqu=
e','isUnique',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 (107,5,'descAtt=
','desc',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 (108,2,'descCla=
ss','description',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 (114,5,'isVirtu=
al','isVirtual',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 (125,2,'isHidde=
n','isHidden',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","isVirtual","protection","display") VALUES (12=
6,6,'users','users',0,'f','t','f','f','t','f','f','t','t',null);
-INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (127,26,'domain=
Table','domainTable',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 (128,26,'userTa=
ble','userTable',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 (129,81,'parent=
Pertinence','parentId',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 (131,130,'optio=
nGroupName','name',0,'f','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 (134,5,'display=
','display',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 (136,15,'parent=
Choice','parent',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 (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,'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);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (4,1,'parentCla=
ssType','parentId',4,1,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (16,6,'domainNa=
me','name',1,1,1,1,1,1,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (17,6,'statusDo=
main','status',2,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (18,7,'email','=
email',0,0,1,0,0,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (19,7,'pass','p=
ass',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (20,80,'group',=
'group',0,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (21,80,'value',=
'value',0,1,1,0,1,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (22,80,'parent'=
,'parent',0,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (23,80,'isActiv=
eOption','isActive',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (24,80,'orderOp=
tion','order',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","isVirtual","protection","display") VALUES (25=
,7,'domains','domains',0,0,1,0,0,1,0,0,1,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (30,1,'sysClass=
TypeName','sysName',0,1,1,0,0,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (31,2,'classTyp=
e','classType',0,1,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (32,2,'sysName'=
,'sysName',0,1,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (33,2,'parentId=
','parentId',0,1,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (34,3,'domainId=
','domainId',0,1,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (35,3,'class','=
class',0,1,1,0,0,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (36,3,'delDate'=
,'delDate',0,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (37,3,'status',=
'status',0,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (40,5,'classId'=
,'classId',0,1,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (41,5,'order','=
order',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (42,5,'attName'=
,'name',-1,1,1,0,1,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (43,8,'maxLengt=
h','maximum size',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (44,8,'minLengt=
h','minimum size',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (45,8,'defaultT=
ext','default',0,0,1,0,1,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (46,8,'dispSize=
','dispSize',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (47,9,'decimals=
','decimals',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (48,9,'max','ma=
x',0,0,1,0,1,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (49,9,'min','mi=
n',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (50,9,'default'=
,'default',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (51,12,'format'=
,'format',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (52,12,'dispHou=
rs','dispHours',0,0,1,0,1,0,0,0,1,null);
+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,1,1,0,1,0,0,0,1,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,1,1,0,1,0,1,0,1,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,0,1,0,1,0,0,0,1,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,0,1,0,0,0,1,0,1,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,0,1,0,0,0,0,0,1,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,0,1,0,0,0,1,0,1,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,0,1,0,1,0,0,0,1,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,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (63,5,'isSearch=
able','isSearchable',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (64,5,'isEditab=
le','isEditable',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (65,5,'isSelfLo=
okup','isSelfLookup',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (66,2,'name','n=
ame',0,1,1,0,1,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (67,5,'isPrimar=
y','isPrimary',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (68,12,'custom'=
,'custom',0,0,1,0,1,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (69,5, 'protect=
ion','protection',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (70,81,'owner',=
'owner',0,1,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (71,81,'to','to=
',0,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (72,81,'ratio',=
'ratio',0,0,1,0,0,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (76,82,'display=
Text','displayText',0,0,1,0,1,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (77,82,'numTrue=
Value','numTrueValue',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (78,82,'numFals=
eValue','numFalseValue',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (83,39,'maxsize=
','maxsize',1,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (84,39,'path','=
path',2,0,1,0,1,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (85,39,'extensi=
ons','extensions',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (86,39,'link','=
link',4,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (102,2,'isAbstr=
act','isAbstract',5,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (103,5,'sysAttN=
ame','sysName',0,1,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (104,3,'createD=
ate','createDate',0,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (105,3,'modDate=
','modDate',0,1,0,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (106,5,'isUniqu=
e','isUnique',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (107,5,'descAtt=
','desc',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (108,2,'descCla=
ss','description',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (114,5,'isVirtu=
al','isVirtual',0,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (125,2,'isHidde=
n','isHidden',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","isVirtual","protection","display") VALUES (12=
6,6,'users','users',0,0,1,0,0,1,0,0,1,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (127,26,'domain=
Table','domainTable',0,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (128,26,'userTa=
ble','userTable',0,0,1,0,0,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (129,81,'parent=
Pertinence','parentId',0,0,1,0,0,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (131,130,'optio=
nGroupName','name',0,0,1,0,1,0,1,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (134,5,'display=
','display',0,0,1,0,1,0,0,0,1,null);
+INSERT INTO "attribute" ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display") VALUES (136,15,'parent=
Choice','parent',0,0,1,0,0,0,0,0,1,null);
+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,0,1,0,1,0,0,0,1,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,1,1,0,1,0,1,0,1,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,1,1,0,1,0,0,0,1,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,0,1,0,0,0,0,0,1,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,1,1,0,0,0,1,1,0,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,1,1,0,0,0,0,0,0,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);
@@ -561,13 +561,13 @@
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);
+INSERT INTO "option" ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption") VALUES (116,132,'dd/mm/aaaa',NULL,1,1);
+INSERT INTO "option" ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption") VALUES (117,132,'mm/dd/aaaa',NULL,1,2);
+INSERT INTO "option" ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption") VALUES (118,133,'none',NULL,1,1);
+INSERT INTO "option" ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption") VALUES (119,133,'hh:mm',NULL,1,2);
+INSERT INTO "option" ("id_entity","group","value","parent","isActiveOpt=
ion","orderOption") VALUES (120,133,'hh:mm:ss',NULL,1,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');
@@ -584,9 +584,9 @@
INSERT INTO "inheritance" ("id_entity","from","to") VALUES (33,2,2);
=20
=20
-INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (107,5,=
25,'f');
-INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (108,5,=
25,'f');
-INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (152,5,=
25,'f');
+INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (107,5,=
25,0);
+INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (108,5,=
25,0);
+INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (152,5,=
25,0);
=20
INSERT INTO "domain" ("id_entity","domainName","statusDomain") VALUES =
(10,'SystemDomain',NULL);
INSERT INTO "domain" ("id_entity","domainName","statusDomain") VALUES =
(122,'DefaultDomain',NULL);
@@ -610,4 +610,4 @@
-- Agregando algunas indices para agilizar el metamodelo.
CREATE INDEX entity_class_idx ON entity ("class");
CREATE INDEX attribute_classid_idx ON attribute ("classId");
-
+
Modified: humano2/trunk/core/schema/mssql/mssql-2-formulas.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-2-formulas.sql 2005-05-18 16:24=
:51 UTC (rev 1081)
+++ humano2/trunk/core/schema/mssql/mssql-2-formulas.sql 2005-05-18 16:58=
:10 UTC (rev 1082)
@@ -6,7 +6,7 @@
-- the Free Software Foundation; either version 2 of the License, or
-- (at your option) any later version. =20
--
--- $Id: pgsql-2-formulas.sql 946 2005-05-10 14:53:11Z marijn $
+-- $Id$
=20
CREATE TABLE formula (
"id_entity" integer PRIMARY KEY,
@@ -29,20 +29,20 @@
VALUES (1005, 10, 13, NULL, NULL);
INSERT INTO entity ("id_entity","domainId","class","delDate","status")
VALUES (1006, 10, 13, NULL, NULL);
-set identity_insert entity off
+set identity_insert entity off
=20
-INSERT INTO "class" VALUES (1001, 27, 'formula', 'formula', 3, 'f', 'f',=
NULL);
+INSERT INTO "class" VALUES (1001, 27, 'formula', 'formula', 3, 0, 0, NUL=
L);
=20
-INSERT INTO "attribute" VALUES (1002, 1001, 'formula', 'formula', 0.00, =
'f', 't', 'f', 't', 'f', 't', 'f', 'f', NULL, 't', 0 );
-INSERT INTO "attribute" VALUES (1003, 1001, 'attributeId', 'attributeId'=
, 0.00, 'f', 't', 'f', 'f', 'f', 'f', 'f', 'f', NULL, 't', 0 );
-INSERT INTO "attribute" VALUES (1004, 1001, 'orderFormula', 'order', 0.0=
0, 'f', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO "attribute" VALUES (1005, 1001, 'formulaName', 'name', 0.00,=
'f', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO "attribute" VALUES (1006, 1001, 'descFormula', 'desciption',=
0.00, 'f', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
+INSERT INTO "attribute" VALUES (1002, 1001, 'formula', 'formula', 0.00, =
0, 1, 0, 1, 0, 1, 0, 0, NULL, 1, 0 );
+INSERT INTO "attribute" VALUES (1003, 1001, 'attributeId', 'attributeId'=
, 0.00, 0, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0 );
+INSERT INTO "attribute" VALUES (1004, 1001, 'orderFormula', 'order', 0.0=
0, 0, 1, 0, 1, 0, 0, 0, 0, NULL, 1, 0);
+INSERT INTO "attribute" VALUES (1005, 1001, 'formulaName', 'name', 0.00,=
0, 1, 0, 1, 0, 0, 0, 0, NULL, 1, 0);
+INSERT INTO "attribute" VALUES (1006, 1001, 'descFormula', 'desciption',=
0.00, 0, 1, 0, 1, 0, 0, 0, 0, NULL, 1, 0);
=20
INSERT INTO "numeric" VALUES (1004, NULL, NULL, NULL, NULL);
=20
INSERT INTO "pertinence" VALUES (1003, 1003, 5, 'n:1', NULL, NULL,NULL);
=20
-INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1002, 5=
, 40, 'f');
-INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1005, 5=
, 25, 'f');
-INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1006, 5=
, 25, 'f');
+INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1002, 5=
, 40, 0);
+INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1005, 5=
, 25, 0);
+INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1006, 5=
, 25, 0);
Modified: humano2/trunk/core/schema/mssql/mssql-3-view.sql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D...
[truncated message content] |
