CREATE TABLE `uchome_plug_newfarm` (
`uid` mediumint(8) NOT NULL,
`farmlandstatus` text NOT NULL,
`animal` text NOT NULL,
`taskid` int(2) NOT NULL default '1',
`charm` int(10) NOT NULL default '0',
`money` int(10) NOT NULL default '15000',
`exp` int(10) NOT NULL default '2000',
`mc_exp` int(10) NOT NULL default '0',
`fb` int(10) NOT NULL default '50',
`reclaim` smallint(2) NOT NULL default '6',
`package` text NOT NULL,
`mc_package` text NOT NULL,
`fertilizer` text NOT NULL,
`decorative` text NOT NULL,
`fruit` text NOT NULL,
`dog` text NOT NULL,
`nosegay` text NOT NULL,
`message` text NOT NULL,
`mc_taskid` int(2) NOT NULL default '0',
`mc_taskid1` int(2) NOT NULL default '0',
`wenzi` text NOT NULL,
`bad` int(10) NOT NULL default '0',
`mc_chat` text NOT NULL,
`log` text NOT NULL,
`repertory` text NOT NULL,
`parade` text NOT NULL,
`dabian` tinyint(3) unsigned NOT NULL default '0',
`badtime` int(11) NOT NULL default '0',
`mc_a` tinyint(3) unsigned NOT NULL default '0',
`sfeedleft` int(10) NOT NULL default '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
我查了查PHP文件,就 MUCAO1.PHP 有
<?php
/*
* 请将本文件改为英文名再在浏览器运行。
*/
include_once('../common.php');
$_SGLOBAL['db']->query("ALTER TABLE ".tname('plug_newfarm')." ADD `mc_taskid1` int(2) NOT NULL default '0';");
echo('ok');
?>
,其他地方没用到?是否这个字段是无用的??
mc_taskid 是判断任务进程的,后面加1这个用来干啥??
谢谢~~ |