Menu
▾
▴
[H2-commits] r1419 - humano2/trunk/core/schema/pgsql
|
From: <sv...@de...> - 2005-06-24 19:38:53
|
Author: marcelo Date: 2005-06-24 15:38:52 -0400 (Fri, 24 Jun 2005) New Revision: 1419 Added: humano2/trunk/core/schema/pgsql/patch-pgsql-Beta6.sql humano2/trunk/core/schema/pgsql/pgsql-01-metadata.sql humano2/trunk/core/schema/pgsql/pgsql-02-formulas.sql humano2/trunk/core/schema/pgsql/pgsql-03-view.sql humano2/trunk/core/schema/pgsql/pgsql-04-extendedAttributes.sql humano2/trunk/core/schema/pgsql/pgsql-05-rules.sql humano2/trunk/core/schema/pgsql/pgsql-06-form.sql humano2/trunk/core/schema/pgsql/pgsql-07-report.sql humano2/trunk/core/schema/pgsql/pgsql-08-folder.sql humano2/trunk/core/schema/pgsql/pgsql-09-HelpDeskSMB.sql Removed: humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql humano2/trunk/core/schema/pgsql/pgsql-2-formulas.sql humano2/trunk/core/schema/pgsql/pgsql-3-view.sql humano2/trunk/core/schema/pgsql/pgsql-4-extendedAttributes.sql humano2/trunk/core/schema/pgsql/pgsql-5-rules.sql humano2/trunk/core/schema/pgsql/pgsql-6-form.sql humano2/trunk/core/schema/pgsql/pgsql-7-report.sql humano2/trunk/core/schema/pgsql/pgsql-8-folder.sql humano2/trunk/core/schema/pgsql/pgsql-9-HelpDeskSMB.sql humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql Log: * Renaming files metamodel files along with patch file so that it does n= ot get included with the initial database creation. Copied: humano2/trunk/core/schema/pgsql/patch-pgsql-Beta6.sql (from rev 1= 418, humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-01-metadata.sql (from rev 1= 418, humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-02-formulas.sql (from rev 1= 418, humano2/trunk/core/schema/pgsql/pgsql-2-formulas.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-03-view.sql (from rev 1418,= humano2/trunk/core/schema/pgsql/pgsql-3-view.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-04-extendedAttributes.sql (= from rev 1418, humano2/trunk/core/schema/pgsql/pgsql-4-extendedAttributes= .sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-05-rules.sql (from rev 1418= , humano2/trunk/core/schema/pgsql/pgsql-5-rules.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-06-form.sql (from rev 1418,= humano2/trunk/core/schema/pgsql/pgsql-6-form.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-07-report.sql (from rev 141= 8, humano2/trunk/core/schema/pgsql/pgsql-7-report.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-08-folder.sql (from rev 141= 8, humano2/trunk/core/schema/pgsql/pgsql-8-folder.sql) Copied: humano2/trunk/core/schema/pgsql/pgsql-09-HelpDeskSMB.sql (from re= v 1418, humano2/trunk/core/schema/pgsql/pgsql-9-HelpDeskSMB.sql) Deleted: humano2/trunk/core/schema/pgsql/pgsql-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/pgsql/pgsql-1-metadata.sql 2005-06-24 19:27= :13 UTC (rev 1418) +++ humano2/trunk/core/schema/pgsql/pgsql-1-metadata.sql 2005-06-24 19:38= :52 UTC (rev 1419) @@ -1,622 +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$ - --- Este archivo contiene el eschema para la base de datos PostgreSQL de --- La meta data y sistema de Humano2. - -/* Create Tables */ -Create table "attribute" -( - "id_entity" Integer NOT NULL, - "classId" Integer NOT NULL, - "sysAttName" Varchar(50) NOT NULL, - "attName" Varchar(50) NOT NULL, - "order" Numeric(10,2) NOT NULL DEFAULT 0, - "isObligatory" Boolean NOT NULL DEFAULT 'f', -- No se puede crear si e= sto es true, pero el attributo no esta definido - "isActive" Boolean NOT NULL DEFAULT 't', -- Es activo (=3D habilitado)= en el definicion del class - "isSearchable" Boolean NOT NULL DEFAULT 't', -- Se debe habilitar para= full-text search.=20 - "isEditable" Boolean NOT NULL DEFAULT 't', -- Si se puede editar una v= ez creado. - "isSelfLookup" Boolean NOT NULL DEFAULT 'f', -- Para si este attributo= tiene la posibilidad de hacer un drilldown. - "isPrimary" Boolean NOT NULL DEFAULT 'f', -- Si es llave primaria (UNI= QUE, NOT NULL) - "isUnique" Boolean NOT NULL DEFAULT 'f', -- Si es el valor del attribu= to es unico en la class. - "isVirtual" Boolean NOT NULL DEFAULT 'f', -- Si el atributo es virtual= no genera una columna - "descAtt" text, -- Descripcion del attributo. - "protection" Boolean NOT NULL DEFAULT 'f', -- Para que no se puede bo= rrar a nivel del builder (=3D anti-condoro) - "display" Integer, - primary key ("id_entity") -); - - -Create table "option" -( - "id_entity" Integer NOT NULL, - "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" Boolean not null default 't', -- Si es activo. - "orderOption" Numeric(10,2), - primary key ("id_entity") -); - -Create table "boolean" -( - "id_entity" Integer NOT NULL, - "displayText" Varchar(20), -- FIXME. - "numTrueValue" Integer, -- Valor para displegar cuando Verda= dero - "numFalseValue" Integer, -- Valor para displegar cuando Falso - primary key ("id_entity") -); - -Create table "class" -( - "id_entity" Integer NOT NULL, - "classType" Integer NOT NULL, -- Tipo de clase - "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" Boolean NOT NULL default 'f', -- significa que no se pued= e instanciar solo (como entity) - "isHidden" Boolean NOT NULL default 'f', -- significa que el class no = es visible al usuario.=09 - "descClass" text, - primary key ("id_entity") -); - -Create table "classType" -( - "id_entity" Integer NOT NULL, - "sysClassTypeName" Varchar(50) NOT NULL, - "parentClassType" Integer, - primary key ("id_entity") -); - -Create table "dateTime" -( - "id_entity" Integer NOT NULL, - "format" Integer, -- Pulldown con el formato del tiempo. FIXME - "dispHours" Integer, -- Pulldown de la resolucion del tiempo FIXME - "custom" Varchar(50),-- FIXME - primary key ("id_entity") -); - -Create table "domain" -( - "id_entity" Integer NOT NULL, - "domainName" Varchar(50), - "statusDomain" Integer,-- Pulldown de los estatus (deben ser Parte del = eschema inicial) FIXME.=20 - primary key ("id_entity") -); - -Create table "entity" -( - "id_entity" Serial, - "domainId" Integer NOT NULL, - "class" Integer NOT NULL, - "createDate" Timestamp NOT NULL DEFAULT NOW(), -- Momento de creacion - "modDate" Timestamp NOT NULL DEFAULT NOW(), -- Momento de modificacion - "delDate" Timestamp, -- Momento de borrar (NULL =3D Vivo) - "status" Varchar(40), - primary key ("id_entity") -); - -Create table "file" -( - "id_entity" Integer NOT NULL, - "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. - "linked" Boolean, -- CAREFUL!! Don't put "link" for this column:= causes problem with xsl then - primary key ("id_entity") -); - -Create table "inheritance" -( - "id_entity" Integer NOT NULL, - "from" Integer NOT NULL, - "to" Integer NOT NULL, - primary key ("id_entity") -); - -Create table "numeric" -( - "id_entity" Integer NOT NULL, - "decimals" Integer, -- Cantidad de decimales despues de la comma (para = la creacion de Numeric(x,y)) - "max" Integer, -- Valor maximo que se puede guardar en el numeric. - "min" Integer, - "default" Integer, - primary key ("id_entity") -); - -Create table "pertinence" -( - "id_entity" Integer NOT NULL, - "owner" Integer NOT NULL, -- El id de la columna que posee las refer= encias - "to" Integer NOT NULL, -- Tabla a la cual conecta esta relacion - "ratio" char(3) NOT NULL, -- Relacion (n:1, 1:n, n:m) - "parentPertinence" Integer, -- Padre de la relacion. - "visualAttrib" Integer, -- Attributo que se trae desde la tabla fora= nea. Si es null se trae la llave del metadata - "filterView" Text, -- Un filter sobre los pertinences que se muestr= an. -- FIXME: Is this the cleanst solution? - "widthPertinence" Integer, -- Width to display the pert= inence - "heightPertinence" Integer, -- Height to display - primary key ("id_entity") -); - -Create table "choice" -( - "id_entity" Integer NOT NULL, - "groupType" Integer NOT NULL, -- Grupo de opciones asociado a esta ele= ccion - "parentChoice" Integer, -- Para relaciones entre opciones, Region, Co= muna. - primary key ("id_entity") -); - -Create table "text" -( - "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" Boolean NOT NULL DEFAULT 'f', - primary key ("id_entity") -); - -Create table "textline" -( - "id_entity" Integer NOT NULL, - "maxLength" Integer, - "minLength" Integer, - "defaultText" Varchar(50), -- Default value - "dispSize" Integer, -- Tamano para displegar - primary key ("id_entity") -); - -Create table "user" -( - "id_entity" Integer NOT NULL, - "email" Varchar(50), - "pass" Varchar(50), -- plaintext password. - primary key ("id_entity") -); - -Create table "user_domain" -- Relacion entre usuarios y dominios. -( - "id_entity" Integer NOT NULL, - "userTable" Integer NOT NULL, - "domainTable" Integer NOT NULL, - primary key ("id_entity") -); - -Create table "optionGroup" -( - "id_entity" Integer NOT NULL, - "optionGroupName" Varchar(50), -- Default value - primary key ("id_entity") -); - -Create table "displayAttribute" -( - "id_entity" Integer NOT NULL, - "xslt" Varchar(50), -- Default value - "attTypeRef" Integer, - primary key ("id_entity") -); - -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 foreign key ("id_entity") references "attrib= ute" ("id_entity") on update restrict on delete cascade; -Alter table "dateTime" add foreign key ("id_entity") references "attri= bute" ("id_entity") on update restrict on delete cascade; -Alter table "file" add foreign key ("id_entity") references "attribut= e" ("id_entity") on update restrict on delete cascade; -Alter table "inheritance" add foreign key ("id_entity") references "att= ribute" ("id_entity") on update restrict on delete restrict; -Alter table "numeric" add foreign key ("id_entity") references "attrib= ute" ("id_entity") on update restrict on delete cascade; -Alter table "pertinence" add foreign key ("id_entity") references "attr= ibute" ("id_entity") on update restrict on delete cascade; -Alter table "choice" add foreign key ("id_entity") references "attribu= te" ("id_entity") on update restrict on delete cascade; -Alter table "text" add foreign key ("id_entity") references "attribut= e" ("id_entity") on update restrict on delete cascade; -Alter table "textline" add foreign key ("id_entity") references "attri= bute" ("id_entity") on update restrict on delete cascade; -Alter table "attribute" add foreign key ("classId") references "class"= ("id_entity") on update restrict on delete cascade; -Alter table "entity" add foreign key ("class") references "class" ("id= _entity") on update restrict on delete restrict; -Alter table "class" add foreign key ("classType") references "classTy= pe" ("id_entity") on update restrict on delete cascade; -Alter table "user_domain" add foreign key ("userTable") references "use= r" ("id_entity") on update restrict on delete cascade; -Alter table "user_domain" add foreign key ("domainTable")references "do= main" ("id_entity") on update restrict on delete cascade; - -/* Initial Data */ - -INSERT INTO "classType" ("id_entity","sysClassTypeName","parentClassTyp= e") VALUES (1,'metaModel',NULL); -INSERT INTO "classType" ("id_entity","sysClassTypeName","parentClassTyp= e") VALUES (27,'component',NULL); -INSERT INTO "classType" ("id_entity","sysClassTypeName","parentClassTyp= e") VALUES (29,'solutionData',NULL); - -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (1,1, 'classType','classType',3,'f',= 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (2,1, 'class','class',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (3,1, 'entity','entity',NULL,'t','f'= ); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (5,1, 'attribute','attribute',3,'t','= f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (6,27, 'domain','domain',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (7,27, 'user','user',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (8,1, 'textline','textline',5,'f', 'f= '); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (9,1, 'numeric','numeric',5,'f', 'f')= ; -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (12,1,'dateTime','dateTime',5,'f', 'f= '); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (13,1,'text','text',5,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (14,1,'inheritance','inheritance',5,'= f', 't'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (15,1,'choice','choice',81,'f', 't'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (26,27,'user_domain','user_domain',3,= 'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (39,1,'file','file',5,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (80,1, 'option','option',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (81,1,'pertinence','pertinence',5,'f'= , 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (82,1,'boolean','boolean',5,'f', 'f')= ; -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (130,1,'optionGroup','optionGroup',3,= 'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (149,1,'displayAttribute','displayAtt= ribute',3,'f', 'f'); -INSERT INTO "class" ("id_entity","classType","sysName","name","parentId= ","isAbstract", "isHidden") VALUES (153,1,'version','version',3,'f', 'f'= ); - -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (1,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (2,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (3,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (4,10,14,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (5,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (6,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (7,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (8,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (9,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (10,10,6,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (11,10,7,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (12,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (13,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (14,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (15,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (16,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (17,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (18,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (19,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (20,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (21,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (22,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (23,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (24,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (25,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (26,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (27,10,1,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (28,10,26,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (29,10,1,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (30,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (31,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (32,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (33,10,14,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (34,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (35,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (36,10,12,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (37,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (39,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (40,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (41,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (42,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (43,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (44,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (45,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (46,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (47,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (48,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (49,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (50,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (51,10,15,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (52,10,15,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (53,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (54,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (55,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (56,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (57,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (58,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (60,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (61,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (62,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (63,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (64,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (65,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (66,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (67,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (68,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (69,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (70,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (71,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (72,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (73,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (74,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (75,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (76,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (77,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (78,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (80,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (81,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (82,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (83,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (84,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (85,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (86,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (102,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (103,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (104,10,12,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (105,10,12,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (106,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (107,10,13,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (108,10,13,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (109,10,6,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (110,10,7,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (111,109,26,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (112,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (113,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (114,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (116,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (117,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (118,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (119,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (120,10,80,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (121,10,7,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (122,10,6,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (123,10,26,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (124,10,26,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (125,10,82,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (126,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (127,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (128,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (129,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (130,10,2,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (131,10,8,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (132,10,130,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (133,10,130,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (134,10,15,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (135,10,130,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (136,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (137,10,81,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (138,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (139,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (140,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (141,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (142,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (143,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (144,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (145,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (146,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (147,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (148,10,149,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (149,10,2,NULL,NULL); -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); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (157,10,9,NULL,NULL); -INSERT INTO "entity" ("id_entity","domainId","class","delDate","status"= ) VALUES (158,10,9,NULL,NULL); - -=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,'linked'= ,'linked',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 (157,81,'widthP= ertinence','width (in pixels)',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 (158,81,'height= Pertinence','height (in pixels)',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 (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 "numeric" ("id_entity","decimals","max","min","default") V= ALUES (17,2,NULL,0,NULL); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (24,2,NULL,0,NULL); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (41,2,NULL,0,NULL); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (43,0,255,1,20); -- textLine maxLength -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (44,0,255,0, 0); -- textLine minLength -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (46,0,255,1,20); -- textLine dispSize -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (47,0, 25, 0, 3); -- numeric decimals -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (48,0,NULL,NULL, 10000000); -- numeric max -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (49,0,NULL,NULL,-10000000); -- numeric min -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (50,0,NULL,NULL, NULL); -- numeric default=20 -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (53,0,100,1,30); -- text cols -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (54,0,50, 1, 7); -- text rows -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (77,0,NULL,NULL,NULL); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (83,2,10,0,1); -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (157,4,NULL,NULL,200); -- pertinence width -INSERT INTO "numeric" ("id_entity","decimals","max","min","default") V= ALUES (158,4,NULL,NULL,200); -- pertinence height - -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (16,50,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (18,25,1,25); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (19,10,6,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (21,50,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (30,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (32,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (37,40,35,40); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (66,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (42,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (45,50,0,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (68,50,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (72,10,3,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (76,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (84,20,0,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (131,20,1,20); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (154,50,1,50); -INSERT INTO "textline" ("id_entity","maxLength","minLength","dispSize")= VALUES (155,50,1,50); - - -INSERT INTO "dateTime" ("id_entity","format","dispHours","custom") VAL= UES (36,116,118,NULL); -INSERT INTO "dateTime" ("id_entity","format","dispHours","custom") VAL= UES (104,116,118,NULL); -INSERT INTO "dateTime" ("id_entity","format","dispHours","custom") VAL= UES (105,116,118,NULL); - - -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (23,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (55,'s?',1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (61,'s?',1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (62,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (63,'s?',1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (64,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (65,'s?',1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (67,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (86,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (102,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (106,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (114,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (125,NULL,1,NULL); -INSERT INTO "boolean" ("id_entity","displayText","numTrueValue","numFal= seValue") VALUES (69,NULL,1,NULL); - - -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (20,20,5,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (22,22,80,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (25,128,26,'n:m',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (31,31,1,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (34,34,6,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (35,35,2,'n:1',NULL); -- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (40,40,2,'n:1',NULL); -- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (51,51,80,'n:1',NULL); -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (52,52,80,'n:1',NULL); -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (56,56,2,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (57,57,2,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (60,60,130,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (70,70,5,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (71,71,2,'n:1',NULL);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (126,127,26,'n:m',25);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (127,127,6,'n:1',25);-- ok -INSERT INTO "pertinence" ("id_entity","owner","to","ratio","parentPerti= nence") VALUES (128,128,7,'n:1',25);-- ok -INSERT INTO "per... [truncated message content] |
