**字段新增**
**會員表：aijiacms_member**
| 字段名 | 字段類型 | 是否可空 | 默認值 | 字段描述 |
| ---------- | ------------ | -------- | ------ | -------------- |
| parentid | int(11) | yes | | 推薦人 userid |
| houseid | int(11) | yes | | 推薦樓盤itemid |
| people | int(11) | no | 0 | 邀請人數 |
| commission | float(10,2) | no | 0 | 累計獲得傭金 |
| roleid | int(10) | no | 0 | 角色ID |
| houseids | varchar(500) | no | | 權限樓盤ID |
```
ALTER TABLE aijiacms_member ADD COLUMN `parentid` int(11);
ALTER TABLE aijiacms_member ADD COLUMN `houseid` int(11);
ALTER TABLE aijiacms_member ADD COLUMN `people` int(11) NOT NULL DEFAULT 0;
ALTER TABLE aijiacms_member ADD COLUMN `commission` float(10,2) NOT NULL DEFAULT 0;
ALTER TABLE aijiacms_member ADD COLUMN `roleid` int(10) NOT NULL DEFAULT 0;
ALTER TABLE aijiacms_member ADD COLUMN `houseids` varchar(500) NOT NULL DEFAULT 0;
ALTER TABLE aijiacms_member ADD COLUMN `nun` varchar(50) NOT NULL DEFAULT '';
```
**分銷表：aijiacms_fenxiao**
| 字段名 | 字段類型 | 是否可空 | 默認值 | 字段描述 |
| ---------------- | ----------- | -------- | ------ | ------------------------- |
| shareid | int(11) | yes | | aijiacms_share_log 主鍵ID |
| tuijian_memberid | int(11) | no | | 推薦人會員ID |
| tuijian_mobile | varchar(50) | no | | 推薦人手機號 |
```
ALTER TABLE aijiacms_fenxiao ADD COLUMN `shareid` int(11) NOT NULL;
ALTER TABLE aijiacms_fenxiao ADD COLUMN `tuijian_memberid` int(11) NOT NULL;
ALTER TABLE aijiacms_fenxiao ADD COLUMN `tuijian_mobile` varchar(50) NOT NULL;
```
**表新增**
**分銷記錄表：aijiacms_fenxiao_log**
| 字段名 | 字段類型 | 是否可空 | 默認值 | 字段描述 |
| -------- | ------------- | -------- | ------ | ---------------------------------------------- |
| itemid | int(11) | no | | 主鍵ID |
| parentid | int(11) | no | | aijiacms_fenxiao itemid |
| status | tinyint(1) | no | | 0 待受理 1 已預約 2 已到訪 3 已交定金 4 已成交 |
| memberid | int(11) | no | | 操作人會員ID |
| datatime | int(11) | no | | 操作時間 |
| remark | varchar(2000) | yes | | 操作備注 |
| money | float(10,2) | no | 0 | 獲取傭金金額 |
```
create table `aijiacms_fenxiao_log` (
`itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`parentid` int(11) UNSIGNED NOT NULL,
`status` tinyint(1) UNSIGNED NOT NULL,
`memberid` int(11) UNSIGNED NOT NULL,
`datatime` int(11) UNSIGNED NOT NULL,
`remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL default '',
`money` float(10,2) NOT NULL default 0,
PRIMARY KEY (`itemid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;
```
會員招募 -> 已交定金
線上選房 -> 已成交
手動推薦 -> 待受理
**分享記錄表：aijiacms_share_log**
| 字段名 | 字段類型 | 是否可空 | 默認值 | 字段描述 |
| -------- | ---------- | -------- | ------ | --------------------------------- |
| itemid | int(11) | no | | 主鍵ID |
| houseid | int(11) | no | | 推薦樓盤itemid |
| memberid | int(11) | no | | 分享人會員ID |
| type | tinyint(1) | no | | 分享類型 1 手動推薦 2 鏈接 3 海報 |
| amount | int(11) | no | 0 | 推薦成功次數 |
```
create table `aijiacms_share_log` (
`itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`houseid` int(11) UNSIGNED NOT NULL,
`memberid` int(11) UNSIGNED NOT NULL,
`type` tinyint(1) UNSIGNED NOT NULL,
`amount` int(11) UNSIGNED NOT NULL,
PRIMARY KEY (`itemid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;
```
**權限角色表：aijiacms_role**
| 字段名 | 字段類型 | 是否可空 | 默認值 | 字段描述 |
| --------- | -------------------- | -------- | ------ | -------- |
| id | int(11) | no | | 主鍵ID |
| name | varchar(500) | no | | 角色名稱 |
| parentid | int(11) | No | 0 | 父ID |
| listorder | smallint(4) unsigned | no | 0 | |
| title | varchar(30) | no | | |
| url | varchar(255) | no | | |
| moduleid | smallint(6) | no | 0 | |
| file | varchar(20) | no | | |
| action | varchar(255) | no | | |
| catid | varchar(255) | no | | |
| style | varchar(50) | no | | |
| describe | varchar(500) | yes | | 角色描述 |
| datatime | int(11) | no | | 添加時間 |
```
create table `aijiacms_role` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(500) not null,
`parentid` int(11) UNSIGNED NOT NULL default 0,
`listorder` smallint(4) UNSIGNED NOT NULL default 0,
`title` varchar(30) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`moduleid` smallint(6) NOT NULL default 0,
`file` varchar(20) NOT NULL default '',
`action` varchar(255) NOT NULL default '',
`catid` varchar(255) NOT NULL default '',
`style` varchar(255) NOT NULL default '',
`describe` varchar(500) NOT NULL default '',
`datatime` int(11) UNSIGNED NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;
```
