<?php echo 1 ?>
DROP TABLE IF EXISTS `#@__admin`;
CREATE TABLE `#@__admin` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` char(20) NOT NULL default '',
`pwd` char(32) NOT NULL default '',
`power_id` tinyint(3) unsigned NOT NULL default '1',
`power_lb` tinyint(1) unsigned NOT NULL default '0',
`lb_id` smallint(5) unsigned NOT NULL default '0',
`time` timestamp,
PRIMARY KEY (`id`),
UNIQUE INDEX (`name`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__admin_power`;
CREATE TABLE `#@__admin_power` (
`id` tinyint(3) unsigned NOT NULL,
`name` char(255) NOT NULL default '',
`content` text,
PRIMARY KEY (`id`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__admin_lb`;
CREATE TABLE `#@__admin_lb` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` char(255) NOT NULL default '',
PRIMARY KEY (`id`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__admin_log`;
CREATE TABLE `#@__admin_log` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` char(20) NOT NULL default '',
`operate` char(42) NOT NULL default '',
`file` char(21) NOT NULL default '',
`state` tinyint(1) unsigned NOT NULL default '0',
`time` timestamp,
`ip` int(10) unsigned NOT NULL default '0',
`port` smallint(5) unsigned NOT NULL default '0',
`referer` char(255) NOT NULL default '',
`ua` char(255) NOT NULL default '',
PRIMARY KEY (`id`),
INDEX (`name`),
INDEX (`operate`),
INDEX (`state`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__gg`;
CREATE TABLE `#@__gg` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` char(255) NOT NULL default '',
`content` text,
`gid` char(14) NOT NULL default '',
`tj` tinyint(1) NOT NULL default '0',
`yb` tinyint(1) NOT NULL default '0',
`type` tinyint(1) NOT NULL default '0',
`lei_id` int(10) unsigned NOT NULL default '1',
`zu_id` int(10) unsigned NOT NULL default '1',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
`href` char(255) NOT NULL default '',
`time` timestamp,
`admin_id` smallint(5) unsigned NOT NULL default '1',
`recycle` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
INDEX (`gid`),
INDEX (`tj`),
INDEX (`yb`),
INDEX (`type`),
INDEX (`lei_id`),
INDEX (`zu_id`),
INDEX (`admin_id`),
INDEX (`recycle`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__gg_template`;
CREATE TABLE `#@__gg_template` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` char(255) NOT NULL default '',
`content` text,
`admin_id` smallint(5) unsigned NOT NULL default '1',
`lb_id` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
INDEX (`admin_id`),
INDEX (`lb_id`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__upload`;
CREATE TABLE `#@__upload` (
`id` int(10) unsigned NOT NULL auto_increment,
`filename` char(255) NOT NULL default '',
`type` char(255) NOT NULL default '',
`size` int(10) unsigned NOT NULL default '0',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
`admin_id` smallint(5) unsigned NOT NULL default '1',
`lb_id` smallint(5) unsigned NOT NULL default '1',
`time` timestamp,
PRIMARY KEY (`id`),
INDEX (`admin_id`),
INDEX (`lb_id`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__lei`;
CREATE TABLE `#@__lei` (
`id` int(10) unsigned NOT NULL auto_increment,
`type` tinyint(1) NOT NULL default '1',
`admin_id` smallint(5) unsigned NOT NULL default '1',
`lb_id` smallint(5) unsigned NOT NULL default '1',
`name` char(60) NOT NULL default '',
PRIMARY KEY (`id`),
INDEX (`type`),
INDEX (`admin_id`),
INDEX (`lb_id`),
INDEX (`name`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__zu`;
CREATE TABLE `#@__zu` (
`id` int(10) unsigned NOT NULL auto_increment,
`type` tinyint(1) NOT NULL default '1',
`admin_id` smallint(5) unsigned NOT NULL default '1',
`lb_id` smallint(5) unsigned NOT NULL default '1',
`name` char(60) NOT NULL default '',
PRIMARY KEY (`id`),
INDEX (`type`),
INDEX (`admin_id`),
INDEX (`lb_id`),
INDEX (`name`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__ggcl`;
CREATE TABLE `#@__ggcl` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` char(255) NOT NULL default '',
`exp` char(255) NOT NULL default '',
`gid` char(14) NOT NULL default '',
`type` tinyint(1) NOT NULL default '0',
`weight` tinyint(2) unsigned NOT NULL default '0',
`gg` text,
`rotate_cl` tinyint(1) NOT NULL default '0',
`slide_interval` tinyint(3) unsigned NOT NULL default '0',
`time_cl` tinyint(1) NOT NULL default '0',
`time_content` text,
`limit_gg` tinyint(1) NOT NULL default '0',
`limit_gg_num` int(10) unsigned NOT NULL default '0',
`limit_visitor` tinyint(1) NOT NULL default '0',
`visitor_num` tinyint(3) unsigned NOT NULL default '0',
`os_cl` tinyint(1) NOT NULL default '0',
`os_content` char(255) NOT NULL default '',
`screen_cl` tinyint(1) NOT NULL default '0',
`screen_content` char(255) NOT NULL default '',
`browser_cl` tinyint(1) NOT NULL default '0',
`browser_content` char(255) NOT NULL default '',
`lang_cl` tinyint(1) NOT NULL default '0',
`lang_content` char(255) NOT NULL default '',
`referer_cl` tinyint(1) NOT NULL default '0',
`referer_content` text,
`url_cl` tinyint(1) NOT NULL default '0',
`url_content` text,
`local_cl` tinyint(1) NOT NULL default '0',
`local_content` text,
`ua_cl` tinyint(1) NOT NULL default '0',
`ua_content` text,
`lei_id` int(10) unsigned NOT NULL default '1',
`zu_id` int(10) unsigned NOT NULL default '1',
`time` timestamp,
`admin_id` smallint(5) unsigned NOT NULL default '1',
`recycle` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
INDEX (`gid`),
INDEX (`type`),
INDEX (`lei_id`),
INDEX (`zu_id`),
INDEX (`admin_id`),
INDEX (`recycle`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__ggw`;
CREATE TABLE `#@__ggw` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` char(255) NOT NULL default '',
`gid` char(14) NOT NULL default '',
`type` tinyint(1) NOT NULL default '0',
`ggcl` text,
`bjgg` char(30) NOT NULL default '',
`lei_id` int(10) unsigned NOT NULL default '1',
`zu_id` int(10) unsigned NOT NULL default '1',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
`time` timestamp,
`admin_id` smallint(5) unsigned NOT NULL default '1',
`recycle` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
INDEX (`gid`),
INDEX (`type`),
INDEX (`lei_id`),
INDEX (`zu_id`),
INDEX (`admin_id`),
INDEX (`recycle`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__ggws`;
CREATE TABLE `#@__ggws` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` char(255) NOT NULL default '',
`gid` char(14) NOT NULL default '',
`ggw` text,
`lei_id` int(10) unsigned NOT NULL default '1',
`zu_id` int(10) unsigned NOT NULL default '1',
`time` timestamp,
`admin_id` smallint(5) unsigned NOT NULL default '1',
`recycle` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
INDEX (`gid`),
INDEX (`lei_id`),
INDEX (`zu_id`),
INDEX (`admin_id`),
INDEX (`recycle`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__counter`;
CREATE TABLE `#@__counter` (
`id` int(10) unsigned NOT NULL auto_increment,
`time` timestamp,
`ac` tinyint(1) unsigned NOT NULL default '0',
`ip` int(10) unsigned NOT NULL default '0',
`po` smallint(5) unsigned NOT NULL default '0',
`os` char(20) NOT NULL default '',
`la` char(8) NOT NULL default '',
`bn` char(15) NOT NULL default '',
`bv` char(12) NOT NULL default '',
`fr` char(255) NOT NULL default '',
`ur` char(255) NOT NULL default '',
`sw` smallint(5) unsigned NOT NULL default '0',
`sh` smallint(5) unsigned NOT NULL default '0',
`vw` smallint(5) unsigned NOT NULL default '0',
`vh` smallint(5) unsigned NOT NULL default '0',
`dw` smallint(5) unsigned NOT NULL default '0',
`dh` smallint(5) unsigned NOT NULL default '0',
`dx` smallint(5) unsigned NOT NULL default '0',
`dy` smallint(5) unsigned NOT NULL default '0',
`mx` smallint(5) unsigned NOT NULL default '0',
`my` smallint(5) unsigned NOT NULL default '0',
`rx` smallint(5) unsigned NOT NULL default '0',
`ry` smallint(5) unsigned NOT NULL default '0',
`sc` smallint(5) unsigned NOT NULL default '0',
`co` tinyint(1) unsigned NOT NULL default '0',
`ggwid` int(10) unsigned NOT NULL default '0',
`ggwx` smallint(5) unsigned NOT NULL default '0',
`ggwy` smallint(5) unsigned NOT NULL default '0',
`ggww` smallint(5) unsigned NOT NULL default '0',
`ggwh` smallint(5) unsigned NOT NULL default '0',
`ggid` int(10) unsigned NOT NULL default '0',
`ggsn` smallint(5) unsigned NOT NULL default '0',
`ggsn1` smallint(5) unsigned NOT NULL default '0',
`ggsn2` smallint(5) unsigned NOT NULL default '0',
`ggcn` smallint(5) unsigned NOT NULL default '0',
`ggcn1` smallint(5) unsigned NOT NULL default '0',
`asn` smallint(5) unsigned NOT NULL default '0',
`asn1` smallint(5) unsigned NOT NULL default '0',
`acn` smallint(5) unsigned NOT NULL default '0',
`acn1` smallint(5) unsigned NOT NULL default '0',
`ua` char(255) NOT NULL default '',
PRIMARY KEY (`id`),
INDEX (`time`),
INDEX (`ggwid`),
INDEX (`ggid`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__statistics_01`;
CREATE TABLE `#@__statistics_01` (
`id` int(10) unsigned NOT NULL auto_increment,
`time` datetime,
`hour` smallint(10) unsigned NOT NULL default '0',
`num01` int(10) unsigned NOT NULL default '0',
`num02` int(10) unsigned NOT NULL default '0',
`num03` int(10) unsigned NOT NULL default '0',
`num04` int(10) unsigned NOT NULL default '0',
`num05` int(10) unsigned NOT NULL default '0',
`num06` int(10) unsigned NOT NULL default '0',
`num07` int(10) unsigned NOT NULL default '0',
`num08` int(10) unsigned NOT NULL default '0',
`num09` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
INDEX (`hour`)
)DEFAULT CHARACTER SET utf8;

DROP TABLE IF EXISTS `#@__statistics_02`;
CREATE TABLE `#@__statistics_02` (
`id` int(10) unsigned NOT NULL auto_increment,
`gg_id` smallint(10) unsigned NOT NULL default '0',
`ggw_id` smallint(10) unsigned NOT NULL default '0',
`date` date,
`num01` int(10) unsigned NOT NULL default '0',
`num02` int(10) unsigned NOT NULL default '0',
`num03` int(10) unsigned NOT NULL default '0',
`num04` int(10) unsigned NOT NULL default '0',
`num05` int(10) unsigned NOT NULL default '0',
`num06` int(10) unsigned NOT NULL default '0',
`num07` int(10) unsigned NOT NULL default '0',
`num08` int(10) unsigned NOT NULL default '0',
`num09` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
INDEX (`gg_id`),
INDEX (`ggw_id`)
)DEFAULT CHARACTER SET utf8;