DROP TABLE IF EXISTS card;

CREATE TABLE card (
    id INTEGER PRIMARY KEY,
    front TEXT NOT NULL,
    back TEXT NOT NULL,
    created_at DATETIME NOT NULL default CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL default CURRENT_TIMESTAMP
);

CREATE TRIGGER update_timestamp
AFTER UPDATE
ON card
FOR EACH ROW
BEGIN
    UPDATE card SET updated_at = CURRENT_TIMESTAMP WHERE id = OLD.id;
END;