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