diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/database.sql b/database.sql index c9e239075..5d7a3020c 100644 --- a/database.sql +++ b/database.sql @@ -477,7 +477,12 @@ CREATE TABLE IF NOT EXISTS `queue` ( `created` DATETIME NOT NULL , `last` DATETIME NOT NULL , `content` MEDIUMTEXT NOT NULL, -`batch` TINYINT( 1 ) NOT NULL DEFAULT '0' +`batch` TINYINT( 1 ) NOT NULL DEFAULT '0', +INDEX ( `cid` ), +INDEX ( `created` ), +INDEX ( `last` ), +INDEX ( `network` ), +INDEX ( `batch` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `pconfig` ( |