SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS=0;
CREATE TABLE users(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,first_name VARCHAR(60) NOT NULL,last_name VARCHAR(60) NOT NULL,username VARCHAR(40) NOT NULL UNIQUE,phone VARCHAR(20) NOT NULL UNIQUE,email VARCHAR(150) NOT NULL UNIQUE,password_hash VARCHAR(255) NOT NULL,status ENUM('active','blocked') NOT NULL DEFAULT 'active',is_staff TINYINT(1) NOT NULL DEFAULT 0,email_verified_at DATETIME NULL,phone_verified_at DATETIME NULL,last_seen DATETIME NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,INDEX(status),INDEX(is_staff))ENGINE=InnoDB;
CREATE TABLE user_profiles(user_id INT UNSIGNED PRIMARY KEY,avatar VARCHAR(255) NULL,bio VARCHAR(255) NULL,lang ENUM('fa','en') NOT NULL DEFAULT 'fa',FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE roles(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,name VARCHAR(40) NOT NULL UNIQUE)ENGINE=InnoDB;
CREATE TABLE permissions(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,code VARCHAR(60) NOT NULL UNIQUE)ENGINE=InnoDB;
CREATE TABLE role_permissions(role_id INT UNSIGNED,permission_id INT UNSIGNED,PRIMARY KEY(role_id,permission_id),FOREIGN KEY(role_id)REFERENCES roles(id)ON DELETE CASCADE,FOREIGN KEY(permission_id)REFERENCES permissions(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE user_roles(user_id INT UNSIGNED,role_id INT UNSIGNED,PRIMARY KEY(user_id,role_id),FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE,FOREIGN KEY(role_id)REFERENCES roles(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE service_categories(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,name_fa VARCHAR(80) NOT NULL,name_en VARCHAR(80) NOT NULL,sort INT NOT NULL DEFAULT 0,active TINYINT(1) NOT NULL DEFAULT 1)ENGINE=InnoDB;
CREATE TABLE staff(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,name VARCHAR(100) NOT NULL,title VARCHAR(100) NULL,avatar VARCHAR(255) NULL,active TINYINT(1) NOT NULL DEFAULT 1)ENGINE=InnoDB;
CREATE TABLE services(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,category_id INT UNSIGNED NOT NULL,staff_id INT UNSIGNED NULL,name_fa VARCHAR(120) NOT NULL,name_en VARCHAR(120) NOT NULL,desc_fa TEXT NULL,desc_en TEXT NULL,image VARCHAR(255) NULL,price BIGINT UNSIGNED NOT NULL,sale_price BIGINT UNSIGNED NULL,duration_min SMALLINT UNSIGNED NOT NULL,buffer_min SMALLINT UNSIGNED NOT NULL DEFAULT 0,daily_capacity SMALLINT UNSIGNED NOT NULL DEFAULT 20,active TINYINT(1) NOT NULL DEFAULT 1,FOREIGN KEY(category_id)REFERENCES service_categories(id),FOREIGN KEY(staff_id)REFERENCES staff(id)ON DELETE SET NULL,INDEX(active))ENGINE=InnoDB;
CREATE TABLE staff_schedules(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,staff_id INT UNSIGNED NOT NULL,weekday TINYINT NOT NULL,start_time TIME NOT NULL,end_time TIME NOT NULL,FOREIGN KEY(staff_id)REFERENCES staff(id)ON DELETE CASCADE,INDEX(staff_id,weekday))ENGINE=InnoDB;
CREATE TABLE bookings(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,code CHAR(10) NOT NULL UNIQUE,user_id INT UNSIGNED NOT NULL,service_id INT UNSIGNED NOT NULL,staff_id INT UNSIGNED NOT NULL,start_at DATETIME NOT NULL,end_at DATETIME NOT NULL,price BIGINT UNSIGNED NOT NULL,status ENUM('pending','confirmed','rejected','cancelled','done') NOT NULL DEFAULT 'pending',slot_key VARCHAR(40) NULL UNIQUE,note VARCHAR(255) NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,FOREIGN KEY(user_id)REFERENCES users(id),FOREIGN KEY(service_id)REFERENCES services(id),FOREIGN KEY(staff_id)REFERENCES staff(id),INDEX(staff_id,start_at),INDEX(user_id,status))ENGINE=InnoDB;
CREATE TABLE booking_status_history(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,booking_id INT UNSIGNED NOT NULL,old_status VARCHAR(20),new_status VARCHAR(20),changed_by INT UNSIGNED NULL,note VARCHAR(255),created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,FOREIGN KEY(booking_id)REFERENCES bookings(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE blocked_dates(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,date_from DATE NOT NULL,date_to DATE NOT NULL,reason VARCHAR(150) NULL)ENGINE=InnoDB;
CREATE TABLE blocked_time_slots(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,day DATE NOT NULL,start_time TIME NOT NULL,end_time TIME NOT NULL,staff_id INT UNSIGNED NULL,INDEX(day))ENGINE=InnoDB;
CREATE TABLE posts(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,author_id INT UNSIGNED NOT NULL,caption TEXT NULL,hashtags VARCHAR(255) NULL,category VARCHAR(60) NULL,category_id INT UNSIGNED NULL,kind ENUM('image','video','multi') NOT NULL DEFAULT 'image',cover VARCHAR(255) NULL,status ENUM('published','hidden','scheduled') NOT NULL DEFAULT 'published',publish_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,shares INT UNSIGNED NOT NULL DEFAULT 0,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,FOREIGN KEY(author_id)REFERENCES users(id),INDEX(status,publish_at))ENGINE=InnoDB;
CREATE TABLE post_media(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,post_id INT UNSIGNED NOT NULL,file VARCHAR(255) NOT NULL,type ENUM('image','video') NOT NULL,sort TINYINT NOT NULL DEFAULT 0,FOREIGN KEY(post_id)REFERENCES posts(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE post_likes(post_id INT UNSIGNED,user_id INT UNSIGNED,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(post_id,user_id),FOREIGN KEY(post_id)REFERENCES posts(id)ON DELETE CASCADE,FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE post_comments(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,post_id INT UNSIGNED NOT NULL,user_id INT UNSIGNED NOT NULL,parent_id INT UNSIGNED NULL,body VARCHAR(1000) NOT NULL,blocked TINYINT(1) NOT NULL DEFAULT 0,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,FOREIGN KEY(post_id)REFERENCES posts(id)ON DELETE CASCADE,FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE,INDEX(post_id))ENGINE=InnoDB;
CREATE TABLE comment_likes(comment_id INT UNSIGNED,user_id INT UNSIGNED,PRIMARY KEY(comment_id,user_id),FOREIGN KEY(comment_id)REFERENCES post_comments(id)ON DELETE CASCADE,FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE post_saves(post_id INT UNSIGNED,user_id INT UNSIGNED,PRIMARY KEY(post_id,user_id),FOREIGN KEY(post_id)REFERENCES posts(id)ON DELETE CASCADE,FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE post_views(post_id INT UNSIGNED,user_id INT UNSIGNED,PRIMARY KEY(post_id,user_id),FOREIGN KEY(post_id)REFERENCES posts(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE post_reports(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,post_id INT UNSIGNED NOT NULL,user_id INT UNSIGNED NOT NULL,reason VARCHAR(255),created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,UNIQUE(post_id,user_id))ENGINE=InnoDB;
CREATE TABLE stories(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,author_id INT UNSIGNED NOT NULL,file VARCHAR(255) NOT NULL,type ENUM('image','video') NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,expires_at DATETIME NOT NULL,deleted TINYINT(1) NOT NULL DEFAULT 0,FOREIGN KEY(author_id)REFERENCES users(id),INDEX(expires_at))ENGINE=InnoDB;
CREATE TABLE story_views(story_id INT UNSIGNED,user_id INT UNSIGNED,viewed_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(story_id,user_id),FOREIGN KEY(story_id)REFERENCES stories(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE story_likes(story_id INT UNSIGNED,user_id INT UNSIGNED,liked_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(story_id,user_id),FOREIGN KEY(story_id)REFERENCES stories(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE story_replies(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,story_id INT UNSIGNED NOT NULL,user_id INT UNSIGNED NOT NULL,body VARCHAR(500) NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,FOREIGN KEY(story_id)REFERENCES stories(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE conversations(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,type ENUM('support','group') NOT NULL DEFAULT 'support',user_id INT UNSIGNED NULL UNIQUE,name VARCHAR(80) NULL,avatar VARCHAR(255) NULL,created_by INT UNSIGNED NULL,assigned_to INT UNSIGNED NULL,status ENUM('open','archived') NOT NULL DEFAULT 'open',internal_note TEXT NULL,last_message_at DATETIME NULL,FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE conversation_participants(conversation_id INT UNSIGNED,user_id INT UNSIGNED,PRIMARY KEY(conversation_id,user_id),FOREIGN KEY(conversation_id)REFERENCES conversations(id)ON DELETE CASCADE,INDEX(user_id))ENGINE=InnoDB;
CREATE TABLE messages(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,conversation_id INT UNSIGNED NOT NULL,sender_id INT UNSIGNED NOT NULL,kind ENUM('text','image','video','file','voice','poll') NOT NULL DEFAULT 'text',poll_id INT UNSIGNED NULL,body TEXT NULL,reply_to BIGINT UNSIGNED NULL,reaction VARCHAR(8) NULL,story_id INT UNSIGNED NULL,deleted TINYINT(1) NOT NULL DEFAULT 0,delivered_at DATETIME NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,FOREIGN KEY(conversation_id)REFERENCES conversations(id)ON DELETE CASCADE,INDEX(conversation_id,id),FULLTEXT(body))ENGINE=InnoDB;
CREATE TABLE message_attachments(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,message_id BIGINT UNSIGNED NOT NULL,file VARCHAR(255) NOT NULL,mime VARCHAR(100),size INT UNSIGNED,duration SMALLINT UNSIGNED NULL,FOREIGN KEY(message_id)REFERENCES messages(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE message_reads(message_id BIGINT UNSIGNED,user_id INT UNSIGNED,read_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(message_id,user_id),FOREIGN KEY(message_id)REFERENCES messages(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE notifications(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id INT UNSIGNED NOT NULL,type VARCHAR(40) NOT NULL,title_fa VARCHAR(160),title_en VARCHAR(160),link VARCHAR(160),read_at DATETIME NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE,INDEX(user_id,read_at))ENGINE=InnoDB;
CREATE TABLE notification_preferences(user_id INT UNSIGNED,type VARCHAR(40),enabled TINYINT(1) NOT NULL DEFAULT 1,PRIMARY KEY(user_id,type))ENGINE=InnoDB;
CREATE TABLE site_settings(k VARCHAR(60) PRIMARY KEY,v TEXT)ENGINE=InnoDB;
CREATE TABLE translations(lang CHAR(2),k VARCHAR(80),v TEXT,PRIMARY KEY(lang,k))ENGINE=InnoDB;
CREATE TABLE activity_logs(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id INT UNSIGNED NULL,action VARCHAR(60) NOT NULL,detail VARCHAR(500),ip VARCHAR(45),created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,INDEX(action),INDEX(created_at))ENGINE=InnoDB;
CREATE TABLE security_logs(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,event VARCHAR(60) NOT NULL,detail VARCHAR(500),ip VARCHAR(45),created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP)ENGINE=InnoDB;
CREATE TABLE discounts(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,code VARCHAR(30) NOT NULL UNIQUE,percent TINYINT UNSIGNED NOT NULL,max_uses INT UNSIGNED NULL,used INT UNSIGNED NOT NULL DEFAULT 0,expires_at DATETIME NULL,active TINYINT(1) NOT NULL DEFAULT 1)ENGINE=InnoDB;
CREATE TABLE reviews(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id INT UNSIGNED NOT NULL,service_id INT UNSIGNED NOT NULL,rating TINYINT NOT NULL,body VARCHAR(600),created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,UNIQUE(user_id,service_id))ENGINE=InnoDB;
CREATE TABLE password_resets(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id INT UNSIGNED NOT NULL,token_hash CHAR(64) NOT NULL,expires_at DATETIME NOT NULL,used TINYINT(1) NOT NULL DEFAULT 0)ENGINE=InnoDB;
CREATE TABLE login_attempts(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,ident VARCHAR(80) NOT NULL,ip VARCHAR(45) NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,INDEX(ident,created_at),INDEX(ip,created_at))ENGINE=InnoDB;
CREATE TABLE rate_limits(k VARCHAR(80) NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,INDEX(k,created_at))ENGINE=InnoDB;
CREATE TABLE polls(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,question VARCHAR(250) NOT NULL,multiple TINYINT(1) NOT NULL DEFAULT 0,created_by INT UNSIGNED NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP)ENGINE=InnoDB;
CREATE TABLE poll_options(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,poll_id INT UNSIGNED NOT NULL,text VARCHAR(150) NOT NULL,sort TINYINT NOT NULL DEFAULT 0,FOREIGN KEY(poll_id)REFERENCES polls(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE poll_votes(poll_id INT UNSIGNED NOT NULL,option_id INT UNSIGNED NOT NULL,user_id INT UNSIGNED NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(option_id,user_id),INDEX(poll_id,user_id),FOREIGN KEY(option_id)REFERENCES poll_options(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE post_categories(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,name_fa VARCHAR(80) NOT NULL,name_en VARCHAR(80) NOT NULL,sort INT NOT NULL DEFAULT 0,active TINYINT(1) NOT NULL DEFAULT 1)ENGINE=InnoDB;
CREATE TABLE user_permissions(user_id INT UNSIGNED NOT NULL,permission_id INT UNSIGNED NOT NULL,PRIMARY KEY(user_id,permission_id),FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE,FOREIGN KEY(permission_id)REFERENCES permissions(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE user_follows(follower_id INT UNSIGNED NOT NULL,author_id INT UNSIGNED NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(follower_id,author_id),INDEX(author_id),FOREIGN KEY(follower_id)REFERENCES users(id)ON DELETE CASCADE,FOREIGN KEY(author_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE email_verifications(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id INT UNSIGNED NOT NULL,token_hash CHAR(64) NOT NULL,expires_at DATETIME NOT NULL,used TINYINT(1) NOT NULL DEFAULT 0,INDEX(token_hash),FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE phone_codes(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id INT UNSIGNED NOT NULL,code_hash VARCHAR(255) NOT NULL,expires_at DATETIME NOT NULL,tries TINYINT NOT NULL DEFAULT 0,used TINYINT(1) NOT NULL DEFAULT 0,INDEX(user_id),FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE post_favorites(post_id INT UNSIGNED NOT NULL,user_id INT UNSIGNED NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(post_id,user_id),FOREIGN KEY(post_id)REFERENCES posts(id)ON DELETE CASCADE,FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE service_favorites(user_id INT UNSIGNED NOT NULL,service_id INT UNSIGNED NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(user_id,service_id),FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE,FOREIGN KEY(service_id)REFERENCES services(id)ON DELETE CASCADE)ENGINE=InnoDB;
CREATE TABLE user_sessions(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id INT UNSIGNED NOT NULL,sid_hash CHAR(64) NOT NULL UNIQUE,ip VARCHAR(45) NULL,ua VARCHAR(255) NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,last_seen DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,INDEX(user_id),FOREIGN KEY(user_id)REFERENCES users(id)ON DELETE CASCADE)ENGINE=InnoDB;
SET FOREIGN_KEY_CHECKS=1;
INSERT INTO roles(name)VALUES('super_admin'),('admin'),('receptionist'),('content_manager'),('support_manager');
INSERT INTO permissions(code)VALUES('dashboard'),('users'),('admins'),('content'),('services'),('bookings'),('chat'),('settings'),('logs'),('media'),('translations');
INSERT INTO role_permissions SELECT r.id,p.id FROM roles r JOIN permissions p WHERE r.name IN('super_admin','admin');
INSERT INTO role_permissions SELECT r.id,p.id FROM roles r JOIN permissions p WHERE r.name='content_manager' AND p.code='media';
INSERT INTO role_permissions SELECT r.id,p.id FROM roles r JOIN permissions p WHERE r.name='receptionist' AND p.code IN('dashboard','bookings','services');
INSERT INTO role_permissions SELECT r.id,p.id FROM roles r JOIN permissions p WHERE r.name='content_manager' AND p.code IN('dashboard','content');
INSERT INTO role_permissions SELECT r.id,p.id FROM roles r JOIN permissions p WHERE r.name='support_manager' AND p.code IN('dashboard','chat','users');
INSERT INTO site_settings(k,v)VALUES('site_name','Glow Salon'),('salon_name','Glow Salon'),('phone',''),('email',''),('address',''),('open_time','09:00'),('close_time','20:00'),('cancel_hours','12'),('slot_step','30'),('accent','#ff3d81'),('maintenance','0');
INSERT INTO service_categories(name_fa,name_en,sort)VALUES('خدمات مو','Hair',1),('رنگ و مش','Color',2),('ناخن','Nails',3),('آرایش','Makeup',4),('پاکسازی پوست','Skin care',5),('مژه و ابرو','Lashes & brows',6),('خدمات عروس','Bridal',7);
INSERT INTO site_settings(k,v)VALUES('accent2','#ffb347'),('default_lang','fa'),('sec_max_attempts','8'),('sec_lock_minutes','15'),('sec_pw_min','8'),('sec_require_verified','0'),('sec_upload_mb','100'),('notif_email','0'),
('hours_json','{"0":{"c":0,"o":"09:00","e":"20:00"},"1":{"c":0,"o":"09:00","e":"20:00"},"2":{"c":0,"o":"09:00","e":"20:00"},"3":{"c":0,"o":"09:00","e":"20:00"},"4":{"c":0,"o":"09:00","e":"20:00"},"5":{"c":1,"o":"09:00","e":"20:00"},"6":{"c":0,"o":"09:00","e":"20:00"}}');
INSERT INTO post_categories(name_fa,name_en,sort)VALUES('کار‌ها','Work',1),('آموزش','Tips',2),('تخفیف','Offers',3);