[H2-commits] r1335 - humano2/trunk/core/schema/mssql

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

Author: marcelo
Date: 2005-06-16 14:15:57 -0400 (Thu, 16 Jun 2005)
New Revision: 1335

Added:
   humano2/trunk/core/schema/mssql/mssql-9-HelpDeskSMB.sql
Log:
ADDED: schema for helpdesk for MsSQl server

Added: humano2/trunk/core/schema/mssql/mssql-9-HelpDeskSMB.sql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

--- humano2/trunk/core/schema/mssql/mssql-9-HelpDeskSMB.sql	2005-06-16 13=
:48:30 UTC (rev 1334)
+++ humano2/trunk/core/schema/mssql/mssql-9-HelpDeskSMB.sql	2005-06-16 18=
:15:57 UTC (rev 1335)
@@ -0,0 +1,219 @@
+
+
+CREATE TABLE "d10160cAsset" (
+    id_entity integer NOT NULL,
+    "c10165Name" varchar(20),
+    "c10165Serial Nr." varchar(20),
+    "c10165Details" text,
+    "c10165User" integer,
+    "c10165Purchase Data" datetime,
+    "c10165User1" integer,
+PRIMARY KEY (id_entity)
+);
+
+CREATE TABLE "d10160cAsset Type" (
+    id_entity integer NOT NULL,
+    "c10213Type Name" varchar(20),
+PRIMARY KEY (id_entity)
+);
+
+
+CREATE TABLE "d10160cProblem Type" (
+    id_entity integer NOT NULL,
+    "c10189Problem Type" varchar(20),
+PRIMARY KEY (id_entity)
+);
+
+
+CREATE TABLE "d10160cTicket" (
+    id_entity integer NOT NULL,
+    "c10162Title" varchar(20),
+    "c10162Detail" text,
+    "c10162Request by" integer,
+    "c10162Assigned to" integer,
+    "c10162Assigned to1" integer,
+    "c10162Status" integer,
+    "c10162Solution Detail" text,
+    "c10162Problem Type" integer,
+    "c10162Attachment" varchar(255),
+    "c10162Date" datetime,
+    "c10162Resolution Date" datetime,
+    "c10162Request by1" integer,
+    "c10162Assigned to2" integer,
+    "c10162Assigned to3" integer,
+PRIMARY KEY (id_entity)
+);
+
+CREATE TABLE "d10160cTicket Status" (
+    id_entity integer NOT NULL,
+    "c10163Status Name" varchar(20),
+PRIMARY KEY (id_entity)
+);
+
+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, '0', '0', NULL);
+INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10163, 29, 'd10160cTicke=
t Status', 'Ticket Status', 3, '0', '0', NULL);
+INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10165, 29, 'd10160cAsset=
', 'Asset', 3, '0', '0', NULL);
+INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10189, 29, 'd10160cProbl=
em Type', 'Problem Type', 3, '0', '0', NULL);
+INSERT INTO "class" (id_entity, "classType", "sysName", name, "parentId"=
, "isAbstract", "isHidden", "descClass") VALUES (10213, 29, 'd10160cAsset=
 Type', 'Asset Type', 3, '0', '0', NULL);
+
+set identity_insert entity ON
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10160, 10, 6, '2005-06-03 13:42:40', '200=
5-06-03 13:42:40', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10161, 10, 26, '2005-06-03 13:42:40', '20=
05-06-03 13:42:40', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10183, 10160, 13, '2005-06-03 13:49:23', =
'2005-06-03 13:50:51', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10188, 10160, 13, '2005-06-03 13:51:06', =
'2005-06-03 13:51:06', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10191, 10160, 1011, '2005-06-03 13:52:08'=
, '2005-06-03 14:00:51', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10180, 10160, 1011, '2005-06-03 13:49:03'=
, '2005-06-03 14:01:03', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10213, 10160, 2, '2005-06-03 14:01:25', '=
2005-06-03 14:01:25', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10217, 10160, 8, '2005-06-03 14:02:01', '=
2005-06-03 14:02:01', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10211, 10160, 1400, '2005-06-03 14:00:13'=
, '2005-06-03 14:09:25', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10169, 10160, 13, '2005-06-03 13:45:57', =
'2005-06-03 14:22:30', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10168, 10160, 8, '2005-06-03 13:45:43', '=
2005-06-03 14:25:37', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10208, 10160, 12, '2005-06-03 13:58:04', =
'2005-06-03 14:26:15', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10192, 10160, 81, '2005-06-03 13:52:32', =
'2005-06-03 14:28:15', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10229, 10160, 81, '2005-06-03 14:39:34', =
'2005-06-03 14:40:29', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10231, 10160, 81, '2005-06-03 14:42:01', =
'2005-06-03 14:42:19', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10182, 10160, 1011, '2005-06-03 13:49:16'=
, '2005-06-03 14:46:42', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10228, 10160, 1300, '2005-06-03 14:19:33'=
, '2005-06-03 14:53:13', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10234, 10160, 81, '2005-06-03 14:54:09', =
'2005-06-03 14:54:09', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10167, 10160, 1011, '2005-06-03 13:45:32'=
, '2005-06-03 14:55:26', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10187, 10160, 81, '2005-06-03 13:50:34', =
'2005-06-03 14:56:52', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10162, 10160, 2, '2005-06-03 13:43:27', '=
2005-06-03 13:43:27', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10163, 10160, 2, '2005-06-03 13:43:46', '=
2005-06-03 13:43:46', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10165, 10160, 2, '2005-06-03 13:45:18', '=
2005-06-03 13:45:18', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10166, 10160, 8, '2005-06-03 13:45:32', '=
2005-06-03 13:45:32', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10179, 10160, 8, '2005-06-03 13:49:03', '=
2005-06-03 13:49:03', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10189, 10160, 2, '2005-06-03 13:51:55', '=
2005-06-03 13:51:55', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10190, 10160, 8, '2005-06-03 13:52:08', '=
2005-06-03 13:52:08', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10171, 10160, 1011, '2005-06-03 13:46:14'=
, '2005-06-03 14:11:48', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10218, 10160, 1011, '2005-06-03 14:02:01'=
, '2005-06-03 14:12:17', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10216, 10160, 1011, '2005-06-03 14:01:49'=
, '2005-06-03 14:12:32', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10207, 10160, 12, '2005-06-03 13:57:45', =
'2005-06-03 14:22:45', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10181, 10160, 8, '2005-06-03 13:49:16', '=
2005-06-03 14:26:07', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10209, 10160, 12, '2005-06-03 13:58:16', =
'2005-06-03 14:28:37', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10212, 10160, 1400, '2005-06-03 14:00:21'=
, '2005-06-03 14:41:01', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10227, 10160, 1011, '2005-06-03 14:14:50'=
, '2005-06-03 14:46:50', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10226, 10160, 1011, '2005-06-03 14:14:03'=
, '2005-06-03 14:46:59', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10210, 10160, 1400, '2005-06-03 14:00:06'=
, '2005-06-03 14:53:42', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10193, 10160, 39, '2005-06-03 13:52:55', =
'2005-06-03 14:56:44', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10194, 10160, 10163, '2005-06-03 13:53:51=
', '2005-06-03 13:53:51', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10195, 10160, 10163, '2005-06-03 13:53:59=
', '2005-06-03 13:53:59', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10196, 10160, 10189, '2005-06-03 13:54:17=
', '2005-06-03 13:54:17', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10197, 10160, 10189, '2005-06-03 13:54:46=
', '2005-06-03 13:54:46', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10198, 10160, 10189, '2005-06-03 13:54:53=
', '2005-06-03 13:54:53', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10199, 10160, 10189, '2005-06-03 13:55:04=
', '2005-06-03 13:55:04', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10200, 10160, 10189, '2005-06-03 13:55:17=
', '2005-06-03 13:55:17', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10201, 10160, 10189, '2005-06-03 13:55:41=
', '2005-06-03 13:55:41', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10202, 10160, 10189, '2005-06-03 13:55:49=
', '2005-06-03 13:55:49', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10203, 10160, 10189, '2005-06-03 13:56:15=
', '2005-06-03 13:56:15', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10204, 10160, 10189, '2005-06-03 13:56:25=
', '2005-06-03 13:56:25', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10205, 10160, 10189, '2005-06-03 13:56:36=
', '2005-06-03 13:56:36', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10206, 10160, 10189, '2005-06-03 13:56:46=
', '2005-06-03 13:56:46', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10221, 10160, 10213, '2005-06-03 14:03:01=
', '2005-06-03 14:03:01', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10222, 10160, 10213, '2005-06-03 14:03:11=
', '2005-06-03 14:03:11', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10223, 10160, 10213, '2005-06-03 14:03:19=
', '2005-06-03 14:03:19', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10224, 10160, 10213, '2005-06-03 14:03:27=
', '2005-06-03 14:03:27', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10225, 10160, 10213, '2005-06-03 14:03:34=
', '2005-06-03 14:03:34', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10233, 10160, 10162, '2005-06-03 14:48:54=
', '2005-06-03 14:48:54', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10235, 10160, 10165, '2005-06-03 14:54:50=
', '2005-06-03 14:55:44', NULL, NULL);
+INSERT INTO entity (id_entity, "domainId", "class", "createDate", "modDa=
te", "delDate", status) VALUES (10232, 10160, 10162, '2005-06-03 14:43:15=
', '2005-06-03 14:57:13', NULL, NULL);
+set identity_insert entity OFF
+
+
+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, '0', '=
1', '0', '1', '0', '0', '0', '0', NULL, '0', 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, '0', '1', '0', '1', '0', '0', '0', '0', NULL, '0', 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 (10217, 10213, 'c10213Type Name', 'Type Name', 0.00, '0', '1'=
, '0', '1', '0', '1', '0', '0', NULL, '0', 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, '0', '1', '=
0', '1', '0', '0', '0', '0', NULL, '0', 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, '0', '=
1', '0', '1', '0', '0', '0', '0', NULL, '0', 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, '0', '1', '0', '1=
', '0', '0', '0', '0', NULL, '0', 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, '=
0', '1', '0', '1', '0', '0', '0', '0', NULL, '0', 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, '0',=
 '1', '1', '1', '0', '0', '0', '0', NULL, '0', 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, '0'=
, '1', '1', '1', '0', '0', '0', '0', NULL, '0', 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, '0', '1', '1', '1=
', '0', '0', '0', '0', NULL, '0', 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, '0', '1', '0'=
, '1', '0', '0', '0', '0', NULL, '0', 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, '0', '1', '0', '1'=
, '0', '1', '0', '0', NULL, '0', 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, '0',=
 '1', '0', '1', '0', '1', '0', '0', NULL, '0', 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, '0=
', '1', '0', '1', '0', '1', '0', '0', NULL, '0', 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, =
'0', '1', '0', '1', '0', '0', '0', '0', NULL, '0', 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, '0', '1', '0',=
 '1', '0', '1', '0', '0', NULL, '0', 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, '0', '1', '0', '1', '0', '0', '0', '0', NULL, '0', 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 (10193, 10162, 'c10162Attachment', 'Attachment', 20.00, '0', =
'1', '0', '1', '0', '0', '0', '0', NULL, '0', 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 (=
10193, 100000, NULL, NULL, '1');
+
+
+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, '0');
+INSERT INTO text (id_entity, "rows", cols, "isHtml") VALUES (10188, 7, 3=
0, '0');
+INSERT INTO text (id_entity, "rows", cols, "isHtml") VALUES (10169, 7, 3=
0, '0');
+
+
+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');



