From 0b3fb764b2e67d771021d47447121a8836198fd5 Mon Sep 17 00:00:00 2001 From: Magnus Granberg Date: Sun, 31 Jan 2016 19:32:34 +0100 Subject: split build_logs_repoman_qa to repoman and qa --- sql/structure_dump.sql | 37 ++++++++++++++++++++++++++++++------- 1 file changed, 30 insertions(+), 7 deletions(-) (limited to 'sql') diff --git a/sql/structure_dump.sql b/sql/structure_dump.sql index 194c8ee..9c2f397 100644 --- a/sql/structure_dump.sql +++ b/sql/structure_dump.sql @@ -3,7 +3,7 @@ -- http://www.phpmyadmin.net -- -- Host: localhost --- Generation Time: Jan 31, 2016 at 01:39 PM +-- Generation Time: Jan 31, 2016 at 06:07 PM -- Server version: 10.0.22-MariaDB-log -- PHP Version: 5.6.16-pl0-gentoo @@ -173,10 +173,22 @@ CREATE TABLE IF NOT EXISTS `build_logs_hilight` ( -- -------------------------------------------------------- -- --- Table structure for table `build_logs_repoman_qa` +-- Table structure for table `build_logs_qa` -- -CREATE TABLE IF NOT EXISTS `build_logs_repoman_qa` ( +CREATE TABLE IF NOT EXISTS `build_logs_qa` ( +`id` int(11) NOT NULL, + `build_log_id` int(11) NOT NULL, + `summery_text` text NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `build_logs_repoman` +-- + +CREATE TABLE IF NOT EXISTS `build_logs_repoman` ( `id` int(11) NOT NULL, `build_log_id` int(11) NOT NULL, `summery_text` text NOT NULL @@ -607,9 +619,15 @@ ALTER TABLE `build_logs_hilight` ADD PRIMARY KEY (`id`), ADD KEY `log_id` (`log_id`), ADD KEY `hilight_id` (`hilight_css_id`), ADD KEY `hilight_css_id` (`hilight_css_id`); -- --- Indexes for table `build_logs_repoman_qa` +-- Indexes for table `build_logs_qa` +-- +ALTER TABLE `build_logs_qa` + ADD PRIMARY KEY (`id`), ADD KEY `build_logs_id` (`build_log_id`); + +-- +-- Indexes for table `build_logs_repoman` -- -ALTER TABLE `build_logs_repoman_qa` +ALTER TABLE `build_logs_repoman` ADD PRIMARY KEY (`id`), ADD KEY `build_logs_id` (`build_log_id`); -- @@ -830,9 +848,14 @@ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `build_logs_hilight` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- --- AUTO_INCREMENT for table `build_logs_repoman_qa` +-- AUTO_INCREMENT for table `build_logs_qa` +-- +ALTER TABLE `build_logs_qa` +MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; +-- +-- AUTO_INCREMENT for table `build_logs_repoman` -- -ALTER TABLE `build_logs_repoman_qa` +ALTER TABLE `build_logs_repoman` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `build_logs_use` -- cgit v1.2.3-65-gdbad