CREATE TABLE b_search_phrase
(
	ID			INT(18)		NOT NULL auto_increment,
	TIMESTAMP_X		DATETIME	NOT NULL,
	SITE_ID			CHAR(2)		NOT NULL,
	RESULT_COUNT		INT(11)		NOT NULL,
	PAGES			INT(11)		NOT NULL,
	SESSION_ID		VARCHAR(32)	NOT NULL,
	PHRASE			VARCHAR(250),
	TAGS			VARCHAR(250),
	URL_TO			TEXT,
	URL_TO_404		CHAR(1),
	URL_TO_SITE_ID		CHAR(2),
	STAT_SESS_ID		INT(18),
	EVENT1			VARCHAR(50),
	PRIMARY KEY PK_B_SEARCH_PHRASE (ID),
	KEY IND_PK_B_SEARCH_PHRASE_SESS_PH (SESSION_ID, PHRASE(50)),
	KEY IND_PK_B_SEARCH_PHRASE_SESS_TG (SESSION_ID, TAGS(50)),
	KEY IND_PK_B_SEARCH_PHRASE_TIME (TIMESTAMP_X)
);
