SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
SET DATEFORMAT YMD
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv BINARY(16)
BEGIN TRANSACTION
-- Add 1 row to [dbo].[firma]
INSERT INTO [dbo].[firma] ([firmaadi], [ssksicilno], [arkaresim], [yetkili], [adres1], [adres2], [tel], [fax], [email], [gsm], [vda], [vno], [banka1], [hesap1], [banka2], [hesap2], [banka3], [hesap3], [foto]) VALUES (N'SoykanSoft ', N'12345678901 ', NULL, N'Soykan ÖZÇELİK ', N'address ', NULL, NULL, NULL, N'soykan@soykansoft.com ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'firma_foto.png ')
-- Add 1 row to [dbo].[params]
INSERT INTO [dbo].[params] ([_datapath], [_server], [_username], [_password], [_datamode]) VALUES (NULL, N'FOX_W7_RTM', NULL, NULL, N'SQL ')
-- Add 10 rows to [dbo].[cari]
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'{CFC450B0-B346-40D2-A31F-7E4C34AAB54D}', N'S-001 ', N'Soykan ÖZCELIK ')
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'{F91C52C2-F177-485C-A761-578378F5F1D7}', N'C-001 ', N'Cetin BASOZ123 ')
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'0F63D0B4-4F39-448A-9C87-B0A30CD0D5C3 ', N'AO ', N'Ata ÖZÇELİK ')
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'36C4492D-AD8D-472B-9622-814390DF0650 ', N'CC ', N'cihan cakmak ')
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'6C5E5798-2A8D-4114-A8E7-C349A2E95CEF ', N'T001 ', N'Timucin ARAL ')
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'6C79B9DC-0ABF-4E45-9E5A-1AD7F1DD4690 ', N'JUKI ', N'BHFFFF ')
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'89F35A6F-A607-4ECA-9D2A-5DFE0E0B0DA1 ', N'eeeee ', N'eeeee ')
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'AAF7D987-CA94-4969-BEEF-0D5833FB8223 ', N'EY ', N'Erdal YALCIN ')
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'D0BCE6AA-D8B4-4990-9C60-6526ADD2207A ', N'DH ', N'Dila Hatem ÖZÇELİK ')
INSERT INTO [dbo].[cari] ([myguid], [ckodu], [cadi]) VALUES (N'E230D7C7-294C-4C9F-8C19-D98AE47E685C ', N'sdsdf ', N'FFFFFFFFFFFFFFFFFFFF ')
-- Add 2 rows to [dbo].[siparisb]
SET IDENTITY_INSERT [dbo].[siparisb] ON
INSERT INTO [dbo].[siparisb] ([myguid], [sipno], [tarih], [ckodu]) VALUES (N'4526CFAB-9CB4-4932-8BF7-0EDF82B928B2 ', 5, '2009-10-21 00:00:00.000', N'S001 ')
INSERT INTO [dbo].[siparisb] ([myguid], [sipno], [tarih], [ckodu]) VALUES (N'75684BA5-BBDA-4C95-B210-9B5CC466602D ', 6, '2009-12-04 00:00:00.000', N'BEN ')
SET IDENTITY_INSERT [dbo].[siparisb] OFF
-- Add 8 rows to [dbo].[siparisd]
INSERT INTO [dbo].[siparisd] ([myguid], [sipno], [skodu], [miktar], [fiyat], [tutar], [pmyguid]) VALUES (N'1383F0DF-2DE5-46E1-8BE0-857BCA079682 ', 6, N'HYU ', 11, 23, NULL, N'75684BA5-BBDA-4C95-B210-9B5CC466602D ')
INSERT INTO [dbo].[siparisd] ([myguid], [sipno], [skodu], [miktar], [fiyat], [tutar], [pmyguid]) VALUES (N'317CBB50-F7B6-4CFE-BA2C-BC71C65F57E5 ', 5, N'CCCC ', 78, 78, NULL, N'4526CFAB-9CB4-4932-8BF7-0EDF82B928B2 ')
INSERT INTO [dbo].[siparisd] ([myguid], [sipno], [skodu], [miktar], [fiyat], [tutar], [pmyguid]) VALUES (N'53E88771-DAB7-46E4-A757-93B582A7CADE ', 0, N'O ', 12, 12, NULL, N'{145FE240-B586-46FF-AF9B-1A352C44D9E8}')
INSERT INTO [dbo].[siparisd] ([myguid], [sipno], [skodu], [miktar], [fiyat], [tutar], [pmyguid]) VALUES (N'7CE655B5-4F0C-4AC8-8885-9D3028D8ED4B ', 6, N'HKK ', 12, 3, NULL, N'75684BA5-BBDA-4C95-B210-9B5CC466602D ')
INSERT INTO [dbo].[siparisd] ([myguid], [sipno], [skodu], [miktar], [fiyat], [tutar], [pmyguid]) VALUES (N'9A4251BD-1FD0-46B6-A2EF-1E3B27255EF6 ', 0, N'SQL ', 10, 2, NULL, N'{E08FB2A8-C449-46DA-8E45-CE6D8083E134}')
INSERT INTO [dbo].[siparisd] ([myguid], [sipno], [skodu], [miktar], [fiyat], [tutar], [pmyguid]) VALUES (N'9FC6330D-2769-446D-9502-3A4AD92D006D ', 6, N'HY ', 12, 23, NULL, N'75684BA5-BBDA-4C95-B210-9B5CC466602D ')
INSERT INTO [dbo].[siparisd] ([myguid], [sipno], [skodu], [miktar], [fiyat], [tutar], [pmyguid]) VALUES (N'AE28B9A2-6729-43FD-923B-F6AD3CA2F9C0 ', 6, N'JU ', 23, 23, NULL, N'75684BA5-BBDA-4C95-B210-9B5CC466602D ')
INSERT INTO [dbo].[siparisd] ([myguid], [sipno], [skodu], [miktar], [fiyat], [tutar], [pmyguid]) VALUES (N'E6EF64FB-B1D6-4D2B-B1CA-D8D837C8115D ', 5, N'NHJ ', 334, 34, NULL, N'4526CFAB-9CB4-4932-8BF7-0EDF82B928B2 ')
-- Add 2 rows to [dbo].[stok]
INSERT INTO [dbo].[stok] ([myguid], [skodu], [sadi], [birim]) VALUES (N'D973D582-CF3B-4559-9B45-31DFF5C862C5 ', N'SQL3 ', N'SQL33333 ', N'AD ')
INSERT INTO [dbo].[stok] ([myguid], [skodu], [sadi], [birim]) VALUES (N'E8DD56B2-86E7-447A-B40E-BD7A160C71D2 ', N'SQL ', N'SQLll ', N'm3 ')
COMMIT TRANSACTION
GO