{"slug":"personal-chat-room","name":"Personal Chat room","description":"Personal Chat Room adds a facility to allow your customers to chat with one another. Here They can questions with another users and can get the answer …","author":"Rohitashv Singhal","active_installs":10,"version":"1.1","wp_org_url":"https://wordpress.org/plugins/personal-chat-room/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cs_messages","full_table_name":"wp_cs_messages","description":"Stores cs messages data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"sender","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"recipient","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"message","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"when","type":"int(11)","nullable":false,"primary_key":false},{"name":"room","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"tinyint(1) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `cs_messages` ( `id` int(11) unsigned NOT NULL auto_increment, `sender` int(11) unsigned NOT NULL, `recipient` int(11) unsigned NOT NULL default '0', `message` VARCHAR(255) NOT NULL, `when` int(11) NOT NULL default '0', `room` int(5) unsigned NOT NULL default '0', `type` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`) )\"; $wpdb->query($message_table);"},{"table_name":"cs_profiles","full_table_name":"wp_cs_profiles","description":"Stores cs profiles data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(10) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"password","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"salt","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"status","type":"enum('active','passive')","nullable":false,"primary_key":false},{"name":"role","type":"tinyint(4) unsigned","nullable":false,"primary_key":false},{"name":"about","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"date_reg","type":"datetime","nullable":false,"primary_key":false},{"name":"rate","type":"float","nullable":false,"primary_key":false},{"name":"rate_count","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `cs_profiles` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `first_name` varchar(255) NOT NULL default '', `last_name` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `password` varchar(40) NOT NULL default '', `salt` varchar(10) NOT NULL default '', `status` enum('active','passive') NOT NULL default 'active', `role` tinyint(4) unsigned NOT NULL default '1', `about` varchar(255) NOT NULL, `date_reg` datetime NOT NULL default '0000-00-00 00:00:00', `rate` float NOT NULL, `rate_count` int(11) NOT NULL, PRIMARY KEY (`id`) )\"; $wpdb->query($profile_table);"},{"table_name":"cs_val_tab","full_table_name":"wp_cs_val_tab","description":"Stores cs val tab data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"value","type":"VARCHAR(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `cs_val_tab` ( `id` int(11) unsigned NOT NULL auto_increment, `value` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`) )\"; $wpdb->query($message_val_tab);"}],"table_count":3}