CREATE TABLE site_position_data_new_table (
id INT SERIAL NOT NULL,
workspace_name VARCHAR(128) DEFAULT NULL,
workspace_id INT DEFAULT NULL,
workspcace_tracking_frequency VARCHAR(45) DEFAULT NULL,
search_engine VARCHAR(128) DEFAULT NULL,
search_engine_id INT DEFAULT NULL,
search_term VARCHAR(128) DEFAULT NULL,
period VARCHAR(45) DEFAULT NULL,
position INT DEFAULT NULL,
feature VARCHAR(45) DEFAULT NUL,
url VARCHAR(2047) DEFAULT NULL,
site_id INT DEFAULT NULL,
site_label VARCHAR(256) DEFAULT NULL,
UNIQUE INDEX key_COMPOUND (
period, search_engine_id, search_term,
workspace_id, position, site_id
),
PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;