[scannr.git] / 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
 );