diff options
author | Antonio Gallo <tonicucoz@gmail.com> | 2010-11-02 21:40:43 +0000 |
---|---|---|
committer | Antonio Gallo <tonicucoz@gmail.com> | 2010-11-02 21:40:43 +0000 |
commit | 4477a95a94fad105139927ecb7890dc508ef2f05 (patch) | |
tree | 7b5e3afb592eaef8eb7533f7c3b6920a76272fa0 /h-source/tables.sql | |
parent | 4daafefd0c29440c6fbad2239be2803ad04b92cd (diff) |
added bios and webcam entries in the notebook category
Diffstat (limited to 'h-source/tables.sql')
-rw-r--r-- | h-source/tables.sql | 8 |
1 files changed, 7 insertions, 1 deletions
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; |