INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'LinkedIn', 'social_linkedin', '99', NOW());
INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'Twitter', 'social_twitter', '99', NOW());
INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'Youtube', 'social_youtube', '99', NOW());
INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'Pinterest', 'social_pinterest', '99', NOW());
UPDATE tblsocial_media_links_static SET ordering = '5' WHERE codename = 'social_facebook';
UPDATE tblsocial_media_links_static SET ordering = '10' WHERE codename = 'social_instagram';
UPDATE tblsocial_media_links_static SET ordering = '15' WHERE codename = 'social_linkedin';
UPDATE tblsocial_media_links_static SET ordering = '20' WHERE codename = 'social_twitter';
UPDATE tblsocial_media_links_static SET ordering = '25' WHERE codename = 'social_youtube';
UPDATE tblsocial_media_links_static SET ordering = '30' WHERE codename = 'social_pinterest';
UPDATE tblsocial_media_links_static SET ordering = '35' WHERE codename = 'social_google';
UPDATE tblsocial_media_links_static SET ordering = '40' WHERE codename = 'social_website';

ALTER TABLE `tbltenant_files` ADD `added_on` DATETIME NULL DEFAULT NULL AFTER `file_for`;