diff options
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));', ], } |