diff options
Diffstat (limited to 'SQL/sqlite/2022100100.sql')
-rw-r--r-- | SQL/sqlite/2022100100.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/SQL/sqlite/2022100100.sql b/SQL/sqlite/2022100100.sql new file mode 100644 index 000000000..97d83d2b2 --- /dev/null +++ b/SQL/sqlite/2022100100.sql @@ -0,0 +1,9 @@ +CREATE TABLE uploads ( + upload_id varchar(64) NOT NULL PRIMARY KEY, + session_id varchar(128) NOT NULL, + "group" varchar(128) NOT NULL, + metadata text NOT NULL, + created datetime NOT NULL default '0000-00-00 00:00:00' +); + +CREATE INDEX ix_uploads_session_id ON uploads(session_id, "group", created); |