{"slug":"cortaito-url-shortener","name":"Cortaito","description":"Private URL shortener with click statistics, geolocation and link expiration. Small but mighty, like a Málaga espresso. ☕","author":"Koke Pérez","active_installs":0,"version":"1.7.3","wp_org_url":"https://wordpress.org/plugins/cortaito-url-shortener/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"cortaito_clics","full_table_name":"wp_cortaito_clics","description":"Stores cortaito clics data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cortaito_links","full_table_name":"wp_cortaito_links","description":"Stores cortaito links data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"codigo","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"url_destino","type":"TEXT","nullable":false,"primary_key":false},{"name":"descripcion","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"caduca_en","type":"DATETIME","nullable":true,"primary_key":false},{"name":"creado_en","type":"DATETIME","nullable":false,"primary_key":false},{"name":"link_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"pais","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"ciudad","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"dispositivo","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"navegador","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"referrer","type":"TEXT","nullable":true,"primary_key":false},{"name":"fecha","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cortaito_links ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, codigo VARCHAR(20) NOT NULL, url_destino TEXT NOT NULL, descripcion VARCHAR(255) NOT NULL DEFAULT '', caduca_en DATETIME DEFAULT NULL, creado_en DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY codigo (codigo) ) $charset;\"; $sql2 = \"CREATE TABLE wp_cortaito_clics ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, link_id BIGINT UNSIGNED NOT NULL, ip VARCHAR(45) NOT NULL DEFAULT '', pais VARCHAR(100) NOT NULL DEFAULT '', ciudad VARCHAR(100) NOT NULL DEFAULT '', dispositivo VARCHAR(50) NOT NULL DEFAULT '', navegador VARCHAR(100) NOT NULL DEFAULT '', referrer TEXT, fecha DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY link_id (link_id) ) $charset;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql1 );"}],"table_count":2}