{"slug":"aistore-bhagavad-gita","name":"Aistore Bhagavad Gita","description":"Publish the complete Bhagavad Gita on your WordPress website with chapters, verses, audio, search, favorites, social sharing, and daily email.","author":"susheelhbti","active_installs":0,"version":"2.0.1","wp_org_url":"https://wordpress.org/plugins/aistore-bhagavad-gita/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"aistore_favorites","full_table_name":"wp_aistore_favorites","description":"Stores aistore favorites data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"chapter_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"verse_number","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"email","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"subscribed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aistore_favorites ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, chapter_id int(11) NOT NULL, verse_number int(11) NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_user (user_id), KEY idx_user_chapter (user_id, chapter_id) ) $charset_collate;\"; // Subscribers table with index on status $sql2 = \"CREATE TABLE IF NOT EXISTS wp_aistore_subscribers ( id bigint(20) NOT NULL AUTO_INCREMENT, email varchar(200) NOT NULL, name varchar(200) DEFAULT '', subscribed_at datetime DEFAULT CURRENT_TIMESTAMP, status varchar(20) DEFAULT 'active', PRIMARY KEY (id), UNIQUE KEY email (email), KEY idx_status (status) ) $charset_collate;\"; dbDelta( $sql1 );"},{"table_name":"aistore_subscribers","full_table_name":"wp_aistore_subscribers","description":"Stores aistore subscribers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":2}