aboutsummaryrefslogtreecommitdiff
path: root/h-source/tables.sql
diff options
context:
space:
mode:
authorAntonio Gallo <tonicucoz@gmail.com>2011-04-18 16:09:47 +0000
committerAntonio Gallo <tonicucoz@gmail.com>2011-04-18 16:09:47 +0000
commit931861e0513be7e110fc1d98e366cbd4efb831ce (patch)
tree9cb3bf844f5edc60f06d19da53334126d01d3c52 /h-source/tables.sql
parent1614aa5cb29b3abbe59b45760d4cedf3b2183fa8 (diff)
h-source:added acquisition cards and fingerprint readers - 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 e914867..34c8ab9 100644
--- a/h-source/tables.sql
+++ b/h-source/tables.sql
@@ -96,7 +96,8 @@ create table hardware (
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',
- bluetooth_works varchar(30) CHARACTER SET utf8 not null default 'not-specified'
+ bluetooth_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
+ fingerprint_works varchar(30) CHARACTER SET utf8 not null default 'not-specified'
)engine=innodb;
create table revisions (
@@ -126,6 +127,7 @@ create table revisions (
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',
bluetooth_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
+ fingerprint_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
id_hard INT UNSIGNED NOT NULL
)engine=innodb;