稀饭的国度

关键字: mysql compile
1. -static 13%
–with-client-ldflags=-all-static
–with-mysqld-ldflags=-all-static
静态链接提高13%性能
2. -pgcc 1%
CFLAGS=”-O3 -mpentiumpro -mstack-align-double” CXX=gcc \
CXXFLAGS=”-O3 -mpentiumpro -mstack-align-double \
-felide-constructors -fno-exceptions -fno-rtti”
如果是Inter处理器，使用pgcc提高1%性能
3. Unix Socket 7.5%
–with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock
使用unix套接字链接提高7.5%性能，所以在windows下mysql性能肯定不如unix下面
4. –enable-assembler
允许使用汇编模式(优化性能)
阅读全文…

鞋衫各式名品专卖

本篇只是个人猜测.仅供参考,注意辩读.

我的linode主机,前两天一度出现硬盘IO狂飙的事情.被警告和死机几次,很头疼.仔细检查很多地方,最终将目标锁定在eaccelerator,只有开启它之后,程序才会频繁的进行数据交换.将所有键值指向shm,即内存作为缓存容器,IO读写立刻下降.

参数如下:

zend_extension = “/usr/local/lib/php/extensions/no-debug-non-zts-20060613/eaccelerator.so”
eaccelerator.shm_size = 128
eaccelerator.enable = 1
eaccelerator.optimizer = 1
eaccelerator.debug = 0
eaccelerator.name_space = “”
eaccelerator.check_mtime = 1
eaccelerator.filter = “”
eaccelerator.shm_max = 0
eaccelerator.shm_ttl = 3600
eaccelerator.shm_prune_period = 3600
eaccelerator.shm_only = 1
eaccelerator.compress = 0
eaccelerator.compress_level = 6
eaccelerator.keys = shm
eaccelerator.sessions = shm
eaccelerator.content = shm

eaccelerator.compress = 0 这个选项在php-fpm启动的fcgi中建议关闭.压缩并不会带来性能的突破,如果使用磁盘作为缓存容器,读写更频繁.而且会不稳定.会出现进程死掉的事情.

linux下用源代码编译apache+mysql+php应用环境linux下用源代码编译mysql（基本步骤） linux下用源代码编译apache linux下用源代码编译php mysql部分。mysql源代码的版本是：mysql-5.1.29-rc.tar.gz 建立mysql运行的用户和组：为了安全起见，myslq需要以特定的用户身份去运行。 首先，我们需要查看系统中现有的用户及用户组： 注意：本文中所有的命令均以root身份运行（既shell提示符为#），如果对linux系统不熟悉，在回车前一定要仔细核对。本文不对命令进行过多的讨论，除非有必要，仅给出需要的命令及参数解释。 grep -in mysql /etc/passwd /etc/group 执行上述命令，-i参数不区分大小写，如果你没有看到包含mysql的信息，则说明你的系统当前 可能 没有配置mysql，下面我们需要为mysql运行创建用户及组。如果你看到结果返回 mysql 的字样，说明mysql运行的帐户信息己建立好了，那么可以跳过下面这一步。 <!–more–> groupadd -r -p mysql5 mysql useradd -c “mysql daemon” -r -s /bin/false -d /var/lib/mysql -g mysql -p mysql5 mysql 上述参数解释如下（两个命令参数意义类似）： -c “mysql daemon” mysql用户的描述，如果描述包含多个字符，可以使用引号 -r 将 用户/组 设置为 系统用户/组 -s /bin/false 指定登录外壳，/bin/false为禁止用户从 终端/图形界面 登录 -d /var/lib/mysql，设置用户的主目录，/var/lib/mysql是默认设置，你也可以指定其他位置。 -g mysql 将用户加入到指定的组中。指定的组名必须是存在的。 -p mysql5 设置密码。本文仅是举例，你可以为用户和组各指定不同的密码。 我们是先创建组，然后再创建用户，并把用户加入到组中。如果是先创建用户，在没有指定 -n 参数的情况下，系统将自动创建与用户名同名的组，并且 组ID 与 用户ID 相同，这可能不是我们需要的结果，特别是个别系统有可能更改这一默认设置（如，新用户有默认组），从而带来一些问题，因此，为了避免不必要的麻烦，上述两个命令的顺序不要颠倒。 阅读全文…

简单生活。简单运动

今天遇到一个问题，有一个 Select 语句没有加 “Order By”，返回的数据是不确定的。

这种问题碰到不止几次了。追根寻底， Select 语句如果不加 “Order By”， MySQL会怎么排序呢？

在网上搜了一下，在MySQL论坛发现了这篇文章。

http://forums.mysql.com/read.php?21,239471,239688#msg-239688

阅读全文…

[root@web-little-opt-146 NginxSoftware]# time curl -o /dev/null -s -w %{time_connect}:%{time_starttransfer}:%{time_total} http://image.kaluli.net/index/images/index/20100416/127141246304.gif
1.259:1.281:1.392
real    0m1.394s
user    0m0.002s
sys     0m0.003s

　　清单 1 给出对一个流行的新闻站点执行 curl 命令的情况。输出通常是 HTML 代码，通过 -o 参数发送到 /dev/null。-s 参数去掉所有状态信息。-w 参数让 curl 写出表 1 列出的计时器的状态信息：

阅读全文…

　　Note: This article is for theoretical purpose only. Using an SSH server as a bounce point to other servers/networks will violate the Resource Usage Policies of most hosting service providers. Use it at your own risk!
　　注意：本文仅限于理论研究。将 SSH 服务器作为连接其它服务器或网络的跳板将违反大多数主机服务提供商的资源使用政策。风险自负！

阅读全文…

UCenter Home 数据表结构
2008-08-23 11:53
–
– ucenter home 数据库
–
– 数据库: uchome
–
– ——————————————————–
–
– “广告”表
– 序号,是否激活,标题,位置,代码,类型
uchome_ad
adid smallint(6) unsigned NOT NULL auto_increment,
available tinyint(1) NOT NULL default ‘1′,
title varchar(50) NOT NULL default ”,
pagetype varchar(20) NOT NULL default ”,
adcode text NOT NULL,
system tinyint(1) NOT NULL default ‘0′,
PRIMARY KEY (adid)

<!–more–>

– ——————————————————–
–
– “管理员session记录”表
– 序号,ip,创建日期,错误数量
uchome_adminsession
uid mediumint(8) unsigned NOT NULL default ‘0′,
ip char(15) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
errorcount tinyint(1) NOT NULL default ‘0′,
PRIMARY KEY (uid)

– ——————————————————–
–
– “相册”表
– 序号,相册名称,用户ID,用户名,创建日期,更新日期,图片数量,最近图片地址,x,可见度,查看密码
uchome_album
albumid mediumint(8) unsigned NOT NULL auto_increment,
albumname varchar(50) NOT NULL default ”,
uid mediumint(8) unsigned NOT NULL default ‘0′,
username varchar(15) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
updatetime int(10) unsigned NOT NULL default ‘0′,
picnum smallint(6) unsigned NOT NULL default ‘0′,
pic varchar(60) NOT NULL default ”,
picflag tinyint(1) NOT NULL default ‘0′,
friend tinyint(1) NOT NULL default ‘0′,
`password` varchar(10) NOT NULL default ”,
target_ids text NOT NULL,
PRIMARY KEY (albumid),
KEY uid (uid,updatetime),
KEY friend (friend,updatetime),
KEY updatetime (updatetime)

– ——————————————————–
–
– “uchome app”表
– 用户ID,应用ID,数量,更新日期
uchome_app
uid mediumint(8) unsigned NOT NULL default ‘0′,
appid smallint(6) unsigned NOT NULL default ‘0′,
num mediumint(8) unsigned NOT NULL default ‘0′,
updatetime int(10) unsigned NOT NULL default ‘0′,
PRIMARY KEY (uid,appid)

– ——————————————————–
–
– 数据调用 表
– 序号,调用名称,调用sql语句,缓存变量,缓存时间,获取的记录数,每页的记录数,html代码
uchome_block
bid smallint(6) unsigned NOT NULL auto_increment,
blockname varchar(40) NOT NULL default ”,
blocksql text NOT NULL,
cachename varchar(30) NOT NULL default ”,
cachetime smallint(6) unsigned NOT NULL default ‘0′,
num tinyint(3) unsigned NOT NULL default ‘0′,
perpage tinyint(3) unsigned NOT NULL default ‘0′,
htmlcode text NOT NULL,
PRIMARY KEY (bid)

– ——————————————————–
–
– “日志”表
– 序号,用户id,用户名,主题,分类id,浏览数,回复数,发布日期,图片地址,是否有图片,没有回复,X,查看密码
uchome_blog
blogid mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default ‘0′,
username char(15) NOT NULL default ”,
`subject` char(80) NOT NULL default ”,
classid smallint(6) unsigned NOT NULL default ‘0′,
viewnum mediumint(8) unsigned NOT NULL default ‘0′,
replynum mediumint(8) unsigned NOT NULL default ‘0′,
tracenum mediumint(8) unsigned NOT NULL default ‘0′,
dateline int(10) unsigned NOT NULL default ‘0′,
pic char(120) NOT NULL default ”,
picflag tinyint(1) NOT NULL default ‘0′,
noreply tinyint(1) NOT NULL default ‘0′,
friend tinyint(1) NOT NULL default ‘0′,
`password` char(10) NOT NULL default ”,
PRIMARY KEY (blogid),
KEY uid (uid,dateline),
KEY friend (friend,dateline),
KEY dateline (dateline)

– ——————————————————–
–
– “日志摘要”表
– 序号,用户ID,表签,消息,发送IP,内容,生成日期,x
uchome_blogfield
blogid mediumint(8) unsigned NOT NULL default ‘0′,
uid mediumint(8) unsigned NOT NULL default ‘0′,
tag varchar(255) NOT NULL default ”,
message mediumtext NOT NULL,
postip varchar(20) NOT NULL default ”,
related text NOT NULL,
relatedtime int(10) unsigned NOT NULL default ‘0′,
target_ids text NOT NULL,
PRIMARY KEY (blogid)

– ——————————————————–
–
– “模块缓存”表 模块调用数据时(站点设置)
– 缓存的密钥,值,时间
uchome_cache
cachekey varchar(16) NOT NULL default ”,
`value` mediumtext NOT NULL,
mtime int(10) unsigned NOT NULL default ‘0′,
PRIMARY KEY (cachekey)

– ——————————————————–
–
– “日志分类”表
– 序号,分类名称,用户ID,创建日期
uchome_class
classid mediumint(8) unsigned NOT NULL auto_increment,
classname char(40) NOT NULL default ”,
uid mediumint(8) unsigned NOT NULL default ‘0′,
dateline int(10) unsigned NOT NULL default ‘0′,
PRIMARY KEY (classid),
KEY uid (uid)

– ——————————————————–
–
– “space留言”表
– 序号,用户ID,x,ID类型,作者的ID,作者,ip,创建日期,内容
uchome_comment
cid mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default ‘0′,
id mediumint(8) unsigned NOT NULL default ‘0′,
idtype varchar(20) NOT NULL default ”,
authorid mediumint(8) unsigned NOT NULL default ‘0′,
author varchar(15) NOT NULL default ”,
ip varchar(20) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
message text NOT NULL,
PRIMARY KEY (cid),
KEY id (id,idtype,dateline)

– ——————————————————–
–
– “ucenter基本设置”表 后台的站点设置,隐私设置:允许访问的IP列表,禁止访问的IP列表,新用户默认隐私设置
–
uchome_config
var varchar(30) NOT NULL default ”,
datavalue text NOT NULL,
PRIMARY KEY (var)

– ——————————————————–
–
– 定表:更新浏览数统计,清理过期的feed,清里个人通知,统计uc的feed[后台的Task]
–
uchome_cron
cronid smallint(6) unsigned NOT NULL auto_increment,
available tinyint(1) NOT NULL default ‘0′,
`type` enum(’user’,’system’) NOT NULL default ‘user’,
`name` char(50) NOT NULL default ”,
filename char(50) NOT NULL default ”,
lastrun int(10) unsigned NOT NULL default ‘0′,
nextrun int(10) unsigned NOT NULL default ‘0′,
weekday tinyint(1) NOT NULL default ‘0′,
`day` tinyint(2) NOT NULL default ‘0′,
`hour` tinyint(2) NOT NULL default ‘0′,
`minute` char(36) NOT NULL default ”,
PRIMARY KEY (cronid),
KEY nextrun (available,nextrun)

– ——————————————————–
–
– 积分规则,邮件,后台的上传图片设置,远程上传设置,多应用设置,备份目录,词法过滤,随便看看模块列表:模块编辑
– 变量,变量值
uchome_data
var varchar(20) NOT NULL default ”,
datavalue text NOT NULL,
PRIMARY KEY (var)

– ——————————————————–
–
– “迷你博客”表
– 序号,用户ID,用户名,创建日期,内容,ip
uchome_doing
doid mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default ‘0′,
username char(15) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
message char(200) NOT NULL default ”,
ip char(20) NOT NULL default ”,
PRIMARY KEY (doid),
KEY uid (uid,dateline),
KEY dateline (dateline)

– ——————————————————–
–
– “加好友”表
– 用户ID,要加好友的ID,要加好友的名字,状态(0=s,1=d),把好友放到哪个组中,备
uchome_friend
uid mediumint(8) unsigned NOT NULL default ‘0′,
fuid mediumint(8) unsigned NOT NULL default ‘0′,
fusername char(15) NOT NULL default ”,
status tinyint(1) NOT NULL default ‘0′,
gid smallint(6) unsigned NOT NULL default ‘0′,
note char(50) NOT NULL default ”,
PRIMARY KEY (uid,fuid),
KEY fuid (fuid),
KEY status (uid, status)

– ——————————————————–
–
– “反馈”表
– 序号,应用ID,图标,用户ID,用户名,创建日期,x,x,x,标题模板,标题数据,正文模板,正文数据
uchome_feed (
feedid mediumint(8) unsigned NOT NULL auto_increment,
appid smallint(6) unsigned NOT NULL default ‘0′,
icon varchar(30) NOT NULL default ”,
uid mediumint(8) unsigned NOT NULL default ‘0′,
username varchar(15) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
friend tinyint(1) NOT NULL default ‘0′,
hash_template varchar(32) NOT NULL default ”,
hash_data varchar(32) NOT NULL default ”,
title_template text NOT NULL,
title_data text NOT NULL,
body_template text NOT NULL,
body_data text NOT NULL,
body_general text NOT NULL,
image_1 varchar(255) NOT NULL default ”,
image_1_link varchar(255) NOT NULL default ”,
image_2 varchar(255) NOT NULL default ”,
image_2_link varchar(255) NOT NULL default ”,
image_3 varchar(255) NOT NULL default ”,
image_3_link varchar(255) NOT NULL default ”,
image_4 varchar(255) NOT NULL default ”,
image_4_link varchar(255) NOT NULL default ”,
target_ids text NOT NULL,
PRIMARY KEY (feedid),
KEY uid (uid,dateline),
KEY dateline (dateline)

– ——————————————————–
–
– “邀请好友”表
– 序号,用户ID,邀请码,被邀请好友的ID,被邀请用户名
uchome_invite (
id mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default ‘0′,
code char(20) NOT NULL default ”,
fuid mediumint(8) unsigned NOT NULL default ‘0′,
fusername char(15) NOT NULL default ”,
PRIMARY KEY (id),
KEY uid (uid)

– ——————————————————–
–
– uchome日志
– 序号,数据实例ID,blogid[uid]类型
uchome_log (
logid mediumint(8) unsigned NOT NULL auto_increment,
id mediumint(8) unsigned NOT NULL default ‘0′,
idtype char(20) NOT NULL default ”,
PRIMARY KEY (logid)

– ——————————————————–
–
– uchome会员表
– 序号,用户名,密码
uchome_member (
uid mediumint(8) unsigned NOT NULL auto_increment,
username char(15) NOT NULL default ”,
`password` char(32) NOT NULL default ”,
PRIMARY KEY (uid)

– ——————————————————–
–
– 自定义选吧 表
– 序号,选吧名称,选吧的ID,人数,吧主,状态,公告,图片
uchome_mtag
tagid mediumint(8) unsigned NOT NULL auto_increment,
tagname varchar(40) NOT NULL default ”,
fieldid smallint(6) NOT NULL default ‘0′,
membernum mediumint(8) unsigned NOT NULL default ‘0′,
moderator varchar(255) NOT NULL default ”,
`close` tinyint(1) NOT NULL default ‘0′,
announcement varchar(255) NOT NULL default ”,
pic varchar(150) NOT NULL default ”,
PRIMARY KEY (tagid),
KEY tagname (tagname),
KEY fieldid (fieldid,membernum),
KEY membernum (membernum)

– ——————————————————–
–
– “通知”表
– 序号,接收用户ID,类型,是否新通知,作者ID,作者用户名,备注,创建日期
uchome_notification
id mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default ‘0′,
`type` varchar(20) NOT NULL default ”,
`new` tinyint(1) NOT NULL default ‘0′,
authorid mediumint(8) unsigned NOT NULL default ‘0′,
author varchar(15) NOT NULL default ”,
note text NOT NULL,
dateline int(10) unsigned NOT NULL default ‘0′,
PRIMARY KEY (id),
KEY uid (uid)

– ——————————————————–
–
– “相片”表
– 相片ID,相册ID,用户ID，创建日期,源文件名,主题,格式,大小,图片路径
uchome_pic (
picid mediumint(8) NOT NULL auto_increment,
albumid mediumint(8) unsigned NOT NULL default ‘0′,
uid mediumint(8) unsigned NOT NULL default ‘0′,
dateline int(10) unsigned NOT NULL default ‘0′,
filename char(100) NOT NULL default ”,
title char(150) NOT NULL default ”,
`type` char(20) NOT NULL default ”,
size int(10) unsigned NOT NULL default ‘0′,
filepath char(60) NOT NULL default ”,
thumb tinyint(1) NOT NULL default ‘0′,
remote tinyint(1) NOT NULL default ‘0′,
PRIMARY KEY (picid),
KEY albumid (albumid,dateline)

– ——————————————————–
–
– “打招呼”表
– (向谁)用户ID,(发送招呼)用户ID,(发送招呼的)用户名，备注
uchome_poke (
uid mediumint(8) unsigned NOT NULL default ‘0′,
fromuid mediumint(8) unsigned NOT NULL default ‘0′,
fromusername char(15) NOT NULL default ”,
note char(50) NOT NULL default ”,
PRIMARY KEY (uid,fromuid)

– ——————————————————–
–
– “发帖”表
– 帖子ID,选吧ID,主贴ID,用户ID,用户名,ip,创建日期,内容,图片,是否为回复(1为发贴,0为回贴)
uchome_post (
pid mediumint(8) unsigned NOT NULL auto_increment,
tagid mediumint(8) unsigned NOT NULL default ‘0′,
tid mediumint(8) unsigned NOT NULL default ‘0′,
uid mediumint(8) unsigned NOT NULL default ‘0′,
username varchar(15) NOT NULL default ”,
ip varchar(20) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
message text NOT NULL,
pic varchar(255) NOT NULL default ”,
isthread tinyint(1) NOT NULL default ‘0′,
PRIMARY KEY (pid),
KEY tid (tid,dateline)

– ——————————————————–
–
– 选吧的主题(默认为定表)
– 序号,选吧的主题,选吧介绍,控件的类型,输入框类型,选项,显示顺序
uchome_profield (
fieldid smallint(6) unsigned NOT NULL auto_increment,
title varchar(80) NOT NULL default ”,
note varchar(255) NOT NULL default ”,
formtype varchar(20) NOT NULL default ‘0′,
inputnum smallint(3) unsigned NOT NULL default ‘0′,
choice text NOT NULL,
displayorder tinyint(3) unsigned NOT NULL default ‘0′,
PRIMARY KEY (fieldid)

– ——————————————————–
–
– 后台用户栏目:注册会员时的附加控件,跟会员表uchome_member关联
– 序号,标题,备注,控件的类型,最大的数量,是否为必填项(1否,0是),是否隐藏(0否,1是),是否允许搜索(0否,1是),选项名称(radio,select),显示顺序
uchome_profilefield (
fieldid smallint(6) unsigned NOT NULL auto_increment,
title varchar(80) NOT NULL default ”,
note varchar(255) NOT NULL default ”,
formtype varchar(20) NOT NULL default ‘0′,
maxsize tinyint(3) unsigned NOT NULL default ‘0′,
required tinyint(1) NOT NULL default ‘0′,
invisible tinyint(1) NOT NULL default ‘0′,
allowsearch tinyint(1) NOT NULL default ‘0′,
choice text NOT NULL,
displayorder tinyint(3) unsigned NOT NULL default ‘0′,
PRIMARY KEY (fieldid)

– ——————————————————–
–
– “在线session”表
– 用户ID,用户名,密码,权限,积分,最后上线日期,站内信,屏蔽CSS
uchome_session (
uid mediumint(8) unsigned NOT NULL default ‘0′,
username char(15) NOT NULL default ”,
`password` char(32) NOT NULL default ”,
groupid smallint(6) unsigned NOT NULL default ‘0′,
credit int(10) NOT NULL default ‘0′,
lastactivity int(10) unsigned NOT NULL default ‘0′,
newpm tinyint(1) NOT NULL default ‘0′,
nocss tinyint(1) NOT NULL default ‘0′,
PRIMARY KEY (uid)

– ——————————————————–
–
– “分享”表
– 分享ID,类别,分享者ID,分享者用户名,分享日期,x,主题模板,正文模板(占位符),正文的文本,图片,图片连接
uchome_share
sid mediumint(8) unsigned NOT NULL auto_increment,
type varchar(30) NOT NULL default ”,
uid mediumint(8) unsigned NOT NULL default ‘0′,
username varchar(15) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
hash_data varchar(32) NOT NULL default ”,
title_template text NOT NULL,
body_template text NOT NULL,
body_data text NOT NULL,
body_general text NOT NULL,
image varchar(255) NOT NULL default ”,
image_link varchar(255) NOT NULL default ”,
PRIMARY KEY (sid),
KEY uid (uid,dateline),
KEY dateline (dateline)

– ——————————————————–
–
– “个人空间”表
– ID,权限,积分,用户名,个人主页网址,空间名称,浏览数量,好友数量,创建日期,更新日期,最后(搜)索引日期,最后提交日期,已用的空间(字节)数,x,x
uchome_space
uid mediumint(8) unsigned NOT NULL default ‘0′,
groupid smallint(6) unsigned NOT NULL default ‘0′,
credit int(10) NOT NULL default ‘0′,
username char(15) NOT NULL default ”,
domain char(15) NOT NULL default ”,
spacename char(30) NOT NULL default ”,
viewnum int(10) unsigned NOT NULL default ‘0′,
friendnum int(10) unsigned NOT NULL default ‘0′,
dateline int(10) unsigned NOT NULL default ‘0′,
updatetime int(10) unsigned NOT NULL default ‘0′,
lastsearch int(10) unsigned NOT NULL default ‘0′,
lastpost int(10) unsigned NOT NULL default ‘0′,
attachsize int(10) NOT NULL default ‘0′,
addsize int(10) NOT NULL default ‘0′,
flag tinyint(1) NOT NULL default ‘0′,
PRIMARY KEY (uid),
KEY username (username),
KEY domain (domain),
KEY updatetime (updatetime)

– ——————————————————–
–
– “个人资料” 表
– 用户ID,性别,邮箱,qq,msn,出生年,出生月,出生日,血性,婚姻状况,出生的省,出生的市,现居省,现居市,最后的日志,x,是否选用个性模板,个人空间模板，X,X,X,X
uchome_spacefield
uid mediumint(8) unsigned NOT NULL default ‘0′,
sex tinyint(1) NOT NULL default ‘0′,
email varchar(100) NOT NULL default ”,
qq varchar(20) NOT NULL default ”,
msn varchar(80) NOT NULL default ”,
birthyear smallint(6) unsigned NOT NULL default ‘0′,
birthmonth tinyint(3) unsigned NOT NULL default ‘0′,
birthday tinyint(3) unsigned NOT NULL default ‘0′,
blood varchar(5) NOT NULL default ”,
marry tinyint(1) NOT NULL default ‘0′,
birthprovince varchar(20) NOT NULL default ”,
birthcity varchar(20) NOT NULL default ”,
resideprovince varchar(20) NOT NULL default ”,
residecity varchar(20) NOT NULL default ”,
note varchar(255) NOT NULL default ”,
authstr varchar(20) NOT NULL default ”,
nocss tinyint(1) NOT NULL default ‘0′,
theme varchar(20) NOT NULL default ”,
css text NOT NULL,
privacy text NOT NULL,
friend text NOT NULL,
feedfriend text NOT NULL,
PRIMARY KEY (uid)

– ——————————————————–
–
– “日志关键字”表
– 关键字序号,关键字名称,用户ID,创建日期,日志数量,x
uchome_tag
tagid mediumint(8) unsigned NOT NULL auto_increment,
tagname char(30) NOT NULL default ”,
uid mediumint(8) unsigned NOT NULL default ‘0′,
dateline int(10) unsigned NOT NULL default ‘0′,
blognum smallint(6) unsigned NOT NULL default ‘0′,
`close` tinyint(1) NOT NULL default ‘0′,
PRIMARY KEY (tagid),
KEY tagname (tagname)

– ——————————————————–
–
– “日志”表跟“日志关键字”表的中间表
– 关键字ID,日志ID
uchome_tagblog
tagid mediumint(8) unsigned NOT NULL default ‘0′,
blogid mediumint(8) unsigned NOT NULL default ‘0′,
PRIMARY KEY (tagid,blogid)

– ——————————————————–
–
– “用户”表和“选吧”表的中间表
– 选吧ID,用户ID,用户名
uchome_tagspace
tagid mediumint(8) unsigned NOT NULL default ‘0′,
uid mediumint(8) unsigned NOT NULL default ‘0′,
username char(15) NOT NULL default ”,
PRIMARY KEY (tagid,uid),
KEY uid (uid)

– ——————————————————–
–
– “贴子”表
– 贴子ID,选吧的ID,主题,作者ID,作者用户名,发帖日期,查看数,回复数,最后回复时间,最后回复人,最后回复人ID,排序,置顶
uchome_thread
tid mediumint(8) unsigned NOT NULL auto_increment,
tagid mediumint(8) unsigned NOT NULL default ‘0′,
`subject` char(80) NOT NULL default ”,
uid mediumint(8) unsigned NOT NULL default ‘0′,
username char(15) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
viewnum mediumint(8) unsigned NOT NULL default ‘0′,
replynum mediumint(8) unsigned NOT NULL default ‘0′,
lastpost int(10) unsigned NOT NULL default ‘0′,
lastauthor char(15) NOT NULL default ”,
lastauthorid mediumint(8) unsigned NOT NULL default ‘0′,
displayorder tinyint(1) unsigned NOT NULL default ‘0′,
digest tinyint(1) NOT NULL default ‘0′,
PRIMARY KEY (tid),
KEY tagid (tagid,displayorder,lastpost),
KEY uid (uid,lastpost),
KEY lastpost (lastpost)

– ——————————————————–
–
– “日志的脚印”表
– 被踩日志ID,踩脚印者ID,踩者用户名,踩脚印的时间
uchome_trace
blogid mediumint(8) unsigned NOT NULL default ‘0′,
uid mediumint(8) unsigned NOT NULL default ‘0′,
username char(15) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
PRIMARY KEY (blogid,uid),
KEY dateline (blogid,dateline),
KEY uid (uid,dateline)

– ——————————————————–
–
– 会员的分类[后台的用户组] 表
–
uchome_usergroup
gid smallint(6) unsigned NOT NULL auto_increment,
grouptitle char(20) NOT NULL default ”,
system tinyint(1) NOT NULL default ‘0′,
creditlower int(10) NOT NULL default ‘0′,
maxfriendnum smallint(6) unsigned NOT NULL default ‘0′,
maxattachsize int(10) unsigned NOT NULL default ‘0′,
allowhtml tinyint(1) NOT NULL default ‘0′,
allowcomment tinyint(1) NOT NULL default ‘0′,
searchinterval smallint(6) unsigned NOT NULL default ‘0′,
postinterval smallint(6) unsigned NOT NULL default ‘0′,
allowblog tinyint(1) NOT NULL default ‘0′,
allowdoing tinyint(1) NOT NULL default ‘0′,
allowupload tinyint(1) NOT NULL default ‘0′,
allowshare tinyint(1) NOT NULL default ‘0′,
allowthread tinyint(1) NOT NULL default ‘0′,
allowpost tinyint(1) NOT NULL default ‘0′,
domainlength smallint(6) unsigned NOT NULL default ‘0′,
closeignore tinyint(1) NOT NULL default ‘0′,
manageconfig tinyint(1) NOT NULL default ‘0′,
managenetwork tinyint(1) NOT NULL default ‘0′,
manageprofilefield tinyint(1) NOT NULL default ‘0′,
manageprofield tinyint(1) NOT NULL default ‘0′,
manageusergroup tinyint(1) NOT NULL default ‘0′,
managefeed tinyint(1) NOT NULL default ‘0′,
manageshare tinyint(1) NOT NULL default ‘0′,
managedoing tinyint(1) NOT NULL default ‘0′,
manageblog tinyint(1) NOT NULL default ‘0′,
managetag tinyint(1) NOT NULL default ‘0′,
managetagtpl tinyint(1) NOT NULL default ‘0′,
managealbum tinyint(1) NOT NULL default ‘0′,
managecomment tinyint(1) NOT NULL default ‘0′,
managemtag tinyint(1) NOT NULL default ‘0′,
managethread tinyint(1) NOT NULL default ‘0′,
managespace tinyint(1) NOT NULL default ‘0′,
managecensor tinyint(1) NOT NULL default ‘0′,
managead tinyint(1) NOT NULL default ‘0′,
managebackup tinyint(1) NOT NULL default ‘0′,
manageblock tinyint(1) NOT NULL default ‘0′,
managetemplate tinyint(1) NOT NULL default ‘0′,
managestat tinyint(1) NOT NULL default ‘0′,
managecache tinyint(1) NOT NULL default ‘0′,
managecredit tinyint(1) NOT NULL default ‘0′,
managecron tinyint(1) NOT NULL default ‘0′,
PRIMARY KEY (gid)

– ——————————————————–
–
– “最新访客”表
– 受访者ID,访客ID,访客用户名,访问时间
uchome_visitor
uid mediumint(8) unsigned NOT NULL default ‘0′,
vuid mediumint(8) unsigned NOT NULL default ‘0′,
vusername char(15) NOT NULL default ”,
dateline int(10) unsigned NOT NULL default ‘0′,
PRIMARY KEY (uid,vuid),
KEY dateline (uid,dateline)

一、准备

1.在www.extmail.org 中下载extmail-1.2.tar.gz 和extman1.1

Extmail 用于从浏览器中登入、使用邮件系统

Extman 用于从浏览器中管邮件系统

2.由于安装extmail要用到以下三个包（到http://search.cpan.org 中搜索）

1）Unix-Syslog http://search.cpan.org/~mharnisch/Unix-Syslog-1.1/Syslog.pm

阅读全文…

一、准备

1.从www.extmail.org 中下载extman-1.1.tar.gz

2.从http://sourceforge.net/projects/courier/files/ 下载courier-authlib

使用Courier-authlib软件的目的是因为saslauthd程序不支持数据库认证，而Courier-authlib支持多种数据库认证

3.检查postfix是否支持虚拟用户 postconf – m | grep msyql 如果出现mysql表示支持

二、建立虚拟用户数据库

阅读全文…

一、准备

1.在 http://mirror.postfixchina.org/ 下载好postfix-2.6.5.tar.gz

2.在http://www.dovecot.org 中下载好dovecot-1.1.16.tar.gz

Dovecot是一个安全性较好的POP3/IMAP服务器软件，响应速度快而且扩展性好

注意：所有源码包都放在 /postfix-an 目录下，解压也是在此目录下

3.停止sendmail

①Service sendmail stop

阅读全文…