Differential D8344 Diff 19854 resources/sql/patches/20130622.doorkeeper.sql

Changeset View

Standalone View

Show All 26 Lines	CREATE TABLE {$NAMESPACE}_doorkeeper.edge (
PRIMARY KEY (src, type, dst),		PRIMARY KEY (src, type, dst),
KEY (src, type, dateCreated, seq)		KEY (src, type, dateCreated, seq)
) ENGINE=InnoDB, COLLATE utf8_general_ci;		) ENGINE=InnoDB, COLLATE utf8_general_ci;

CREATE TABLE {$NAMESPACE}_doorkeeper.edgedata (		CREATE TABLE {$NAMESPACE}_doorkeeper.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;