Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 9afe645fb3
Fetching contributors…

Cannot retrieve contributors at this time

file 65 lines (56 sloc) 1.891 kb
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65

DROP TABLE IF EXISTS `contents`;
CREATE TABLE `contents` (
  `idx` int(10) NOT NULL AUTO_INCREMENT,
  `c_id` varchar(100) NOT NULL,
  `c_type` varchar(10) NOT NULL,
  `s_name` varchar(30) NOT NULL,
  `c_info` text NOT NULL,
  `f_count` int(4) NOT NULL DEFAULT '0',
  `f_enable` enum('y','n') NOT NULL,
  `regdate` datetime NOT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `contents_search_status`;
CREATE TABLE `contents_search_status` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `c_idx` int(10) NOT NULL,
  `search_word` varchar(200) NOT NULL,
  `c` enum('y','n') NOT NULL,
  `d` enum('y','n') NOT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `favorites`;
CREATE TABLE `favorites` (
  `idx` int(10) NOT NULL AUTO_INCREMENT,
  `m_idx` int(10) NOT NULL,
  `c_idx` int(10) NOT NULL,
  `search_word` varchar(200) NOT NULL,
  `tags` varchar(500) DEFAULT NULL,
  `regdate` datetime NOT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `members`;
CREATE TABLE `members` (
  `idx` int(10) NOT NULL AUTO_INCREMENT,
  `nickname` varchar(20) DEFAULT NULL,
  `passwd` varchar(40) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `facebook_id` varchar(20) DEFAULT NULL,
  `twitter_id` varchar(20) DEFAULT NULL,
  `level` smallint(1) NOT NULL DEFAULT '9',
  `policy_agree` enum('y','n') NOT NULL DEFAULT 'n',
  `auto_key` varchar(40) DEFAULT NULL,
  `logindate` datetime DEFAULT NULL,
  `joindate` datetime DEFAULT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
  `idx` int(10) NOT NULL AUTO_INCREMENT,
  `f_idx` int(10) NOT NULL,
  `m_idx` int(10) NOT NULL,
  `tag` varchar(20) NOT NULL,
  PRIMARY KEY (`idx`),
  KEY `m_idx` (`m_idx`),
  KEY `f_idx` (`f_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Something went wrong with that request. Please try again.