Ticket #291 (closed defect: invalid)
SQL Server 'Create' script error
| Reported by: | ryan | Owned by: | somebody |
|---|---|---|---|
| Priority: | low | Milestone: | |
| Version: | Severity: | minor | |
| Keywords: | Cc: |
Description
field 'author' is defined twice, error on creation.
CREATE TABLE [dbo].[pages] (
[id] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [path] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [body] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [datetimecreated] [datetime] NOT NULL , [author] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [version] [int] NOT NULL , [summary] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [categories] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [authrolestoview] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [authrolestoedit] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [filename] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [filesize] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [filemimetype] [nvarchar] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [imagewidth] [int] NULL , [imageheight] [int] NULL, [author] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
![(please configure the [header_logo] section in trac.ini)](/ModelGlue.com/trac.cgi/chrome/site/your_project_logo.png)