=== ZKTeco Setup v6 (configuration.php) ===

Time:           2026-11-14 14:30:21
DB:             almaali_Schoolv4
AutoRegister:   ON
RateLimit:      OFF
Config source:  configuration.php
Mode:           CHECK ONLY

--- Creating tables (v6 with all columns) ---
  [OK]      aleppos_zkteco_raw_logs
  [OK]      aleppos_zkteco_devices
  [OK]      aleppos_zkteco_users
  [OK]      aleppos_zkteco_fingerprints
  [OK]      aleppos_zkteco_commands
  [OK]      aleppos_zkteco_rate_limit
  [OK]      aleppos_zkteco_sync_settings

--- Applying ALTER statements ---
  [OK] sync_status ENUM updated
  [OK] received_at = DATETIME

--- Seeding sync settings (v6) ---
  [OK] inserted 0 of 23 settings
  [INFO] 23 setting(s) already exist (skipped)

--- Tables ---
[OK] aleppos_zkteco_raw_logs
[OK] aleppos_zkteco_devices
[OK] aleppos_zkteco_users
[OK] aleppos_zkteco_fingerprints
[OK] aleppos_zkteco_commands
[OK] aleppos_zkteco_rate_limit
[OK] aleppos_zkteco_sync_settings

--- Columns (raw_logs) ---
id                   | bigint(20) unsigned                      | NO | NULL
device_sn            | varchar(50)                              | NO | 
created_via          | enum('device','virtual','admin')         | NO | device
created_by_user_id   | int(11)                                  | YES | NULL
device_pin           | varchar(30)                              | NO | NULL
punch_time           | datetime                                 | NO | NULL
punch_type           | tinyint(4)                               | NO | 0
punch_state          | varchar(20)                              | NO | in
verify_mode          | tinyint(4)                               | NO | 0
work_code            | varchar(20)                              | NO | 
log_date             | date                                     | NO | NULL
log_time             | time                                     | NO | NULL
raw_line             | text                                     | YES | NULL
sync_status          | enum('pending','synced','failed','skipped') | NO | pending
sync_note            | varchar(255)                             | YES | NULL
target_log_id        | bigint(20) unsigned                      | YES | NULL
sync_attempts        | tinyint(3) unsigned                      | YES | 0
received_at          | datetime                                 | NO | NULL
synced_at            | datetime                                 | YES | NULL

--- Indexes (raw_logs) ---
Key: PRIMARY              | Col: id                   | Unique: YES
Key: uniq_punch           | Col: device_sn            | Unique: YES
Key: uniq_punch           | Col: device_pin           | Unique: YES
Key: uniq_punch           | Col: punch_time           | Unique: YES
Key: uniq_punch           | Col: punch_type           | Unique: YES
Key: idx_sync_status      | Col: sync_status          | Unique: no
Key: idx_punch_time       | Col: punch_time           | Unique: no
Key: idx_log_date         | Col: log_date             | Unique: no
Key: idx_device_pin       | Col: device_sn            | Unique: no
Key: idx_device_pin       | Col: device_pin           | Unique: no
Key: idx_status_date      | Col: sync_status          | Unique: no
Key: idx_status_date      | Col: log_date             | Unique: no
Key: idx_created_via      | Col: created_via          | Unique: no
Key: idx_created_by       | Col: created_by_user_id   | Unique: no

--- Sync Settings (aleppos_zkteco_sync_settings) ---

  [attendance]
    ALLOW_MULTI_IN_OUT             = 0                    (bool)
    REPLACE_EXISTING_IN            = 0                    (bool)

  [forgive]
    AUTO_CAP_EARLY_IN              = 1                    (bool)
    AUTO_FORGIVE_LATE              = 1                    (bool)
    FORGIVE_LATE_MAX_MINUTES       = 60                   (int)
    AUTO_CAP_LATE_OUT              = 1                    (bool)
    AUTO_FORGIVE_EARLY_OUT         = 1                    (bool)
    FORGIVE_EARLY_OUT_MINUTES      = 50                   (int)

  [holiday]
    PROCESS_HOLIDAY_PUNCHES        = 0                    (bool)
    HOLIDAY_PUNCH_AS_EXTRA         = 1                    (bool)

  [rules]
    MIN_GAP_MINUTES                = 10                   (int)
    CHECK_WORKING_DAY              = 1                    (bool)
    SKIP_WITH_ABSENCE_RECORD       = 0                    (bool)
    ALLOW_OUT_WITHOUT_IN           = 0                    (bool)
    IGNORE_LATE_IN_AFTER_END       = 1                    (bool)

  [system]
    BATCH_LIMIT                    = 500                  (int)
    LOG_VERBOSE                    = 1                    (bool)
    DRY_RUN_MODE                   = 0                    (bool)
    SYNC_TOKEN                     =                      (string)
    ADMIN_ID                       = 55                   (int)
    AUTO_CLOSE_OPEN_RECORDS        = 1                    (bool)
    AUTO_CLOSE_GRACE_MINUTES       = 15                   (int)
    AUTO_CLOSE_AFTER_HOURS         = 24                   (int)
    AUTO_CREATE_ABSENCE            = 1                    (bool)
    ABSENCE_GRACE_MINUTES          = 15                   (int)

  الإجمالي: 25 إعداد في 5 فئة

CHECK MODE - no destructive changes were made.
To rebuild:       ?setup=1&rebuild=1&confirm=YES
To reseed only:   ?setup=1&reseed_settings=1