{"table_name":"mailmaga_x_users","full_table_name":"wp_mailmaga_x_users","description":"Stores mailmaga x users data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_mailmaga_x_users ( user_id BIGINT( 20 ) unsigned NOT NULL AUTO_INCREMENT, user_name VARCHAR( 100 ) DEFAULT NULL , user_email VARCHAR( 100 ) NOT NULL DEFAULT '' , user_group VARCHAR( 100 ) DEFAULT NULL , PRIMARY KEY (user_id) ) {$charset_collate};\"; $sqls[] = \"CREATE TABLE wp_mailmaga_x_servers ( server_id BIGINT( 20 ) unsigned NOT NULL AUTO_INCREMENT, server_name VARCHAR( 100 ) NOT NULL DEFAULT '' , type VARCHAR( 50 ) DEFAULT NULL , sleep INT( 2 ) DEFAULT '0' , host VARCHAR( 50 ) DEFAULT NULL , auth INT( 1 ) DEFAULT 1 , port VARCHAR( 10 ) DEFAULT NULL , account VARCHAR( 100 ) DEFAULT NULL , password VARCHAR( 100 ) DEFAULT NULL , PRIMARY KEY (server_id) ) {$charset_collate};\"; $sqls[] = \"CREATE TABLE wp_mailmaga_x_mails ( mail_id BIGINT( 20 ) unsigned NOT NULL AUTO_INCREMENT, title VARCHAR( 255 ) NOT NULL DEFAULT '', content TEXT NOT NULL DEFAULT '' , user_ids TEXT NOT NULL DEFAULT '' , server_ids TEXT NOT NULL DEFAULT '' , created_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00' , PRIMARY KEY (mail_id) ) {$charset_collate};\"; $sqls[] = \"CREATE TABLE wp_mailmaga_x_historys ( history_id BIGINT( 20 ) unsigned NOT NULL AUTO_INCREMENT, mail_id BIGINT( 20 ) NOT NULL , user_id VARCHAR( 50 ) NOT NULL , secret_key VARCHAR( 100 ) NOT NULL DEFAULT '' , success INT( 1 ) DEFAULT 0 , error TEXT DEFAULT NULL , created_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00' , opened_time datetime DEFAULT NULL , is_html INT( 1 ) DEFAULT 0 , PRIMARY KEY (history_id) ) {$charset_collate};\"; $sqls[] = \"INSERT INTO wp_mailmaga_x_servers ( server_id, server_name, type, sleep, host, auth, port, account, password) VALUES (NULL, '\" . __('localhost') . \"', 'mail', 0, 'localhost', 0, '', '', '');","columns":[{"name":"user_id","type":"BIGINT( 20 ) unsigned","nullable":false,"primary_key":true},{"name":"user_name","type":"VARCHAR( 100 )","nullable":true,"primary_key":false},{"name":"user_email","type":"VARCHAR( 100 )","nullable":false,"primary_key":false},{"name":"user_group","type":"VARCHAR( 100 )","nullable":true,"primary_key":false},{"name":"server_name","type":"VARCHAR( 100 )","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR( 50 )","nullable":true,"primary_key":false},{"name":"sleep","type":"INT( 2 )","nullable":true,"primary_key":false},{"name":"host","type":"VARCHAR( 50 )","nullable":true,"primary_key":false},{"name":"auth","type":"INT( 1 )","nullable":true,"primary_key":false},{"name":"port","type":"VARCHAR( 10 )","nullable":true,"primary_key":false},{"name":"account","type":"VARCHAR( 100 )","nullable":true,"primary_key":false},{"name":"password","type":"VARCHAR( 100 )","nullable":true,"primary_key":false},{"name":"title","type":"VARCHAR( 255 )","nullable":false,"primary_key":false},{"name":"content","type":"TEXT","nullable":false,"primary_key":false},{"name":"user_ids","type":"TEXT","nullable":false,"primary_key":false},{"name":"server_ids","type":"TEXT","nullable":false,"primary_key":false},{"name":"created_time","type":"datetime","nullable":false,"primary_key":false},{"name":"mail_id","type":"BIGINT( 20 )","nullable":false,"primary_key":false},{"name":"user_id","type":"VARCHAR( 50 )","nullable":false,"primary_key":false},{"name":"secret_key","type":"VARCHAR( 100 )","nullable":false,"primary_key":false},{"name":"success","type":"INT( 1 )","nullable":true,"primary_key":false},{"name":"error","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_time","type":"datetime","nullable":false,"primary_key":false},{"name":"opened_time","type":"datetime","nullable":true,"primary_key":false},{"name":"is_html","type":"INT( 1 )","nullable":true,"primary_key":false}],"plugin":{"slug":"mailmaga-x","name":"Mailmaga-X","active_installs":10,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/mailmaga-x/"}}