[tcdb-devel] SF.net SVN: tcdb: [7] Schema/TCDBSQLServer2005.sql

[<jon...@us...>]

Revision: 7
Author:   jon_r_johnson
Date:     2006-05-26 12:12:46 -0700 (Fri, 26 May 2006)
ViewCVS:  http://svn.sourceforge.net/tcdb/?rev=7&view=rev

Log Message:
-----------


Modified Paths:
--------------
    Schema/TCDBSQLServer2005.sql
Modified: Schema/TCDBSQLServer2005.sql
===================================================================
--- Schema/TCDBSQLServer2005.sql	2006-05-26 18:51:10 UTC (rev 6)
+++ Schema/TCDBSQLServer2005.sql	2006-05-26 19:12:46 UTC (rev 7)
@@ -152,11 +152,12 @@
 	[resultID] [bigint] IDENTITY(1,1) NOT NULL,
 	[name] [varchar](255) NULL,
 	[statusEnum] [int] NULL,
+	[code] [text] NULL,
  CONSTRAINT [PK_tcdb_result] PRIMARY KEY CLUSTERED 
 (
 	[resultID] ASC
 )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
-) ON [PRIMARY]
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 END
 GO
 SET ANSI_NULLS ON
@@ -543,12 +544,16 @@
   @firstName varchar(24),  
   @lastName varchar(24),  
   @email varchar(50),  
-  @officePhone varchar(14),  
-  @homePhone varchar(14),  
-  @cellPhone varchar(14),  
-  @automation bit  
+  @officePhone varchar(14) = null,  
+  @homePhone varchar(14) = null,  
+  @cellPhone varchar(14) = null,  
+  @automation bit = null
 ) as  
 
+-- 2006/05/24	JRJ		Default to Normal Person
+if (@automation is null)
+  set @automation = 0
+
 -- 2006/05/24	JRJ		Corrected table name  
 insert into tcdb_user  
 select  
@@ -585,37 +590,6 @@
 GO
 SET QUOTED_IDENTIFIER ON
 GO
-IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND type in (N'U'))
-BEGIN
-CREATE TABLE [dbo].[tcdb_user](
-	[userID] [int] IDENTITY(1,1) NOT NULL,
-	[email] [varchar](50) NOT NULL,
-	[officePhone] [varchar](14) NULL,
-	[homePhone] [varchar](14) NULL,
-	[cellPhone] [varchar](14) NULL,
-	[firstName] [varchar](24) NOT NULL,
-	[lastName] [varchar](24) NOT NULL,
-	[automation] [bit] NULL,
- CONSTRAINT [PK_tcdb_user] PRIMARY KEY CLUSTERED 
-(
-	[email] ASC,
-	[firstName] ASC,
-	[lastName] ASC
-)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
-) ON [PRIMARY]
-END
-GO
-
-IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND name = N'ix_userID')
-CREATE UNIQUE NONCLUSTERED INDEX [ix_userID] ON [dbo].[tcdb_user] 
-(
-	[userID] ASC
-)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
-GO
-SET ANSI_NULLS ON
-GO
-SET QUOTED_IDENTIFIER ON
-GO
 IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_platformVersion]') AND type in (N'U'))
 BEGIN
 CREATE TABLE [dbo].[tcdb_platformVersion](
@@ -697,6 +671,37 @@
 GO
 SET QUOTED_IDENTIFIER ON
 GO
+IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND type in (N'U'))
+BEGIN
+CREATE TABLE [dbo].[tcdb_user](
+	[userID] [int] IDENTITY(1,1) NOT NULL,
+	[email] [varchar](50) NOT NULL,
+	[officePhone] [varchar](14) NULL,
+	[homePhone] [varchar](14) NULL,
+	[cellPhone] [varchar](14) NULL,
+	[firstName] [varchar](24) NOT NULL,
+	[lastName] [varchar](24) NOT NULL,
+	[automation] [bit] NOT NULL,
+ CONSTRAINT [PK_tcdb_user] PRIMARY KEY CLUSTERED 
+(
+	[email] ASC,
+	[firstName] ASC,
+	[lastName] ASC
+)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
+) ON [PRIMARY]
+END
+GO
+
+IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND name = N'ix_userID')
+CREATE UNIQUE NONCLUSTERED INDEX [ix_userID] ON [dbo].[tcdb_user] 
+(
+	[userID] ASC
+)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
+GO
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
 IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_build]') AND type in (N'U'))
 BEGIN
 CREATE TABLE [dbo].[tcdb_build](


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.