/*
ExtMail - OSS
by He zhiqiang <hzqbbc@hzqbbc.com>
Copyright (c) 1998-2005 hzqbbc.com
License: GPL v2
This is the MySQL database structure for ExtMail System, derive from
Postfixadmin ( http://high5.net/howto/ ) project, and modify to meet
our need, it is compatible with PostfixAdmin MySQL structure and have
some extmail specific attributes and structure
ExtMail have an alternative solution on openLDAP, please check the
extmail.schema (V3) for detail.
You can create the database from the shell with:
mysql -u root [-p] < extmail.sql
*/
/*
Initialize mysql
*/
USE mysql;
/* readonly user & password */
/* clean user if exists */
delete FROM user where User in ('extmail','webman');
delete FROM db where User in ('extmail','webman');
INSERT INTO user (Host, User, Password) VALUES ('localhost','extmail',password('extmail'));
INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost','extmail','extmail','Y');
/* extman read/write user & password */
INSERT INTO user (Host, User, Password) VALUES ('localhost','webman',password('webman'));
INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) VALUES ('localhost', 'extmail', 'webman', 'Y', 'Y', 'Y', 'Y');
FLUSH PRIVILEGES;
/* readonly user */
GRANT USAGE ON extmail.* TO extmail@localhost;
GRANT SELECT, UPDATE ON extmail.* TO extmail@localhost;
/* read/write user */
GRANT USAGE ON extmail.* TO webman@localhost;
GRANT SELECT, INSERT, DELETE, UPDATE ON extmail.* TO webman@localhost;
CREATE DATABASE extmail;
USE extmail;
/* Table structure for table manager */
CREATE TABLE manager (
username varchar(255) NOT NULL default '',
password varchar(255) NOT NULL default '',
type varchar(64) NOT NULL default 'postmaster',
uid varchar(255) NOT NULL default '',
name varchar(255) NOT NULL default '',
question text NOT NULL default '',
answer text NOT NULL default '',
disablepwdchange smallint(1),
createdate datetime NOT NULL default '0000-00-00 00:00:00',
expiredate DATE NOT NULL default '0000-00-00',
active tinyint(1) NOT NULL default '1',
PRIMARY KEY (username),
KEY username (username)
) TYPE=MyISAM COMMENT='Ext/Webman - Admin Accounts';
/* Table structure for table alias */
CREATE TABLE alias (
address varchar(255) NOT NULL default '',
goto text NOT NULL,
domain varchar(255) NOT NULL default '',
createdate datetime NOT NULL default '0000-00-00 00:00:00',
active tinyint(1) NOT NULL default '1',
PRIMARY KEY (address),
KEY address (address)
) TYPE=MyISAM COMMENT='ExtMail - Virtual Aliases';
/* Table structure for table domain */
CREATE TABLE domain (
domain varchar(255) NOT NULL default '',
description varchar(255) NOT NULL default '',
hashdirpath varchar(255) NOT NULL default '',
maxalias int(10) NOT NULL default '0',
maxusers int(10) NOT NULL default '0',
maxquota varchar(16) NOT NULL default '0',
maxnetdiskquota varchar(16) NOT NULL default '0',
transport varchar(255) default NULL,
can_signup tinyint(1) NOT NULL default '0',
default_quota varchar(255) default NULL,
default_netdiskquota varchar(255) default NULL,
default_expire varchar(12) default NULL,
disablesmtpd smallint(1),
disablesmtp smallint(1),
disablewebmail smallint(1),
disablenetdisk smallint(1),
disableimap smallint(1),
disablepop3 smallint(1),
createdate datetime NOT NULL default '0000-00-00 00:00:00',
expiredate DATE NOT NULL default '0000-00-00',
active tinyint(1) NOT NULL default '1',
PRIMARY KEY (domain),
KEY domain (domain)
) TYPE=MyISAM COMMENT='ExtMail - Virtual Domains';
/* Table structure for table domain_manager */
CREATE TABLE domain_manager (
username varchar(255) NOT NULL default '',
domain varchar(255) NOT NULL default '',
createdate datetime NOT NULL default '0000-00-00 00:00:00',
active tinyint(1) NOT NULL default '1',
KEY username (username)
) TYPE=MyISAM COMMENT='Ext/Webman - Domain Admins';
/*
Table structure for table mailbox
mapping: name <-> cn, username <-> mail
*/
CREATE TABLE mailbox (
username varchar(255) NOT NULL default '',
uid varchar(255) NOT NULL default '',
password varchar(255) NOT NULL default '',
clearpwd varchar(128) NOT NULL default '',
name varchar(255) NOT NULL default '',
mailhost varchar(255) NOT NULL default '',
maildir varchar(255) NOT NULL default '',
homedir varchar(255) NOT NULL default '',
quota varchar(16) NOT NULL default '0',
netdiskquota varchar(16) NOT NULL default '0',
domain varchar(255) NOT NULL default '',
uidnumber int(6) NOT NULL default '1000',
gidnumber int(6) NOT NULL default '1000',
createdate datetime NOT NULL default '0000-00-00 00:00:00',
expiredate DATE NOT NULL default '0000-00-00',
active smallint(1) NOT NULL default '1',
disablepwdchange smallint(1),
disablesmtpd smallint(1),
disablesmtp smallint(1),
disablewebmail smallint(1),
disablenetdisk smallint(1),
disableimap smallint(1),
disablepop3 smallint(1),
question text NOT NULL default '',
answer text NOT NULL default '',
PRIMARY KEY (username),
KEY username (username)
) TYPE=MyISAM COMMENT='ExtMail - Virtual Mailboxes';
没有合适的资源?快使用搜索试试~ 我知道了~
extman-0.2.5.tar.gz
5星 · 超过95%的资源 需积分: 7 230 下载量 101 浏览量
2009-08-11
14:24:08
上传
评论
收藏 549KB GZ 举报
温馨提示
共248个文件
gif:99个
pm:34个
html:19个
extman-0.2.5.tar.gz,最新的extman后台管理程序包.
资源推荐
资源详情
资源评论
收起资源包目录
extman-0.2.5.tar.gz (248个子文件)
AUTHORS 293B
AUTHORS 140B
backport 1KB
webman.cf 5KB
ldap_virtual_domains_maps.cf 210B
ldap_virtual_mailbox_maps.cf 202B
ldap_virtual_alias_maps.cf 201B
ldap_virtual_limit_maps.cf 195B
ldap_virtual_sender_maps.cf 190B
mysql_virtual_sender_maps.cf 173B
mysql_virtual_mailbox_maps.cf 172B
mysql_virtual_limit_maps.cf 170B
mysql_virtual_domains_maps.cf 168B
mysql_virtual_alias_maps.cf 166B
captcha.cgi 3KB
groupmail.cgi 614B
overview.cgi 607B
changepwd.cgi 605B
forgetpwd.cgi 605B
viewlog.cgi 604B
manager.cgi 604B
domain.cgi 601B
signup.cgi 601B
alias.cgi 598B
index.cgi 597B
user.cgi 595B
ChangeLog 17KB
CHANGES 8KB
COPYING 18KB
default.css 5KB
autocomplete.css 468B
tab.css 430B
style.css 292B
en_US 13KB
README.ext 2KB
README.fcgi 13KB
medal1.gif 33KB
medal9.gif 31KB
medal6.gif 31KB
medal10.gif 31KB
medal8.gif 30KB
medal4.gif 29KB
medal3.gif 26KB
medal2.gif 26KB
medal5.gif 24KB
medal7.gif 22KB
fck_strip.gif 8KB
watermark.gif 4KB
logo.gif 2KB
bb_email.gif 1KB
bb_flash.gif 1KB
bb_image.gif 1KB
bb_qq.gif 1KB
bb_rm.gif 1017B
bb_ra.gif 1014B
bb_wma.gif 1013B
bb_wmv.gif 1013B
bb_table.gif 1009B
bb_alipay.gif 1008B
online_supermod.gif 995B
online_moderator.gif 994B
online_member.gif 991B
bb_unlink.gif 985B
bb_quote.gif 980B
bb_fly.gif 979B
zoomout.gif 976B
zoomin.gif 976B
extman_logo.gif 971B
bb_removeformat.gif 970B
bb_redo.gif 955B
bb_undo.gif 955B
bb_color.gif 949B
bb_url.gif 947B
bb_outdent.gif 933B
bb_indent.gif 933B
del.gif 929B
bb_bold.gif 928B
bb_code.gif 915B
bb_underline.gif 910B
bb_orderedlist.gif 906B
bb_unorderedlist.gif 905B
bb_italic.gif 881B
toploading.gif 875B
bb_center.gif 856B
bb_left.gif 856B
bb_right.gif 855B
bb_contract.gif 835B
bb_expand.gif 834B
bb_separator.gif 829B
sort_asc.gif 827B
icon_signinxspace.gif 755B
rss.gif 705B
home.gif 664B
backup.gif 628B
alias.gif 623B
user.gif 609B
passwd.gif 599B
online_admin.gif 595B
online_guest.gif 583B
hint_sm.gif 565B
共 248 条
- 1
- 2
- 3
资源评论
- zh_w_l_zh2013-07-06可以用呀,不错的
- xx_07222012-11-04可以用、、不如在网上下的好哦、比较老了
- pengzai5122012-11-19还不错,之前搭建环境用到了
- matianhai2019-09-03不错的资源
longhui2012
- 粉丝: 8
- 资源: 23
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功