8 lines
207 B
MySQL
8 lines
207 B
MySQL
|
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
|
||
|
|
);
|