SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Accounts](
	[AccountId] [int] IDENTITY(1,1) NOT NULL,
	[Lastname] [nvarchar](30) NOT NULL,
	[Firstname] [nvarchar](20) NOT NULL,
	[Phone] [varchar](15) NOT NULL,
	[SumTotal] [decimal](9, 1) NOT NULL,
 CONSTRAINT [PK_Accounts] PRIMARY KEY CLUSTERED
(
	[AccountId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Calls]    Script Date: 12/06/2015 17:47:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Calls](
	[CallId] [int] IDENTITY(1,1) NOT NULL,
	[AccountId] [int] NOT NULL,
	[CountryId] [int] NOT NULL,
	[Duration] [int] NOT NULL,
	[Date] [datetime] NOT NULL,
 CONSTRAINT [PK_Calls] PRIMARY KEY CLUSTERED
(
	[CallId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Countries]    Script Date: 12/06/2015 17:47:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Countries](
	[CountryId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](30) NOT NULL,
	[Price] [decimal](4, 1) NOT NULL,
 CONSTRAINT [PK_Countries] PRIMARY KEY CLUSTERED
(
	[CountryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[Accounts] ON

GO
INSERT [dbo].[Accounts] ([AccountId], [Lastname], [Firstname], [Phone], [SumTotal]) VALUES (3, N'Ewart', N'Mathew', N'2383590', CAST(54.0 AS Decimal(9, 1)))
GO
INSERT [dbo].[Accounts] ([AccountId], [Lastname], [Firstname], [Phone], [SumTotal]) VALUES (4, N'Marcello', N'Tyrone', N'2591048', CAST(78.0 AS Decimal(9, 1)))
GO
INSERT [dbo].[Accounts] ([AccountId], [Lastname], [Firstname], [Phone], [SumTotal]) VALUES (6, N'Jasmine ', N'Hobson', N'2839247', CAST(43.0 AS Decimal(9, 1)))
GO
INSERT [dbo].[Accounts] ([AccountId], [Lastname], [Firstname], [Phone], [SumTotal]) VALUES (7, N'Hartigan', N'Josef', N'2023349', CAST(239.0 AS Decimal(9, 1)))
GO
INSERT [dbo].[Accounts] ([AccountId], [Lastname], [Firstname], [Phone], [SumTotal]) VALUES (8, N'Balsamo', N'Tessa', N'2671097', CAST(125.0 AS Decimal(9, 1)))
GO
SET IDENTITY_INSERT [dbo].[Accounts] OFF
GO
SET IDENTITY_INSERT [dbo].[Countries] ON

GO
INSERT [dbo].[Countries] ([CountryId], [Name], [Price]) VALUES (1, N'Canada', CAST(7.0 AS Decimal(4, 1)))
GO
INSERT [dbo].[Countries] ([CountryId], [Name], [Price]) VALUES (2, N'China', CAST(4.5 AS Decimal(4, 1)))
GO
INSERT [dbo].[Countries] ([CountryId], [Name], [Price]) VALUES (3, N'United Kingdom', CAST(8.0 AS Decimal(4, 1)))
GO
INSERT [dbo].[Countries] ([CountryId], [Name], [Price]) VALUES (4, N'USA', CAST(6.0 AS Decimal(4, 1)))
GO
SET IDENTITY_INSERT [dbo].[Countries] OFF
GO
ALTER TABLE [dbo].[Calls]  WITH CHECK ADD  CONSTRAINT [FK_Calls_Accounts] FOREIGN KEY([AccountId])
REFERENCES [dbo].[Accounts] ([AccountId])
GO
ALTER TABLE [dbo].[Calls] CHECK CONSTRAINT [FK_Calls_Accounts]
GO
ALTER TABLE [dbo].[Calls]  WITH CHECK ADD  CONSTRAINT [FK_Calls_Countries] FOREIGN KEY([CountryId])
REFERENCES [dbo].[Countries] ([CountryId])
GO
ALTER TABLE [dbo].[Calls] CHECK CONSTRAINT [FK_Calls_Countries]
GO


-----------
app.config + configmanager 4
yvela monacemebis chatvirtva
search button for countries using parameter
messagebox