town/sql/create_codes_db.sql

8 lines
207 B
MySQL
Raw Permalink Normal View History

2023-10-25 04:39:13 +00:00
CREATE TABLE IF NOT EXISTS auth_codes (
id INTEGER PRIMARY KEY,
created TEXT DEFAULT (strftime('%Y-%m-%dT%H:%M', 'now', 'localtime')),
code TEXT,
email TEXT,
used INTEGER DEFAULT 0
);