ALTER TABLE `users`
ADD COLUMN `datecreated`  timestamp NULL AFTER `lastname`,
ADD COLUMN `createdip`  varchar(15) NULL AFTER `datecreated`;

ALTER TABLE `shorturl`
ADD COLUMN `userId`  int NULL AFTER `status`;

UPDATE `site_config` SET `availableValues` = '["blue_v2", "green_v2", "orange_v2", "blue", "orange", "green"]' WHERE `site_config`.`id` =9;

INSERT INTO `site_config` (
`config_key` ,
`config_value` ,
`config_description` ,
`availableValues` ,
`config_type` ,
`config_group`) VALUES (
'default_email_address_from',
'you@domain.com',
'The email address new account registrations will be sent from.',
'',
'string',
'Default')