From 3b8c99d91e3733427e9f821ed385f097d18e8ffa Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 11 Jun 2003 18:16:32 +0000 Subject: - 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: 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 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. --- database/database.mssql | 11 ++++++++--- 1 file changed, 8 insertions(+), 3 deletions(-) (limited to 'database') 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 - -- cgit v1.2.3