{"table_name":"ec_schedule","full_table_name":"wp_ec_schedule","description":"Stores ec schedule data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE ec_schedule ( schedule_id int(11) NOT NULL AUTO_INCREMENT, schedule_label varchar(255) DEFAULT '', day_of_week varchar(20) NOT NULL DEFAULT '', is_holiday tinyint(1) NOT NULL DEFAULT 1, holiday_date date DEFAULT NULL, apply_to_retail tinyint(1) NOT NULL DEFAULT 0, apply_to_preorder tinyint(1) NOT NULL DEFAULT 0, apply_to_restaurant tinyint(1) NOT NULL DEFAULT 0, retail_start varchar(32) NOT NULL DEFAULT '', retail_end varchar(32) NOT NULL DEFAULT '', preorder_start varchar(32) NOT NULL DEFAULT '', preorder_end varchar(32) NOT NULL DEFAULT '', preorder_open_time varchar(32) NOT NULL DEFAULT '', preorder_close_time varchar(32) NOT NULL DEFAULT '', restaurant_start varchar(32) NOT NULL DEFAULT '', restaurant_end varchar(32) NOT NULL DEFAULT '', retail_closed tinyint(1) NOT NULL DEFAULT 0, preorder_closed tinyint(1) NOT NULL DEFAULT 0, restaurant_closed tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (schedule_id), UNIQUE KEY schedule_id (schedule_id) ) $collate;\" );","columns":[{"name":"schedule_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"schedule_label","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"day_of_week","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"is_holiday","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"holiday_date","type":"date","nullable":true,"primary_key":false},{"name":"apply_to_retail","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"apply_to_preorder","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"apply_to_restaurant","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"retail_start","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"retail_end","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_start","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_end","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_open_time","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_close_time","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"restaurant_start","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"restaurant_end","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"retail_closed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"preorder_closed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"restaurant_closed","type":"tinyint(1)","nullable":false,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"Shopping Cart & eCommerce Store","active_installs":4000,"version":"5.9.1","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}