[
https://issues.apache.org/jira/browse/ROL-1714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Glen Mazza closed ROL-1714.
---------------------------
Resolution: Fixed
This was fixed in some earlier version of Roller -- at least in trunk the table
create statement is exactly as suggested in this JIRA. Thanks for bringing to
our attention.
> create table of roller_permission error in mssql
> ------------------------------------------------
>
> Key: ROL-1714
> URL: https://issues.apache.org/jira/browse/ROL-1714
> Project: Roller
> Issue Type: Bug
> Components: Installation
> Affects Versions: 5.0
> Environment: mssql+tomcat+windows
> Reporter: guoweizhan
> Assignee: Roller Unassigned
>
> when create the table of roller_permission, the type of datecreated is
> error, it doesn't change the timestamp to datetime. the createdb script
> should be change to
> create table roller_permission (
> id varchar(48) not null primary key,
> username varchar(255) not null,
> actions varchar(255),
> objectid varchar(48),
> objecttype varchar(255),
> pending $db.BOOLEAN_SQL_TYPE_TRUE,
> datecreated $db.TIMESTAMP_SQL_TYPE not null
> );
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
