USE [Church]
GO

/****** Object:  Table [dbo].[ServantsTitles]    ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****** Object:  Table [dbo].[ServantsTitles]    ******/
--SET IDENTITY_INSERT [dbo].[ServantsTitles] ON
INSERT INTO [dbo].[ServantsTitles] ([Name])
VALUES (N'Pastor')

INSERT INTO [dbo].[ServantsTitles] ([Name])
VALUES (N'Prezbiter')

INSERT INTO [dbo].[ServantsTitles] ([Name])
VALUES (N'Diacon')

INSERT INTO [dbo].[ServantsTitles] ([Name])
VALUES (N'Lider tineret')
SET IDENTITY_INSERT [dbo].[ServantsTitles] OFF

GO


/****** Object:  Table [dbo].[PropertiesTypes]    ******/
--SET IDENTITY_INSERT [dbo].[PropertiesTypes] ON

INSERT INTO [dbo].[PropertiesTypes] ([Name])
VALUES (N'Masina')

INSERT INTO [dbo].[PropertiesTypes] ([Name])
VALUES (N'Casa')

INSERT INTO [dbo].[PropertiesTypes] ([Name])
VALUES (N'Teren')

INSERT INTO [dbo].[PropertiesTypes] ([Name])
VALUES (N'Apartament')

INSERT INTO [dbo].[PropertiesTypes] ([Name])
VALUES (N'Garsoniera')
SET IDENTITY_INSERT [dbo].[PropertiesTypes] OFF

GO

/****** Object:  Table [dbo].[Jobs]    ******/
--SET IDENTITY_INSERT [dbo].[Jobs] ON

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'<Alta ocupatie>')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Instalator')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Electrician')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Programator')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Inginer')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Economist')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Medic')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Profesor')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Invatator')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Educator')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Agricultor')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Vanzator')

INSERT INTO [dbo].[Jobs] ([Name])
VALUES (N'Zidar')

SET IDENTITY_INSERT [dbo].[Jobs] OFF

GO

/****** Object:  Table [dbo].[GroupsTypes]    ******/
--SET IDENTITY_INSERT [dbo].[GroupsTypes] ON

INSERT INTO [dbo].[GroupsTypes] ([Name])
VALUES (N'Cor mixt')

INSERT INTO [dbo].[GroupsTypes] ([Name])
VALUES (N'Cor barbatesc')

INSERT INTO [dbo].[GroupsTypes] ([Name])
VALUES (N'Cor copii')

INSERT INTO [dbo].[GroupsTypes] ([Name])
VALUES (N'Scoala Duminicala cls. I-IV')

INSERT INTO [dbo].[GroupsTypes] ([Name])
VALUES (N'Scoala Duminicala cls. V-VIII')

INSERT INTO [dbo].[GroupsTypes] ([Name])
VALUES (N'Fanfara')

INSERT INTO [dbo].[GroupsTypes] ([Name])
VALUES (N'Orchestra')
SET IDENTITY_INSERT [dbo].[GroupsTypes] OFF

GO

/****** Object:  Table [dbo].[Districts]    ******/
--SET IDENTITY_INSERT [dbo].[Districts] ON

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'<Alt Cartier>')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Manastur')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Marasti')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Gheorgheni')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Grigorescu')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Buna Ziua')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Iris')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Dambul Rotund')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Andrei Muresanu')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Centru')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Bulgaria')

INSERT INTO [dbo].[Districts] ([Name])
VALUES (N'Zorilor')

SET IDENTITY_INSERT [dbo].[Districts] OFF

GO

/****** Object:  Table [dbo].[Churches]    ******/
--SET IDENTITY_INSERT [dbo].[Churches] ON
INSERT INTO [dbo].[Churches] ([Name], [Address], [IsChild])
VALUES (N'Betel', N'Cluj-Napoca', 0)

INSERT INTO [dbo].[Churches] ([Name], [Address], [IsChild])
VALUES (N'Prunis', N'Prunis', 1)

INSERT INTO [dbo].[Churches] ([Name], [Address], [IsChild])
VALUES (N'Borsa', N'Borsa', 1)

INSERT INTO [dbo].[Churches] ([Name], [Address], [IsChild])
VALUES (N'Cristorel', N'Cristorel', 1)

INSERT INTO [dbo].[Churches] ([Name], [Address], [IsChild])
VALUES (N'Filea de Jos', N'Filea de Jos', 1)

INSERT INTO [dbo].[Churches] ([Name], [Address], [IsChild])
VALUES (N'Feiurdeni', N'Feiurdeni', 1)

SET IDENTITY_INSERT [dbo].[Churches] OFF
 --GO


/****** Object:  Table [dbo].[ChurchesProperties]    ******/
--SET IDENTITY_INSERT [dbo].[ChurchesProperties] ON
DECLARE @mainCurchID int;
SELECT @mainCurchID = ChurchID FROM Churches WHERE IsChild = 0

INSERT INTO [dbo].[ChurchesProperties] ([ChurchID], [Property], [Count])
VALUES (@mainCurchID, N'Scaune', 300)

INSERT INTO [dbo].[ChurchesProperties] ([ChurchID], [Property], [Count])
VALUES (@mainCurchID, N'Farfurii model M', 500)

INSERT INTO [dbo].[ChurchesProperties] ([ChurchID], [Property], [Count])
VALUES (@mainCurchID, N'Pahare model M', 500)

INSERT INTO [dbo].[ChurchesProperties] ([ChurchID], [Property], [Count])
VALUES (@mainCurchID, N'Linguri', 500)

INSERT INTO [dbo].[ChurchesProperties] ([ChurchID], [Property], [Count])
VALUES (@mainCurchID, N'Furculite', 500)

INSERT INTO [dbo].[ChurchesProperties] ([ChurchID], [Property], [Count])
VALUES (@mainCurchID, N'Cutite', 500)

SET IDENTITY_INSERT [dbo].[ChurchesProperties] OFF

GO


/****** Object:  Table [dbo].[RegistersTypes]    ******/
-- SET IDENTITY_INSERT [dbo].[RegistersTypes] ON

INSERT INTO [dbo].[RegistersTypes] ([Name])
VALUES (N'Registru Apartinatori')

INSERT INTO [dbo].[RegistersTypes] ([Name])
VALUES (N'Registru Membri')

SET IDENTITY_INSERT [dbo].[RegistersTypes] OFF

GO

/****** Object:  Table [dbo].[FamiliesRegistersTypes]    ******/
--SET IDENTITY_INSERT [dbo].[FamiliesRegistersTypes] ON

INSERT INTO [dbo].[FamiliesRegistersTypes] ([Name])
VALUES (N'Registru Familii')

SET IDENTITY_INSERT [dbo].[FamiliesRegistersTypes] OFF

GO
