數據庫有四個表，分別是：
一、用戶表
~~~
DROP TABLE IF EXISTS `pre_common_member`;
CREATE TABLE `pre_common_member` (
`uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`username` char(15) NOT NULL DEFAULT '',
`password` char(32) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '0',
`regdate` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
~~~
二、訂單表
~~~
DROP TABLE IF EXISTS `pre_tto_order`;
CREATE TABLE `pre_tto_order` (
`oid` int(20) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`tid` int(15) unsigned NOT NULL DEFAULT '0',
`ap` mediumint(8) unsigned NOT NULL DEFAULT '0',
`snick` char(15) NOT NULL DEFAULT '',
`bnick` char(15) NOT NULL DEFAULT '',
`stime` int(10) unsigned NOT NULL DEFAULT '0',
`etime` int(10) unsigned NOT NULL DEFAULT '0',
`oamount` decimal(10,2) NOT NULL DEFAULT '0.00',
`pamount` decimal(10,2) NOT NULL DEFAULT '0.00',
`damount` decimal(10,2) NOT NULL DEFAULT '0.00',
`trate` float NOT NULL DEFAULT '0.7',
`displayorder` tinyint(1) NOT NULL DEFAULT '0',
`remark` char(255) NOT NULL DEFAULT '0',
`onum` varchar(50) DEFAULT NULL,
PRIMARY KEY (`oid`),
KEY `uid` (`uid`),
KEY `tid` (`tid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
~~~
三、產品表
~~~
DROP TABLE IF EXISTS `pre_tto_template`;
CREATE TABLE `pre_tto_template` (
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`tid` int(15) unsigned NOT NULL DEFAULT '0',
`ttype` tinyint(1) NOT NULL DEFAULT '0',
`highlight` tinyint(1) NOT NULL DEFAULT '0',
`tname` char(50) NOT NULL DEFAULT '',
`pnick` char(15) NOT NULL DEFAULT '',
`dnick` char(15) NOT NULL DEFAULT '',
`onick1` char(15) NOT NULL DEFAULT '',
`onick2` char(15) NOT NULL DEFAULT '',
`puid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`duid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`ouid1` mediumint(8) unsigned NOT NULL DEFAULT '0',
`ouid2` mediumint(8) unsigned NOT NULL DEFAULT '0',
`prate` float NOT NULL DEFAULT '0',
`drate` float NOT NULL DEFAULT '0',
`orate1` float NOT NULL DEFAULT '0',
`orate2` float NOT NULL DEFAULT '0',
KEY `uid` (`uid`,`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
~~~
四、結算表
~~~
DROP TABLE IF EXISTS `pre_tto_account`;
CREATE TABLE `pre_tto_account` (
`aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`ap` mediumint(8) unsigned NOT NULL DEFAULT '0',
`anick` char(15) NOT NULL DEFAULT '',
`pstatus` tinyint(1) NOT NULL DEFAULT '0',
`amount` decimal(10,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
~~~
新建數據庫并填充測試數據。
建立數據表對應模型。
用戶模型
/apps/index/model/User.php
~~~
<?php
namespace app\index\model;
use think\Model;
class User extends Model
{
protected $name = 'common_member';
}
?>
~~~
產品模型
/apps/index/model/Template.php
~~~
<?php
namespace app\index\model;
use think\Model;
class Template extends Model
{
protected $name = 'tto_template';
}
?>
~~~
訂單模型
/apps/index/model/Order.php
~~~
<?php
namespace app\index\model;
use think\Model;
class Order extends Model
{
protected $name = 'tto_order';
}
?>
~~~
結算模型
/apps/index/model/Account.php
~~~
<?php
namespace app\index\model;
use think\Model;
class Account extends Model
{
protected $name = 'tto_account';
}
?>
~~~