diff options
| author | alecpl <alec@alec.pl> | 2008-06-12 17:46:31 +0000 |
|---|---|---|
| committer | alecpl <alec@alec.pl> | 2008-06-12 17:46:31 +0000 |
| commit | c98f3b5d6e4c681b7e42ea71c32cd2ef1991b519 (patch) | |
| tree | 60b76c380431f8c2ef9143164fc1bd79a966dccd /SQL/mysql.update.sql | |
| parent | dea67436608e5256c7a328cae8cbf766b970298d (diff) | |
#1485125: added index on messages.created
Diffstat (limited to 'SQL/mysql.update.sql')
| -rw-r--r-- | SQL/mysql.update.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index f07672614..ae6fb7533 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -25,3 +25,8 @@ ALTER TABLE `identities` MODIFY `organization` varchar(128) NOT NULL DEFAULT '', MODIFY `name` varchar(128) NOT NULL, MODIFY `email` varchar(128) NOT NULL; + +-- Updates from version 0.2-alpha + +ALTER TABLE `messages` + ADD INDEX `created_index` (`created`); |