aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDamien Zammit <damien@zamaudio.com>2021-08-03 17:28:06 +1000
committerDamien Zammit <damien@zamaudio.com>2021-08-03 17:47:37 +1000
commitb94da099f104e374b9d216340094231ba13840b2 (patch)
treeafa2892968761963afbe7efb0f974edf395b0af1
parent971cf0eec13c21e9ff4d2d143c1a148a95b31e0c (diff)
Update tables.sql to match h-node schema dump
-rw-r--r--h-source/tables.sql4
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',