Browse code
Fix MySQL table creation, TYPE to ENGINE
Rainer Volkrodt authored on 2016/03/21 11:50:45
Showing 1 changed files
| ... | ... |
@@ -34,7 +34,7 @@ dbquery("CREATE TABLE IF NOT EXISTS `".TABLEPREFIX."fanfiction_poll_votes` (
|
| 34 | 34 |
`vote_poll` int(11) NOT NULL default '0', |
| 35 | 35 |
PRIMARY KEY (`vote_id`), |
| 36 | 36 |
KEY `vote_user` (`vote_user`,`vote_poll`) |
| 37 |
-) TYPE=MyISAM;") ; |
|
| 37 |
+) ENGINE=MyISAM;") ; |
|
| 38 | 38 |
dbquery("CREATE TABLE IF NOT EXISTS `".TABLEPREFIX."fanfiction_poll` (
|
| 39 | 39 |
`poll_id` INT NOT NULL AUTO_INCREMENT , |
| 40 | 40 |
`poll_question` VARCHAR( 250 ) NOT NULL , |
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,46 @@ |
| 1 |
+<?php |
|
| 2 |
+ |
|
| 3 |
+// ---------------------------------------------------------------------- |
|
| 4 |
+// eFiction 3.2 |
|
| 5 |
+// Copyright (c) 2007 by Tammy Keefer |
|
| 6 |
+// Valid HTML 4.01 Transitional |
|
| 7 |
+// Based on eFiction 1.1 |
|
| 8 |
+// Copyright (C) 2003 by Rebecca Smallwood. |
|
| 9 |
+// http://efiction.sourceforge.net/ |
|
| 10 |
+// ---------------------------------------------------------------------- |
|
| 11 |
+// LICENSE |
|
| 12 |
+// |
|
| 13 |
+// This program is free software; you can redistribute it and/or |
|
| 14 |
+// modify it under the terms of the GNU General Public License (GPL) |
|
| 15 |
+// as published by the Free Software Foundation; either version 2 |
|
| 16 |
+// of the License, or (at your option) any later version. |
|
| 17 |
+// |
|
| 18 |
+// This program is distributed in the hope that it will be useful, |
|
| 19 |
+// but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 20 |
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 21 |
+// GNU General Public License for more details. |
|
| 22 |
+// |
|
| 23 |
+// To read the license please visit http://www.gnu.org/copyleft/gpl.html |
|
| 24 |
+// ---------------------------------------------------------------------- |
|
| 25 |
+ |
|
| 26 |
+if(!defined("_CHARSET")) exit( );
|
|
| 27 |
+ |
|
| 28 |
+ |
|
| 29 |
+dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_blocks(`block_name`, `block_title`, `block_status`, `block_file`, `block_variables`) VALUES('poll', 'Poll', '0', 'poll/poll.php', '');");
|
|
| 30 |
+dbquery("CREATE TABLE IF NOT EXISTS `".TABLEPREFIX."fanfiction_poll_votes` (
|
|
| 31 |
+ `vote_id` int(11) NOT NULL auto_increment, |
|
| 32 |
+ `vote_user` int(11) NOT NULL default '0', |
|
| 33 |
+ `vote_opt` int(11) NOT NULL default '0', |
|
| 34 |
+ `vote_poll` int(11) NOT NULL default '0', |
|
| 35 |
+ PRIMARY KEY (`vote_id`), |
|
| 36 |
+ KEY `vote_user` (`vote_user`,`vote_poll`) |
|
| 37 |
+) TYPE=MyISAM;") ; |
|
| 38 |
+dbquery("CREATE TABLE IF NOT EXISTS `".TABLEPREFIX."fanfiction_poll` (
|
|
| 39 |
+`poll_id` INT NOT NULL AUTO_INCREMENT , |
|
| 40 |
+`poll_question` VARCHAR( 250 ) NOT NULL , |
|
| 41 |
+`poll_opts` TEXT NOT NULL , |
|
| 42 |
+`poll_start` DATETIME NOT NULL , |
|
| 43 |
+`poll_end` DATETIME NULL , |
|
| 44 |
+`poll_results` VARCHAR( 250 ) NULL , |
|
| 45 |
+PRIMARY KEY ( `poll_id` ))"); |
|
| 46 |
+?> |
|
| 0 | 47 |
\ No newline at end of file |