structure.php
2.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
<?php
/**
* 应用的数据表结构文件
* structure.php
* $Author$
*/
return "
CREATE TABLE IF NOT EXISTS luoyanshou_luoyanshou(
u_id INT UNSIGNED NOT NULL auto_increment COMMENT '用户ID',
u_name VARCHAR(15) NOT NULL DEFAULT '姓名'COMMENT '用户名',
u_pwd VARCHAR(32) DEFAULT '' COMMENT '用户密码',
u_sex TINYINT UNSIGNED DEFAULT 0 COMMENT '用户性别',
u_mail VARCHAR(50) NULL COMMENT '邮箱',
u_tel VARCHAR(11) NULL COMMENT '电话',
`status` TINYINT DEFAULT 0 COMMENT '用户状态 0:有效 1:无效',
ins_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP() COMMENT '插入时间',
upd_date TIMESTAMP NULL COMMENT '修改时间',
PRIMARY KEY(`u_id`)
)ENGINE=INNODB DEFAULT charset=utf8;
CREATE TABLE IF NOT EXISTS luoyanshou_messages(
m_id INT UNSIGNED NOT NULL auto_increment COMMENT '留言ID',
m_title varchar(80) DEFAULT '' COMMENT '标题',
m_content VARCHAR(500) DEFAULT '' COMMENT '留言',
m_imgs VARCHAR(1000) DEFAULT '' COMMENT '图片路径',
m_ip varchar(20) DEFAULT '' COMMENT '留言IP',
m_status TINYINT UNSIGNED DEFAULT 1 COMMENT '1:未审核 2:已审核 3:已删除',
m_uid INT UNSIGNED NOT NULL COMMENT '用户ID',
m_domain VARCHAR(100) NULL DEFAULT '' COMMENT '企业标识',
ins_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP() COMMENT '留言时间',
upd_date TIMESTAMP NULL COMMENT '修改/删除时间',
PRIMARY KEY (`m_id`),
FOREIGN KEY(`m_uid`) REFERENCES luoyanshou(`u_id`) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=INNODB DEFAULT charset=utf8;
CREATE TABLE IF NOT EXISTS luoyanshou_attachment(
a_mid INT UNSIGNED NOT NULL COMMENT '留言ID',
a_path VARCHAR(200) DEFAULT '' COMMENT '附件路径',
a_status TINYINT UNSIGNED DEFAULT 0 COMMENT '0:未删除 1:已删除',
ins_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP() COMMENT '上传时间',
upd_date TIMESTAMP NULL COMMENT '修改/删除时间',
PRIMARY KEY(`a_mid`,`a_path`),
FOREIGN KEY(`a_mid`) REFERENCES luoyanshou_messages(`m_id`) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=INNODB DEFAULT charset=utf8;
CREATE TABLE IF NOT EXISTS luoyanshou_comment(
c_uid INT UNSIGNED NOT NULL COMMENT '评论用户ID',
c_mid INT UNSIGNED NOT NULL COMMENT '被评论留言ID',
c_comment VARCHAR(140) DEFAULT '' COMMENT '评论内容',
ins_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP() COMMENT '评论时间',
upd_date TIMESTAMP NULL COMMENT '修改时间',
FOREIGN KEY(`c_uid`) REFERENCES luoyanshou(`u_id`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY(`c_mid`) REFERENCES luoyanshou_messages(`m_id`) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=INNODB DEFAULT charset=utf8;
";