32SJKrpi

1-- Номенклатура: Телефонни типове
2IF NOT EXISTS (SELECT [NAME] FROM TOP_NOMS WHERE [NOMID] = 628)
3BEGIN
4	INSERT INTO TOP_NOMS
5		   ( [CHECKSUM], [STATUS], TRCODE, HIST_USER_INI, HIST_LAST_DATE, NOMID, SIZE, [NAME] )
6	VALUES
7		   ( 0, 0x0, 0, '', GETDATE(), 628, 1 , 'Телефонни типове' )
8END
9GO
10
11-- Номенклатура: Градове
12IF NOT EXISTS (SELECT [NAME] FROM TOP_NOMS WHERE [NOMID] = 629)
13BEGIN
14	INSERT INTO TOP_NOMS
15		   ( [CHECKSUM], [STATUS], TRCODE, HIST_USER_INI, HIST_LAST_DATE, NOMID, SIZE, [NAME] )
16	VALUES
17		   ( 0, 0x0, 0, '', GETDATE(), 629, 4 , 'Градове' )
18END
19GO
20
21IF( OBJECT_ID('NM629', 'U') IS NULL )
22BEGIN
23
24	CREATE TABLE NM629 
25	( 
26		[CHECKSUM]			[smallint]		NOT NULL,
27		[STATUS]			dbo.STATUS		NOT NULL,
28		[TRCODE]			[int]			NOT NULL,
29		[HIST_USER_INI]		[INIC]			NOT NULL,
30		[HIST_LAST_DATE]    [DateTime]      NOT NULL,
31		[NOMID]				[smallint]		NOT NULL,
32		[CODE]				[int]			NOT NULL,
33		[REGION]			[char](128)		NOT NULL,
34
35		CONSTRAINT PK_NM629_CODE PRIMARY KEY (CODE),
36		CONSTRAINT FK_NM629_NOMID_CODE FOREIGN KEY (NOMID, CODE)
37		REFERENCES NOMS(NOMID, CODE)
38	)
39	EXEC dbo.SP_ADD_COUNTER 'NM629', 'NM629', 'CODE'
40
41END
42ELSE
43	DROP TABLE NM629
44GO
45
46EXEC SP_CREATE_HISTORY 'NM629'
47
48USE BPB_VCSBank_Archive
49EXEC SP_CREATE_HISTORY 'MLNIKOLOV\SQL2016', 'BPB_VCSBank_Online', 2020, 0, 'NM629'
50
51USE BPB_VCSBank_Online