Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/20130317.phrictionedge.sql
| 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; | ||||