{"table_name":"reservations","full_table_name":"wp_reservations","description":"Stores reservations data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_reservations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, order_id bigint(20) unsigned NOT NULL, arrival DATETIME NOT NULL, departure DATETIME NOT NULL, status varchar(10) NOT NULL, resource bigint(20) NOT NULL, space int(10) NOT NULL, adults int(10) NOT NULL, children int(10) NOT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_reservationmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, reservation_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY reservation_id (reservation_id), KEY meta_key (meta_key($max_index_length)) ) $collate; CREATE TABLE wp_reservations_sessions ( session_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_key char(32) NOT NULL, session_value longtext NOT NULL, session_expiry BIGINT UNSIGNED NOT NULL, PRIMARY KEY (session_id), UNIQUE KEY session_key (session_key) ) $collate; CREATE TABLE wp_receipt_items ( receipt_item_id BIGINT UNSIGNED NOT NULL auto_increment, receipt_item_name TEXT NOT NULL, receipt_item_type varchar(200) NOT NULL DEFAULT '', receipt_object_type varchar(200) NOT NULL DEFAULT '', receipt_object_id BIGINT UNSIGNED NOT NULL, PRIMARY KEY (receipt_item_id), KEY order_id (receipt_object_id) ) $collate; CREATE TABLE wp_receipt_itemmeta ( meta_id BIGINT UNSIGNED NOT NULL auto_increment, receipt_item_id BIGINT UNSIGNED NOT NULL, meta_key varchar(255) default NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY receipt_item_id (receipt_item_id), KEY meta_key (meta_key(32)) ) $collate;\"; return $tables; } /** * Return a list of easyReservations tables. Used to make sure all ER tables are dropped when uninstalling the plugin * in a single site or multi site environment. * * @return array ER tables. */ public static function get_tables() { global $wpdb; $tables = array( \"wp_reservations\", \"wp_reservation_meta\", \"wp_reservations_sessions\", \"wp_receipt_items\", \"wp_receipt_itemmeta\", \"wp_reservations_payment_tokenmeta\", \"wp_reservations_payment_tokens\", );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"arrival","type":"DATETIME","nullable":false,"primary_key":false},{"name":"departure","type":"DATETIME","nullable":false,"primary_key":false},{"name":"status","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"resource","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"space","type":"int(10)","nullable":false,"primary_key":false},{"name":"adults","type":"int(10)","nullable":false,"primary_key":false},{"name":"children","type":"int(10)","nullable":false,"primary_key":false},{"name":"reservation_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"session_key","type":"char(32)","nullable":false,"primary_key":false},{"name":"session_value","type":"longtext","nullable":false,"primary_key":false},{"name":"session_expiry","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"receipt_item_name","type":"TEXT","nullable":false,"primary_key":false},{"name":"receipt_item_type","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"receipt_object_type","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"receipt_object_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"receipt_item_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false}],"plugin":{"slug":"easyreservations","name":"easyReservations","active_installs":800,"version":"6.0-alpha.23","wp_org_url":"https://wordpress.org/plugins/easyreservations/"}}