Browse code
Fix settings table column creation oversight with SMTP updates; also general consistency changes
Clarissa Walker authored on 2026/08/22 19:34:21
Showing 1 changed files
| ... | ... |
@@ -54,9 +54,9 @@ CREATE TABLE `fanfiction_settings` ( |
| 54 | 54 |
`disablepopups` tinyint(1) NOT NULL default '0', |
| 55 | 55 |
`agestatement` tinyint(1) NOT NULL default '0', |
| 56 | 56 |
`words` text, |
| 57 |
- `version` varchar(10) NOT NULL default '3.3', |
|
| 57 |
+ `version` varchar(10) NOT NULL default '3.5.9', |
|
| 58 | 58 |
`smtp_host` varchar(200) default NULL, |
| 59 | 59 |
`smtp_username` varchar(50) default NULL, |
| 60 | 60 |
`smtp_password` varchar(50) default NULL, |
| 61 | 61 |
PRIMARY KEY (`sitekey`) |
| 62 |
-) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
| 63 | 62 |
\ No newline at end of file |
| 63 |
+) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
Browse code
3.5.6 efiction version
Jimako authored on 2024/03/09 16:09:42
Showing 1 changed files
| 1 | 1 |
new file mode 100644 |
| ... | ... |
@@ -0,0 +1,62 @@ |
| 1 |
+-- |
|
| 2 |
+-- Table structure for table `settingsfanfiction_settings` |
|
| 3 |
+-- |
|
| 4 |
+ |
|
| 5 |
+CREATE TABLE `fanfiction_settings` ( |
|
| 6 |
+ `sitekey` varchar(50) NOT NULL default '1', |
|
| 7 |
+ `sitename` varchar(200) NOT NULL default 'Your Site', |
|
| 8 |
+ `slogan` varchar(200) NOT NULL default 'It\'s a cool site!', |
|
| 9 |
+ `url` varchar(200) NOT NULL default 'http://www.yoursite.com', |
|
| 10 |
+ `siteemail` varchar(200) NOT NULL default 'you@yoursite.com', |
|
| 11 |
+ `tableprefix` varchar(50) NOT NULL default '', |
|
| 12 |
+ `skin` varchar(50) NOT NULL default 'default', |
|
| 13 |
+ `hiddenskins` varchar(255) NULL default '', |
|
| 14 |
+ `language` varchar(10) NOT NULL default 'en', |
|
| 15 |
+ `submissionsoff` tinyint(1) NOT NULL default '0', |
|
| 16 |
+ `storiespath` varchar(20) NOT NULL default 'stories', |
|
| 17 |
+ `store` varchar(5) NOT NULL default 'files', |
|
| 18 |
+ `autovalidate` tinyint(1) NOT NULL default '0', |
|
| 19 |
+ `coauthallowed` int(1) NOT NULL default '0', |
|
| 20 |
+ `maxwords` int(11) NOT NULL default '0', |
|
| 21 |
+ `minwords` int(11) NOT NULL default '0', |
|
| 22 |
+ `imageupload` tinyint(1) NOT NULL default '0', |
|
| 23 |
+ `imageheight` int(11) NOT NULL default '200', |
|
| 24 |
+ `imagewidth` int(11) NOT NULL default '200', |
|
| 25 |
+ `roundrobins` tinyint(1) NOT NULL default '0', |
|
| 26 |
+ `allowseries` tinyint(4) NOT NULL default '2', |
|
| 27 |
+ `tinyMCE` tinyint(1) NOT NULL default '0', |
|
| 28 |
+ `allowed_tags` varchar(200) NOT NULL default '<b><i><u><center><hr><p><br /><br><blockquote><ol><ul><li><img><strong><em>', |
|
| 29 |
+ `favorites` tinyint(1) NOT NULL default '0', |
|
| 30 |
+ `multiplecats` tinyint(1) NOT NULL default '0', |
|
| 31 |
+ `newscomments` tinyint(1) NOT NULL default '0', |
|
| 32 |
+ `logging` tinyint(1) NOT NULL default '0', |
|
| 33 |
+ `maintenance` tinyint(1) NOT NULL default '0', |
|
| 34 |
+ `debug` tinyint(1) NOT NULL default '0', |
|
| 35 |
+ `captcha` tinyint(1) NOT NULL default '0', |
|
| 36 |
+ `dateformat` varchar(20) NOT NULL default 'd/m/y', |
|
| 37 |
+ `timeformat` varchar(20) NOT NULL default '- h:i a', |
|
| 38 |
+ `recentdays` tinyint(2) NOT NULL default '7', |
|
| 39 |
+ `displaycolumns` tinyint(1) NOT NULL default '1', |
|
| 40 |
+ `itemsperpage` tinyint(2) NOT NULL default '25', |
|
| 41 |
+ `extendcats` tinyint(1) NOT NULL default '0', |
|
| 42 |
+ `displayindex` tinyint(1) NOT NULL default '0', |
|
| 43 |
+ `defaultsort` tinyint(1) NOT NULL default '0', |
|
| 44 |
+ `displayprofile` tinyint(1) NOT NULL default '0', |
|
| 45 |
+ `linkstyle` tinyint(1) NOT NULL default '0', |
|
| 46 |
+ `linkrange` tinyint(2) NOT NULL default '5', |
|
| 47 |
+ `reviewsallowed` tinyint(1) NOT NULL default '0', |
|
| 48 |
+ `ratings` tinyint(1) NOT NULL default '0', |
|
| 49 |
+ `anonreviews` tinyint(1) NOT NULL default '0', |
|
| 50 |
+ `revdelete` tinyint(1) NOT NULL default '0', |
|
| 51 |
+ `rateonly` tinyint(1) NOT NULL default '0', |
|
| 52 |
+ `pwdsetting` tinyint(1) NOT NULL default '0', |
|
| 53 |
+ `alertson` tinyint(1) NOT NULL default '0', |
|
| 54 |
+ `disablepopups` tinyint(1) NOT NULL default '0', |
|
| 55 |
+ `agestatement` tinyint(1) NOT NULL default '0', |
|
| 56 |
+ `words` text, |
|
| 57 |
+ `version` varchar(10) NOT NULL default '3.3', |
|
| 58 |
+ `smtp_host` varchar(200) default NULL, |
|
| 59 |
+ `smtp_username` varchar(50) default NULL, |
|
| 60 |
+ `smtp_password` varchar(50) default NULL, |
|
| 61 |
+ PRIMARY KEY (`sitekey`) |
|
| 62 |
+) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
| 0 | 63 |
\ No newline at end of file |