{"slug":"smarttr-address","name":"SmartTR Address","description":"Turkish address auto-fill for WooCommerce checkout — cascading Province and District dropdowns for Turkish orders.","author":"Ugur Ozkan","active_installs":0,"version":"1.5.1","wp_org_url":"https://wordpress.org/plugins/smarttr-address/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cecomsmarad_address_book","full_table_name":"wp_cecomsmarad_address_book","description":"Stores cecomsmarad address book data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cecomsmarad_districts","full_table_name":"wp_cecomsmarad_districts","description":"Stores cecomsmarad districts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cecomsmarad_provinces","full_table_name":"wp_cecomsmarad_provinces","description":"Stores cecomsmarad provinces data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"code","type":"VARCHAR(4)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"province_code","type":"VARCHAR(4)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"nickname","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"address_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"province_code","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"province_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"district_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"neighborhood","type":"VARCHAR(150)","nullable":false,"primary_key":false},{"name":"postcode","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"address_1","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"last_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"company","type":"VARCHAR(150)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cecomsmarad_provinces ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, code VARCHAR(4) NOT NULL, name VARCHAR(100) NOT NULL, PRIMARY KEY (id), UNIQUE KEY idx_code (code), KEY idx_name (name) ) {$charset_collate}; CREATE TABLE wp_cecomsmarad_districts ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, province_code VARCHAR(4) NOT NULL, name VARCHAR(100) NOT NULL, PRIMARY KEY (id), KEY idx_province_code (province_code), KEY idx_province_name (province_code, name) ) {$charset_collate}; CREATE TABLE wp_cecomsmarad_address_book ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, nickname VARCHAR(100) NOT NULL, address_type VARCHAR(20) NOT NULL DEFAULT 'billing', province_code VARCHAR(10) NOT NULL, province_name VARCHAR(100) NOT NULL, district_name VARCHAR(100) NOT NULL, neighborhood VARCHAR(150) NOT NULL DEFAULT '', postcode VARCHAR(20) NOT NULL DEFAULT '', address_1 VARCHAR(255) NOT NULL DEFAULT '', first_name VARCHAR(100) NOT NULL DEFAULT '', last_name VARCHAR(100) NOT NULL DEFAULT '', company VARCHAR(150) NOT NULL DEFAULT '', phone VARCHAR(30) NOT NULL DEFAULT '', email VARCHAR(255) NOT NULL DEFAULT '', country VARCHAR(10) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_user_id (user_id), KEY idx_user_type (user_id, address_type) ) {$charset_collate};\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"}],"table_count":3}