diff options
author | Antonio Gallo <tonicucoz@gmail.com> | 2013-10-15 19:25:31 +0000 |
---|---|---|
committer | Antonio Gallo <tonicucoz@gmail.com> | 2013-10-15 19:25:31 +0000 |
commit | af80b967213a02fc9cd39dbddbdb2ac582b00200 (patch) | |
tree | 3f54abef1eca38b1ac129029f443d77651bdeef3 /h-source/tables.sql | |
parent | a93461b231fb94f3a6a9df09a30557732201ddcc (diff) |
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
Diffstat (limited to 'h-source/tables.sql')
-rw-r--r-- | h-source/tables.sql | 46 |
1 files changed, 26 insertions, 20 deletions
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 |