diff options
author | Antonio Gallo <tonicucoz@gmail.com> | 2011-06-22 14:51:14 +0000 |
---|---|---|
committer | Antonio Gallo <tonicucoz@gmail.com> | 2011-06-22 14:51:14 +0000 |
commit | 34adb20d0ffe996bf454ade33ff02fef70968730 (patch) | |
tree | 2f095b0449a67150469b6baaaebbb67471126f63 /h-source/tables.sql | |
parent | dcbc21e9680c54adc831b71cd1d22d3e680e03b0 (diff) |
anonymous users can now insert devices, automatically set as hidden (to be approved)
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; |