aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAntonio Gallo <tonicucoz@gmail.com>2012-04-16 23:07:50 +0000
committerAntonio Gallo <tonicucoz@gmail.com>2012-04-16 23:07:50 +0000
commit51c194e1c1ba0c5beadcf1e72187894a177d1b71 (patch)
tree6c3a9c3ecfe1f5733a85f1fe0a6363dbda38cf64
parentdb7760c0b06f55f3a6219fcb44f27b9d92a15285 (diff)
modified tables.sql
-rw-r--r--h-source/tables.sql5
1 files changed, 3 insertions, 2 deletions
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