[scannr.git] / db.sql
--- a/db.sql
+++ b/db.sql
@@ -91,4 +91,21 @@
 -- PostgreSQL database dump complete
 --
 
+CREATE TABLE "compilation" (
+  "filename" text NOT NULL,
+  "files" text ARRAY NOT NULL,
+  "datetime" timestamp NOT NULL
+);
 
+CREATE TABLE "trunk_log" (
+  "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
+);