From f89f03cd6ae4a1b3f98e39c2e01d9e40f8a286b4 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Fri, 12 Sep 2008 07:12:05 -0400 Subject: [PATCH] Refactor drag & drop functionality. Don't rely on browser events anymore (#1484453) --- 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