-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- 생성 시간: 24-03-02 09:13
-- 서버 버전: 8.2.0
-- PHP 버전: 8.2.13

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 */;

--
-- 데이터베이스: `publics`
--

-- --------------------------------------------------------

--
-- 테이블 구조 `calc_tables`
--

DROP TABLE IF EXISTS `calc_tables`;
CREATE TABLE IF NOT EXISTS `calc_tables` (
  `idx` int NOT NULL AUTO_INCREMENT,
  `boardidx` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `boardid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `write` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `day` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `passkey` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `commentcount` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `urladdr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fileaddr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `boardtitle` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastwriter` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastpost` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idx`),
  KEY `number` (`number`),
  KEY `write` (`write`),
  KEY `day` (`day`),
  KEY `hit` (`hit`),
  KEY `commentcount` (`commentcount`),
  KEY `boardid` (`boardid`) USING BTREE,
  KEY `lastwriter` (`lastwriter`),
  KEY `boardidx` (`boardidx`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='comment게시판 정산처리 update와 글 상태 보여주기 처리 테이블';

-- --------------------------------------------------------

--
-- 테이블 구조 `comment`
--

DROP TABLE IF EXISTS `comment`;
CREATE TABLE IF NOT EXISTS `comment` (
  `idx` int NOT NULL AUTO_INCREMENT,
  `boardidx` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `boardid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `write` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `day` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `passkey` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `urladdr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fileaddr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `boardtitle` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastwriter` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastpost` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idx`),
  KEY `number` (`number`),
  KEY `write` (`write`),
  KEY `day` (`day`),
  KEY `hit` (`hit`),
  KEY `boardid` (`boardid`) USING BTREE,
  KEY `lastwriter` (`lastwriter`),
  KEY `boardidx` (`boardidx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='글작성용 테이블';

-- --------------------------------------------------------

--
-- 테이블 구조 `depth_base`
--

DROP TABLE IF EXISTS `depth_base`;
CREATE TABLE IF NOT EXISTS `depth_base` (
  `idx` int NOT NULL AUTO_INCREMENT,
  `depth_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prvid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `spool` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idx`) USING BTREE,
  KEY `depth_id` (`depth_id`) USING BTREE,
  KEY `spool` (`spool`) USING BTREE,
  KEY `mode` (`mode`),
  KEY `prvid` (`prvid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='메인또는서브포럼';

--
-- 테이블의 덤프 데이터 `depth_base`
--

INSERT INTO `depth_base` (`idx`, `depth_id`, `prvid`, `spool`, `mode`) VALUES
(1, 'bcdef4 ', 'base', '2', 'pre'),
(2, 'defgh7 ', 'top', '1', 'block');

-- --------------------------------------------------------

--
-- 테이블 구조 `depth_state_set`
--

DROP TABLE IF EXISTS `depth_state_set`;
CREATE TABLE IF NOT EXISTS `depth_state_set` (
  `idx` int NOT NULL AUTO_INCREMENT,
  `calls` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prvid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `spool` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prvtitle` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idx`) USING BTREE,
  KEY `spool` (`spool`) USING BTREE,
  KEY `prvid` (`prvid`),
  KEY `calls` (`calls`) USING BTREE,
  KEY `mode` (`mode`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 테이블의 덤프 데이터 `depth_state_set`
--

INSERT INTO `depth_state_set` (`idx`, `calls`, `prvid`, `spool`, `prvtitle`, `subject`, `mode`) VALUES
(1, '', 'top', '', 'abc', '테스트000', 'block'),
(2, 'defgh7', 'top', '1', '', '테스트11', ''),
(3, 'bcdef4', 'base', '3', '', '테스트2', ''),
(4, 'base456', 'base', '2', '', 'qpdltm', ''),
(5, 'base85623', 'base', '1', '', '베이스1', ''),
(6, '', 'base', '', 'def', 'base', 'pre');

-- --------------------------------------------------------

--
-- 테이블 구조 `forum_site`
--

DROP TABLE IF EXISTS `forum_site`;
CREATE TABLE IF NOT EXISTS `forum_site` (
  `idx` int NOT NULL AUTO_INCREMENT,
  `site` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `main_sub` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idx`),
  KEY `site` (`site`) USING BTREE,
  KEY `main_sub` (`main_sub`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 테이블의 덤프 데이터 `forum_site`
--

INSERT INTO `forum_site` (`idx`, `site`, `main_sub`) VALUES
(1, 'abc', 'index'),
(2, 'def', 'depth');

-- --------------------------------------------------------

--
-- 테이블 구조 `index_base`
--

DROP TABLE IF EXISTS `index_base`;
CREATE TABLE IF NOT EXISTS `index_base` (
  `idx` int NOT NULL AUTO_INCREMENT,
  `tableid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `spool` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idx`) USING BTREE,
  KEY `tableid` (`tableid`) USING BTREE,
  KEY `mode` (`mode`) USING BTREE,
  KEY `spool` (`spool`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='메인또는서브포럼';

--
-- 테이블의 덤프 데이터 `index_base`
--

INSERT INTO `index_base` (`idx`, `tableid`, `spool`, `mode`) VALUES
(1, 'top', '2', 'block'),
(2, 'base', '1', 'pre');

-- --------------------------------------------------------

--
-- 테이블 구조 `index_state_set`
--

DROP TABLE IF EXISTS `index_state_set`;
CREATE TABLE IF NOT EXISTS `index_state_set` (
  `idx` int NOT NULL AUTO_INCREMENT,
  `attrib` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `spool` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `calls` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idx`) USING BTREE,
  KEY `attrib` (`attrib`) USING BTREE,
  KEY `spool` (`spool`) USING BTREE,
  KEY `calls` (`calls`) USING BTREE,
  KEY `mode` (`mode`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 테이블의 덤프 데이터 `index_state_set`
--

INSERT INTO `index_state_set` (`idx`, `attrib`, `spool`, `subject`, `mode`, `calls`) VALUES
(1, '', '', '테스트000', 'block', 'top'),
(2, 'defgh7', '1', '테스트1', '', 'top'),
(3, 'bcdef4', '2', '테스트2', '', 'base'),
(4, 'base456', '2', 'qpdltm', '', 'base'),
(5, 'base85623', '1', '베이스1', '', 'base'),
(6, '', '', '베이스000', 'pre', 'base');

-- --------------------------------------------------------

--
-- 테이블 구조 `set_depth_max`
--

DROP TABLE IF EXISTS `set_depth_max`;
CREATE TABLE IF NOT EXISTS `set_depth_max` (
  `idx` int NOT NULL,
  `counts` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `crnt_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `idx` (`idx`),
  KEY `limit_sub` (`counts`) USING BTREE,
  KEY `crnt_name` (`crnt_name`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='토막글 Re)Re)Re)..제한 단계';

--
-- 테이블의 덤프 데이터 `set_depth_max`
--

INSERT INTO `set_depth_max` (`idx`, `counts`, `crnt_name`) VALUES
(1, '1', 'abc');

-- --------------------------------------------------------

--
-- 테이블 구조 `set_forum_admin`
--

DROP TABLE IF EXISTS `set_forum_admin`;
CREATE TABLE IF NOT EXISTS `set_forum_admin` (
  `idx` int NOT NULL,
  `admin_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `idx` (`idx`),
  KEY `code` (`code`),
  KEY `admin_id` (`admin_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- 테이블 구조 `set_max_depth`
--

DROP TABLE IF EXISTS `set_max_depth`;
CREATE TABLE IF NOT EXISTS `set_max_depth` (
  `idx` int NOT NULL AUTO_INCREMENT,
  `set_max` int NOT NULL DEFAULT '2',
  PRIMARY KEY (`idx`),
  KEY `set_max` (`set_max`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='테이블 토막글 제한갯수';

-- --------------------------------------------------------

--
-- 테이블 구조 `set_stop_forum`
--

DROP TABLE IF EXISTS `set_stop_forum`;
CREATE TABLE IF NOT EXISTS `set_stop_forum` (
  `idx` int NOT NULL,
  `open_time` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_lock` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stop_forum` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `open_code` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `idx` (`idx`),
  KEY `stop_forum` (`stop_forum`),
  KEY `open_time` (`open_time`) USING BTREE,
  KEY `user_lock` (`user_lock`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- 테이블 구조 `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `idx` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_hash` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idx`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 덤프된 테이블의 인덱스
--

--
-- 테이블의 인덱스 `calc_tables`
--
ALTER TABLE `calc_tables` ADD FULLTEXT KEY `title` (`title`);
ALTER TABLE `calc_tables` ADD FULLTEXT KEY `passkey` (`passkey`);
ALTER TABLE `calc_tables` ADD FULLTEXT KEY `message` (`message`);
ALTER TABLE `calc_tables` ADD FULLTEXT KEY `urladdr` (`urladdr`);
ALTER TABLE `calc_tables` ADD FULLTEXT KEY `fileaddr` (`fileaddr`);
ALTER TABLE `calc_tables` ADD FULLTEXT KEY `lastpost` (`lastpost`);
ALTER TABLE `calc_tables` ADD FULLTEXT KEY `boardt` (`boardtitle`);

--
-- 테이블의 인덱스 `comment`
--
ALTER TABLE `comment` ADD FULLTEXT KEY `title` (`title`);
ALTER TABLE `comment` ADD FULLTEXT KEY `passkey` (`passkey`);
ALTER TABLE `comment` ADD FULLTEXT KEY `message` (`message`);
ALTER TABLE `comment` ADD FULLTEXT KEY `urladdr` (`urladdr`);
ALTER TABLE `comment` ADD FULLTEXT KEY `fileaddr` (`fileaddr`);
ALTER TABLE `comment` ADD FULLTEXT KEY `lastpost` (`lastpost`);
ALTER TABLE `comment` ADD FULLTEXT KEY `boardtitle` (`boardtitle`);

--
-- 테이블의 인덱스 `depth_state_set`
--
ALTER TABLE `depth_state_set` ADD FULLTEXT KEY `subject` (`subject`);
ALTER TABLE `depth_state_set` ADD FULLTEXT KEY `prvtitle` (`prvtitle`);

--
-- 테이블의 인덱스 `index_state_set`
--
ALTER TABLE `index_state_set` ADD FULLTEXT KEY `subject` (`subject`);

--
-- 테이블의 인덱스 `set_stop_forum`
--
ALTER TABLE `set_stop_forum` ADD FULLTEXT KEY `open_code` (`open_code`);

--
-- 테이블의 인덱스 `users`
--
ALTER TABLE `users` ADD FULLTEXT KEY `user_hash` (`user_hash`);
COMMIT;

/*!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 */;