/*
   2012. július 16.11:27:54
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker
   Application: 
*/

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wf_cikkek
	DROP CONSTRAINT DF_wf_cikkek_jellemzo1
GO
ALTER TABLE dbo.wf_cikkek
	DROP COLUMN jellemzo1
GO
COMMIT
go

/*
   2012. július 16.11:29:02
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker
   Application: 
*/

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wf_cikkek ADD
	gycikk_szam dbo.cikk_szam NOT NULL CONSTRAINT DF_wf_cikkek_gycikk_szam DEFAULT ''
GO
COMMIT
go

/*
   2012. július 16.11:31:30
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker
   Application: 
*/

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wf_cikkek ADD
	chips_ados char(1) NOT NULL CONSTRAINT DF_wf_cikkek_chips_ados DEFAULT '0',
	vpop_platofok dbo.mennyiseg NOT NULL CONSTRAINT DF_wf_cikkek_vpop_platofok DEFAULT 0
GO
COMMIT
go