Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.5.1
- -- http://www.phpmyadmin.net
- --
- -- Hostiteľ: localhost
- -- Čas generovania: Št 19.Nov 2015, 16:35
- -- Verzia serveru: 5.5.44-0+deb7u1
- -- Verzia PHP: 5.6.7-1
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Databáza: `prestashop`
- --
- -- --------------------------------------------------------
- --
- -- Štruktúra tabuľky pre tabuľku `access`
- --
- CREATE TABLE `access` (
- `id_profile` INT(10) UNSIGNED NOT NULL,
- `id_tab` INT(10) UNSIGNED NOT NULL,
- `view` INT(11) NOT NULL,
- `add` INT(11) NOT NULL,
- `edit` INT(11) NOT NULL,
- `delete` INT(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Sťahujem dáta pre tabuľku `access`
- --
- INSERT INTO `access` (`id_profile`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES
- (1, 0, 1, 1, 1, 1),
- (1, 2, 0, 0, 0, 0),
- (1, 3, 0, 0, 0, 0),
- (1, 4, 0, 0, 0, 0),
- (1, 5, 1, 1, 1, 1),
- (1, 6, 0, 0, 0, 0),
- (1, 7, 1, 1, 1, 1),
- (1, 8, 0, 0, 0, 0),
- (1, 19, 1, 1, 1, 1),
- (1, 20, 1, 1, 1, 1),
- (1, 21, 1, 1, 1, 1),
- (1, 22, 1, 1, 1, 1),
- (1, 23, 1, 1, 1, 1),
- (1, 24, 1, 1, 1, 1),
- (1, 25, 1, 1, 1, 1),
- (1, 26, 1, 1, 1, 1),
- (1, 27, 1, 1, 1, 1),
- (1, 28, 1, 1, 1, 1),
- (1, 29, 1, 1, 1, 1),
- (1, 30, 0, 0, 0, 0),
- (1, 31, 1, 1, 1, 1),
- (1, 32, 1, 1, 1, 1),
- (1, 33, 1, 1, 1, 1),
- (1, 34, 1, 1, 1, 1),
- (1, 35, 1, 1, 1, 1),
- (1, 36, 1, 1, 1, 1),
- (1, 37, 0, 0, 0, 0),
- (1, 38, 1, 1, 1, 1),
- (1, 39, 1, 1, 1, 1),
- (1, 40, 1, 1, 1, 1),
- (1, 41, 1, 1, 1, 1),
- (1, 42, 1, 1, 1, 1),
- (1, 43, 0, 0, 0, 0),
- (1, 44, 1, 1, 1, 1),
- (1, 45, 1, 1, 1, 1),
- (1, 46, 0, 0, 0, 0),
- (1, 47, 0, 0, 0, 0),
- (1, 48, 1, 1, 1, 1),
- (1, 49, 0, 0, 0, 0),
- (1, 50, 1, 1, 1, 1),
- (1, 51, 0, 0, 0, 0),
- (1, 52, 1, 1, 1, 1),
- (1, 53, 1, 1, 1, 1),
- (1, 54, 1, 1, 1, 1),
- (1, 55, 1, 1, 1, 1),
- (1, 56, 1, 1, 1, 1),
- (1, 57, 1, 1, 1, 1),
- (1, 58, 1, 1, 1, 1),
- (1, 59, 1, 1, 1, 1),
- (1, 60, 0, 0, 0, 0),
- (1, 61, 1, 1, 1, 1),
- (1, 62, 1, 1, 1, 1),
- (1, 63, 1, 1, 1, 1),
- (1, 64, 0, 0, 0, 0),
- (1, 65, 0, 0, 0, 0),
- (1, 66, 1, 1, 1, 1),
- (1, 67, 1, 1, 1, 1),
- (1, 68, 1, 1, 1, 1),
- (1, 69, 1, 1, 1, 1),
- (1, 70, 1, 1, 1, 1),
- (1, 71, 1, 1, 1, 1),
- (1, 72, 0, 0, 0, 0),
- (1, 73, 1, 1, 1, 1),
- (1, 74, 1, 1, 1, 1),
- (1, 75, 1, 1, 1, 1),
- (1, 76, 1, 1, 1, 1),
- (1, 77, 1, 1, 1, 1),
- (1, 78, 1, 1, 1, 1),
- (1, 79, 0, 0, 0, 0),
- (1, 80, 1, 1, 1, 1),
- (1, 81, 1, 1, 1, 1),
- (1, 82, 1, 1, 1, 1),
- (1, 83, 1, 1, 1, 1),
- (1, 84, 1, 1, 1, 1),
- (1, 85, 0, 0, 0, 0),
- (1, 86, 1, 1, 1, 1),
- (1, 87, 1, 1, 1, 1),
- (1, 88, 1, 1, 1, 1),
- (1, 89, 1, 1, 1, 1),
- (1, 90, 0, 0, 0, 0),
- (1, 91, 0, 0, 0, 0),
- (1, 92, 1, 1, 1, 1),
- (1, 93, 1, 1, 1, 1),
- (1, 94, 1, 1, 1, 1),
- (1, 95, 1, 1, 1, 1),
- (1, 96, 1, 1, 1, 1),
- (1, 97, 0, 0, 0, 0),
- (1, 98, 0, 0, 0, 0),
- (1, 99, 1, 1, 1, 1),
- (1, 100, 1, 1, 1, 1),
- (1, 101, 1, 1, 1, 1),
- (1, 102, 1, 1, 1, 1),
- (1, 103, 1, 1, 1, 1),
- (1, 104, 1, 1, 1, 1),
- (1, 105, 1, 1, 1, 1),
- (2, 0, 1, 1, 1, 1),
- (2, 2, 0, 0, 0, 0),
- (2, 3, 0, 0, 0, 0),
- (2, 4, 0, 0, 0, 0),
- (2, 5, 0, 0, 0, 0),
- (2, 6, 0, 0, 0, 0),
- (2, 7, 0, 0, 0, 0),
- (2, 8, 0, 0, 0, 0),
- (2, 19, 0, 0, 0, 0),
- (2, 20, 1, 1, 1, 1),
- (2, 21, 1, 1, 1, 1),
- (2, 22, 1, 1, 1, 1),
- (2, 23, 1, 1, 1, 1),
- (2, 24, 0, 0, 0, 0),
- (2, 25, 0, 0, 0, 0),
- (2, 26, 0, 0, 0, 0),
- (2, 27, 1, 1, 1, 1),
- (2, 28, 0, 0, 0, 0),
- (2, 29, 0, 0, 0, 0),
- (2, 30, 1, 1, 1, 1),
- (2, 31, 1, 1, 1, 1),
- (2, 32, 1, 1, 1, 1),
- (2, 33, 1, 1, 1, 1),
- (2, 34, 1, 1, 1, 1),
- (2, 35, 1, 1, 1, 1),
- (2, 36, 0, 0, 0, 0),
- (2, 37, 1, 1, 1, 1),
- (2, 38, 1, 1, 1, 1),
- (2, 39, 0, 0, 0, 0),
- (2, 40, 0, 0, 0, 0),
- (2, 41, 0, 0, 0, 0),
- (2, 42, 0, 0, 0, 0),
- (2, 43, 0, 0, 0, 0),
- (2, 44, 0, 0, 0, 0),
- (2, 45, 0, 0, 0, 0),
- (2, 46, 0, 0, 0, 0),
- (2, 47, 0, 0, 0, 0),
- (2, 48, 1, 1, 1, 1),
- (2, 49, 1, 1, 1, 1),
- (2, 50, 0, 0, 0, 0),
- (2, 51, 0, 0, 0, 0),
- (2, 52, 0, 0, 0, 0),
- (2, 53, 0, 0, 0, 0),
- (2, 54, 0, 0, 0, 0),
- (2, 55, 0, 0, 0, 0),
- (2, 56, 0, 0, 0, 0),
- (2, 57, 0, 0, 0, 0),
- (2, 58, 0, 0, 0, 0),
- (2, 59, 0, 0, 0, 0),
- (2, 60, 1, 0, 1, 0),
- (2, 61, 0, 0, 0, 0),
- (2, 62, 0, 0, 0, 0),
- (2, 63, 0, 0, 0, 0),
- (2, 64, 0, 0, 0, 0),
- (2, 65, 0, 0, 0, 0),
- (2, 66, 0, 0, 0, 0),
- (2, 67, 0, 0, 0, 0),
- (2, 68, 0, 0, 0, 0),
- (2, 69, 0, 0, 0, 0),
- (2, 70, 0, 0, 0, 0),
- (2, 71, 0, 0, 0, 0),
- (2, 72, 0, 0, 0, 0),
- (2, 73, 0, 0, 0, 0),
- (2, 74, 0, 0, 0, 0),
- (2, 75, 0, 0, 0, 0),
- (2, 76, 0, 0, 0, 0),
- (2, 77, 0, 0, 0, 0),
- (2, 78, 0, 0, 0, 0),
- (2, 79, 0, 0, 0, 0),
- (2, 80, 0, 0, 0, 0),
- (2, 81, 0, 0, 0, 0),
- (2, 82, 0, 0, 0, 0),
- (2, 83, 0, 0, 0, 0),
- (2, 84, 0, 0, 0, 0),
- (2, 85, 0, 0, 0, 0),
- (2, 86, 0, 0, 0, 0),
- (2, 87, 0, 0, 0, 0),
- (2, 88, 0, 0, 0, 0),
- (2, 89, 0, 0, 0, 0),
- (2, 90, 0, 0, 0, 0),
- (2, 91, 0, 0, 0, 0),
- (2, 92, 0, 0, 0, 0),
- (2, 93, 0, 0, 0, 0),
- (2, 94, 1, 1, 1, 1),
- (2, 95, 1, 1, 1, 1),
- (2, 96, 1, 1, 1, 1),
- (2, 97, 0, 0, 0, 0),
- (2, 98, 0, 0, 0, 0),
- (2, 99, 1, 1, 1, 1),
- (2, 100, 1, 1, 1, 1),
- (2, 101, 0, 0, 0, 0),
- (2, 102, 0, 0, 0, 0),
- (2, 103, 0, 0, 0, 0),
- (2, 104, 0, 0, 0, 0),
- (2, 105, 0, 0, 0, 0),
- (3, 0, 1, 1, 1, 1),
- (3, 2, 0, 0, 0, 0),
- (3, 3, 0, 0, 0, 0),
- (3, 4, 0, 0, 0, 0),
- (3, 5, 1, 0, 0, 0),
- (3, 6, 0, 0, 0, 0),
- (3, 7, 0, 0, 0, 0),
- (3, 8, 0, 0, 0, 0),
- (3, 19, 0, 0, 0, 0),
- (3, 20, 0, 0, 0, 0),
- (3, 21, 1, 1, 1, 1),
- (3, 22, 1, 1, 1, 1),
- (3, 23, 0, 0, 0, 0),
- (3, 24, 0, 0, 0, 0),
- (3, 25, 0, 0, 0, 0),
- (3, 26, 0, 0, 0, 0),
- (3, 27, 0, 0, 0, 0),
- (3, 28, 0, 0, 0, 0),
- (3, 29, 0, 0, 0, 0),
- (3, 30, 0, 0, 0, 0),
- (3, 31, 0, 0, 0, 0),
- (3, 32, 0, 0, 0, 0),
- (3, 33, 0, 0, 0, 0),
- (3, 34, 0, 0, 0, 0),
- (3, 35, 0, 0, 0, 0),
- (3, 36, 0, 0, 0, 0),
- (3, 37, 0, 0, 0, 0),
- (3, 38, 0, 0, 0, 0),
- (3, 39, 0, 0, 0, 0),
- (3, 40, 0, 0, 0, 0),
- (3, 41, 0, 0, 0, 0),
- (3, 42, 0, 0, 0, 0),
- (3, 43, 0, 0, 0, 0),
- (3, 44, 0, 0, 0, 0),
- (3, 45, 0, 0, 0, 0),
- (3, 46, 0, 0, 0, 0),
- (3, 47, 0, 0, 0, 0),
- (3, 48, 0, 0, 0, 0),
- (3, 49, 0, 0, 0, 0),
- (3, 50, 0, 0, 0, 0),
- (3, 51, 0, 0, 0, 0),
- (3, 52, 0, 0, 0, 0),
- (3, 53, 0, 0, 0, 0),
- (3, 54, 0, 0, 0, 0),
- (3, 55, 0, 0, 0, 0),
- (3, 56, 0, 0, 0, 0),
- (3, 57, 0, 0, 0, 0),
- (3, 58, 0, 0, 0, 0),
- (3, 59, 1, 1, 1, 1),
- (3, 60, 0, 0, 0, 0),
- (3, 61, 0, 0, 0, 0),
- (3, 62, 0, 0, 0, 0),
- (3, 63, 0, 0, 0, 0),
- (3, 64, 0, 0, 0, 0),
- (3, 65, 0, 0, 0, 0),
- (3, 66, 0, 0, 0, 0),
- (3, 67, 0, 0, 0, 0),
- (3, 68, 0, 0, 0, 0),
- (3, 69, 0, 0, 0, 0),
- (3, 70, 1, 1, 1, 1),
- (3, 71, 0, 0, 0, 0),
- (3, 72, 0, 0, 0, 0),
- (3, 73, 0, 0, 0, 0),
- (3, 74, 0, 0, 0, 0),
- (3, 75, 0, 0, 0, 0),
- (3, 76, 0, 0, 0, 0),
- (3, 77, 0, 0, 0, 0),
- (3, 78, 0, 0, 0, 0),
- (3, 79, 0, 0, 0, 0),
- (3, 80, 0, 0, 0, 0),
- (3, 81, 0, 0, 0, 0),
- (3, 82, 0, 0, 0, 0),
- (3, 83, 0, 0, 0, 0),
- (3, 84, 0, 0, 0, 0),
- (3, 85, 0, 0, 0, 0),
- (3, 86, 0, 0, 0, 0),
- (3, 87, 0, 0, 0, 0),
- (3, 88, 0, 0, 0, 0),
- (3, 89, 0, 0, 0, 0),
- (3, 90, 0, 0, 0, 0),
- (3, 91, 0, 0, 0, 0),
- (3, 92, 0, 0, 0, 0),
- (3, 93, 0, 0, 0, 0),
- (3, 94, 0, 0, 0, 0),
- (3, 95, 0, 0, 0, 0),
- (3, 96, 0, 0, 0, 0),
- (3, 97, 0, 0, 0, 0),
- (3, 98, 0, 0, 0, 0),
- (3, 99, 0, 0, 0, 0),
- (3, 100, 0, 0, 0, 0),
- (3, 101, 0, 0, 0, 0),
- (3, 102, 0, 0, 0, 0),
- (3, 103, 0, 0, 0, 0),
- (3, 104, 0, 0, 0, 0),
- (3, 105, 0, 0, 0, 0),
- (4, 0, 1, 1, 1, 1),
- (4, 2, 0, 0, 0, 0),
- (4, 3, 0, 0, 0, 0),
- (4, 4, 0, 0, 0, 0),
- (4, 5, 1, 0, 0, 0),
- (4, 6, 0, 0, 0, 0),
- (4, 7, 0, 0, 0, 0),
- (4, 8, 0, 0, 0, 0),
- (4, 19, 1, 1, 1, 1),
- (4, 20, 1, 0, 0, 0),
- (4, 21, 1, 1, 1, 1),
- (4, 22, 1, 1, 1, 1),
- (4, 23, 0, 0, 0, 0),
- (4, 24, 0, 0, 0, 0),
- (4, 25, 0, 0, 0, 0),
- (4, 26, 1, 0, 0, 0),
- (4, 27, 0, 0, 0, 0),
- (4, 28, 0, 0, 0, 0),
- (4, 29, 0, 0, 0, 0),
- (4, 30, 1, 1, 1, 1),
- (4, 31, 1, 1, 1, 1),
- (4, 32, 0, 0, 0, 0),
- (4, 33, 0, 0, 0, 0),
- (4, 34, 1, 1, 1, 1),
- (4, 35, 0, 0, 0, 0),
- (4, 36, 1, 1, 1, 1),
- (4, 37, 1, 1, 1, 1),
- (4, 38, 1, 1, 1, 1),
- (4, 39, 1, 1, 1, 1),
- (4, 40, 1, 1, 1, 1),
- (4, 41, 0, 0, 0, 0),
- (4, 42, 0, 0, 0, 0),
- (4, 43, 0, 0, 0, 0),
- (4, 44, 0, 0, 0, 0),
- (4, 45, 0, 0, 0, 0),
- (4, 46, 0, 0, 0, 0),
- (4, 47, 0, 0, 0, 0),
- (4, 48, 0, 0, 0, 0),
- (4, 49, 0, 0, 0, 0),
- (4, 50, 0, 0, 0, 0),
- (4, 51, 0, 0, 0, 0),
- (4, 52, 0, 0, 0, 0),
- (4, 53, 0, 0, 0, 0),
- (4, 54, 0, 0, 0, 0),
- (4, 55, 0, 0, 0, 0),
- (4, 56, 0, 0, 0, 0),
- (4, 57, 0, 0, 0, 0),
- (4, 58, 0, 0, 0, 0),
- (4, 59, 0, 0, 0, 0),
- (4, 60, 1, 0, 1, 0),
- (4, 61, 0, 0, 0, 0),
- (4, 62, 0, 0, 0, 0),
- (4, 63, 0, 0, 0, 0),
- (4, 64, 0, 0, 0, 0),
- (4, 65, 0, 0, 0, 0),
- (4, 66, 0, 0, 0, 0),
- (4, 67, 0, 0, 0, 0),
- (4, 68, 0, 0, 0, 0),
- (4, 69, 0, 0, 0, 0),
- (4, 70, 0, 0, 0, 0),
- (4, 71, 0, 0, 0, 0),
- (4, 72, 0, 0, 0, 0),
- (4, 73, 0, 0, 0, 0),
- (4, 74, 0, 0, 0, 0),
- (4, 75, 0, 0, 0, 0),
- (4, 76, 0, 0, 0, 0),
- (4, 77, 0, 0, 0, 0),
- (4, 78, 0, 0, 0, 0),
- (4, 79, 0, 0, 0, 0),
- (4, 80, 0, 0, 0, 0),
- (4, 81, 0, 0, 0, 0),
- (4, 82, 0, 0, 0, 0),
- (4, 83, 0, 0, 0, 0),
- (4, 84, 1, 1, 1, 1),
- (4, 85, 0, 0, 0, 0),
- (4, 86, 0, 0, 0, 0),
- (4, 87, 0, 0, 0, 0),
- (4, 88, 0, 0, 0, 0),
- (4, 89, 0, 0, 0, 0),
- (4, 90, 0, 0, 0, 0),
- (4, 91, 1, 1, 1, 1),
- (4, 92, 0, 0, 0, 0),
- (4, 93, 1, 1, 1, 1),
- (4, 94, 0, 0, 0, 0),
- (4, 95, 0, 0, 0, 0),
- (4, 96, 0, 0, 0, 0),
- (4, 97, 0, 0, 0, 0),
- (4, 98, 0, 0, 0, 0),
- (4, 99, 1, 0, 0, 0),
- (4, 100, 0, 0, 0, 0),
- (4, 101, 0, 0, 0, 0),
- (4, 102, 0, 0, 0, 0),
- (4, 103, 0, 0, 0, 0),
- (4, 104, 0, 0, 0, 0),
- (4, 105, 0, 0, 0, 0);
- --
- -- Kľúče pre exportované tabuľky
- --
- --
- -- Indexy pre tabuľku `access`
- --
- ALTER TABLE `access`
- ADD PRIMARY KEY (`id_profile`,`id_tab`);
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement