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

(limited to 'h-source/tables.sql')

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 <http://www.gnu.org/licenses/>.
 
--- 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

