Files F117752482

2008030300.sql
No OneTemporary
Actions

Authored By

Unknown

Size

1 KB

Referenced Files

None

Subscribers

None

2008030300.sql
View Options

	-- Updates from version 0.1-stable to 0.1.1

	CREATE INDEX cache_user_id_idx ON cache (user_id, cache_key);
	CREATE INDEX contacts_user_id_idx ON contacts (user_id);
	CREATE INDEX identities_user_id_idx ON identities (user_id);

	CREATE INDEX users_username_id_idx ON users (username);
	CREATE INDEX users_alias_id_idx ON users (alias);

	-- added ON DELETE/UPDATE actions
	ALTER TABLE messages DROP CONSTRAINT messages_user_id_fkey;
	ALTER TABLE messages ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
	ALTER TABLE identities DROP CONSTRAINT identities_user_id_fkey;
	ALTER TABLE identities ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
	ALTER TABLE contacts DROP CONSTRAINT contacts_user_id_fkey;
	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;

File Metadata

Mime Type: text/plain
Expires: Sat, Apr 4, 4:12 AM (20 h, 7 m ago)
Storage Engine: local-disk
Storage Format: Raw Data
Storage Handle: 14/e1/0cf133abc2b2af9301a53e2dc1e8
Default Alt Text: 2008030300.sql (1 KB)

Event Timeline