Devco1 Shell

Filename : sess_3566036c9869f8907aa0cd9286b66184
back
 PMA_token |s:32:"754a343f3769743857704873386a583f"; HMAC_secret |s:16:"!qXZIL?Iq'GT=<pO";auth_type|s:3:"env";browser_access_time|a:2:{s:7:"default";i:1763898569;s:36:"75f2b5ff-2380-b432-ed9b-c934e0729bc7";i:1763889175;}encryption_key|s:32:"�S��<_�<����[^�ܳ��x�eX�";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.2";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:1:{s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1763898330;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1763898330;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1758152040;s:9:"userprefs";a:1:{s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}s:17:"server_1_wifiyecu";a:16:{s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:0:{}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:7:"Plugins";s:6:"engine";s:7:"Engines";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:5:"query";s:5:"Query";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:9:"operation";s:10:"Operations";s:10:"privileges";s:10:"Privileges";s:8:"routines";s:8:"Routines";s:6:"events";s:6:"Events";s:8:"triggers";s:8:"Triggers";s:8:"tracking";s:8:"Tracking";s:8:"designer";s:8:"Designer";s:15:"central_columns";s:15:"Central columns";}s:12:"is_superuser";b:0;s:14:"mysql_cur_user";s:18:"wifiyecu@localhost";s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}}tmpval|a:14:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:0:{}}s:5:"query";a:10:{s:32:"db6c02e86163a8eb68b0ca2ee13946a9";a:8:{s:3:"sql";s:320:"-- جدول سلة التسوق
CREATE TABLE cart (
    id INT AUTO_INCREMENT PRIMARY KEY,
    session_id VARCHAR(255),
    product_id INT,
    quantity INT DEFAULT 1,
    color_id INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (product_id) REFERENCES products(id) ON DELETE CASCADE
);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"5ba5ae086c29f12f7c048b69c3b4d781";a:8:{s:3:"sql";s:519:"-- جدول الطلبات
CREATE TABLE orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    customer_name VARCHAR(255) NOT NULL,
    customer_email VARCHAR(255) NOT NULL,
    customer_phone VARCHAR(20) NOT NULL,
    customer_address TEXT NOT NULL,
    total_amount DECIMAL(10,2) NOT NULL,
    status ENUM('pending', 'processing', 'completed', 'cancelled') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"986eca976ec6f66088bd0e666ca555fb";a:8:{s:3:"sql";s:366:"-- جدول تفاصيل الطلب
CREATE TABLE order_items (
    id INT AUTO_INCREMENT PRIMARY KEY,
    order_id INT,
    product_id INT,
    product_name VARCHAR(255),
    quantity INT,
    price DECIMAL(10,2),
    FOREIGN KEY (order_id) REFERENCES orders(id) ON DELETE CASCADE,
    FOREIGN KEY (product_id) REFERENCES products(id) ON DELETE SET NULL
);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"1835eb85d42cfe26f1e243fbe8995003";a:8:{s:3:"sql";s:253:"-- جدول المديرين
CREATE TABLE admins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(100) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"b1be16a90a13b3393bbae6b4a1b41f4c";a:8:{s:3:"sql";s:626:"-- إدخال بيانات تجريبية
INSERT INTO products (name, description, price, old_price, brand, stock_quantity) VALUES
('iPhone 15 Pro', 'أحدث هاتف من Apple بشريحة A17 Pro وكاميرا متطورة', 3999.00, 4299.00, 'Apple', 50),
('Samsung Galaxy S24', 'هاتف سامسونج الذكي بشاشة ديناميكية AMOLED', 3499.00, NULL, 'Samsung', 30),
('Huawei P60 Pro', 'هاتف هواوي بكاميرا XMAGE المتقدمة', 2899.00, 3199.00, 'Huawei', 25),
('Xiaomi 13 Pro', 'هاتف شاومي بشاشة LTPO OLED وبطارية كبيرة', 2599.00, NULL, 'Xiaomi', 40);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"30929cd94e5baf41b9c62a4465ad359c";a:8:{s:3:"sql";s:295:"INSERT INTO product_images (product_id, image_url, is_main) VALUES
(1, 'images/products/iphone15pro-1.jpg', 1),
(1, 'images/products/iphone15pro-2.jpg', 0),
(2, 'images/products/galaxys24-1.jpg', 1),
(3, 'images/products/huaweip60pro-1.jpg', 1),
(4, 'images/products/xiaomi13pro-1.jpg', 1);";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"4a79fb5182946824680af3d4c00b84f3";a:8:{s:3:"sql";s:368:"INSERT INTO colors (product_id, color_name, color_code) VALUES
(1, 'تيتانيوم طبيعي', '#8A8A8A'),
(1, 'تيتانيوم أزرق', '#007AFF'),
(1, 'تيتانيوم أبيض', '#F2F2F2'),
(2, 'أونيكس أسود', '#000000'),
(2, 'رخامي رمادي', '#666666'),
(3, 'روكسي أزرق', '#1E3A8A'),
(3, 'كوارتز أبيض', '#FFFFFF');";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"37cfebf6b93353028547ce7b4ddb1619";a:8:{s:3:"sql";s:430:"INSERT INTO reviews (product_id, user_name, rating, comment) VALUES
(1, 'أحمد محمد', 5, 'هاتف رائع وسريع جداً، الكاميرا مذهلة'),
(1, 'فاطمة علي', 4, 'جيد جداً لكن السعر مرتفع قليلاً'),
(2, 'خالد عبدالله', 5, 'شاشة رائعة وأداء ممتاز'),
(3, 'سارة أحمد', 4, 'تصميم جميل وبطارية تدوم طويلاً');";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"d442569518dd60e48cb3bbe0b32eec8f";a:8:{s:3:"sql";s:148:"INSERT INTO admins (username, password, email) VALUES
('admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin@store.com');";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"ac2b5d0e0e27eaf53d897aeac788ed0f";a:8:{s:3:"sql";s:22:"-- password: password;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:25:"wifiyecu_smartphone_store";}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}Import_message|a:2:{s:7:"message";N;s:11:"go_back_url";s:64:"index.php?route=/database/structure&db=wifiyecu_smartphone_store";}is_multi_query|b:1;sql_from_query_box|b:1;flashMessages|a:0:{}sql_history|a:1:{i:0;a:3:{s:2:"db";s:25:"wifiyecu_smartphone_store";s:5:"table";s:0:"";s:8:"sqlquery";s:22:"-- password: password;";}}errors|a:0:{}