phpBB.de

Code: Alles auswählen

CREATE TABLE `phpbb3_profile_guestbook` (
	`gb_id` int(10) NOT NULL auto_increment,
	`user_id` int(10) NOT NULL default '0',
	`poster_id` int(10) NOT NULL default '0',
	`gb_time` int(10) NOT NULL default '0',
	`title` varchar(255) NOT NULL default '',
	`message` text NOT NULL,
	`bbcode_uid` varchar(8) collate utf8_bin NOT NULL,
	`bbcode_bitfield` varchar(5) collate utf8_bin NOT NULL,
	`user_guestbook_limit` VARCHAR(255) NULL,
	`user_guest_name` varchar(64) NOT NULL default '',
PRIMARY KEY  (`gb_id`));

Code: Alles auswählen

ALTER TABLE `phpbb3_users` ADD `user_guestbook_active` TINYINT( 1 ) DEFAULT '1' NOT NULL;

Code: Alles auswählen

ALTER TABLE `phpbb3_users` ADD `user_guestbook_active` TINYINT( 1 ) DEFAULT '1' NOT NULL;

Code: Alles auswählen

ALTER TABLE `phpbb3_users` ADD `user_guestbook_active` TINYINT( 1 ) DEFAULT '1' NOT NULL;

Code: Alles auswählen

ALTER TABLE `phpbb3_users` ADD `user_guestbook_active` TINYINT( 1 ) DEFAULT '1' NOT NULL;