In DB:
Alter table bucalendar add venue_name varchar(70);
Alter table bucalendar add other_income_name varchar(70);
ALTER TABLE tillinvoices ADD last_print DATETIME DEFAULT NULL;
Alter table waitron add userpayment tinyint not null default 1;

ALTER TABLE tillclients ADD w_current decimal(20,2) DEFAULT '0.00';
ALTER TABLE tillclients ADD w_1 decimal(20,2) DEFAULT '0.00';
ALTER TABLE tillclients ADD w_2 decimal(20,2) DEFAULT '0.00';
ALTER TABLE tillclients ADD w_3 decimal(20,2) DEFAULT '0.00';
ALTER TABLE tillclients ADD w_4 decimal(20,2) DEFAULT '0.00';
ALTER TABLE tillclients ADD w_4plus decimal(20,2) DEFAULT '0.00';

ALTER TABLE suppliers ADD w_current decimal(20,2) DEFAULT '0.00';
ALTER TABLE suppliers ADD w_1 decimal(20,2) DEFAULT '0.00';
ALTER TABLE suppliers ADD w_2 decimal(20,2) DEFAULT '0.00';
ALTER TABLE suppliers ADD w_3 decimal(20,2) DEFAULT '0.00';
ALTER TABLE suppliers ADD w_4 decimal(20,2) DEFAULT '0.00';
ALTER TABLE suppliers ADD w_4plus decimal(20,2) DEFAULT '0.00';

DROP TABLE IF EXISTS `account_weekend`;
CREATE TABLE `account_weekend` (
  `id` int(11) NOT NULL,
  `week` int(11) DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `account` int(11) DEFAULT NULL,
  `person` varchar(100) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


In Spaceusers:
CREATE TABLE Settings (`name` varchar(32) NOT NULL,`val` varchar(50) NOT NULL DEFAULT '',`db` varchar(30) not null default '',PRIMARY KEY (`name`,`db`) );
