diff options
| author | Antonio Gallo <tonicucoz@gmail.com> | 2012-04-16 23:07:50 +0000 |
|---|---|---|
| committer | Antonio Gallo <tonicucoz@gmail.com> | 2012-04-16 23:07:50 +0000 |
| commit | 51c194e1c1ba0c5beadcf1e72187894a177d1b71 (patch) | |
| tree | 6c3a9c3ecfe1f5733a85f1fe0a6363dbda38cf64 | |
| parent | db7760c0b06f55f3a6219fcb44f27b9d92a15285 (diff) | |
modified tables.sql
| -rw-r--r-- | h-source/tables.sql | 5 |
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 |