diff options
author | Antonio Gallo <tonicucoz@gmail.com> | 2012-04-16 22:52:11 +0000 |
---|---|---|
committer | Antonio Gallo <tonicucoz@gmail.com> | 2012-04-16 22:52:11 +0000 |
commit | db7760c0b06f55f3a6219fcb44f27b9d92a15285 (patch) | |
tree | b526bb689d23a8f61825e65e8a32f1320fba27bd /h-source | |
parent | 34ef73728b467487cdc405fa61785ed8b4f180af (diff) |
modified tables.sql, added the vendors table. First step to move the vendors list to the db
Diffstat (limited to 'h-source')
-rw-r--r-- | h-source/tables.sql | 25 |
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 |