Ticket #291 (closed defect: invalid)

Opened 19 years ago

Last modified 19 years ago

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

Attachments

sqlserver.sql (2.3 kB) - added by ryan 19 years ago.
SQl Server Create script

Change History

Changed 19 years ago by ryan

SQl Server Create script

Changed 19 years ago by joe.rinehart

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

I honestly have no idea what this refers to. The only CREATE TABLE statements in my source code are the widget samples, which have no table 'pages'.

Note: See TracTickets for help on using tickets.