diff options
| author | Friendika <info@friendika.com> | 2011-10-22 01:29:26 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-10-22 01:29:26 -0700 |
| commit | 0ada550a02552a6a31872662d43795d07507efa6 (patch) | |
| tree | 219baf0ec4dafdff1f3f228cc0664c44228d02b7 /database.sql | |
| parent | 3783d8860c2ceabc846ef915ce8ae5e4784107b2 (diff) | |
| download | volse-hubzilla-0ada550a02552a6a31872662d43795d07507efa6.tar.gz volse-hubzilla-0ada550a02552a6a31872662d43795d07507efa6.tar.bz2 volse-hubzilla-0ada550a02552a6a31872662d43795d07507efa6.zip | |
queue indexes
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` ( |