From 4477a95a94fad105139927ecb7890dc508ef2f05 Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
Date: Tue, 2 Nov 2010 21:40:43 +0000
Subject: added bios and webcam entries in the notebook category

---
 h-source/tables.sql | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

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

diff --git a/h-source/tables.sql b/h-source/tables.sql
index ae0d1c1..7ecd6d8 100644
--- a/h-source/tables.sql
+++ b/h-source/tables.sql
@@ -91,7 +91,10 @@ create table hardware (
 	deleted char(4) not null default 'no',
 	pci_id char(10) not null,
 	driver varchar(50) not null,
-	interface char(15) not null default 'not-specified'
+	interface char(15) not null default 'not-specified',
+	bios char(15) not null default 'not-specified',
+	webcam_type varchar(100) CHARACTER SET utf8 not null,
+	webcam_works varchar(30) CHARACTER SET utf8 not null default 'not-specified'
 )engine=innodb;
 
 create table revisions (
@@ -116,6 +119,9 @@ create table revisions (
 	pci_id char(10) not null,
 	driver varchar(50) not null,
 	interface char(15) not null default 'not-specified',
+	bios char(15) not null default 'not-specified',
+	webcam_type varchar(100) CHARACTER SET utf8 not null,
+	webcam_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
 	id_hard INT UNSIGNED NOT NULL
 )engine=innodb;
 
-- 
cgit v1.2.3

