[platal.git] / upgrade / 0.9.6 / 10_search_name.sql


CREATE TABLE `search_name` (
  `uid` int(11) NOT NULL default '0',
  `token` char(255) NOT NULL default '',
  `score` int(11) NOT NULL default '0',
  PRIMARY KEY (token,uid),
  INDEX (uid)
);


drop table recherche;
Commit	Line	Data
0337d704	1
	2	CREATE TABLE `search_name` (
	3	`uid` int(11) NOT NULL default '0',
	4	`token` char(255) NOT NULL default '',
	5	`score` int(11) NOT NULL default '0',
	6	PRIMARY KEY (token,uid),
	7	INDEX (uid)
	8	);
	9
	10
	11	drop table recherche;
	12