-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 28, 2026 at 03:43 PM
-- Server version: 10.6.27-MariaDB-log
-- PHP Version: 8.3.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 */;

--
-- Database: `consmcpg_shtastliveca`
--

-- --------------------------------------------------------

--
-- Table structure for table `awards`
--

CREATE TABLE `awards` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `PostDate` datetime NOT NULL,
  `LastUpdate` datetime NOT NULL,
  `Title` varchar(128) NOT NULL,
  `FilePath` varchar(64) NOT NULL,
  `OnFirstPage` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `borica`
--

CREATE TABLE `borica` (
  `OrderID` int(10) NOT NULL,
  `PostDate` datetime NOT NULL,
  `Data` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `careers`
--

CREATE TABLE `careers` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `PostDate` datetime DEFAULT NULL,
  `LastUpdate` datetime DEFAULT NULL,
  `StartFrom` date DEFAULT NULL,
  `EndTo` date DEFAULT NULL,
  `Title` varchar(120) NOT NULL,
  `URLLabel` varchar(64) NOT NULL,
  `Annotation` varchar(255) NOT NULL,
  `Content` text NOT NULL,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `PostDate` datetime NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `Content` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `europrojects`
--

CREATE TABLE `europrojects` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `PostDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `LastUpdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Title` varchar(255) NOT NULL,
  `Annotation` text NOT NULL,
  `FilePath` varchar(64) NOT NULL,
  `Documents` varchar(64) NOT NULL,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `PostDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `LastUpdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Title` varchar(120) NOT NULL,
  `URLLabel` varchar(32) NOT NULL,
  `Annotation` varchar(255) NOT NULL,
  `FilePath` varchar(64) NOT NULL,
  `Photos` text NOT NULL,
  `PhotoLabels` text NOT NULL,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `gb_opinions`
--

CREATE TABLE `gb_opinions` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `PostDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `LastUpdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `FullName` varchar(64) NOT NULL,
  `Phone` varchar(64) NOT NULL,
  `EMail` varchar(64) NOT NULL,
  `Evaluation` varchar(255) NOT NULL,
  `Opinion` text NOT NULL,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `ID` bigint(20) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `Supplier` varchar(32) NOT NULL,
  `PostDate` datetime DEFAULT NULL,
  `LastUpdate` datetime DEFAULT NULL,
  `Type` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `Data` text DEFAULT NULL,
  `SearchKey` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL,
  `PostDate` datetime NOT NULL,
  `LastUpdate` datetime NOT NULL,
  `Title` varchar(128) NOT NULL,
  `FilePath` varchar(64) NOT NULL,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL,
  `PostDate` datetime NOT NULL,
  `LastUpdate` datetime NOT NULL,
  `MetaTitle` varchar(128) DEFAULT NULL,
  `MetaDescription` varchar(255) DEFAULT NULL,
  `MetaImage` varchar(64) DEFAULT NULL,
  `Title` varchar(128) NOT NULL,
  `URLLabel` varchar(32) NOT NULL,
  `Annotation` varchar(255) NOT NULL,
  `Content` longtext NOT NULL,
  `FilePath` varchar(64) NOT NULL,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `PostDate` datetime NOT NULL,
  `LastUpdate` datetime NOT NULL,
  `Title` varchar(128) NOT NULL,
  `FilePath` varchar(64) NOT NULL,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `reservations`
--

CREATE TABLE `reservations` (
  `ID` int(10) UNSIGNED NOT NULL,
  `RestaurantID` char(2) DEFAULT NULL,
  `PostDate` datetime DEFAULT NULL,
  `LastUpdate` datetime DEFAULT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `FullName` varchar(64) DEFAULT NULL,
  `Phone` varchar(64) DEFAULT NULL,
  `EMail` varchar(64) DEFAULT NULL,
  `ResDate` date DEFAULT NULL,
  `ResTime` time DEFAULT NULL,
  `Seats` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
  `Comment` varchar(255) DEFAULT NULL,
  `Earnest` float(5,2) UNSIGNED NOT NULL DEFAULT 0.00,
  `Status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `Sent` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `BoricaID` int(12) UNSIGNED NOT NULL DEFAULT 0,
  `Borica` text DEFAULT NULL,
  `InvoiceID` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `UserID` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `ResID` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `InvoiceData` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `restaurants`
--

CREATE TABLE `restaurants` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL,
  `PostDate` datetime NOT NULL,
  `LastUpdate` datetime NOT NULL,
  `Title` varchar(128) NOT NULL,
  `Town` varchar(64) NOT NULL,
  `URLLabel` varchar(64) NOT NULL,
  `Annotation` varchar(255) NOT NULL,
  `About` text NOT NULL,
  `TownInfo` text NOT NULL,
  `Photos` text NOT NULL,
  `PhotosTown` text NOT NULL,
  `Slider` text NOT NULL,
  `GalleryLabel` varchar(64) DEFAULT NULL,
  `Address` varchar(128) NOT NULL,
  `Phone` varchar(64) NOT NULL,
  `SocialImg` varchar(64) NOT NULL,
  `GoogleMapsLink` text NOT NULL,
  `TripAdvisor` text NOT NULL,
  `Tour360` text NOT NULL,
  `FacebookLink` text NOT NULL,
  `GooglePlusLink` text NOT NULL,
  `PinterestLink` text NOT NULL,
  `InstagramLink` text NOT NULL,
  `FoursquareLink` text NOT NULL,
  `TwitterLink` text NOT NULL,
  `MenuLink` varchar(255) NOT NULL,
  `TakeawayLink` varchar(255) NOT NULL,
  `FoodpandaLink` varchar(255) NOT NULL,
  `CameraLink` varchar(255) DEFAULT NULL,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `res_users`
--

CREATE TABLE `res_users` (
  `ID` int(10) UNSIGNED NOT NULL,
  `RegDate` datetime NOT NULL,
  `LastUpdate` datetime NOT NULL,
  `EMail` varchar(125) NOT NULL DEFAULT '',
  `Password` varchar(32) NOT NULL,
  `FullName` varchar(255) NOT NULL,
  `StaffPosition` varchar(32) NOT NULL,
  `Access` enum('admin','staff') NOT NULL DEFAULT 'staff',
  `Visible` tinyint(1) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `ID` int(10) UNSIGNED NOT NULL,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `PostDate` datetime NOT NULL,
  `LastUpdate` datetime NOT NULL,
  `StartFrom` date NOT NULL DEFAULT '0000-00-00',
  `EndTo` date NOT NULL DEFAULT '0000-00-00',
  `Title` varchar(255) NOT NULL,
  `FilePath` varchar(64) NOT NULL,
  `WebPageURL` varchar(255) DEFAULT NULL,
  `Visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `ID` int(10) UNSIGNED NOT NULL,
  `RegDate` datetime NOT NULL,
  `LastUpdate` datetime NOT NULL,
  `EMail` varchar(64) NOT NULL,
  `Password` varchar(32) NOT NULL,
  `FullName` varchar(64) NOT NULL,
  `Phone` varchar(64) NOT NULL,
  `Country` varchar(64) NOT NULL,
  `City` varchar(64) NOT NULL,
  `Address` varchar(128) NOT NULL,
  `PostalCode` varchar(32) NOT NULL,
  `Access` tinyint(3) UNSIGNED NOT NULL,
  `SecureKey` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `vouchers`
--

CREATE TABLE `vouchers` (
  `ID` int(10) UNSIGNED NOT NULL,
  `PostDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `LastUpdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `BoricaID` int(12) NOT NULL DEFAULT 0,
  `Language` char(2) NOT NULL DEFAULT 'bg',
  `Data` text NOT NULL,
  `Status` tinyint(3) NOT NULL DEFAULT 0,
  `InvoiceID` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `UserID` int(10) NOT NULL DEFAULT 0,
  `RestaurantID` char(2) NOT NULL DEFAULT '',
  `PaymentKey` varchar(64) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `awards`
--
ALTER TABLE `awards`
  ADD PRIMARY KEY (`ID`,`Language`);

--
-- Indexes for table `borica`
--
ALTER TABLE `borica`
  ADD PRIMARY KEY (`OrderID`,`PostDate`),
  ADD KEY `OrderID` (`OrderID`);

--
-- Indexes for table `careers`
--
ALTER TABLE `careers`
  ADD PRIMARY KEY (`ID`,`Language`),
  ADD UNIQUE KEY `Language` (`Language`,`URLLabel`);

--
-- Indexes for table `europrojects`
--
ALTER TABLE `europrojects`
  ADD PRIMARY KEY (`ID`,`Language`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`ID`,`Language`),
  ADD UNIQUE KEY `LangLabel` (`Language`,`URLLabel`);

--
-- Indexes for table `gb_opinions`
--
ALTER TABLE `gb_opinions`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`ID`,`Language`,`Supplier`) USING BTREE,
  ADD KEY `Type` (`Type`);
ALTER TABLE `invoices` ADD FULLTEXT KEY `SearchKey` (`SearchKey`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`ID`,`Language`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`ID`,`Language`),
  ADD UNIQUE KEY `Label` (`Language`,`URLLabel`),
  ADD KEY `URLLabel` (`URLLabel`,`Language`,`Visible`);

--
-- Indexes for table `partners`
--
ALTER TABLE `partners`
  ADD PRIMARY KEY (`ID`,`Language`);

--
-- Indexes for table `reservations`
--
ALTER TABLE `reservations`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `BoricaID` (`BoricaID`);

--
-- Indexes for table `restaurants`
--
ALTER TABLE `restaurants`
  ADD PRIMARY KEY (`ID`,`Language`),
  ADD UNIQUE KEY `Label` (`Language`,`URLLabel`),
  ADD KEY `URLLabel` (`URLLabel`,`Language`,`Visible`);

--
-- Indexes for table `res_users`
--
ALTER TABLE `res_users`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`ID`,`Language`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`ID`),
  ADD UNIQUE KEY `EMail` (`EMail`);

--
-- Indexes for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `gb_opinions`
--
ALTER TABLE `gb_opinions`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reservations`
--
ALTER TABLE `reservations`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `res_users`
--
ALTER TABLE `res_users`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vouchers`
--
ALTER TABLE `vouchers`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!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 */;
