恢复数据库后用sp_helpuser查看，发现
> UserName GroupName        LoginName DefDBName UserID SID
> -------- ---------------- --------- --------- ------ ---
> dbo      db_owner         NULL      NULL      1      0x01

第一次见这种情况，幸好下面SQL语句可以修复db_owner的login name为sa
exec sp_configure 'allow updates', '1'
go
RECONFIGURE WITH OVERRIDE
go

update sysusers
set sid = (select sid from master..syslogins where loginname = 'sa'), updatedate = getdate(), status = (status & ~1) | 2
where name = 'dbo'

exec sp_configure 'allow updates', '0'
go
RECONFIGURE WITH OVERRIDE
go


jira首页列表添加逾期时间

相关文件调用顺序：
atlassian-jira\WEB-INF\classes\com\atlassian\jira\plugin\JiraPluginManager.class
atlassian-jira\WEB-INF\classes\system-portlets-plugin.xml
atlassian-jira\WEB-INF\classes\templates\plugins\jira\portlets\searchresults.vm
atlassian-jira\WEB-INF\classes\templates\plugins\jira\portlets\issuesummary.vm
atlassian-jira\WEB-INF\classes\templates\plugins\jira\portlets\includes\issuesummary-rowcontents.vm


在issuesummary-rowcontents.vm最后添加：
<td nowrap width="1%">   
  #text("issue.field.duedate"): today.getTime()
</td>

在searchresults.vm
把所以colspan="4"改成
colspan="5"