Apache Roller
  1. Apache Roller
  2. ROL-1714

create table of roller_permission error in mssql

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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
      );

        Activity

        guoweizhan created issue -
        Henri Yandell made changes -
        Field Original Value New Value
        Project Import Fri Mar 27 23:38:16 PDT 2009 [ 1238222296558 ]
        Mark Thomas made changes -
        Workflow jira [ 12459251 ] Default workflow, editable Closed status [ 12623213 ]
        Hide
        Glen Mazza added a comment -

        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.

        Show
        Glen Mazza added a comment - 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.
        Glen Mazza made changes -
        Status Open [ 1 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development