File indexing completed on 2024-04-21 06:00:36
0001 CREATE TABLE `member_setting_group` 0002 ( 0003 `member_setting_group_id` INT(11) NOT NULL AUTO_INCREMENT, 0004 `title` VARCHAR(45) NOT NULL, 0005 PRIMARY KEY (`member_setting_group_id`) 0006 ); 0007 0008 0009 CREATE TABLE `member_setting_item` 0010 ( 0011 `member_setting_item_id` INT(11) NOT NULL AUTO_INCREMENT, 0012 `title` VARCHAR(45) NOT NULL, 0013 `member_setting_group_id` INT(11) NOT NULL, 0014 PRIMARY KEY (`member_setting_item_id`) 0015 ); 0016 0017 0018 CREATE TABLE `member_setting_value` 0019 ( 0020 `member_setting_value_id` INT(11) NOT NULL AUTO_INCREMENT, 0021 `member_setting_item_id` INT(11) NOT NULL, 0022 `value` VARCHAR(100) NOT NULL, 0023 `member_id` INT(11) NOT NULL, 0024 `created_at` TIMESTAMP NOT NULL DEFAULT now(), 0025 `changed_at` DATETIME NULL DEFAULT NULL, 0026 `deleted_at` DATETIME NULL DEFAULT NULL, 0027 `is_active` INT(1) NOT NULL DEFAULT 1, 0028 PRIMARY KEY (`member_setting_value_id`) 0029 );