Opened 4 years ago

Closed 4 years ago

#1486020 closed Bugs (fixed)

Errors in SQL/mssql.initial.sql

Reported by: Gliese Owned by:
Priority: 5 Milestone: 0.3-stable
Component: Database Version: 0.3-rc1
Severity: normal Keywords:
Cc:

Description

SQL/mssql.initial.sql contains a syntax error (extra comma at the end of line 205 CONSTRAINT [DF_users_created] DEFAULT (getdate()) FOR [created]), and structure discrepancies with mysql.initial.sql. In particular, the field preferences in table users is wrongly defined as non nullable and no default value is defined for html_signature in table identities, which triggers errors.
Suggested patch in attachment.

Attachments (1)

mssql.initial.sql.diff (1.9 KB) - added by Gliese 4 years ago.

Download all attachments as: .zip

Change History (2)

Changed 4 years ago by Gliese

comment:1 Changed 4 years ago by alec

  • Resolution set to fixed
  • Status changed from new to closed

Fixed in [7c6bc1a1].

Note: See TracTickets for help on using tickets.