Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/roundcube/roundcubemail.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'SQL/sqlite/2022100100.sql')
-rw-r--r--SQL/sqlite/2022100100.sql9
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);