structure.php
3.23 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
60
61
62
63
64
<?php
/**
* 应用的数据表结构文件
* structure.php
* $Author$
*/
return "
CREATE TABLE IF NOT EXISTS `luoyanshou_luoyanshou` (
`u_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`u_name` VARCHAR(15) NOT NULL DEFAULT '姓名' COMMENT '用户名',
`u_pwd` VARCHAR(32) DEFAULT NULL COMMENT '用户密码',
`u_sex` TINYINT(3) UNSIGNED DEFAULT '1' COMMENT '用户性别',
`u_mail` VARCHAR(50) DEFAULT NULL COMMENT '邮箱',
`u_tel` VARCHAR(11) DEFAULT NULL COMMENT '电话',
`status` TINYINT(4) DEFAULT '0' COMMENT '用户状态 0:有效 1:无效',
`domain` VARCHAR(200) DEFAULT NULL,
`ins_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '插入时间',
`upd_date` TIMESTAMP NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`u_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `luoyanshou_messages` (
`m_id` INT(10) 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(3) UNSIGNED DEFAULT '1' COMMENT '1:未审核 2:审核未通过 3:审核已通过 4:已删除',
`m_reason` VARCHAR(200) DEFAULT '' COMMENT '审核未通过原因',
`m_uid` INT(10) unsigned NOT NULL COMMENT '用户ID',
`domain` VARCHAR(200) DEFAULT NULL,
`ins_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '留言时间',
`m_updated` TIMESTAMP NULL DEFAULT NULL COMMENT '修改/删除时间',
PRIMARY KEY (`m_id`),
KEY `m_uid` (`m_uid`),
CONSTRAINT `luoyanshou_messages_ibfk_1` FOREIGN KEY (`m_uid`) REFERENCES `luoyanshou_luoyanshou` (`u_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `luoyanshou_attachment` (
`a_mid` INT(10) UNSIGNED NOT NULL COMMENT '留言ID',
`a_path` VARCHAR(200) NOT NULL DEFAULT '' COMMENT '附件路径',
`a_status` TINYINT(3) UNSIGNED DEFAULT '0' COMMENT '0:未删除 1:已删除',
`ins_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上传时间',
`upd_date` TIMESTAMP NULL DEFAULT NULL COMMENT '修改/删除时间',
PRIMARY KEY (`a_mid`,`a_path`),
CONSTRAINT `luoyanshou_attachment_ibfk_1` 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(10) UNSIGNED NOT NULL COMMENT '评论用户ID',
`c_mid` INT(10) UNSIGNED NOT NULL COMMENT '被评论留言ID',
`c_comment` VARCHAR(140) DEFAULT '' COMMENT '评论内容',
`domain` VARCHAR(200) DEFAULT NULL,
`ins_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '评论时间',
`upd_date` TIMESTAMP NULL DEFAULT NULL COMMENT '修改时间',
KEY `c_uid` (`c_uid`),
KEY `c_mid` (`c_mid`),
CONSTRAINT `luoyanshou_comment_ibfk_1` FOREIGN KEY (`c_uid`) REFERENCES `luoyanshou_luoyanshou` (`u_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `luoyanshou_comment_ibfk_2` FOREIGN KEY (`c_mid`) REFERENCES `luoyanshou_messages` (`m_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
";