{"slug":"community-gradebook","name":"Community Gradebook","description":"Easy to use and simple Gradebook","author":"Manoj Chacko","active_installs":10,"version":"0.1","wp_org_url":"https://wordpress.org/plugins/community-gradebook/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"course_table","full_table_name":"wp_course_table","description":"Stores course table data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"Course_No","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"Course_Title","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"Section","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"CRN","type":"varchar(15)","nullable":false,"primary_key":false},{"name":"Instructor_login","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"Term","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"Timestamp","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS course_table (Course_No varchar(20) NOT NULL, Course_Title varchar(50) NOT NULL, Section varchar(10) NOT NULL, CRN varchar(15) NOT NULL, Instructor_login varchar(45) NOT NULL, Term varchar(45) NOT NULL, Timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (CRN));"},{"table_name":"gb_user_table","full_table_name":"wp_gb_user_table","description":"Stores gb user table data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"User_login","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"User_email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"User_role","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"Timestamp","type":"timestamp","nullable":false,"primary_key":false},{"name":"User_name","type":"varchar(45)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS gb_user_table (User_login varchar(45) NOT NULL, User_email varchar(100) NOT NULL, User_role varchar(45) NOT NULL, Timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, User_name varchar(45) NOT NULL, PRIMARY KEY (User_login));"},{"table_name":"general_info","full_table_name":"wp_general_info","description":"Stores general info data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(10) unsigned","nullable":false,"primary_key":true},{"name":"Title","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"Value","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"Value_Name","type":"varchar(45)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS general_info (id int(10) unsigned NOT NULL AUTO_INCREMENT, Title varchar(45) NOT NULL, Value varchar(250) DEFAULT NULL, Value_Name varchar(45) NOT NULL, PRIMARY KEY (id));"},{"table_name":"gradebook","full_table_name":"wp_gradebook","description":"Stores gradebook data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"GB_ID","type":"int(10) unsigned","nullable":false,"primary_key":true},{"name":"Course_No","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"Email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"Data_Title","type":"varchar(1000)","nullable":false,"primary_key":false},{"name":"Data_Value","type":"varchar(1000)","nullable":false,"primary_key":false},{"name":"Term","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"TimeStamp","type":"timestamp","nullable":false,"primary_key":false},{"name":"Section","type":"varchar(45)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS gradebook (GB_ID int(10) unsigned NOT NULL AUTO_INCREMENT, Course_No varchar(20) NOT NULL, Email varchar(100) NOT NULL, Data_Title varchar(1000) NOT NULL, Data_Value varchar(1000) NOT NULL, Term varchar(45) NOT NULL, TimeStamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, Section varchar(45) NOT NULL, PRIMARY KEY (GB_ID));"}],"table_count":4}