Update migration script.

kiwiz · kiwiz · commit 5c753031942e · 2016-10-06T21:13:03.000-04:00
Create new index after generating api_keys for all users.
diff --git a/bin/migration.php b/bin/migration.php
@@ -45,12 +45,12 @@ function ver_cmp($a, $b) {
 }
 
 if(ver_cmp($old_ver, '1.1.0') < 0) {
-    // FOO\DB::query('ALTER TABLE `users` ADD COLUMN `api_key` VARCHAR(255) NOT NULL DEFAULT ""');
-    FOO\DB::query('CREATE UNIQUE INDEX `users_site_id_api_key_idx` ON `users`(`site_id`, `api_key`);');
+    FOO\DB::query('ALTER TABLE `users` ADD COLUMN `api_key` VARCHAR(255) NOT NULL DEFAULT ""');
     $user_ids = FOO\DB::query('SELECT user_id FROM users', [], FOO\DB::COL);
     foreach($user_ids as $user_id) {
         FOO\DB::query('UPDATE `users` SET `api_key`=? WHERE `user_id`=?', [FOO\Random::base64_bytes(FOO\User::API_KEY_LEN), $user_id]);
     }
+    FOO\DB::query('CREATE UNIQUE INDEX `users_site_id_api_key_idx` ON `users`(`site_id`, `api_key`);');
 }
 
 /**

Original file line number	Diff line number	Diff line change
`@@ -45,12 +45,12 @@ function ver_cmp($a, $b) {`
`45`	`45`	`}`
`46`	`46`
`47`	`47`	`if(ver_cmp($old_ver, '1.1.0') < 0) {`
`48`		- // FOO\DB::query('ALTER TABLE `users` ADD COLUMN `api_key` VARCHAR(255) NOT NULL DEFAULT ""');
`49`		- FOO\DB::query('CREATE UNIQUE INDEX `users_site_id_api_key_idx` ON `users`(`site_id`, `api_key`);');
	`48`	+ FOO\DB::query('ALTER TABLE `users` ADD COLUMN `api_key` VARCHAR(255) NOT NULL DEFAULT ""');
`50`	`49`	`$user_ids = FOO\DB::query('SELECT user_id FROM users', [], FOO\DB::COL);`
`51`	`50`	`foreach($user_ids as $user_id) {`
`52`	`51`	FOO\DB::query('UPDATE `users` SET `api_key`=? WHERE `user_id`=?', [FOO\Random::base64_bytes(FOO\User::API_KEY_LEN), $user_id]);
`53`	`52`	`}`
	`53`	+ FOO\DB::query('CREATE UNIQUE INDEX `users_site_id_api_key_idx` ON `users`(`site_id`, `api_key`);');
`54`	`54`	`}`
`55`	`55`
`56`	`56`	`/**`