From 51c194e1c1ba0c5beadcf1e72187894a177d1b71 Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
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

