hutula2.sql

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

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;