# MySQL dump 6.4
#
# Host: localhost    Database: keystone
#--------------------------------------------------------
# Server version	3.22.27

#
# Table structure for table 'dictionary'
#
CREATE TABLE dictionary (
  _rowid int(10) DEFAULT '0' NOT NULL auto_increment,
  dtable varchar(15) DEFAULT '' NOT NULL,
  dcolumn varchar(15) DEFAULT '' NOT NULL,
  dflags varchar(80),
  dlabel varchar(20),
  dheading varchar(10),
  dtype char(1),
  PRIMARY KEY (_rowid),
  KEY dtable (dtable),
  KEY dcolumn (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 (72,'contacts','ctype','','Contact Type','Type','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 (75,'people','login','','Login Name','Login','C');
INSERT INTO dictionary VALUES (76,'people','fullname','','Full Name','Name','C');
INSERT INTO dictionary VALUES (77,'people','passwd','','Password','Password','P');
INSERT INTO dictionary VALUES (78,'people','email','','E-Mail','E-Mail','C');
INSERT INTO dictionary VALUES (79,'people','grp','','Group','Group','C');
INSERT INTO dictionary VALUES (80,'people','company','','Company','Company','C');
INSERT INTO dictionary VALUES (81,'people','lastlog','D','Last Login','LastLogin','I');
INSERT INTO dictionary VALUES (82,'resources','r_tag','','Resources Tag','Tag','C');
INSERT INTO dictionary VALUES (83,'resources','r_ptag','','Parent Tag','Parent','C');
INSERT INTO dictionary VALUES (84,'dictionary','dtable','','Table Name','Table','C');
INSERT INTO dictionary VALUES (85,'dictionary','dcolumn','','Column Name','Column','C');
INSERT INTO dictionary VALUES (86,'dictionary','dflags','','Flags','Flags','C');
INSERT INTO dictionary VALUES (87,'dictionary','dlabel','','Column Label','Label','C');
INSERT INTO dictionary VALUES (88,'dictionary','dheading','','Heading','Heading','C');
INSERT INTO dictionary VALUES (89,'dictionary','dtype','','Column Type','Type','C');
INSERT INTO dictionary VALUES (90,'slipver','v_id','','Slip ID','SID','I');
INSERT INTO dictionary VALUES (91,'slipver','v_prod','','Product Name','Product','C');
INSERT INTO dictionary VALUES (92,'slipver','v_mod','','Module name','Module','C');
INSERT INTO dictionary VALUES (93,'slipver','v_plat','','Platform Name','Platform','C');
INSERT INTO dictionary VALUES (94,'slipver','v_foundin','','Found in Version','FoundIn','C');
INSERT INTO dictionary VALUES (95,'slipver','v_target','','Target Version','Target','C');
INSERT INTO dictionary VALUES (96,'slipver','v_verify','','Verified In','Verify','C');
INSERT INTO dictionary VALUES (97,'slipver','v_resolve','','Resolution Code','ResCode','C');

