Uploaded image for project: 'Apache Roller'
  1. Apache Roller
  2. ROL-1714

create table of roller_permission error in mssql

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.0
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      mssql+tomcat+windows
    • Database:
      mssql
    • JDK Version:
      1.5

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

        Attachments

          Activity

            People

            • Assignee:
              roller_unassigned Roller Unassigned
              Reporter:
              guoweizhan guoweizhan
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: