1
CREATE TABLE IF NOT EXISTS `categories` (
2
`id` int(11) NOT NULL AUTO_INCREMENT,
3
`type` int(11) NOT NULL,
4
`name` varchar(50) NOT NULL,
5
`description` text NOT NULL,
6
`created_id` int(11) NOT NULL,
7
`created_time` int(11) NOT NULL,
9
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
12
-- --------------------------------------------------------
15
-- Table structure for table `details`
18
CREATE TABLE IF NOT EXISTS `details` (
19
`id` int(11) NOT NULL AUTO_INCREMENT,
20
`type` varchar(50) NOT NULL,
22
`lastedit_id` int(11) NOT NULL,
23
`lastedit_time` int(11) NOT NULL,
25
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
28
-- Dumping data for table `details`
31
INSERT INTO `details` (`id`, `type`, `text`, `lastedit_id`, `lastedit_time`) VALUES
32
(1, 'umokkum', '', 0, 0),
33
(2, 'admin_notebook', '', 0, 0);
35
-- --------------------------------------------------------
38
-- Table structure for table `ips`
41
CREATE TABLE IF NOT EXISTS `ips` (
42
`id` int(11) NOT NULL AUTO_INCREMENT,
43
`ip` varchar(28) NOT NULL,
44
`userid` int(11) NOT NULL,
45
`theme` varchar(200) NOT NULL,
46
`firstaction` int(11) NOT NULL,
47
`lastaction` int(11) NOT NULL,
48
`visit` int(11) NOT NULL,
50
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
54
-- --------------------------------------------------------
57
-- Table structure for table `log`
60
CREATE TABLE IF NOT EXISTS `log` (
61
`id` int(11) NOT NULL AUTO_INCREMENT,
63
`time` int(11) NOT NULL,
65
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
68
-- --------------------------------------------------------
71
-- Table structure for table `tutorials`
74
CREATE TABLE IF NOT EXISTS `tutorials` (
75
`id` int(11) NOT NULL AUTO_INCREMENT,
76
`name` varchar(100) NOT NULL,
77
`type` int(11) NOT NULL,
79
`description` varchar(150) NOT NULL,
80
`category` int(11) NOT NULL,
81
`created_id` int(11) NOT NULL,
82
`created_time` int(11) NOT NULL,
83
`lastedit_id` int(11) NOT NULL,
84
`lastedit_time` int(11) NOT NULL,
86
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
89
-- --------------------------------------------------------
92
-- Table structure for table `users`
95
CREATE TABLE IF NOT EXISTS `users` (
96
`id` int(11) NOT NULL AUTO_INCREMENT,
97
`username` varchar(32) NOT NULL,
98
`password` varchar(32) NOT NULL,
99
`fullname` varchar(100) NOT NULL,
100
`desc` text NOT NULL,
101
`signup_time` int(11) NOT NULL,
102
`signup_ip` varchar(32) NOT NULL,
103
`lastaction_time` int(11) NOT NULL,
104
`lastaction_ip` varchar(32) NOT NULL,
105
`admin` int(11) NOT NULL,
107
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
110
-- Dumping data for table `users`
113
INSERT INTO `users` (`id`, `username`, `password`, `fullname`, `desc`, `signup_time`, `signup_ip`, `lastaction_time`, `lastaction_ip`, `admin`) VALUES
114
(1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Admin', '0', , '0', 0, '0', 1),
116
-- --------------------------------------------------------
119
-- Table structure for table `utf8`
122
CREATE TABLE IF NOT EXISTS `utf8` (
123
`id` int(11) NOT NULL AUTO_INCREMENT,
124
`text` text NOT NULL,
125
`ip` varchar(50) NOT NULL,
126
`time` int(11) NOT NULL,
128
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;