Project

General

Profile

« Previous | Next » 

Revision 1538

Added by Dietmar almost 13 years ago

! add table db engine in module install scripts
! some small updates in modules

View differences:

install.php
4 4
 * @category        modules
5 5
 * @package         news
6 6
 * @author          WebsiteBaker Project
7
 * @copyright       2004-2009, Ryan Djurovich
8 7
 * @copyright       2009-2011, Website Baker Org. e.V.
9 8
 * @link			http://www.websitebaker2.org/
10 9
 * @license         http://www.gnu.org/licenses/gpl.html
......
39 38
					 . '`posted_when` INT NOT NULL DEFAULT \'0\','
40 39
					 . '`posted_by` INT NOT NULL DEFAULT \'0\','
41 40
					 . 'PRIMARY KEY (post_id)'
42
					 . ' )';
41
					 . ' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci';
43 42
	$database->query($mod_news);
44 43
	
45 44
	// $database->query("DROP TABLE IF EXISTS `".TABLE_PREFIX."mod_news_groups`");
......
51 50
					 . '`position` INT NOT NULL DEFAULT \'0\','
52 51
					 . '`title` VARCHAR(255) NOT NULL DEFAULT \'\','
53 52
					 . 'PRIMARY KEY (group_id)'
54
                . ' )';
53
                . ' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci';
55 54
	$database->query($mod_news);
56 55
	
57 56
	// $database->query("DROP TABLE IF EXISTS `".TABLE_PREFIX."mod_news_comments`");
......
65 64
					 . '`commented_when` INT NOT NULL DEFAULT \'0\','
66 65
					 . '`commented_by` INT NOT NULL DEFAULT \'0\','
67 66
					 . 'PRIMARY KEY (comment_id)'
68
                . ' )';
67
                . ' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci';
69 68

  
70 69
	$database->query($mod_news);
71 70
	
......
87 86
					 . '`resize` INT NOT NULL DEFAULT \'0\','
88 87
					 . ' `use_captcha` INT NOT NULL DEFAULT \'0\','
89 88
					 . 'PRIMARY KEY (section_id)'
90
                . ' )';
89
                . ' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci';
91 90

  
92 91
	$database->query($mod_news);
93 92
		

Also available in: Unified diff