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;