From ea0f13c140f6444d4b0da9e38e1c27c9004b6184 Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
Date: Thu, 2 Aug 2012 00:44:36 +0000
Subject: dropped pcmcia controller, added generic host controller with subtype

---
 h-source/tables.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'h-source/tables.sql')

diff --git a/h-source/tables.sql b/h-source/tables.sql
index c757655..31d7643 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(15) NOT NULL,
+  `subtype` char(25) NOT NULL,
   `driver` varchar(50) NOT NULL,
   `interface` char(15) NOT NULL DEFAULT 'not-specified',
   `bios` char(20) NOT NULL DEFAULT 'not-specified',
@@ -401,7 +401,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(15) NOT NULL,
+  `subtype` char(25)) NOT NULL,
   `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

