API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
91
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.11 KB | None | 0 0
raw download clone embed print report
  1. /****** Object: Table [dbo].[Kullanicilar] Script Date: 05/13/2011 20:35:52 ******/
  2. IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kullanicilar]') AND type in (N'U'))
  3. DROP TABLE [dbo].[Kullanicilar]
  4. GO
  5. /****** Object: Table [dbo].[Yetkiler] Script Date: 05/13/2011 20:35:52 ******/
  6. IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Yetkiler]') AND type in (N'U'))
  7. DROP TABLE [dbo].[Yetkiler]
  8. GO
  9. /****** Object: Table [dbo].[Yetkiler] Script Date: 05/13/2011 20:35:52 ******/
  10. SET ANSI_NULLS ON
  11. GO
  12. SET QUOTED_IDENTIFIER ON
  13. GO
  14. IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Yetkiler]') AND type in (N'U'))
  15. BEGIN
  16. CREATE TABLE [dbo].[Yetkiler](
  17. [ID] [int] IDENTITY(1,1) NOT NULL,
  18. [YetkiAdi] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  19. [UstId] [int] NULL,
  20. [AstId] [int] NULL
  21. )
  22. END
  23. GO
  24. SET IDENTITY_INSERT [dbo].[Yetkiler] ON
  25. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (1, N'Sistem Yöneticisi', 0, NULL)
  26. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (2, N'Genel Müdür', 1, NULL)
  27. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (3, N'Bilişim Yetkili', 2, NULL)
  28. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (4, N'Pazarlama Yetkili', 2, NULL)
  29. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (5, N'Muhasebe Yetkili', 2, NULL)
  30. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (6, N'Depo Yetkili', 2, NULL)
  31. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (7, N'Bilişim Kullanıcı', 3, NULL)
  32. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (8, N'Pazarlama Kullanıcı', 4, NULL)
  33. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (9, N'Muhasebe Kullanıcı', 5, NULL)
  34. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (10, N'Depo Kullanıcı', 6, NULL)
  35. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (11, N'Ana Bayi Yetkili', 7, NULL)
  36. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (12, N'Ana Bayi Kullanıcı', 11, NULL)
  37. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (13, N'Alt Bayi Yetkili', 11, NULL)
  38. INSERT [dbo].[Yetkiler] ([ID], [YetkiAdi], [UstId], [AstId]) VALUES (14, N'Alt Bayi Kullanıcı', 13, NULL)
  39. SET IDENTITY_INSERT [dbo].[Yetkiler] OFF
  40. /****** Object: Table [dbo].[Kullanicilar] Script Date: 05/13/2011 20:35:52 ******/
  41. SET ANSI_NULLS ON
  42. GO
  43. SET QUOTED_IDENTIFIER ON
  44. GO
  45. IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Kullanicilar]') AND type in (N'U'))
  46. BEGIN
  47. CREATE TABLE [dbo].[Kullanicilar](
  48. [ID] [int] IDENTITY(1,1) NOT NULL,
  49. [YetkiID] [int] NULL,
  50. [KullaniciAdi] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  51. [Parola] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  52. [TCNo] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  53. [Ad] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  54. [Soyad] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  55. [Email] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  56. [FirmaUnvani] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  57. [BayiAdi] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  58. [Sektor] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  59. [TosKullaniciAdi] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  60. [StatikIp] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  61. [Adres] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  62. [Il] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  63. [Ilce] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  64. [Tel1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  65. [Tel2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  66. [VergiDaire] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  67. [VergiNo] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  68. [AktivasyonTarih] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  69. [SozlesmeTarih] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
  70. )
  71. END
  72. GO
  73. SET IDENTITY_INSERT [dbo].[Kullanicilar] ON
  74. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (1, 1, N'Dursun', N'12345', N'12345678910', N'Dursun', N'Yılmaz', N'dursun@yilmaz.com.tr', N'Netcom Bilgisayar', N'netcom', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  75. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (2, 2, N'İbrahim', N'12345', N'12345678910', N'İbrahim', N'Çam', N'ibrahim@cam.com.tr', N'Netcom Bilgisayar', N'netcom2', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  76. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (3, 3, N'Samet', N'12345', N'12345678910', N'Samet', N'Koçak', N'samet@kocak.com.tr', N'Netcom Bilgisayar', N'netcom3', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  77. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (4, 4, N'Ahmet', N'12345', N'12345678910', N'Ahmet', N'Soyak', N'ahmet@soyak.com.tr', N'Netcom Bilgisayar', N'netcom4', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  78. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (5, 5, N'Zekeriya', N'12345', N'12345678910', N'Zekeriya', N'Tuçay', N'zekeriya@tuncay.com.tr', N'Netcom Bilgisayar', N'netcom5', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  79. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (6, 6, N'Ramazan', N'12345', N'12345678910', N'Ramazan', N'Çıtaksevi', N'ramazan@citaksevi.com.tr', N'Netcom Bilgisayar', N'netcom6', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  80. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (7, 7, N'Zahide', N'12345', N'12345678910', N'Zahide', N'Erdal', N'ramazan@citaksevi.com.tr', N'Netcom Bilgisayar', N'netcom7', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  81. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (8, 8, N'Burak', N'12345', N'12345678910', N'Burak', N'Şahin', N'burak@sahin.com.tr', N'Netcom Bilgisayar', N'netcom8', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  82. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (9, 9, N'Emrah', N'12345', N'12345678910', N'Emrah', N'Şahin', N'burak@sahin.com.tr', N'Netcom Bilgisayar', N'netcom9', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  83. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (10, 10, N'Murat', N'12345', N'12345678910', N'Murat', N'Soyismi', N'murat@soyismi.com.tr', N'Netcom Bilgisayar', N'netcom10', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  84. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (11, 11, N'Netcom', N'12345', N'12345678910', N'Netcom', N'Bilgisayar', N'netcom@netcombilgisayar.com.tr', N'Netcom Bilgisayar', N'netcom11', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  85. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (12, 12, N'Cemal', N'12345', N'12345678910', N'Cemal', N'Kaçar', N'cemal@kacar.com.tr', N'Netcom Bilgisayar', N'netcom12', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  86. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (13, 13, N'NetcomAltYetkili', N'12345', N'12345678910', N'Netcom', N'AltYetkili', N'netcom@altyetkili.com.tr', N'Netcom Bilgisayar', N'netcom13', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  87. INSERT [dbo].[Kullanicilar] ([ID], [YetkiID], [KullaniciAdi], [Parola], [TCNo], [Ad], [Soyad], [Email], [FirmaUnvani], [BayiAdi], [Sektor], [TosKullaniciAdi], [StatikIp], [Adres], [Il], [Ilce], [Tel1], [Tel2], [VergiDaire], [VergiNo], [AktivasyonTarih], [SozlesmeTarih]) VALUES (14, 14, N'NetcomAltBayiKullanici', N'12345', N'12345678910', N'Netcom', N'AltBayi Kullanici', N'netcom@altbayikullanici.com.tr', N'Netcom Bilgisayar', N'netcom14', N'Bilişim', N'060010', N'192.168.1.1', N'Çankaya', N'Ankara', N'Çankaya', N'03126545454', N'05355353535', N'Çankaya', N'123456789', N'12.01.2010', N'10.01.2009')
  88. SET IDENTITY_INSERT [dbo].[Kullanicilar] OFF
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!