HockeyCMS-SHOP/sqlSchema/hockey_cms.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19-11.8.6-MariaDB, for debian-linux-gnu (aarch64)
--
-- Host: localhost    Database: hockey_cms
-- ------------------------------------------------------
-- Server version	11.8.6-MariaDB-0+deb13u1 from Debian

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;

--
-- Table structure for table `attribute_groups`
--

DROP TABLE IF EXISTS `attribute_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `attribute_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attribute_groups`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `attribute_groups` WRITE;
/*!40000 ALTER TABLE `attribute_groups` DISABLE KEYS */;
INSERT INTO `attribute_groups` VALUES
(1,'ICE SKATES','ΠΑΓΟΠΕΔΙΛΑ'),
(2,'ΡΟΥΧΙΣΜΟΣ','APPAREL'),
(10,'ΜΠΑΣΤΟΥΝΙΑ','STICKS');
/*!40000 ALTER TABLE `attribute_groups` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `attributes`
--

DROP TABLE IF EXISTS `attributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `attributes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `unit` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  CONSTRAINT `attributes_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `attribute_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attributes`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `attributes` WRITE;
/*!40000 ALTER TABLE `attributes` DISABLE KEYS */;
INSERT INTO `attributes` VALUES
(1,1,'ΜΕΓΕΘΟΣ','SIZE','US'),
(3,1,'ΜΕΓΕΘΟΣ','SIZE','EU'),
(4,1,'ΚΑΤΑΣΤΑΣΗ','CONDITION',''),
(6,2,'ΜΕΓΕΘΟΣ','SIZE',''),
(7,2,'ΗΛΙΚΙΑ','AGE','YO'),
(8,2,'ΚΑΤΑΣΤΑΣΗ','CONDITION',''),
(12,10,'ΚΑΤΑΣΤΑΣΗ','CONDITION',''),
(13,10,'ΥΨΟΣ','HEIGHT','CM'),
(14,10,'ΧΕΡΙ','HAND','Left/Right');
/*!40000 ALTER TABLE `attributes` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name_el` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `slug` varchar(100) NOT NULL,
  `attribute_group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `parent_id` (`parent_id`),
  KEY `attribute_group_id` (`attribute_group_id`),
  CONSTRAINT `categories_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `categories_ibfk_2` FOREIGN KEY (`attribute_group_id`) REFERENCES `attribute_groups` (`id`) ON DELETE SET NULL,
  CONSTRAINT `categories_ibfk_3` FOREIGN KEY (`attribute_group_id`) REFERENCES `attribute_groups` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES
(1,NULL,'ΠΑΓΟΠΕΔΙΛΑ','ICE SKATES',1,'ice-skates',1),
(9,NULL,'ΕΞΟΠΛΗΣΜΟΣ ΤΕΡΜΑΤΟΦΥΛΑΚΑ','GOALIE GEAR',12,'goalie-gear',2),
(10,NULL,'ΜΠΑΣΤΟΥΝΙΑ','STICKS',2,'sticks',10),
(13,NULL,'ΡΟΥΧΙΣΜΟΣ','APPAREL',3,'apparel',2),
(15,16,'ΓΑΝΤΙΑ','GLOVES',5,'gloves',2),
(16,NULL,'ΠΡΟΣΤΑΣΙΑ','PROTECTIVE GEAR',4,'protective-gear',2),
(17,16,'ΕΠΙΑΓΚΩΝΙΔΕΣ','PADS ELBOW',6,'pads-elbow',2),
(18,16,'ΕΠΙΚΑΛΑΜΙΔΕΣ','SHIN GUARDS',7,'shin-guards',2),
(19,13,'ΘΩΡΑΚΕΣ & ΕΠΩΜΙΔΕΣ','CHEST & SOULDER PADS',9,'chest-soulder-pads',2),
(20,16,'ΚΡΑΝΟΣ','HELMET',8,'helmet',2),
(21,13,'ΠΑΝΤΕΛΟΝΙ','PANTS',10,'pants',2),
(22,13,'ΣΠΑΣΟΥΑΡ','JOCK',11,'jock',2);
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `email_templates`
--

DROP TABLE IF EXISTS `email_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_key` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `subject_el` varchar(255) NOT NULL,
  `subject_en` varchar(255) NOT NULL,
  `body_el` text NOT NULL,
  `body_en` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `template_key` (`template_key`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_templates`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `email_templates` WRITE;
/*!40000 ALTER TABLE `email_templates` DISABLE KEYS */;
INSERT INTO `email_templates` VALUES
(1,'new_order','  (  / )','HockeyGear - Επιβεβαίωση καταχώρισης παραγγελίας #{order_id}','HockeyGear - Order Confirmation #{order_id}','Αγαπητέ/ή {customer_name},\r\n\r\nΚαταχωρίθηκε επιτυχώς η παραγγελία σας με τα παρακάτω στοιχεία:\r\n\r\nΚωδικός Παραγγελίας: #{order_id}\r\n\r\nΣυνολική Τιμή: {total_amount}\r\n\r\nΠαρακαλούμε όπως επικοινωνήσετε με τον πωλητή για τη διαδικασία παραλαβής.','Dear {customer_name},\r\n\r\nYour order has been successfully placed with the following details:\r\n\r\nOrder ID: #{order_id}\r\n\r\nTotal Amount: {total_amount}\r\n\r\nPlease contact the seller to arrange your order collection/pickup.'),
(2,'status_change','  ','HockeyGear - Ενημέρωση κατάστασης παραγγελίας #{order_id}','HockeyGear - Order Status Update #{order_id}','Αγαπητέ/ή {customer_name},\r\n\r\nΣας ενημερώνουμε ότι η κατάσταση της παραγγελίας σας άλλαξε.\r\n\r\nΚωδικός Παραγγελίας: #{order_id}\r\n\r\nΝέα Κατάσταση: {status}\r\n\r\nΠαρακαλούμε επικοινωνήστε μαζί μας ή με τον πωλητή για περισσότερες πληροφορίες.','Dear {customer_name},\r\n\r\nWe would like to inform you that the status of your order has been updated.\r\n\r\nOrder ID: #{order_id}\r\n\r\nNew Status: {status}\r\n\r\nPlease contact us or the seller for further details.'),
(3,'seller_new_order','  ( )','HockeyGear - Νέα Παραγγελία #{order_id} - Πάνελ Διαχείρισης','New Sale! Order #{order_id} - Hockey CMS','Αγαπητέ συνεργάτη,\r\n\r\nΚαταχωρίθηκε νέα παραγγελία στο σύστημα με τα παρακάτω στοιχεία:\r\n\r\nΚωδικός Παραγγελίας: #{order_id}\r\n\r\nΠελάτης: {customer_name}\r\n\r\nΣυνολική Τιμή: {total_amount}\r\n\r\nΠαρακαλούμε συνδεθείτε στο πάνελ διαχείρισης για να δείτε τις λεπτομέρειες και να προχωρήσετε στις απαραίτητες ενέργειες.','Dear Partner,\r\n\r\nA new order has been placed in the system with the following details:\r\n\r\nOrder ID: #{order_id}\r\n\r\nCustomer: {customer_name}\r\n\r\nTotal Amount: {total_amount}\r\n\r\nPlease log in to your admin panel to view the details and proceed with the order fulfillment.');
/*!40000 ALTER TABLE `email_templates` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `order_items`
--

DROP TABLE IF EXISTS `order_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `order_id` (`order_id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_items`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `order_items` WRITE;
/*!40000 ALTER TABLE `order_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_items` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(100) NOT NULL,
  `customer_email` varchar(100) NOT NULL,
  `customer_phone` varchar(50) NOT NULL,
  `shipping_address` text NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `status` varchar(20) DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `product_attribute_values`
--

DROP TABLE IF EXISTS `product_attribute_values`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_attribute_values` (
  `product_id` int(11) NOT NULL,
  `attribute_id` int(11) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`product_id`,`attribute_id`),
  KEY `attribute_id` (`attribute_id`),
  CONSTRAINT `product_attribute_values_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_attribute_values_ibfk_2` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_attribute_values`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `product_attribute_values` WRITE;
/*!40000 ALTER TABLE `product_attribute_values` DISABLE KEYS */;
INSERT INTO `product_attribute_values` VALUES
(2,6,'Youth'),
(2,7,'6 to 9'),
(2,8,'Good'),
(3,6,'Large (youth)'),
(3,7,'5 to 7'),
(3,8,'Σχεδόν καινούργιο / as good as new'),
(4,6,'Large (youth)'),
(4,7,'10 to 13'),
(4,8,'2. Καλή / good'),
(5,6,'Jr.Medium'),
(5,8,'Καλή / good'),
(6,6,'Large (youth)'),
(6,7,'5 to 7'),
(6,8,'Καλή / good');
/*!40000 ALTER TABLE `product_attribute_values` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `product_images`
--

DROP TABLE IF EXISTS `product_images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `is_primary` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_images`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `product_images` WRITE;
/*!40000 ALTER TABLE `product_images` DISABLE KEYS */;
INSERT INTO `product_images` VALUES
(2,2,'uploads/equipment/prod_2_1790588393.jpg',1),
(3,3,'uploads/equipment/prod_3_1790588897.jpg',1),
(4,4,'uploads/equipment/prod_4_1790589083.jpg',1),
(5,5,'uploads/equipment/prod_5_1790589860.jpg',1),
(6,6,'uploads/equipment/prod_6_1790590114.jpg',1);
/*!40000 ALTER TABLE `product_images` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sku` varchar(50) DEFAULT NULL,
  `seller_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `attribute_group_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `search_tags` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `status` enum('available','sold','hidden') DEFAULT 'available',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `quantity` int(11) DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `seller_id` (`seller_id`),
  KEY `category_id` (`category_id`),
  KEY `attribute_group_id` (`attribute_group_id`),
  CONSTRAINT `products_ibfk_1` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`),
  CONSTRAINT `products_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `products_ibfk_3` FOREIGN KEY (`attribute_group_id`) REFERENCES `attribute_groups` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES
(2,NULL,1,15,2,'Bauer Supreme one 20','','gloves, γαντια, προστασια',20.00,'sold','2026-09-28 09:39:03',0),
(3,NULL,1,17,2,'Bauer Supreme Pro','','επιαγκωνιδες, pads elbow, προστασια',15.00,'available','2026-09-28 09:45:02',1),
(4,NULL,1,17,2,'Bauer NSX','','επιαγκωνιδες, pads elbow',15.00,'available','2026-09-28 09:51:23',1),
(5,NULL,1,18,2,'Jr.Medium','','επικαλαμιδες, shin, guards',15.00,'available','2026-09-28 10:04:20',1),
(6,NULL,1,18,2,'Bauer Supreme Pro','','',10.00,'available','2026-09-28 10:08:33',1);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES
(1,'administrator'),
(2,'seller'),
(3,'user');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `key` varchar(50) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES
('active_theme','default'),
('allow_user_to_seller','1'),
('mail_from_address','athenshockeygear@gmail.com'),
('mail_from_name','Athens Hockey Gear'),
('site_logo','uploads/logo_1790669499.jpg'),
('smtp_encryption','tls'),
('smtp_host','smtp.gmail.com'),
('smtp_password','mdaexymcizvutjjh'),
('smtp_port','587'),
('smtp_username','athenshockeygear@gmail.com');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

--
-- Table structure for table `site_texts`
--

DROP TABLE IF EXISTS `site_texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_texts` (
  `text_key` varchar(100) NOT NULL,
  `text_value_el` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `text_value_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`text_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_texts`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `site_texts` WRITE;
/*!40000 ALTER TABLE `site_texts` DISABLE KEYS */;
INSERT INTO `site_texts` VALUES
('btn_view_product','','View','     '),
('category_subtitle_prefix','','Results :','      '),
('category_title_prefix','','Category :','       '),
('filter_price_from','','From','Placeholder  '),
('filter_price_label','','Price :','    '),
('filter_price_to','','To','Placeholder  '),
('filter_sort_label','','Order :','   dropdown '),
('header_cart_btn','','Cart','   '),
('header_login_btn','','Login','     '),
('header_logo_text','','TradeHockey','  /   e-shop    '),
('header_search_btn','','Search','   '),
('header_search_placeholder','...','...','    '),
('sidebar_categories_title','','Categories','      '),
('site_slogan','','Sell & Buy Hockey Gear','     '),
('site_sub_slogan','','Used and new Hockey Gear','        '),
('title_new_arrivals','','New Entries','      ');
/*!40000 ALTER TABLE `site_texts` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `is_seller` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `role_id` (`role_id`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0;
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,1,'admin','sparmaksitzian@gmail.com','6943078334','$2y$12$eIpc5tWDqNHNhGwW7VJhpOIc0M1twWFgEu6MSt.kgs.GjdbAmyTjG','Super','Admin','2026-09-27 13:25:04',1),
(4,3,'eparmak','maidawmn@gmail.com','','$2y$12$POty9nKbADIDWVf/mNOq1ePopW4Klq6rn6OXrJfETed5FUvzQLgUm','Stathis','Parmaksitzian','2026-09-27 21:50:17',1),
(5,3,'parmaksitziand@gmail.com','parmaksitziand@gmail.com',NULL,'$2y$12$S4OUCHLVBhzPoeuUnZ1DNOvfR5SuOi92OoqOZ.yj.z9g375wBPMYO','Dimitris','Parmaksitzian','2026-09-29 07:46:37',0);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

-- Dump completed on 2026-09-29 12:29:47