aboutsummaryrefslogtreecommitdiff
path: root/h-source/tables.sql
diff options
context:
space:
mode:
Diffstat (limited to 'h-source/tables.sql')
-rw-r--r--h-source/tables.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/h-source/tables.sql b/h-source/tables.sql
index b6914c9..ba40d5c 100644
--- a/h-source/tables.sql
+++ b/h-source/tables.sql
@@ -90,6 +90,7 @@ create table hardware (
ask_for_del char(4) not null default 'no',
deleted char(4) not null default 'no',
approved char(4) not null default 'yes',
+ cleared char(3) not null default 'no',
pci_id char(10) not null,
driver varchar(50) not null,
interface char(15) not null default 'not-specified',
@@ -134,6 +135,7 @@ create table revisions (
architecture char(15) not null default 'not-specified',
other_names text CHARACTER SET utf8 not null,
approved char(4) not null default 'yes',
+ cleared char(3) not null default 'no',
id_hard INT UNSIGNED NOT NULL
)engine=innodb;