root/sqlconvert/tmp.sql
| Revision 374:9a80851e24f1, 419 bytes (checked in by Dmitry Nezhevenko <dion@…>, 3 years ago) |
|---|
| Line | |
|---|---|
| 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); |
| 3 | UPDATE conference_jids set jid=LOWER(jid); |
| 4 | |
| 5 | ... cleanup nicks/jids here ... |
| 6 | |
| 7 | ALTER TABLE conference_jids add UNIQUE(conference_id, jid); |
| 8 | ALTER TABLE conference_nicks add UNIQUE(conference_id, nick, jid); |
Note: See TracBrowser
for help on using the browser.
