DROP TABLE IF EXISTS `Users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Users` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `username` varchar(100) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `password` varchar(100) DEFAULT NULL, `employee` bigint(20) DEFAULT NULL, `default_module` bigint(20) DEFAULT NULL, `user_level` enum('Admin','Employee','Manager','Other') DEFAULT NULL, `user_roles` text, `last_login` datetime DEFAULT NULL, `last_update` datetime DEFAULT NULL, `created` datetime DEFAULT NULL, `login_hash` varchar(64) DEFAULT NULL, `lang` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), KEY `Fk_User_Employee` (`employee`), KEY `Fk_User_SupportedLanguages` (`lang`), KEY `login_hash_index` (`login_hash`), CONSTRAINT `Fk_User_Employee` FOREIGN KEY (`employee`) REFERENCES `Employees` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `Fk_User_SupportedLanguages` FOREIGN KEY (`lang`) REFERENCES `SupportedLanguages` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Users` -- LOCK TABLES `Users` WRITE; /*!40000 ALTER TABLE `Users` DISABLE KEYS */; INSERT INTO `Users` VALUES (1,'admin','icehrm+admin@web-stalk.com','21232f297a57a5a743894a0e4a801fc3',1,NULL,'Admin','',NULL,NULL,NULL,NULL,NULL),(2,'manager','icehrm+manager@web-stalk.com','4048bb914a704a0728549a26b92d8550',2,NULL,'Manager','','2013-01-03 02:47:37','2013-01-03 02:47:37','2013-01-03 02:47:37',NULL,NULL),(3,'user1','icehrm+user1@web-stalk.com','4048bb914a704a0728549a26b92d8550',3,NULL,'Employee','','2013-01-03 02:48:32','2013-01-03 02:48:32','2013-01-03 02:48:32',NULL,NULL),(4,'user2','icehrm+user2@web-stalk.com','4048bb914a704a0728549a26b92d8550',4,NULL,'Employee','','2013-01-03 02:58:55','2013-01-03 02:58:55','2013-01-03 02:58:55',NULL,NULL),(5,'user3','icehrm+user3@web-stalk.com','4048bb914a704a0728549a26b92d8550',NULL,NULL,'Other','["1"]','2013-01-03 02:58:55','2013-01-03 02:58:55','2013-01-03 02:58:55',NULL,NULL); /*!40000 ALTER TABLE `Users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;