use [% mysql.b2e.sqldb %];

ALTER TABLE `[% table_prefix %]_hitlog` 
    MODIFY COLUMN `visitTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    ADD KEY `visitTime` (`visitTime`)
;

UPDATE [% table_prefix %]_settings SET set_value='8066' WHERE set_name='db_version';
