-- phpMyAdmin SQL Dump -- version 2.11.4 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2008 年 07 月 03 日 02:32 -- 服务器版本: 5.0.51 -- PHP 版本: 5.2.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- 数据库: `orbit` -- -- -------------------------------------------------------- -- -- 表的结构 `checker` -- CREATE TABLE IF NOT EXISTS `checker` ( `checker_id` int(11) unsigned NOT NULL auto_increment, `email` varchar(200) collate latin1_general_ci NOT NULL, `checker_pass` varchar(32) collate latin1_general_ci NOT NULL default '', `checker_time` int(11) NOT NULL, `checker_ip` varchar(15) collate latin1_general_ci NOT NULL, `role` tinyint(1) NOT NULL default '0', `nickname` varchar(255) collate latin1_general_ci NOT NULL, PRIMARY KEY (`checker_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=12 ; -- -- 导出表中的数据 `checker` -- INSERT INTO `checker` (`checker_id`, `email`, `checker_pass`, `checker_time`, `checker_ip`, `role`, `nickname`) VALUES (10, 'adfa@asdd.com', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 1214964187, '127.0.0.1', 0, 'aaaaaa'), (11, 'asdfas@dsd.com', '96e79218965eb72c92a549dd5a330112', 1214992446, '10.4.0.76', 1, 'nengwu'), (9, 'xuele@sdd.com', '87e0b4a117f7252316075ff5524849f2', 1214377752, '10.4.0.24', 1, 'xulei'), (6, 'lick@dd.com', '96e79218965eb72c92a549dd5a330112', 1214364591, '127.0.0.1', 0, 'lick'); -- -------------------------------------------------------- -- -- 表的结构 `language` -- CREATE TABLE IF NOT EXISTS `language` ( `language_id` int(11) unsigned NOT NULL auto_increment, `language_name` varchar(200) collate latin1_general_ci NOT NULL default '', `shorthand` varchar(32) collate latin1_general_ci NOT NULL default '', `label` int(8) NOT NULL, PRIMARY KEY (`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=146 ; -- -- 导出表中的数据 `language` -- INSERT INTO `language` (`language_id`, `language_name`, `shorthand`, `label`) VALUES (1, 'Afrikaans', 'afk', 1252), (2, 'Arabic (Saudi Arabia)', 'ara', 0), (3, 'Arabic (Lebanon)', 'arb', 0), (4, 'Arabic (Egypt)', 'are', 0), (5, 'Arabic (Algeria)', 'arg', 0), (6, 'Arabic (Bahrain)', 'arh', 0), (7, 'Arabic (Iraq)', 'ari', 0), (8, 'Arabic (Jordan)', 'arj', 0), (9, 'Arabic (Kuwait)', 'ark', 0), (10, 'Arabic (Libya)', 'arl', 0), (11, 'Arabic (Morocco)', 'arm', 0), (12, 'Arabic (Oman)', 'aro', 0), (13, 'Arabic (Qatar)', 'arq', 0), (14, 'Arabic (Syria)', 'ars', 0), (15, 'Arabic (Tunisia)', 'art', 0), (16, 'Arabic (U.A.E.)', 'aru', 0), (17, 'Arabic (Yemen)', 'ary', 0), (18, 'Azeri (Cyrillic)', 'aze', 0), (19, 'Azeri (Latin)', 'azl', 0), (20, 'Belarusian', 'bel', 0), (21, 'Bulgarian', 'bgr', 0), (22, 'Breton (France)', 'brf', 0), (23, 'Catalan', 'cat', 0), (24, 'Chinese (PRC)', 'chs', 0), (25, 'Chinese (Taiwan)', 'cht', 0), (26, 'Cornish (United Kingdom)', 'cor', 0), (27, 'Czech', 'csy', 0), (28, 'Welsh (United Kingdom)', 'cym', 0), (29, 'Danish', 'dan', 0), (30, 'German (Austria)', 'dea', 0), (31, 'German (Liechtenstein)', 'dec', 0), (32, 'German (Luxembourg)', 'del', 0), (33, 'German (Switzerland)', 'des', 0), (34, 'German (Germany)', 'deu', 0), (35, 'Divehi', 'div', 0), (36, 'Greek', 'ell', 0), (37, 'English (Australia)', 'ena', 0), (38, 'English (Caribbean)', 'enb', 0), (39, 'English (Canada)', 'enc', 0), (40, 'English (United Kingdom)', 'eng', 0), (41, 'English (Ireland)', 'eni', 0), (42, 'English (Jamaica)', 'enj', 0), (43, 'English (Belize)', 'enl', 0), (44, 'English (Philippines)', 'enp', 0), (45, 'English (South Africa)', 'ens', 0), (46, 'English (Trinidad)', 'ent', 0), (47, 'English (United States)', 'enu', 0), (48, 'English (Zimbabwe)', 'enw', 0), (49, 'English (New Zealand)', 'enz', 0), (50, 'Esperanto', 'eox', 0), (51, 'Spanish (Panama)', 'esa', 0), (52, 'Spanish (Bolivia)', 'esb', 0), (53, 'Spanish (Costa Rica)', 'esc', 0), (54, 'Spanish (Dominican Republic)', 'esd', 0), (55, 'Spanish (El Salvador)', 'ese', 0), (56, 'Spanish (Ecuador)', 'esf', 0), (57, 'Spanish (Guatemala)', 'esg', 0), (58, 'Spanish (Honduras)', 'esh', 0), (59, 'Spanish (Nicaragua)', 'esi', 0), (60, 'Spanish (Chile)', 'esl', 0), (61, 'Spanish (Mexico)', 'esm', 0), (62, 'Spanish (International Sort)', 'esn', 0), (63, 'Spanish (Colombia)', 'eso', 0), (64, 'Spanish (Traditional Sort)', 'esp', 0), (65, 'Spanish (Peru)', 'esr', 0), (66, 'Spanish (Argentina)', 'ess', 0), (67, 'Spanish (Puerto Rico)', 'esu', 0), (68, 'Spanish (Venezuela)', 'esv', 0), (69, 'Spanish (Uruguay)', 'esy', 0), (70, 'Spanish (Paraguay)', 'esz', 0), (71, 'Estonian', 'eti', 0), (72, 'Basque', 'euq', 0), (73, 'Farsi', 'far', 0), (74, 'Finnish', 'fin', 0), (75, 'Faeroese', 'fos', 0), (76, 'French (France)', 'fra', 0), (77, 'French (Belgium)', 'frb', 0), (78, 'French (Canada)', 'frc', 0), (79, 'French (Luxembourg)', 'frl', 0), (80, 'French (Monaco)', 'frm', 0), (81, 'French (Switzerland)', 'frs', 0), (82, 'Irish Gaelic', 'gae', 0), (83, 'Scots Gaelic', 'gdh', 0), (84, 'Manx Gaelic', 'gdv', 0), (85, 'Galician', 'glc', 0), (86, 'Gujarati', 'guj', 0), (87, 'Hebrew', 'heb', 0), (88, 'Hindi', 'hin', 0), (89, 'Croatian', 'hrv', 0), (90, 'Hungarian', 'hun', 0), (91, 'Armenian', 'hye', 0), (92, 'Indonesian', 'ind', 0), (93, 'Icelandic', 'isl', 0), (94, 'Italian (Italy)', 'ita', 0), (95, 'Italian (Switzerland)', 'its', 0), (96, 'Japanese', 'jpn', 0), (97, 'Kannada', 'kan', 0), (98, 'Georgian', 'kat', 0), (99, 'Kazakh', 'kkz', 0), (100, 'Konkani', 'knk', 0), (101, 'Korean', 'kor', 0), (102, 'Kyrgyz (Cyrillic)', 'kyr', 0), (103, 'Lithuanian', 'lth', 0), (104, 'Latvian', 'lvi', 0), (105, 'Marathi', 'mar', 0), (106, 'FYRO Macedonian', 'mki', 0), (107, 'Mongolian (Cyrillic)', 'mon', 0), (108, 'Malay (Brunei Darussalam)', 'msb', 0), (109, 'Malay (Malaysia)', 'msl', 0), (110, 'Dutch (Belgium)', 'nlb', 0), (111, 'Dutch (Netherlands)', 'nld', 0), (112, 'Dutch (Surinam)', 'nls', 0), (113, 'Norwegian (Nynorsk)', 'non', 0), (114, 'Norwegian (Bokmal)', 'nor', 0), (115, 'Punjabi', 'pan', 0), (116, 'Polish', 'plk', 0), (117, 'Portuguese (Brazil)', 'ptb', 0), (118, 'Portuguese (Portugal)', 'ptg', 0), (119, 'Romanian', 'rom', 0), (120, 'Russian', 'rus', 0), (121, 'Sanskrit', 'san', 0), (122, 'Slovak', 'sky', 0), (123, 'Slovenian', 'slv', 0), (124, 'Albanian', 'sqi', 0), (125, 'Serbian (Cyrillic)', 'srb', 0), (126, 'Serbian (Latin)', 'srl', 0), (127, 'Swedish', 'sve', 0), (128, 'Swedish (Finland)', 'svf', 0), (129, 'Swahili', 'swk', 0), (130, 'Syriac', 'syr', 0), (131, 'Tamil', 'tam', 0), (132, 'Telugu', 'tel', 0), (133, 'Thai', 'tha', 0), (134, 'Turkish', 'trk', 0), (135, 'Tatar', 'ttt', 0), (136, 'Ukrainian', 'ukr', 0), (137, 'Urdu', 'urd', 0), (138, 'Uzbek (Cyrillic)', 'uzb', 0), (139, 'Uzbek (Latin)', 'uzl', 0), (140, 'Vietnamese', 'vit', 0), (141, 'Walon', 'wal', 0), (142, 'Chinese (Hong Kong S.A.R.)', 'zhh', 0), (143, 'Chinese (Singapore)', 'zhi', 0), (144, 'Chinese (Macau S.A.R.)', 'zhm', 0); -- -------------------------------------------------------- -- -- 表的结构 `path` -- CREATE TABLE IF NOT EXISTS `path` ( `path_id` int(11) unsigned NOT NULL auto_increment, `path_name` varchar(200) collate latin1_general_ci NOT NULL default '', `path_time` int(11) NOT NULL, `path_ip` varchar(15) collate latin1_general_ci NOT NULL, `orderby` int(11) NOT NULL, `user_id` int(11) NOT NULL, `shorthand` varchar(32) collate latin1_general_ci NOT NULL, `version` varchar(100) collate latin1_general_ci NOT NULL, `update_time` int(11) NOT NULL, `edit_time` int(11) NOT NULL, `download_num` int(11) NOT NULL, PRIMARY KEY (`path_id`), UNIQUE KEY `path_name` (`path_name`), UNIQUE KEY `shorthand` (`shorthand`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=12 ; -- -- 导出表中的数据 `path` -- INSERT INTO `path` (`path_id`, `path_name`, `path_time`, `path_ip`, `orderby`, `user_id`, `shorthand`, `version`, `update_time`, `edit_time`, `download_num`) VALUES (1, 'obcht.ini', 1213865146, '127.0.0.1', 0, 37, 'cht', '2.6.5', 1214384060, 1214377257, 0), (2, 'obara.ini', 1213865146, '127.0.0.1', 0, 37, 'ara', '2.6.5', 1214981123, 1214377235, 1), (3, 'obbgr.ini', 1213865146, '127.0.0.1', 0, 35, 'bgr', '2.6.5', 1214375513, 1214375475, 1), (4, 'obcat.ini', 1213865146, '127.0.0.1', 0, 35, 'cat', '2.6.5', 1214384048, 1214377286, 0), (5, 'obchs.ini', 1213865146, '127.0.0.1', 0, 21, 'chs', '2.6.5', 1213875146, 0, 0), (9, '', 0, '', 0, 0, '', '', 1214375747, 0, 0), (10, 'arb.ini', 1214905492, '10.4.0.24', 0, 27, 'arb', 'V2.7.1', 1214963591, 1214905492, 1), (11, 'obbel.ini', 1214904060, '127.0.0.1', 0, 22, 'bel', 'V2.7.1', 1214963882, 1214904060, 0); -- -------------------------------------------------------- -- -- 表的结构 `temp_path` -- CREATE TABLE IF NOT EXISTS `temp_path` ( `temp_path_id` int(11) unsigned NOT NULL auto_increment, `temp_path_name` varchar(200) collate latin1_general_ci NOT NULL default '', `temp_path_time` int(11) NOT NULL, `temp_path_ip` varchar(15) collate latin1_general_ci NOT NULL, `if_path` tinyint(1) NOT NULL default '0', `orderby` int(11) NOT NULL, `user_id` int(11) NOT NULL, `shorthand` varchar(32) collate latin1_general_ci NOT NULL, `version` varchar(100) collate latin1_general_ci NOT NULL, `checker_id` int(11) NOT NULL, `status` tinyint(1) NOT NULL, PRIMARY KEY (`temp_path_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=57 ; -- -- 导出表中的数据 `temp_path` -- INSERT INTO `temp_path` (`temp_path_id`, `temp_path_name`, `temp_path_time`, `temp_path_ip`, `if_path`, `orderby`, `user_id`, `shorthand`, `version`, `checker_id`, `status`) VALUES (25, 'cht2008062524.ini', 1214377276, '127.0.0.1', 0, 0, 35, 'cht', '2.6.5', 0, 0), (24, 'cat2008062523.ini', 1214377271, '127.0.0.1', 0, 0, 35, 'cat', '2.6.5', 0, 0), (29, 'cht2008062628.ini', 1214444440, '127.0.0.1', 0, 0, 22, 'cht', '2.6.5', 0, 0), (22, 'ara2008062521.ini', 1214377251, '127.0.0.1', 0, 0, 37, 'ara', '2.6.5', 0, 0), (21, 'cat2008062520.ini', 1214377245, '127.0.0.1', 0, 0, 37, 'cat', '2.6.5', 0, 0), (20, 'chs2008062519.ini', 1214377240, '127.0.0.1', 0, 0, 37, 'chs', '2.6.5', 0, 0), (28, 'afk2008062526.ini', 1214385194, '127.0.0.1', 0, 0, 22, 'afk', '2.6.5', 0, 0), (26, 'ara2008062525.ini', 1214377281, '127.0.0.1', 0, 0, 35, 'ara', '2.6.5', 0, 0), (30, 'cht2008062629.ini', 1214445033, '127.0.0.1', 0, 0, 22, 'cht', '2.6.5', 0, 0), (31, 'cht2008062630.ini', 1214445069, '127.0.0.1', 0, 0, 22, 'cht', '2.6.5', 0, 0), (32, 'cht2008062631.ini', 1214445276, '127.0.0.1', 0, 0, 22, 'cht', '2.6.5', 0, 0), (33, 'cht2008062632.ini', 1214445646, '127.0.0.1', 0, 0, 22, 'cht', '2.6.5', 0, 0), (34, 'cht2008062633.ini', 1214463614, '127.0.0.1', 0, 0, 38, 'cht', '2.6.5', 0, 0), (35, 'cht2008062634.ini', 1214463710, '127.0.0.1', 0, 0, 38, 'cht', '2.6.5', 0, 0), (36, 'afk2008062735.ini', 1214559796, '127.0.0.1', 0, 0, 22, 'afk', '2.6.5', 0, 0), (55, 'cht2008070254.ini', 1214982006, '127.0.0.1', 0, 0, 22, 'cht', 'V2.7.1', 0, 0), (54, 'cht2008070253.ini', 1214981906, '127.0.0.1', 0, 0, 22, 'cht', 'V2.7.1', 0, 0), (53, 'cht2008070252.ini', 1214981771, '127.0.0.1', 0, 0, 22, 'cht', 'V2.7.1', 0, 0), (52, 'cht2008070251.ini', 1214981676, '127.0.0.1', 0, 0, 22, 'cht', 'V2.7.1', 0, 0), (56, 'cat2008070355.ini', 1215049445, '127.0.0.1', 0, 0, 22, 'cat', 'V2.7.1', 0, 0); -- -------------------------------------------------------- -- -- 表的结构 `user` -- CREATE TABLE IF NOT EXISTS `user` ( `user_id` int(11) unsigned NOT NULL auto_increment, `email` varchar(200) collate latin1_general_ci NOT NULL, `user_pass` varchar(32) collate latin1_general_ci NOT NULL default '', `reg_time` int(11) NOT NULL, `reg_ip` varchar(15) collate latin1_general_ci NOT NULL, `status` tinyint(1) NOT NULL default '0', `desc` varchar(255) collate latin1_general_ci NOT NULL, `nickname` varchar(255) collate latin1_general_ci NOT NULL, `real_pwd` varchar(32) collate latin1_general_ci NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=40 ; -- -- 导出表中的数据 `user` -- INSERT INTO `user` (`user_id`, `email`, `user_pass`, `reg_time`, `reg_ip`, `status`, `desc`, `nickname`, `real_pwd`) VALUES (1, 'adsf@ff.cvom', '111111', 1213761620, '127.0.0.1', 0, '', 'sdf', ''), (2, 'adsf@ff.cvom', '96e79218965eb72c92a549dd5a330112', 1213767431, '127.0.0.1', 0, '', 'sdf', ''), (3, 'adsf@ff.cvom', '96e79218965eb72c92a549dd5a330112', 1213767457, '127.0.0.1', 0, '', 'sdf', ''), (4, 'adsf@ff.cvom', '96e79218965eb72c92a549dd5a330112', 1213767520, '127.0.0.1', 0, '', 'sdf', ''), (5, 'asdfa@d.com', 'b0baee9d279d34fa1dfd71aadb908c3f', 1213767634, '127.0.0.1', 0, '', '11111', ''), (6, 'aaa@dfd.com', '7fa8282ad93047a4d6fe6111c93b308a', 1213767730, '127.0.0.1', 0, '', '1111111', ''), (7, 'fasdfa@fd.com', '7fa8282ad93047a4d6fe6111c93b308a', 1213767751, '127.0.0.1', 0, '', 'fdgsadfas', ''), (8, 'fasdfa@fd.com', '7fa8282ad93047a4d6fe6111c93b308a', 1213767765, '127.0.0.1', 0, '', 'fdgsadfas', ''), (9, 'fasdfa@fd.com', '7fa8282ad93047a4d6fe6111c93b308a', 1213767794, '127.0.0.1', 0, '', 'fdgsadfas', ''), (10, 'fasdfa@fd.com', '7fa8282ad93047a4d6fe6111c93b308a', 1213767806, '127.0.0.1', 0, '', 'fdgsadfas', ''), (11, 'fasdfa@fd.com', '7fa8282ad93047a4d6fe6111c93b308a', 1213767814, '127.0.0.1', 0, '', 'fdgsadfas', ''), (12, 'adfasd@fdsgf.p', '96e79218965eb72c92a549dd5a330112', 1213767884, '127.0.0.1', 0, '', '212312', ''), (13, 'adfasd@fdsgf.p', '96e79218965eb72c92a549dd5a330112', 1213767900, '127.0.0.1', 0, '', '212312', ''), (14, 'asd@sd.com', '6168f305888c3d795e67c6de17bf8a21', 1213772010, '127.0.0.1', 0, '', 'asdfasdfasd', ''), (15, 'asdfa@dd.com', '9398108ce1775a3c79fc2afef9fb399f', 1213772458, '127.0.0.1', 0, '', 'sadfasfdsa', ''), (16, 'asdfasdf@sdd.com', '0203a0e1c9cf667158261a12ea2a2203', 1213778173, '127.0.0.1', 0, '', 'asdfasdf@sdd.com', ''), (17, 'fsadfas@dd.ocm', 'd7e6d69693f80ca6faf8368dfd368f7a', 1213778301, '127.0.0.1', 0, '', 'fsadfas@dd.ocm', ''), (18, 'asdfas@dd.com', '96e79218965eb72c92a549dd5a330112', 1213778665, '127.0.0.1', 0, '', '555555', ''), (19, 'fasdfa@fdd.com', '826f476f5b9138147ab6657e5051d25a', 1213778723, '127.0.0.1', 0, '', '2313213221', ''), (20, 'asdf@dd.com', '912ec803b2ce49e4a541068d495ab570', 1213780180, '127.0.0.1', 0, '', 'asdf', ''), (21, 'nengwu@1.com', '7fa8282ad93047a4d6fe6111c93b308a', 1213780273, '127.0.0.1', 0, '', 'shaka', ''), (22, 'lick@1sdfd.com', '96e79218965eb72c92a549dd5a330112', 1213780364, '127.0.0.1', 0, '', 'lick', ''), (23, 'asdfasd@ff.com', '7fa8282ad93047a4d6fe6111c93b308a', 1213842907, '127.0.0.1', 0, '', '4654654321321', ''), (24, 'asdfasdf@dd.com', 'cade22905595029c5472ea3f5dbdf543', 1213843056, '127.0.0.1', 0, '', 'sfsdfsgffdsgf', ''), (25, 'asdfas@dsfdd.com', '93862c560643de26d7dde4ccc83e50f4', 1213843361, '127.0.0.1', 0, '', 'safdasdf', ''), (26, 'sdfafaddsd@cc.com', '9c4152a1fa94efac3cc99c31419e549e', 1213861626, '127.0.0.1', 0, '', 'sdfafasdsf', ''), (27, 'lei_xu@globalnet-inc.com', '5055b261efb4e949643341a72adbf6f4', 1213866675, '10.4.0.24', 0, '', 'xulei', ''), (28, 'asdfasdf@dsdf.com', '963baa6c7cb6739a3b037a4216b1ab00', 1213927087, '127.0.0.1', 0, '', 'ssdfasdfasd', ''), (29, 'asdf@asdfasdf.com', '6a204bd89f3c8348afd5c77c717a097a', 1213943689, '127.0.0.1', 0, '', 'asdfasdf', ''), (30, 'asdfasdfa@dd.com', 'f61b26d635309536c3c83c0adc3cb972', 1213955139, '127.0.0.1', 0, '', 'asdfasdfa', ''), (31, 'sadfas@dd.com', 'b0baee9d279d34fa1dfd71aadb908c3f', 1214184289, '127.0.0.1', 0, '', '2132123132', ''), (32, 'asdfas@sdd.com', '96e79218965eb72c92a549dd5a330112', 1214212308, '127.0.0.1', 0, '', 'asdfasdfasdf', ''), (33, 'afadsf@dsd.com', '96e79218965eb72c92a549dd5a330112', 1214275220, '127.0.0.1', 0, '', '1321346465', ''), (34, 'asdfasdf@sdfd.com', '96e79218965eb72c92a549dd5a330112', 1214359221, '127.0.0.1', 0, '', '212453456', ''), (35, 'gods@sdf.com', '96e79218965eb72c92a549dd5a330112', 1214375448, '127.0.0.1', 0, '', 'gods', ''), (36, 'asdfas@dd.com', '96e79218965eb72c92a549dd5a330112', 1214377114, '127.0.0.1', 0, '', 'uuuu', ''), (37, 'uuuuuu@sdd.com', '8de1ebe5220196d6acdb486f346fe162', 1214377155, '127.0.0.1', 0, '', 'uuuuuu', ''), (38, 'handsome-wk@163.com', '186bca7826f8aeb9aa3eb12928329389', 1214463595, '127.0.0.1', 0, '', 'handsome-wk', ''), (39, 'handsome-wk@qq.com', '96e79218965eb72c92a549dd5a330112', 1215050707, '127.0.0.1', 0, '', 'toallick', '111111');