Differential D7751 Diff 17565 resources/sql/patches/20131211.phragmentedges.sql

Changeset View

Standalone View

				CREATE TABLE {$NAMESPACE}_phragment.edge (
				src VARCHAR(64) NOT NULL COLLATE utf8_bin,
				type VARCHAR(64) NOT NULL COLLATE utf8_bin,
				dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
				dateCreated INT UNSIGNED NOT NULL,
				seq INT UNSIGNED NOT NULL,
				dataID INT UNSIGNED,
				PRIMARY KEY (src, type, dst),
				KEY (src, type, dateCreated, seq)
				) ENGINE=InnoDB, COLLATE utf8_general_ci;

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