From b94da099f104e374b9d216340094231ba13840b2 Mon Sep 17 00:00:00 2001 From: Damien Zammit Date: Tue, 3 Aug 2021 17:28:06 +1000 Subject: Update tables.sql to match h-node schema dump --- h-source/tables.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'h-source') 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', -- cgit v1.2.3