API tools faq
paste
Advertisement
Guest User

script

a guest
Nov 20th, 2013
1,633
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 11.80 KB | None | 0 0
raw download clone embed print report
  1. USE [ip_addresses]
  2. GO
  3. /****** Object:  Table [dbo].[ipv4_addresses]    Script Date: 05.11.2013 16:21:14 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. SET ANSI_PADDING ON
  9. GO
  10. CREATE TABLE [dbo].[ipv4_addresses](
  11.     [id] [INT] IDENTITY(1,1) NOT NULL,
  12.     [address] [VARCHAR](255) NOT NULL,
  13.     [date_added] [datetime] NULL,
  14.     [white_list] [bit] NULL,
  15. PRIMARY KEY CLUSTERED
  16. (
  17.     [id] ASC
  18. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  19. ) ON [PRIMARY]
  20.  
  21. GO
  22. SET ANSI_PADDING OFF
  23. GO
  24. /****** Object:  Table [dbo].[ipv6_addresses]    Script Date: 05.11.2013 16:21:14 ******/
  25. SET ANSI_NULLS ON
  26. GO
  27. SET QUOTED_IDENTIFIER ON
  28. GO
  29. SET ANSI_PADDING ON
  30. GO
  31. CREATE TABLE [dbo].[ipv6_addresses](
  32.     [id] [INT] IDENTITY(1,1) NOT NULL,
  33.     [address] [VARCHAR](255) NOT NULL,
  34.     [date_added] [datetime] NULL,
  35.     [white_list] [bit] NULL,
  36. PRIMARY KEY CLUSTERED
  37. (
  38.     [id] ASC
  39. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  40. ) ON [PRIMARY]
  41.  
  42. GO
  43. SET ANSI_PADDING OFF
  44. GO
  45. /****** Object:  Table [dbo].[not_valid_ip]    Script Date: 05.11.2013 16:21:14 ******/
  46. SET ANSI_NULLS ON
  47. GO
  48. SET QUOTED_IDENTIFIER ON
  49. GO
  50. SET ANSI_PADDING ON
  51. GO
  52. CREATE TABLE [dbo].[not_valid_ip](
  53.     [id] [INT] IDENTITY(1,1) NOT NULL,
  54.     [address] [VARCHAR](255) NOT NULL,
  55.     [date_added] [datetime] NULL,
  56. PRIMARY KEY CLUSTERED
  57. (
  58.     [id] ASC
  59. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  60. ) ON [PRIMARY]
  61.  
  62. GO
  63. SET ANSI_PADDING OFF
  64. GO
  65. /****** Object:  Table [dbo].[roles]    Script Date: 05.11.2013 16:21:14 ******/
  66. SET ANSI_NULLS ON
  67. GO
  68. SET QUOTED_IDENTIFIER ON
  69. GO
  70. SET ANSI_PADDING ON
  71. GO
  72. CREATE TABLE [dbo].[roles](
  73.     [role_id] [INT] NOT NULL,
  74.     [ROLE] [VARCHAR](255) NOT NULL,
  75. PRIMARY KEY CLUSTERED
  76. (
  77.     [role_id] ASC
  78. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  79. ) ON [PRIMARY]
  80.  
  81. GO
  82. SET ANSI_PADDING OFF
  83. GO
  84. /****** Object:  Table [dbo].[source_to_addresses]    Script Date: 05.11.2013 16:21:14 ******/
  85. SET ANSI_NULLS ON
  86. GO
  87. SET QUOTED_IDENTIFIER ON
  88. GO
  89. CREATE TABLE [dbo].[source_to_addresses](
  90.     [id] [INT] IDENTITY(1,1) NOT NULL,
  91.     [not_valid_id] [INT] NULL,
  92.     [source_id] [INT] NOT NULL,
  93.     [v6_id] [INT] NULL,
  94.     [v4_id] [INT] NULL,
  95.  CONSTRAINT [PK_source_to_addresses] PRIMARY KEY CLUSTERED
  96. (
  97.     [id] ASC
  98. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  99. ) ON [PRIMARY]
  100.  
  101. GO
  102. /****** Object:  Table [dbo].[sources]    Script Date: 05.11.2013 16:21:14 ******/
  103. SET ANSI_NULLS ON
  104. GO
  105. SET QUOTED_IDENTIFIER ON
  106. GO
  107. SET ANSI_PADDING ON
  108. GO
  109. CREATE TABLE [dbo].[sources](
  110.     [source_id] [INT] IDENTITY(1,1) NOT NULL,
  111.     [dirname] [VARCHAR](255) NULL,
  112.     [list_type] [VARCHAR](255) NOT NULL,
  113.     [md5] [VARCHAR](255) NULL,
  114.     [rank] [FLOAT] NOT NULL,
  115.     [source_date_added] [datetime] NOT NULL,
  116.     [source_name] [VARCHAR](255) NOT NULL,
  117.     [updated] [datetime] NULL,
  118.     [url] [VARCHAR](255) NOT NULL,
  119.     [downloader] [VARCHAR](255) NULL,
  120.  CONSTRAINT [PK__sources__3035A9B60619526F] PRIMARY KEY CLUSTERED
  121. (
  122.     [source_id] ASC
  123. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  124. ) ON [PRIMARY]
  125.  
  126. GO
  127. SET ANSI_PADDING OFF
  128. GO
  129. /****** Object:  Table [dbo].[user_roles]    Script Date: 05.11.2013 16:21:14 ******/
  130. SET ANSI_NULLS ON
  131. GO
  132. SET QUOTED_IDENTIFIER ON
  133. GO
  134. CREATE TABLE [dbo].[user_roles](
  135.     [user_id] [INT] NOT NULL,
  136.     [role_id] [INT] NOT NULL,
  137. PRIMARY KEY CLUSTERED
  138. (
  139.     [user_id] ASC,
  140.     [role_id] ASC
  141. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  142. ) ON [PRIMARY]
  143.  
  144. GO
  145. /****** Object:  Table [dbo].[users]    Script Date: 05.11.2013 16:21:14 ******/
  146. SET ANSI_NULLS ON
  147. GO
  148. SET QUOTED_IDENTIFIER ON
  149. GO
  150. SET ANSI_PADDING ON
  151. GO
  152. CREATE TABLE [dbo].[users](
  153.     [id] [INT] IDENTITY(1,1) NOT NULL,
  154.     [ctime] [datetime] NULL,
  155.     [email] [VARCHAR](255) NOT NULL,
  156.     [firstname] [VARCHAR](255) NULL,
  157.     [lastname] [VARCHAR](255) NULL,
  158.     [ltime] [datetime] NULL,
  159.     [password] [VARCHAR](255) NOT NULL,
  160.     [username] [VARCHAR](255) NOT NULL,
  161. PRIMARY KEY CLUSTERED
  162. (
  163.     [id] ASC
  164. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  165. ) ON [PRIMARY]
  166.  
  167. GO
  168. SET ANSI_PADDING OFF
  169. GO
  170. SET IDENTITY_INSERT [dbo].[ipv4_addresses] ON
  171.  
  172. INSERT [dbo].[ipv4_addresses] ([id], [address], [date_added], [white_list]) VALUES (1094, N'127.0.0.1', CAST(0x0000A26D00D8D74D AS DateTime), 1)
  173. INSERT [dbo].[ipv4_addresses] ([id], [address], [date_added], [white_list]) VALUES (1095, N'127.0.0.2', CAST(0x0000A26D00D8D74D AS DateTime), 1)
  174. INSERT [dbo].[ipv4_addresses] ([id], [address], [date_added], [white_list]) VALUES (1096, N'127.0.0.3', CAST(0x0000A26D00D8D74D AS DateTime), 1)
  175. INSERT [dbo].[ipv4_addresses] ([id], [address], [date_added], [white_list]) VALUES (1097, N'127.0.0.4', CAST(0x0000A26D00D8D74D AS DateTime), 1)
  176. SET IDENTITY_INSERT [dbo].[ipv4_addresses] OFF
  177. SET IDENTITY_INSERT [dbo].[ipv6_addresses] ON
  178.  
  179. INSERT [dbo].[ipv6_addresses] ([id], [address], [date_added], [white_list]) VALUES (49, N'0127:0000:0000:0001', CAST(0x0000A26D00D8D74D AS DateTime), 1)
  180. INSERT [dbo].[ipv6_addresses] ([id], [address], [date_added], [white_list]) VALUES (50, N'0127:0000:0000:0002', CAST(0x0000A26D00D8D74D AS DateTime), 1)
  181. INSERT [dbo].[ipv6_addresses] ([id], [address], [date_added], [white_list]) VALUES (51, N'0127:0000:0000:0003', CAST(0x0000A26D00D8D74D AS DateTime), 1)
  182. INSERT [dbo].[ipv6_addresses] ([id], [address], [date_added], [white_list]) VALUES (52, N'0127:0000:0000:0004', CAST(0x0000A26D00D8D74D AS DateTime), 1)
  183. SET IDENTITY_INSERT [dbo].[ipv6_addresses] OFF
  184. SET IDENTITY_INSERT [dbo].[not_valid_ip] ON
  185.  
  186. INSERT [dbo].[not_valid_ip] ([id], [address], [date_added]) VALUES (45, N'0127:0000:0m00:0001', CAST(0x0000A26D00D8D74D AS DateTime))
  187. INSERT [dbo].[not_valid_ip] ([id], [address], [date_added]) VALUES (46, N'x127:0000:0000:0001', CAST(0x0000A26D00D8D74D AS DateTime))
  188. INSERT [dbo].[not_valid_ip] ([id], [address], [date_added]) VALUES (47, N'0127:0000:0000:0z01', CAST(0x0000A26D00D8D74D AS DateTime))
  189. INSERT [dbo].[not_valid_ip] ([id], [address], [date_added]) VALUES (48, N'0127:0000:000z:0001', CAST(0x0000A26D00D8D74D AS DateTime))
  190. SET IDENTITY_INSERT [dbo].[not_valid_ip] OFF
  191. INSERT [dbo].[roles] ([role_id], [ROLE]) VALUES (1, N'ROLE_ADMIN')
  192. INSERT [dbo].[roles] ([role_id], [ROLE]) VALUES (2, N'ROLE_USER')
  193. SET IDENTITY_INSERT [dbo].[source_to_addresses] ON
  194.  
  195. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1180, NULL, 4, NULL, 1094)
  196. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1181, NULL, 4, NULL, 1095)
  197. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1182, NULL, 4, NULL, 1096)
  198. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1183, NULL, 4, NULL, 1097)
  199. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1184, NULL, 4, 49, NULL)
  200. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1185, NULL, 4, 50, NULL)
  201. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1186, NULL, 4, 51, NULL)
  202. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1187, NULL, 4, 52, NULL)
  203. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1188, 45, 4, NULL, NULL)
  204. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1189, 46, 4, NULL, NULL)
  205. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1190, 47, 4, NULL, NULL)
  206. INSERT [dbo].[source_to_addresses] ([id], [not_valid_id], [source_id], [v6_id], [v4_id]) VALUES (1191, 48, 4, NULL, NULL)
  207. SET IDENTITY_INSERT [dbo].[source_to_addresses] OFF
  208. SET IDENTITY_INSERT [dbo].[sources] ON
  209.  
  210. INSERT [dbo].[sources] ([source_id], [dirname], [list_type], [md5], [rank], [source_date_added], [source_name], [updated], [url], [downloader]) VALUES (1, N'D:\\textfiles\\openbsd', N'blacklist', NULL, 0.7, CAST(0x0000A21300000000 AS DateTime), N'OpenBSD traplist', NULL, N'http://www.openbsd.org/spamd/traplist.gz', NULL)
  211. INSERT [dbo].[sources] ([source_id], [dirname], [list_type], [md5], [rank], [source_date_added], [source_name], [updated], [url], [downloader]) VALUES (2, N'D:\\textfiles\\nixspam', N'blacklist', NULL, 0.6, CAST(0x0000A21300000000 AS DateTime), N'Nixspam list', NULL, N'http://wget-mirrors.uceprotect.net/rbldnsd-all/dnsbl-1.uceprotect.net.gz', NULL)
  212. INSERT [dbo].[sources] ([source_id], [dirname], [list_type], [md5], [rank], [source_date_added], [source_name], [updated], [url], [downloader]) VALUES (4, N'D:\\textfiles\\chaosreigns', N'whitelist', NULL, 0.1, CAST(0x0000A21300000000 AS DateTime), N'Chaosreigns Whitelist', NULL, N'http://www.chaosreigns.com/iprep/iprep.txt', NULL)
  213. SET IDENTITY_INSERT [dbo].[sources] OFF
  214. INSERT [dbo].[user_roles] ([user_id], [role_id]) VALUES (1, 1)
  215. INSERT [dbo].[user_roles] ([user_id], [role_id]) VALUES (1, 2)
  216. INSERT [dbo].[user_roles] ([user_id], [role_id]) VALUES (2, 2)
  217. SET IDENTITY_INSERT [dbo].[users] ON
  218.  
  219. INSERT [dbo].[users] ([id], [ctime], [email], [firstname], [lastname], [ltime], [password], [username]) VALUES (1, NULL, N'admin@m', N'admin', N'admin', NULL, N'admin', N'admin')
  220. INSERT [dbo].[users] ([id], [ctime], [email], [firstname], [lastname], [ltime], [password], [username]) VALUES (2, NULL, N'user@m', N'user', N'user', NULL, N'user', N'user')
  221. SET IDENTITY_INSERT [dbo].[users] OFF
  222. SET ANSI_PADDING ON
  223.  
  224. GO
  225. /****** Object:  Index [UK_qhey5jp6nccetbht473c973d9]    Script Date: 05.11.2013 16:21:14 ******/
  226. ALTER TABLE [dbo].[sources] ADD  CONSTRAINT [UK_qhey5jp6nccetbht473c973d9] UNIQUE NONCLUSTERED
  227. (
  228.     [url] ASC
  229. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  230. GO
  231. ALTER TABLE [dbo].[source_to_addresses]  WITH CHECK ADD  CONSTRAINT [FK_2cns9g2le9wax71coxl9micwg] FOREIGN KEY([source_id])
  232. REFERENCES [dbo].[sources] ([source_id])
  233. GO
  234. ALTER TABLE [dbo].[source_to_addresses] CHECK CONSTRAINT [FK_2cns9g2le9wax71coxl9micwg]
  235. GO
  236. ALTER TABLE [dbo].[source_to_addresses]  WITH CHECK ADD  CONSTRAINT [FK_5no2toqwk9l29982w94xhiqqw] FOREIGN KEY([v6_id])
  237. REFERENCES [dbo].[ipv6_addresses] ([id])
  238. GO
  239. ALTER TABLE [dbo].[source_to_addresses] CHECK CONSTRAINT [FK_5no2toqwk9l29982w94xhiqqw]
  240. GO
  241. ALTER TABLE [dbo].[source_to_addresses]  WITH CHECK ADD  CONSTRAINT [FK_hvd5wqe2afw4in3uadw963phf] FOREIGN KEY([v4_id])
  242. REFERENCES [dbo].[ipv4_addresses] ([id])
  243. GO
  244. ALTER TABLE [dbo].[source_to_addresses] CHECK CONSTRAINT [FK_hvd5wqe2afw4in3uadw963phf]
  245. GO
  246. ALTER TABLE [dbo].[source_to_addresses]  WITH CHECK ADD  CONSTRAINT [FK_p4vohlbig90rmu4bbkui1howj] FOREIGN KEY([not_valid_id])
  247. REFERENCES [dbo].[not_valid_ip] ([id])
  248. GO
  249. ALTER TABLE [dbo].[source_to_addresses] CHECK CONSTRAINT [FK_p4vohlbig90rmu4bbkui1howj]
  250. GO
  251. ALTER TABLE [dbo].[user_roles]  WITH CHECK ADD  CONSTRAINT [FK_5q4rc4fh1on6567qk69uesvyf] FOREIGN KEY([role_id])
  252. REFERENCES [dbo].[roles] ([role_id])
  253. GO
  254. ALTER TABLE [dbo].[user_roles] CHECK CONSTRAINT [FK_5q4rc4fh1on6567qk69uesvyf]
  255. GO
  256. ALTER TABLE [dbo].[user_roles]  WITH CHECK ADD  CONSTRAINT [FK_g1uebn6mqk9qiaw45vnacmyo2] FOREIGN KEY([user_id])
  257. REFERENCES [dbo].[users] ([id])
  258. GO
  259. ALTER TABLE [dbo].[user_roles] CHECK CONSTRAINT [FK_g1uebn6mqk9qiaw45vnacmyo2]
  260. GO
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!