[platal.git] / upgrade / 1.1.0 / 15_url_shortener.sql

DROP TABLE IF EXISTS url_shortener;

CREATE TABLE url_shortener (
  alias CHAR(6) NOT NULL DEFAULT '',
  url TEXT NOT NULL,
  PRIMARY KEY (alias)
) ENGINE=InnoDB, CHARSET=utf8;

-- vim:set syntax=mysql:
Commit	Line	Data
e23d21c1 SJ	1	DROP TABLE IF EXISTS url_shortener;
	2
	3	CREATE TABLE url_shortener (
	4	alias CHAR(6) NOT NULL DEFAULT '',
	5	url TEXT NOT NULL,
	6	PRIMARY KEY (alias)
	7	) ENGINE=InnoDB, CHARSET=utf8;
	8
	9	-- vim:set syntax=mysql: