/*
--	$Id: dictionary.interbase,v 1.2 1999/09/20 00:42:08 billf Exp $
--
--	Table structure for table 'dictionary'
*/


CREATE TABLE dictionary (
  ks_rowid int NOT NULL PRIMARY KEY,
  dtable varchar(15) NOT NULL,
  dcolumn varchar(15) NOT NULL,
  dflags varchar(80),
  dlabel varchar(20),
  dheading varchar(10),
  dtype varchar(1)
);

CREATE INDEX dictionary_dtable_idx ON dictionary (dtable);
CREATE INDEX dictionary_dcolumn_idx ON dictionary (dcolumn);

/*
--
-- Dumping data for table 'dictionary'
--
*/

INSERT INTO dictionary VALUES (45,'slips','sid','','Slip ID','SID','I');
INSERT INTO dictionary VALUES (46,'slips','spid','','Slip Parent ID','SPID','I');
INSERT INTO dictionary VALUES (47,'slips','depend','','Dependent Slip ID','DSID','I');
INSERT INTO dictionary VALUES (48,'slips','o_date','D','Open Date','OpenD','I');
INSERT INTO dictionary VALUES (49,'slips','o_tech','','Open Tech','OpenT','C');
INSERT INTO dictionary VALUES (50,'slips','c_date','D','Close Date','CloseD','I');
INSERT INTO dictionary VALUES (51,'slips','c_tech','','Close Tech','CloseT','C');
INSERT INTO dictionary VALUES (9,'slips','state','','Unused',NULL,NULL);
INSERT INTO dictionary VALUES (52,'slips','status','','Current Status','St','C');
INSERT INTO dictionary VALUES (53,'slips','priority','','Priority','Pri','I');
INSERT INTO dictionary VALUES (54,'slips','ctag','','Contact Tag','Contact','C');
INSERT INTO dictionary VALUES (55,'slips','problem','','Short description of','Problem','C');
INSERT INTO dictionary VALUES (56,'slips','summary','','Full Description','Descriptio','C');
INSERT INTO dictionary VALUES (57,'slips','so_date','D','Scheduled Open Date','Sched ODat','I');
INSERT INTO dictionary VALUES (58,'slips','sc_date','D','Scheduled Close Date','Sched CDat','I');
INSERT INTO dictionary VALUES (59,'slips','grp','','Group','Group','C');
INSERT INTO dictionary VALUES (60,'slips','is_public','B','Public Flag','Pub','I');
INSERT INTO dictionary VALUES (61,'slips','l_tech','','Last Tech','Last Tech','C');
INSERT INTO dictionary VALUES (62,'slips','num_children','C','Number of Children','Ch','I');
INSERT INTO dictionary VALUES (63,'slips','num_follows','C','Number of Followups','Fo','I');
INSERT INTO dictionary VALUES (64,'slips','currtech','','Current Assigned Tec','Tech','C');
INSERT INTO dictionary VALUES (65,'slips','l_activity','D','Last Activity','LastAct','I');
INSERT INTO dictionary VALUES (66,'contacts','tag','','Tag','Tag','C');
INSERT INTO dictionary VALUES (67,'contacts','name','','Full Name','Name','C');
INSERT INTO dictionary VALUES (68,'contacts','company','','Company','Comp','C');
INSERT INTO dictionary VALUES (70,'contacts','email','','Email Address','EMail','C');
INSERT INTO dictionary VALUES (71,'contacts','passwd','P','Password','Pass','C');
INSERT INTO dictionary VALUES (72,'slips','timespent','','Time Spent','TimeSpent','I');

/* create the generator */

CREATE GENERATOR ROWID_GEN;
COMMIT;
SET GENERATOR ROWID_GEN TO 100;
COMMIT;

SET TERM !! ;
CREATE TRIGGER dictionary_trg_bir FOR dictionary
BEFORE INSERT 
	AS BEGIN
     		NEW.ks_rowid = GEN_ID (ROWID_GEN, 1);
	END !!
SET TERM ; !!

