Commit | Line | Data |
---|---|---|
b4b826ea SJ |
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: |