Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS `groups`;
- #
- # Table structure for table 'groups'
- #
- CREATE TABLE `groups` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(20) NOT NULL,
- `description` varchar(100) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- #
- # Dumping data for table 'groups'
- #
- INSERT INTO `groups` (`id`, `name`, `description`) VALUES
- (1,'admin','Administrator'),
- (2,'members','User');
- DROP TABLE IF EXISTS `users`;
- #
- # Table structure for table 'users'
- #
- CREATE TABLE `users` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `ip_address` varchar(45) NOT NULL,
- `username` varchar(100) NULL,
- `password` varchar(255) NOT NULL,
- `email` varchar(254) NOT NULL,
- `activation_selector` varchar(255) DEFAULT NULL,
- `activation_code` varchar(255) DEFAULT NULL,
- `forgotten_password_selector` varchar(255) DEFAULT NULL,
- `forgotten_password_code` varchar(255) DEFAULT NULL,
- `forgotten_password_time` int(11) unsigned DEFAULT NULL,
- `remember_selector` varchar(255) DEFAULT NULL,
- `remember_code` varchar(255) DEFAULT NULL,
- `created_on` int(11) unsigned NOT NULL,
- `last_login` int(11) unsigned DEFAULT NULL,
- `active` tinyint(1) unsigned DEFAULT NULL,
- `first_name` varchar(50) DEFAULT NULL,
- `last_name` varchar(50) DEFAULT NULL,
- `company` varchar(100) DEFAULT NULL,
- `phone` varchar(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- CONSTRAINT `uc_email` UNIQUE (`email`),
- CONSTRAINT `uc_activation_selector` UNIQUE (`activation_selector`),
- CONSTRAINT `uc_forgotten_password_selector` UNIQUE (`forgotten_password_selector`),
- CONSTRAINT `uc_remember_selector` UNIQUE (`remember_selector`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- #
- # Dumping data for table 'users'
- #
- INSERT INTO `users` (`id`, `ip_address`, `username`, `password`, `email`, `activation_code`, `forgotten_password_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`) VALUES
- ('1','127.0.0.1','administrator','$2y$08$2qZbp3RAEXohqTUi00ZaWcMA6uJOFicwNZa4oD6ZFXFek63MG.Daa','admin@admin.com','',NULL,'1268889823','1268889823','1', 'Admin','istrator','ADMIN','0');
- DROP TABLE IF EXISTS `meta_users`;
- #
- # Table structure for table 'meta_users'
- #
- CREATE TABLE `meta_users` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` int(11) unsigned NOT NULL COMMENT 'ID пользователя',
- `category_interest` varchar(20) DEFAULT NULL COMMENT 'Что вас интересует',
- `city_job_wishes` varchar(20) DEFAULT NULL COMMENT 'В каких городах вы хотели бы работать',
- `sphere_interest` varchar(20) DEFAULT NULL COMMENT 'Какие сферы интересны',
- `company_interest` varchar(20) DEFAULT NULL COMMENT 'Работа в каких компаниях интересна',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `users_groups`;
- #
- # Table structure for table 'users_groups'
- #
- CREATE TABLE `users_groups` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` int(11) unsigned NOT NULL,
- `group_id` mediumint(8) unsigned NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_users_groups_users1_idx` (`user_id`),
- KEY `fk_users_groups_groups1_idx` (`group_id`),
- CONSTRAINT `uc_users_groups` UNIQUE (`user_id`, `group_id`),
- CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES
- (1,1,1),
- (2,1,2);
- DROP TABLE IF EXISTS `login_attempts`;
- #
- # Table structure for table 'login_attempts'
- #
- CREATE TABLE `login_attempts` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `ip_address` varchar(45) NOT NULL,
- `login` varchar(100) NOT NULL,
- `time` int(11) unsigned DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `category`;
- #
- # Table structure for table 'category'
- #
- CREATE TABLE `category` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(200) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `company`;
- #
- # Table structure for table 'company'
- #
- CREATE TABLE `company` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(200) DEFAULT NULL,
- `logo` varchar(20) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `city`;
- #
- # Table structure for table 'city'
- #
- CREATE TABLE `city` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(200) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `sphere`;
- #
- # Table structure for table 'sphere'
- #
- CREATE TABLE `sphere` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(200) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `events`;
- #
- # Table structure for table 'events'
- #
- CREATE TABLE IF NOT EXISTS `events` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `category` int(11) unsigned NOT NULL COMMENT 'Категория',
- `name` text NOT NULL COMMENT 'Наименование',
- `company` int(11) unsigned NOT NULL COMMENT 'Компания',
- `city` int(11) unsigned NOT NULL COMMENT'Город',
- `request_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Подача заявок c',
- `request_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Подача заявок до',
- `event_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Провед-е с',
- `event_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Провед-е до',
- `sphere` int(11) unsigned NOT NULL COMMENT 'сфера',
- `additional` text NOT NULL DEFAULT '' COMMENT 'Дополнительное поле',
- PRIMARY KEY (`id`),
- UNIQUE KEY `id` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement