sbNNwULM

1-- --------------------------------------------------------
2
3--
4-- Table structure for table `posts`
5--
6
7CREATE TABLE IF NOT EXISTS `posts` (
8  `post_id` int(11) NOT NULL AUTO_INCREMENT,
9  `post_board` smallint(6) NOT NULL,
10  `post_parent` int(11) NOT NULL DEFAULT '0',
11  `post_name` varchar(255) NOT NULL,
12  `post_tripcode` varchar(30) NOT NULL,
13  `post_email` varchar(255) NOT NULL,
14  `post_subject` varchar(255) NOT NULL,
15  `post_message` text NOT NULL,
16  `post_password` varchar(255) NOT NULL,
17  `post_ip` varchar(100) NOT NULL,
18  `post_ip_md5` varchar(32) NOT NULL,
19  `post_tag` varchar(5) NOT NULL,
20  `post_timestamp` int(11) NOT NULL,
21  `post_stickied` smallint(6) DEFAULT '0',
22  `post_locked` smallint(6) DEFAULT '0',
23  `post_authority` smallint(6) DEFAULT '0',
24  `post_reviewed` smallint(6) DEFAULT '0',
25  `post_delete_time` int(11) NOT NULL DEFAULT '0',
26  `post_deleted` smallint(6) DEFAULT '0',
27  `post_bumped` int(11) NOT NULL DEFAULT '0',
28  PRIMARY KEY (`post_id`,`post_board`)
29) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=120 ;
30
31--
32-- Dumping data for table `posts`
33--
34
35
36-- --------------------------------------------------------
37
38--
39-- Table structure for table `post_files`
40--
41
42CREATE TABLE IF NOT EXISTS `post_files` (
43  `file_post` int(11) NOT NULL,
44  `file_board` smallint(6) NOT NULL,
45  `file_name` varchar(50) NOT NULL,
46  `file_md5` varchar(32) NOT NULL,
47  `file_type` varchar(20) NOT NULL,
48  `file_original` varchar(255) NOT NULL,
49  `file_size` int(11) NOT NULL DEFAULT '0',
50  `file_size_formatted` varchar(75) NOT NULL,
51  `file_image_width` smallint(6) DEFAULT '0',
52  `file_image_height` smallint(6) DEFAULT '0',
53  `file_thumb_width` smallint(6) DEFAULT '0',
54  `file_thumb_height` smallint(6) DEFAULT '0'
55) ENGINE=MyISAM DEFAULT CHARSET=utf8;