File indexing completed on 2024-04-21 06:00:37
0001 ALTER TABLE `project_category` 0002 ADD COLUMN `browse_list_type` INT(1) NOT NULL DEFAULT '0' AFTER `source_required`; 0003 0004 0005 CREATE TABLE `browse_list_types` ( 0006 `browse_list_type_id` INT(11) NOT NULL AUTO_INCREMENT, 0007 `name` VARCHAR(50) NOT NULL, 0008 `desc` VARCHAR(255) NULL DEFAULT NULL, 0009 `render_page_name` VARCHAR(50) NULL DEFAULT 'index-react', 0010 `is_active` INT(1) UNSIGNED NULL DEFAULT '1', 0011 `deleted_at` TIMESTAMP NULL DEFAULT NULL, 0012 PRIMARY KEY (`browse_list_type_id`) 0013 ) 0014 COLLATE='latin1_swedish_ci' 0015 ENGINE=InnoDB 0016 ; 0017 0018 0019 0020 INSERT INTO `pling`.`browse_list_types` (`browse_list_type_id`, `type_name`, `type_desc`) VALUES ('0', 'default', 'Default List type is list'); 0021 INSERT INTO `pling`.`browse_list_types` (`type_name`, `type_desc`) VALUES ('picture', 'Gridview with big pictures'); 0022 INSERT INTO `pling`.`browse_list_types` (`type_name`, `type_desc`) VALUES ('music', 'Gridview with play buttons'); 0023 0024 0025 ALTER TABLE `config_store` 0026 ADD COLUMN `browse_list_type` INT(11) NULL DEFAULT NULL AFTER `stay_in_context`; 0027