diff options
Diffstat (limited to 'h-source/tables.sql')
| -rw-r--r-- | h-source/tables.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/h-source/tables.sql b/h-source/tables.sql index f9ef911..08e2b10 100644 --- a/h-source/tables.sql +++ b/h-source/tables.sql @@ -134,7 +134,7 @@ CREATE TABLE IF NOT EXISTS `deletion` ( CREATE TABLE IF NOT EXISTS `hardware` ( `id_hard` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(50) NOT NULL, - `kernel` varchar(50) NOT NULL, + `kernel` varchar(100) NOT NULL, `vendor` varchar(50) NOT NULL, `model` varchar(200) NOT NULL, `created_by` int(11) NOT NULL, @@ -385,7 +385,7 @@ CREATE TABLE IF NOT EXISTS `regusers_groups` ( CREATE TABLE IF NOT EXISTS `revisions` ( `id_rev` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(50) NOT NULL, - `kernel` varchar(50) NOT NULL, + `kernel` varchar(100) NOT NULL, `vendor` varchar(50) NOT NULL, `model` varchar(200) NOT NULL, `created_by` int(11) NOT NULL, @@ -589,6 +589,8 @@ insert into distros (clean_name, full_name, id_order) values ('venenux_0_8_2', ' 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 reggroups (name) values ('admin'); +insert into reggroups (name) values ('moderator'); insert into regusers (username,password) values ('admin',sha1('admin')); |