← All changes | classes/helper/e2pdf-db.php +12 -6 1.32.31 → 1.32.53 View file →

		@@ -121,9 +121,9 @@
121	121	`title` text,
122	122	`created_at` datetime NOT NULL,
123	123	`updated_at` datetime NOT NULL,
124	124	`flatten` enum('0','1','2') NOT NULL DEFAULT '0',
125		- `tab_order` enum('0','1','2','3') NOT NULL DEFAULT '0',
	125	+ `tab_order` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
126	126	`compression` int(1) NOT NULL DEFAULT '-1',
127	127	`optimization` int(1) NOT NULL DEFAULT '-1',
128	128	`appearance` enum('0','1') NOT NULL DEFAULT '0',
129	129	`width` int(11) NOT NULL DEFAULT '0',
		@@ -217,10 +217,13 @@
217	217	if (!$wpdb->get_var("SHOW COLUMNS FROM `" . $db_prefix . "e2pdf_templates` LIKE 'text_align';")) {
218	218	$wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_templates` ADD COLUMN `text_align` varchar(255) NOT NULL AFTER line_height;");
219	219	}
220	220
221		- if (!$wpdb->get_var("SHOW COLUMNS FROM `" . $db_prefix . "e2pdf_templates` LIKE 'tab_order';")) {
222		- $wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_templates` ADD COLUMN `tab_order` enum('0','1','2','3') NOT NULL DEFAULT '0' AFTER flatten;");
	221	+ $tab_order = $wpdb->get_var("SHOW COLUMNS FROM `" . $db_prefix . "e2pdf_templates` LIKE 'tab_order';", 1);
	222	+ if ($tab_order === null) {
	223	+ $wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_templates` ADD COLUMN `tab_order` enum('0','1','2','3','4') NOT NULL DEFAULT '0' AFTER flatten;");
	224	+ } elseif (strpos($tab_order, "'4'") === false) {
	225	+ $wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_templates` MODIFY COLUMN `tab_order` enum('0','1','2','3','4') NOT NULL DEFAULT '0';");
223	226	}
224	227
225	228	if (!$wpdb->get_var("SHOW COLUMNS FROM `" . $db_prefix . "e2pdf_templates` LIKE 'item1';")) {
226	229	$wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_templates` ADD COLUMN `item1` varchar(255) NOT NULL AFTER item;");
		@@ -415,9 +418,9 @@
415	418	`title` text,
416	419	`created_at` datetime NOT NULL,
417	420	`updated_at` datetime NOT NULL,
418	421	`flatten` enum('0','1','2') NOT NULL DEFAULT '0',
419		- `tab_order` enum('0','1','2','3') NOT NULL DEFAULT '0',
	422	+ `tab_order` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
420	423	`compression` int(1) NOT NULL DEFAULT '-1',
421	424	`optimization` int(1) NOT NULL DEFAULT '-1',
422	425	`appearance` enum('0','1') NOT NULL DEFAULT '0',
423	426	`width` int(11) NOT NULL DEFAULT '0',
		@@ -498,10 +501,13 @@
498	501	if (!$wpdb->get_var("SHOW COLUMNS FROM `" . $db_prefix . "e2pdf_revisions` LIKE 'text_align';")) {
499	502	$wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_revisions` ADD COLUMN `text_align` varchar(255) NOT NULL AFTER line_height;");
500	503	}
501	504
502		- if (!$wpdb->get_var("SHOW COLUMNS FROM `" . $db_prefix . "e2pdf_revisions` LIKE 'tab_order';")) {
503		- $wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_revisions` ADD COLUMN `tab_order` enum('0','1','2','3') NOT NULL DEFAULT '0' AFTER flatten;");
	505	+ $tab_order = $wpdb->get_var("SHOW COLUMNS FROM `" . $db_prefix . "e2pdf_revisions` LIKE 'tab_order';", 1);
	506	+ if ($tab_order === null) {
	507	+ $wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_revisions` ADD COLUMN `tab_order` enum('0','1','2','3','4') NOT NULL DEFAULT '0' AFTER flatten;");
	508	+ } elseif (strpos($tab_order, "'4'") === false) {
	509	+ $wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_revisions` MODIFY COLUMN `tab_order` enum('0','1','2','3','4') NOT NULL DEFAULT '0';");
504	510	}
505	511
506	512	if (!$wpdb->get_var("SHOW COLUMNS FROM `" . $db_prefix . "e2pdf_revisions` LIKE 'item1';")) {
507	513	$wpdb->query("ALTER TABLE `" . $db_prefix . "e2pdf_revisions` ADD COLUMN `item1` varchar(255) NOT NULL AFTER item;");