aboutsummaryrefslogtreecommitdiff
path: root/h-source/tables.sql
diff options
context:
space:
mode:
authorAntonio Gallo <tonicucoz@gmail.com>2011-07-13 15:28:30 +0000
committerAntonio Gallo <tonicucoz@gmail.com>2011-07-13 15:28:30 +0000
commitd8e1f81df2e40574c0e685910bf99407f7e66017 (patch)
treea69b5a96dff0f22a37db460d5fb2d88ff49650ec /h-source/tables.sql
parentbe1d2d6c4c5623c6af59cf72e74e0335d1aa6cb5 (diff)
administrators can permanently delete a device page - part 1
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;