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)
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
Note: See
TracTickets for help on using
tickets.

Fixed in [7c6bc1a1].