Differential D8344 Diff 19854 resources/sql/patches/20130322.phortune.sql

Changeset View

Standalone View

Show All 37 Lines	CREATE TABLE {$NAMESPACE}_phortune.edge (
PRIMARY KEY (src, type, dst),		PRIMARY KEY (src, type, dst),
KEY (src, type, dateCreated, seq)		KEY (src, type, dateCreated, seq)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;		) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE {$NAMESPACE}_phortune.edgedata (		CREATE TABLE {$NAMESPACE}_phortune.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 DEFAULT CHARSET=utf8;		) ENGINE=InnoDB DEFAULT CHARSET=utf8;