diff options
Diffstat (limited to 'h-source/tables.sql')
| -rw-r--r-- | h-source/tables.sql | 4 |
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; |