diff options
| -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 |