diff options
| author | Louis Burda <quent.burda@gmail.com> | 2022-11-06 02:09:32 +0100 |
|---|---|---|
| committer | Louis Burda <quent.burda@gmail.com> | 2022-11-06 02:09:32 +0100 |
| commit | 42c73528483b6a61ebe6c355c089d11f3ef8efca (patch) | |
| tree | bd281357f225e26c48cb1e33f69a3117e7eb249c | |
| parent | e6ff8ccc10d2b6ccd23d154dc1aec373c6e1882d (diff) | |
| download | bambi7-service-fireworx-42c73528483b6a61ebe6c355c089d11f3ef8efca.tar.gz bambi7-service-fireworx-42c73528483b6a61ebe6c355c089d11f3ef8efca.zip | |
Capitalize sql NULL
| -rw-r--r-- | service/init.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/service/init.sql b/service/init.sql index dd31b3a..fdcf10a 100644 --- a/service/init.sql +++ b/service/init.sql @@ -1,6 +1,6 @@ CREATE TABLE IF NOT EXISTS users( id INTEGER PRIMARY KEY AUTOINCREMENT, - creat INTEGER DEFAULT null, + creat INTEGER DEFAULT NULL, name TEXT UNIQUE, p TEXT, q TEXT, @@ -24,5 +24,5 @@ CREATE INDEX IF NOT EXISTS users_name ON users(name); CREATE TRIGGER IF NOT EXISTS users_creat AFTER INSERT ON users BEGIN - UPDATE users SET creat = strftime("%s", "now") WHERE creat IS null; + UPDATE users SET creat = strftime("%s", "now") WHERE creat IS NULL; END |