CREATE TABLE DbName.TableName ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id column comment', errcnt INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'errcnt column comment', user_id INT UNSIGNED NOT NULL, photo_id INT UNSIGNED NOT NULL, place_id INT UNSIGNED NOT NULL, next_processing_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY (place_id, next_processing_time), UNIQUE KEY (user_id, place_id, photo_id) );

Getters and Setters

Keep Comment

Camel Case

Underscore

Submit