--- 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,4 +92,22 @@
 -- PostgreSQL database dump complete
 --
 
+CREATE TABLE "compilations" (
+  "filename" text NOT NULL,
+  "files" text ARRAY NOT NULL,
+  "datetime" timestamp NOT NULL
+);
 
+CREATE TABLE "trunk_logs" (
+  "id" text NOT NULL,
+  "datetime" integer NOT NULL,
+  "site" integer NOT NULL,
+  "action" text NOT NULL,
+  "sourcetype" character(1) NOT NULL,
+  "sourceid" smallint NOT NULL,
+  "targettype" character(1) NOT NULL,
+  "targetid" smallint NOT NULL,
+  "channel" smallint NOT NULL,
+  "calltype" text NOT NULL
+);
+