hutula2.sql

采用模块化设计,自由组合文章,软件,论坛等模块,安装方便快捷 模板支持Dreamweaver可视化编辑,创建风格更为容易,专业

INSERT INTO `la_center_pv` (`name`, `p0`, `p1`, `p2`, `p3`, `p4`, `p5`, `p6`, `p7`, `p8`, `p9`, `p10`, `p11`, `p12`, `p13`, `p14`, `p15`, `p16`, `p17`, `p18`, `p19`) VALUES
('v_', 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('v0', 1, 15, 1, 0, 1, 0, 0, 1, 0, 1, 0, 0, 20, 1, 0, 1, 0, 0, 0, 0),
('v1', 1, 15, 1, 0, 1, 0, 0, 1, 0, 1, 0, 0, 30, 1, 0, 1, 0, 0, 0, 0),
('v2', 1, 15, 2, 0, 1, 0, 0, 1, 0, 1, 0, 0, 40, 1, 0, 2, 0, 0, 0, 0),
('v3', 1, 15, 3, 0, 1, 0, 0, 1, 0, 1, 0, 0, 50, 1, 0, 3, 0, 0, 0, 0),
('v4', 1, 15, 4, 0, 1, 0, 0, 1, 0, 1, 0, 0, 50, 1, 0, 4, 0, 0, 0, 0),
('v5', 1, 15, 5, 0, 1, 0, 0, 1, 0, 1, 0, 0, 50, 1, 0, 5, 0, 0, 0, 0),
('v6', 1, 15, 6, 0, 1, 0, 0, 1, 0, 1, 0, 0, 50, 1, 0, 6, 0, 0, 0, 0),
('v7', 1, 15, 7, 0, 1, 0, 0, 1, 0, 1, 0, 0, 50, 1, 0, 7, 0, 0, 0, 0),
('v8', 1, 15, 8, 0, 1, 0, 0, 1, 0, 1, 0, 0, 50, 1, 0, 8, 0, 0, 0, 0),
('a1', 1, 0, 50, 1, 1, 1, 1, 1, 1, 1, 1, 1, 100, 1, 1, 10, 0, 0, 0, 0),
('a2', 1, 0, 50, 1, 1, 1, 1, 1, 1, 1, 1, 1, 100, 1, 1, 10, 0, 0, 0, 0),
('a3', 1, 0, 50, 1, 1, 1, 1, 1, 1, 1, 1, 1, 100, 1, 1, 10, 0, 0, 0, 0),
('a4', 1, 0, 50, 1, 1, 1, 1, 1, 1, 1, 1, 1, 100, 1, 1, 10, 0, 0, 0, 0),
('a5', 1, 0, 50, 1, 1, 1, 1, 1, 1, 1, 1, 1, 100, 1, 1, 10, 0, 0, 0, 0);

CREATE TABLE `la_center_titles` (
  `tid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `lid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `author` varchar(18) NOT NULL,
  `lastptime` int(10) NOT NULL DEFAULT '0',
  `lastauthor` varchar(18) NOT NULL,
  `ptime` int(10) unsigned NOT NULL DEFAULT '0',
  `utime` int(10) unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL,
  `stitle` varchar(255) NOT NULL,
  `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',
  `f_twt` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `f_link` 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',
  `state` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `annex` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `attrib` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `reply` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `hits` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `downs` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `mark` varchar(60) NOT NULL DEFAULT '0,0,0,0,0,0,0,0',
  `tongs` varchar(120) NOT NULL,
  PRIMARY KEY (`tid`),
  KEY `authorid` (`authorid`),
  KEY `ptime` (`ptime`),
  KEY `f_link` (`f_link`),
  KEY `lid` (`lid`),
  KEY `downs` (`downs`),
  KEY `f_twt` (`f_twt`),
  FULLTEXT KEY `stitle` (`stitle`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `la_center_tpl` (
  `name` varchar(20) NOT NULL,
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `la_center_tpl` (`name`) VALUES
('default');

CREATE TABLE `la_center_users` (
  `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(12) NOT NULL,
  `password` varchar(32) NOT NULL,
  `face` varchar(5) NOT NULL,
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `regdate` int(10) unsigned NOT NULL DEFAULT '0',
  `postnum` int(10) unsigned NOT NULL DEFAULT '0',
  `a` int(10) NOT NULL DEFAULT '0',
  `b` int(10) NOT NULL DEFAULT '0',
  `c` int(10) NOT NULL DEFAULT '0',
  `d` int(10) NOT NULL DEFAULT '0',
  `h1` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h2` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h3` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h4` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h5` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `bb1` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bb2` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bb3` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bb4` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bb5` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `newmsg` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `regip` varchar(15) NOT NULL,
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `lasttime` int(10) unsigned NOT NULL DEFAULT '0',
  `lastip` varchar(15) NOT NULL,
  `signa` varchar(255) NOT NULL,
  `blank` int(10) unsigned NOT NULL DEFAULT '0',
  `admin` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `pw_w` varchar(30) NOT NULL,
  `pw_d` varchar(30) NOT NULL,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `name` (`name`),
  KEY `lasttime` (`lasttime`),
  KEY `postnum` (`postnum`),
  KEY `a` (`a`),
  KEY `b` (`b`),
  KEY `c` (`c`),
  KEY `d` (`d`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `la_center_ycode` (
  `id` tinyint(2) NOT NULL,
  `code` varchar(20) NOT NULL,
  `num` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `la_center_ycode` (`id`, `code`, `num`) VALUES
(1, 'abcd-1234', 10),
(2, '', 10),
(3, '', 10),
(4, '', 10),
(5, '', 10),
(6, '', 10),
(7, '', 10),
(8, '', 10),
(9, '', 10),
(10, '', 10);

CREATE TABLE `la_index_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_index_config` (`id`, `value`, `explain`) VALUES
(1, '[e,24,10]', ''),
(2, '[a,12,5][b,12,5]', ''),
(3, '[d,24,5]', ''),
(4, '24', ''),
(5, '18', ''),
(6, '6', ''),
(7, '090508', '');

CREATE TABLE `la_adcode_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_adcode_config` (`id`, `value`, `explain`) VALUES
(1, '', ''),
(2, '广告维护中...', ''),
(3, '20', ''),
(4, '10', ''),
(5, '090508', '');

CREATE TABLE `la_adcode_lists` (
  `fid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `admins` varchar(255) NOT NULL,
  `c` varchar(255) NOT NULL,
  `zu` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `xu` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `h1` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h2` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h3` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h4` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h5` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `level` tinyint(2) NOT NULL DEFAULT '-1',
  `a1` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `a2` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `a3` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `a4` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `a5` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `titles` int(10) unsigned NOT NULL DEFAULT '0',
  `admint` tinyint(2) unsigned NOT NULL DEFAULT '1',
  `v` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `v_` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ha` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `la_adcode_lists` (`fid`, `name`, `admins`, `c`, `zu`, `xu`, `h1`, `h2`, `h3`, `h4`, `h5`, `level`, `a1`, `a2`, `a3`, `a4`, `a5`, `titles`, `admint`, `v`, `v_`, `ha`) VALUES
(1, 'center', '', '', 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 20, 1, 0, 0, 0),
(2, 'index', '', '', 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 20, 1, 0, 0, 0);
CREATE TABLE `la_adcode_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',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `la_adcode_pv` (`name`, `p0`, `p1`, `p2`, `p3`, `p4`, `p5`, `p6`, `p7`, `p8`, `p9`) VALUES
('a1', 0, 1, 1, 1, 0, 1, 0, 0, 0, 0),
('a2', 0, 1, 1, 1, 0, 1, 0, 0, 0, 0),
('a3', 0, 1, 1, 1, 0, 1, 0, 0, 0, 0),
('a4', 0, 1, 1, 1, 0, 1, 0, 0, 0, 0),
('a5', 0, 1, 1, 1, 0, 1, 0, 0, 0, 0);

CREATE TABLE `la_adcode_titles` (
  `tid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `author` varchar(18) NOT NULL DEFAULT '',
  `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL,
  `stitle` varchar(255) NOT NULL,
  `etime` int(10) unsigned NOT NULL DEFAULT '0',
  `f_top` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `f_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`),
  KEY `id` (`id`),
  KEY `authorid` (`authorid`),
  KEY `etime` (`etime`),
  FULLTEXT KEY `stitle` (`stitle`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `la_center_gonline` (
  `gid` varchar(5) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `lasttime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`gid`),
  KEY `lasttime` (`lasttime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;