--- 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
 );
 
 
@@ -91,13 +92,13 @@
 -- PostgreSQL database dump complete
 --
 
-CREATE TABLE "compilation" (
+CREATE TABLE "compilations" (
   "filename" text NOT NULL,
   "files" text ARRAY NOT NULL,
   "datetime" timestamp NOT NULL
 );
 
-CREATE TABLE "trunk_log" (
+CREATE TABLE "trunk_logs" (
   "id" text NOT NULL,
   "datetime" integer NOT NULL,
   "site" integer NOT NULL,
@@ -109,3 +110,4 @@
   "channel" smallint NOT NULL,
   "calltype" text NOT NULL
 );
+