From bd2f4275434bb99880e6659a1a528bd8eec380f4 Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
Date: Thu, 23 Dec 2010 23:14:42 +0000
Subject: added sound cards - part 1

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

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

diff --git a/h-source/tables.sql b/h-source/tables.sql
index 6ec4d72..8d38e81 100644
--- a/h-source/tables.sql
+++ b/h-source/tables.sql
@@ -94,7 +94,8 @@ create table hardware (
 	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'
+	webcam_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
+	sound_card_works varchar(30) CHARACTER SET utf8 not null default 'not-specified'
 )engine=innodb;
 
 create table revisions (
@@ -122,6 +123,7 @@ create table revisions (
 	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',
+	sound_card_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
 	id_hard INT UNSIGNED NOT NULL
 )engine=innodb;
 
-- 
cgit v1.2.3

