summaryrefslogtreecommitdiffstats
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert2003-10-17 16:10:48 (GMT)
committerDries Buytaert2003-10-17 16:10:48 (GMT)
commitd64bc008fdff5cad8634395c375a744b8fe960d4 (patch)
treea470fbdbc4b7dca7d206c994c822dccfa9e95821 /database
parent3c3c556c55555f431e388600f36cfa54959fc254 (diff)
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.
Diffstat (limited to 'database')
-rw-r--r--database/database.mssql8
1 files changed, 7 insertions, 1 deletions
diff --git a/database/database.mssql b/database/database.mssql
index 663697e..f323cd2 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