diff options
Diffstat (limited to 'h-source/tables.sql')
-rw-r--r-- | h-source/tables.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/h-source/tables.sql b/h-source/tables.sql index 08bdfa6..b6914c9 100644 --- a/h-source/tables.sql +++ b/h-source/tables.sql @@ -89,6 +89,7 @@ create table hardware ( comm_year char(15) not null, ask_for_del char(4) not null default 'no', deleted char(4) not null default 'no', + approved char(4) not null default 'yes', pci_id char(10) not null, driver varchar(50) not null, interface char(15) not null default 'not-specified', @@ -132,6 +133,7 @@ create table revisions ( fingerprint_works varchar(30) CHARACTER SET utf8 not null default 'not-specified', architecture char(15) not null default 'not-specified', other_names text CHARACTER SET utf8 not null, + approved char(4) not null default 'yes', id_hard INT UNSIGNED NOT NULL )engine=innodb; |