1. 在数据库中执行如下命令建立数据库:
create table cdb_plan(
pid int(10) unsigned NOT NULL,
operators varchar(100) NOT NULL default '',
applylimit int(4) unsigned NOT NULL default '0',
allowpet tinyint(1) unsigned NOT NULL default '0',
enddate int(10) unsigned NOT NULL default '0',
pointdate int(10) unsigned not null default '0',
PRIMARY KEY (pid)
) TYPE=MyISAM;
create table cdb_planapply(
pid int(10) unsigned NOT NULL,
uid int(10) unsigned NOT NULL,
malecount tinyint(2) unsigned NOT NULL default '0',
femalecount tinyint(2) unsigned NOT NULL default '0',
catcount tinyint(2) unsigned NOT NULL default '0',
dogcount tinyint(2) unsigned NOT NULL default '0',
phone varchar(30) NOT NULL default '',
memo varchar(255) NOT NULL default '',
applydate int(10) unsigned NOT NULL default '0',
confirm tinyint(1) unsigned NOT NULL default '0',
confirmdate int(10) unsigned NOT NULL default '0',
quitdate int(10) unsigned NOT NULL default '0',
point tinyint(2) unsigned NOT NULL default '0',
PRIMARY KEY (pid,uid),
KEY uid (uid)
) TYPE=MyISAM;
注意:cdb_可以替换成你系统设定的数据库前缀。
楼主,这个要如何操作?偶是菜鸟儿 |