GMh8pF5J

1ALTER TABLE collections
2    CHANGE COLUMN  `password` `password` varchar(255) NULL;
3ALTER TABLE addons_collections
4    ADD COLUMN `ordering` int(11) UNSIGNED NOT NULL DEFAULT 0;
5ALTER TABLE collections
6    ADD COLUMN `addon_index` varchar(40) NULL,
7    ADD COLUMN `recommended_collection_id` int(11) unsigned NULL,
8    ADD FOREIGN KEY (`recommended_collection_id`) REFERENCES `collections` (`id`);
9
10CREATE INDEX `collections_addon_index` ON `collections` (`addon_index`);
11DROP TABLE IF EXISTS `collections_tokens`;
12CREATE TABLE `collections_tokens` (
13    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
14    `created` datetime NOT NULL,
15    `modified` datetime NOT NULL,
16    `collection_id` integer NOT NULL,
17    `token` varchar(255) NOT NULL UNIQUE
18)
19;
20ALTER TABLE `collections_tokens` ADD CONSTRAINT `collection_id_refs_id_2d03c093` FOREIGN KEY (`collection_id`) REFERENCES `collections` (`id`);
21CREATE TABLE `discovery_modules` (
22    `id` int(11) UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
23    `created` datetime NOT NULL,
24    `modified` datetime NOT NULL,
25    `app_id` integer NOT NULL,
26    `module` varchar(255) NOT NULL,
27    `ordering` integer,
28    `locales` varchar(255) NOT NULL
29);
30ALTER TABLE auth_user
31    CHANGE COLUMN username `username` varchar(255) NOT NULL UNIQUE,
32    CHANGE COLUMN first_name `first_name` varchar(255) NOT NULL,
33    CHANGE COLUMN last_name `last_name` varchar(255) NOT NULL,
34    CHANGE COLUMN email `email` varchar(255) NOT NULL UNIQUE;
35UPDATE schema_version SET version=32;