Ticket #1486020 (closed Bugs: fixed)

Opened 13 months ago

Last modified 13 months ago

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

mssql.initial.sql.diff (1.9 KB) - added by Gliese 13 months ago.

Change History

Changed 13 months ago by Gliese

Changed 13 months ago by alec

  • status changed from new to closed
  • resolution set to fixed

Fixed in r2829.

Note: See TracTickets for help on using tickets.