-- Adminer 3.6.1 MySQL dump

SET NAMES utf8;
SET foreign_key_checks = 0;
SET time_zone = 'SYSTEM';
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `container`;
CREATE TABLE `container` (
  `id` INT(5) NOT NULL AUTO_INCREMENT,
  `number` INT(11) NOT NULL,
  `type` tinyint(1) NOT NULL,
  `user_id` INT(11) DEFAULT NULL,
  `last_transfer` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `damage` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
  `usable` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `container_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `login` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
  `password` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `new_password` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `authorized_person` VARCHAR(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company` VARCHAR(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `shortcut` VARCHAR(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `street` VARCHAR(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` VARCHAR(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` VARCHAR(7) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mobil` VARCHAR(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ico` VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `role` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'customer-unauthorized',
  `registred` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_logged` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


-- 2012-11-15 11:33:44