{"slug":"easysms","name":"EasySMS","description":"EasySMS provides an easy way for readers to subscribe to SMS updates and for admins to send SMS messages to groups. Auto SMS with post publishing.","author":"Brian Fegter","active_installs":10,"version":"2.0.7.2","wp_org_url":"https://wordpress.org/plugins/easysms/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"easysms","full_table_name":"wp_easysms","description":"Stores easysms data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int","nullable":false,"primary_key":true},{"name":"firstName","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"lastName","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"phoneNumber","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"carrierEmail","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"randomCode","type":"varchar(4)","nullable":true,"primary_key":false},{"name":"confirm","type":"varchar(3)","nullable":true,"primary_key":false},{"name":"msgCount","type":"int","nullable":true,"primary_key":false},{"name":"notes","type":"tinytext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE easysms ( ID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), firstName varchar(25), lastName varchar(25), phoneNumber varchar(25), carrierEmail varchar(25), randomCode varchar(4), confirm varchar(3), msgCount int, notes tinytext )\"; mysql_query($i);"},{"table_name":"easysms_carriers","full_table_name":"wp_easysms_carriers","description":"Stores easysms carriers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int","nullable":false,"primary_key":true},{"name":"carrierName","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"carrierEmail","type":"varchar(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE easysms_carriers ( ID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), carrierName varchar(25), carrierEmail varchar(45) )\"; mysql_query($i);"},{"table_name":"easysms_group_users","full_table_name":"wp_easysms_group_users","description":"Stores easysms group users data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int","nullable":false,"primary_key":true},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"group_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE easysms_group_users ( ID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), user_id int, group_id int )\"; mysql_query($i);"},{"table_name":"easysms_groups","full_table_name":"wp_easysms_groups","description":"Stores easysms groups data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int","nullable":false,"primary_key":true},{"name":"groupName","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"groupDescription","type":"tinytext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE easysms_groups ( ID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), groupName varchar(25), groupDescription tinytext )\"; mysql_query($i);"}],"table_count":4}