Diff | Subversion & Trac

Download diff

 INSERT INTO `phpbb_ctracker_config` (`ct_config_name`, `ct_config_value`) VALUES ('footer_layout', '6');
 CREATE TABLE `phpbb_ctracker_filechk` (
-	`filepath` text,
+	`filepath` TEXT NOT NULL,
 	`hash` varchar(32) default NULL
 	);
 CREATE TABLE `phpbb_ctracker_filescanner` (
 	`id` smallint(5) NOT NULL,
-	`filepath` text,
+	`filepath` TEXT NOT NULL,
 	`safety` smallint(1) NOT NULL default '0',
 	PRIMARY KEY  (`id`)
 	);
   `background` tinyint(1) NOT NULL default '1',
   `local` tinyint(1) NOT NULL default '0',
   `edit_auth` tinyint(1) NOT NULL default '5',
-  `groups` tinytext NOT NULL,
+  `groups` TINYTEXT NOT NULL,
   PRIMARY KEY  (`bid`)
 );
   `global_blocks` tinyint(1) NOT NULL default '0',
   `view` tinyint(1) NOT NULL default '0',
   `edit_auth` tinyint(1) NOT NULL default '5',
-  `groups` tinytext NOT NULL,
+  `groups` TINYTEXT NOT NULL,
   PRIMARY KEY  (`lid`)
 );
 	`menu_icon` varchar(255) default NULL,
 	`menu_name_lang` varchar(150) default NULL,
 	`menu_name` varchar(150) default NULL,
-	`menu_desc` text,
+	`menu_desc` TEXT NOT NULL,
 	`menu_link` varchar(255) default NULL,
 	`menu_link_external` tinyint(1) NOT NULL default '0',
 	`auth_view` tinyint(2) NOT NULL default '0',
 	`template` varchar(100) NOT NULL DEFAULT '',
 	`global_blocks` tinyint(1) NOT NULL DEFAULT '0',
 	`page_nav` tinyint(1) NOT NULL DEFAULT '1',
-	`config_vars` text NOT NULL DEFAULT '',
+	`config_vars` TEXT NOT NULL,
 	`view` tinyint(1) NOT NULL DEFAULT '0',
 	`edit_auth` tinyint(1) NOT NULL DEFAULT '5',
-	`groups` tinytext NOT NULL,
+	`groups` TINYTEXT NOT NULL,
 	PRIMARY KEY (`lsid`),
 	UNIQUE KEY `page_id` (`page_id`)
 );
 	`forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	`save_time` int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	`draft_subject` varchar(100) DEFAULT '' NOT NULL,
-	`draft_message` text,
+	`draft_message` TEXT NOT NULL,
 	PRIMARY KEY (`draft_id`),
 	KEY `save_time` (`save_time`)
 );
 	klicks INT(11) DEFAULT '0',
 	free TINYINT(1) DEFAULT '0',
 	extern TINYINT(1) DEFAULT '0',
-	long_desc TEXT DEFAULT '',
+	long_desc TEXT NOT NULL,
 	sort INT(11) DEFAULT '0',
 	cat INT(11) DEFAULT '0',
 	hacklist TINYINT(1) DEFAULT '0',
 	hack_version VARCHAR(32) DEFAULT '',
 	hack_dl_url TINYTEXT DEFAULT '',
 	test varchar(50) DEFAULT '',
-	req TEXT DEFAULT '',
+	req TEXT NOT NULL,
-	todo TEXT DEFAULT '',
+	todo TEXT NOT NULL,
-	warning TEXT DEFAULT '',
+	warning TEXT NOT NULL,
-	mod_desc TEXT DEFAULT '',
+	mod_desc TEXT NOT NULL,
 	mod_list TINYINT(1) DEFAULT '0',
 	file_size BIGINT(20) NOT NULL DEFAULT '0',
 	change_time INT(11) DEFAULT '0',
 	path VARCHAR(255) DEFAULT '',
 	cat_name VARCHAR(255) DEFAULT '',
 	sort INT(11) DEFAULT '0',
-	description TEXT DEFAULT '',
+	description TEXT NOT NULL,
-	rules TEXT DEFAULT '',
+	rules TEXT NOT NULL,
 	auth_view TINYINT(1) NOT NULL DEFAULT '1',
 	auth_dl TINYINT(1) NOT NULL DEFAULT '1',
 	auth_up TINYINT(1) NOT NULL DEFAULT '0',
 	report_id INT(11) AUTO_INCREMENT NOT NULL,
 	df_id INT(11) NOT NULL DEFAULT '0',
 	report_title VARCHAR(255) DEFAULT '',
-	report_text TEXT,
+	report_text TEXT NOT NULL,
 	report_file_ver VARCHAR(50) DEFAULT '',
 	report_date INT(11) DEFAULT '0',
 	report_author_id MEDIUMINT(8) DEFAULT 0 NOT NULL,
 	username VARCHAR(32) NOT NULL DEFAULT '',
 	comment_time INT(11) NOT NULL DEFAULT '0',
 	comment_edit_time INT(11) NOT NULL DEFAULT '0',
-	comment_text TEXT NOT NULL DEFAULT '',
+	comment_text TEXT NOT NULL,
 	approve TINYINT(1) NOT NULL DEFAULT '0',
 PRIMARY KEY (dl_id)
 );
 INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('link_this_topic', '0');
 ALTER TABLE `phpbb_cms_layout` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0';
 ALTER TABLE `phpbb_cms_layout` ADD `page_nav` TINYINT(1) NOT NULL DEFAULT '1' AFTER `global_blocks`;
-ALTER TABLE `phpbb_cms_layout` ADD `config_vars` TEXT NOT NULL DEFAULT '' AFTER `page_nav`;
+ALTER TABLE `phpbb_cms_layout` ADD `config_vars` TEXT AFTER `page_nav`;
 ALTER TABLE `phpbb_cms_layout_special` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0';
 ALTER TABLE `phpbb_cms_layout_special` ADD `page_nav` TINYINT(1) NOT NULL DEFAULT '1' AFTER `global_blocks`;
-ALTER TABLE `phpbb_cms_layout_special` ADD `config_vars` TEXT NOT NULL DEFAULT '' AFTER `page_nav`;
+ALTER TABLE `phpbb_cms_layout_special` ADD `config_vars` TEXT AFTER `page_nav`;
 INSERT INTO `phpbb_cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('ghtop', 'gt', 0);
 INSERT INTO `phpbb_cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('ghbottom', 'gb', 0);
 INSERT INTO `phpbb_cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('ghleft', 'gl', 0);
 	`poster_ip` varchar(8) NOT NULL default '',
 	`post_username` varchar(25) default NULL,
 	`post_subject` varchar(255) default NULL,
-	`post_text` text,
+	`post_text` TEXT NOT NULL,
-	`post_text_compiled` text,
+	`post_text_compiled` TEXT NOT NULL,
 	`enable_bbcode` tinyint(1) NOT NULL default '1',
 	`enable_html` tinyint(1) NOT NULL default '0',
 	`enable_smilies` tinyint(1) NOT NULL default '1',
 	`enable_sig` tinyint(1) NOT NULL default '1',
-	`edit_notes` mediumtext,
+	`edit_notes` MEDIUMTEXT,
 	`post_edit_time` int(11) default NULL,
 	`post_edit_count` smallint(5) unsigned NOT NULL default '0',
 	`post_edit_id` mediumint(8) NOT NULL default '0',
 	`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
 	`privmsgs_type` tinyint(4) NOT NULL default '0',
 	`privmsgs_subject` varchar(255) NOT NULL default '',
-	`privmsgs_text` text,
+	`privmsgs_text` TEXT NOT NULL,
 	`privmsgs_from_userid` mediumint(8) NOT NULL default '0',
 	`privmsgs_to_userid` mediumint(8) NOT NULL default '0',
 	`privmsgs_date` int(11) NOT NULL default '0',
 	`cat_id` mediumint(8) unsigned NOT NULL default '0',
 	`main_type` char(1) default NULL,
 	`forum_name` varchar(150) default NULL,
-	`forum_desc` text,
+	`forum_desc` TEXT NOT NULL,
 	`forum_status` tinyint(4) NOT NULL default '0',
 	`forum_order` mediumint(8) unsigned NOT NULL default '1',
 	`forum_posts` mediumint(8) unsigned NOT NULL default '0',
 	`cat_main` mediumint(8) unsigned NOT NULL default '0',
 	`cat_main_type` char(1) default NULL,
 	`cat_title` varchar(100) default NULL,
-	`cat_desc` text,
+	`cat_desc` TEXT NOT NULL,
 	`icon` varchar(255) default NULL,
 	`cat_order` mediumint(8) unsigned NOT NULL default '0',
 	PRIMARY KEY (`cat_id`),
 	`user_id` mediumint(8) NOT NULL,
 	`group_id` mediumint(8) NOT NULL,
 	`email_subject` varchar(255) NOT NULL,
-	`email_body` text,
+	`email_body` TEXT NOT NULL,
 	`email_format` tinyint(1) NOT NULL default '0',
 	`batch_start` mediumint(8) NOT NULL,
 	`batch_size` smallint UNSIGNED NOT NULL,
 CREATE TABLE `phpbb_ads` (
 	`ad_id` mediumint(8) unsigned NOT NULL auto_increment,
 	`ad_title` varchar(255) NOT NULL,
-	`ad_text` text,
+	`ad_text` TEXT NOT NULL,
 	`ad_position` varchar(255) NOT NULL,
 	`ad_auth` tinyint(1) NOT NULL default '0',
 	`ad_format` tinyint(1) NOT NULL default '0',
+########################################
+##              BUILD 053             ##
+########################################
+########################################
+##              BUILD 053a            ##
+########################################
+## TICKETS - BEGIN
+CREATE TABLE phpbb_tickets_cat (
+	ticket_cat_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
+	ticket_cat_title VARCHAR(255) NOT NULL DEFAULT '',
+	ticket_cat_des TEXT NOT NULL,
+	ticket_cat_emails TEXT NOT NULL,
+	PRIMARY KEY (ticket_cat_id)
+);
+INSERT INTO phpbb_tickets_cat (ticket_cat_title, ticket_cat_des) VALUES ('General', 'General');
+## TICKETS - END
+UPDATE `phpbb_cms_layout_special` SET page_id = 'viewforum' WHERE page_id = 'viewfforum';
 #####################
 ##UPDATE phpbb_config SET config_value = '2' WHERE config_name = 'main_admin_id';
 UPDATE phpbb_config SET config_value = '3.0.7' WHERE config_name = 'upi2db_version';
 UPDATE phpbb_album_config SET config_value = '1.5.0' WHERE config_name = 'fap_version';
 UPDATE phpbb_config SET config_value = '.0.23' WHERE config_name = 'version';
-UPDATE phpbb_config SET config_value = '1.3.0.53' WHERE config_name = 'ip_version';
+UPDATE phpbb_config SET config_value = '1.3.0.53a' WHERE config_name = 'ip_version';

Icy Phoenix

root/ip/tags/release_1_3_0_53/install/schemas/db_update_000.sql