Merge branch 'master' of ssh://maxious.lambdacomplex.org/git/scannr
[scannr.git] / db.sql
blob:a/db.sql -> blob:b/db.sql
--- 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
 );
+