[platal.git] / upgrade / 0.9.14 / 08_autocomplete.sql

CREATE TABLE `search_autocomplete` (
      `name` varchar(20) NOT NULL,
      `query` varchar(100) NOT NULL,
      `result` text NOT NULL,
      `generated` datetime NOT NULL,
      PRIMARY KEY  (`name`,`query`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Commit	Line	Data
	1	CREATE TABLE `search_autocomplete` (
	2	`name` varchar(20) NOT NULL,
	3	`query` varchar(100) NOT NULL,
	4	`result` text NOT NULL,
	5	`generated` datetime NOT NULL,
	6	PRIMARY KEY (`name`,`query`)
	7	) ENGINE=MyISAM DEFAULT CHARSET=utf8;