hutula2.sql

来自「采用模块化设计,自由组合文章,软件,论坛等模块,安装方便快捷 模板支持Dre」· SQL 代码 · 共 466 行 · 第 1/2 页

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;