/database/patches/12.php

RENAME TABLE  `templates_page` TO  `templates` ;



ALTER TABLE  `templates` DROP  `name` ,

DROP  `changed` ,

DROP  `backend_template` ;



ALTER TABLE  `templates` ADD  `html` LONGTEXT NOT NULL;



ALTER TABLE  `templates_backend` ADD  `changed` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;



ALTER TABLE  `templates_backend` ADD  `template` INT NOT NULL;



DELETE FROM  `templates` WHERE  `templates`.`ID` =1 LIMIT 1 ;



DELETE FROM  `templates` WHERE  `templates`.`ID` =10 LIMIT 1 ;



DELETE FROM  `templates` WHERE  `templates`.`ID` =11 LIMIT 1 ;



DELETE FROM  `templates` WHERE  `templates`.`ID` =13 LIMIT 1 ;



DELETE FROM  `templates` WHERE  `templates`.`ID` =15 LIMIT 1 ;



UPDATE  `templates_backend` SET  `template` =  '17' WHERE  `templates_backend`.`ID` =1 LIMIT 1 ;



UPDATE  `templates_backend` SET  `template` =  '14' WHERE  `templates_backend`.`ID` =2 LIMIT 1 ;



INSERT INTO  `navca`.`system_messages` (

`ID` ,

`type` ,

`code` ,

`heading` ,

`message` ,

`customisable` ,

`customless_message`

)

VALUES (

NULL ,  'message',  'template00001',  'New template created',  'Your new template has been created, you can customise it using the options below.',  '0',  ''

);





INSERT INTO  `navca`.`system_messages` (

`ID` ,

`type` ,

`code` ,

`heading` ,

`message` ,

`customisable` ,

`customless_message`

)

VALUES (

NULL ,  'message',  'template00002',  'Changes saved',  'The changes to the template have been saved.',  '0',  ''

);





UPDATE  `settings` SET  `value` =  '2' WHERE  `settings`.`key` ='default_template.id' LIMIT 1 ;