cms/database.html at main · amaechiu-del/cms · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>AI Database Manager - DomisLink CMS</title>
    <style>
        :root { --neon: #EEFF00; --dark: #0a0a0a; --card: #111; --border: #222; --text: #fff; --text-dim: #888; --success: #00ff88; --warning: #ffaa00; --ai-blue: #00d4ff; --ai-purple: #aa66ff; }
        * { margin: 0; padding: 0; box-sizing: border-box; }
        body { font-family: 'Segoe UI', system-ui, sans-serif; background: var(--dark); color: var(--text); min-height: 100vh; }
        .sidebar { width: 260px; background: #050505; border-right: 1px solid var(--border); padding: 20px; position: fixed; height: 100vh; }
        .logo { font-size: 1.5rem; font-weight: 700; color: var(--ai-purple); margin-bottom: 30px; }
        .nav-item { display: block; padding: 12px 15px; border-radius: 10px; color: var(--text-dim); text-decoration: none; margin-bottom: 5px; }
        .nav-item:hover { background: rgba(170, 102, 255, 0.1); }
        .nav-item.active { background: var(--ai-purple); color: #fff; }
        .main { margin-left: 260px; padding: 30px; }
        .header { display: flex; justify-content: space-between; align-items: center; margin-bottom: 30px; }
        .header h1 { font-size: 1.8rem; }
        .btn { padding: 12px 25px; border-radius: 10px; border: none; font-weight: 600; cursor: pointer; }
        .btn-primary { background: var(--neon); color: #000; }
        .btn-ai { background: linear-gradient(135deg, var(--ai-blue), var(--ai-purple)); color: #fff; }

        .ai-panel { background: linear-gradient(135deg, rgba(170, 102, 255, 0.1), rgba(170, 102, 255, 0.02)); border: 1px solid rgba(170, 102, 255, 0.3); border-radius: 15px; padding: 25px; margin-bottom: 30px; display: flex; align-items: center; gap: 20px; }
        .ai-panel .icon { font-size: 3rem; }
        .ai-panel .content { flex: 1; }
        .ai-panel .content h3 { margin-bottom: 5px; }
        .ai-panel .content p { color: var(--text-dim); font-size: 0.9rem; }

        .stats-grid { display: grid; grid-template-columns: repeat(4, 1fr); gap: 20px; margin-bottom: 30px; }
        .stat-card { background: var(--card); border: 1px solid var(--border); border-radius: 12px; padding: 20px; text-align: center; }
        .stat-card .value { font-size: 2rem; font-weight: 700; color: var(--ai-purple); }
        .stat-card .label { color: var(--text-dim); font-size: 0.8rem; margin-top: 5px; }
        .stat-card .status { font-size: 0.75rem; color: var(--success); margin-top: 8px; }

        .db-grid { display: grid; grid-template-columns: repeat(2, 1fr); gap: 20px; }
        .card { background: var(--card); border: 1px solid var(--border); border-radius: 12px; padding: 25px; }
        .card h3 { margin-bottom: 20px; display: flex; align-items: center; gap: 10px; }

        .db-table { width: 100%; }
        .db-table th, .db-table td { padding: 12px; text-align: left; border-bottom: 1px solid var(--border); }
        .db-table th { color: var(--text-dim); font-size: 0.8rem; }
        .db-table td { font-size: 0.9rem; }
        .db-status { padding: 3px 10px; border-radius: 10px; font-size: 0.7rem; }
        .db-status.healthy { background: rgba(0, 255, 136, 0.1); color: var(--success); }
        .db-status.optimizing { background: rgba(255, 170, 0, 0.1); color: var(--warning); }

        .action-item { display: flex; align-items: center; justify-content: space-between; padding: 15px; background: var(--dark); border-radius: 10px; margin-bottom: 10px; }
        .action-item .info { display: flex; align-items: center; gap: 12px; }
        .action-item .time { font-size: 0.75rem; color: var(--text-dim); }

        @media (max-width: 1200px) { .db-grid { grid-template-columns: 1fr; } }
        @media (max-width: 768px) { .sidebar { display: none; } .main { margin-left: 0; } .stats-grid { grid-template-columns: repeat(2, 1fr); } }
    </style>
</head>
<body>
    <aside class="sidebar">
        <div class="logo">🗄️ Database</div>
        <a href="index.html" class="nav-item">📊 Dashboard</a>
        <a href="ai-dashboard.html" class="nav-item">🤖 AI Activity</a>
        <a href="hosting.html" class="nav-item">🌐 Hosting</a>
        <a href="domains.html" class="nav-item">🔗 Domains</a>
        <a href="security.html" class="nav-item">🛡️ Security</a>
        <a href="analytics.html" class="nav-item">📈 Analytics</a>
        <a href="email.html" class="nav-item">📧 Email</a>
        <a href="database.html" class="nav-item active">🗄️ Database</a>
        <a href="store.html" class="nav-item">🛒 Store</a>
        <a href="forms.html" class="nav-item">📋 Forms</a>
    </aside>

    <main class="main">
        <div class="header">
            <h1>🗄️ AI Database Manager</h1>
            <div style="display: flex; gap: 10px;">
                <button class="btn btn-ai">🤖 AI Optimize</button>
                <button class="btn btn-primary">💾 Backup Now</button>
            </div>
        </div>

        <div class="ai-panel">
            <div class="icon">🤖</div>
            <div class="content">
                <h3>AI Database Optimization Active</h3>
                <p>Auto-indexing, query optimization, cleanup, and performance tuning. 99% automated.</p>
            </div>
            <span style="padding: 8px 15px; background: var(--ai-purple); color: #fff; border-radius: 20px; font-size: 0.8rem;">99% AI-Managed</span>
        </div>

        <div class="stats-grid">
            <div class="stat-card">
                <div class="value">2.4GB</div>
                <div class="label">Total Size</div>
                <div class="status">✓ Optimized</div>
            </div>
            <div class="stat-card">
                <div class="value">47</div>
                <div class="label">Tables</div>
                <div class="status">✓ Indexed</div>
            </div>
            <div class="stat-card">
                <div class="value">1.2ms</div>
                <div class="label">Avg Query Time</div>
                <div class="status">✓ Optimal</div>
            </div>
            <div class="stat-card">
                <div class="value">24</div>
                <div class="label">Backups</div>
                <div class="status">✓ Auto-running</div>
            </div>
        </div>

        <div class="db-grid">
            <div class="card">
                <h3>📊 Database Tables</h3>
                <table class="db-table">
                    <tr><th>Table</th><th>Rows</th><th>Size</th><th>Status</th></tr>
                    <tr><td>users</td><td>12,847</td><td>45MB</td><td><span class="db-status healthy">Healthy</span></td></tr>
                    <tr><td>pages</td><td>1,247</td><td>128MB</td><td><span class="db-status healthy">Healthy</span></td></tr>
                    <tr><td>media</td><td>8,934</td><td>1.2GB</td><td><span class="db-status healthy">Healthy</span></td></tr>
                    <tr><td>analytics</td><td>487,234</td><td>890MB</td><td><span class="db-status optimizing">Optimizing</span></td></tr>
                    <tr><td>sessions</td><td>3,421</td><td>12MB</td><td><span class="db-status healthy">Healthy</span></td></tr>
                </table>
            </div>

            <div class="card">
                <h3>🤖 Recent AI Actions</h3>
                <div class="action-item">
                    <div class="info"><span>🔧</span> Auto-optimized 12 queries</div>
                    <span class="time">5 min ago</span>
                </div>
                <div class="action-item">
                    <div class="info"><span>🗑️</span> Cleaned 2,341 orphaned records</div>
                    <span class="time">1 hour ago</span>
                </div>
                <div class="action-item">
                    <div class="info"><span>📊</span> Created 3 new indexes</div>
                    <span class="time">2 hours ago</span>
                </div>
                <div class="action-item">
                    <div class="info"><span>💾</span> Backup completed (2.4GB)</div>
                    <span class="time">3 hours ago</span>
                </div>
                <div class="action-item">
                    <div class="info"><span>⚡</span> Query cache refreshed</div>
                    <span class="time">4 hours ago</span>
                </div>
            </div>
        </div>
    </main>
</body>
</html>