/*
   2010. február 23.16:17:09
   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.szallito
	DROP CONSTRAINT FK_SZALLITO_SZALLCSOPORT
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szallito
	DROP CONSTRAINT FK_SZALLITO_BELEPES
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_szallito
	(
	SZALL_KOD dbo.kulcs NOT NULL IDENTITY (1, 1),
	SZALL_NEV dbo.nev NOT NULL,
	VAROS dbo.nev NOT NULL,
	IRANYITO dbo.nev NOT NULL,
	CIM dbo.nev NOT NULL,
	TELEFON dbo.nev NULL,
	FAX dbo.nev NULL,
	KAPCSOLAT dbo.nev NULL,
	ADOSZAM dbo.nev NULL,
	eu_adoszam dbo.nev NULL,
	BANK dbo.nev NULL,
	FIZMOD char(1) NOT NULL,
	FIZHAT int NOT NULL,
	SZALLCSOP int NOT NULL,
	MAX_KESZLET dbo.egyseg_ar NOT NULL,
	orszag dbo.nev NOT NULL,
	jovedeki dbo.nev NOT NULL,
	email varchar(512) NULL,
	szorzo dbo.egyseg_ar NULL,
	modositva dbo.datum_ora NOT NULL,
	kicsoda dbo.kicsoda NOT NULL
	)  ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_szallito ON
GO
IF EXISTS(SELECT * FROM dbo.szallito)
	 EXEC('INSERT INTO dbo.Tmp_szallito (SZALL_KOD, SZALL_NEV, VAROS, IRANYITO, CIM, TELEFON, FAX, KAPCSOLAT, ADOSZAM, eu_adoszam, BANK, FIZMOD, FIZHAT, SZALLCSOP, MAX_KESZLET, orszag, jovedeki, modositva, kicsoda)
		SELECT SZALL_KOD, SZALL_NEV, VAROS, IRANYITO, CIM, TELEFON, FAX, KAPCSOLAT, ADOSZAM, eu_adoszam, BANK, FIZMOD, FIZHAT, SZALLCSOP, MAX_KESZLET, orszag, jovedeki, modositva, kicsoda FROM dbo.szallito WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_szallito OFF
GO
ALTER TABLE dbo.szall_szlaf
	DROP CONSTRAINT FK_szall_szlaf_szallito
GO
ALTER TABLE dbo.szall_szlef
	DROP CONSTRAINT FK_szall_szlef_szallito
GO
ALTER TABLE dbo.szbiz_szlef
	DROP CONSTRAINT FK_szbiz_szlef_szallito
GO
ALTER TABLE dbo.szallito_bank
	DROP CONSTRAINT FK_szallito_bank_SZALLITO
GO
ALTER TABLE dbo.szall_renf
	DROP CONSTRAINT FK_szall_renf_szallito
GO
ALTER TABLE dbo.vevo_szall
	DROP CONSTRAINT FK_vevo_szall_szallito
GO
DROP TABLE dbo.szallito
GO
EXECUTE sp_rename N'dbo.Tmp_szallito', N'szallito', 'OBJECT' 
GO
ALTER TABLE dbo.szallito ADD CONSTRAINT
	PK_SZALLITO PRIMARY KEY CLUSTERED 
	(
	SZALL_KOD
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_SZALLITO ON dbo.szallito
	(
	SZALL_NEV
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_SZALLITO_1 ON dbo.szallito
	(
	SZALLCSOP
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.szallito ADD CONSTRAINT
	FK_SZALLITO_BELEPES FOREIGN KEY
	(
	kicsoda
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szallito ADD CONSTRAINT
	FK_SZALLITO_SZALLCSOPORT FOREIGN KEY
	(
	SZALLCSOP
	) REFERENCES dbo.szallcsoport
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szall ADD CONSTRAINT
	FK_vevo_szall_szallito FOREIGN KEY
	(
	szall_kod
	) REFERENCES dbo.szallito
	(
	SZALL_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_renf ADD CONSTRAINT
	FK_szall_renf_szallito FOREIGN KEY
	(
	szallito
	) REFERENCES dbo.szallito
	(
	SZALL_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szallito_bank ADD CONSTRAINT
	FK_szallito_bank_SZALLITO FOREIGN KEY
	(
	szall_kod
	) REFERENCES dbo.szallito
	(
	SZALL_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szbiz_szlef ADD CONSTRAINT
	FK_szbiz_szlef_szallito FOREIGN KEY
	(
	SZALLITO
	) REFERENCES dbo.szallito
	(
	SZALL_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlef ADD CONSTRAINT
	FK_szall_szlef_szallito FOREIGN KEY
	(
	SZALLITO
	) REFERENCES dbo.szallito
	(
	SZALL_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlaf ADD CONSTRAINT
	FK_szall_szlaf_szallito FOREIGN KEY
	(
	SZALLITO
	) REFERENCES dbo.szallito
	(
	SZALL_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go


update szallito set email='', szorzo=0
go