root/ip/tags/release_1_3_0_53/install/schemas/sql_update_ip.php

Show revision log
 
111163
53
	case '122451': $current_ip_version = '1.2.24.51'; break;
53
	case '122451': $current_ip_version = '1.2.24.51'; break;
54
	case '122552': $current_ip_version = '1.2.25.52'; break;
54
	case '122552': $current_ip_version = '1.2.25.52'; break;
55
	case '13053': $current_ip_version = '1.3.0.53'; break;
55
	case '13053': $current_ip_version = '1.3.0.53'; break;
 
56
	case '13053a': $current_ip_version = '1.3.0.53a'; break;



57
	case '13154': $current_ip_version = '1.3.1.54'; break;



56
}
58
}



57
59



58
// Icy Phoenix Part...
60
// Icy Phoenix Part...


...
...
83
			`pic_filename` varchar(255) NOT NULL default '',
85
			`pic_filename` varchar(255) NOT NULL default '',



84
			`pic_thumbnail` varchar(255) NULL default '',
86
			`pic_thumbnail` varchar(255) NULL default '',



85
			`pic_title` varchar(255) NOT NULL default '',
87
			`pic_title` varchar(255) NOT NULL default '',



86
			`pic_desc` text,
88
			`pic_desc` TEXT NOT NULL,



87
			`pic_user_id` mediumint(8) NOT NULL default '0',
89
			`pic_user_id` mediumint(8) NOT NULL default '0',



88
			`pic_username` varchar(32) NULL default '',
90
			`pic_username` varchar(32) NULL default '',



89
			`pic_user_ip` varchar(8) NOT NULL default '0',
91
			`pic_user_ip` varchar(8) NOT NULL default '0',


...
...
101
		$sql[] = "CREATE TABLE `" . $table_prefix . "album_cat` (
103
		$sql[] = "CREATE TABLE `" . $table_prefix . "album_cat` (



102
			`cat_id` mediumint(8) unsigned NOT NULL auto_increment,
104
			`cat_id` mediumint(8) unsigned NOT NULL auto_increment,



103
			`cat_title` varchar(255) NOT NULL default '',
105
			`cat_title` varchar(255) NOT NULL default '',



104
			`cat_desc` text,
106
			`cat_desc` TEXT NOT NULL,



105
			`cat_order` mediumint(8) NOT NULL default '0',
107
			`cat_order` mediumint(8) NOT NULL default '0',



106
			`cat_view_level` tinyint(3) NOT NULL default '-1',
108
			`cat_view_level` tinyint(3) NOT NULL default '-1',



107
			`cat_upload_level` tinyint(3) NOT NULL default '0',
109
			`cat_upload_level` tinyint(3) NOT NULL default '0',


...
...
137
			`comment_username` varchar(32) default '',
139
			`comment_username` varchar(32) default '',



138
			`comment_user_ip` varchar(8) NOT NULL default '',
140
			`comment_user_ip` varchar(8) NOT NULL default '',



139
			`comment_time` int(11) unsigned NOT NULL default '0',
141
			`comment_time` int(11) unsigned NOT NULL default '0',



140
			`comment_text` text,
142
			`comment_text` TEXT NOT NULL,



141
			`comment_edit_time` int(11) unsigned default NULL,
143
			`comment_edit_time` int(11) unsigned default NULL,



142
			`comment_edit_count` smallint(5) unsigned NOT NULL default '0',
144
			`comment_edit_count` smallint(5) unsigned NOT NULL default '0',



143
			`comment_edit_user_id` mediumint(8) default NULL,
145
			`comment_edit_user_id` mediumint(8) default NULL,


...
...
342
			`hack_desc` varchar(255) NOT NULL default '',
344
			`hack_desc` varchar(255) NOT NULL default '',



343
			`hack_author` varchar(255) NOT NULL default '',
345
			`hack_author` varchar(255) NOT NULL default '',



344
			`hack_author_email` varchar(255) NOT NULL default '',
346
			`hack_author_email` varchar(255) NOT NULL default '',



345
			`hack_author_website` tinytext NOT NULL,
347
			`hack_author_website` TINYTEXT NOT NULL,



346
			`hack_version` varchar(32) NOT NULL default '',
348
			`hack_version` varchar(32) NOT NULL default '',



347
			`hack_hide` enum('Yes','No') NOT NULL default 'No',
349
			`hack_hide` enum('Yes','No') NOT NULL default 'No',



348
			`hack_download_url` tinytext NOT NULL,
350
			`hack_download_url` TINYTEXT NOT NULL,



349
			`hack_file` varchar(255) NOT NULL default '',
351
			`hack_file` varchar(255) NOT NULL default '',



350
			`hack_file_mtime` int(10) unsigned NOT NULL default '0',
352
			`hack_file_mtime` int(10) unsigned NOT NULL default '0',



351
			PRIMARY KEY (`hack_id`),
353
			PRIMARY KEY (`hack_id`),


...
...
356
358



357
		$sql[] = "CREATE TABLE `" . $table_prefix . "jr_admin_users` (
359
		$sql[] = "CREATE TABLE `" . $table_prefix . "jr_admin_users` (



358
			`user_id` mediumint(9) NOT NULL default '0',
360
			`user_id` mediumint(9) NOT NULL default '0',



359
			`user_jr_admin` longtext NOT NULL,
361
			`user_jr_admin` LONGTEXT NOT NULL,



360
			`start_date` int(10) unsigned NOT NULL default '0',
362
			`start_date` int(10) unsigned NOT NULL default '0',



361
			`update_date` int(10) unsigned NOT NULL default '0',
363
			`update_date` int(10) unsigned NOT NULL default '0',



362
			`admin_notes` text NOT NULL,
364
			`admin_notes` text NOT NULL,


...
...
561
563



562
		$sql[] = "CREATE TABLE `" . $table_prefix . "pa_cat` (
564
		$sql[] = "CREATE TABLE `" . $table_prefix . "pa_cat` (



563
			`cat_id` int(10) NOT NULL auto_increment,
565
			`cat_id` int(10) NOT NULL auto_increment,



564
			`cat_name` text,
566
			`cat_name` TEXT NOT NULL,



565
			`cat_desc` text,
567
			`cat_desc` TEXT NOT NULL,



566
			`cat_parent` int(50) default NULL,
568
			`cat_parent` int(50) default NULL,



567
			`parents_data` text NOT NULL,
569
			`parents_data` text NOT NULL,



568
			`cat_order` int(50) default NULL,
570
			`cat_order` int(50) default NULL,


...
...
635
			`file_id` int(10) NOT NULL auto_increment,
637
			`file_id` int(10) NOT NULL auto_increment,



636
			`user_id` mediumint(8) NOT NULL default '0',
638
			`user_id` mediumint(8) NOT NULL default '0',



637
			`poster_ip` varchar(8) NOT NULL default '',
639
			`poster_ip` varchar(8) NOT NULL default '',



638
			`file_name` text,
640
			`file_name` TEXT NOT NULL,



639
			`file_size` int(20) NOT NULL default '0',
641
			`file_size` int(20) NOT NULL default '0',



640
			`unique_name` varchar(255) NOT NULL default '',
642
			`unique_name` varchar(255) NOT NULL default '',



641
			`real_name` varchar(255) NOT NULL default '',
643
			`real_name` varchar(255) NOT NULL default '',



642
			`file_dir` varchar(255) NOT NULL default '',
644
			`file_dir` varchar(255) NOT NULL default '',



643
			`file_desc` text,
645
			`file_desc` TEXT NOT NULL,



644
			`file_creator` text,
646
			`file_creator` TEXT NOT NULL,



645
			`file_version` text,
647
			`file_version` TEXT NOT NULL,



646
			`file_longdesc` text,
648
			`file_longdesc` TEXT NOT NULL,



647
			`file_ssurl` text,
649
			`file_ssurl` TEXT NOT NULL,



648
			`file_sshot_link` tinyint(2) NOT NULL default '0',
650
			`file_sshot_link` tinyint(2) NOT NULL default '0',



649
			`file_dlurl` text,
651
			`file_dlurl` TEXT NOT NULL,



650
			`file_time` int(50) default NULL,
652
			`file_time` int(50) default NULL,



651
			`file_update_time` int(50) NOT NULL default '0',
653
			`file_update_time` int(50) NOT NULL default '0',



652
			`file_catid` int(10) default NULL,
654
			`file_catid` int(10) default NULL,



653
			`file_posticon` text,
655
			`file_posticon` TEXT NOT NULL,



654
			`file_license` int(10) default NULL,
656
			`file_license` int(10) default NULL,



655
			`file_dls` int(10) default NULL,
657
			`file_dls` int(10) default NULL,



656
			`file_last` int(50) default NULL,
658
			`file_last` int(50) default NULL,



657
			`file_pin` int(2) default NULL,
659
			`file_pin` int(2) default NULL,



658
			`file_docsurl` text,
660
			`file_docsurl` TEXT NOT NULL,



659
			`file_approved` tinyint(1) NOT NULL default '1',
661
			`file_approved` tinyint(1) NOT NULL default '1',



660
			`file_broken` tinyint(1) NOT NULL default '0',
662
			`file_broken` tinyint(1) NOT NULL default '0',



661
			PRIMARY KEY (`file_id`)
663
			PRIMARY KEY (`file_id`)


...
...
663
665



664
		$sql[] = "CREATE TABLE `" . $table_prefix . "pa_license` (
666
		$sql[] = "CREATE TABLE `" . $table_prefix . "pa_license` (



665
			`license_id` int(10) NOT NULL auto_increment,
667
			`license_id` int(10) NOT NULL auto_increment,



666
			`license_name` text,
668
			`license_name` TEXT NOT NULL,



667
			`license_text` text,
669
			`license_text` TEXT NOT NULL,



668
			PRIMARY KEY (`license_id`)
670
			PRIMARY KEY (`license_id`)



669
		)";
671
		)";



670
672


...
...
2003
2005



2004
		// Create File Check Table
2006
		// Create File Check Table



2005
		$sql[] = "CREATE TABLE `" . $table_prefix . "ctracker_filechk` (
2007
		$sql[] = "CREATE TABLE `" . $table_prefix . "ctracker_filechk` (



2006
				`filepath` text,
2008
				`filepath` TEXT NOT NULL,



2007
				`hash` varchar(32) default NULL
2009
				`hash` varchar(32) default NULL



2008
				);";
2010
				);";



2009
2011



2010
		// Create File Scanner Table
2012
		// Create File Scanner Table



2011
		$sql[] = "CREATE TABLE `" . $table_prefix . "ctracker_filescanner` (
2013
		$sql[] = "CREATE TABLE `" . $table_prefix . "ctracker_filescanner` (



2012
				`id` smallint(5) NOT NULL,
2014
				`id` smallint(5) NOT NULL,



2013
				`filepath` text,
2015
				`filepath` TEXT NOT NULL,



2014
				`safety` smallint(1) NOT NULL default '0',
2016
				`safety` smallint(1) NOT NULL default '0',



2015
				PRIMARY KEY (`id`)
2017
				PRIMARY KEY (`id`)



2016
				);";
2018
				);";


...
...
2160
			`background` tinyint(1) NOT NULL default '1',
2162
			`background` tinyint(1) NOT NULL default '1',



2161
			`local` tinyint(1) NOT NULL default '0',
2163
			`local` tinyint(1) NOT NULL default '0',



2162
			`edit_auth` tinyint(1) NOT NULL default '5',
2164
			`edit_auth` tinyint(1) NOT NULL default '5',



2163
			`groups` tinytext NOT NULL,
2165
			`groups` TINYTEXT NOT NULL,



2164
			PRIMARY KEY (`bid`)
2166
			PRIMARY KEY (`bid`)



2165
		)";
2167
		)";



2166
2168


...
...
2180
			`global_blocks` tinyint(1) NOT NULL default '0',
2182
			`global_blocks` tinyint(1) NOT NULL default '0',



2181
			`view` tinyint(1) NOT NULL default '0',
2183
			`view` tinyint(1) NOT NULL default '0',



2182
			`edit_auth` tinyint(1) NOT NULL default '5',
2184
			`edit_auth` tinyint(1) NOT NULL default '5',



2183
			`groups` tinytext NOT NULL,
2185
			`groups` TINYTEXT NOT NULL,



2184
			PRIMARY KEY (`lid`)
2186
			PRIMARY KEY (`lid`)



2185
		)";
2187
		)";



2186
2188


...
...
2344
			`menu_icon` varchar(255) default NULL,
2346
			`menu_icon` varchar(255) default NULL,



2345
			`menu_name_lang` varchar(150) default NULL,
2347
			`menu_name_lang` varchar(150) default NULL,



2346
			`menu_name` varchar(150) default NULL,
2348
			`menu_name` varchar(150) default NULL,



2347
			`menu_desc` text,
2349
			`menu_desc` TEXT NOT NULL,



2348
			`menu_link` varchar(255) default NULL,
2350
			`menu_link` varchar(255) default NULL,



2349
			`menu_link_external` tinyint(1) NOT NULL default '0',
2351
			`menu_link_external` tinyint(1) NOT NULL default '0',



2350
			`auth_view` tinyint(2) NOT NULL default '0',
2352
			`auth_view` tinyint(2) NOT NULL default '0',


...
...
2554
			`global_blocks` tinyint(1) NOT NULL default '0',
2556
			`global_blocks` tinyint(1) NOT NULL default '0',



2555
			`view` tinyint(1) NOT NULL default '0',
2557
			`view` tinyint(1) NOT NULL default '0',



2556
			`edit_auth` tinyint(1) NOT NULL default '5',
2558
			`edit_auth` tinyint(1) NOT NULL default '5',



2557
			`groups` tinytext NOT NULL,
2559
			`groups` TINYTEXT NOT NULL,



2558
			PRIMARY KEY (`lsid`),
2560
			PRIMARY KEY (`lsid`),



2559
			UNIQUE KEY `page_id` (`page_id`)
2561
			UNIQUE KEY `page_id` (`page_id`)



2560
		)";
2562
		)";


...
...
2598
			`forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
2600
			`forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,



2599
			`save_time` int(11) UNSIGNED DEFAULT '0' NOT NULL,
2601
			`save_time` int(11) UNSIGNED DEFAULT '0' NOT NULL,



2600
			`draft_subject` varchar(100) DEFAULT '' NOT NULL,
2602
			`draft_subject` varchar(100) DEFAULT '' NOT NULL,



2601
			`draft_message` text,
2603
			`draft_message` TEXT NOT NULL,



2602
			PRIMARY KEY (`draft_id`),
2604
			PRIMARY KEY (`draft_id`),



2603
			KEY `save_time` (`save_time`)
2605
			KEY `save_time` (`save_time`)



2604
		)";
2606
		)";


...
...
2619
			klicks INT(11) DEFAULT '0',
2621
			klicks INT(11) DEFAULT '0',



2620
			free TINYINT(1) DEFAULT '0',
2622
			free TINYINT(1) DEFAULT '0',



2621
			extern TINYINT(1) DEFAULT '0',
2623
			extern TINYINT(1) DEFAULT '0',



2622
			long_desc TEXT DEFAULT '',
2624
			long_desc TEXT NOT NULL,



2623
			sort INT(11) DEFAULT '0',
2625
			sort INT(11) DEFAULT '0',



2624
			cat INT(11) DEFAULT '0',
2626
			cat INT(11) DEFAULT '0',



2625
			hacklist TINYINT(1) DEFAULT '0',
2627
			hacklist TINYINT(1) DEFAULT '0',



2626
			hack_author VARCHAR(255) DEFAULT '',
2628
			hack_author VARCHAR(255) DEFAULT '',



2627
			hack_author_email VARCHAR(255) DEFAULT '',
2629
			hack_author_email VARCHAR(255) DEFAULT '',



2628
			hack_author_website TINYTEXT DEFAULT '',
2630
			hack_author_website TINYTEXT,



2629
			hack_version VARCHAR(32) DEFAULT '',
2631
			hack_version VARCHAR(32) DEFAULT '',



2630
			hack_dl_url TINYTEXT DEFAULT '',
2632
			hack_dl_url TINYTEXT,



2631
			test varchar(50) DEFAULT '',
2633
			test varchar(50) DEFAULT '',



2632
			req TEXT DEFAULT '',
2634
			req TEXT NOT NULL,



2633
			todo TEXT DEFAULT '',
2635
			todo TEXT NOT NULL,



2634
			warning TEXT DEFAULT '',
2636
			warning TEXT NOT NULL,



2635
			mod_desc TEXT DEFAULT '',
2637
			mod_desc TEXT NOT NULL,



2636
			mod_list TINYINT(1) DEFAULT '0',
2638
			mod_list TINYINT(1) DEFAULT '0',



2637
			file_size BIGINT(20) NOT NULL DEFAULT '0',
2639
			file_size BIGINT(20) NOT NULL DEFAULT '0',



2638
			change_time INT(11) DEFAULT '0',
2640
			change_time INT(11) DEFAULT '0',


...
...
2656
			path VARCHAR(255) DEFAULT '',
2658
			path VARCHAR(255) DEFAULT '',



2657
			cat_name VARCHAR(255) DEFAULT '',
2659
			cat_name VARCHAR(255) DEFAULT '',



2658
			sort INT(11) DEFAULT '0',
2660
			sort INT(11) DEFAULT '0',



2659
			description TEXT DEFAULT '',
2661
			description TEXT NOT NULL,



2660
			rules TEXT DEFAULT '',
2662
			rules TEXT NOT NULL,



2661
			auth_view TINYINT(1) NOT NULL DEFAULT '1',
2663
			auth_view TINYINT(1) NOT NULL DEFAULT '1',



2662
			auth_dl TINYINT(1) NOT NULL DEFAULT '1',
2664
			auth_dl TINYINT(1) NOT NULL DEFAULT '1',



2663
			auth_up TINYINT(1) NOT NULL DEFAULT '0',
2665
			auth_up TINYINT(1) NOT NULL DEFAULT '0',


...
...
2700
			report_id INT(11) AUTO_INCREMENT NOT NULL,
2702
			report_id INT(11) AUTO_INCREMENT NOT NULL,



2701
			df_id INT(11) NOT NULL DEFAULT '0',
2703
			df_id INT(11) NOT NULL DEFAULT '0',



2702
			report_title VARCHAR(255) DEFAULT '',
2704
			report_title VARCHAR(255) DEFAULT '',



2703
			report_text TEXT,
2705
			report_text TEXT NOT NULL,



2704
			report_file_ver VARCHAR(50) DEFAULT '',
2706
			report_file_ver VARCHAR(50) DEFAULT '',



2705
			report_date INT(11) DEFAULT '0',
2707
			report_date INT(11) DEFAULT '0',



2706
			report_author_id MEDIUMINT(8) DEFAULT 0 NOT NULL,
2708
			report_author_id MEDIUMINT(8) DEFAULT 0 NOT NULL,


...
...
2732
			username VARCHAR(32) NOT NULL DEFAULT '',
2734
			username VARCHAR(32) NOT NULL DEFAULT '',



2733
			comment_time INT(11) NOT NULL DEFAULT '0',
2735
			comment_time INT(11) NOT NULL DEFAULT '0',



2734
			comment_edit_time INT(11) NOT NULL DEFAULT '0',
2736
			comment_edit_time INT(11) NOT NULL DEFAULT '0',



2735
			comment_text TEXT NOT NULL DEFAULT '',
2737
			comment_text TEXT NOT NULL,



2736
			approve TINYINT(1) NOT NULL DEFAULT '0',
2738
			approve TINYINT(1) NOT NULL DEFAULT '0',



2737
		PRIMARY KEY (dl_id)
2739
		PRIMARY KEY (dl_id)



2738
		)";
2740
		)";


...
...
2897
		/* Updating from IP 1.1.10.25 */
2899
		/* Updating from IP 1.1.10.25 */



2898
		case '1.1.10.25':
2900
		case '1.1.10.25':



2899
		$sql[] = "ALTER TABLE `" . $table_prefix . "groups` ADD COLUMN group_legend_order MEDIUMINT(8) DEFAULT '0' NOT NULL AFTER `group_legend`";
2901
		$sql[] = "ALTER TABLE `" . $table_prefix . "groups` ADD COLUMN group_legend_order MEDIUMINT(8) DEFAULT '0' NOT NULL AFTER `group_legend`";



2900
		//$sql[] = "ALTER TABLE `" . $table_prefix . "posts` CHANGE `post_edit_count` `post_edit_count` TINYTEXT DEFAULT ''";
2902
		//$sql[] = "ALTER TABLE `" . $table_prefix . "posts` CHANGE `post_edit_count` `post_edit_count` TINYTEXT";



2901
		$sql[] = "ALTER TABLE `" . $table_prefix . "posts` ADD COLUMN `post_edit_id` MEDIUMINT(8) DEFAULT '0' NOT NULL AFTER `post_edit_count`";
2903
		$sql[] = "ALTER TABLE `" . $table_prefix . "posts` ADD COLUMN `post_edit_id` MEDIUMINT(8) DEFAULT '0' NOT NULL AFTER `post_edit_count`";



2902
2904



2903
		/* Updating from IP 1.2.0.27 */
2905
		/* Updating from IP 1.2.0.27 */


...
...
2934
		$sql[] = "INSERT INTO `" . $table_prefix . "config` (config_name, config_value) VALUES ('link_this_topic', '0')";
2936
		$sql[] = "INSERT INTO `" . $table_prefix . "config` (config_name, config_value) VALUES ('link_this_topic', '0')";



2935
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'";
2937
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'";



2936
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout` ADD `page_nav` TINYINT(1) NOT NULL DEFAULT '1' AFTER `global_blocks`";
2938
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout` ADD `page_nav` TINYINT(1) NOT NULL DEFAULT '1' AFTER `global_blocks`";



2937
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout` ADD `config_vars` TEXT NOT NULL DEFAULT '' AFTER `page_nav`";
2939
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout` ADD `config_vars` TEXT AFTER `page_nav`";



2938
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout_special` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'";
2940
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout_special` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'";



2939
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout_special` ADD `page_nav` TINYINT(1) NOT NULL DEFAULT '1' AFTER `global_blocks`";
2941
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout_special` ADD `page_nav` TINYINT(1) NOT NULL DEFAULT '1' AFTER `global_blocks`";



2940
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout_special` ADD `config_vars` TEXT NOT NULL DEFAULT '' AFTER `page_nav`";
2942
		$sql[] = "ALTER TABLE `" . $table_prefix . "cms_layout_special` ADD `config_vars` TEXT AFTER `page_nav`";



2941
		$sql[] = "INSERT INTO `" . $table_prefix . "config` (config_name, config_value) VALUES ('link_this_topic', '0')";
2943
		$sql[] = "INSERT INTO `" . $table_prefix . "config` (config_name, config_value) VALUES ('link_this_topic', '0')";



2942
		$sql[] = "INSERT INTO `" . $table_prefix . "cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('ghtop', 'gt', 0)";
2944
		$sql[] = "INSERT INTO `" . $table_prefix . "cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('ghtop', 'gt', 0)";



2943
		$sql[] = "INSERT INTO `" . $table_prefix . "cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('ghbottom', 'gb', 0)";
2945
		$sql[] = "INSERT INTO `" . $table_prefix . "cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('ghbottom', 'gb', 0)";


...
...
3162
				`poster_ip` varchar(8) NOT NULL default '',
3164
				`poster_ip` varchar(8) NOT NULL default '',



3163
				`post_username` varchar(25) default NULL,
3165
				`post_username` varchar(25) default NULL,



3164
				`post_subject` varchar(255) default NULL,
3166
				`post_subject` varchar(255) default NULL,



3165
				`post_text` text,
3167
				`post_text` TEXT NOT NULL,



3166
				`post_text_compiled` text,
3168
				`post_text_compiled` TEXT NOT NULL,



3167
				`enable_bbcode` tinyint(1) NOT NULL default '1',
3169
				`enable_bbcode` tinyint(1) NOT NULL default '1',



3168
				`enable_html` tinyint(1) NOT NULL default '0',
3170
				`enable_html` tinyint(1) NOT NULL default '0',



3169
				`enable_smilies` tinyint(1) NOT NULL default '1',
3171
				`enable_smilies` tinyint(1) NOT NULL default '1',



3170
				`enable_sig` tinyint(1) NOT NULL default '1',
3172
				`enable_sig` tinyint(1) NOT NULL default '1',



3171
				`edit_notes` mediumtext,
3173
				`edit_notes` MEDIUMTEXT,



3172
				`post_edit_time` int(11) default NULL,
3174
				`post_edit_time` int(11) default NULL,



3173
				`post_edit_count` smallint(5) unsigned NOT NULL default '0',
3175
				`post_edit_count` smallint(5) unsigned NOT NULL default '0',



3174
				`post_edit_id` mediumint(8) NOT NULL default '0',
3176
				`post_edit_id` mediumint(8) NOT NULL default '0',


...
...
3201
				`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
3203
				`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,



3202
				`privmsgs_type` tinyint(4) NOT NULL default '0',
3204
				`privmsgs_type` tinyint(4) NOT NULL default '0',



3203
				`privmsgs_subject` varchar(255) NOT NULL default '',
3205
				`privmsgs_subject` varchar(255) NOT NULL default '',



3204
				`privmsgs_text` text,
3206
				`privmsgs_text` TEXT NOT NULL,



3205
				`privmsgs_from_userid` mediumint(8) NOT NULL default '0',
3207
				`privmsgs_from_userid` mediumint(8) NOT NULL default '0',



3206
				`privmsgs_to_userid` mediumint(8) NOT NULL default '0',
3208
				`privmsgs_to_userid` mediumint(8) NOT NULL default '0',



3207
				`privmsgs_date` int(11) NOT NULL default '0',
3209
				`privmsgs_date` int(11) NOT NULL default '0',


...
...
3241
				`cat_id` mediumint(8) unsigned NOT NULL default '0',
3243
				`cat_id` mediumint(8) unsigned NOT NULL default '0',



3242
				`main_type` char(1) default NULL,
3244
				`main_type` char(1) default NULL,



3243
				`forum_name` varchar(150) default NULL,
3245
				`forum_name` varchar(150) default NULL,



3244
				`forum_desc` text,
3246
				`forum_desc` TEXT NOT NULL,



3245
				`forum_status` tinyint(4) NOT NULL default '0',
3247
				`forum_status` tinyint(4) NOT NULL default '0',



3246
				`forum_order` mediumint(8) unsigned NOT NULL default '1',
3248
				`forum_order` mediumint(8) unsigned NOT NULL default '1',



3247
				`forum_posts` mediumint(8) unsigned NOT NULL default '0',
3249
				`forum_posts` mediumint(8) unsigned NOT NULL default '0',


...
...
3325
			`cat_main` mediumint(8) unsigned NOT NULL default '0',
3327
			`cat_main` mediumint(8) unsigned NOT NULL default '0',



3326
			`cat_main_type` char(1) default NULL,
3328
			`cat_main_type` char(1) default NULL,



3327
			`cat_title` varchar(100) default NULL,
3329
			`cat_title` varchar(100) default NULL,



3328
			`cat_desc` text,
3330
			`cat_desc` TEXT NOT NULL,



3329
			`icon` varchar(255) default NULL,
3331
			`icon` varchar(255) default NULL,



3330
			`cat_order` mediumint(8) unsigned NOT NULL default '0',
3332
			`cat_order` mediumint(8) unsigned NOT NULL default '0',



3331
			PRIMARY KEY (`cat_id`),
3333
			PRIMARY KEY (`cat_id`),


...
...
3393
				`user_id` mediumint(8) NOT NULL,
3395
				`user_id` mediumint(8) NOT NULL,



3394
				`group_id` mediumint(8) NOT NULL,
3396
				`group_id` mediumint(8) NOT NULL,



3395
				`email_subject` varchar(255) NOT NULL,
3397
				`email_subject` varchar(255) NOT NULL,



3396
				`email_body` text,
3398
				`email_body` TEXT NOT NULL,



3397
				`email_format` tinyint(1) NOT NULL default '0',
3399
				`email_format` tinyint(1) NOT NULL default '0',



3398
				`batch_start` mediumint(8) NOT NULL,
3400
				`batch_start` mediumint(8) NOT NULL,



3399
				`batch_size` smallint UNSIGNED NOT NULL,
3401
				`batch_size` smallint UNSIGNED NOT NULL,


...
...
3441
		$sql[] = "CREATE TABLE `" . $table_prefix . "ads` (
3443
		$sql[] = "CREATE TABLE `" . $table_prefix . "ads` (



3442
			`ad_id` mediumint(8) unsigned NOT NULL auto_increment,
3444
			`ad_id` mediumint(8) unsigned NOT NULL auto_increment,



3443
			`ad_title` varchar(255) NOT NULL,
3445
			`ad_title` varchar(255) NOT NULL,



3444
			`ad_text` text,
3446
			`ad_text` TEXT NOT NULL,



3445
			`ad_position` varchar(255) NOT NULL,
3447
			`ad_position` varchar(255) NOT NULL,



3446
			`ad_auth` tinyint(1) NOT NULL default '0',
3448
			`ad_auth` tinyint(1) NOT NULL default '0',



3447
			`ad_format` tinyint(1) NOT NULL default '0',
3449
			`ad_format` tinyint(1) NOT NULL default '0',


...
...
3565
3567



3566
		/* Updating from IP 1.3.0.53 */
3568
		/* Updating from IP 1.3.0.53 */



3567
		case '1.3.0.53':
3569
		case '1.3.0.53':



3570
		case '1.3.0.53a':



3571
		$sql[] = "INSERT INTO `" . $table_prefix . "cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('gheader', 'gh', 0)";



3572
		$sql[] = "INSERT INTO `" . $table_prefix . "cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('gfooter', 'gf', 0)";



3573



3574
		$sql[] = "CREATE TABLE `" . $table_prefix . "tickets_cat` (



3575
				ticket_cat_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,



3576
				ticket_cat_title VARCHAR(255) NOT NULL DEFAULT '',



3577
				ticket_cat_des TEXT NOT NULL,



3578
				ticket_cat_emails TEXT NOT NULL,



3579
				PRIMARY KEY (ticket_cat_id)



3580
			)";



3581
		$sql[] = "INSERT INTO `" . $table_prefix . "tickets_cat` (ticket_cat_title, ticket_cat_des) VALUES ('General', 'General')";



3582



3583
		$sql[] = "UPDATE `" . $table_prefix . "cms_layout_special` SET page_id = 'viewforum' WHERE page_id = 'viewfforum'";



3584



3585
		/* Updating from IP 1.3.1.54 */



3586
		case '1.3.1.54':



3568
	}
3587
	}



3569
3588



3570
	$sql[] = "INSERT INTO " . $table_prefix . "config VALUES ('ip_version', '" . $ip_version . "')";
3589
	$sql[] = "INSERT INTO " . $table_prefix . "config VALUES ('ip_version', '" . $ip_version . "')";