--- a/db.sql +++ b/db.sql @@ -52,10 +52,11 @@ CREATE TABLE tgids ( tgid text NOT NULL, subfleet smallint, + alpha_tag text NOT NULL, mode character(1) DEFAULT 'D'::bpchar NOT NULL, - alpha_tag text NOT NULL, + description text, service_tag text, - category smallint + category text ); @@ -109,3 +110,4 @@ "channel" smallint NOT NULL, "calltype" text NOT NULL ); +