[ROL-1714] create table of roller_permission error in mssql

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0
• Component/s: Installation & Configuration
• Environment: mssql+tomcat+windows
• Database: mssql
• JDK Version: 1.5
• Assignee: Roller Unassigned
• Reporter: guoweizhan
• Created: 09/May/08 15:20
• Updated: 28/Aug/13 02:56
• Resolved: 28/Aug/13 02:56

Description

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
);