Polskie forum wsparcia dla phpBB

Kod: Zaznacz cały

ALTER TABLE `phpbb_users` 
ADD `user_plusp` INT( 6 ) UNSIGNED DEFAULT '0' NOT NULL , 
ADD `user_minusp` INT( 6 ) UNSIGNED DEFAULT '0' NOT NULL , 
ADD `user_disallowed_write` TINYINT ( 1 ) DEFAULT '0' NOT NULL; 

ALTER TABLE `phpbb_posts` 
ADD `post_plusp` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL , 
ADD `post_minusp` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ; 

CREATE TABLE `phpbb_plusminus` ( 
`pm_id` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT , 
`post_id` INT ( 11 ) UNSIGNED NOT NULL , 
`pm_time` INT ( 32 ) NOT NULL , 
`pm_from` INT ( 11 ) UNSIGNED NOT NULL , 
`pm_to` INT ( 11 ) UNSIGNED NOT NULL , 
`pm_type` INT ( 2 ) NOT NULL , 
`pm_reason` VARCHAR ( 255 ) , 
PRIMARY KEY ( `pm_id` ) 
); 

ALTER TABLE `phpbb_groups` 
ADD `auth_disallow_write` TINYINT( 11 ) DEFAULT '0' NOT NULL , 
ADD `auth_ban` TINYINT DEFAULT '0' NOT NULL , 
ADD `auth_remove_points` TINYINT( 1 ) DEFAULT '0' NOT NULL ; 

ALTER TABLE `phpbb_forums` 
ADD `enable_pluspoints` TINYINT( 1 ) DEFAULT '1' NOT NULL , 
ADD `enable_minuspoints` TINYINT( 1 ) DEFAULT '1' NOT NULL ;