Found in "gnokii-working" directory, some November-patches version

[gnokii.git] / smsd / sms.tables.sql

diff --git a/smsd/sms.tables.sql b/smsd/sms.tables.sql
index c18568c..b4c61f5 100644 (file)
--- a/smsd/sms.tables.sql
+++ b/smsd/sms.tables.sql
@@ -10,6 +10,15 @@ CREATE TABLE "outbox" (
        "id" serial,
        "number" character varying(20) NOT NULL,
        "insertdate" timestamp DEFAULT 'now' NOT NULL,
-       "text" character varying(160),
+       "text" text NOT NULL,
+       "hexencode" bool DEFAULT 'false' NOT NULL,
+       "type" character varying(20) DEFAULT 'text' NOT NULL,
+       "fromfile" bool DEFAULT 'false' NOT NULL,
+       "netcode" character varying(10) DEFAULT NULL NULL,
+       "udhpresent" bool DEFAULT 'false' NOT NULL,
+       "longuseudh" bool DEFAULT 'true' NOT NULL,
+       "eightbit" bool DEFAULT 'false' NOT NULL,
+       "smsc" character varying(20) DEFAULT NULL NULL,
        "processed" bool DEFAULT 'false'
 );
+CREATE INDEX outbox_processed ON "outbox" (processed);