| 1 | DROP TABLE IF EXISTS tmp_url_shortener; |
| 2 | CREATE TEMPORARY TABLE tmp_url_shortener LIKE url_shortener; |
| 3 | INSERT INTO tmp_url_shortener SELECT * FROM url_shortener; |
| 4 | DROP TABLE url_shortener; |
| 5 | CREATE TABLE url_shortener ( |
| 6 | alias VARCHAR(255) NOT NULL DEFAULT '', |
| 7 | url TEXT NOT NULL, |
| 8 | PRIMARY KEY (alias) |
| 9 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 10 | INSERT INTO url_shortener (alias, url) |
| 11 | SELECT alias, url |
| 12 | FROM tmp_url_shortener; |
| 13 | DROP TABLE IF EXISTS tmp_url_shortener; |
| 14 | |
| 15 | -- vim:set syntax=mysql: |