diff options
Diffstat (limited to 'db/install.sql')
| -rw-r--r-- | db/install.sql | 20 |
1 files changed, 4 insertions, 16 deletions
diff --git a/db/install.sql b/db/install.sql index f58cf5b..fbcf340 100644 --- a/db/install.sql +++ b/db/install.sql @@ -1,20 +1,8 @@ CREATE TABLE `author` ( `id` tinyint(4) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, - `name` varchar(64) NOT NULL, - `email` varchar(256) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - -CREATE TABLE `job` ( - `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, - `package_id` smallint(5) UNSIGNED NOT NULL, - `major` tinyint(3) UNSIGNED NOT NULL, - `minor` tinyint(3) UNSIGNED NOT NULL, - `revision` tinyint(3) UNSIGNED NOT NULL, - `time_scheduled` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, - `time_started` datetime DEFAULT NULL, - `time_finished` datetime DEFAULT NULL, - `result_code` tinyint(3) UNSIGNED DEFAULT NULL, - `log` text + `name` varchar(63) NOT NULL, + `email` varchar(255) NOT NULL, + `password` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `package` ( @@ -22,6 +10,7 @@ CREATE TABLE `package` ( `author_id` tinyint(3) UNSIGNED NOT NULL, `name` varchar(63) NOT NULL, `url` varchar(2047) NOT NULL, + `git_url` varchar(2047) NOT NULL, `desc` text NOT NULL, `time_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; @@ -37,7 +26,6 @@ CREATE TABLE `version` ( ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ALTER TABLE `author` - ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name` (`name`); ALTER TABLE `package` |