firstgarden-web-gnu/manager/install.php

<?php
include_once '_common.php'; // 그누보드 설정 파일 불러오기
include_once 'head.php';
include_once 'head.sub.php';
/* 
    초기 세팅을 위한 데이터베이스 생성 
    table name은 config.php 를 참조하여 생성한다.
    table name의 접두어를 바꾸고 싶은 경우 해당 파일을 수정할 것

*/

// LOG
$query[] = "CREATE TABLE `{$fg['log_table']}` (
        `idx` INT UNSIGNED NOT NULL AUTO_INCREMENT,
        `work` VARCHAR(50) NOT NULL,
        `work_detail` TEXT NOT NULL,
        `id` VARCHAR(50) NOT NULL,
        `date` DATETIME NOT NULL,
        PRIMARY KEY (`idx`)
        )
    COMMENT='계정구분(부서)' COLLATE='utf8mb4_general_ci' DEFAULT CHARSET='utf8';
    ";

// 사용자 계정 구분
$query[] = "CREATE TABLE `{$fg['member_group_table']}` (
        `tid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
        `tname` VARCHAR(50) NOT NULL,
        `tauth` TINYINT(1) NOT NULL,
        `tused` TINYINT(1) NOT NULL,
        `memo` VARCHAR(255) NULL,
        PRIMARY KEY (`tid`),
        UNIQUE INDEX `tname` (`tname`)
    )
    COMMENT='계정구분(부서)' 
    COLLATE='utf8mb4_general_ci' 
    DEFAULT CHARSET='utf8';
";

// 사용자 계정
$query[] = "CREATE TABLE `{$fg['member_table']}` (
        `idx` INT UNSIGNED NOT NULL AUTO_INCREMENT,
        `user_id` VARCHAR(50) NOT NULL,
        `user_pw` VARCHAR(256) NOT NULL,
        `user_name` VARCHAR(10) NULL,
        `tid` INT NULL,
        `user_lv` TINYINT(2) NULL,
        `used` TINYINT(1) NOT NULL,
        `memo` VARCHAR(255) NULL,
        `join_datetime` DATETIME NOT NULL,
        `last_login_time` DATETIME NULL DEFAULT 0000-00-00 00:00:00,
        PRIMARY KEY (`idx`),
        UNIQUE INDEX `user_id` (`user_id`),
        CONSTRAINT `FK_member_group` FREIGN KEY (`tid`) REFERENCES `{$fg['member_group_table']}` (`member_id`)
    )
    COMMENT='계정(직원)' 
    COLLATE='utf8mb4_general_ci' 
    DEFAULT CHARSET='utf8'
    ;
";


// VIP 구분 테이블
$query[] = "CREATE TABLE `{$fg['vip_category_table']}` (
        `gr_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
        `gr_name` VARCHAR(50) NOT NULL,
        `gr_lv` VARCHAR(2) NOT NULL,
        `gr_used` TINYINT(2) NOT NULL,
        `gr_date` DATE NOT NULL,
        PRIMARY KEY (`gr_id`),
        UNIQUE INDEX `gr_name` (`gr_name`)
    )
    COMMENT='VIP 구분'
    COLLATE='utf8mb4_general_ci'
    DEFAULT CHARSET='utf8'
    ;
";

// VIP LIST
$query[] = "CREATE TABLE `{$fg['vip_list_table']}` (
        `idx` INT UNSIGNED NOT NULL AUTO_INCREMENT,
        `vip_card_no` INT(6) NOT NULL,
        `status` VARCHAR(10) NOT NULL,
        `gr_id` TINYINT(3) NOT NULL,
        `rec_team` VARCHAR(20) NOT NULL,
        `app_name` VARCHAR(20) NOT NULL,
        `vip_name` VARCHAR(20) NOT NULL,
        `vip_memo` VARCHAR(255) NOT NULL,
        `vip_birth` DATE NOT NULL,
        `vip_email` VARCHAR(255) NOT NULL,
        `vip_addr` VARCHAR(255) NOT NULL,
        `vip_tel`  VARCHAR(20) NOT NULL,
        `vip_gender` VARCHAR(10) NOT NULL,
        `vip_date` DATE NOT NULL,
        `rec_name` VARCHAR(50) NOT NULL,
        `join_datetime` DATAETIME NOT NULL,
        `last_edit_date` DATETIME NOT NULL,
        `last_edit_name` VARCHAR(50) NOT NULL,
        `last_ent_date` DATETIME NOT NULL,
        `ent_count` INT(11) NOT NULL,
        PRIMARY KEY (`idx`),
        UNIQUE INDEX `vip_card_no` (`vip_card_no`),
        UNIQUE INDEX `vip_tel` (`vip_tel`)
    )
    COMMENT='VIP 회원 목록'
    COLLATE='utf8mb4_general_ci'
    DEFAULT CHARSET='utf8'
    ; 
";

// VIP 입장기록
$query[] = "CREATE TABLE `{$fg['vip_ent_table']}` (
        `idx` INT UNSIGNED NOT NULL AUTO_INCREMENT,
        `vip_card_no` INT(6) NOT NULL,
        `ent_date` DATETIME NOT NULL,
        `adm` VARCHAR(50) NOT NULL,
        PRIMARY KEY (`idx`)
    )
    COMMENT='VIP 입장기록'
    COLLATE='utf8mb4_general_ci'
    DEFAULT CHARSET='utf8'
    ;
";

// 연간회원 카테고리
$query[] = "CREATE TABLE `{$fg['annual_category_table']}` (
        `ca_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
        `ca_name` VARCHAR(50) NOT NULL,
        `ca_used` TINYINT(2) NOT NULL,
        `ca_info` VARCHAR(255) NOT NULL,
        `ca_code` INT NOT NULL
    )
    COMMENT='연간회원 구분'
    COLLATE='utf8mb4_general_ci'
    DEFAULT CHARSET='utf8'
    ;
";

// 연간회원 리스트
$query[] = "CREATE TABLE `{$fg['annual_member_table']}` (
        `mem_no` INT UNSIGNED NOT NULL AUTO_INCREMENT,
        `status` VARCHAR(10) NOT NULL,
        `ca_id` TINYINT(3) NOT NULL,
        `app_id` VARCHAR(20) NOT NULL,
        `name` VARCHAR(20) NOT NULL,
        `memo` VARCHAR(255) NOT NULL,
        `birth` DATE NOT NULL,
        `email` VARCHAR(255) NOT NULL,
        `addr` VARCHAR(255) NOT NULL,
        `tel`  VARCHAR(20) NOT NULL,
        `gender` VARCHAR(10) NOT NULL,
        `sdate` DATE NOT NULL,
        `edate` DATE NOT NULL,
        `photo_url` VARCHAR(255) NOT NULL,
        `photo_name` VARCHAR(255) NOT NULL,
        `last_edit_date` DATETIME NOT NULL,
        `last_edit_id` VARCHAR(50) NOT NULL,
        `last_ent_date` DATETIME NOT NULL,
        `ent_count` INT(11) NOT NULL,
        PRIMARY KEY (`mem_no`),
        UNIQUE INDEX `mem_no` (`mem_no`)
    )
    COMMENT='연간회원 목록'
    COLLATE='utf8mb4_general_ci'
    DEFAULT CHARSET='utf8'
    ; 
";
foreach($query as $row) {
    sql_query($row);
}
goto_url(FG_MANAGER_URL);

include_once 'tail.php';