diff options
author | Aurélien Bompard <aurelien@bompard.org> | 2013-08-01 12:20:57 +0000 |
---|---|---|
committer | Aurélien Bompard <aurelien@bompard.org> | 2013-08-01 13:36:17 +0000 |
commit | a373e9e6f8b26e700257de062f04f13ddfb96a5f (patch) | |
tree | 015ed78e543dc7f4adaffb4433a38fd58728176f /kittystore/storm/schema/patch_10.py | |
parent | 070871070e62fce367c55ec52579f4680b3d3980 (diff) | |
download | kittystore-master.tar.gz kittystore-master.tar.xz kittystore-master.zip |
Diffstat (limited to 'kittystore/storm/schema/patch_10.py')
-rw-r--r-- | kittystore/storm/schema/patch_10.py | 33 |
1 files changed, 9 insertions, 24 deletions
diff --git a/kittystore/storm/schema/patch_10.py b/kittystore/storm/schema/patch_10.py index f04f8e8..dc41cbe 100644 --- a/kittystore/storm/schema/patch_10.py +++ b/kittystore/storm/schema/patch_10.py @@ -6,32 +6,17 @@ from . import get_db_type SQL = { - "sqlite": [""" - CREATE TABLE "user_address" ( - user_id VARCHAR(255) NOT NULL, - address VARCHAR(255) NOT NULL, - PRIMARY KEY (user_id, address) - );""", - 'CREATE INDEX "ix_user_address_user_id" ON "user_address" (user_id);', - 'CREATE UNIQUE INDEX "ix_user_address_address" ON "user_address" (address);', + "sqlite": [ + 'ALTER TABLE "email" ADD COLUMN user_id VARCHAR(255);', + 'CREATE INDEX "ix_email_user_id" ON "email" (user_id);', ], - "postgres": [""" - CREATE TABLE "user_address" ( - user_id VARCHAR(255) NOT NULL, - address VARCHAR(255) NOT NULL, - PRIMARY KEY (user_id, address) - );""", - 'CREATE INDEX "ix_user_address_user_id" ON "user_address" USING btree (user_id);', - 'CREATE UNIQUE INDEX "ix_user_address_address" ON "user_address" USING btree (address);', + "postgres": [ + 'ALTER TABLE "email" ADD COLUMN user_id VARCHAR(255);', + 'CREATE INDEX "ix_email_user_id" ON "email" USING btree (user_id);', ], - "mysql": [""" - CREATE TABLE `user_address` ( - user_id VARCHAR(255) NOT NULL, - address VARCHAR(255) NOT NULL, - PRIMARY KEY (user_id, address) - );""", - 'CREATE INDEX `ix_user_address_user_id` ON `user_address` (user_id);', - 'CREATE UNIQUE INDEX `ix_user_address_address` ON `user_address` (address);', + "mysql": [ + 'ALTER TABLE `email` ADD COLUMN user_id VARCHAR(255);', + 'CREATE INDEX `ix_email_user_id` ON `email` (user_id(255));', ], } |