

CREATE TABLE `thth_admin` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `usertype` int(10) unsigned NOT NULL default '0',
  `userid` varchar(30) NOT NULL default '',
  `pwd` varchar(50) NOT NULL default '',
  `uname` varchar(20) NOT NULL default '',
  `typeid` int(10) unsigned NOT NULL default '0',
  `logintime` datetime NOT NULL default '0000-00-00 00:00:00',
  `loginip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;


INSERT INTO `thth_admin` (`ID`, `usertype`, `userid`, `pwd`, `uname`, `typeid`, `logintime`, `loginip`) VALUES (1, 10, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin', 0, '2007-12-02 13:50:20', '127.0.0.1');



CREATE TABLE `thth_art` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `typeid` int(10) unsigned NOT NULL default '0',
  `isdd` smallint(5) unsigned NOT NULL default '0',
  `redtitle` smallint(5) unsigned NOT NULL default '0',
  `ismake` smallint(5) unsigned NOT NULL default '0',
  `rank` smallint(5) NOT NULL default '0',
  `click` int(10) unsigned NOT NULL default '0',
  `picname` varchar(200) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `writer` varchar(50) NOT NULL default '',
  `source` varchar(50) NOT NULL default '',
  `msg` text NOT NULL,
  `stime` date NOT NULL default '0000-00-00',
  `likeid` varchar(250) NOT NULL default '',
  `body` mediumtext NOT NULL,
  `userid` int(10) unsigned NOT NULL default '0',
  `spec` int(10) unsigned NOT NULL default '0',
  `dtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `memberID` int(11) NOT NULL default '0',
  `outall` int(10) NOT NULL default '0',
  `outday` int(10) NOT NULL default '0',
  `inall` int(10) NOT NULL default '0',
  `inday` int(10) NOT NULL default '0',
  `inip` varchar(50) NOT NULL default '',
  `outip` varchar(50) NOT NULL default '',
  `indate` date NOT NULL default '0000-00-00',
  `outdate` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=128 DEFAULT CHARSET=latin1 AUTO_INCREMENT=128 ;


INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (118, 1, 0, 0, 0, 0, 1, '', 'ϷŴ˹ٷ', 'wdf', '', '555555555555555', '0000-00-00', '', 'http://44tt.net', 1, 0, '2008-04-13 00:12:19', 0, 4, 14, 0, 0, '', '127.0.0.1', '0000-00-00', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (117, 1, 0, 0, 0, 0, 0, '', 'asdfds', 'wdf', '', 'sadfds', '0000-00-00', '', 'http://asdfsdfds', 1, 0, '2008-04-12 23:58:39', 0, 1, 12, 0, 0, '', '127.0.0.1', '0000-00-00', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (119, 2, 0, 0, 0, 0, 0, '', '', 'wdf', '', 'ddd', '0000-00-00', '', 'http://55tt.net', 1, 0, '2008-04-13 00:12:31', 0, 1, 2, 0, 0, '', '127.0.0.1', '0000-00-00', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (120, 2, 0, 0, 0, 0, 1, '', 'ffffffffffff', 'wdf', '', 'fdff', '0000-00-00', '', 'http://fffffffffffff', 1, 0, '2008-04-13 21:52:12', 0, 15, 17, 0, 0, '', '127.0.0.1', '0000-00-00', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (121, 4, 0, 0, 0, 0, 0, '', 'ػ', '', '', '', '0000-00-00', '', 'http://localhost', 1, 0, '0000-00-00 00:00:00', 0, 2, 2, 8, 1, '127.0.0.1', '127.0.0.1', '2008-04-15', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (124, 2, 1, 0, 0, 0, 0, '/20080415/091826477lit.gif', 'sdaf', '', '', '', '2008-04-15', '', 'http://88tt.net', 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, '', '', '0000-00-00', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (123, 1, 1, 0, 0, 0, 0, '/20080415/092011512lit.gif', 'asdfsad', '', '', 'asdfsad', '2008-04-15', '', 'http://www.google.com', 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, '', '', '0000-00-00', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (125, 13, 0, 0, 0, 0, 0, '', '̳', 'im286', '', 'ggggggggggg', '2008-04-15', '', 'http://www.im286.com', 1, 0, '0000-00-00 00:00:00', 0, 1, 1, 0, 0, '', '127.0.0.1', '0000-00-00', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (126, 1, 0, 0, 0, 0, 0, '', 'asdfdsa', 'wdf', '', 'asdfdsaf', '0000-00-00', '', 'http://asdfsadfsda', 0, 0, '2008-04-15 09:45:18', 0, 0, 0, 0, 0, '', '', '0000-00-00', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (127, 1, 0, 0, 0, 0, 0, '', 'test', 'wdf', '', 'ttt', '0000-00-00', '', 'http://test', 0, 0, '2008-04-15 09:46:06', 0, 0, 0, 0, 0, '', '', '0000-00-00', '0000-00-00');
INSERT INTO `thth_art` (`ID`, `typeid`, `isdd`, `redtitle`, `ismake`, `rank`, `click`, `picname`, `title`, `writer`, `source`, `msg`, `stime`, `likeid`, `body`, `userid`, `spec`, `dtime`, `memberID`, `outall`, `outday`, `inall`, `inday`, `inip`, `outip`, `indate`, `outdate`) VALUES (128, 2, 0, 0, 0, 0, 0, '', 'վ', 'nihao', '', 'ddddd', '0000-00-00', '', 'http://www.sohu.com', 0, 0, '2008-04-15 10:42:12', 0, 0, 0, 0, 0, '', '', '0000-00-00', '0000-00-00');





CREATE TABLE `thth_arttype` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `reID` int(10) unsigned NOT NULL default '0',
  `typename` varchar(30) NOT NULL default '',
  `typedir` varchar(100) NOT NULL default '',
  `isdefault` smallint(6) NOT NULL default '0',
  `defaultname` varchar(30) NOT NULL default 'index.html',
  `issend` smallint(6) NOT NULL default '0',
  `channeltype` smallint(6) NOT NULL default '1',
  `modname` varchar(50) NOT NULL default 'Ĭģ',
  `maxpage` int(11) NOT NULL default '-1',
  `ispart` smallint(6) NOT NULL default '0',
  `description` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=latin1 AUTO_INCREMENT=96 ;



INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (1, 0, 'Ƶ', '1', 0, 'index.html', 0, 1, 'Ĭģ', 100, 0, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (2, 0, 'ѵӰ', '2', 1, 'index.html', 0, 1, 'Ĭģ', 100, 0, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (3, 0, 'ͼƬֽ', '3', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (4, 0, 'MP3', '4', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (5, 0, 'ѧС˵', '5', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (6, 0, '', '6', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (7, 0, 'ַ', '7', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (8, 0, '̳', '8', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (9, 0, 'Ϸش', '9', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (10, 0, '˶', '10', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (11, 0, '齻', '11', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (12, 0, 'ҽƱ', '12', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');
INSERT INTO `thth_arttype` (`ID`, `reID`, `typename`, `typedir`, `isdefault`, `defaultname`, `issend`, `channeltype`, `modname`, `maxpage`, `ispart`, `description`) VALUES (13, 0, '', '13', 1, 'index.html', 0, 1, 'Ĭģ', 100, 1, '');



CREATE TABLE `thth_feedback` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `artID` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  `ip` varchar(20) NOT NULL default '',
  `msg` text NOT NULL,
  `ischeck` smallint(6) NOT NULL default '0',
  `dtime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE `thth_member` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL default '0',
  `pwd` varchar(32) NOT NULL default '',
  `uname` varchar(20) NOT NULL default '',
  `sex` smallint(5) unsigned NOT NULL default '1',
  `age` varchar(5) NOT NULL default '',
  `birthday` varchar(20) NOT NULL default 'logo/default.jpg',
  `weight` varchar(10) NOT NULL default '',
  `height` varchar(10) NOT NULL default '',
  `job` varchar(10) NOT NULL default '',
  `aera` varchar(30) default NULL,
  `city` varchar(250) NOT NULL default '',
  `myinfo` text,
  `mybb` varchar(250) NOT NULL default '',
  `tel` varchar(30) default NULL,
  `oicq` varchar(15) default NULL,
  `email` varchar(50) NOT NULL default '',
  `homepage` varchar(50) default NULL,
  `jointime` datetime NOT NULL default '0000-00-00 00:00:00',
  `joinip` varchar(20) NOT NULL default '',
  `logintime` datetime NOT NULL default '0000-00-00 00:00:00',
  `loginip` varchar(20) NOT NULL default '',
  `rank` smallint(5) unsigned NOT NULL default '0',
  `isup` smallint(6) NOT NULL default '0',
  `hits` int(12) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;



INSERT INTO `thth_member` (`ID`, `userid`, `pwd`, `uname`, `sex`, `age`, `birthday`, `weight`, `height`, `job`, `aera`, `city`, `myinfo`, `mybb`, `tel`, `oicq`, `email`, `homepage`, `jointime`, `joinip`, `logintime`, `loginip`, `rank`, `isup`, `hits`) VALUES (15, 'bbbb', '111111', 'ʯʴƵ', 91, '', 'logo/default.jpg', '', '', '', '', '', 'ӿƼѧӿƼѧӿƼѧӿƼѧ', 'ӿƼѧ', '23432432', '2343223', 'asdfsadf@asdf.com', 'http://', '2007-12-01 00:00:00', '127.0.0.1', '2007-12-01 23:29:09', '127.0.0.1', 0, 0, 74);
INSERT INTO `thth_member` (`ID`, `userid`, `pwd`, `uname`, `sex`, `age`, `birthday`, `weight`, `height`, `job`, `aera`, `city`, `myinfo`, `mybb`, `tel`, `oicq`, `email`, `homepage`, `jointime`, `joinip`, `logintime`, `loginip`, `rank`, `isup`, `hits`) VALUES (14, 'asdfsdds', '111111', 'ʯʴƵ', 91, '', 'logo/default.jpg', '', '', '', 'ԭ', '', 'asdfds', '', '23432432', '2343223', 'asdfsadf@asdf.com', 'http://', '2007-12-01 00:00:00', '127.0.0.1', '0000-00-00 00:00:00', '', 0, 0, 31);
INSERT INTO `thth_member` (`ID`, `userid`, `pwd`, `uname`, `sex`, `age`, `birthday`, `weight`, `height`, `job`, `aera`, `city`, `myinfo`, `mybb`, `tel`, `oicq`, `email`, `homepage`, `jointime`, `joinip`, `logintime`, `loginip`, `rank`, `isup`, `hits`) VALUES (9, 'ziserven', '11111111', 'ʯʴƵ', 91, '', 'logo/default.jpg', '', '', '', 'ԭ', '', 'sadfs', '', '23432432', '23324', 'asdfsadf@asdf.com', 'http://', '2007-11-30 20:12:38', '127.0.0.1', '2007-12-01 11:19:07', '127.0.0.1', 0, 0, 18);
INSERT INTO `thth_member` (`ID`, `userid`, `pwd`, `uname`, `sex`, `age`, `birthday`, `weight`, `height`, `job`, `aera`, `city`, `myinfo`, `mybb`, `tel`, `oicq`, `email`, `homepage`, `jointime`, `joinip`, `logintime`, `loginip`, `rank`, `isup`, `hits`) VALUES (10, 'ttttt', '1111111', 'ʯʴƵ', 91, '', 'logo/default.jpg', '', '', '', 'ԭ', '', 'asdfsa', '', '23432432', '2343223', 'asdfsadf@asdf.com', 'http://', '2007-11-30 00:00:00', '127.0.0.1', '0000-00-00 00:00:00', '', 0, 0, 4);
INSERT INTO `thth_member` (`ID`, `userid`, `pwd`, `uname`, `sex`, `age`, `birthday`, `weight`, `height`, `job`, `aera`, `city`, `myinfo`, `mybb`, `tel`, `oicq`, `email`, `homepage`, `jointime`, `joinip`, `logintime`, `loginip`, `rank`, `isup`, `hits`) VALUES (11, 'asdfdsa', '1111111', 'ʯʴƵ', 91, '', 'logo/default.jpg', '', '', '', 'ԭ', '', 'asdfds', '', '23432432', '2343223', 'asdfsadf@asdf.com', 'http://', '0000-00-00 00:00:00', '127.0.0.1', '0000-00-00 00:00:00', '', 0, 0, 1);
INSERT INTO `thth_member` (`ID`, `userid`, `pwd`, `uname`, `sex`, `age`, `birthday`, `weight`, `height`, `job`, `aera`, `city`, `myinfo`, `mybb`, `tel`, `oicq`, `email`, `homepage`, `jointime`, `joinip`, `logintime`, `loginip`, `rank`, `isup`, `hits`) VALUES (12, 'wefasdfsda', '111111', 'ʯʴƵ', 91, '', 'logo/default.jpg', '', '', '', 'ԭ', 'tttt', 'asdfsd', '', '23432432', '2343223', 'asdfsadf@asdf.com', 'http://', '2007-11-30 00:00:00', '127.0.0.1', '0000-00-00 00:00:00', '', 0, 0, 9);
INSERT INTO `thth_member` (`ID`, `userid`, `pwd`, `uname`, `sex`, `age`, `birthday`, `weight`, `height`, `job`, `aera`, `city`, `myinfo`, `mybb`, `tel`, `oicq`, `email`, `homepage`, `jointime`, `joinip`, `logintime`, `loginip`, `rank`, `isup`, `hits`) VALUES (13, 'asdfasdsafd', '111111', 'ʯʴƵ', 91, '', 'logo/default.jpg', '', '', '', 'ԭ', 'fffff', 'afadssa', '', '23432432', '2343223', 'asdfsadf@asdf.com', 'http://www.jeast.net.cn', '2007-11-30 00:00:00', '127.0.0.1', '0000-00-00 00:00:00', '', 0, 0, 33);



CREATE TABLE `thth_membertype` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `rank` smallint(10) NOT NULL default '0',
  `membername` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



