From af80b967213a02fc9cd39dbddbdb2ac582b00200 Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
Date: Tue, 15 Oct 2013 19:25:31 +0000
Subject: added the ManagerController and the manager users group. Now the
 users in the manager group can modify the list of allowed distros by means of
 the main panel

---
 h-source/tables.sql | 46 ++++++++++++++++++++++++++--------------------
 1 file changed, 26 insertions(+), 20 deletions(-)

(limited to 'h-source/tables.sql')

diff --git a/h-source/tables.sql b/h-source/tables.sql
index a695600..f9ef911 100644
--- a/h-source/tables.sql
+++ b/h-source/tables.sql
@@ -33,7 +33,7 @@ CREATE TABLE IF NOT EXISTS `accesses` (
   `ora` char(8) NOT NULL,
   `username` varchar(30) NOT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=650 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -46,7 +46,7 @@ CREATE TABLE IF NOT EXISTS `admingroups` (
   `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   PRIMARY KEY (`id_group`),
   UNIQUE KEY `name` (`name`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -78,7 +78,7 @@ CREATE TABLE IF NOT EXISTS `adminusers` (
   PRIMARY KEY (`id_user`),
   UNIQUE KEY `username` (`username`),
   KEY `username_2` (`username`,`password`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -106,7 +106,7 @@ CREATE TABLE IF NOT EXISTS `boxes` (
   `title` varchar(150) NOT NULL,
   `message` text NOT NULL,
   PRIMARY KEY (`id_box`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -123,7 +123,7 @@ CREATE TABLE IF NOT EXISTS `deletion` (
   `id_hard` int(10) unsigned NOT NULL,
   `id_duplicate` int(10) unsigned NOT NULL,
   PRIMARY KEY (`id_del`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -171,7 +171,7 @@ CREATE TABLE IF NOT EXISTS `hardware` (
   `it_tracks_users` varchar(30) NOT NULL DEFAULT 'not-specified',
   `prevent_wifi` char(20) NOT NULL DEFAULT 'not-specified',
   PRIMARY KEY (`id_hard`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=503 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -203,7 +203,7 @@ CREATE TABLE IF NOT EXISTS `history` (
   `message` text NOT NULL,
   `gr` char(15) NOT NULL,
   PRIMARY KEY (`id_history`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1367 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;
 
 -- --------------------------------------------------------
 
@@ -224,7 +224,7 @@ CREATE TABLE IF NOT EXISTS `issues` (
   `notice` text NOT NULL,
   `deleted` char(4) NOT NULL DEFAULT 'no',
   PRIMARY KEY (`id_issue`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=106 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -241,7 +241,7 @@ CREATE TABLE IF NOT EXISTS `messages` (
   `deleted` char(4) NOT NULL DEFAULT 'no',
   `has_read` char(4) NOT NULL DEFAULT 'no',
   PRIMARY KEY (`id_mes`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=342 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -255,7 +255,7 @@ CREATE TABLE IF NOT EXISTS `news` (
   `title` varchar(150) NOT NULL,
   `message` text NOT NULL,
   PRIMARY KEY (`id_news`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -268,7 +268,7 @@ CREATE TABLE IF NOT EXISTS `params` (
   `updating` char(4) NOT NULL DEFAULT 'no',
   `boxes_xml` text NOT NULL,
   PRIMARY KEY (`id_par`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;
 
 -- --------------------------------------------------------
 
@@ -291,7 +291,7 @@ CREATE TABLE IF NOT EXISTS `profile` (
   `website` varchar(100) NOT NULL,
   `send_notification` char(4) NOT NULL DEFAULT 'yes',
   PRIMARY KEY (`id_prof`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=330 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -306,7 +306,7 @@ CREATE TABLE IF NOT EXISTS `regaccesses` (
   `ora` char(8) NOT NULL,
   `username` varchar(30) NOT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3529 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
 
 -- --------------------------------------------------------
 
@@ -319,7 +319,7 @@ CREATE TABLE IF NOT EXISTS `reggroups` (
   `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   PRIMARY KEY (`id_group`),
   UNIQUE KEY `name` (`name`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;
 
 -- --------------------------------------------------------
 
@@ -360,7 +360,7 @@ CREATE TABLE IF NOT EXISTS `regusers` (
   PRIMARY KEY (`id_user`),
   UNIQUE KEY `username` (`username`),
   KEY `username_2` (`username`,`password`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=463 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;
 
 -- --------------------------------------------------------
 
@@ -421,7 +421,7 @@ CREATE TABLE IF NOT EXISTS `revisions` (
   `it_tracks_users` varchar(30) NOT NULL DEFAULT 'not-specified',
   `prevent_wifi` char(20) NOT NULL DEFAULT 'not-specified',
   PRIMARY KEY (`id_rev`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=627 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -438,7 +438,7 @@ CREATE TABLE IF NOT EXISTS `talk` (
   `id_hard` int(10) unsigned NOT NULL,
   `deleted` char(4) NOT NULL DEFAULT 'no',
   PRIMARY KEY (`id_talk`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=259 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -458,7 +458,7 @@ CREATE TABLE IF NOT EXISTS `wiki` (
   `blocked` char(3) NOT NULL DEFAULT 'no',
   `is_main` char(3) NOT NULL DEFAULT 'no',
   PRIMARY KEY (`id_wiki`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -476,7 +476,7 @@ CREATE TABLE IF NOT EXISTS `wiki_revisions` (
   `page` text NOT NULL,
   `id_wiki` int(10) unsigned NOT NULL,
   PRIMARY KEY (`id_rev`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=252 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -493,7 +493,7 @@ CREATE TABLE IF NOT EXISTS `wiki_talk` (
   `id_wiki` int(10) unsigned NOT NULL,
   `deleted` char(4) NOT NULL DEFAULT 'no',
   PRIMARY KEY (`id_talk`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -587,3 +587,9 @@ insert into distros (clean_name, full_name, id_order) values ('ututo_xs_2012_04'
 insert into distros (clean_name, full_name, id_order) values ('venenux_0_8', 'VENENUX 0.8', 23);
 insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 24);
 insert into distros (clean_name, full_name, id_order) values ('venenux_0_9', 'VENENUX 0.9', 25);
+
+insert into reggroups (name) values ('manager');
+
+insert into regusers (username,password) values ('admin',sha1('admin'));
+
+insert into regusers_groups (id_user, id_group) values (1,1);
\ No newline at end of file
-- 
cgit v1.2.3

