← All changes | includes/Activator.php +11 -8 1.8.6 → 1.10.19 View file →

		@@ -17,9 +17,9 @@
17	17	global $wpdb;
18	18
19	19	$table_name_payments = $wpdb->prefix . 'sync_basalam_payments';
20	20	$table_name_options = $wpdb->prefix . 'sync_basalam_map_options';
21		- $table_name_uploaded_photo = $wpdb->prefix . 'sync_basalam_uploaded_photo';
	21	+ $table_name_uploaded_media = $wpdb->prefix . 'sync_basalam_uploaded_media';
22	22	$table_name_debug_logs = $wpdb->prefix . 'sync_basalam_debug_logs';
23	23	$table_name_discount_tasks = $wpdb->prefix . 'sync_basalam_discount_tasks';
24	24	$table_name_category_mappings = $wpdb->prefix . 'sync_basalam_category_mappings';
25	25	$table_name_jobs_manager = $wpdb->prefix . 'sync_basalam_job_manager';
		@@ -42,16 +42,19 @@
42	42	sync_basalam_name VARCHAR(255),
43	43	PRIMARY KEY (id)
44	44	) $charset_collate;";
45	45
46		- $sql_uploaded_photo = "CREATE TABLE $table_name_uploaded_photo (
47		- id INT AUTO_INCREMENT,
48		- woo_photo_id INT,
49		- sync_basalam_photo_id INT,
50		- sync_basalam_photo_url VARCHAR(2083),
	46	+ $sql_uploaded_media = "CREATE TABLE $table_name_uploaded_media (
	47	+ id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
	48	+ type VARCHAR(16) NOT NULL,
	49	+ source_identity VARCHAR(191) NOT NULL,
	50	+ media_id BIGINT UNSIGNED NULL,
	51	+ media_url VARCHAR(2083) NULL,
51	52	created_at DATETIME NOT NULL,
52	53	PRIMARY KEY (id),
53		- UNIQUE KEY unique_woo_photo_id (woo_photo_id)
	54	+ UNIQUE KEY unique_type_source (type, source_identity),
	55	+ KEY idx_type_created (type, created_at),
	56	+ KEY idx_created_at (created_at)
54	57	) $charset_collate;";
55	58
56	59	$sql_debug_logs = "CREATE TABLE $table_name_debug_logs (
57	60	id BIGINT UNSIGNED AUTO_INCREMENT,
		@@ -122,9 +125,9 @@
122	125	) $charset_collate;";
123	126
124	127	dbDelta($sql_Payment);
125	128	dbDelta($sql_options);
126		- dbDelta($sql_uploaded_photo);
	129	+ dbDelta($sql_uploaded_media);
127	130	dbDelta($sql_debug_logs);
128	131	dbDelta($sql_discount_tasks);
129	132	dbDelta($sql_category_mappings);
130	133	dbDelta($sql_jobs_manager);