File manager - Edit - /home/linknsbh/rassudr.online/chat/db.php
Back
<?php $dbFile = __DIR__ . '/data.sqlite'; $db = new PDO('sqlite:' . $dbFile); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $db->exec("CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT UNIQUE NOT NULL, password TEXT NOT NULL, role TEXT DEFAULT 'agent', status TEXT DEFAULT 'active', created_at DATETIME DEFAULT CURRENT_TIMESTAMP)"); $db->exec("CREATE TABLE IF NOT EXISTS properties (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, domain TEXT, widget_color TEXT DEFAULT '#1a73e8', widget_position TEXT DEFAULT 'bottom_right', welcome_message TEXT, offline_message TEXT, active INTEGER DEFAULT 1, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)"); $db->exec("CREATE TABLE IF NOT EXISTS departments (id INTEGER PRIMARY KEY AUTOINCREMENT, property_id INTEGER DEFAULT 1, name TEXT NOT NULL, email TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)"); $db->exec("CREATE TABLE IF NOT EXISTS visitors (id INTEGER PRIMARY KEY AUTOINCREMENT, property_id INTEGER DEFAULT 1, session_id TEXT, ip TEXT, country TEXT, page_url TEXT, referrer TEXT, user_agent TEXT, name TEXT, email TEXT, last_activity DATETIME, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)"); $db->exec("CREATE TABLE IF NOT EXISTS conversations (id INTEGER PRIMARY KEY AUTOINCREMENT, property_id INTEGER DEFAULT 1, visitor_id INTEGER, agent_id INTEGER, department_id INTEGER, status TEXT DEFAULT 'pending', rating INTEGER, email TEXT, closed_at DATETIME, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP)"); $db->exec("CREATE TABLE IF NOT EXISTS messages (id INTEGER PRIMARY KEY AUTOINCREMENT, conversation_id INTEGER, sender_type TEXT, sender_id INTEGER, content TEXT, type TEXT DEFAULT 'text', file_path TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)"); $db->exec("CREATE TABLE IF NOT EXISTS canned_responses (id INTEGER PRIMARY KEY AUTOINCREMENT, property_id INTEGER DEFAULT 1, department_id INTEGER, shortcut TEXT, message TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)");
| ver. 1.4 |
Github
|
.
| PHP 8.2.31 | Generation time: 0.46 |
proxy
|
phpinfo
|
Settings