Created
October 30, 2017 15:32
-
-
Save dryrain39/f3a605431bd314a979a95f27bcfb12aa to your computer and use it in GitHub Desktop.
gangbuk_pf.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- phpMyAdmin SQL Dump | |
-- version 4.5.4.1deb2ubuntu2 | |
-- http://www.phpmyadmin.net | |
-- | |
-- Host: localhost | |
-- 생성 시간: 17-10-31 00:02 | |
-- 서버 버전: 5.7.19-0ubuntu0.16.04.1 | |
-- PHP 버전: 7.0.22-0ubuntu0.16.04.1 | |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; | |
SET time_zone = "+00:00"; | |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; | |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; | |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; | |
/*!40101 SET NAMES utf8mb4 */; | |
-- | |
-- 데이터베이스: `gangbuk_pf` | |
-- | |
-- -------------------------------------------------------- | |
-- | |
-- 테이블 구조 `meal_data_GB` | |
-- | |
CREATE TABLE `meal_data_GB` ( | |
`date` int(11) NOT NULL, | |
`data` text COLLATE utf8mb4_bin NOT NULL, | |
`school` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'YS' | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; | |
-- -------------------------------------------------------- | |
-- | |
-- 테이블 구조 `meal_data_YS` | |
-- | |
CREATE TABLE `meal_data_YS` ( | |
`date` int(11) NOT NULL, | |
`data` text COLLATE utf8mb4_bin NOT NULL, | |
`school` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'GB' | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; | |
-- -------------------------------------------------------- | |
-- | |
-- 테이블 구조 `user` | |
-- | |
CREATE TABLE `user` ( | |
`user_key` varchar(100) COLLATE utf8mb4_bin NOT NULL, | |
`school_setting` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'GB', | |
`keyboard` int(11) NOT NULL DEFAULT '0' | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; | |
-- | |
-- 덤프된 테이블의 인덱스 | |
-- | |
-- | |
-- 테이블의 인덱스 `meal_data_GB` | |
-- | |
ALTER TABLE `meal_data_GB` | |
ADD PRIMARY KEY (`date`); | |
-- | |
-- 테이블의 인덱스 `meal_data_YS` | |
-- | |
ALTER TABLE `meal_data_YS` | |
ADD PRIMARY KEY (`date`); | |
-- | |
-- 테이블의 인덱스 `user` | |
-- | |
ALTER TABLE `user` | |
ADD PRIMARY KEY (`user_key`); | |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; | |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; | |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment