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

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);