Board3

Code: Select all

CREATE TABLE `phpbb_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: Select all

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

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_guestbook_delete` TINYINT( 1 ) DEFAULT '1' NOT NULL;

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_guestbook_send` TINYINT( 1 ) DEFAULT '1' NOT NULL;

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_guestbook_limit` INT(11) DEFAULT '10' NOT NULL;