?? hutula2.sql
字號:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE `la_admin_users` (
`uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(12) NOT NULL,
`password` varchar(32) NOT NULL,
`type` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `la_center_adv` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) NOT NULL,
`author` varchar(12) NOT NULL,
`message` varchar(255) NOT NULL,
`ptime` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `la_center_annexs` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`idt` varchar(3) NOT NULL,
`ids` mediumint(8) unsigned NOT NULL DEFAULT '0',
`author` varchar(12) NOT NULL,
`authorid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`ptime` int(10) unsigned NOT NULL DEFAULT '0',
`num` mediumint(8) unsigned NOT NULL DEFAULT '0',
`con` varchar(255) NOT NULL,
`con2` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`filetype` varchar(40) NOT NULL,
`type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`type2` tinyint(1) unsigned NOT NULL DEFAULT '0',
`size` int(10) NOT NULL DEFAULT '0',
`kit` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `ptime` (`ptime`),
KEY `authorid` (`authorid`),
KEY `type` (`type`),
KEY `idt` (`idt`),
KEY `ids` (`ids`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `la_center_bb` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(16) NOT NULL,
`a` smallint(5) unsigned NOT NULL DEFAULT '0',
`b` smallint(5) unsigned NOT NULL DEFAULT '0',
`c` smallint(5) unsigned NOT NULL DEFAULT '0',
`d` smallint(5) unsigned NOT NULL DEFAULT '0',
`stop` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `la_center_bb` (`id`, `name`, `a`, `b`, `c`, `d`, `stop`) VALUES
(1, '勛章1', 100, 0, 0, 0, 0),
(2, '勛章2', 0, 100, 0, 0, 0),
(3, '勛章3', 0, 0, 100, 0, 0),
(4, '勛章4', 0, 0, 0, 100, 0),
(5, '勛章5', 200, 0, 0, 0, 0),
(6, '勛章6', 0, 200, 0, 0, 0),
(7, '勛章7', 0, 0, 200, 0, 0),
(8, '勛章8', 0, 0, 0, 200, 0),
(9, '勛章9', 100, 100, 100, 100, 0),
(10, '勛章10', 200, 200, 200, 200, 0),
(11, '勛章11', 0, 0, 0, 0, 50),
(12, '勛章12', 0, 0, 0, 0, 100);
CREATE TABLE `la_center_config` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`value` text NOT NULL,
`explain` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `la_center_config` (`id`, `value`, `explain`) VALUES
(1, '', ''),
(2, 'default', ''),
(3, 'zh-CN', ''),
(4, '', ''),
(5, '系統維護中...', ''),
(6, '20', ''),
(7, '20', ''),
(8, '7', ''),
(9, 'upfiles', ''),
(10, '8', ''),
(11, '1', ''),
(12, 'admin,管理員', ''),
(13, 'rar,zip,gif,jpg,jpeg,png,mp3', ''),
(14, 'Hutula官方站', ''),
(15, '', ''),
(16, '090508', ''),
(17, '', ''),
(18, '本地下載,http://www.hutula.com', ''),
(19, '0', ''),
(20, '? 2007 - 2009 <a href="http://www.hutula.com">HUTULA</a>', ''),
(21, '', ''),
(22, '', ''),
(23, '', ''),
(24, '', ''),
(25, '18', ''),
(26, '1239891568', ''),
(27, '100', ''),
(28, '', '');
CREATE TABLE `la_center_evm` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`idt` varchar(3) NOT NULL,
`ids` mediumint(8) unsigned NOT NULL DEFAULT '0',
`type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`a` int(5) unsigned NOT NULL DEFAULT '0',
`b` int(5) unsigned NOT NULL DEFAULT '0',
`c` int(5) unsigned NOT NULL DEFAULT '0',
`d` int(5) unsigned NOT NULL DEFAULT '0',
`admin` varchar(12) NOT NULL,
`ptime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idt` (`idt`),
KEY `ids` (`ids`),
KEY `ptime` (`ptime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `la_center_evp` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`eid` varchar(20) NOT NULL,
`idt` varchar(3) NOT NULL,
`ids` mediumint(8) unsigned NOT NULL DEFAULT '0',
`admin` varchar(12) NOT NULL,
`ptime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idt` (`idt`),
KEY `ids` (`ids`),
KEY `ptime` (`ptime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `la_center_evu` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`eid` varchar(20) NOT NULL,
`mods` varchar(20) NOT NULL,
`ptime` int(10) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`admin` varchar(12) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `ptime` (`ptime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `la_center_level` (
`name` varchar(12) NOT NULL,
`v1` int(10) unsigned NOT NULL,
`v2` int(10) unsigned NOT NULL,
`v3` int(10) unsigned NOT NULL,
`v4` int(10) unsigned NOT NULL,
`v5` int(10) unsigned NOT NULL,
`v6` int(10) unsigned NOT NULL,
`v7` int(10) unsigned NOT NULL,
`v8` int(10) unsigned NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `la_center_level` (`name`, `v1`, `v2`, `v3`, `v4`, `v5`, `v6`, `v7`, `v8`) VALUES
('a', 0, 0, 0, 0, 0, 0, 0, 0),
('b', 0, 0, 0, 0, 0, 0, 0, 0),
('c', 0, 0, 0, 0, 0, 0, 0, 0),
('d', 0, 0, 0, 0, 0, 0, 0, 0),
('p', 100, 200, 500, 1000, 2000, 5000, 10000, 20000);
CREATE TABLE `la_center_mark` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`tid` mediumint(8) NOT NULL DEFAULT '0',
`uip` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `la_center_mods` (
`name` varchar(20) NOT NULL,
`paixu` tinyint(2) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `la_center_mods` (`name`, `paixu`) VALUES
('adcode', 0);
CREATE TABLE `la_center_posts` (
`pid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`tid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`author` varchar(18) NOT NULL DEFAULT '',
`authorid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`p_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ptime` int(10) unsigned NOT NULL DEFAULT '0',
`etime` int(10) unsigned NOT NULL DEFAULT '0',
`content` text NOT NULL,
`ip` varchar(15) NOT NULL,
`f_html` tinyint(1) unsigned NOT NULL DEFAULT '0',
`f_url` tinyint(1) unsigned NOT NULL DEFAULT '0',
`f_ubb` tinyint(1) unsigned NOT NULL DEFAULT '0',
`annex` tinyint(1) unsigned NOT NULL DEFAULT '0',
`attrib` tinyint(1) unsigned NOT NULL DEFAULT '0',
`m_a` int(10) NOT NULL DEFAULT '0',
`m_b` int(10) NOT NULL DEFAULT '0',
`m_c` int(10) NOT NULL DEFAULT '0',
`m_d` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`pid`),
KEY `tid` (`tid`),
KEY `authorid` (`authorid`),
KEY `ptime` (`ptime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `la_center_pv` (
`name` varchar(12) NOT NULL,
`p0` smallint(5) unsigned NOT NULL DEFAULT '0',
`p1` smallint(5) unsigned NOT NULL DEFAULT '0',
`p2` smallint(5) unsigned NOT NULL DEFAULT '0',
`p3` smallint(5) unsigned NOT NULL DEFAULT '0',
`p4` smallint(5) unsigned NOT NULL DEFAULT '0',
`p5` smallint(5) unsigned NOT NULL DEFAULT '0',
`p6` smallint(5) unsigned NOT NULL DEFAULT '0',
`p7` smallint(5) unsigned NOT NULL DEFAULT '0',
`p8` smallint(5) unsigned NOT NULL DEFAULT '0',
`p9` smallint(5) unsigned NOT NULL DEFAULT '0',
`p10` smallint(5) unsigned NOT NULL DEFAULT '0',
`p11` smallint(5) unsigned NOT NULL DEFAULT '0',
`p12` smallint(5) unsigned NOT NULL DEFAULT '0',
`p13` smallint(5) unsigned NOT NULL DEFAULT '0',
`p14` smallint(5) unsigned NOT NULL DEFAULT '0',
`p15` smallint(5) unsigned NOT NULL DEFAULT '0',
`p16` smallint(5) unsigned NOT NULL DEFAULT '0',
`p17` smallint(5) unsigned NOT NULL DEFAULT '0',
`p18` smallint(5) unsigned NOT NULL DEFAULT '0',
`p19` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -