From 5abe267448ca813f35a6bf9f9e5a08ded732efe3 Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
Date: Wed, 14 May 2014 23:40:22 +0000
Subject: kernel entry can keep 99 characters -- issue 234 submitted by
 goritskov at h-node.org

---
 h-source/tables.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

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

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'));
 
-- 
cgit v1.2.3

