summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2003-06-11 18:16:32 +0000
committerDries Buytaert <dries@buytaert.net>2003-06-11 18:16:32 +0000
commit3b8c99d91e3733427e9f821ed385f097d18e8ffa (patch)
tree34ec7c5574a1c00d348eb371de067f25625ec125 /database
parentc6eede081fa9d88c4ece2ca96f5369dcbebff189 (diff)
downloadbrdo-3b8c99d91e3733427e9f821ed385f097d18e8ffa.tar.gz
brdo-3b8c99d91e3733427e9f821ed385f097d18e8ffa.tar.bz2
- Bugfix: fixed the CREATE FUNCTION in database.mssql as it needs to be prefixed with GO for some obscure reason. Patch by Kjartan.
- Bugfix: fixed the defaults for blocks in database.mssql so the NOT NULL fields get values. Patch by Kjartan. - Bugfix: changed check_form() to use htmlspecialchars() instead of drupal_specialchars() as this caused Drupal to emit incorrect form items in presence of quotes. Example: <input type="submit" class="form-submit" name="op" value="Submit "top nodes" block changes" /> IMO, drupal_specialchars() is better called xmlspecialchars() to avoid confusion. - Bugfix: when an anonymous user visits a site, they shouldn't see any content (except the login block, if it is enabled) unless they have the "access content" permissions. Patch by Matt Westgate. - Improvement: improved the error checking and the error messages in the profile module. Updated the code to match the Drupal coding conventions. Modified patch from Matt Westgate. - Improvement: don't generate the <base href=""> tag in the base theme; it is already emitted by theme_head(). Patch by Kristjan. - Improvement: don't execute any SQL queries when checking the permissions of user #1. Patch by Kjartan. - Improvement: made a scalable layout form that works in IE and that behaves better with narrow themes. Part of patch #51 by Al. - Improvement: removed some redundant print statements from the comment module. Modified patch from Craig Courtney.
Diffstat (limited to 'database')
-rw-r--r--database/database.mssql11
1 files changed, 8 insertions, 3 deletions
diff --git a/database/database.mssql b/database/database.mssql
index 9ba7ea501..f4b60db69 100644
--- a/database/database.mssql
+++ b/database/database.mssql
@@ -1,3 +1,7 @@
+---
+--- Table definitions
+---
+
CREATE TABLE [dbo].[access] (
[aid] [smallint] NULL ,
[mask] [varchar] (255) NOT NULL ,
@@ -460,13 +464,15 @@ INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Intern
INSERT INTO variable(name,value) VALUES('update_start', 's:10:"2002-05-15";');
INSERT INTO variable(name,value) VALUES('theme_default','s:6:"marvin";');
-INSERT INTO blocks(module,delta,status) VALUES('user', '0', '1');
-INSERT INTO blocks(module,delta,status) VALUES('user', '1', '1');
+INSERT INTO blocks(module,delta,status,custom,region,weight,path) VALUES('user', 0, 1, 0, 1, 0, '');
+INSERT INTO blocks(module,delta,status,custom,region,weight,path) VALUES('user', 1, 1, 0, 1, 0, '');
+
---
--- Functions. Functions first available in SQL Server 2000. GREATEST() used by forum.module, tracker.module at the moment.
---
+GO
CREATE FUNCTION GREATEST (@a int, @b int)
RETURNS int AS
BEGIN
@@ -476,4 +482,3 @@ BEGIN
END
RETURN @b;
END
-