aboutsummaryrefslogtreecommitdiff
path: root/h-source/tables.sql
diff options
context:
space:
mode:
authorAntonio Gallo <tonicucoz@gmail.com>2010-12-23 23:14:42 +0000
committerAntonio Gallo <tonicucoz@gmail.com>2010-12-23 23:14:42 +0000
commitbd2f4275434bb99880e6659a1a528bd8eec380f4 (patch)
tree7394de7942ef4791b066a03ab412c674fdbf4ba5 /h-source/tables.sql
parent58214267999e01688b9d885dbf5fe02f14b3be8e (diff)
added sound cards - part 1
Diffstat (limited to 'h-source/tables.sql')
-rw-r--r--h-source/tables.sql4
1 files changed, 3 insertions, 1 deletions
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;