Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

syntax error at or near "AUTO_INCREMENT"

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;
 
PREVIOUS NEXT
Tagged: #syntax #error
ADD COMMENT
Topic
Name
2+3 =