diff options
| author | Damien Zammit <damien@zamaudio.com> | 2021-08-03 17:28:06 +1000 |
|---|---|---|
| committer | Damien Zammit <damien@zamaudio.com> | 2021-08-03 17:47:37 +1000 |
| commit | b94da099f104e374b9d216340094231ba13840b2 (patch) | |
| tree | afa2892968761963afbe7efb0f974edf395b0af1 | |
| parent | 971cf0eec13c21e9ff4d2d143c1a148a95b31e0c (diff) | |
Update tables.sql to match h-node schema dump
| -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', |