Menu
▾
▴
[H2-commits] r1083 - humano2/branches/datareader/core/schema/mssql
|
From: <sv...@de...> - 2005-05-18 17:01:51
|
Author: marcelo Date: 2005-05-18 13:01:42 -0400 (Wed, 18 May 2005) New Revision: 1083 Removed: humano2/branches/datareader/core/schema/mssql/msql-2-formulas.sql humano2/branches/datareader/core/schema/mssql/msql-3-view.sql Modified: humano2/branches/datareader/core/schema/mssql/mssql-1-metadata.sql humano2/branches/datareader/core/schema/mssql/mssql-4-extendedAttribut= es.sql humano2/branches/datareader/core/schema/mssql/mssql-5-rules.sql humano2/branches/datareader/core/schema/mssql/mssql-6-form.sql humano2/branches/datareader/core/schema/mssql/mssql-7-report.sql humano2/branches/datareader/core/schema/mssql/mssql-8-folder.sql Log: Deleted: humano2/branches/datareader/core/schema/mssql/msql-2-formulas.sq= l =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/branches/datareader/core/schema/mssql/msql-2-formulas.sql 200= 5-05-18 16:58:10 UTC (rev 1082) +++ humano2/branches/datareader/core/schema/mssql/msql-2-formulas.sql 200= 5-05-18 17:01:42 UTC (rev 1083) @@ -1,48 +0,0 @@ --- The Humano2 Business solution --- Copyright (C) 2004,5 Humano2 Chile S.A. (http://www.humano2.com) --- --- This program is free software; you can redistribute it and/or modify --- it under the terms of the GNU General Public License as published by --- 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 $ - -CREATE TABLE formula ( - "id_entity" integer PRIMARY KEY, - "formula" text, - "attributeId" integer, - "orderFormula" integer,=20 - "formulaName" text, - "descFormula" text -); -set identity_insert entity on -INSERT INTO entity ("id_entity","domainId","class","delDate","status")=20 - VALUES (1001, 10, 2, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") - VALUES (1002, 10, 13, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") - VALUES (1003, 10, 81, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") - VALUES (1004, 10, 9, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") - 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 - -INSERT INTO "class" VALUES (1001, 27, 'formula', 'formula', 3, 'f', 'f',= NULL); - -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 "numeric" VALUES (1004, NULL, NULL, NULL, NULL); - -INSERT INTO "pertinence" VALUES (1003, 1003, 5, 'n:1', NULL, NULL,NULL); - -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'); Deleted: humano2/branches/datareader/core/schema/mssql/msql-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=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/branches/datareader/core/schema/mssql/msql-3-view.sql 2005-05= -18 16:58:10 UTC (rev 1082) +++ humano2/branches/datareader/core/schema/mssql/msql-3-view.sql 2005-05= -18 17:01:42 UTC (rev 1083) @@ -1,51 +0,0 @@ --- The Humano2 Business solution --- Copyright (C) 2004,5 Humano2 Chile S.A. (http://www.humano2.com) --- --- This program is free software; you can redistribute it and/or modify --- it under the terms of the GNU General Public License as published by --- the Free Software Foundation; either version 2 of the License, or --- (at your option) any later version. =20 --- --- $Id: pgsql-3-view.sql 817 2005-05-06 00:49:38Z pcamacho $ - -CREATE TABLE "view" ( - id_entity integer PRIMARY KEY, - "columns" text, - "where" text, - "groupby" text, - "having" text, - "order" text, - "idClassView" integer, - "viewName" character varying(50) -); - -set identity_insert entity ON -INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1011, 10, 2, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1012, 10, 13, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1013, 10, 13, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1014, 10, 13, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1015, 10, 13, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1016, 10, 13, NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1017, 10, 81,NULL, NULL); -INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1018, 10, 8, NULL, NULL); -set identity_insert entity Off - -INSERT INTO "class" VALUES (1011, 27, 'view', 'view', 3, 'f', 'f', NULL)= ; - -INSERT INTO attribute VALUES (1012, 1011, 'columns', 'columns', 0.00, 'f= ', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0); -INSERT INTO attribute VALUES (1013, 1011, 'where', 'where', 0.00, 'f', '= t', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0); -INSERT INTO attribute VALUES (1014, 1011, 'groupby', 'groupby', 0.00, 'f= ', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0); -INSERT INTO attribute VALUES (1015, 1011, 'having', 'having', 0.00, 'f',= 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0); -INSERT INTO attribute VALUES (1016, 1011, 'order', 'order', 0.00, 'f', '= t', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0); -INSERT INTO attribute VALUES (1017, 1011, 'idClassView', 'class', 0.00, = 'f', 't', 'f', 'f', 'f', 'f', 'f', 'f', NULL, 't', 0); -INSERT INTO attribute VALUES (1018, 1011, 'viewName', 'name', 0.00, 'f',= 't', 'f', 't', 'f', 't', 'f', 'f', NULL, 't', 0); - -INSERT INTO pertinence VALUES (1017, 1017, 2, 'n:1', NULL, NULL, NULL); - -INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1012,5= ,25,'f'); -INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1013,5= ,25,'f'); -INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1014,5= ,25,'f'); -INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1015,5= ,25,'f'); -INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1016,5= ,25,'f'); - -INSERT INTO textline VALUES (1018, NULL, NULL, NULL, NULL); Modified: humano2/branches/datareader/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/branches/datareader/core/schema/mssql/mssql-1-metadata.sql 20= 05-05-18 16:58:10 UTC (rev 1082) +++ humano2/branches/datareader/core/schema/mssql/mssql-1-metadata.sql 20= 05-05-18 17:01:42 UTC (rev 1083) @@ -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: mssql-1-metadata.sql 1082 2005-05-18 16:58:10Z marcelo $ =20 -- Este archivo contiene el eschema para la base de datos PostgreSQL de -- La meta data y sistema de Humano2. @@ -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,7 +40,7 @@ "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") ); @@ -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 @@ -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; @@ -224,26 +232,27 @@ 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 (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); + 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); @@ -378,88 +387,93 @@ 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 -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,'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 (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"... [truncated message content] |
