From 34adb20d0ffe996bf454ade33ff02fef70968730 Mon Sep 17 00:00:00 2001 From: Antonio Gallo Date: Wed, 22 Jun 2011 14:51:14 +0000 Subject: anonymous users can now insert devices, automatically set as hidden (to be approved) --- h-source/tables.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'h-source/tables.sql') 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; -- cgit v1.2.3