| Server IP : 213.186.33.4 / Your IP : 216.73.217.131 Web Server : Apache System : Linux webm006.cluster103.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : awebpaca ( 35430) PHP Version : 8.5.0 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/awebpaca/blog/administrator/components/com_admin/sql/updates/sqlazure/ |
Upload File : |
-- Change default value for enabled column. DECLARE @table AS nvarchar(100) DECLARE @constraintName AS nvarchar(100) DECLARE @constraintQuery AS nvarchar(1000) SET QUOTED_IDENTIFIER OFF SET @table = "#__extensions" SET QUOTED_IDENTIFIER ON SELECT @constraintName = name FROM sys.default_constraints WHERE parent_object_id = object_id(@table) AND parent_column_id = columnproperty(object_id(@table), 'enabled', 'ColumnId') SET @constraintQuery = 'ALTER TABLE [' + @table + '] DROP CONSTRAINT [' + @constraintName + ']; ALTER TABLE [' + @table + '] ADD CONSTRAINT [' + @constraintName + '] DEFAULT 0 FOR [enabled]' EXECUTE sp_executesql @constraintQuery;