From 34adb20d0ffe996bf454ade33ff02fef70968730 Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
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

