CREATE TABLE tblsocial_media_links_static (
	id BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(5000) NOT NULL,
    codename VARCHAR(5000) NOT NULL,
    ordering INT UNSIGNED DEFAULT 99,
    datecreated DATETIME NULL DEFAULT NULL
);

INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'Google', 'social_google', '99', '2020-09-07 19:41:08');
INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'Facebook', 'social_facebook', '99', '2020-09-07 19:41:08');
INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'Yelp', 'social_yelp', '99', '2020-09-07 19:41:08');
INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'Instagram', 'social_instagram', '99', '2020-09-07 19:41:08');
INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'Website', 'social_website', '99', '2020-09-07 19:41:08');
INSERT INTO `tblsocial_media_links_static` (`id`, `name`, `codename`, `ordering`, `datecreated`) VALUES (NULL, 'Contractor+ Club', 'social_contractorplusclub', '99', '2020-09-07 19:41:08');