-- PostgreSQL
--
-- Host: localhost    Database: keystone
----------------------------------------------------------

--
-- Table structure for table 'contactlabel'
--
CREATE SEQUENCE contactlabel_seq START 1;

CREATE TABLE contactlabel (
	_rowid int NOT NULL DEFAULT nextval('contactlabel_seq') PRIMARY KEY,
	tag varchar(10),
	descrip varchar(30),
	ltype varchar(1)
);

CREATE INDEX contactlabel_tag_idx ON contactlabel(tag);

INSERT INTO contactlabel VALUES (1,'WORK','Work Phone','P');
INSERT INTO contactlabel VALUES (2,'WORK2','Work Phone #2','P');
INSERT INTO contactlabel VALUES (3,'CELL','Cell Phone','P');
INSERT INTO contactlabel VALUES (4,'PAGER','Pager','P');
INSERT INTO contactlabel VALUES (5,'CAR','Car Phone','P');
INSERT INTO contactlabel VALUES (6,'HOME','Home Phone','P');
INSERT INTO contactlabel VALUES (7,'FAX', 'Work Fax', 'P');
INSERT INTO contactlabel VALUES (8,'FAX2', 'Work Fax #2', 'P');
INSERT INTO contactlabel VALUES (9,'WORK','Work Address','A');
INSERT INTO contactlabel VALUES (10,'HOME','Home Address','A');

