Bug#216294: marked as done (dcl: Postgresql createdb.sql uses erroneous syntax)

To: Matej Vela <vela@debian.org>
Subject: Bug#216294: marked as done (dcl: Postgresql createdb.sql uses erroneous syntax)
From: owner@bugs.debian.org (Debian Bug Tracking System)
Date: Wed, 22 Mar 2006 06:03:36 -0800
Message-id: <[🔎] handler.216294.D216294.11430354207039.ackdone@bugs.debian.org>
References: <87slpaoagm.fsf@diziet.irb.hr> <E1AAaOg-0007Cw-00@peperina.rivero>

Your message dated Wed, 22 Mar 2006 14:50:01 +0100
with message-id <87slpaoagm.fsf@diziet.irb.hr>
and subject line Removed
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--- Begin Message ---

To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: dcl: Postgresql createdb.sql uses erroneous syntax
From: Maximiliano Curia <maxy@rivero.com.ar>
Date: Fri, 17 Oct 2003 16:36:26 -0300
Message-id: <E1AAaOg-0007Cw-00@peperina.rivero>

Package: dcl
Version: 1:0.9.2-1
Severity: important
Tags: patch

The createdb.sql uses syntax that is not postgresql syntax. I've
modified it to make it work.

Here it is:
-- createdb.sql
CREATE SEQUENCE "seq_accounts";
CREATE SEQUENCE "seq_attributesets";
CREATE SEQUENCE "seq_views";
CREATE SEQUENCE "seq_tickets";
CREATE SEQUENCE "seq_ticketresolutions";
CREATE SEQUENCE "seq_faq";
CREATE SEQUENCE "seq_faqtopics";
CREATE SEQUENCE "seq_faqquestions";
CREATE SEQUENCE "seq_faqanswers";
CREATE SEQUENCE "seq_timecards";
CREATE SEQUENCE "seq_severity";
CREATE SEQUENCE "seq_departments";
CREATE SEQUENCE "seq_jcn";
CREATE SEQUENCE "seq_projects";
CREATE SEQUENCE "seq_watches";

CREATE SEQUENCE 
	"seq_personnel" 
	start 2 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('seq_personnel');


CREATE SEQUENCE 
	"seq_actions" 
	start 7 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('seq_actions');

CREATE SEQUENCE "seq_priorities";
CREATE SEQUENCE "seq_products";

CREATE SEQUENCE 
	"seq_statuses" 
	start 4 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('seq_statuses');

CREATE TABLE "personnel" (
		"id" "int4" NOT NULL,
		"short" char(10) NOT NULL, 
		"lastname" varchar(25), 
		"firstname" varchar(20), 
		"reportto" "int4", 
		"department" "int4", 
		"pwd" varchar(50), 
		"security" "int4", 
		"email" varchar(80),
		"active" varchar(1) default 'Y'
	);

CREATE TABLE "accounts" (
		"id" "int4" NOT NULL, 
		"short" char(10) NOT NULL, 
		"name" varchar(30) NOT NULL, 
		"add1" varchar(30), 
		"add2" varchar(30), 
		"city" varchar(50), 
		"state" char(2), 
		"zip" char(11), 
		"contact" varchar(50), 
		"voice" char(10), 
		"fax" char(10), 
		"data1" char(10), 
		"data2" char(10), 
		"notes" varchar(1024),
		"active" varchar(1) default 'Y'
	);

CREATE TABLE "actions" (
		"id" "int4" NOT NULL, 
		"short" char(10) NOT NULL, 
		"name" varchar(20) NOT NULL,
		"active" varchar(1) default 'Y'
	);

CREATE TABLE "priorities" (
		"id" "int4" NOT NULL, 
		"short" char(10) NOT NULL, 
		"name" varchar(20) NOT NULL, 
		"weight" "int4" NOT NULL,
		"active" varchar(1) default 'Y'
	);

CREATE TABLE "products" (
		"id" "int4" NOT NULL, 
		"short" char(10) NOT NULL, 
		"name" varchar(50) NOT NULL, 
		"reportto" "int4",
		"active" varchar(1) default 'Y',
		"ticketsto" "int4" NOT NULL,
		"wosetid" "int4" NOT NULL,
		"tcksetid" "int4" NOT NULL
	);

CREATE TABLE "statuses" (
		"id" "int4" NOT NULL, 
		"short" char(10) NOT NULL, 
		"name" varchar(20) NOT NULL,
		"active" varchar(1) default 'Y',
		"dcl_status_type" "int4" default '1' not null
	);

CREATE TABLE "timecards" (
		"id" "int4" NOT NULL, 
		"jcn" "int4" NOT NULL, 
		"seq" "int4" NOT NULL, 
		"actionon" "date" NOT NULL, 
		"inputon" "timestamp" DEFAULT CURRENT_TIMESTAMP NOT NULL, 
		"actionby" "int4" NOT NULL, 
		"status" "int4" NOT NULL, 
		"action" "int4" NOT NULL, 
		"hours" "float8" NOT NULL, 
		"summary" varchar(100) NOT NULL, 
		"description" varchar(1024), 
		"revision" varchar(20),
		"reassign_from_id" "int4" null,
		"reassign_to_id" "int4" null
	);

CREATE TABLE "severities" (
		"id" "int4" NOT NULL, 
		"short" char(10) NOT NULL, 
		"name" varchar(20) NOT NULL, 
		"weight" "int4" NOT NULL,
		"active" varchar(1) default 'Y'
	);

CREATE TABLE "departments" (
		"id" "int4" NOT NULL, 
		"short" char(10) NOT NULL, 
		"name" varchar(30) NOT NULL,
		"active" varchar(1) default 'Y'
	);

CREATE TABLE "workorders" (
		"jcn" "int4" NOT NULL, 
		"seq" "int4" NOT NULL, 
		"product" "int4" NOT NULL, 
		"account" "int4", 
		"createby" "int4" NOT NULL, 
		"createdon" "timestamp" NOT NULL, 
		"closedby" "int4", 
		"closedon" "date", 
		"status" "int4" NOT NULL, 
		"statuson" "timestamp" NOT NULL, 
		"lastactionon" "timestamp", 
		"deadlineon" "date", 
		"eststarton" "date", 
		"estendon" "date", 
		"starton" "date", 
		"esthours" "float8", 
		"totalhours" "float8", 
		"priority" "int4" NOT NULL, 
		"severity" "int4" NOT NULL, 
		"contact" varchar(50), 
		"contactphone" char(10), 
		"summary" varchar(100) NOT NULL, 
		"notes" varchar(1024), 
		"description" varchar(1024) NOT NULL, 
		"responsible" "int4", 
		"revision" varchar(20), 
		"publicview" "bool", 
		"notifycreateby" "bool", 
		"notifyproductlead" "bool", 
		"notifyresponsible" "bool", 
		"etchours" "float8",
		"module_id" "int4"
	);

create table "dcl_projects" (
		"projectid" "int4" not null primary key, 
		"name" varchar(100), 
		"reportto" "int4" not null, 
		"createdby" "int4" not null, 
		"createdon" "timestamp" DEFAULT CURRENT_TIMESTAMP NOT NULL, 
		"projectdeadline" "date", 
		"description" varchar(1024) not null, 
		"status" "int4" not null, 
		"lastactivity" "timestamp", 
		"finalclose" "date",
		"parentprojectid" int4 default('0') not null
	);

create unique index "projects_name_key" on dcl_projects("name");

create table "projectmap" (
		"projectid" "int4" not null, 
		"jcn" "int4" not null, 
		"seq" "int4" not null, 
		primary key("projectid", "jcn", "seq")
	);

create table "watches" (
		"watchid" "int4" primary key not null,
		"typeid" "int4" not null,
		"whatid1" "int4" not null,
		"whatid2" "int4" not null,
		"whoid" "int4" not null,
		"actions" "int4" not null
	);

CREATE FUNCTION 
	"next_seq" ("int4" ) 
	RETURNS "int4" AS 
	'SELECT MAX(seq)+1 FROM WORKORDERS WHERE jcn = $1' LANGUAGE 'SQL';

COPY "personnel" FROM stdin;
1	sa        	Administrator		0	0	c12e01f2a13ff5587e1e9e4aedb8242d	9		Y
\.
COPY "actions" FROM stdin;
1	DBG       	Debug	Y
2	RES       	Research	Y
3	DOC       	Document	Y
4	TST       	Testing	Y
5	DES       	Design	Y
6	IMP       	Implementation	Y
7	CORR      	Correction	Y
\.
COPY "statuses" FROM stdin;
1	OP        	Open	Y	1
2	CL        	Closed	Y	2
3	DF        	Deferred	Y	3
4	UA        	Unassigned	Y	1
\.

CREATE UNIQUE INDEX 
	"personnel_pkey" 
	on "personnel" using btree ( "id" "int4_ops" );

CREATE UNIQUE INDEX 
	"personnel_short_key" 
	on "personnel" using btree ( "short" "bpchar_ops" );

CREATE UNIQUE INDEX 
	"accounts_pkey" 
	on "accounts" using btree ( "id" "int4_ops" );

CREATE UNIQUE INDEX 
	"actions_pkey" 
	on "actions" using btree ( "id" "int4_ops" );

CREATE UNIQUE INDEX 
	"priorities_pkey" 
	on "priorities" using btree ( "id" "int4_ops" );

CREATE UNIQUE INDEX 
	"products_pkey" 
	on "products" using btree ( "id" "int4_ops" );

CREATE UNIQUE INDEX 
	"statuses_pkey" 
	on "statuses" using btree ( "id" "int4_ops" );

CREATE UNIQUE INDEX 
	"timecards_pkey" 
	on "timecards" using btree ( "id" "int4_ops" );

CREATE UNIQUE INDEX 
	"severities_pkey" 
	on "severities" using btree ( "id" "int4_ops" );

CREATE UNIQUE INDEX 
	"departments_pkey" 
	on "departments" using btree ( "id" "int4_ops" );

CREATE TABLE "tickets" (
		"ticketid" int4 NOT NULL,
		"product" int4 NOT NULL,
		"account" int4,
		"createdby" int4 NOT NULL,
		"createdon" timestamp DEFAULT 'now()' NOT NULL,
		"responsible" int4 NOT NULL,
		"closedby" int4,
		"closedon" timestamp,
		"status" int4 NOT NULL,
		"statuson" timestamp NOT NULL,
		"lastactionon" timestamp,
		"priority" int4 NOT NULL,
		"type" int4 NOT NULL,
		"contact" varchar(80),
		"contactphone" varchar(20),
		"issue" text NOT NULL,
		"version" varchar(20),
		"summary" varchar(100),
		"seconds" int4 not null default '0',
		"contactemail" varchar(100),
		"module_id" int4,
		PRIMARY KEY ("ticketid")
	);

CREATE TABLE "ticketresolutions" (
		"resid" int4 NOT NULL,
		"ticketid" int4 NOT NULL,
		"loggedby" int4 NOT NULL,
		"loggedon" timestamp DEFAULT 'now()' NOT NULL,
		"status" int4 NOT NULL,
		"resolution" text NOT NULL,
		"startedon" timestamp NOT NULL,
		PRIMARY KEY ("resid")
	);

CREATE TABLE "faq" (
		"faqid" int4 NOT NULL,
		"name" varchar(80) NOT NULL,
		"createby" int4,
		"createon" timestamp DEFAULT 'now()' NOT NULL,
		"modifyby" int4,
		"modifyon" timestamp,
		"active" char(1) DEFAULT 'Y' NOT NULL,
		"description" text,
		PRIMARY KEY ("faqid")
	);

CREATE TABLE "faqtopics" (
		"topicid" int4 NOT NULL,
		"seq" int4 NOT NULL,
		"faqid" int4 NOT NULL,
		"name" varchar(80) NOT NULL,
		"description" text NOT NULL,
		"createby" int4,
		"createon" timestamp DEFAULT 'now()' NOT NULL,
		"modifyby" int4,
		"modifyon" timestamp,
		"active" char(1) DEFAULT 'Y' NOT NULL,
		PRIMARY KEY ("topicid")
	);

CREATE TABLE "faqquestions" (
		"questionid" int4 NOT NULL,
		"seq" int4 NOT NULL,
		"topicid" int4 NOT NULL,
		"questiontext" text NOT NULL,
		"createby" int4,
		"createon" timestamp DEFAULT 'now()' NOT NULL,
		"modifyby" int4,
		"modifyon" timestamp,
		"active" char(1) DEFAULT 'Y' NOT NULL,
		PRIMARY KEY ("questionid")
	);

CREATE TABLE "faqanswers" (
		"answerid" int4 NOT NULL,
		"questionid" int4 NOT NULL,
		"answertext" text NOT NULL,
		"createby" int4 NOT NULL,
		"createon" timestamp DEFAULT 'now()' NOT NULL,
		"modifyby" int4,
		"modifyon" timestamp,
		"active" char(1) DEFAULT 'Y' NOT NULL,
		PRIMARY KEY ("answerid")
	);

CREATE TABLE "views" (
		"viewid" int4 NOT NULL,
		"whoid" int4 NOT NULL,
		"name" varchar(100) NOT NULL,
		"ispublic" char(1) DEFAULT 'N' NOT NULL,
		"viewurl" text NOT NULL,
		"tablename" varchar(30) not null,
		PRIMARY KEY("viewid")
	);


CREATE TABLE "attributesets" (
		"id" int4 NOT NULL,
		"short" varchar(20) NOT NULL,
		"name" varchar(100) NOT NULL,
		"active" char(1) NOT NULL DEFAULT 'Y'
	);

INSERT INTO attributesets(id,short,name,active) VALUES (nextval('seq_attributesets'), 'WO', 'Work Orders', 'Y');
INSERT INTO attributesets(id,short,name,active) VALUES (nextval('seq_attributesets'), 'TCK', 'Tickets', 'Y');

CREATE TABLE "attributesetsmap" (
		"setid" int4 NOT NULL,
		"typeid" int4 NOT NULL,
		"keyid" int4 NOT NULL,
		"weight" int4 NOT NULL
	);

INSERT INTO attributesetsmap SELECT 1, 1, id, 1 FROM actions;
INSERT INTO attributesetsmap SELECT 1, 2, id, weight FROM priorities;
INSERT INTO attributesetsmap SELECT 1, 3, id, weight FROM severities;
INSERT INTO attributesetsmap SELECT 1, 4, id, 1 FROM statuses;

INSERT INTO attributesetsmap SELECT 2, 1, id, 1 FROM actions;
INSERT INTO attributesetsmap SELECT 2, 2, id, weight FROM priorities;
INSERT INTO attributesetsmap SELECT 2, 3, id, weight FROM severities;
INSERT INTO attributesetsmap SELECT 2, 4, id, 1 FROM statuses;

CREATE TABLE "dcl_config" (
		"dcl_config_name" varchar(50) NOT NULL,
		"dcl_config_field" varchar(30) NOT NULL,
		"dcl_config_int" int4,
		"dcl_config_double" float8,
		"dcl_config_date" date,
		"dcl_config_datetime" timestamp,
		"dcl_config_varchar" varchar(255),
		PRIMARY KEY ("dcl_config_name")
	);

INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_VERSION','dcl_config_varchar',NULL,NULL,NULL,NULL,'0.9.2');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_DATE_FORMAT','dcl_config_varchar',NULL,NULL,NULL,NULL,'m/d/Y');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_DATE_FORMAT_DB','dcl_config_varchar',NULL,NULL,NULL,NULL,'Y-m-d');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_TIMESTAMP_FORMAT_DB','dcl_config_varchar',NULL,NULL,NULL,NULL,'Y-m-d H:i:s');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_TIMESTAMP_FORMAT','dcl_config_varchar',NULL,NULL,NULL,NULL,'m/d/Y H:i:s');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_MAX_UPLOAD_FILE_SIZE','dcl_config_int',1048576,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_DEFAULT_LANGUAGE','dcl_config_varchar',NULL,NULL,NULL,NULL,'en');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_PRIVATE_KEY','dcl_config_varchar',NULL,NULL,NULL,NULL,'IloveDCL');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_ROOT','dcl_config_varchar',NULL,NULL,NULL,NULL,'http://localhost/dcl/');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_ADD_USER','dcl_config_int',9,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_DEL_WO','dcl_config_int',8,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_MOD_WO','dcl_config_int',7,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_ASSIGN_WO','dcl_config_int',5,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_ADD_WO','dcl_config_int',3,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_HAVE_WO','dcl_config_int',4,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_CHG_PWD','dcl_config_int',2,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_DEF_STATUS_ASSIGN_WO','dcl_config_int',1,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_DEF_STATUS_UNASSIGN_WO','dcl_config_int',4,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_DEF_PRIORITY','dcl_config_int',1,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_DEF_SEVERITY','dcl_config_int',2,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_AUTO_DATE','dcl_config_varchar',NULL,NULL,NULL,NULL,'Y');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_TIME_CARD_ORDER','dcl_config_varchar',NULL,NULL,NULL,NULL,'ASC');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_PROJECT_XML_TEMPLATES','dcl_config_varchar',NULL,NULL,NULL,NULL,'N');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_GD_TYPE','dcl_config_varchar',NULL,NULL,NULL,NULL,'png');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_CQQ_PERCENT','dcl_config_int',0,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_CQQ_FROM','dcl_config_varchar',NULL,NULL,NULL,NULL,'Somebody <someone@somewhere.org>');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_CQQ_SUBJECT','dcl_config_varchar',NULL,NULL,NULL,NULL,'Thank You For Calling');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_CQQ_TEMPLATE','dcl_config_varchar',NULL,NULL,NULL,NULL,'cqqmail.tpl');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_DEF_TEMPLATE_SET','dcl_config_varchar',NULL,NULL,NULL,NULL,'default');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_COLOR_LIGHT','dcl_config_varchar',NULL,NULL,NULL,NULL,'#eeeef8');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_COLOR_DARK','dcl_config_varchar',NULL,NULL,NULL,NULL,'#737b9c');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_SMTP_SERVER','dcl_config_varchar',NULL,NULL,NULL,NULL,'localhost');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_SMTP_ENABLED','dcl_config_varchar',NULL,NULL,NULL,NULL,'Y');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_SMTP_PORT','dcl_config_int',25,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int, dcl_config_double, dcl_config_date, dcl_config_datetime, dcl_config_varchar) VALUES ('DCL_SMTP_TIMEOUT','dcl_config_int',30,NULL,NULL,NULL,NULL);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) VALUES ('DCL_PROJECT_BROWSE_PARENTS_ONLY', 'dcl_config_varchar', 'N');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) VALUES ('DCL_PROJECT_INCLUDE_PARENT_STATS', 'dcl_config_varchar', 'N');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) VALUES ('DCL_PROJECT_INCLUDE_CHILD_STATS', 'dcl_config_varchar', 'Y');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) VALUES ('DCL_FILE_PATH', 'dcl_config_varchar', '.');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) VALUES ('DCL_HTML_TITLE', 'dcl_config_varchar', 'Double Choco Latte - Copyright (C) 1998-2001 Michael L. Dean and Tim R. Norman');
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int) VALUES ('DCL_DEFAULT_PROJECT_STATUS', 'dcl_config_int', 1);
INSERT INTO dcl_config (dcl_config_name, dcl_config_field, dcl_config_int) VALUES ('DCL_DEFAULT_TICKET_STATUS', 'dcl_config_int', 1);
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_GATEWAY_TICKET_ENABLED', 'dcl_config_varchar', 'N');
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_GATEWAY_TICKET_AUTORESPOND', 'dcl_config_varchar', 'N');
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_GATEWAY_TICKET_REPLY', 'dcl_config_varchar', 'N');
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_GATEWAY_TICKET_AUTORESPONSE_EMAIL', 'dcl_config_varchar', 'nobody@localhost');
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_GATEWAY_TICKET_FILE_PATH', 'dcl_config_varchar', '/tmp');
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_int) values ('DCL_GATEWAY_TICKET_STATUS', 'dcl_config_int', 0);
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_int) values ('DCL_GATEWAY_TICKET_PRIORITY', 'dcl_config_int', 0);
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_int) values ('DCL_GATEWAY_TICKET_SEVERITY', 'dcl_config_int', 0);
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_int) values ('DCL_GATEWAY_TICKET_ACCOUNT', 'dcl_config_int', 0);
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_int) values ('DCL_GATEWAY_TICKET_REPLY_LOGGED_BY', 'dcl_config_int', 0);
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_SMTP_DEFAULT_EMAIL', 'dcl_config_varchar', 'nobody@localhost');
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_WO_NOTIFICATION_HTML', 'dcl_config_varchar', 'N');
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_WO_EMAIL_TEMPLATE', 'dcl_config_varchar', 'notify_wo_en.tpl');
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_TCK_NOTIFICATION_HTML', 'dcl_config_varchar', 'N');
insert into dcl_config (dcl_config_name, dcl_config_field, dcl_config_varchar) values ('DCL_TCK_EMAIL_TEMPLATE', 'dcl_config_varchar', 'notify_tck_en.tpl');

CREATE SEQUENCE "seq_dcl_chklst";
CREATE TABLE "dcl_chklst" (
		"dcl_chklst_id" int4 DEFAULT nextval('seq_dcl_chklst') NOT NULL,
		"dcl_chklst_tpl_id" int4 NOT NULL,
		"dcl_chklst_summary" varchar(255) NOT NULL,
		"dcl_chklst_createby" int4 NOT NULL,
		"dcl_chklst_createon" timestamp DEFAULT 'now()' NOT NULL,
		"dcl_chklst_modifyby" int4,
		"dcl_chklst_modifyon" timestamp,
		"dcl_chklst_status" varchar(255),
		PRIMARY KEY ("dcl_chklst_id")
	);

CREATE SEQUENCE "seq_dcl_chklst_tpl";
CREATE TABLE "dcl_chklst_tpl" (
		"dcl_chklst_tpl_id" int4 DEFAULT nextval('seq_dcl_chklst_tpl') NOT NULL,
		"dcl_chklst_tpl_name" varchar(255) NOT NULL,
		"dcl_chklst_tpl_active" char(1) DEFAULT 'Y' NOT NULL,
		PRIMARY KEY ("dcl_chklst_tpl_id")
	);

Create Sequence "seq_dcl_product_module";
Create Table "dcl_product_module" (
		"product_module_id" int4 Default nextval('seq_dcl_product_module') Not Null,
		"product_id" int4 Not Null,
		"module_name" varchar(50) Not Null,
		"active" char(1) Not Null,
		PRIMARY KEY ("product_module_id")
	);

create table dcl_status_type (
		dcl_status_type_id int4 not null primary key,
		dcl_status_type_name varchar(50) not null
	);

insert into dcl_status_type values (1, 'Open');
insert into dcl_status_type values (2, 'Completed');
insert into dcl_status_type values (3, 'Deferred');
-- End of createdb.sql

-- System Information
Debian Release: testing/unstable
Architecture: i386
Kernel: Linux peperina 2.4.21-4-686 #1 Sat Aug 2 23:27:25 EST 2003 i686
Locale: LANG=en_US.ISO-8859-1, LC_CTYPE=en_US.ISO-8859-1

Versions of packages dcl depends on:
ii  apache                   1.3.26-0woody3  Versatile, high-performance HTTP s
ii  apache [httpd]           1.3.26-0woody3  Versatile, high-performance HTTP s
ii  bash                     2.05b-8.1       The GNU Bourne Again SHell
ii  debconf                  1.3.14          Debian configuration management sy
ii  grep                     2.5.1-5         GNU grep, egrep and fgrep
ii  php4                     4:4.1.2-6woody3 A server-side, HTML-embedded scrip
ii  python                   2.2.3-3         An interactive high-level object-o
ii  sed                      4.0.7-1         The GNU sed stream editor
ii  wwwconfig-common         0.0.28          Debian web auto configuration

--- End Message ---

--- Begin Message ---

To: 155511-done@bugs.debian.org, 162177-done@bugs.debian.org, 162456-done@bugs.debian.org, 182518-done@bugs.debian.org, 182519-done@bugs.debian.org, 216294-done@bugs.debian.org, 222764-done@bugs.debian.org, 263456-done@bugs.debian.org, 339411-done@bugs.debian.org

Subject: Removed

From: Matej Vela <vela@debian.org>

Date: Wed, 22 Mar 2006 14:50:01 +0100

Message-id: <87slpaoagm.fsf@diziet.irb.hr>
dcl has been removed from Debian.  For more information, please see
<http://bugs.debian.org/247231>.
--- End Message ---

Reply to:

Prev by Date: Bug#218498: marked as done (gkdial: disconnecting on a busy tone crashes x server)
Next by Date: Bug#339411: marked as done (dcl: "numrows" global is not used for initial tickets display, but is used when changing pages.)
Previous by thread: Bug#218498: marked as done (gkdial: disconnecting on a busy tone crashes x server)
Next by thread: Bug#339411: marked as done (dcl: "numrows" global is not used for initial tickets display, but is used when changing pages.)
Index(es):
- Date
- Thread