CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_name_created_by_unique` (`name`,`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8mb4;

ALTER TABLE `users` 
ADD COLUMN `type` VARCHAR(45) NULL AFTER `profilePic`,
CHANGE COLUMN `signUpDate` `signUpDate` TIMESTAMP NOT NULL ;


ALTER TABLE `users` 
ADD COLUMN `created_by` INT NOT NULL DEFAULT '0' AFTER `type`;

ALTER TABLE `kyx4u_muscol_artists` 
ADD COLUMN `tiktok` VARCHAR(50) NULL AFTER `instagram`,
ADD COLUMN `bio` TEXT NULL AFTER `tiktok`,
CHANGE COLUMN `added` `added` VARCHAR(50) NOT NULL ;

ALTER TABLE `kyx4u_muscol_artists` 
ADD COLUMN `created_at` TIMESTAMP NULL DEFAULT NULL AFTER `bio`,
ADD COLUMN `updated_at` TIMESTAMP NULL DEFAULT NULL AFTER `created_at`;

ALTER TABLE `kyx4u_muscol_artists` 
CHANGE COLUMN `image` `image` VARCHAR(127) NULL ;

ALTER TABLE `kyx4u_muscol_artists` 
CHANGE COLUMN `review` `review` MEDIUMTEXT NULL ,
CHANGE COLUMN `related` `related` VARCHAR(63) NULL ,
CHANGE COLUMN `keywords` `keywords` VARCHAR(512) NULL ,
CHANGE COLUMN `hits` `hits` INT NULL ,
CHANGE COLUMN `country` `country` VARCHAR(255) NULL ,
CHANGE COLUMN `user_id` `user_id` INT NULL ,
CHANGE COLUMN `metakeywords` `metakeywords` TEXT NULL ,
CHANGE COLUMN `metadescription` `metadescription` TEXT NULL ,
CHANGE COLUMN `city` `city` VARCHAR(255) NULL ,
CHANGE COLUMN `years_active` `years_active` VARCHAR(255) NULL ,
CHANGE COLUMN `url` `url` VARCHAR(255) NULL ,
CHANGE COLUMN `genre_id` `genre_id` INT NULL ,
CHANGE COLUMN `tags` `tags` VARCHAR(255) NULL ,
CHANGE COLUMN `cover` `cover` VARCHAR(255) NULL ;

ALTER TABLE `kyx4u_muscol_albums` 
ADD COLUMN `description` TEXT NULL AFTER `video`,
ADD COLUMN `created_at` TIMESTAMP NULL DEFAULT NULL AFTER `description`,
ADD COLUMN `updated_at` TIMESTAMP NULL DEFAULT NULL AFTER `created_at`,
CHANGE COLUMN `name` `name` VARCHAR(255) NULL ,
CHANGE COLUMN `artist_id` `artist_id` INT NULL ,
CHANGE COLUMN `year` `year` YEAR NULL ,
CHANGE COLUMN `month` `month` INT NULL DEFAULT '0' ,
CHANGE COLUMN `edition_year` `edition_year` YEAR NULL ,
CHANGE COLUMN `edition_month` `edition_month` INT NULL ,
CHANGE COLUMN `edition_country` `edition_country` VARCHAR(127) NULL ,
CHANGE COLUMN `edition_details` `edition_details` VARCHAR(255) NULL ,
CHANGE COLUMN `genre_id` `genre_id` INT NULL ,
CHANGE COLUMN `catalog_number` `catalog_number` VARCHAR(31) NULL ,
CHANGE COLUMN `label` `label` VARCHAR(127) NULL ,
CHANGE COLUMN `length` `length` VARCHAR(9) NULL ,
CHANGE COLUMN `format_id` `format_id` INT NULL ,
CHANGE COLUMN `image` `image` VARCHAR(255) NULL DEFAULT 'no_image.jpg' ,
CHANGE COLUMN `ndisc` `ndisc` INT NULL DEFAULT '1' ,
CHANGE COLUMN `types` `types` VARCHAR(31) NULL ,
CHANGE COLUMN `review` `review` MEDIUMTEXT NULL ,
CHANGE COLUMN `name2` `name2` VARCHAR(255) NULL ,
CHANGE COLUMN `artist2` `artist2` VARCHAR(255) NULL ,
CHANGE COLUMN `subtitle` `subtitle` VARCHAR(255) NULL ,
CHANGE COLUMN `subartist` `subartist` VARCHAR(255) NULL ,
CHANGE COLUMN `fisic` `fisic` VARCHAR(4) NULL DEFAULT 'si' ,
CHANGE COLUMN `points` `points` TINYINT(1) NULL DEFAULT '0' ,
CHANGE COLUMN `added` `added` VARCHAR(50) NULL DEFAULT '0000-00-00 00:00:00' ,
CHANGE COLUMN `modified` `modified` VARCHAR(50) NULL ,
CHANGE COLUMN `price` `price` DECIMAL(6,2) NULL DEFAULT '0.00' ,
CHANGE COLUMN `tags` `tags` VARCHAR(63) NULL ,
CHANGE COLUMN `part_of_set` `part_of_set` INT NULL DEFAULT '0' ,
CHANGE COLUMN `show_separately` `show_separately` VARCHAR(1) NULL DEFAULT 'Y' ,
CHANGE COLUMN `params` `params` MEDIUMTEXT NULL ,
CHANGE COLUMN `keywords` `keywords` VARCHAR(2048) NULL ,
CHANGE COLUMN `user_id` `user_id` INT NULL ,
CHANGE COLUMN `hits` `hits` INT NULL ,
CHANGE COLUMN `buy_link` `buy_link` VARCHAR(255) NULL ,
CHANGE COLUMN `album_file` `album_file` VARCHAR(255) NULL ,
CHANGE COLUMN `metakeywords` `metakeywords` TEXT NULL ,
CHANGE COLUMN `metadescription` `metadescription` TEXT NULL ,
CHANGE COLUMN `external_type` `external_type` VARCHAR(255) NULL ,
CHANGE COLUMN `external_id` `external_id` INT NULL ,
CHANGE COLUMN `video` `video` VARCHAR(255) NULL ;


ALTER TABLE `kyx4u_muscol_albums` 
ADD COLUMN `release_date` DATE NULL AFTER `updated_at`;

ALTER TABLE `kyx4u_muscol_songs` 
CHANGE COLUMN `num` `num` TINYINT NULL ,
CHANGE COLUMN `disc_num` `disc_num` TINYINT NULL ,
CHANGE COLUMN `length` `length` VARCHAR(8) NULL ,
CHANGE COLUMN `name` `name` VARCHAR(255) NULL ,
CHANGE COLUMN `lyrics` `lyrics` TEXT NULL ,
CHANGE COLUMN `artist_id` `artist_id` INT NULL ,
CHANGE COLUMN `composer_id` `composer_id` INT NULL ,
CHANGE COLUMN `filename` `filename` VARCHAR(255) NULL ,
CHANGE COLUMN `extension` `extension` VARCHAR(5) NULL ,
CHANGE COLUMN `added` `added` DATETIME NULL ,
CHANGE COLUMN `review` `review` TEXT NULL ,
CHANGE COLUMN `songwriters` `songwriters` TINYTEXT NULL ,
CHANGE COLUMN `chords` `chords` TEXT NULL ,
CHANGE COLUMN `genre_id` `genre_id` INT NULL ,
CHANGE COLUMN `hits` `hits` INT NULL ,
CHANGE COLUMN `buy_link` `buy_link` VARCHAR(255) NULL ,
CHANGE COLUMN `video` `video` VARCHAR(255) NULL ,
CHANGE COLUMN `position` `position` VARCHAR(6) NULL ,
CHANGE COLUMN `downloaded` `downloaded` INT NULL ,
CHANGE COLUMN `user_id` `user_id` INT NULL ,
CHANGE COLUMN `tags` `tags` VARCHAR(255) NULL ,
CHANGE COLUMN `external_type` `external_type` VARCHAR(255) NULL ,
CHANGE COLUMN `external_id` `external_id` INT NULL ;

INSERT INTO `settings` (`id`, `name`, `value`, `created_by`) VALUES ('1', 'color', 'theme-1', '2');
INSERT INTO `settings` (`id`, `name`, `value`, `created_by`) VALUES ('3', 'cust_darklayout', 'off', '2');
INSERT INTO `settings` (`id`, `name`, `value`, `created_by`) VALUES ('2', 'SITE_RTL', 'off', '2');


DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=tapehust_v12
DB_USERNAME=tapehust_dbadmin
DB_PASSWORD=Ciscoarris1!

change parent_disk


remove public/assests/ theme sets