border color for gcycle about craconweb HOT 10 CLOSED

BEGIN TRANSACTION;

--

ALTER TABLE gcycle_ugimage RENAME TO tmpx_gcycle_ugimage;

CREATE TABLE tmp_gcycle_ugimage (
    gcycle_ugimage_id BIGINT UNSIGNED NOT NULL PRIMARY KEY,
    gcycle_id BIGINT UNSIGNED NOT NULL,
    ugimage_id BIGINT UNSIGNED NOT NULL,
    sort INT UNSIGNED NOT NULL DEFAULT 0
);

INSERT INTO tmp_gcycle_ugimage
(gcycle_ugimage_id, gcycle_id, ugimage_id, sort)
SELECT gcycle_ugimage_id, gcycle_id, ugimage_id, sort
FROM tmpx_gcycle_ugimage;

DROP TABLE tmpx_gcycle_ugimage;

--

ALTER TABLE gcycle RENAME TO tmp_gcycle;

CREATE TABLE gcycle (
    gcycle_id BIGINT UNSIGNED NOT NULL PRIMARY KEY,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,

    gsession_id BIGINT UNSIGNED NOT NULL,
    sort INT UNSIGNED NOT NULL DEFAULT 0,
    fixation BIGINT UNSIGNED NOT NULL DEFAULT 0,
    selection BIGINT UNSIGNED NOT NULL DEFAULT 0,
    pictures BIGINT UNSIGNED NOT NULL DEFAULT 0,
    redcross BIGINT UNSIGNED NOT NULL DEFAULT 0,
    probe BIGINT UNSIGNED NOT NULL DEFAULT 0,
    border BIGINT UNSIGNED NOT NULL DEFAULT 0,
    timeout BIGINT UNSIGNED NOT NULL DEFAULT 0,
    width INT UNSIGNED NOT NULL DEFAULT 0,
    height INT UNSIGNED NOT NULL DEFAULT 0,
    blue BOOL NOT NULL DEFAULT 0,
    gray BOOL NOT NULL DEFAULT 0,
    dash BOOL NOT NULL DEFAULT 0,
    probe_index BIGINT UNSIGNED NOT NULL DEFAULT 0,
    target_index BIGINT UNSIGNED NOT NULL DEFAULT 0,
    selected_index BIGINT UNSIGNED NOT NULL DEFAULT 0,
    start_index BIGINT UNSIGNED NOT NULL DEFAULT 0,
    FOREIGN KEY(gsession_id) REFERENCES gsession(gsession_id)
);

INSERT INTO gcycle
(gcycle_id, created_at, gsession_id, sort, fixation, selection, pictures, redcross, probe, border, timeout, width, height, blue, dash, probe_index, target_index, selected_index, start_index)
SELECT gcycle_id, created_at, gsession_id, sort, fixation, selection, pictures, redcross, probe, border, timeout, width, height, blue, dash, probe_index, target_index, selected_index, start_index
FROM tmp_gcycle;

DROP TABLE tmp_gcycle;

--

CREATE TABLE gcycle_ugimage (
    gcycle_ugimage_id BIGINT UNSIGNED NOT NULL PRIMARY KEY,
    gcycle_id BIGINT UNSIGNED NOT NULL,
    ugimage_id BIGINT UNSIGNED NOT NULL,
    sort INT UNSIGNED NOT NULL DEFAULT 0,
    FOREIGN KEY(gcycle_id) REFERENCES gcycle(gcycle_id),
    FOREIGN KEY(ugimage_id) REFERENCES ugimage(ugimage_id),
    UNIQUE (gcycle_id, ugimage_id) ON CONFLICT FAIL,
    UNIQUE (gcycle_id, sort) ON CONFLICT FAIL
);

INSERT INTO gcycle_ugimage
(gcycle_ugimage_id, gcycle_id, ugimage_id, sort)
SELECT gcycle_ugimage_id, gcycle_id, ugimage_id, sort
FROM tmp_gcycle_ugimage;

DROP TABLE tmp_gcycle_ugimage;

--

COMMIT TRANSACTION;