1314 lines
41 KiB
Plaintext
1314 lines
41 KiB
Plaintext
-- phpMyAdmin SQL Dump
|
|
-- version 4.6.3
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: localhost
|
|
-- Czas generowania: 28 Sie 2018, 23:28
|
|
-- Wersja serwera: 5.5.46-MariaDB
|
|
-- Wersja PHP: 5.6.29
|
|
|
|
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 */;
|
|
|
|
--
|
|
-- Baza danych: `projectpro_sklepPRO`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `grid_settings`
|
|
--
|
|
|
|
CREATE TABLE `grid_settings` (
|
|
`id` int(11) NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`settings` text COLLATE utf8_polish_ci NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_articles`
|
|
--
|
|
|
|
CREATE TABLE `pp_articles` (
|
|
`id` int(11) NOT NULL,
|
|
`show_title` int(11) NOT NULL DEFAULT '1',
|
|
`show_date_add` int(11) DEFAULT '0',
|
|
`show_date_modify` int(11) NOT NULL DEFAULT '0',
|
|
`date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`date_modify` datetime DEFAULT NULL,
|
|
`modify_by` int(11) NOT NULL DEFAULT '0',
|
|
`layout_id` int(11) DEFAULT NULL,
|
|
`status` int(11) NOT NULL DEFAULT '0',
|
|
`repeat_entry` int(11) NOT NULL DEFAULT '1',
|
|
`social_icons` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_articles_files`
|
|
--
|
|
|
|
CREATE TABLE `pp_articles_files` (
|
|
`id` int(11) NOT NULL,
|
|
`article_id` int(11) DEFAULT NULL,
|
|
`src` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`to_delete` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_articles_images`
|
|
--
|
|
|
|
CREATE TABLE `pp_articles_images` (
|
|
`id` int(11) NOT NULL,
|
|
`article_id` int(11) DEFAULT NULL,
|
|
`src` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`to_delete` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_articles_langs`
|
|
--
|
|
|
|
CREATE TABLE `pp_articles_langs` (
|
|
`id` int(11) NOT NULL,
|
|
`article_id` int(11) NOT NULL,
|
|
`lang_id` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`title` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`entry` mediumtext COLLATE utf8_polish_ci,
|
|
`text` mediumtext COLLATE utf8_polish_ci,
|
|
`meta_description` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`meta_keywords` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`seo_link` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`noindex` int(11) NOT NULL DEFAULT '0',
|
|
`copy_from` varchar(3) COLLATE utf8_polish_ci DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_articles_pages`
|
|
--
|
|
|
|
CREATE TABLE `pp_articles_pages` (
|
|
`id` int(11) NOT NULL,
|
|
`page_id` int(11) NOT NULL,
|
|
`article_id` int(11) NOT NULL,
|
|
`o` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_banners`
|
|
--
|
|
|
|
CREATE TABLE `pp_banners` (
|
|
`id` int(11) NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`src` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`date_start` date DEFAULT NULL,
|
|
`date_end` date DEFAULT NULL,
|
|
`status` int(11) NOT NULL DEFAULT '1'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_langs`
|
|
--
|
|
|
|
CREATE TABLE `pp_langs` (
|
|
`id` varchar(5) COLLATE utf8_polish_ci NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`start` int(11) NOT NULL DEFAULT '0',
|
|
`status` int(11) NOT NULL DEFAULT '1',
|
|
`o` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
--
|
|
-- Zrzut danych tabeli `pp_langs`
|
|
--
|
|
|
|
INSERT INTO `pp_langs` (`id`, `name`, `start`, `status`, `o`) VALUES
|
|
('de', 'niemiecki', 0, 0, 3),
|
|
('en', 'angielski', 0, 0, 2),
|
|
('pl', 'polski', 1, 1, 1),
|
|
('ru', 'rosyjski', 0, 0, 4),
|
|
('uk', 'ukraiński', 0, 0, 5);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_langs_translations`
|
|
--
|
|
|
|
CREATE TABLE `pp_langs_translations` (
|
|
`id` int(11) NOT NULL,
|
|
`text` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`pl` text COLLATE utf8_polish_ci NOT NULL,
|
|
`en` text COLLATE utf8_polish_ci NOT NULL,
|
|
`ru` text COLLATE utf8_polish_ci NOT NULL,
|
|
`de` text COLLATE utf8_polish_ci,
|
|
`uk` text COLLATE utf8_polish_ci
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
--
|
|
-- Zrzut danych tabeli `pp_langs_translations`
|
|
--
|
|
|
|
INSERT INTO `pp_langs_translations` (`id`, `text`, `pl`, `en`, `ru`, `de`, `uk`) VALUES
|
|
(3, 'temat', 'temat', 'subject', '', '', ''),
|
|
(4, 'wiadomosc', 'wiadomość', 'message', '', '', ''),
|
|
(5, 'wyslij', 'wyślij', 'send', '', '', ''),
|
|
(6, 'email', 'email', 'email', '', '', ''),
|
|
(7, 'nr-telefonu', 'nr telefonu', 'phone number', '', '', ''),
|
|
(8, 'prosze-uzupelnic-email-lub-telefon', 'Proszę uzupełnić adres email lub numer telefonu.', 'Please complete the email address or phone number.', '', '', ''),
|
|
(9, 'blad', 'błąd', 'error', '', '', ''),
|
|
(10, 'zamknij', 'zamknij', 'close', '', '', ''),
|
|
(11, 'wiadomosc-zostala-wyslana', 'Twoja wiadomość została wysłana. Postaramy się na nią odpowiedzieć jak najszybciej.', 'Your message has been sent. We will try to respond to it as soon as possible.', '', '', ''),
|
|
(12, 'wiadomosc-niezostala-wyslana', 'Podczas wysyłania wiadomości wystąpił błąd. Proszę spróbować ponownie. Przepraszamy.', 'During sending error occurred. Please try again. Sorry.', '', '', ''),
|
|
(13, 'data-dodania', 'data dodania', 'date add', '', '', ''),
|
|
(14, 'data-modyfikacji', 'data modyfikacji', 'modification date', '', '', ''),
|
|
(15, 'adres-strony', 'adres strony', 'website address', '', '', ''),
|
|
(16, 'prosze-uzupelnic-adres-strony', 'Proszę uzupełnić adres strony.', 'Please fill in the address of the page.', '', '', ''),
|
|
(17, 'pierwsza', 'pierwsza', 'first', '', '', ''),
|
|
(18, 'nastepna', 'następna', 'next', '', '', ''),
|
|
(19, 'poprzednia', 'poprzednia', 'previous', '', '', ''),
|
|
(20, 'ostatnia', 'ostatnia', 'last', '', '', ''),
|
|
(21, 'z', 'z', 'from', '', '', ''),
|
|
(22, 'wiecej', 'więcej', 'more', '', '', ''),
|
|
(23, 'wstecz', 'wstecz', 'back', '', '', ''),
|
|
(24, 'formularz-captcha-label', 'Proszę narysować kształt w poniższym polu, aby wysłać formularz', '', '', '', ''),
|
|
(25, 'sprobuj-ponownie', 'spróbuj ponownie', '', '', '', ''),
|
|
(26, 'dobrze', 'dobrze', '', '', '', '');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_layouts`
|
|
--
|
|
|
|
CREATE TABLE `pp_layouts` (
|
|
`id` int(11) NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`html` mediumtext COLLATE utf8_polish_ci,
|
|
`css` mediumtext COLLATE utf8_polish_ci,
|
|
`js` mediumtext COLLATE utf8_polish_ci,
|
|
`m_html` mediumtext COLLATE utf8_polish_ci,
|
|
`m_css` mediumtext COLLATE utf8_polish_ci,
|
|
`m_js` mediumtext COLLATE utf8_polish_ci,
|
|
`status` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_layouts_pages`
|
|
--
|
|
|
|
CREATE TABLE `pp_layouts_pages` (
|
|
`id` int(11) NOT NULL,
|
|
`layout_id` int(11) NOT NULL,
|
|
`page_id` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_menus`
|
|
--
|
|
|
|
CREATE TABLE `pp_menus` (
|
|
`id` int(11) NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`status` int(11) NOT NULL DEFAULT '1'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_newsletter`
|
|
--
|
|
|
|
CREATE TABLE `pp_newsletter` (
|
|
`id` int(11) NOT NULL,
|
|
`email` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`hash` varchar(255) COLLATE utf8_polish_ci NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_newsletter_send`
|
|
--
|
|
|
|
CREATE TABLE `pp_newsletter_send` (
|
|
`id` int(11) NOT NULL,
|
|
`email` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`dates` varchar(255) COLLATE utf8_polish_ci NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_pages`
|
|
--
|
|
|
|
CREATE TABLE `pp_pages` (
|
|
`id` int(11) NOT NULL,
|
|
`menu_id` int(11) NOT NULL,
|
|
`page_type` int(11) NOT NULL,
|
|
`sort_type` int(11) NOT NULL,
|
|
`articles_limit` int(11) NOT NULL DEFAULT '10',
|
|
`show_title` int(11) NOT NULL DEFAULT '1',
|
|
`link` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`status` int(11) NOT NULL DEFAULT '1',
|
|
`o` int(11) NOT NULL DEFAULT '0',
|
|
`parent_id` int(11) DEFAULT NULL,
|
|
`start` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_pages_langs`
|
|
--
|
|
|
|
CREATE TABLE `pp_pages_langs` (
|
|
`id` int(11) NOT NULL,
|
|
`page_id` int(11) NOT NULL,
|
|
`lang_id` varchar(5) COLLATE utf8_polish_ci NOT NULL,
|
|
`title` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`meta_description` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`meta_keywords` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`meta_title` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`seo_link` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`page_title` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`noindex` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_scontainers`
|
|
--
|
|
|
|
CREATE TABLE `pp_scontainers` (
|
|
`id` int(11) NOT NULL,
|
|
`status` int(11) NOT NULL DEFAULT '1',
|
|
`show_title` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_scontainers_langs`
|
|
--
|
|
|
|
CREATE TABLE `pp_scontainers_langs` (
|
|
`id` int(11) NOT NULL,
|
|
`container_id` int(11) NOT NULL,
|
|
`lang_id` varchar(2) COLLATE utf8_polish_ci NOT NULL,
|
|
`title` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`text` mediumtext COLLATE utf8_polish_ci
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_settings`
|
|
--
|
|
|
|
CREATE TABLE `pp_settings` (
|
|
`id` int(11) NOT NULL,
|
|
`param` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`value` text COLLATE utf8_polish_ci NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
--
|
|
-- Zrzut danych tabeli `pp_settings`
|
|
--
|
|
|
|
INSERT INTO `pp_settings` (`id`, `param`, `value`) VALUES
|
|
(1, 'firm_name', 'shopPRO'),
|
|
(2, 'firm_adress', ''),
|
|
(3, 'additional_info', ''),
|
|
(4, 'contact_form', '1'),
|
|
(5, 'contact_email', ''),
|
|
(6, 'email_host', ''),
|
|
(7, 'email_port', ''),
|
|
(8, 'email_login', ''),
|
|
(9, 'email_password', ''),
|
|
(10, 'google_maps', '0'),
|
|
(11, 'facebook_link', ''),
|
|
(12, 'statistic_code', ''),
|
|
(13, 'htaccess', ''),
|
|
(14, 'robots', ''),
|
|
(15, 'shop_bank_account_info', '');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_attributes`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_attributes` (
|
|
`id` int(11) NOT NULL,
|
|
`status` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_attributes_langs`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_attributes_langs` (
|
|
`id` int(11) NOT NULL,
|
|
`attribute_id` int(11) NOT NULL,
|
|
`lang_id` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_attributes_values`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_attributes_values` (
|
|
`id` int(11) NOT NULL,
|
|
`attribute_id` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_attributes_values_langs`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_attributes_values_langs` (
|
|
`id` int(11) NOT NULL,
|
|
`value_id` int(11) NOT NULL,
|
|
`lang_id` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_categories`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_categories` (
|
|
`id` int(11) NOT NULL,
|
|
`status` int(11) NOT NULL DEFAULT '1',
|
|
`o` int(11) NOT NULL DEFAULT '0',
|
|
`parent_id` int(11) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_categories_langs`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_categories_langs` (
|
|
`id` int(11) NOT NULL,
|
|
`category_id` int(11) NOT NULL,
|
|
`lang_id` varchar(5) COLLATE utf8_polish_ci NOT NULL,
|
|
`title` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`meta_description` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`meta_keywords` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`meta_title` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`seo_link` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`noindex` int(11) NOT NULL DEFAULT '0',
|
|
`category_title` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_clients`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_clients` (
|
|
`id` int(11) NOT NULL,
|
|
`email` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`password` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`registered` datetime NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_orders`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_orders` (
|
|
`id` int(11) NOT NULL,
|
|
`number` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`client_id` int(11) DEFAULT NULL,
|
|
`date_order` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`comment` text COLLATE utf8_polish_ci,
|
|
`status` int(11) NOT NULL DEFAULT '0',
|
|
`client_name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`client_surname` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`client_email` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`client_address` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`client_postal_code` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`client_city` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`client_phone` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`transport` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`transport_cost` decimal(10,2) NOT NULL,
|
|
`payment_method` varchar(255) COLLATE utf8_polish_ci NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_order_products`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_order_products` (
|
|
`id` int(11) NOT NULL,
|
|
`order_id` int(11) NOT NULL,
|
|
`product_id` int(11) DEFAULT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`attributes` text COLLATE utf8_polish_ci,
|
|
`price_netto` decimal(10,2) NOT NULL,
|
|
`vat` int(11) NOT NULL,
|
|
`quantity` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_payment_methods`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_payment_methods` (
|
|
`id` int(11) NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`description` text COLLATE utf8_polish_ci,
|
|
`status` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
--
|
|
-- Zrzut danych tabeli `pp_shop_payment_methods`
|
|
--
|
|
|
|
INSERT INTO `pp_shop_payment_methods` (`id`, `name`, `description`, `status`) VALUES
|
|
(1, 'Przedpłata - przelew bankowy', 'Przedpłata przelewem na konto bankowe.', 1),
|
|
(2, 'Przedpłata - PayU', 'Szybkie płatności transferami, przelewami oraz kartami kredytowymi.', 1),
|
|
(3, 'Płatność przy odbiorze', '', 1);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_products`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_products` (
|
|
`id` int(11) NOT NULL,
|
|
`date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`date_modify` datetime DEFAULT NULL,
|
|
`modify_by` int(11) NOT NULL DEFAULT '0',
|
|
`status` int(11) NOT NULL DEFAULT '0',
|
|
`price_netto` decimal(10,2) DEFAULT NULL,
|
|
`vat` int(11) DEFAULT NULL,
|
|
`promoted` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_products_attributes`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_products_attributes` (
|
|
`id` int(11) NOT NULL,
|
|
`product_id` int(11) NOT NULL,
|
|
`attribute_id` int(11) NOT NULL,
|
|
`value_id` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_products_categories`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_products_categories` (
|
|
`id` int(11) NOT NULL,
|
|
`category_id` int(11) NOT NULL,
|
|
`product_id` int(11) NOT NULL,
|
|
`o` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_products_files`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_products_files` (
|
|
`id` int(11) NOT NULL,
|
|
`product_id` int(11) DEFAULT NULL,
|
|
`src` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`to_delete` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_products_images`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_products_images` (
|
|
`id` int(11) NOT NULL,
|
|
`product_id` int(11) DEFAULT NULL,
|
|
`src` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`to_delete` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_products_langs`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_products_langs` (
|
|
`id` int(11) NOT NULL,
|
|
`product_id` int(11) NOT NULL,
|
|
`lang_id` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`short_description` mediumtext COLLATE utf8_polish_ci,
|
|
`description` mediumtext COLLATE utf8_polish_ci,
|
|
`meta_description` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`meta_keywords` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`seo_link` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`copy_from` varchar(3) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`shipping_time` text COLLATE utf8_polish_ci
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_products_stock`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_products_stock` (
|
|
`id` int(11) NOT NULL,
|
|
`id_product` int(11) NOT NULL,
|
|
`permutation` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`quantity` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_transports`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_transports` (
|
|
`id` int(11) NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`name_visible` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
|
|
`description` text COLLATE utf8_polish_ci,
|
|
`status` int(11) NOT NULL,
|
|
`cost` decimal(12,2) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
--
|
|
-- Zrzut danych tabeli `pp_shop_transports`
|
|
--
|
|
|
|
INSERT INTO `pp_shop_transports` (`id`, `name`, `name_visible`, `description`, `status`, `cost`) VALUES
|
|
(1, 'Paczkomaty InPost', 'Paczkomaty InPost', 'Czas przesyłki 24h od czasu realizacji zamówienia', 1, '10.00'),
|
|
(3, 'Poczta Polska', '', 'Czas przesyłki 2-4 dni od czasu realizacji zamówienia', 1, '10.00'),
|
|
(4, 'Obiór osobisty', 'Obiór osobisty', 'Odbiór osobisty: ul. Broniewskiego 11/27, 35-222 Rzeszów.', 1, '0.00'),
|
|
(5, 'Kurier DPD - przedpłata', 'Kurier DPD', 'Kurier DPD - przedpłata opis', 1, '10.00'),
|
|
(7, 'Kurier DPD - płatność przy odbiorze', 'Kurier DPD', 'Czas przesyłki 24h od czasu realizacji zamówienia', 1, '13.90');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_shop_transport_payment_methods`
|
|
--
|
|
|
|
CREATE TABLE `pp_shop_transport_payment_methods` (
|
|
`id` int(11) NOT NULL,
|
|
`id_payment_method` int(11) NOT NULL,
|
|
`id_transport` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktura tabeli dla tabeli `pp_users`
|
|
--
|
|
|
|
CREATE TABLE `pp_users` (
|
|
`id` int(11) NOT NULL,
|
|
`login` varchar(25) COLLATE utf8_polish_ci NOT NULL,
|
|
`admin` int(11) NOT NULL DEFAULT '0',
|
|
`password` varchar(255) COLLATE utf8_polish_ci NOT NULL,
|
|
`status` int(11) NOT NULL DEFAULT '0',
|
|
`last_logged` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`last_error_logged` datetime DEFAULT NULL,
|
|
`error_logged_count` int(11) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
|
|
--
|
|
-- Zrzut danych tabeli `pp_users`
|
|
--
|
|
|
|
INSERT INTO `pp_users` (`id`, `login`, `admin`, `password`, `status`, `last_logged`, `last_error_logged`, `error_logged_count`) VALUES
|
|
(1, 'project-pro', 1, 'c3cb2537d25c0efc9e573d059d79c3b8', 1, '2018-08-28 21:24:02', '2017-06-28 22:24:00', 0);
|
|
|
|
--
|
|
-- Indeksy dla zrzutów tabel
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `grid_settings`
|
|
--
|
|
ALTER TABLE `grid_settings`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_articles`
|
|
--
|
|
ALTER TABLE `pp_articles`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `layout_id` (`layout_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_articles_files`
|
|
--
|
|
ALTER TABLE `pp_articles_files`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `article_id` (`article_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_articles_images`
|
|
--
|
|
ALTER TABLE `pp_articles_images`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `article_id` (`article_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_articles_langs`
|
|
--
|
|
ALTER TABLE `pp_articles_langs`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `article_id` (`article_id`),
|
|
ADD KEY `lang_id` (`lang_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_articles_pages`
|
|
--
|
|
ALTER TABLE `pp_articles_pages`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `page_id` (`page_id`),
|
|
ADD KEY `article_id` (`article_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_banners`
|
|
--
|
|
ALTER TABLE `pp_banners`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_langs`
|
|
--
|
|
ALTER TABLE `pp_langs`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_langs_translations`
|
|
--
|
|
ALTER TABLE `pp_langs_translations`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD UNIQUE KEY `text` (`text`);
|
|
|
|
--
|
|
-- Indexes for table `pp_layouts`
|
|
--
|
|
ALTER TABLE `pp_layouts`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_layouts_pages`
|
|
--
|
|
ALTER TABLE `pp_layouts_pages`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `page_id` (`page_id`),
|
|
ADD KEY `layout_id` (`layout_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_menus`
|
|
--
|
|
ALTER TABLE `pp_menus`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_newsletter`
|
|
--
|
|
ALTER TABLE `pp_newsletter`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_newsletter_send`
|
|
--
|
|
ALTER TABLE `pp_newsletter_send`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_pages`
|
|
--
|
|
ALTER TABLE `pp_pages`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `id_menu` (`menu_id`),
|
|
ADD KEY `menu_id` (`menu_id`),
|
|
ADD KEY `parent_id` (`parent_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_pages_langs`
|
|
--
|
|
ALTER TABLE `pp_pages_langs`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `page_id` (`page_id`),
|
|
ADD KEY `lang_id` (`lang_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_scontainers`
|
|
--
|
|
ALTER TABLE `pp_scontainers`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_scontainers_langs`
|
|
--
|
|
ALTER TABLE `pp_scontainers_langs`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `lang_id` (`lang_id`),
|
|
ADD KEY `container_id` (`container_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_settings`
|
|
--
|
|
ALTER TABLE `pp_settings`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_attributes`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_attributes_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes_langs`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `article_id` (`attribute_id`),
|
|
ADD KEY `lang_id` (`lang_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_attributes_values`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes_values`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `attribute_id` (`attribute_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_attributes_values_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes_values_langs`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `lang_id` (`lang_id`),
|
|
ADD KEY `value_id` (`value_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_categories`
|
|
--
|
|
ALTER TABLE `pp_shop_categories`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `parent_id` (`parent_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_categories_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_categories_langs`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `page_id` (`category_id`),
|
|
ADD KEY `lang_id` (`lang_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_clients`
|
|
--
|
|
ALTER TABLE `pp_shop_clients`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_orders`
|
|
--
|
|
ALTER TABLE `pp_shop_orders`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `client_id` (`client_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_order_products`
|
|
--
|
|
ALTER TABLE `pp_shop_order_products`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `order_id` (`order_id`),
|
|
ADD KEY `product_id` (`product_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_payment_methods`
|
|
--
|
|
ALTER TABLE `pp_shop_payment_methods`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_products`
|
|
--
|
|
ALTER TABLE `pp_shop_products`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_products_attributes`
|
|
--
|
|
ALTER TABLE `pp_shop_products_attributes`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `product_id` (`product_id`),
|
|
ADD KEY `attribute_id` (`attribute_id`),
|
|
ADD KEY `value_id` (`value_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_products_categories`
|
|
--
|
|
ALTER TABLE `pp_shop_products_categories`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `page_id` (`category_id`),
|
|
ADD KEY `article_id` (`product_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_products_files`
|
|
--
|
|
ALTER TABLE `pp_shop_products_files`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `article_id` (`product_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_products_images`
|
|
--
|
|
ALTER TABLE `pp_shop_products_images`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `article_id` (`product_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_products_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_products_langs`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `article_id` (`product_id`),
|
|
ADD KEY `lang_id` (`lang_id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_products_stock`
|
|
--
|
|
ALTER TABLE `pp_shop_products_stock`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `id_product` (`id_product`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_transports`
|
|
--
|
|
ALTER TABLE `pp_shop_transports`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `pp_shop_transport_payment_methods`
|
|
--
|
|
ALTER TABLE `pp_shop_transport_payment_methods`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD KEY `id_payment_method` (`id_payment_method`),
|
|
ADD KEY `id_transport` (`id_transport`);
|
|
|
|
--
|
|
-- Indexes for table `pp_users`
|
|
--
|
|
ALTER TABLE `pp_users`
|
|
ADD PRIMARY KEY (`id`),
|
|
ADD UNIQUE KEY `login` (`login`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `grid_settings`
|
|
--
|
|
ALTER TABLE `grid_settings`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_articles`
|
|
--
|
|
ALTER TABLE `pp_articles`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_articles_files`
|
|
--
|
|
ALTER TABLE `pp_articles_files`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_articles_images`
|
|
--
|
|
ALTER TABLE `pp_articles_images`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_articles_langs`
|
|
--
|
|
ALTER TABLE `pp_articles_langs`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_articles_pages`
|
|
--
|
|
ALTER TABLE `pp_articles_pages`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_banners`
|
|
--
|
|
ALTER TABLE `pp_banners`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_langs_translations`
|
|
--
|
|
ALTER TABLE `pp_langs_translations`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_layouts`
|
|
--
|
|
ALTER TABLE `pp_layouts`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_layouts_pages`
|
|
--
|
|
ALTER TABLE `pp_layouts_pages`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_menus`
|
|
--
|
|
ALTER TABLE `pp_menus`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_newsletter`
|
|
--
|
|
ALTER TABLE `pp_newsletter`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_newsletter_send`
|
|
--
|
|
ALTER TABLE `pp_newsletter_send`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_pages`
|
|
--
|
|
ALTER TABLE `pp_pages`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_pages_langs`
|
|
--
|
|
ALTER TABLE `pp_pages_langs`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_scontainers`
|
|
--
|
|
ALTER TABLE `pp_scontainers`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_scontainers_langs`
|
|
--
|
|
ALTER TABLE `pp_scontainers_langs`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_settings`
|
|
--
|
|
ALTER TABLE `pp_settings`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_attributes`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_attributes_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes_langs`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_attributes_values`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes_values`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_attributes_values_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes_values_langs`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_categories`
|
|
--
|
|
ALTER TABLE `pp_shop_categories`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_categories_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_categories_langs`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_clients`
|
|
--
|
|
ALTER TABLE `pp_shop_clients`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_orders`
|
|
--
|
|
ALTER TABLE `pp_shop_orders`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_order_products`
|
|
--
|
|
ALTER TABLE `pp_shop_order_products`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_payment_methods`
|
|
--
|
|
ALTER TABLE `pp_shop_payment_methods`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_products`
|
|
--
|
|
ALTER TABLE `pp_shop_products`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_products_attributes`
|
|
--
|
|
ALTER TABLE `pp_shop_products_attributes`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_products_categories`
|
|
--
|
|
ALTER TABLE `pp_shop_products_categories`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_products_files`
|
|
--
|
|
ALTER TABLE `pp_shop_products_files`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_products_images`
|
|
--
|
|
ALTER TABLE `pp_shop_products_images`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_products_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_products_langs`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_products_stock`
|
|
--
|
|
ALTER TABLE `pp_shop_products_stock`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_transports`
|
|
--
|
|
ALTER TABLE `pp_shop_transports`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_shop_transport_payment_methods`
|
|
--
|
|
ALTER TABLE `pp_shop_transport_payment_methods`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
|
--
|
|
-- AUTO_INCREMENT dla tabeli `pp_users`
|
|
--
|
|
ALTER TABLE `pp_users`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
|
|
--
|
|
-- Ograniczenia dla zrzutów tabel
|
|
--
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_articles`
|
|
--
|
|
ALTER TABLE `pp_articles`
|
|
ADD CONSTRAINT `pp_articles_ibfk_1` FOREIGN KEY (`layout_id`) REFERENCES `pp_layouts` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_articles_files`
|
|
--
|
|
ALTER TABLE `pp_articles_files`
|
|
ADD CONSTRAINT `pp_articles_files_ibfk_1` FOREIGN KEY (`article_id`) REFERENCES `pp_articles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_articles_images`
|
|
--
|
|
ALTER TABLE `pp_articles_images`
|
|
ADD CONSTRAINT `pp_articles_images_ibfk_1` FOREIGN KEY (`article_id`) REFERENCES `pp_articles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_articles_langs`
|
|
--
|
|
ALTER TABLE `pp_articles_langs`
|
|
ADD CONSTRAINT `pp_articles_langs_ibfk_1` FOREIGN KEY (`lang_id`) REFERENCES `pp_langs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_articles_langs_ibfk_2` FOREIGN KEY (`article_id`) REFERENCES `pp_articles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_articles_pages`
|
|
--
|
|
ALTER TABLE `pp_articles_pages`
|
|
ADD CONSTRAINT `pp_articles_pages_ibfk_1` FOREIGN KEY (`page_id`) REFERENCES `pp_pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_articles_pages_ibfk_2` FOREIGN KEY (`article_id`) REFERENCES `pp_articles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_layouts_pages`
|
|
--
|
|
ALTER TABLE `pp_layouts_pages`
|
|
ADD CONSTRAINT `pp_layouts_pages_ibfk_1` FOREIGN KEY (`layout_id`) REFERENCES `pp_layouts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_layouts_pages_ibfk_2` FOREIGN KEY (`page_id`) REFERENCES `pp_pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_pages`
|
|
--
|
|
ALTER TABLE `pp_pages`
|
|
ADD CONSTRAINT `pp_pages_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `pp_menus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_pages_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `pp_pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_pages_langs`
|
|
--
|
|
ALTER TABLE `pp_pages_langs`
|
|
ADD CONSTRAINT `pp_pages_langs_ibfk_1` FOREIGN KEY (`page_id`) REFERENCES `pp_pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_pages_langs_ibfk_2` FOREIGN KEY (`lang_id`) REFERENCES `pp_langs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_scontainers_langs`
|
|
--
|
|
ALTER TABLE `pp_scontainers_langs`
|
|
ADD CONSTRAINT `pp_scontainers_langs_ibfk_2` FOREIGN KEY (`lang_id`) REFERENCES `pp_langs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_scontainers_langs_ibfk_3` FOREIGN KEY (`container_id`) REFERENCES `pp_scontainers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_attributes_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes_langs`
|
|
ADD CONSTRAINT `pp_shop_attributes_langs_ibfk_1` FOREIGN KEY (`attribute_id`) REFERENCES `pp_shop_attributes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_shop_attributes_langs_ibfk_2` FOREIGN KEY (`lang_id`) REFERENCES `pp_langs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_attributes_values`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes_values`
|
|
ADD CONSTRAINT `pp_shop_attributes_values_ibfk_1` FOREIGN KEY (`attribute_id`) REFERENCES `pp_shop_attributes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_attributes_values_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_attributes_values_langs`
|
|
ADD CONSTRAINT `pp_shop_attributes_values_langs_ibfk_2` FOREIGN KEY (`lang_id`) REFERENCES `pp_langs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_shop_attributes_values_langs_ibfk_3` FOREIGN KEY (`value_id`) REFERENCES `pp_shop_attributes_values` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_categories_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_categories_langs`
|
|
ADD CONSTRAINT `pp_shop_categories_langs_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `pp_shop_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_shop_categories_langs_ibfk_2` FOREIGN KEY (`lang_id`) REFERENCES `pp_langs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_orders`
|
|
--
|
|
ALTER TABLE `pp_shop_orders`
|
|
ADD CONSTRAINT `pp_shop_orders_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `pp_shop_clients` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_order_products`
|
|
--
|
|
ALTER TABLE `pp_shop_order_products`
|
|
ADD CONSTRAINT `pp_shop_order_products_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `pp_shop_orders` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
|
|
ADD CONSTRAINT `pp_shop_order_products_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `pp_shop_products` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_products_attributes`
|
|
--
|
|
ALTER TABLE `pp_shop_products_attributes`
|
|
ADD CONSTRAINT `pp_shop_products_attributes_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `pp_shop_products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_shop_products_attributes_ibfk_2` FOREIGN KEY (`attribute_id`) REFERENCES `pp_shop_attributes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_shop_products_attributes_ibfk_3` FOREIGN KEY (`value_id`) REFERENCES `pp_shop_attributes_values` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_products_categories`
|
|
--
|
|
ALTER TABLE `pp_shop_products_categories`
|
|
ADD CONSTRAINT `pp_shop_products_categories_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `pp_shop_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_shop_products_categories_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `pp_shop_products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_products_files`
|
|
--
|
|
ALTER TABLE `pp_shop_products_files`
|
|
ADD CONSTRAINT `pp_shop_products_files_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `pp_shop_products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_products_images`
|
|
--
|
|
ALTER TABLE `pp_shop_products_images`
|
|
ADD CONSTRAINT `pp_shop_products_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `pp_shop_products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_products_langs`
|
|
--
|
|
ALTER TABLE `pp_shop_products_langs`
|
|
ADD CONSTRAINT `pp_shop_products_langs_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `pp_shop_products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_shop_products_langs_ibfk_2` FOREIGN KEY (`lang_id`) REFERENCES `pp_langs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_products_stock`
|
|
--
|
|
ALTER TABLE `pp_shop_products_stock`
|
|
ADD CONSTRAINT `pp_shop_products_stock_ibfk_1` FOREIGN KEY (`id_product`) REFERENCES `pp_shop_products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
--
|
|
-- Ograniczenia dla tabeli `pp_shop_transport_payment_methods`
|
|
--
|
|
ALTER TABLE `pp_shop_transport_payment_methods`
|
|
ADD CONSTRAINT `pp_shop_transport_payment_methods_ibfk_1` FOREIGN KEY (`id_payment_method`) REFERENCES `pp_shop_payment_methods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `pp_shop_transport_payment_methods_ibfk_2` FOREIGN KEY (`id_transport`) REFERENCES `pp_shop_transports` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
/*!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 */;
|