Page Menu
Home
Musing Studio
Search
Configure Global Search
Log In
Files
F10384389
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Size
1 KB
Subscribers
None
View Options
diff --git a/migrations/v13.go b/migrations/v13.go
index 40e8fa8..cb509f2 100644
--- a/migrations/v13.go
+++ b/migrations/v13.go
@@ -1,11 +1,60 @@
/*
- * Copyright © 2018-2023 A Bunch Tell LLC.
+ * Copyright © 2021 A Bunch Tell LLC.
*
* This file is part of WriteFreely.
*
* WriteFreely is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License, included
* in the LICENSE file in this source code package.
*/
package migrations
+
+func supportLetters(db *datastore) error {
+ t, err := db.Begin()
+ if err != nil {
+ t.Rollback()
+ return err
+ }
+
+ _, err = t.Exec(`CREATE TABLE publishjobs (
+ id ` + db.typeInt() + ` auto_increment,
+ post_id ` + db.typeVarChar(16) + ` not null,
+ action ` + db.typeVarChar(16) + ` not null,
+ delay ` + db.typeTinyInt() + ` not null,
+ PRIMARY KEY (id)
+)`)
+ if err != nil {
+ t.Rollback()
+ return err
+ }
+
+ // TODO: fix for SQLite database
+ _, err = t.Exec(`CREATE TABLE emailsubscribers (
+ id char(8) not null,
+ collection_id int not null,
+ user_id int null,
+ email varchar(255) null,
+ subscribed datetime not null,
+ token char(16) not null,
+ confirmed tinyint(1) default 0 not null,
+ allow_export tinyint(1) default 0 not null,
+ constraint eu_coll_email
+ unique (collection_id, email),
+ constraint eu_coll_user
+ unique (collection_id, user_id),
+ PRIMARY KEY (id)
+)`)
+ if err != nil {
+ t.Rollback()
+ return err
+ }
+
+ err = t.Commit()
+ if err != nil {
+ t.Rollback()
+ return err
+ }
+
+ return nil
+}
File Metadata
Details
Attached
Mime Type
text/x-diff
Expires
Sat, Nov 23, 3:34 PM (1 d, 4 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3104587
Attached To
rWF WriteFreely
Event Timeline
Log In to Comment