# --------------------------------------------------------
# VERSION UPDATING
# --------------------------------------------------------
UPDATE `setting` set value='2.5.9__2.6rc1' WHERE name='ClientExec Version';

# --------------------------------------------------------
# TYPOS
# --------------------------------------------------------
UPDATE `setting` SET description = 'Select Yes if you want to disable the embedded Clientexec support system. <br> Additionally, you can define a URL to redirect your customers to an external support system of your own.' WHERE name = 'Disable CE Tickets Support System';

# --------------------------------------------------------
# MISSING END POINT
# --------------------------------------------------------
UPDATE `setting` SET description = 'Number of announcements by category displayed in the dashboard.' WHERE description = 'Number of announcements by category displayed in dashboard'; 

# --------------------------------------------------------
# ANNOUNCEMENTS SHOULD RECORD POST TIME AS WELL
# --------------------------------------------------------
ALTER TABLE `announcement` CHANGE `postdate` `postdate` DATETIME DEFAULT '0000-00-00' NOT NULL;

# --------------------------------------------------------
# ADD NEW REPORT TABLE FOR UPDDATING SETTINGS FOR TABLES
# --------------------------------------------------------
CREATE TABLE `report` (
    `name` VARCHAR( 80 ) NOT NULL ,
    `public` TINYINT DEFAULT '0' NOT NULL ,
    `quickgraph` TINYINT DEFAULT '0' NOT NULL ,
    PRIMARY KEY ( `name` )
);

# --------------------------------------------------------
# UPDATE REPORT MODULE SO ALL CAN SEE REPORTS
# --------------------------------------------------------
UPDATE `module_group` SET `viewable` = '1' WHERE `moduleid` =7 AND `groupid` =3 LIMIT 1 ;
UPDATE `module_group` SET `viewable` = '1' WHERE `moduleid` =7 AND `groupid` =4 LIMIT 1 ;
UPDATE `module_group` SET `viewable` = '1' WHERE `moduleid` =7 AND `groupid` =5 LIMIT 1 ;
