[platal.git] / upgrade / 1.1.1 / 03_url.sql

DROP TABLE IF EXISTS tmp_url_shortener;
CREATE TEMPORARY TABLE tmp_url_shortener LIKE url_shortener;
INSERT INTO tmp_url_shortener SELECT * FROM url_shortener;
DROP TABLE url_shortener;
CREATE TABLE url_shortener (
  alias VARCHAR(255) NOT NULL DEFAULT '',
  url TEXT NOT NULL,
  PRIMARY KEY (alias)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO  url_shortener (alias, url)
     SELECT  alias, url
       FROM  tmp_url_shortener;
DROP TABLE IF EXISTS tmp_url_shortener;

-- vim:set syntax=mysql:
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: