本地开心农场如何建表?请祥告知，不胜感谢

安装说明
建表
CREATE TABLE `uchome_plug_newfarm` (
  `uid` mediumint(8) NOT NULL,
  `farmlandstatus` text character set utf8 NOT NULL,
  `animal` text character set utf8 NOT NULL,
  `taskid` int(2) NOT NULL default '1',
  `charm` int(10) NOT NULL default '0',
  `money` int(10) NOT NULL default '0',
  `exp` int(10) NOT NULL default '0',
  `mc_exp` int(10) NOT NULL default '0',
  `fb` int(10) NOT NULL default '0',
  `reclaim` smallint(2) NOT NULL default '6',
  `package` text character set utf8 NOT NULL,
  `mc_package` text character set utf8 NOT NULL,
  `fertilizer` text character set utf8 NOT NULL,
  `decorative` text character set utf8 NOT NULL,
  `fruit` text character set utf8 NOT NULL,
  `dog` text character set utf8 NOT NULL,
  `nosegay` text character set utf8 NOT NULL,
  `message` text character set utf8 NOT NULL,
  `mc_taskid` int(2) NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

买本书看看，因为这个东西实在是太基础了。

1# lifeixue

提醒楼主，您上面列的表少了两个子表！正确应该是如下：

1. 
   
2. CREATE TABLE `uchome_plug_newfarm` (
   
3.   `uid` mediumint(8) NOT NULL,
   
4.   `farmlandstatus` text character set utf8 NOT NULL,
   
5.   `animal` text character set utf8 NOT NULL,
   
6.   `taskid` int(2) NOT NULL default '1',
   
7.   `charm` int(10) NOT NULL default '0',
   
8.   `money` int(10) NOT NULL default '0',
   
9.   `exp` int(10) NOT NULL default '0',
   
10.   `mc_exp` int(10) NOT NULL default '0',
    
11.   `fb` int(10) NOT NULL default '0',
    
12.   `reclaim` smallint(2) NOT NULL default '6',
    
13.   `package` text character set utf8 NOT NULL,
    
14.   `mc_package` text character set utf8 NOT NULL,
    
15.   `fertilizer` text character set utf8 NOT NULL,
    
16.   `decorative` text character set utf8 NOT NULL,
    
17.   `fruit` text character set utf8 NOT NULL,
    
18.   `dog` text character set utf8 NOT NULL,
    
19.   `nosegay` text character set utf8 NOT NULL,
    
20.   `message` text character set utf8 NOT NULL,
    
21.   `mc_taskid` int(2) NOT NULL default '0',
    
22.   `mc_taskid1` int(2) NOT NULL default '0',
    
23.   `mc_log` text character set utf8 NOT NULL,
    
24.   PRIMARY KEY  (`uid`)
    
25. ) ENGINE=MyISAM DEFAULT CHARSET=gbk;
    

复制代码

去UCH数据库的SQL，贴上表运行即可～

打开phpmyadmin（在浏览器地址栏输入http://www.xxx.com/phpmyadmin/）,选择你的数据库，进入后在右面上部找到SQL，进入后将上述代码粘贴上去，然后点击执行就可以了。

谢谢各位了