diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-10-17 16:10:48 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-10-17 16:10:48 +0000 |
| commit | d64bc008fdff5cad8634395c375a744b8fe960d4 (patch) | |
| tree | a470fbdbc4b7dca7d206c994c822dccfa9e95821 /database | |
| parent | 3c3c556c55555f431e388600f36cfa54959fc254 (diff) | |
| download | brdo-d64bc008fdff5cad8634395c375a744b8fe960d4.tar.gz brdo-d64bc008fdff5cad8634395c375a744b8fe960d4.tar.bz2 | |
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.mssql | 8 |
1 files changed, 7 insertions, 1 deletions
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 |