phpBB.de

Code: Alles auswählen

INSERT INTO `phpbb_config` VALUES ('allow_group_index', '0');

Code: Alles auswählen

DELETE FROM `phpbb_config` WHERE `config_name`  = 'allow_group_index' LIMIT 1;

Code: Alles auswählen

#-----[ SQL ]------------------------------------------
# 
CREATE TABLE `phpbb_whosonline_ranks` (
  `whosonline_rank_id` tinyint(4) NOT NULL auto_increment,
  `whosonline_rank_name` varchar(50) NOT NULL default '',
  `whosonline_rank_color` varchar(9) NOT NULL default '',
  `whosonline_lang_key` smallint(1) unsigned NOT NULL default '0',
  `whosonline_rank_order` int(11) NOT NULL default '0',
  PRIMARY KEY  (`whosonline_rank_id`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;

#
#-----[ SQL ]------------------------------------------
# 
INSERT INTO `phpbb_whosonline_ranks` VALUES (1, 'Test', 'red', 0, 10);

#
#-----[ SQL ]------------------------------------------
#

ALTER TABLE phpbb_users ADD user_whosonline_color int(11) DEFAULT '0' NOT NULL;

#
#-----[ SQL ]------------------------------------------
#

ALTER TABLE `phpbb_groups` ADD `group_color` smallint(8) DEFAULT '0' NOT NULL ;

#
#-----[ SQL ]------------------------------------------
#

INSERT INTO `phpbb_config` VALUES ('allow_group_index', '0');

Code: Alles auswählen

ALTER TABLE `phpbb_themes` ADD `highlight_topic_color` VARCHAR( 6 ) ;
ALTER TABLE `phpbb_themes_name` ADD `highlight_topic_color_name` CHAR( 50 )

Code: Alles auswählen

ALTER TABLE [...] DROP [...]