Database: thuvien
Server: 10.11.10-MariaDB-log
| Tên bảng | Số bản ghi |
|---|---|
| add_book | 360 |
| azure_tokens | 0 |
| book_access_log | 65 |
| categories | 26 |
| category_stats | 26 |
| fine | 0 |
| issue_book | 0 |
| lib_registration | 6 |
| login_logs | 0 |
| message | 0 |
| request_books | 0 |
| std_registration | 0 |
| system_config | 11 |
| t_issuebook | 0 |
| t_registration | 0 |
| theme_presets | 5 |
| theme_settings | 45 |
| theme_settings_grouped | 9 |
| uploaded_files | 0 |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | NULL | auto_increment |
| name | varchar(100) | NO | NULL | ||
| username | varchar(50) | NO | UNI | NULL | |
| password | varchar(255) | NO | NULL | ||
| varchar(255) | NO | UNI | NULL | ||
| phone | varchar(20) | NO | NULL | ||
| address | varchar(500) | NO | NULL | ||
| photo | varchar(500) | NO | NULL | ||
| status | varchar(20) | NO | active | ||
| created_date | timestamp | NO | current_timestamp() | ||
| azure_id | varchar(255) | YES | MUL | NULL | |
| login_type | enum('local','azure') | YES | MUL | local | |
| last_login | datetime | YES | NULL | ||
| created_at | datetime | YES | current_timestamp() | ||
| role | varchar(50) | YES | librarian |
| Cột | Trạng thái | SQL cần chạy |
|---|---|---|
| azure_id | ✅ Đã có | - |
| login_type | ✅ Đã có | - |
| last_login | ✅ Đã có | - |
| role | ✅ Đã có | - |
Tất cả các cột cần thiết đã có trong bảng lib_registration.
| id | name | username | password | phone | address | photo | status | created_date | azure_id | login_type | last_login | created_at | role | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Quản trị viên | admin | admin123 | admin@thuvien.com | 0123456789 | Hà Nội, Việt Nam | upload/admin.jpg | active | 2025-09-10 10:52:54 | NULL | local | NULL | 2025-09-12 10:05:26 | librarian |
| 3 | Azure Administrator | azure_admin | admin@yourdomain.com | active | 2025-09-12 10:05:27 | NULL | azure | NULL | 2025-09-12 10:05:27 | admin | ||||
| 4 | Nguyen Van Hoa | hoanv | hoanv@bachkhoahanoi.edu.vn | active | 2025-09-12 11:35:15 | 22bba4c2-cbf6-4709-86b8-5262c42bd3d3 | azure | 2025-10-06 13:38:28 | 2025-09-12 11:35:15 | librarian | ||||
| 17 | Chu Chuc | chucct | chucct@bachkhoahanoi.edu.vn | active | 2025-09-16 22:50:31 | 870942ba-9e5a-446e-b38a-d65dc9eb6cdd | azure | 2025-09-24 08:19:12 | 2025-09-16 22:50:31 | teacher | ||||
| 18 | Đinh Quang Chiến | 2313620652 | 2313620652@bachkhoahanoi.edu.vn | active | 2025-09-16 23:25:38 | a11013e8-a716-4d6b-ab90-85dad0dc95ac | azure | NULL | 2025-09-16 23:25:38 | student |
composer installazure/config.php