| 1 | ALTER TABLE `apps` ADD `os` TINYINT UNSIGNED NOT NULL DEFAULT 0;
|
| 2 | ALTER TABLE `apps` ADD `platform` TINYINT UNSIGNED NOT NULL DEFAULT 0;
|
| 3 | ALTER TABLE `packages` ADD `is_disabled` TINYINT UNSIGNED NOT NULL DEFAULT 0;
|
| 4 | ALTER TABLE `packages` ADD `rollout` TINYINT UNSIGNED NOT NULL DEFAULT 100;
|
| 5 |
|
| 6 | CREATE TABLE `log_report_deploy` (
|
| 7 | `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
| 8 | `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
| 9 | `package_id` int(10) unsigned NOT NULL DEFAULT '0',
|
| 10 | `client_unique_id` varchar(100) NOT NULL DEFAULT '',
|
| 11 | `previous_label` varchar(20) NOT NULL DEFAULT '',
|
| 12 | `previous_deployment_key` varchar(64) NOT NULL DEFAULT '',
|
| 13 | `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
| 14 | PRIMARY KEY (`id`)
|
| 15 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
| 16 |
|
| 17 | CREATE TABLE `log_report_download` (
|
| 18 | `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
| 19 | `package_id` int(10) unsigned NOT NULL DEFAULT '0',
|
| 20 | `client_unique_id` varchar(100) NOT NULL DEFAULT '',
|
| 21 | `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
| 22 | PRIMARY KEY (`id`)
|
| 23 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
| 24 |
|
| 25 | UPDATE `versions` SET `version` = '0.3.0' WHERE `type` = '1'; |
| \ | No newline at end of file |