X-Git-Url: http://git.jankratochvil.net/?p=gnokii.git;a=blobdiff_plain;f=smsd%2Fsms.tables.sql;fp=smsd%2Fsms.tables.sql;h=b4c61f5750d43a44bbb153f432c4ad6253a3f786;hp=c18568c7ec6ec84006891b9d3cc8ba0f580e362a;hb=49dd905279a8e62936e3713510ab0fd738e20ecb;hpb=2f2703c9133032c12671ca5c77ae626b8fb178d4

diff --git a/smsd/sms.tables.sql b/smsd/sms.tables.sql
index c18568c..b4c61f5 100644
--- 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);