| 1 | DROP TABLE IF EXISTS `versions`;
|
| 2 | CREATE TABLE `versions` (
|
| 3 | `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
| 4 | `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1.DBversion',
|
| 5 | `version` varchar(10) NOT NULL DEFAULT '',
|
| 6 | PRIMARY KEY (`id`),
|
| 7 | UNIQUE KEY `udx_type` (`type`)
|
| 8 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
| 9 |
|
| 10 | LOCK TABLES `versions` WRITE;
|
| 11 | INSERT INTO `versions` (`id`, `type`, `version`)
|
| 12 | VALUES
|
| 13 | (1,1,'0.2.14');
|
| 14 | UNLOCK TABLES;
|
| 15 |
|
| 16 | ALTER TABLE `packages` ADD `is_mandatory` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
|