Differential D8344 Diff 19854 resources/sql/patches/20130317.phrictionedge.sql

Changeset View

Standalone View

	CREATE TABLE {$NAMESPACE}_phriction.edge (			CREATE TABLE {$NAMESPACE}_phriction.edge (
	src VARCHAR(64) NOT NULL COLLATE utf8_bin,			src VARCHAR(64) NOT NULL COLLATE utf8_bin,
	type INT UNSIGNED NOT NULL COLLATE utf8_bin,			type INT UNSIGNED NOT NULL COLLATE utf8_bin,
	dst VARCHAR(64) NOT NULL COLLATE utf8_bin,			dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
	dateCreated INT UNSIGNED NOT NULL,			dateCreated INT UNSIGNED NOT NULL,
	seq INT UNSIGNED NOT NULL,			seq INT UNSIGNED NOT NULL,
	dataID INT UNSIGNED,			dataID INT UNSIGNED,
	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}_phriction.edgedata (			CREATE TABLE {$NAMESPACE}_phriction.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;