Issue Manager ®

CREATE

CREATE TABLE with the PRIMARY KEY being established in the ISSUE ID, Create ISSUE ID as an integer value starting at 1 and incrementing by one.

Given this example, we used the CREATE SCRIPT feature in MANAGEMENT STUDIO to create this script after it was manually created using the WYSIWYG Editor

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[IssueManager](
	[IssueID] [int] IDENTITY(1,1) NOT NULL,
	[UserAccountIDCreator] [int] NULL,
	[UserAccountIDAssigned] [int] NULL,
	[IssueTitle] [varchar](255) NULL,
	[IssueDescription] [varchar](max) NULL,
	[IssueComment] [varchar](max) NULL,
	[IPAddress] [varchar](50) NULL,
	[DateCreated] [datetime] NULL,
	[DateUpdated] [datetime] NULL,
	[DateClosed] [datetime] NULL,
 CONSTRAINT [PK_IssueManager] PRIMARY KEY CLUSTERED 
(
	[IssueID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER

ALTER TABLE setting the default for DATE CREATED to today's date using the function getDate()

Given this example, we used the CREATE SCRIPT feature in MANAGEMENT STUDIO to create this script after it was manually created using the WYSIWYG Editor

ALTER TABLE [dbo].[IssueManager] ADD  CONSTRAINT [DF_IssueManager_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO

Issue Manager

This is the MAIN table that hold most of the information about the issue. All other tables are related to this MAIN table. The PRIMARY KEY (PK) is called IssueID.