{"table_name":"eerb_booking_history","full_table_name":"wp_eerb_booking_history","description":"Stores eerb booking history data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_eerb_booking_history ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, booking_id INT UNSIGNED NOT NULL, action ENUM('created','changed','cancelled','refunded') NOT NULL, changed_by ENUM('customer','admin') NOT NULL DEFAULT 'customer', old_slot_start DATETIME, new_slot_start DATETIME, old_players TINYINT UNSIGNED, new_players TINYINT UNSIGNED, note TEXT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY booking_id (booking_id) ) $charset;\" );","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"booking_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"action","type":"ENUM('created','changed','cancelled','refunded')","nullable":false,"primary_key":false},{"name":"changed_by","type":"ENUM('customer','admin')","nullable":false,"primary_key":false},{"name":"old_slot_start","type":"DATETIME","nullable":true,"primary_key":false},{"name":"new_slot_start","type":"DATETIME","nullable":true,"primary_key":false},{"name":"old_players","type":"TINYINT UNSIGNED","nullable":true,"primary_key":false},{"name":"new_players","type":"TINYINT UNSIGNED","nullable":true,"primary_key":false},{"name":"note","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"ettrick-escape-room-booking","name":"Ettrick Escape Room Booking","active_installs":0,"version":"1.3.1","wp_org_url":"https://wordpress.org/plugins/ettrick-escape-room-booking/"}}