 CREATE TABLE IF NOT EXISTS `users` (
   `id` mediumint(8) NOT NULL AUTO_INCREMENT,
   `name` varchar(80) NOT NULL,
-  `email` varchar(30) NULL,
+  `email` varchar(30) DEFAULT NULL,
   `login` varchar(18) NOT NULL,
-  `password` varchar(40) NOT NULL,
-  `salt` varchar(40) NOT NULL,
+  `password` varchar(60) NOT NULL,
   `last_login` date DEFAULT NULL,
   `active` tinyint(1) NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`)

--

INSERT INTO `permissions` (`id`, `name`, `description`) VALUES
(1, 'admin', 'User is admin.');

-- --------------------------------------------------------


-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `login`, `password`, `last_login`, `active`) VALUES
(1, 'Administrator', 'admin@localhost', 'admin', '$2a$12$SR04o2/JNV5ZoVGZNgPiiezqM2f5D0eVDXsSDoWcfQqg/mST6O6Ye', '2012-08-07', 1);

-- --------------------------------------------------------

