{"table_name":"tutor_carts","full_table_name":"wp_tutor_carts","description":"Stores tutor carts data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_tutor_carts ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED DEFAULT NULL, coupon_code VARCHAR(50) DEFAULT NULL, created_at_gmt DATETIME NOT NULL, updated_at_gmt DATETIME, PRIMARY KEY (id), KEY user_id (user_id), KEY coupon_code (coupon_code), CONSTRAINT fk_tutor_cart_user_id FOREIGN KEY (user_id) REFERENCES wp_users(ID) ON DELETE CASCADE ) $charset_collate;\"; $cart_items_table = \"CREATE TABLE wp_tutor_cart_items ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, cart_id BIGINT(20) UNSIGNED NOT NULL, course_id BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY (id), KEY cart_id (cart_id), KEY course_id (course_id), CONSTRAINT fk_tutor_cart_item_cart_id FOREIGN KEY (cart_id) REFERENCES wp_tutor_carts(id) ON DELETE CASCADE, CONSTRAINT fk_tutor_cart_item_course_id FOREIGN KEY (course_id) REFERENCES wp_posts(ID) ON DELETE CASCADE ) $charset_collate;\"; $customer_table = \"CREATE TABLE wp_tutor_customers ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED DEFAULT NULL, billing_first_name VARCHAR(255) NOT NULL, billing_last_name VARCHAR(255) NOT NULL, billing_email VARCHAR(255) NOT NULL, billing_phone VARCHAR(20) NOT NULL, billing_zip_code VARCHAR(20) NOT NULL, billing_address TEXT NOT NULL, billing_country VARCHAR(100) NOT NULL, billing_state VARCHAR(100) NOT NULL, billing_city VARCHAR(100) NOT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY billing_email (billing_email) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $quiz_attempts_sql );","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"coupon_code","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"created_at_gmt","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at_gmt","type":"DATETIME","nullable":true,"primary_key":false},{"name":"cart_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"course_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"billing_first_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"billing_last_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"billing_email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"billing_phone","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"billing_zip_code","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"billing_address","type":"TEXT","nullable":false,"primary_key":false},{"name":"billing_country","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"billing_state","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"billing_city","type":"VARCHAR(100)","nullable":false,"primary_key":false}],"plugin":{"slug":"tutor","name":"Tutor LMS – eLearning and online course solution","active_installs":100000,"version":"4.2.0","wp_org_url":"https://wordpress.org/plugins/tutor/"}}