From 25c35c81e1648c49291218fdf0162d82b7e692ca Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Fri, 19 Sep 2008 12:14:10 -0400
Subject: [PATCH] - added set_message, set_message_icon and set_message_status functions - icon setting more unified + some small fixes/typos - get rid of *_from_preview() functions (Thomas, don't be mad, it was truly tested ;))
---
SQL/postgres.initial.sql | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql
index 05c6192..88f12af 100644
--- a/SQL/postgres.initial.sql
+++ b/SQL/postgres.initial.sql
@@ -152,7 +152,7 @@
-- Name: messages; Type: TABLE; Schema: public; Owner: postgres
--
-CREATE TABLE "messages" (
+CREATE TABLE messages (
message_id integer DEFAULT nextval('message_ids'::text) PRIMARY KEY,
user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
del integer DEFAULT 0 NOT NULL,
@@ -170,4 +170,5 @@
structure text
);
-ALTER TABLE "messages" ADD UNIQUE (user_id, cache_key, uid);
+ALTER TABLE messages ADD UNIQUE (user_id, cache_key, uid);
+CREATE INDEX messages_created_idx ON messages (created);
--
Gitblit v1.9.1