From db7760c0b06f55f3a6219fcb44f27b9d92a15285 Mon Sep 17 00:00:00 2001 From: Antonio Gallo Date: Mon, 16 Apr 2012 22:52:11 +0000 Subject: modified tables.sql, added the vendors table. First step to move the vendors list to the db --- h-source/tables.sql | 25 +++++++++++-------------- 1 file changed, 11 insertions(+), 14 deletions(-) diff --git a/h-source/tables.sql b/h-source/tables.sql index cfd1379..0d8dbe3 100644 --- a/h-source/tables.sql +++ b/h-source/tables.sql @@ -16,24 +16,10 @@ -- You should have received a copy of the GNU General Public License -- along with h-source. If not, see . --- phpMyAdmin SQL Dump --- version 3.3.9.2 --- http://www.phpmyadmin.net --- --- Host: localhost --- Generation Time: Feb 11, 2012 at 11:26 AM --- Server version: 5.1.41 --- PHP Version: 5.3.2-1ubuntu4.13 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; - - -- -------------------------------------------------------- -- @@ -552,3 +538,14 @@ ALTER TABLE `regusers_groups` ALTER TABLE `wiki_users` ADD CONSTRAINT `wiki_users_ibfk_1` FOREIGN KEY (`id_wiki`) REFERENCES `wiki` (`id_wiki`), ADD CONSTRAINT `wiki_users_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `regusers` (`id_user`); + + +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, + clean_name varchar(200) CHARACTER SET utf8 not null, + full_name varchar(200) CHARACTER SET utf8 not null, + bus ENUM('pci', 'usb') +)engine=innodb; \ No newline at end of file -- cgit v1.2.3