← All changes | models/class-revert.php +1 -16 158 → 113 View file →

		@@ -50,10 +50,9 @@
50	50	post_data text NULL,
51	51	old_uri varchar(500) NOT NULL,
52	52	plugin varchar(200) NOT NULL,
53	53	revert_dt datetime NOT NULL,
54		- PRIMARY KEY (id),
55		- KEY ix_lasso_id (lasso_id)
	54	+ PRIMARY KEY (id)
56	55	';
57	56	$sql = '
58	57	CREATE TABLE ' . $this->get_table_name() . ' (
59	58	' . $columns_sql . '
		@@ -71,20 +70,6 @@
71	70	ALTER TABLE ' . $this->get_table_name() . '
72	71	CHANGE `revert_dt` `revert_dt` DATETIME NOT NULL
73	72	';
74	73	self::query( $query );
75		- }
76		-
77		- /**
78		- * Add lasso_id index for revert lookups (v152+).
79		- */
80		- public function update_for_v152() {
81		- $index_name = 'ix_lasso_id';
82		- $table = $this->get_table_name();
83		- $exists = self::get_var(
84		- "SHOW INDEX FROM {$table} WHERE Key_name = '{$index_name}'"
85		- );
86		- if ( ! $exists ) {
87		- self::query( "ALTER TABLE {$table} ADD KEY {$index_name} (lasso_id)" );
88		- }
89	74	}
90	75	}