diff options
| -rw-r--r-- | h-source/tables.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/h-source/tables.sql b/h-source/tables.sql index 1b6c6f8..1382eb9 100644 --- a/h-source/tables.sql +++ b/h-source/tables.sql @@ -152,7 +152,7 @@ CREATE TABLE IF NOT EXISTS `hardware` ( `ask_for_del` char(4) NOT NULL DEFAULT 'no', `deleted` char(4) NOT NULL DEFAULT 'no', `pci_id` char(10) NOT NULL, - `subtype` char(25) NOT NULL, + `subtype` char(25) NOT NULL DEFAULT 'not-specified', `driver` varchar(50) NOT NULL, `interface` char(15) NOT NULL DEFAULT 'not-specified', `bios` char(20) NOT NULL DEFAULT 'not-specified', @@ -404,7 +404,7 @@ CREATE TABLE IF NOT EXISTS `revisions` ( `comm_year` char(15) NOT NULL, `id_hard` int(10) unsigned NOT NULL, `pci_id` char(10) NOT NULL, - `subtype` char(25) NOT NULL, + `subtype` char(25) NOT NULL DEFAULT 'not-specified', `driver` varchar(50) NOT NULL, `interface` char(15) NOT NULL DEFAULT 'not-specified', `bios` char(20) NOT NULL DEFAULT 'not-specified', |