CREATE TABLE IF NOT EXISTS submissions_template (
    submission_id INT NOT NULL AUTO_INCREMENT, -- unique ID of submission
    list_id INT NOT NULL, -- list that this submission belongs to
    create_dt DATETIME NOT NULL, -- timestamp of submission
    facebook_uin BIGINT NOT NULL, -- Facebook user's uin of submitter, storable indefinitely
    value VARCHAR(512) NOT NULL, -- submission text (i.e., "all gas stations are full-serve only")
    PRIMARY KEY pk_submissions_template (submission_id),
    INDEX ik_submissions_template_1 (create_dt),
    INDEX ik_submissions_template_2 (facebook_uin)
) ENGINE=MyISAM;