[H2-commits] r1244 - in humano2/trunk: . core/schema/pgsql

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

Author: marcelo
Date: 2005-06-03 19:50:42 -0400 (Fri, 03 Jun 2005)
New Revision: 1244

Added:
   humano2/trunk/core/schema/pgsql/pgsql-9-HelpDesk SMB.sql
Modified:
   humano2/trunk/changelog.txt
Log:
 * Adding schema for basic help desk.=20
 * Final change to CHANGELOG.TXT

Modified: humano2/trunk/changelog.txt
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=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/changelog.txt	2005-06-03 23:47:02 UTC (rev 1243)
+++ humano2/trunk/changelog.txt	2005-06-03 23:50:42 UTC (rev 1244)
@@ -6,6 +6,7 @@
    * Changed paging logic in ViewTools so that it works in MsSql
    * This last change means that Postgresql V.8 has to used=20
    * Caching was implemented to minimize calls to the DB
+   * Added a schema file to implement basic help desk
   =20
  * Metamodel=20
    * Added new attribute types of attributes:
@@ -15,6 +16,7 @@
    * Image upload is now soported and the images will be displayed in in=
stance.aspx
    * Views which have multiple column with the same no longer crash
   =20
+  =20
=20
 =3D=3D 5.0.beta3 - 2005-05-27 =3D=3D
=20

Added: humano2/trunk/core/schema/pgsql/pgsql-9-HelpDesk SMB.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-9-HelpDesk SMB.sql	2005-06-03 2=
3:47:02 UTC (rev 1243)
+++ humano2/trunk/core/schema/pgsql/pgsql-9-HelpDesk SMB.sql	2005-06-03 2=
3:50:42 UTC (rev 1244)
@@ -0,0 +1,234 @@
+
+CREATE TABLE "d10160cAsset" (
+    id_entity integer NOT NULL,
+    "c10165Name" character varying(20),
+    "c10165Serial Nr." character varying(20),
+    "c10165Details" pg_catalog.text,
+    "c10165User" integer,
+    "c10165Purchase Data" timestamp without time zone,
+    "c10165User1" integer
+);
+
+CREATE TABLE "d10160cAsset Type" (
+    id_entity integer NOT NULL,
+    "c10213Type Name" character varying(20)
+);
+
+
+CREATE TABLE "d10160cProblem Type" (
+    id_entity integer NOT NULL,
+    "c10189Problem Type" character varying(20)
+);
+
+
+CREATE TABLE "d10160cTicket" (
+    id_entity integer NOT NULL,
+    "c10162Title" character varying(20),
+    "c10162Detail" pg_catalog.text,
+    "c10162Request by" integer,
+    "c10162Assigned to" integer,
+    "c10162Assigned to1" integer,
+    "c10162Status" integer,
+    "c10162Solution Detail" pg_catalog.text,
+    "c10162Problem Type" integer,
+    "c10162Attachment" character varying(255),
+    "c10162Date" timestamp without time zone,
+    "c10162Resolution Date" timestamp without time zone,
+    "c10162Request by1" integer,
+    "c10162Assigned to2" integer,
+    "c10162Assigned to3" integer
+);
+
+CREATE TABLE "d10160cTicket Status" (
+    id_entity integer NOT NULL,
+    "c10163Status Name" character varying(20)
+);
+
+INSERT INTO "domain" (id_entity, "domainName", "statusDomain") VALUES (1=
0160, 'HelpDesk SMB', NULL);
+
+INSERT INTO user_domain (id_entity, "userTable", "domainTable") VALUES (=
10161, 110, 10160);
+
+
+INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10162, 29, 'd10160cTicke=
t', 'Ticket', 3, false, false, NULL);
+INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10163, 29, 'd10160cTicke=
t Status', 'Ticket Status', 3, false, false, NULL);
+INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10165, 29, 'd10160cAsset=
', 'Asset', 3, false, false, NULL);
+INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10189, 29, 'd10160cProbl=
em Type', 'Problem Type', 3, false, false, NULL);
+INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10213, 29, 'd10160cAsset=
 Type', 'Asset Type', 3, false, false, NULL);
+
+
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10160, 10, 6, '2005-06-03 13:42:40.382654=
', '2005-06-03 13:42:40.382654', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10161, 10, 26, '2005-06-03 13:42:40.38265=
4', '2005-06-03 13:42:40.382654', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10183, 10160, 13, '2005-06-03 13:49:23.35=
705', '2005-06-03 13:50:51.900709', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10188, 10160, 13, '2005-06-03 13:51:06.95=
1818', '2005-06-03 13:51:06.951818', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10191, 10160, 1011, '2005-06-03 13:52:08.=
746904', '2005-06-03 14:00:51.690467', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10180, 10160, 1011, '2005-06-03 13:49:03.=
157439', '2005-06-03 14:01:03.294255', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10213, 10160, 2, '2005-06-03 14:01:25.703=
696', '2005-06-03 14:01:25.703696', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10217, 10160, 8, '2005-06-03 14:02:01.815=
791', '2005-06-03 14:02:01.815791', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10211, 10160, 1400, '2005-06-03 14:00:13.=
606343', '2005-06-03 14:09:25.558326', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10169, 10160, 13, '2005-06-03 13:45:57.32=
3388', '2005-06-03 14:22:30.991451', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10168, 10160, 8, '2005-06-03 13:45:43.336=
775', '2005-06-03 14:25:37.287955', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10208, 10160, 12, '2005-06-03 13:58:04.81=
2695', '2005-06-03 14:26:15.834796', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10192, 10160, 81, '2005-06-03 13:52:32.32=
6281', '2005-06-03 14:28:15.268152', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10229, 10160, 81, '2005-06-03 14:39:34.53=
7608', '2005-06-03 14:40:29.939294', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10231, 10160, 81, '2005-06-03 14:42:01.61=
6166', '2005-06-03 14:42:19.932286', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10182, 10160, 1011, '2005-06-03 13:49:16.=
240216', '2005-06-03 14:46:42.304934', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10228, 10160, 1300, '2005-06-03 14:19:33.=
34587', '2005-06-03 14:53:13.709408', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10234, 10160, 81, '2005-06-03 14:54:09.56=
251', '2005-06-03 14:54:09.56251', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10167, 10160, 1011, '2005-06-03 13:45:32.=
65888', '2005-06-03 14:55:26.309087', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10187, 10160, 81, '2005-06-03 13:50:34.47=
0391', '2005-06-03 14:56:52.144244', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10162, 10160, 2, '2005-06-03 13:43:27.916=
665', '2005-06-03 13:43:27.916665', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10163, 10160, 2, '2005-06-03 13:43:46.308=
109', '2005-06-03 13:43:46.308109', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10165, 10160, 2, '2005-06-03 13:45:18.909=
72', '2005-06-03 13:45:18.90972', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10166, 10160, 8, '2005-06-03 13:45:32.568=
103', '2005-06-03 13:45:32.568103', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10179, 10160, 8, '2005-06-03 13:49:03.037=
233', '2005-06-03 13:49:03.037233', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10189, 10160, 2, '2005-06-03 13:51:55.936=
952', '2005-06-03 13:51:55.936952', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10190, 10160, 8, '2005-06-03 13:52:08.663=
398', '2005-06-03 13:52:08.663398', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10171, 10160, 1011, '2005-06-03 13:46:14.=
711256', '2005-06-03 14:11:48.27411', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10218, 10160, 1011, '2005-06-03 14:02:01.=
896462', '2005-06-03 14:12:17.918998', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10216, 10160, 1011, '2005-06-03 14:01:49.=
2393', '2005-06-03 14:12:32.141613', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10207, 10160, 12, '2005-06-03 13:57:45.49=
2882', '2005-06-03 14:22:45.989972', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10181, 10160, 8, '2005-06-03 13:49:16.159=
46', '2005-06-03 14:26:07.052118', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10209, 10160, 12, '2005-06-03 13:58:16.05=
7463', '2005-06-03 14:28:37.025827', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10212, 10160, 1400, '2005-06-03 14:00:21.=
580172', '2005-06-03 14:41:01.392034', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10227, 10160, 1011, '2005-06-03 14:14:50.=
273608', '2005-06-03 14:46:50.975127', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10226, 10160, 1011, '2005-06-03 14:14:03.=
451426', '2005-06-03 14:46:59.017467', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10210, 10160, 1400, '2005-06-03 14:00:06.=
409507', '2005-06-03 14:53:42.120173', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10193, 10160, 39, '2005-06-03 13:52:55.97=
5696', '2005-06-03 14:56:44.293002', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10194, 10160, 10163, '2005-06-03 13:53:51=
.821092', '2005-06-03 13:53:51.821092', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10195, 10160, 10163, '2005-06-03 13:53:59=
.706222', '2005-06-03 13:53:59.706222', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10196, 10160, 10189, '2005-06-03 13:54:17=
.310243', '2005-06-03 13:54:17.310243', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10197, 10160, 10189, '2005-06-03 13:54:46=
.136202', '2005-06-03 13:54:46.136202', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10198, 10160, 10189, '2005-06-03 13:54:53=
.731381', '2005-06-03 13:54:53.731381', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10199, 10160, 10189, '2005-06-03 13:55:04=
.593734', '2005-06-03 13:55:04.593734', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10200, 10160, 10189, '2005-06-03 13:55:17=
.971074', '2005-06-03 13:55:17.971074', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10201, 10160, 10189, '2005-06-03 13:55:41=
.042234', '2005-06-03 13:55:41.042234', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10202, 10160, 10189, '2005-06-03 13:55:49=
.192745', '2005-06-03 13:55:49.192745', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10203, 10160, 10189, '2005-06-03 13:56:15=
.128508', '2005-06-03 13:56:15.128508', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10204, 10160, 10189, '2005-06-03 13:56:25=
.237106', '2005-06-03 13:56:25.237106', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10205, 10160, 10189, '2005-06-03 13:56:36=
.198424', '2005-06-03 13:56:36.198424', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10206, 10160, 10189, '2005-06-03 13:56:46=
.303592', '2005-06-03 13:56:46.303592', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10221, 10160, 10213, '2005-06-03 14:03:01=
.731759', '2005-06-03 14:03:01.731759', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10222, 10160, 10213, '2005-06-03 14:03:11=
.262688', '2005-06-03 14:03:11.262688', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10223, 10160, 10213, '2005-06-03 14:03:19=
.212243', '2005-06-03 14:03:19.212243', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10224, 10160, 10213, '2005-06-03 14:03:27=
.729589', '2005-06-03 14:03:27.729589', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10225, 10160, 10213, '2005-06-03 14:03:34=
.714994', '2005-06-03 14:03:34.714994', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10233, 10160, 10162, '2005-06-03 14:48:54=
.39211', '2005-06-03 14:48:54.809633', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10235, 10160, 10165, '2005-06-03 14:54:50=
.088007', '2005-06-03 14:55:44.129858', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10232, 10160, 10162, '2005-06-03 14:43:15=
.241259', '2005-06-03 14:57:13.749824', NULL, NULL);
+
+
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10183, 10162, 'c10162Detail', 'Problem Detail', 0.00, false,=
 true, false, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10188, 10162, 'c10162Solution Detail', 'Solution Detail', 0.=
00, false, true, false, true, false, false, false, false, NULL, false, NU=
LL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10217, 10213, 'c10213Type Name', 'Type Name', 0.00, false, t=
rue, false, true, false, true, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10169, 10165, 'c10165Details', 'Details', 10.00, false, true=
, false, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10168, 10165, 'c10165Serial Nr.', 'Serial Nr.', 4.00, false,=
 true, false, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10208, 10162, 'c10162Date', 'Date', -9.00, false, true, fals=
e, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10192, 10162, 'c10162Problem Type', 'Problem Type', -4.00, f=
alse, true, false, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10229, 10162, 'c10162Request by1', 'Request by', -5.00, fals=
e, true, true, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10231, 10162, 'c10162Assigned to3', 'Assigned to', 0.00, fal=
se, true, true, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10234, 10165, 'c10165User1', 'User', 0.00, false, true, true=
, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10187, 10162, 'c10162Status', 'Status', 15.00, false, true, =
false, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10166, 10165, 'c10165Name', 'Name', 0.00, false, true, false=
, true, false, true, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10179, 10163, 'c10163Status Name', 'Status Name', 0.00, fals=
e, true, false, true, false, true, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10190, 10189, 'c10189Problem Type', 'Problem Type', 0.00, fa=
lse, true, false, true, false, true, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10207, 10165, 'c10165Purchase Data', 'Purchase Date', 5.00, =
false, true, false, true, false, false, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10181, 10162, 'c10162Title', 'Title', -10.00, false, true, f=
alse, true, false, true, false, false, NULL, false, NULL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10209, 10162, 'c10162Resolution Date', 'Resolution Date', 8.=
00, false, true, false, true, false, false, false, false, NULL, false, NU=
LL);
+INSERT INTO attribute (id_entity, "classId", "sysAttName", "attName", "o=
rder", "isObligatory", "isActive", "isSearchable", "isEditable", "isSelfL=
ookup", "isPrimary", "isUnique", "isVirtual", "descAtt", protection, disp=
lay) VALUES (10193, 10162, 'c10162Attachment', 'Attachment', 20.00, false=
, true, false, true, false, false, false, false, NULL, false, NULL);
+
+
+INSERT INTO "dateTime" (id_entity, format, "dispHours", custom) VALUES (=
10207, NULL, NULL, NULL);
+INSERT INTO "dateTime" (id_entity, format, "dispHours", custom) VALUES (=
10208, NULL, NULL, NULL);
+INSERT INTO "dateTime" (id_entity, format, "dispHours", custom) VALUES (=
10209, NULL, NULL, NULL);
+
+
+INSERT INTO file (id_entity, maxsize, path, extensions, link) VALUES (10=
193, 100000, NULL, NULL, true);
+
+
+INSERT INTO folder (id_entity, "folderName", "folderParent", "folderForm=
s") VALUES (10211, 'Assets', 0, '10167');
+INSERT INTO folder (id_entity, "folderName", "folderParent", "folderForm=
s") VALUES (10212, 'Users and Setup', 0, '10191,10180,10218');
+INSERT INTO folder (id_entity, "folderName", "folderParent", "folderForm=
s") VALUES (10210, 'Tickets', 0, '10227,10226');
+
+
+INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10192, 10192, 10189, 'n:1', NU=
LL, NULL, NULL);
+INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10229, 10229, 7, 'n:1', NULL, =
NULL, NULL);
+INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10231, 10231, 7, 'n:1', NULL, =
NULL, NULL);
+INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10234, 10234, 7, 'n:1', NULL, =
NULL, NULL);
+INSERT INTO pertinence (id_entity, "owner", "to", ratio, "parentPertinen=
ce", "visualAttrib", "filterView") VALUES (10187, 10187, 10163, 'n:1', NU=
LL, NULL, NULL);
+
+
+INSERT INTO report (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassReport", "reportName") VALUES (10228, '10181|1,10187^10179',=
 NULL, '10187^10179', NULL, NULL, 10162, 'Tickets by Assignment');
+
+
+INSERT INTO text (id_entity, "rows", cols, "isHtml") VALUES (10183, 7, 3=
0, false);
+INSERT INTO text (id_entity, "rows", cols, "isHtml") VALUES (10188, 7, 3=
0, false);
+INSERT INTO text (id_entity, "rows", cols, "isHtml") VALUES (10169, 7, 3=
0, false);
+
+
+INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10166, 20, NULL, NULL, NULL);
+INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10179, 20, NULL, NULL, NULL);
+INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10190, 20, NULL, NULL, NULL);
+INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10217, 20, NULL, NULL, NULL);
+INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10168, 20, NULL, NULL, NULL);
+INSERT INTO textline (id_entity, "maxLength", "minLength", "defaultText"=
, "dispSize") VALUES (10181, 20, NULL, NULL, NULL);
+
+
+INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10218, '0,10217', NULL, NULL, NUL=
L, NULL, 10213, 'Asset Type Pick List');
+INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10227, '0,10181,10208,10231^18,10=
209', '10187^10179|7|''closed''|0|0', NULL, NULL, NULL, 10162, 'Closed Ti=
ckets');
+INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10226, '0,10181,10208,10231^18,10=
187^10179', '10187^10179|7|''open''|0|0', NULL, NULL, NULL, 10162, 'Open =
Tickets');
+INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10191, '0,10190', NULL, NULL, NUL=
L, NULL, 10189, 'Problem Type Pick List');
+INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10180, '0,10179', NULL, NULL, NUL=
L, NULL, 10163, 'Ticket Status Pick List');
+INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10182, '0,10181,10208,10231^18,10=
187^10179', NULL, NULL, NULL, NULL, 10162, 'All Tickets');
+INSERT INTO "view" (id_entity, columns, "where", groupby, "having", "ord=
er", "idClassView", "viewName") VALUES (10167, '0,10166,10168,10207,10169=
', NULL, NULL, NULL, NULL, 10165, 'All Assets');
+
+
+INSERT INTO "d10160cAsset" (id_entity, "c10165Name", "c10165Serial Nr.",=
 "c10165Details", "c10165User", "c10165Purchase Data", "c10165User1") VAL=
UES (10235, 'PC Work Station', '453345345', 'Dell Work Station with Monit=
or VisewSonic 14F', NULL, '2005-06-14 00:00:00', 110);
+
+INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0221, 'PC Work Station');
+INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0222, 'PC Notebook');
+INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0223, 'Monitor');
+INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0224, 'Printer');
+INSERT INTO "d10160cAsset Type" (id_entity, "c10213Type Name") VALUES (1=
0225, 'Other');
+
+
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10196, 'Conectivity');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10197, 'Bug');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10198, 'Crash');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10199, 'Priniting');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10200, 'System Start-up');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10201, 'Audio Visual');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10202, 'Virus');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10203, 'eMail');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10204, 'Software - Windows');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10205, 'Software - Office');
+INSERT INTO "d10160cProblem Type" (id_entity, "c10189Problem Type") VALU=
ES (10206, 'Software - Outlook');
+
+
+INSERT INTO "d10160cTicket" (id_entity, "c10162Title", "c10162Detail", "=
c10162Request by", "c10162Assigned to", "c10162Assigned to1", "c10162Stat=
us", "c10162Solution Detail", "c10162Problem Type", "c10162Attachment", "=
c10162Date", "c10162Resolution Date", "c10162Request by1", "c10162Assigne=
d to2", "c10162Assigned to3") VALUES (10233, 'Internet Down', 'User can n=
ot connect to the Internet', NULL, NULL, NULL, 10194, NULL, 10196, NULL, =
'2005-06-03 00:00:00', '2005-06-03 00:00:00', 110, NULL, 110);
+INSERT INTO "d10160cTicket" (id_entity, "c10162Title", "c10162Detail", "=
c10162Request by", "c10162Assigned to", "c10162Assigned to1", "c10162Stat=
us", "c10162Solution Detail", "c10162Problem Type", "c10162Attachment", "=
c10162Date", "c10162Resolution Date", "c10162Request by1", "c10162Assigne=
d to2", "c10162Assigned to3") VALUES (10232, 'PC does not startup', 'PC d=
oes not startup', NULL, NULL, NULL, 10195, 'PC was not plugged in. I plug=
ged in the PC. Now the PC works fine. User happy.', 10200, NULL, '2005-06=
-03 00:00:00', '2005-06-03 00:00:00', 110, NULL, 110);
+
+
+INSERT INTO "d10160cTicket Status" (id_entity, "c10163Status Name") VALU=
ES (10194, 'open');
+INSERT INTO "d10160cTicket Status" (id_entity, "c10163Status Name") VALU=
ES (10195, 'closed');
+
+
+ALTER TABLE ONLY "d10160cAsset Type"
+    ADD CONSTRAINT "d10160cAsset Type_pkey" PRIMARY KEY (id_entity);
+
+ALTER TABLE ONLY "d10160cAsset"
+    ADD CONSTRAINT "d10160cAsset_pkey" PRIMARY KEY (id_entity);
+
+
+
+ALTER TABLE ONLY "d10160cProblem Type"
+    ADD CONSTRAINT "d10160cProblem Type_pkey" PRIMARY KEY (id_entity);
+
+
+ALTER TABLE ONLY "d10160cTicket Status"
+    ADD CONSTRAINT "d10160cTicket Status_pkey" PRIMARY KEY (id_entity);
+
+
+ALTER TABLE ONLY "d10160cTicket"
+    ADD CONSTRAINT "d10160cTicket_pkey" PRIMARY KEY (id_entity);
+
+



