Changeset 374:9a80851e24f1
- Timestamp:
- 05/18/2009 08:03:11 PM (3 years ago)
- Author:
- Dmitry Nezhevenko <dion@…>
- Branch:
- default
- Message:
-
remove unused query
- Files:
-
Legend:
- Unmodified
- Added
- Removed
-
|
r373
|
r374
|
|
| 1 | 1 | DELETE FROM conference_jids where temporary=true; |
| 2 | | DELETE FROM conference_jids where jid in (SELECT jid FROM (select jid, count(jid) as cnt from conference_jids group by conference_id, jid) as tbl where cnt > 1); |
| | 2 | // DELETE FROM conference_jids where jid in (SELECT jid FROM (select jid, count(jid) as cnt from conference_jids group by conference_id, jid) as tbl where cnt > 1); |
| 3 | 3 | UPDATE conference_jids set jid=LOWER(jid); |
| 4 | 4 | |