Download From : Download now

Upgrade from 4.0.x to 4.1 patch: Download now
Database upgrade from 4.0.x to 4.1:

ALTER TABLE `pb_members` ADD `start_time` DATE NOT NULL ,
ADD `end_time` DATE NOT NULL;
ALTER TABLE `pb_jobs` ADD `jobtype_id` SMALLINT( 6 ) NOT NULL DEFAULT '0';
ALTER TABLE `pb_spreads` ADD `show_times` INT( 10 ) NOT NULL DEFAULT '1',
ADD `cost_every_hit` FLOAT( 7, 2 ) NOT NULL DEFAULT '0';
DROP TABLE IF EXISTS `pb_metas`;
CREATE TABLE IF NOT EXISTS `pb_metas` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `object_id` int(10) NOT NULL DEFAULT '0',
  `object_type` varchar(100) NOT NULL DEFAULT '',
  `content` tinytext NOT NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM ;

DROP TABLE IF EXISTS `pb_spreadadses`;
CREATE TABLE `pb_spreadadses` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `member_id` int(10) NOT NULL DEFAULT '0',
  `title` varchar(250) NOT NULL DEFAULT '',
  `desc1` varchar(200) NOT NULL DEFAULT '',
  `desc2` varchar(200) NOT NULL DEFAULT '',
  `show_url` varchar(100) NOT NULL DEFAULT '',
  `target_url` varchar(100) NOT NULL DEFAULT '',
  `created` int(10) NOT NULL DEFAULT '0',
  `modified` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `pb_spreadadstypes`;
CREATE TABLE `pb_spreadadstypes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `member_id` int(10) NOT NULL DEFAULT '0',
  `name` varchar(250) NOT NULL DEFAULT '',
  `created` int(10) NOT NULL DEFAULT '0',
  `modified` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) TYPE=MyISAM;