Differential D8344 Diff 19854 resources/sql/patches/phameblog.sql

Changeset View

Standalone View

	Show All 22 Lines

	CREATE TABLE {$NAMESPACE}_phame.edgedata (			CREATE TABLE {$NAMESPACE}_phame.edgedata (
	id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,			id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
	data LONGTEXT NOT NULL COLLATE utf8_bin			data LONGTEXT NOT NULL COLLATE utf8_bin
	) ENGINE=InnoDB, COLLATE utf8_general_ci;			) ENGINE=InnoDB, COLLATE utf8_general_ci;

	ALTER TABLE {$NAMESPACE}_phame.phame_post			ALTER TABLE {$NAMESPACE}_phame.phame_post
	ADD KEY `instancePosts` (`visibility`, `datePublished`, `id`);			ADD KEY `instancePosts` (`visibility`, `datePublished`, `id`);