githubFork/roundcubemail.git

githubFork / roundcubemail

Roundcubemail devel

summary
reflog
commits
tree
docs
forks
compare

#1485125: added index on messages.created

alecpl

2008-06-12 c98f3b5d6e4c681b7e42ea71c32cd2ef1991b519

 SQL/postgres.update.sql

@@ -17,3 +17,7 @@
ALTER TABLE contacts ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE cache DROP CONSTRAINT cache_user_id_fkey;
ALTER TABLE cache ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;

-- Updates from version 0.2-alpha

CREATE INDEX messages_created_idx ON messages (created);

			@@ -17,3 +17,7 @@
			ALTER TABLE contacts ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
			ALTER TABLE cache DROP CONSTRAINT cache_user_id_fkey;
			ALTER TABLE cache ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;

			-- Updates from version 0.2-alpha

			CREATE INDEX messages_created_idx ON messages (created);