phpBB.de

Code: Alles auswählen

CREATE TABLE `phpbb_advanced_username_color` (
  `group_id` int(10) unsigned NOT NULL auto_increment,
  `group_name` varchar(255) NOT NULL default '',
  `group_color` varchar(6) NOT NULL default '',
  `group_weight` smallint(2) NOT NULL default '',
  PRIMARY KEY  (`group_id`)
) TYPE=MyISAM ;

ALTER TABLE phpbb_users ADD user_color_gc VARCHAR(6) DEFAULT '';
ALTER TABLE phpbb_users ADD user_color_gi TEXT DEFAULT NULL;

Code: Alles auswählen

DROP TABLE IF EXISTS `phpbb_advanced_username_color`;

ALTER TABLE phpbb_users DROP user_color_gc; 
ALTER TABLE phpbb_users DROP user_color_gi;