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 '',
9 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
10 INSERT INTO url_shortener (alias, url
)
12 FROM tmp_url_shortener
;
13 DROP TABLE IF EXISTS tmp_url_shortener
;
15 -- vim:set syntax=mysql: