kernel entry can keep 99 characters -- issue 234 submitted by goritskov at h-node.org

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'));