Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/ponder.sql
| Show First 20 Lines • Show All 41 Lines • ▼ Show 20 Lines | CREATE TABLE `{$NAMESPACE}_ponder`.`edge` ( | ||||
| PRIMARY KEY (`src`,`type`,`dst`), | PRIMARY KEY (`src`,`type`,`dst`), | ||||
| KEY `src` (`src`,`type`,`dateCreated`,`seq`) | KEY `src` (`src`,`type`,`dateCreated`,`seq`) | ||||
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||||
| CREATE TABLE `{$NAMESPACE}_ponder`.`edgedata` ( | CREATE TABLE `{$NAMESPACE}_ponder`.`edgedata` ( | ||||
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | ||||
| `data` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | `data` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | ||||
| PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||||
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||||
| No newline at end of file | |||||