Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.0.10deb1
- -- http://www.phpmyadmin.net
- --
- -- Hostiteľ: localhost
- -- Vygenerované: Št 09.Okt 2014, 14:54
- -- Verzia serveru: 5.5.38-0ubuntu0.14.04.1
- -- Verzia PHP: 5.5.9-1ubuntu4.4
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Databáza: `pce`
- --
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users`
- --
- CREATE TABLE IF NOT EXISTS `users` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `username` VARCHAR(50) NOT NULL,
- `password` VARCHAR(255) NOT NULL,
- `group_id` INT(11) NOT NULL DEFAULT '1',
- `email` VARCHAR(255) NOT NULL,
- `last_login` VARCHAR(25) NOT NULL,
- `previous_login` VARCHAR(25) NOT NULL DEFAULT '0',
- `login_hash` VARCHAR(255) NOT NULL,
- `user_id` INT(11) NOT NULL DEFAULT '0',
- `created_at` INT(11) NOT NULL DEFAULT '0',
- `updated_at` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `username` (`username`,`email`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
- --
- -- Sťahujem dáta pre tabuľku `users`
- --
- INSERT INTO `users` (`id`, `username`, `password`, `group_id`, `email`, `last_login`, `previous_login`, `login_hash`, `user_id`, `created_at`, `updated_at`) VALUES
- (1, 'admin', 'XAcYWOzrxLD6EkwsdhnCtlWmxTDD9cqkWPmz2HU9MbY=', 5, 'admin@example.org', '0', '0', '', 0, 1411286919, 1411297383),
- (2, 'sveatlo', 'FGTCGFUBeyQMQGH/p/1dHWC6NZnsirhoY+TjWs3ZrwM=', 5, 'svatoplukhanzel@gmail.com', '1412858094', '1412858043', 'c6ff9f44db76267cb7a805afde0cb23af1c05cfa', 2, 1411296942, 1412858094),
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_clients`
- --
- CREATE TABLE IF NOT EXISTS `users_clients` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(32) NOT NULL DEFAULT '',
- `client_id` VARCHAR(32) NOT NULL DEFAULT '',
- `client_secret` VARCHAR(32) NOT NULL DEFAULT '',
- `redirect_uri` VARCHAR(255) NOT NULL DEFAULT '',
- `auto_approve` tinyint(1) NOT NULL DEFAULT '0',
- `autonomous` tinyint(1) NOT NULL DEFAULT '0',
- `status` enum('development','pending','approved','rejected') NOT NULL DEFAULT 'development',
- `suspended` tinyint(1) NOT NULL DEFAULT '0',
- `notes` tinytext NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `client_id` (`client_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_groups`
- --
- CREATE TABLE IF NOT EXISTS `users_groups` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) NOT NULL,
- `user_id` INT(11) NOT NULL DEFAULT '0',
- `created_at` INT(11) NOT NULL DEFAULT '0',
- `updated_at` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
- --
- -- Sťahujem dáta pre tabuľku `users_groups`
- --
- INSERT INTO `users_groups` (`id`, `name`, `user_id`, `created_at`, `updated_at`) VALUES
- (1, 'Banned', 0, 0, 0),
- (2, 'Customers', 0, 0, 0),
- (3, 'Technicians', 0, 0, 0),
- (4, 'Administrators', 0, 0, 0),
- (5, 'Super admins', 0, 0, 0);
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_group_permissions`
- --
- CREATE TABLE IF NOT EXISTS `users_group_permissions` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `group_id` INT(11) NOT NULL,
- `perms_id` INT(11) NOT NULL,
- `actions` text,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
- --
- -- Sťahujem dáta pre tabuľku `users_group_permissions`
- --
- INSERT INTO `users_group_permissions` (`id`, `group_id`, `perms_id`, `actions`) VALUES
- (1, 3, 1, 'a:3:{i:0;s:4:"read";i:1;s:5:"write";i:2;s:10:"delete-own";}\n');
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_group_roles`
- --
- CREATE TABLE IF NOT EXISTS `users_group_roles` (
- `group_id` INT(11) NOT NULL,
- `role_id` INT(11) NOT NULL,
- PRIMARY KEY (`group_id`,`role_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Sťahujem dáta pre tabuľku `users_group_roles`
- --
- INSERT INTO `users_group_roles` (`group_id`, `role_id`) VALUES
- (1, 1),
- (2, 2),
- (3, 3),
- (4, 3),
- (4, 4),
- (5, 3),
- (5, 4),
- (5, 5);
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_metadata`
- --
- CREATE TABLE IF NOT EXISTS `users_metadata` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `parent_id` INT(11) NOT NULL DEFAULT '0',
- `key` VARCHAR(20) NOT NULL,
- `value` VARCHAR(100) NOT NULL,
- `user_id` INT(11) NOT NULL DEFAULT '0',
- `created_at` INT(11) NOT NULL DEFAULT '0',
- `updated_at` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;
- --
- -- Sťahujem dáta pre tabuľku `users_metadata`
- --
- INSERT INTO `users_metadata` (`id`, `parent_id`, `key`, `value`, `user_id`, `created_at`, `updated_at`) VALUES
- (1, 1, 'fullname', 'System administrator', 0, 1411286919, 0),
- (2, 0, 'fullname', 'Guest', 0, 0, 0),
- (3, 2, 'fullname', 'Sveatlo', 0, 1411297849, 0),
- (5, 2, 'branches', 'a:8:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;}', 0, 1411297849, 0)
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_permissions`
- --
- CREATE TABLE IF NOT EXISTS `users_permissions` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `area` VARCHAR(25) NOT NULL,
- `permission` VARCHAR(25) NOT NULL,
- `description` VARCHAR(255) NOT NULL,
- `actions` text,
- `user_id` INT(11) NOT NULL DEFAULT '0',
- `created_at` INT(11) NOT NULL DEFAULT '0',
- `updated_at` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `permission` (`area`,`permission`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
- --
- -- Sťahujem dáta pre tabuľku `users_permissions`
- --
- INSERT INTO `users_permissions` (`id`, `area`, `permission`, `description`, `actions`, `user_id`, `created_at`, `updated_at`) VALUES
- (1, 'technician', 'orders', 'access to work_orders', 'a:0:{}', 0, 1412837542, 0);
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_providers`
- --
- CREATE TABLE IF NOT EXISTS `users_providers` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `parent_id` INT(11) NOT NULL DEFAULT '0',
- `provider` VARCHAR(50) NOT NULL,
- `uid` VARCHAR(255) NOT NULL,
- `secret` VARCHAR(255) DEFAULT NULL,
- `access_token` VARCHAR(255) DEFAULT NULL,
- `expires` INT(12) DEFAULT '0',
- `refresh_token` VARCHAR(255) DEFAULT NULL,
- `user_id` INT(11) NOT NULL DEFAULT '0',
- `created_at` INT(11) NOT NULL DEFAULT '0',
- `updated_at` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `parent_id` (`parent_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_roles`
- --
- CREATE TABLE IF NOT EXISTS `users_roles` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) NOT NULL,
- `filter` enum('','A','D','R') NOT NULL DEFAULT '',
- `user_id` INT(11) NOT NULL DEFAULT '0',
- `created_at` INT(11) NOT NULL DEFAULT '0',
- `updated_at` INT(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
- --
- -- Sťahujem dáta pre tabuľku `users_roles`
- --
- INSERT INTO `users_roles` (`id`, `name`, `filter`, `user_id`, `created_at`, `updated_at`) VALUES
- (1, 'banned', 'D', 0, 0, 0),
- (2, 'customers', '', 0, 0, 0),
- (3, 'technicians', '', 0, 0, 0),
- (4, 'administrators', '', 0, 0, 0),
- (5, 'superadmin', 'A', 0, 0, 0);
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_role_permissions`
- --
- CREATE TABLE IF NOT EXISTS `users_role_permissions` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `role_id` INT(11) NOT NULL,
- `perms_id` INT(11) NOT NULL,
- `actions` text,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
- --
- -- Sťahujem dáta pre tabuľku `users_role_permissions`
- --
- INSERT INTO `users_role_permissions` (`id`, `role_id`, `perms_id`, `actions`) VALUES
- (1, 3, 1, 'a:2:{i:0;i:1;i:1;i:2;}');
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_scopes`
- --
- CREATE TABLE IF NOT EXISTS `users_scopes` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `scope` VARCHAR(64) NOT NULL DEFAULT '',
- `name` VARCHAR(64) NOT NULL DEFAULT '',
- `description` VARCHAR(255) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- UNIQUE KEY `scope` (`scope`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_session`
- --
- CREATE TABLE IF NOT EXISTS `users_session` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `client_id` VARCHAR(32) NOT NULL DEFAULT '',
- `redirect_uri` VARCHAR(255) NOT NULL DEFAULT '',
- `type_id` VARCHAR(64) NOT NULL,
- `type` enum('user','auto') NOT NULL DEFAULT 'user',
- `code` text NOT NULL,
- `access_token` VARCHAR(50) NOT NULL DEFAULT '',
- `stage` enum('request','granted') NOT NULL DEFAULT 'request',
- `first_requested` INT(11) NOT NULL,
- `last_updated` INT(11) NOT NULL,
- `limited_access` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `oauth_sessions_ibfk_1` (`client_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_sessionscopes`
- --
- CREATE TABLE IF NOT EXISTS `users_sessionscopes` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `session_id` INT(11) NOT NULL,
- `access_token` VARCHAR(50) NOT NULL DEFAULT '',
- `scope` VARCHAR(64) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`),
- KEY `access_token` (`access_token`),
- KEY `scope` (`scope`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_user_permissions`
- --
- CREATE TABLE IF NOT EXISTS `users_user_permissions` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `user_id` INT(11) NOT NULL,
- `perms_id` INT(11) NOT NULL,
- `actions` text,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `users_user_roles`
- --
- CREATE TABLE IF NOT EXISTS `users_user_roles` (
- `user_id` INT(11) NOT NULL,
- `role_id` INT(11) NOT NULL,
- PRIMARY KEY (`user_id`,`role_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Obmedzenie pre exportované tabuľky
- --
- --
- -- Obmedzenie pre tabuľku `users_session`
- --
- ALTER TABLE `users_session`
- ADD CONSTRAINT `oauth_sessions_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `users_clients` (`client_id`) ON DELETE CASCADE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement