diff options
Diffstat (limited to 'mcs/class/System.Data/Test/ProviderTests/sql')
3 files changed, 22 insertions, 4 deletions
diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog b/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog index b16ad3e8f4d..7d1a0926a6a 100644 --- a/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog +++ b/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog @@ -1,3 +1,10 @@ +2005-09-24 Sureshkumar T <tsureshkumar@novell.com> + + * sybase.sql: grant permissions on objects + + * sqlserver.sql: change id as int. tiny int won't allow 6000 (the + tempory updatable limit). + 2005-09-16 Senganal T <tsenganal@novell.com> * sqlserver.sql: modified. added string_family, datetime_family, diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql b/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql index 117b41ae1d3..4c1cad0956f 100644 --- a/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql +++ b/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql @@ -3,6 +3,7 @@ if exists (select name from sysdatabases where drop database [mono-test]; create database [mono-test]; grant all privileges on [mono-test] to monotester; +go use monotest; @@ -14,7 +15,8 @@ if exists (select name from sysobjects where drop table numeric_family; go -create table numeric_family(id tinyint PRIMARY KEY NOT NULL, +create table numeric_family( + id int PRIMARY KEY NOT NULL, type_bit bit NULL, type_tinyint tinyint NULL, type_smallint smallint NULL, @@ -47,7 +49,7 @@ if exists (select name from sysobjects where go create table binary_family ( - id tinyint PRIMARY KEY NOT NULL, + id int PRIMARY KEY NOT NULL, type_binary binary NULL, type_varbinary varbinary (255) NULL, type_blob image NULL, @@ -78,7 +80,8 @@ if exists (select name from sysobjects where drop table string_family; go -create table string_family(id tinyint PRIMARY KEY NOT NULL, +create table string_family( + id int PRIMARY KEY NOT NULL, type_guid uniqueidentifier NULL, type_char char(10) NULL, type_varchar varchar(10) NULL, @@ -105,7 +108,7 @@ if exists (select name from sysobjects where go create table datetime_family ( - id tinyint PRIMARY KEY NOT NULL, + id int PRIMARY KEY NOT NULL, type_smalldatetime smalldatetime NULL, type_datetime datetime NULL); diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/sybase.sql b/mcs/class/System.Data/Test/ProviderTests/sql/sybase.sql index 2d31ee3ad57..0f84f1091e7 100644 --- a/mcs/class/System.Data/Test/ProviderTests/sql/sybase.sql +++ b/mcs/class/System.Data/Test/ProviderTests/sql/sybase.sql @@ -20,6 +20,8 @@ create table numeric_family ( type_numeric numeric (38, 0) NULL, type_money money NULL, type_smallmoney smallmoney NULL) + +grant all on numeric_family to monotester go insert into numeric_family values (1,1,255,32767,2147483647,9223372036854775807,1000,1000,922337203685477.5807,214748.3647) @@ -46,6 +48,8 @@ create table binary_family ( type_tinyblob image NULL, type_mediumblob image NULL, type_longblob_image image NULL) + +grant all on binary_family to monotester go insert into binary_family values (1, convert (binary, '555555'), convert (varbinary, '0123456789012345678901234567890123456789012345678901234567890123456789'), @@ -98,6 +102,8 @@ begin end go +grant all on sp_clean_employee_table to monotester +go -- SP : sp_get_age if exists (select name from sysobjects where @@ -115,6 +121,8 @@ begin end go +grant all on sp_get_age to monotester +go -- =================================== END OBJECT EMPLOYEE ============================ |