aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAntonio Gallo <tonicucoz@gmail.com>2012-04-16 22:52:11 +0000
committerAntonio Gallo <tonicucoz@gmail.com>2012-04-16 22:52:11 +0000
commitdb7760c0b06f55f3a6219fcb44f27b9d92a15285 (patch)
treeb526bb689d23a8f61825e65e8a32f1320fba27bd
parent34ef73728b467487cdc405fa61785ed8b4f180af (diff)
modified tables.sql, added the vendors table. First step to move the vendors list to the db
-rw-r--r--h-source/tables.sql25
1 files 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 <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