Browse code
Initial uplad w/ php7 fixes
Rainer Volkrodt authored on 2016/03/12 15:54:02
Showing 1 changed files
| 1 | 1 |
new file mode 100644 |
| ... | ... |
@@ -0,0 +1,553 @@ |
| 1 |
+-- |
|
| 2 |
+-- Table structure for table `fanfiction_authorfields` |
|
| 3 |
+-- |
|
| 4 |
+ |
|
| 5 |
+CREATE TABLE `fanfiction_authorfields` ( |
|
| 6 |
+ `field_id` int(11) NOT NULL auto_increment, |
|
| 7 |
+ `field_type` tinyint(4) NOT NULL default '0', |
|
| 8 |
+ `field_name` varchar(30) NOT NULL default '', |
|
| 9 |
+ `field_title` varchar(255) NOT NULL default '', |
|
| 10 |
+ `field_options` text, |
|
| 11 |
+ `field_code_in` text, |
|
| 12 |
+ `field_code_out` text, |
|
| 13 |
+ `field_on` tinyint(1) NOT NULL default '0', |
|
| 14 |
+ PRIMARY KEY (`field_id`) |
|
| 15 |
+) REPLACE=MyISAM; |
|
| 16 |
+ |
|
| 17 |
+-- -------------------------------------------------------- |
|
| 18 |
+ |
|
| 19 |
+-- |
|
| 20 |
+-- Table structure for table `fanfiction_authorinfo` |
|
| 21 |
+-- |
|
| 22 |
+ |
|
| 23 |
+CREATE TABLE `fanfiction_authorinfo` ( |
|
| 24 |
+ `uid` int(11) NOT NULL default '0', |
|
| 25 |
+ `field` int(11) NOT NULL default '0', |
|
| 26 |
+ `info` varchar(255) NOT NULL default '', |
|
| 27 |
+ PRIMARY KEY (`uid`,`field`), |
|
| 28 |
+ KEY `uid` (`uid`) |
|
| 29 |
+) REPLACE=MyISAM; |
|
| 30 |
+ |
|
| 31 |
+-- -------------------------------------------------------- |
|
| 32 |
+ |
|
| 33 |
+-- |
|
| 34 |
+-- Table structure for table `fanfiction_authorprefs` |
|
| 35 |
+-- |
|
| 36 |
+ |
|
| 37 |
+CREATE TABLE `fanfiction_authorprefs` ( |
|
| 38 |
+ `uid` int(11) NOT NULL default '0', |
|
| 39 |
+ `newreviews` tinyint(1) NOT NULL default '0', |
|
| 40 |
+ `newrespond` tinyint(1) NOT NULL default '0', |
|
| 41 |
+ `ageconsent` tinyint(1) NOT NULL default '0', |
|
| 42 |
+ `alertson` tinyint(1) NOT NULL default '0', |
|
| 43 |
+ `tinyMCE` tinyint(1) NOT NULL default '0', |
|
| 44 |
+ `sortby` tinyint(1) NOT NULL default '0', |
|
| 45 |
+ `storyindex` tinyint(1) NOT NULL default '0', |
|
| 46 |
+ `validated` tinyint(1) NOT NULL default '0', |
|
| 47 |
+ `userskin` varchar(60) NOT NULL default 'default', |
|
| 48 |
+ `level` tinyint(1) NOT NULL default '0', |
|
| 49 |
+ `categories` varchar(200) NOT NULL default '0', |
|
| 50 |
+ `contact` tinyint(1) NOT NULL default '0', |
|
| 51 |
+ `stories` int(11) NOT NULL default '', |
|
| 52 |
+ PRIMARY KEY (`uid`) |
|
| 53 |
+) REPLACE=MyISAM; |
|
| 54 |
+ |
|
| 55 |
+-- -------------------------------------------------------- |
|
| 56 |
+ |
|
| 57 |
+-- |
|
| 58 |
+-- Table structure for table `fanfiction_authors` |
|
| 59 |
+-- |
|
| 60 |
+ |
|
| 61 |
+CREATE TABLE `fanfiction_authors` ( |
|
| 62 |
+ `uid` int(11) NOT NULL auto_increment, |
|
| 63 |
+ `penname` varchar(200) NOT NULL default '', |
|
| 64 |
+ `realname` varchar(200) NOT NULL default '', |
|
| 65 |
+ `email` varchar(200) NOT NULL default '', |
|
| 66 |
+ `website` varchar(200) NOT NULL default '', |
|
| 67 |
+ `bio` text NOT NULL, |
|
| 68 |
+ `image` varchar(200) NOT NULL default '', |
|
| 69 |
+ `date` datetime NOT NULL default '0000-00-00 00:00:00', |
|
| 70 |
+ `admincreated` int(11) NOT NULL default '0', |
|
| 71 |
+ `password` varchar(40) NOT NULL default '0', |
|
| 72 |
+ PRIMARY KEY (`uid`), |
|
| 73 |
+ KEY `penname` (`penname`), |
|
| 74 |
+ KEY `admincreated` (`admincreated`) |
|
| 75 |
+) REPLACE=MyISAM; |
|
| 76 |
+ |
|
| 77 |
+-- -------------------------------------------------------- |
|
| 78 |
+ |
|
| 79 |
+-- |
|
| 80 |
+-- Table structure for table `fanfiction_blocks` |
|
| 81 |
+-- |
|
| 82 |
+ |
|
| 83 |
+CREATE TABLE `fanfiction_blocks` ( |
|
| 84 |
+ `block_id` int(11) NOT NULL auto_increment, |
|
| 85 |
+ `block_name` varchar(30) NOT NULL default '', |
|
| 86 |
+ `block_title` varchar(150) NOT NULL default '', |
|
| 87 |
+ `block_file` varchar(200) NOT NULL default '', |
|
| 88 |
+ `block_status` tinyint(1) NOT NULL default '0', |
|
| 89 |
+ `block_variables` text NOT NULL, |
|
| 90 |
+ PRIMARY KEY (`block_id`), |
|
| 91 |
+ KEY `block_name` (`block_name`) |
|
| 92 |
+) REPLACE=MyISAM; |
|
| 93 |
+ |
|
| 94 |
+-- -------------------------------------------------------- |
|
| 95 |
+ |
|
| 96 |
+-- |
|
| 97 |
+-- Table structure for table `fanfiction_categories` |
|
| 98 |
+-- |
|
| 99 |
+ |
|
| 100 |
+CREATE TABLE `fanfiction_categories` ( |
|
| 101 |
+ `catid` int(11) NOT NULL auto_increment, |
|
| 102 |
+ `parentcatid` int(11) NOT NULL default '-1', |
|
| 103 |
+ `category` varchar(60) NOT NULL default '', |
|
| 104 |
+ `description` text NOT NULL, |
|
| 105 |
+ `image` varchar(100) NOT NULL default '', |
|
| 106 |
+ `locked` tinyint(4) NOT NULL default '0', |
|
| 107 |
+ `leveldown` tinyint(4) NOT NULL default '0', |
|
| 108 |
+ `displayorder` int(4) NOT NULL default '0', |
|
| 109 |
+ `numitems` int(11) NOT NULL default '0', |
|
| 110 |
+ PRIMARY KEY (`catid`), |
|
| 111 |
+ KEY `byparent` (`parentcatid`,`displayorder`) |
|
| 112 |
+) REPLACE=MyISAM; |
|
| 113 |
+ |
|
| 114 |
+-- -------------------------------------------------------- |
|
| 115 |
+ |
|
| 116 |
+-- |
|
| 117 |
+-- Table structure for table `fanfiction_chapters` |
|
| 118 |
+-- |
|
| 119 |
+ |
|
| 120 |
+CREATE TABLE `fanfiction_chapters` ( |
|
| 121 |
+ `chapid` int(11) NOT NULL auto_increment, |
|
| 122 |
+ `title` varchar(250) NOT NULL default '', |
|
| 123 |
+ `inorder` int(11) NOT NULL default '0', |
|
| 124 |
+ `notes` text NOT NULL, |
|
| 125 |
+ `storytext` text NOT NULL, |
|
| 126 |
+ `endnotes` text, |
|
| 127 |
+ `validated` tinyint(4) NOT NULL default '0', |
|
| 128 |
+ `wordcount` int(11) NOT NULL default '0', |
|
| 129 |
+ `rating` tinyint(4) NOT NULL default '0', |
|
| 130 |
+ `reviews` smallint(6) NOT NULL default '0', |
|
| 131 |
+ `sid` int(11) NOT NULL default '0', |
|
| 132 |
+ `uid` int(11) NOT NULL default '0', |
|
| 133 |
+ `count` int(11) NOT NULL default '0', |
|
| 134 |
+ PRIMARY KEY (`chapid`), |
|
| 135 |
+ KEY `sid` (`sid`), |
|
| 136 |
+ KEY `uid` (`uid`), |
|
| 137 |
+ KEY `inorder` (`inorder`), |
|
| 138 |
+ KEY `title` (`title`), |
|
| 139 |
+ KEY `validated` (`validated`), |
|
| 140 |
+ KEY `forstoryblock` (`sid`,`validated`) |
|
| 141 |
+) REPLACE=MyISAM; |
|
| 142 |
+ |
|
| 143 |
+-- -------------------------------------------------------- |
|
| 144 |
+ |
|
| 145 |
+-- |
|
| 146 |
+-- Table structure for table `fanfiction_characters` |
|
| 147 |
+-- |
|
| 148 |
+ |
|
| 149 |
+CREATE TABLE `fanfiction_characters` ( |
|
| 150 |
+ `charid` int(11) NOT NULL auto_increment, |
|
| 151 |
+ `catid` int(11) NOT NULL default '0', |
|
| 152 |
+ `charname` varchar(60) NOT NULL default '', |
|
| 153 |
+ `bio` text NOT NULL, |
|
| 154 |
+ `image` varchar(200) NOT NULL default '', |
|
| 155 |
+ PRIMARY KEY (`charid`), |
|
| 156 |
+ KEY `catid` (`catid`), |
|
| 157 |
+ KEY `charname` (`charname`) |
|
| 158 |
+) REPLACE=MyISAM; |
|
| 159 |
+ |
|
| 160 |
+-- -------------------------------------------------------- |
|
| 161 |
+ |
|
| 162 |
+-- |
|
| 163 |
+-- Table structure for table `fanfiction_classes` |
|
| 164 |
+-- |
|
| 165 |
+ |
|
| 166 |
+CREATE TABLE `fanfiction_classes` ( |
|
| 167 |
+ `class_id` int(11) NOT NULL auto_increment, |
|
| 168 |
+ `class_type` int(11) NOT NULL default '0', |
|
| 169 |
+ `class_name` varchar(100) NOT NULL default '', |
|
| 170 |
+ PRIMARY KEY (`class_id`), |
|
| 171 |
+ KEY `byname` (`class_type`,`class_name`,`class_id`) |
|
| 172 |
+) REPLACE=MyISAM; |
|
| 173 |
+ |
|
| 174 |
+-- -------------------------------------------------------- |
|
| 175 |
+ |
|
| 176 |
+-- |
|
| 177 |
+-- Table structure for table `fanfiction_classtypes` |
|
| 178 |
+-- |
|
| 179 |
+ |
|
| 180 |
+CREATE TABLE `fanfiction_classtypes` ( |
|
| 181 |
+ `classtype_id` int(11) NOT NULL auto_increment, |
|
| 182 |
+ `classtype_name` varchar(50) NOT NULL default '', |
|
| 183 |
+ `classtype_title` varchar(50) NOT NULL default '', |
|
| 184 |
+ PRIMARY KEY (`classtype_id`), |
|
| 185 |
+ UNIQUE KEY `classtype_name` (`classtype_name`) |
|
| 186 |
+) REPLACE=MyISAM; |
|
| 187 |
+ |
|
| 188 |
+-- -------------------------------------------------------- |
|
| 189 |
+ |
|
| 190 |
+-- |
|
| 191 |
+-- Table structure for table `fanfiction_coauthors` |
|
| 192 |
+-- |
|
| 193 |
+ |
|
| 194 |
+CREATE TABLE `fanfiction_coauthors` ( |
|
| 195 |
+ `sid` int(11) NOT NULL default '0', |
|
| 196 |
+ `uid` int(11) NOT NULL default '0', |
|
| 197 |
+ PRIMARY KEY (`sid`,`uid`), |
|
| 198 |
+) REPLACE=MyISAM; |
|
| 199 |
+-- -------------------------------------------------------- |
|
| 200 |
+ |
|
| 201 |
+-- |
|
| 202 |
+-- Table structure for table `fanfiction_codeblocks` |
|
| 203 |
+-- |
|
| 204 |
+ |
|
| 205 |
+CREATE TABLE `fanfiction_codeblocks` ( |
|
| 206 |
+ `code_id` int(11) NOT NULL auto_increment, |
|
| 207 |
+ `code_text` text NOT NULL, |
|
| 208 |
+ `code_type` varchar(20) default NULL, |
|
| 209 |
+ `code_module` varchar(60) default NULL, |
|
| 210 |
+ PRIMARY KEY (`code_id`), |
|
| 211 |
+ KEY `code_type` (`code_type`) |
|
| 212 |
+) REPLACE=MyISAM; |
|
| 213 |
+ |
|
| 214 |
+-- -------------------------------------------------------- |
|
| 215 |
+ |
|
| 216 |
+-- |
|
| 217 |
+-- Table structure for table `fanfiction_comments` |
|
| 218 |
+-- |
|
| 219 |
+ |
|
| 220 |
+CREATE TABLE `fanfiction_comments` ( |
|
| 221 |
+ `cid` int(11) NOT NULL auto_increment, |
|
| 222 |
+ `nid` int(11) NOT NULL default '0', |
|
| 223 |
+ `uid` int(11) NOT NULL default '0', |
|
| 224 |
+ `comment` text NOT NULL, |
|
| 225 |
+ `time` datetime NOT NULL default '0000-00-00 00:00:00', |
|
| 226 |
+ PRIMARY KEY (`cid`), |
|
| 227 |
+ KEY `commentlist` (`nid`,`time`) |
|
| 228 |
+) REPLACE=MyISAM; |
|
| 229 |
+ |
|
| 230 |
+-- -------------------------------------------------------- |
|
| 231 |
+ |
|
| 232 |
+-- |
|
| 233 |
+-- Table structure for table `fanfiction_favorites` |
|
| 234 |
+-- |
|
| 235 |
+ |
|
| 236 |
+CREATE TABLE `fanfiction_favorites` ( |
|
| 237 |
+ `uid` int(11) NOT NULL default '0', |
|
| 238 |
+ `item` int(11) NOT NULL default '0', |
|
| 239 |
+ `type` char(2) NOT NULL default '', |
|
| 240 |
+ `comments` text, |
|
| 241 |
+ UNIQUE KEY `byitem` (`item`,`type`,`uid`), |
|
| 242 |
+ UNIQUE KEY `byuid` (`uid`,`type`,`item`) |
|
| 243 |
+) REPLACE=MyISAM; |
|
| 244 |
+ |
|
| 245 |
+-- -------------------------------------------------------- |
|
| 246 |
+ |
|
| 247 |
+-- |
|
| 248 |
+-- Table structure for table `fanfiction_inseries` |
|
| 249 |
+-- |
|
| 250 |
+ |
|
| 251 |
+CREATE TABLE `fanfiction_inseries` ( |
|
| 252 |
+ `seriesid` int(11) NOT NULL default '0', |
|
| 253 |
+ `sid` int(11) NOT NULL default '0', |
|
| 254 |
+ `subseriesid` int(11) NOT NULL default '0', |
|
| 255 |
+ `confirmed` int(11) NOT NULL default '0', |
|
| 256 |
+ `inorder` int(11) NOT NULL default '0', |
|
| 257 |
+ `updated` datetime NOT NULL default '0000-00-00 00:00:00', |
|
| 258 |
+ PRIMARY KEY (`sid`,`seriesid`), |
|
| 259 |
+ KEY `seriesid` (`seriesid`,`inorder`) |
|
| 260 |
+) REPLACE=MyISAM; |
|
| 261 |
+ |
|
| 262 |
+-- -------------------------------------------------------- |
|
| 263 |
+ |
|
| 264 |
+-- |
|
| 265 |
+-- Table structure for table `fanfiction_log` |
|
| 266 |
+-- |
|
| 267 |
+ |
|
| 268 |
+CREATE TABLE `fanfiction_log` ( |
|
| 269 |
+ `log_id` int(11) NOT NULL auto_increment, |
|
| 270 |
+ `log_action` varchar(255) default NULL, |
|
| 271 |
+ `log_uid` int(11) NOT NULL default '0', |
|
| 272 |
+ `log_ip` int(11) default NULL, |
|
| 273 |
+ `log_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
|
| 274 |
+ `log_type` char(2) NOT NULL default '', |
|
| 275 |
+ PRIMARY KEY (`log_id`) |
|
| 276 |
+) REPLACE=MyISAM; |
|
| 277 |
+ |
|
| 278 |
+-- -------------------------------------------------------- |
|
| 279 |
+ |
|
| 280 |
+-- |
|
| 281 |
+-- Table structure for table `fanfiction_messages` |
|
| 282 |
+-- |
|
| 283 |
+ |
|
| 284 |
+CREATE TABLE `fanfiction_messages` ( |
|
| 285 |
+ `message_id` int(11) NOT NULL auto_increment, |
|
| 286 |
+ `message_name` varchar(50) NOT NULL default '', |
|
| 287 |
+ `message_title` varchar(200) NOT NULL default '', |
|
| 288 |
+ `message_text` text, |
|
| 289 |
+ PRIMARY KEY (`message_id`), |
|
| 290 |
+ KEY `message_name` (`message_name`) |
|
| 291 |
+) REPLACE=MyISAM; |
|
| 292 |
+ |
|
| 293 |
+-- -------------------------------------------------------- |
|
| 294 |
+ |
|
| 295 |
+-- |
|
| 296 |
+-- Table structure for table `fanfiction_modules` |
|
| 297 |
+-- |
|
| 298 |
+ |
|
| 299 |
+CREATE TABLE `fanfiction_modules` ( |
|
| 300 |
+ `id` int(11) NOT NULL, |
|
| 301 |
+ `name` varchar(100) NOT NULL default 'Test Module', |
|
| 302 |
+ `version` varchar(10) NOT NULL default '1.0', |
|
| 303 |
+ PRIMARY KEY (`id`), |
|
| 304 |
+ KEY `name_version` (`name`,`version`) |
|
| 305 |
+) REPLACE=MyISAM; |
|
| 306 |
+ |
|
| 307 |
+-- -------------------------------------------------------- |
|
| 308 |
+ |
|
| 309 |
+-- |
|
| 310 |
+-- Table structure for table `fanfiction_news` |
|
| 311 |
+-- |
|
| 312 |
+ |
|
| 313 |
+CREATE TABLE `fanfiction_news` ( |
|
| 314 |
+ `nid` int(11) NOT NULL auto_increment, |
|
| 315 |
+ `author` varchar(60) NOT NULL default '', |
|
| 316 |
+ `title` varchar(255) NOT NULL default '', |
|
| 317 |
+ `story` text NOT NULL, |
|
| 318 |
+ `time` datetime default NULL, |
|
| 319 |
+ `comments` int(11) NOT NULL default '0', |
|
| 320 |
+ PRIMARY KEY (`nid`) |
|
| 321 |
+) REPLACE=MyISAM; |
|
| 322 |
+ |
|
| 323 |
+-- -------------------------------------------------------- |
|
| 324 |
+ |
|
| 325 |
+-- |
|
| 326 |
+-- Table structure for table `fanfiction_pagelinks` |
|
| 327 |
+-- |
|
| 328 |
+ |
|
| 329 |
+CREATE TABLE `fanfiction_pagelinks` ( |
|
| 330 |
+ `link_id` int(11) NOT NULL auto_increment, |
|
| 331 |
+ `link_name` varchar(50) NOT NULL default '', |
|
| 332 |
+ `link_text` varchar(100) NOT NULL default '', |
|
| 333 |
+ `link_url` varchar(250) NOT NULL default '', |
|
| 334 |
+ `link_target` char(1) NOT NULL default '0', |
|
| 335 |
+ `link_access` tinyint(4) NOT NULL default '0', |
|
| 336 |
+ PRIMARY KEY (`link_id`), |
|
| 337 |
+ KEY `link_name` (`link_name`) |
|
| 338 |
+) REPLACE=MyISAM; |
|
| 339 |
+ |
|
| 340 |
+-- -------------------------------------------------------- |
|
| 341 |
+ |
|
| 342 |
+-- |
|
| 343 |
+-- Table structure for table `fanfiction_panels` |
|
| 344 |
+-- |
|
| 345 |
+ |
|
| 346 |
+CREATE TABLE `fanfiction_panels` ( |
|
| 347 |
+ `panel_id` int(11) NOT NULL auto_increment, |
|
| 348 |
+ `panel_name` varchar(50) NOT NULL default 'unknown', |
|
| 349 |
+ `panel_title` varchar(100) NOT NULL default 'Unnamed Panel', |
|
| 350 |
+ `panel_url` varchar(100) default NULL, |
|
| 351 |
+ `panel_level` tinyint(4) NOT NULL default '3', |
|
| 352 |
+ `panel_order` tinyint(4) NOT NULL default '0', |
|
| 353 |
+ `panel_hidden` tinyint(1) NOT NULL default '0', |
|
| 354 |
+ `panel_type` varchar(20) NOT NULL default 'A', |
|
| 355 |
+ PRIMARY KEY (`panel_id`), |
|
| 356 |
+ KEY `panel_type` (`panel_type`,`panel_name`) |
|
| 357 |
+) REPLACE=MyISAM; |
|
| 358 |
+ |
|
| 359 |
+-- -------------------------------------------------------- |
|
| 360 |
+ |
|
| 361 |
+-- |
|
| 362 |
+-- Table structure for table `fanfiction_ratings` |
|
| 363 |
+-- |
|
| 364 |
+ |
|
| 365 |
+CREATE TABLE `fanfiction_ratings` ( |
|
| 366 |
+ `rid` int(11) NOT NULL auto_increment, |
|
| 367 |
+ `rating` varchar(60) NOT NULL default '', |
|
| 368 |
+ `ratingwarning` int(11) NOT NULL default '0', |
|
| 369 |
+ `warningtext` text NOT NULL, |
|
| 370 |
+ PRIMARY KEY (`rid`), |
|
| 371 |
+ KEY `rating` (`rating`) |
|
| 372 |
+) REPLACE=MyISAM; |
|
| 373 |
+ |
|
| 374 |
+-- -------------------------------------------------------- |
|
| 375 |
+ |
|
| 376 |
+-- |
|
| 377 |
+-- Table structure for table `fanfiction_reviews` |
|
| 378 |
+-- |
|
| 379 |
+ |
|
| 380 |
+CREATE TABLE `fanfiction_reviews` ( |
|
| 381 |
+ `reviewid` int(11) NOT NULL auto_increment, |
|
| 382 |
+ `item` int(11) NOT NULL default '0', |
|
| 383 |
+ `chapid` int(11) NOT NULL default '0', |
|
| 384 |
+ `reviewer` varchar(60) NOT NULL default '0', |
|
| 385 |
+ `uid` int(11) NOT NULL default '0', |
|
| 386 |
+ `review` text NOT NULL, |
|
| 387 |
+ `date` datetime NOT NULL default '0000-00-00 00:00:00', |
|
| 388 |
+ `rating` int(11) NOT NULL default '0', |
|
| 389 |
+ `respond` char(1) NOT NULL default '0', |
|
| 390 |
+ `type` char(2) NOT NULL default 'ST', |
|
| 391 |
+ PRIMARY KEY (`reviewid`), |
|
| 392 |
+ KEY `psid` (`chapid`), |
|
| 393 |
+ KEY `rating` (`rating`), |
|
| 394 |
+ KEY `respond` (`respond`), |
|
| 395 |
+ KEY `avgrating` (`type`,`item`,`rating`), |
|
| 396 |
+ KEY `bychapter` (`chapid`,`rating`), |
|
| 397 |
+ KEY `byuid` (`uid`,`item`,`type`) |
|
| 398 |
+) REPLACE=MyISAM; |
|
| 399 |
+ |
|
| 400 |
+-- -------------------------------------------------------- |
|
| 401 |
+ |
|
| 402 |
+-- |
|
| 403 |
+-- Table structure for table `fanfiction_series` |
|
| 404 |
+-- |
|
| 405 |
+ |
|
| 406 |
+CREATE TABLE `fanfiction_series` ( |
|
| 407 |
+ `seriesid` int(11) NOT NULL auto_increment, |
|
| 408 |
+ `title` varchar(200) NOT NULL default '', |
|
| 409 |
+ `summary` text, |
|
| 410 |
+ `uid` int(11) NOT NULL default '0', |
|
| 411 |
+ `isopen` tinyint(4) NOT NULL default '0', |
|
| 412 |
+ `catid` varchar(200) NOT NULL default '0', |
|
| 413 |
+ `rating` tinyint(4) NOT NULL default '0', |
|
| 414 |
+ `classes` varchar(200) default NULL, |
|
| 415 |
+ `characters` varchar(250) NOT NULL default '', |
|
| 416 |
+ `reviews` smallint(6) NOT NULL default '0', |
|
| 417 |
+ `numstories` int(11) NOT NULL default '0', |
|
| 418 |
+ `warnings` varchar(250) NOT NULL default '', |
|
| 419 |
+ `challenges` varchar(200) NOT NULL default '', |
|
| 420 |
+ `genres` varchar(250) NOT NULL default '', |
|
| 421 |
+ PRIMARY KEY (`seriesid`), |
|
| 422 |
+ KEY `catid` (`catid`), |
|
| 423 |
+ KEY `owner` (`uid`,`title`) |
|
| 424 |
+) REPLACE=MyISAM; |
|
| 425 |
+ |
|
| 426 |
+-- -------------------------------------------------------- |
|
| 427 |
+-- |
|
| 428 |
+-- Table structure for table `fanfiction_stats` |
|
| 429 |
+-- |
|
| 430 |
+ |
|
| 431 |
+CREATE TABLE `fanfiction_stats` ( |
|
| 432 |
+ `sitekey` varchar(50) NOT NULL default '0', |
|
| 433 |
+ `stories` int(11) NOT NULL default '0', |
|
| 434 |
+ `chapters` int(11) NOT NULL default '0', |
|
| 435 |
+ `series` int(11) NOT NULL default '0', |
|
| 436 |
+ `reviews` int(11) NOT NULL default '0', |
|
| 437 |
+ `wordcount` int(11) NOT NULL default '0', |
|
| 438 |
+ `authors` int(11) NOT NULL default '0', |
|
| 439 |
+ `members` int(11) NOT NULL default '0', |
|
| 440 |
+ `reviewers` int(11) NOT NULL default '0', |
|
| 441 |
+ `newestmember` int(11) NOT NULL default '0' |
|
| 442 |
+) REPLACE=MyISAM; |
|
| 443 |
+ |
|
| 444 |
+-- -------------------------------------------------------- |
|
| 445 |
+ |
|
| 446 |
+-- |
|
| 447 |
+-- Table structure for table `fanfiction_stories` |
|
| 448 |
+-- |
|
| 449 |
+ |
|
| 450 |
+CREATE TABLE `fanfiction_stories` ( |
|
| 451 |
+ `sid` int(11) NOT NULL auto_increment, |
|
| 452 |
+ `title` varchar(200) NOT NULL default '', |
|
| 453 |
+ `summary` text, |
|
| 454 |
+ `storynotes` text, |
|
| 455 |
+ `catid` varchar(100) NOT NULL default '0', |
|
| 456 |
+ `classes` varchar(200) default NULL, |
|
| 457 |
+ `charid` varchar(250) NOT NULL default '0', |
|
| 458 |
+ `rid` varchar(25) NOT NULL default '0', |
|
| 459 |
+ `date` datetime NOT NULL default '0000-00-00 00:00:00', |
|
| 460 |
+ `updated` datetime NOT NULL default '0000-00-00 00:00:00', |
|
| 461 |
+ `uid` int(11) NOT NULL default '0', |
|
| 462 |
+ `coauthors` varchar(200) default NULL, |
|
| 463 |
+ `featured` tinyint(4) NOT NULL default '0', |
|
| 464 |
+ `validated` tinyint(4) NOT NULL default '0', |
|
| 465 |
+ `completed` tinyint(4) NOT NULL default '0', |
|
| 466 |
+ `rr` tinyint(4) NOT NULL default '0', |
|
| 467 |
+ `wordcount` int(11) NOT NULL default '0', |
|
| 468 |
+ `rating` tinyint(4) NOT NULL default '0', |
|
| 469 |
+ `reviews` smallint(6) NOT NULL default '0', |
|
| 470 |
+ `count` int(11) NOT NULL default '0', |
|
| 471 |
+ `challenges` varchar(200) NOT NULL default '0', |
|
| 472 |
+ PRIMARY KEY (`sid`), |
|
| 473 |
+ KEY `title` (`title`), |
|
| 474 |
+ KEY `catid` (`catid`), |
|
| 475 |
+ KEY `charid` (`charid`), |
|
| 476 |
+ KEY `rid` (`rid`), |
|
| 477 |
+ KEY `uid` (`uid`), |
|
| 478 |
+ KEY `featured` (`featured`), |
|
| 479 |
+ KEY `completed` (`completed`), |
|
| 480 |
+ KEY `rr` (`rr`), |
|
| 481 |
+ KEY `challenges` (`challenges`), |
|
| 482 |
+ KEY `validateduid` (`validated`,`uid`), |
|
| 483 |
+ KEY `recent` (`updated`,`validated`) |
|
| 484 |
+) REPLACE=MyISAM; |
|
| 485 |
+ |
|
| 486 |
+-- -------------------------------------------------------- |
|
| 487 |
+ |
|
| 488 |
+-- |
|
| 489 |
+-- Table structure for table `fanfiction_settings` |
|
| 490 |
+-- |
|
| 491 |
+ |
|
| 492 |
+CREATE TABLE `fanfiction_settings` ( |
|
| 493 |
+ `sitekey` varchar(50) NOT NULL default '1', |
|
| 494 |
+ `sitename` varchar(200) NOT NULL default 'Your Site', |
|
| 495 |
+ `slogan` varchar(200) NOT NULL default 'It''s a cool site!', |
|
| 496 |
+ `url` varchar(200) NOT NULL default 'http://www.yoursite.com', |
|
| 497 |
+ `siteemail` varchar(200) NOT NULL default 'you@yoursite.com', |
|
| 498 |
+ `tableprefix` varchar(50) NOT NULL default '', |
|
| 499 |
+ `skin` varchar(50) NOT NULL default 'default', |
|
| 500 |
+ `hiddenskins` varchar(255) default '', |
|
| 501 |
+ `language` varchar(10) NOT NULL default 'en', |
|
| 502 |
+ `submissionsoff` tinyint(1) NOT NULL default '0', |
|
| 503 |
+ `storiespath` varchar(20) NOT NULL default 'stories', |
|
| 504 |
+ `store` varchar(5) NOT NULL default 'files', |
|
| 505 |
+ `autovalidate` tinyint(1) NOT NULL default '0', |
|
| 506 |
+ `coauthallowed` int(1) NOT NULL default '0', |
|
| 507 |
+ `maxwords` int(11) NOT NULL default '0', |
|
| 508 |
+ `minwords` int(11) NOT NULL default '0', |
|
| 509 |
+ `imageupload` tinyint(1) NOT NULL default '0', |
|
| 510 |
+ `imageheight` int(11) NOT NULL default '200', |
|
| 511 |
+ `imagewidth` int(11) NOT NULL default '200', |
|
| 512 |
+ `roundrobins` tinyint(1) NOT NULL default '0', |
|
| 513 |
+ `allowseries` tinyint(4) NOT NULL default '2', |
|
| 514 |
+ `tinyMCE` tinyint(1) NOT NULL default '0', |
|
| 515 |
+ `allowed_tags` varchar(200) NOT NULL default '<b><i><u><center><hr><p><br /><br><blockquote><ol><ul><li><img><strong><em>', |
|
| 516 |
+ `favorites` tinyint(1) NOT NULL default '0', |
|
| 517 |
+ `multiplecats` tinyint(1) NOT NULL default '0', |
|
| 518 |
+ `newscomments` tinyint(1) NOT NULL default '0', |
|
| 519 |
+ `logging` tinyint(1) NOT NULL default '0', |
|
| 520 |
+ `maintenance` tinyint(1) NOT NULL default '0', |
|
| 521 |
+ `debug` tinyint(1) NOT NULL default '0', |
|
| 522 |
+ `captcha` tinyint(1) NOT NULL default '0', |
|
| 523 |
+ `dateformat` varchar(20) NOT NULL default 'd/m/y', |
|
| 524 |
+ `timeformat` varchar(20) NOT NULL default '- h:i a', |
|
| 525 |
+ `recentdays` tinyint(2) NOT NULL default '7', |
|
| 526 |
+ `displaycolumns` tinyint(1) NOT NULL default '1', |
|
| 527 |
+ `itemsperpage` tinyint(2) NOT NULL default '25', |
|
| 528 |
+ `extendcats` tinyint(1) NOT NULL default '0', |
|
| 529 |
+ `displayindex` tinyint(1) NOT NULL default '0', |
|
| 530 |
+ `defaultsort` tinyint(1) NOT NULL default '0', |
|
| 531 |
+ `displayprofile` tinyint(1) NOT NULL default '0', |
|
| 532 |
+ `linkstyle` tinyint(1) NOT NULL default '0', |
|
| 533 |
+ `linkrange` tinyint(2) NOT NULL default '5', |
|
| 534 |
+ `reviewsallowed` tinyint(1) NOT NULL default '0', |
|
| 535 |
+ `ratings` tinyint(1) NOT NULL default '0', |
|
| 536 |
+ `anonreviews` tinyint(1) NOT NULL default '0', |
|
| 537 |
+ `revdelete` tinyint(1) NOT NULL default '0', |
|
| 538 |
+ `rateonly` tinyint(1) NOT NULL default '0', |
|
| 539 |
+ `pwdsetting` tinyint(1) NOT NULL default '0', |
|
| 540 |
+ `alertson` tinyint(1) NOT NULL default '0', |
|
| 541 |
+ `disablepopups` tinyint(1) NOT NULL default '0', |
|
| 542 |
+ `agestatement` tinyint(1) NOT NULL default '0', |
|
| 543 |
+ `words` text, |
|
| 544 |
+ `version` varchar(10) NOT NULL default '3.0', |
|
| 545 |
+ `smtp_host` varchar(200) default NULL, |
|
| 546 |
+ `smtp_username` varchar(50) default NULL, |
|
| 547 |
+ `smtp_password` varchar(50) default NULL, |
|
| 548 |
+ `anonchallenges` tinyint(1) NOT NULL default '0', |
|
| 549 |
+ `anonrecs` tinyint(1) NOT NULL default '0', |
|
| 550 |
+ `rectarget` tinyint(1) NOT NULL default '0', |
|
| 551 |
+ `autovalrecs` tinyint(1) NOT NULL default '0', |
|
| 552 |
+ PRIMARY KEY (`sitekey`) |
|
| 553 |
+) REPLACE=MyISAM; |
|
| 0 | 554 |
\ No newline at end of file |