Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/autopatches/20150605.diviner.edges.sql
- This file was added.
| CREATE TABLE {$NAMESPACE}_diviner.edge ( | |||||
| src VARBINARY(64) NOT NULL, | |||||
| type INT UNSIGNED NOT NULL, | |||||
| dst VARBINARY(64) NOT NULL, | |||||
| dateCreated INT UNSIGNED NOT NULL, | |||||
| seq INT UNSIGNED NOT NULL, | |||||
| dataID INT UNSIGNED, | |||||
| PRIMARY KEY (src, type, dst), | |||||
| KEY src (src, type, dateCreated, seq), | |||||
| UNIQUE KEY key_dst (dst, type, src) | |||||
| ) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT}; | |||||
| CREATE TABLE {$NAMESPACE}_diviner.edgedata ( | |||||
| id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, | |||||
| data LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT} | |||||
| ) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT}; | |||||