upgrade/1.1.1/03_url.sql

   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: