顺路把数据表的sql粘上,省得没了。- -- phpMyAdmin SQL Dump
- -- version 2.11.9.2
- -- http://www.phpmyadmin.net
- --
- -- 主机: 127.0.0.1:3306
- -- 生成日期: 2009 年 09 月 06 日 03:10
- -- 服务器版本: 5.1.28
- -- PHP 版本: 5.2.6
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- --
- -- 数据库: `discuz`
- --
- -- --------------------------------------------------------
- --
- -- 表的结构 `cdb_toxy_bag`
- --
- DROP TABLE IF EXISTS `cdb_toxy_bag`;
- CREATE TABLE IF NOT EXISTS `cdb_toxy_bag` (
- `pid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `pnum` smallint(6) NOT NULL DEFAULT '0',
- PRIMARY KEY (`pid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- 导出表中的数据 `cdb_toxy_bag`
- --
- -- --------------------------------------------------------
- --
- -- 表的结构 `cdb_toxy_ground`
- --
- DROP TABLE IF EXISTS `cdb_toxy_ground`;
- CREATE TABLE IF NOT EXISTS `cdb_toxy_ground` (
- `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `regdate` date NOT NULL DEFAULT '0000-00-00',
- `message` smallint(6) NOT NULL DEFAULT '0',
- `ex` int(10) NOT NULL DEFAULT '0',
- `bedate` date NOT NULL DEFAULT '0000-00-00',
- `beg` smallint(6) NOT NULL DEFAULT '0',
- `beb` smallint(6) NOT NULL DEFAULT '0',
- `date` date NOT NULL DEFAULT '0000-00-00',
- `grass` smallint(6) NOT NULL DEFAULT '0',
- `bug` smallint(6) NOT NULL DEFAULT '0',
- `background` char(10) NOT NULL DEFAULT 'bg1',
- `d1` char(10) NOT NULL DEFAULT 'lvdi',
- `p1` smallint(6) NOT NULL DEFAULT '0',
- `pt1` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn1` smallint(6) NOT NULL DEFAULT '0',
- `g1` smallint(1) NOT NULL DEFAULT '0',
- `b1` smallint(1) NOT NULL DEFAULT '0',
- `d2` char(10) NOT NULL DEFAULT 'lvdi',
- `p2` smallint(6) NOT NULL DEFAULT '0',
- `pt2` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn2` smallint(6) NOT NULL DEFAULT '0',
- `g2` smallint(1) NOT NULL DEFAULT '0',
- `b2` smallint(1) NOT NULL DEFAULT '0',
- `d3` char(10) NOT NULL DEFAULT 'lvdi',
- `p3` smallint(6) NOT NULL DEFAULT '0',
- `pt3` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn3` smallint(6) NOT NULL DEFAULT '0',
- `g3` smallint(1) NOT NULL DEFAULT '0',
- `b3` smallint(1) NOT NULL DEFAULT '0',
- `d4` char(10) NOT NULL DEFAULT 'lvdi',
- `p4` smallint(6) NOT NULL DEFAULT '0',
- `pt4` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn4` smallint(6) NOT NULL DEFAULT '0',
- `g4` smallint(1) NOT NULL DEFAULT '0',
- `b4` smallint(1) NOT NULL DEFAULT '0',
- `d5` char(10) NOT NULL DEFAULT 'lvdi',
- `p5` smallint(6) NOT NULL DEFAULT '0',
- `pt5` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn5` smallint(6) NOT NULL DEFAULT '0',
- `g5` smallint(1) NOT NULL DEFAULT '0',
- `b5` smallint(1) NOT NULL DEFAULT '0',
- `d6` char(10) NOT NULL DEFAULT 'lvdi',
- `p6` smallint(6) NOT NULL DEFAULT '0',
- `pt6` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn6` smallint(6) NOT NULL DEFAULT '0',
- `g6` smallint(1) NOT NULL DEFAULT '0',
- `b6` smallint(1) NOT NULL DEFAULT '0',
- `d7` char(10) NOT NULL DEFAULT 'lvdi',
- `p7` smallint(6) NOT NULL DEFAULT '0',
- `pt7` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn7` smallint(6) NOT NULL DEFAULT '0',
- `g7` smallint(1) NOT NULL DEFAULT '0',
- `b7` smallint(1) NOT NULL DEFAULT '0',
- `d8` char(10) NOT NULL DEFAULT 'lvdi',
- `p8` smallint(6) NOT NULL DEFAULT '0',
- `pt8` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn8` smallint(6) NOT NULL DEFAULT '0',
- `g8` smallint(1) NOT NULL DEFAULT '0',
- `b8` smallint(1) NOT NULL DEFAULT '0',
- `d9` char(10) NOT NULL DEFAULT 'lvdi',
- `p9` smallint(6) NOT NULL DEFAULT '0',
- `pt9` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn9` smallint(6) NOT NULL DEFAULT '0',
- `g9` smallint(1) NOT NULL DEFAULT '0',
- `b9` smallint(1) NOT NULL DEFAULT '0',
- `d10` char(10) NOT NULL DEFAULT 'lvdi',
- `p10` smallint(6) NOT NULL DEFAULT '0',
- `pt10` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn10` smallint(6) NOT NULL DEFAULT '0',
- `g10` smallint(1) NOT NULL DEFAULT '0',
- `b10` smallint(1) NOT NULL DEFAULT '0',
- `d11` char(10) NOT NULL DEFAULT 'lvdi',
- `p11` smallint(6) NOT NULL DEFAULT '0',
- `pt11` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn11` smallint(6) NOT NULL DEFAULT '0',
- `g11` smallint(1) NOT NULL DEFAULT '0',
- `b11` smallint(1) NOT NULL DEFAULT '0',
- `d12` char(10) NOT NULL DEFAULT 'lvdi',
- `p12` smallint(6) NOT NULL DEFAULT '0',
- `pt12` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn12` smallint(6) NOT NULL DEFAULT '0',
- `g12` smallint(1) NOT NULL DEFAULT '0',
- `b12` smallint(1) NOT NULL DEFAULT '0',
- `d13` char(10) NOT NULL DEFAULT 'lvdi',
- `u13` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `p13` smallint(6) NOT NULL DEFAULT '0',
- `pt13` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn13` smallint(6) NOT NULL DEFAULT '0',
- `g13` smallint(1) NOT NULL DEFAULT '0',
- `b13` smallint(1) NOT NULL DEFAULT '0',
- `d14` char(10) NOT NULL DEFAULT 'lvdi',
- `u14` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `p14` smallint(6) NOT NULL DEFAULT '0',
- `pt14` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn14` smallint(6) NOT NULL DEFAULT '0',
- `g14` smallint(1) NOT NULL DEFAULT '0',
- `b14` smallint(1) NOT NULL DEFAULT '0',
- `d15` char(10) NOT NULL DEFAULT 'lvdi',
- `u15` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `p15` smallint(6) NOT NULL DEFAULT '0',
- `pt15` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `pn15` smallint(6) NOT NULL DEFAULT '0',
- `g15` smallint(1) NOT NULL DEFAULT '0',
- `b15` smallint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`uid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- 导出表中的数据 `cdb_toxy_ground`
- --
- INSERT INTO `cdb_toxy_ground` (`uid`, `regdate`, `message`, `ex`, `bedate`, `beg`, `beb`, `date`, `grass`, `bug`, `background`, `d1`, `p1`, `pt1`, `pn1`, `g1`, `b1`, `d2`, `p2`, `pt2`, `pn2`, `g2`, `b2`, `d3`, `p3`, `pt3`, `pn3`, `g3`, `b3`, `d4`, `p4`, `pt4`, `pn4`, `g4`, `b4`, `d5`, `p5`, `pt5`, `pn5`, `g5`, `b5`, `d6`, `p6`, `pt6`, `pn6`, `g6`, `b6`, `d7`, `p7`, `pt7`, `pn7`, `g7`, `b7`, `d8`, `p8`, `pt8`, `pn8`, `g8`, `b8`, `d9`, `p9`, `pt9`, `pn9`, `g9`, `b9`, `d10`, `p10`, `pt10`, `pn10`, `g10`, `b10`, `d11`, `p11`, `pt11`, `pn11`, `g11`, `b11`, `d12`, `p12`, `pt12`, `pn12`, `g12`, `b12`, `d13`, `u13`, `p13`, `pt13`, `pn13`, `g13`, `b13`, `d14`, `u14`, `p14`, `pt14`, `pn14`, `g14`, `b14`, `d15`, `u15`, `p15`, `pt15`, `pn15`, `g15`, `b15`) VALUES
- (1, '0000-00-00', 0, 163, '0000-00-00', 0, 0, '0000-00-00', 0, 0, 'bg1', 'di1', 1, '0000-00-00 00:00:00', 0, 1, 0, 'di1', 0, '0000-00-00 00:00:00', 0, 0, 0, 'di1', 0, '0000-00-00 00:00:00', 0, 0, 0, 'di1', 0, '0000-00-00 00:00:00', 0, 0, 0, 'di1', 0, '0000-00-00 00:00:00', 0, 0, 0, 'di1', 0, '0000-00-00 00:00:00', 0, 0, 0, 'lvdi', 0, '0000-00-00 00:00:00', 0, 0, 0, 'lvdi', 0, '0000-00-00 00:00:00', 0, 0, 0, 'lvdi', 0, '0000-00-00 00:00:00', 0, 0, 0, 'lvdi', 0, '0000-00-00 00:00:00', 0, 0, 0, 'lvdi', 0, '0000-00-00 00:00:00', 0, 0, 0, 'lvdi', 0, '0000-00-00 00:00:00', 0, 0, 0, 'lvdi', 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 'lvdi', 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 'lvdi', 0, 0, '0000-00-00 00:00:00', 0, 0, 0);
- -- --------------------------------------------------------
- --
- -- 表的结构 `cdb_toxy_message`
- --
- DROP TABLE IF EXISTS `cdb_toxy_message`;
- CREATE TABLE IF NOT EXISTS `cdb_toxy_message` (
- `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `bdate` date NOT NULL DEFAULT '0000-00-00',
- `edate` date NOT NULL DEFAULT '0000-00-00',
- `biaoti` char(10) NOT NULL DEFAULT '',
- `neirong` char(10) NOT NULL DEFAULT '',
- `coin` smallint(6) NOT NULL DEFAULT '0',
- `exp` smallint(6) NOT NULL DEFAULT '0',
- `pid` smallint(6) NOT NULL DEFAULT '0',
- `pnum` smallint(6) NOT NULL DEFAULT '0',
- PRIMARY KEY (`mid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- 导出表中的数据 `cdb_toxy_message`
- --
- -- --------------------------------------------------------
- --
- -- 表的结构 `cdb_toxy_plant`
- --
- DROP TABLE IF EXISTS `cdb_toxy_plant`;
- CREATE TABLE IF NOT EXISTS `cdb_toxy_plant` (
- `pid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `pname` char(10) NOT NULL DEFAULT '',
- `pm` smallint(6) NOT NULL DEFAULT '0',
- `pnum` smallint(6) NOT NULL DEFAULT '0',
- `zprice` smallint(6) NOT NULL DEFAULT '0',
- `gprice` smallint(6) NOT NULL DEFAULT '0',
- `prm` smallint(6) NOT NULL DEFAULT '0',
- `prnum` smallint(6) NOT NULL DEFAULT '0',
- `pic` char(10) NOT NULL DEFAULT '',
- `prm1` smallint(6) NOT NULL DEFAULT '0',
- `pic1` char(10) NOT NULL DEFAULT '',
- `prm2` smallint(6) NOT NULL DEFAULT '0',
- `pic2` char(10) NOT NULL DEFAULT '',
- `prm3` smallint(6) NOT NULL DEFAULT '0',
- `pic3` char(10) NOT NULL DEFAULT '',
- `prm4` smallint(6) NOT NULL DEFAULT '0',
- `pic4` char(10) NOT NULL DEFAULT '',
- `prm5` smallint(6) NOT NULL DEFAULT '0',
- `pic5` char(10) NOT NULL DEFAULT '',
- PRIMARY KEY (`pid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- 导出表中的数据 `cdb_toxy_plant`
- --
- -- --------------------------------------------------------
- --
- -- 表的结构 `cdb_toxy_rank`
- --
- DROP TABLE IF EXISTS `cdb_toxy_rank`;
- CREATE TABLE IF NOT EXISTS `cdb_toxy_rank` (
- `rank` smallint(6) unsigned NOT NULL DEFAULT '0',
- `exp` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`rank`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- 导出表中的数据 `cdb_toxy_rank`
- --
- -- --------------------------------------------------------
- --
- -- 表的结构 `cdb_toxy_seed`
- --
- DROP TABLE IF EXISTS `cdb_toxy_seed`;
- CREATE TABLE IF NOT EXISTS `cdb_toxy_seed` (
- `pid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `pnum` smallint(6) NOT NULL DEFAULT '0',
- PRIMARY KEY (`pid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- 导出表中的数据 `cdb_toxy_seed`
- --
- -- --------------------------------------------------------
- --
- -- 表的结构 `cdb_toxy_steal`
- --
- DROP TABLE IF EXISTS `cdb_toxy_steal`;
- CREATE TABLE IF NOT EXISTS `cdb_toxy_steal` (
- `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `beuid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `dname` char(10) NOT NULL DEFAULT '',
- `date` date NOT NULL DEFAULT '0000-00-00',
- PRIMARY KEY (`uid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- 导出表中的数据 `cdb_toxy_steal`
- --
复制代码 |