From 51c194e1c1ba0c5beadcf1e72187894a177d1b71 Mon Sep 17 00:00:00 2001 From: Antonio Gallo Date: Mon, 16 Apr 2012 23:07:50 +0000 Subject: modified tables.sql --- h-source/tables.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'h-source/tables.sql') diff --git a/h-source/tables.sql b/h-source/tables.sql index 0d8dbe3..2f9ea7c 100644 --- a/h-source/tables.sql +++ b/h-source/tables.sql @@ -544,8 +544,9 @@ create table vendors ( id_vendor INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, creation_date timestamp default CURRENT_TIMESTAMP, update_date datetime NOT NULL, - vendorid SMALLINT UNSIGNED not null, + vendorid CHAR(4) not null, clean_name varchar(200) CHARACTER SET utf8 not null, full_name varchar(200) CHARACTER SET utf8 not null, - bus ENUM('pci', 'usb') + bus ENUM('pci', 'usb'), + unique(bus,vendorid) )engine=innodb; \ No newline at end of file -- cgit v1.2.3