数据库结构.txt

来自「本系统为六合彩网上投注系统」· 文本 代码 · 共 85 行

lottery 表
+------------+----------+------+-----+---------+-------+
| Field      | Type     | Null | Key | Default | Extra |
+------------+----------+------+-----+---------+-------+
| lotteryNum | int(20)  |      | PRI | 0       |       |
| qiNum      | int(20)  |      |     | 0       |       |
| oneNum     | int(10)  |      |     | 0       |       |
| twoNum     | int(10)  |      |     | 0       |       |
| threeNum   | int(10)  |      |     | 0       |       |
| fourNum    | int(10)  |      |     | 0       |       |
| fiveNum    | int(10)  |      |     | 0       |       |
| sixNum     | int(10)  |      |     | 0       |       |
| speNum     | int(10)  |      |     | 0       |       |
| username   | char(10) |      |     |         |       |
| zhuNum     | char(10) |      |     |         |       |
| zjlevel    | int(10)  | YES  |     | NULL    |       |
| zjMoney    | char(50) | YES  |     | NULL    |       |
+------------+----------+------+-----+---------+-------+
13 rows in set (0.29 sec)

userinfo 表
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| username | char(30) |      | PRI |         |       |
| password | char(30) |      |     |         |       |
| remain   | int(50)  |      |     | 0       |       |
+----------+----------+------+-----+---------+-------+
3 rows in set (0.07 sec)

admininfo 表
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| username | char(20) |      | PRI |         |       |
| password | char(20) |      |     |         |       |
+----------+----------+------+-----+---------+-------+
2 rows in set (0.04 sec)

nowQiNum 表
+----------+---------+------+-----+---------+-------+
| Field    | Type    | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+-------+
| nowQiNum | int(10) |      |     | 0       |       |
+----------+---------+------+-----+---------+-------+
1 row in set (0.04 sec)

result 表
+----------+---------+------+-----+---------+-------+
| Field    | Type    | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+-------+
| qiNum    | int(20) |      | PRI | 0       |       |
| oneNum   | int(10) |      |     | 0       |       |
| twoNum   | int(10) |      |     | 0       |       |
| threeNum | int(10) |      |     | 0       |       |
| fourNum  | int(10) |      |     | 0       |       |
| fiveNum  | int(10) |      |     | 0       |       |
| sixNum   | int(10) |      |     | 0       |       |
| speNum   | int(10) |      |     | 0       |       |
+----------+---------+------+-----+---------+-------+
8 rows in set (0.03 sec)

resultMoney 表
+------------+----------+------+-----+---------+-------+
| Field      | Type     | Null | Key | Default | Extra |
+------------+----------+------+-----+---------+-------+
| qiNum      | int(20)  |      | PRI | 0       |       |
| headMoney  | char(50) |      |     |         |       |
| twoMoney   | char(50) |      |     |         |       |
| threeMoney | char(50) |      |     |         |       |
| fourMoney  | char(30) |      |     |         |       |
| fiveMoney  | char(30) |      |     |         |       |
| sixMoney   | char(30) |      |     |         |       |
| sevenMoney | char(30) |      |     |         |       |
+------------+----------+------+-----+---------+-------+
8 rows in set (0.09 sec)

chip_in_message 表
+---------+----------+------+-----+---------+-------+
| Field   | Type     | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| message | char(20) |      |     |         |       |
+---------+----------+------+-----+---------+-------+
1 row in set (0.05 sec)