From d64bc008fdff5cad8634395c375a744b8fe960d4 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Fri, 17 Oct 2003 16:10:48 +0000
Subject: Patch by Moshe:

- comment.module: fixed an ambigous 'timestamp' query

- forum.module: prev/next links no longer excerpt from the title+body in
their title attribute. they now excerpt from only their title. this is
more consistent with rest of drupal, and GROUP BY on node.body which
isn't appreciated by MSSQL. also replaced some '' with NULL which caused
errors in MSSQL

- statistics.module: replaced a USING join with a standard ON join. USING
is not as widely supported, and functionally equivalent.
---
 database/database.mssql | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'database')

diff --git a/database/database.mssql b/database/database.mssql
index 663697e2c..f323cd207 100644
--- a/database/database.mssql
+++ b/database/database.mssql
@@ -113,7 +113,7 @@ GO
 CREATE TABLE [dbo].[forum] (
   [nid] [numeric](10, 0) NOT NULL ,
   [tid] [numeric](10, 0) NOT NULL ,
-  [icon] [varchar] (255) NOT NULL ,
+  [icon] [varchar] (255) NULL ,
   [shadow] [numeric](10, 0) NOT NULL
 ) ON [PRIMARY]
 GO
@@ -369,6 +369,12 @@ CREATE TABLE [dbo].[users] (
 --ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 GO
 
+CREATE TABLE [dbo].[users_uid_seq] (
+  [id] [int] IDENTITY (1, 1) NOT NULL ,
+  [vapor] [int] NULL
+) ON [PRIMARY]
+GO
+
 CREATE TABLE [dbo].[variable] (
   [name] [varchar] (32) NOT NULL ,
   [value] [varchar] (8000) NOT NULL
-- 
cgit v1.2.3