-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- 생성 시간: 24-02-16 15:50
-- 서버 버전: 10.4.32-MariaDB
-- PHP 버전: 8.0.30

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

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

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

--
-- 테이블 구조 `category`
--

CREATE TABLE `category` (
  `groupidx` int(11) NOT NULL,
  `previdx` varchar(20) NOT NULL,
  `prevtitle` tinytext NOT NULL,
  `previd` varchar(20) NOT NULL,
  `depthidx` varchar(20) NOT NULL,
  `depthtitle` tinytext NOT NULL,
  `depthid` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='카테고리';

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

INSERT INTO `category` (`groupidx`, `previdx`, `prevtitle`, `previd`, `depthidx`, `depthtitle`, `depthid`) VALUES
(1, '1', 'abc', 'top', '', '', ''),
(2, '1', 'abc', 'top', '1', 'alpha', 'inf'),
(3, '1', 'beta', 'delta', '2', 'omega', 'omega');

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

--
-- 테이블의 인덱스 `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`groupidx`),
  ADD KEY `previdx` (`previdx`),
  ADD KEY `previd` (`previd`),
  ADD KEY `depthid` (`depthid`);
ALTER TABLE `category` ADD FULLTEXT KEY `prevtitle` (`prevtitle`);
ALTER TABLE `category` ADD FULLTEXT KEY `depthtitle` (`depthtitle`);

--
-- 덤프된 테이블의 AUTO_INCREMENT
--

--
-- 테이블의 AUTO_INCREMENT `category`
--
ALTER TABLE `category`
  MODIFY `groupidx` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;