API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 12th, 2016
203
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 45.46 KB | None | 0 0
raw download clone embed print report
  1. USE [master]
  2. GO
  3. /****** Object: Database [gameweb] Script Date: 12/12/2016 19:59:28 ******/
  4. CREATE DATABASE [gameweb] ON PRIMARY
  5. ( NAME = N'gameweb', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\gameweb.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  6. LOG ON
  7. ( NAME = N'gameweb_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\gameweb_log.LDF' , SIZE = 576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
  8. GO
  9. ALTER DATABASE [gameweb] SET COMPATIBILITY_LEVEL = 100
  10. GO
  11. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  12. begin
  13. EXEC [gameweb].[dbo].[sp_fulltext_database] @action = 'enable'
  14. end
  15. GO
  16. ALTER DATABASE [gameweb] SET ANSI_NULL_DEFAULT OFF
  17. GO
  18. ALTER DATABASE [gameweb] SET ANSI_NULLS OFF
  19. GO
  20. ALTER DATABASE [gameweb] SET ANSI_PADDING OFF
  21. GO
  22. ALTER DATABASE [gameweb] SET ANSI_WARNINGS OFF
  23. GO
  24. ALTER DATABASE [gameweb] SET ARITHABORT OFF
  25. GO
  26. ALTER DATABASE [gameweb] SET AUTO_CLOSE ON
  27. GO
  28. ALTER DATABASE [gameweb] SET AUTO_CREATE_STATISTICS ON
  29. GO
  30. ALTER DATABASE [gameweb] SET AUTO_SHRINK OFF
  31. GO
  32. ALTER DATABASE [gameweb] SET AUTO_UPDATE_STATISTICS ON
  33. GO
  34. ALTER DATABASE [gameweb] SET CURSOR_CLOSE_ON_COMMIT OFF
  35. GO
  36. ALTER DATABASE [gameweb] SET CURSOR_DEFAULT GLOBAL
  37. GO
  38. ALTER DATABASE [gameweb] SET CONCAT_NULL_YIELDS_NULL OFF
  39. GO
  40. ALTER DATABASE [gameweb] SET NUMERIC_ROUNDABORT OFF
  41. GO
  42. ALTER DATABASE [gameweb] SET QUOTED_IDENTIFIER OFF
  43. GO
  44. ALTER DATABASE [gameweb] SET RECURSIVE_TRIGGERS OFF
  45. GO
  46. ALTER DATABASE [gameweb] SET ENABLE_BROKER
  47. GO
  48. ALTER DATABASE [gameweb] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
  49. GO
  50. ALTER DATABASE [gameweb] SET DATE_CORRELATION_OPTIMIZATION OFF
  51. GO
  52. ALTER DATABASE [gameweb] SET TRUSTWORTHY OFF
  53. GO
  54. ALTER DATABASE [gameweb] SET ALLOW_SNAPSHOT_ISOLATION OFF
  55. GO
  56. ALTER DATABASE [gameweb] SET PARAMETERIZATION SIMPLE
  57. GO
  58. ALTER DATABASE [gameweb] SET READ_COMMITTED_SNAPSHOT OFF
  59. GO
  60. ALTER DATABASE [gameweb] SET HONOR_BROKER_PRIORITY OFF
  61. GO
  62. ALTER DATABASE [gameweb] SET READ_WRITE
  63. GO
  64. ALTER DATABASE [gameweb] SET RECOVERY SIMPLE
  65. GO
  66. ALTER DATABASE [gameweb] SET MULTI_USER
  67. GO
  68. ALTER DATABASE [gameweb] SET PAGE_VERIFY CHECKSUM
  69. GO
  70. ALTER DATABASE [gameweb] SET DB_CHAINING OFF
  71. GO
  72. /****** Object: Login [NT SERVICE\MSSQL$SQLEXPRESS] Script Date: 12/12/2016 19:59:28 ******/
  73. CREATE LOGIN [NT SERVICE\MSSQL$SQLEXPRESS] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[Español]
  74. GO
  75. /****** Object: Login [NT AUTHORITY\SYSTEM] Script Date: 12/12/2016 19:59:28 ******/
  76. CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[Español]
  77. GO
  78. /****** Object: Login [jara] Script Date: 12/12/2016 19:59:29 ******/
  79. /* For security reasons the login is created disabled and with a random password. */
  80. CREATE LOGIN [jara] WITH PASSWORD=N'sEk ÁŒÑA|ÔèÓõ+''7¶.<ùdB ˜î^²', DEFAULT_DATABASE=[gameweb], DEFAULT_LANGUAGE=[Español], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
  81. GO
  82. EXEC sys.sp_addsrvrolemember @loginame = N'jara', @rolename = N'sysadmin'
  83. GO
  84. EXEC sys.sp_addsrvrolemember @loginame = N'jara', @rolename = N'securityadmin'
  85. GO
  86. EXEC sys.sp_addsrvrolemember @loginame = N'jara', @rolename = N'serveradmin'
  87. GO
  88. EXEC sys.sp_addsrvrolemember @loginame = N'jara', @rolename = N'setupadmin'
  89. GO
  90. EXEC sys.sp_addsrvrolemember @loginame = N'jara', @rolename = N'processadmin'
  91. GO
  92. EXEC sys.sp_addsrvrolemember @loginame = N'jara', @rolename = N'diskadmin'
  93. GO
  94. EXEC sys.sp_addsrvrolemember @loginame = N'jara', @rolename = N'dbcreator'
  95. GO
  96. EXEC sys.sp_addsrvrolemember @loginame = N'jara', @rolename = N'bulkadmin'
  97. GO
  98. ALTER LOGIN [jara] DISABLE
  99. GO
  100. /****** Object: Login [DESKTOP-8IP01PM\Mauro] Script Date: 12/12/2016 19:59:29 ******/
  101. CREATE LOGIN [DESKTOP-8IP01PM\Mauro] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[Español]
  102. GO
  103. /****** Object: Login [BUILTIN\Usuarios] Script Date: 12/12/2016 19:59:29 ******/
  104. CREATE LOGIN [BUILTIN\Usuarios] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[Español]
  105. GO
  106. /****** Object: Login [##MS_PolicyTsqlExecutionLogin##] Script Date: 12/12/2016 19:59:29 ******/
  107. /* For security reasons the login is created disabled and with a random password. */
  108. CREATE LOGIN [##MS_PolicyTsqlExecutionLogin##] WITH PASSWORD=N'Mé!RWÖᷝÝ(0îÜ&èä,îÇOÆ_®RÅuÝÓF7û', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
  109. GO
  110. ALTER LOGIN [##MS_PolicyTsqlExecutionLogin##] DISABLE
  111. GO
  112. /****** Object: Login [##MS_PolicyEventProcessingLogin##] Script Date: 12/12/2016 19:59:29 ******/
  113. /* For security reasons the login is created disabled and with a random password. */
  114. CREATE LOGIN [##MS_PolicyEventProcessingLogin##] WITH PASSWORD=N'/¶" Òí/ßcæV8Ý ¾8,qClÀø£Àœö', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[Español], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
  115. GO
  116. ALTER LOGIN [##MS_PolicyEventProcessingLogin##] DISABLE
  117. GO
  118. USE [gameweb]
  119. GO
  120. /****** Object: Role [Standard Role] Script Date: 12/12/2016 19:59:29 ******/
  121. CREATE ROLE [Standard Role] AUTHORIZATION [jara]
  122. GO
  123. /****** Object: Role [asdasdasdasd] Script Date: 12/12/2016 19:59:29 ******/
  124. CREATE ROLE [asdasdasdasd] AUTHORIZATION [Standard Role]
  125. GO
  126. /****** Object: User [jara] Script Date: 12/12/2016 19:59:29 ******/
  127. CREATE USER [jara] FOR LOGIN [jara] WITH DEFAULT_SCHEMA=[dbo]
  128. GO
  129. /****** Object: Table [dbo].[Logros] Script Date: 12/12/2016 19:59:29 ******/
  130. SET ANSI_NULLS ON
  131. GO
  132. SET QUOTED_IDENTIFIER ON
  133. GO
  134. SET ANSI_PADDING ON
  135. GO
  136. CREATE TABLE [dbo].[Logros](
  137. [IdLogro] [int] IDENTITY(1,1) NOT NULL,
  138. [Nombre] [varchar](20) NOT NULL,
  139. [Imagen] [varchar](120) NULL,
  140. PRIMARY KEY CLUSTERED
  141. (
  142. [IdLogro] ASC
  143. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  144. ) ON [PRIMARY]
  145. GO
  146. SET ANSI_PADDING OFF
  147. GO
  148. /****** Object: Table [dbo].[Clases] Script Date: 12/12/2016 19:59:29 ******/
  149. SET ANSI_NULLS ON
  150. GO
  151. SET QUOTED_IDENTIFIER ON
  152. GO
  153. SET ANSI_PADDING ON
  154. GO
  155. CREATE TABLE [dbo].[Clases](
  156. [IdClase] [int] NOT NULL,
  157. [Nombre] [varchar](20) NULL,
  158. [Descripcion] [text] NULL,
  159. PRIMARY KEY CLUSTERED
  160. (
  161. [IdClase] ASC
  162. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  163. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  164. GO
  165. SET ANSI_PADDING OFF
  166. GO
  167. INSERT [dbo].[Clases] ([IdClase], [Nombre], [Descripcion]) VALUES (1, N'Wizard', N'LALALA')
  168. INSERT [dbo].[Clases] ([IdClase], [Nombre], [Descripcion]) VALUES (2, N'Warrior', N'asd')
  169. INSERT [dbo].[Clases] ([IdClase], [Nombre], [Descripcion]) VALUES (3, N'Rogue', N'asdd')
  170. /****** Object: Table [dbo].[paises] Script Date: 12/12/2016 19:59:29 ******/
  171. SET ANSI_NULLS ON
  172. GO
  173. SET QUOTED_IDENTIFIER ON
  174. GO
  175. SET ANSI_PADDING ON
  176. GO
  177. CREATE TABLE [dbo].[paises](
  178. [id] [int] IDENTITY(1,1) NOT NULL,
  179. [iso] [varchar](255) NOT NULL,
  180. [pais] [varchar](255) NOT NULL,
  181. PRIMARY KEY CLUSTERED
  182. (
  183. [id] ASC
  184. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  185. ) ON [PRIMARY]
  186. GO
  187. SET ANSI_PADDING OFF
  188. GO
  189. SET IDENTITY_INSERT [dbo].[paises] ON
  190. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (1, N'AF', N'Afganistán')
  191. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (2, N'AX', N'Islas Gland')
  192. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (3, N'AL', N'Albania')
  193. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (4, N'DE', N'Alemania')
  194. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (5, N'AD', N'Andorra')
  195. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (6, N'AO', N'Angola')
  196. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (7, N'AI', N'Anguilla')
  197. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (8, N'AQ', N'Antártida')
  198. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (9, N'AG', N'Antigua y Barbuda')
  199. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (10, N'AN', N'Antillas Holandesas')
  200. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (11, N'SA', N'Arabia Saudí')
  201. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (12, N'DZ', N'Argelia')
  202. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (13, N'AR', N'Argentina')
  203. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (14, N'AM', N'Armenia')
  204. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (15, N'AW', N'Aruba')
  205. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (16, N'AU', N'Australia')
  206. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (17, N'AT', N'Austria')
  207. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (18, N'AZ', N'Azerbaiyán')
  208. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (19, N'BS', N'Bahamas')
  209. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (20, N'BH', N'Bahréin')
  210. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (21, N'BD', N'Bangladesh')
  211. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (22, N'BB', N'Barbados')
  212. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (23, N'BY', N'Bielorrusia')
  213. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (24, N'BE', N'Bélgica')
  214. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (25, N'BZ', N'Belice')
  215. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (26, N'BJ', N'Benin')
  216. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (27, N'BM', N'Bermudas')
  217. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (28, N'BT', N'Bhután')
  218. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (29, N'BO', N'Bolivia')
  219. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (30, N'BA', N'Bosnia y Herzegovina')
  220. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (31, N'BW', N'Botsuana')
  221. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (32, N'BV', N'Isla Bouvet')
  222. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (33, N'BR', N'Brasil')
  223. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (34, N'BN', N'Brunéi')
  224. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (35, N'BG', N'Bulgaria')
  225. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (36, N'BF', N'Burkina Faso')
  226. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (37, N'BI', N'Burundi')
  227. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (38, N'CV', N'Cabo Verde')
  228. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (39, N'KY', N'Islas Caimán')
  229. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (40, N'KH', N'Camboya')
  230. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (41, N'CM', N'Camerún')
  231. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (42, N'CA', N'Canadá')
  232. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (43, N'CF', N'República Centroafricana')
  233. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (44, N'TD', N'Chad')
  234. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (45, N'CZ', N'República Checa')
  235. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (46, N'CL', N'Chile')
  236. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (47, N'CN', N'China')
  237. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (48, N'CY', N'Chipre')
  238. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (49, N'CX', N'Isla de Navidad')
  239. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (50, N'VA', N'Ciudad del Vaticano')
  240. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (51, N'CC', N'Islas Cocos')
  241. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (52, N'CO', N'Colombia')
  242. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (53, N'KM', N'Comoras')
  243. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (54, N'CD', N'República Democrática del Congo')
  244. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (55, N'CG', N'Congo')
  245. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (56, N'CK', N'Islas Cook')
  246. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (57, N'KP', N'Corea del Norte')
  247. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (58, N'KR', N'Corea del Sur')
  248. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (59, N'CI', N'Costa de Marfil')
  249. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (60, N'CR', N'Costa Rica')
  250. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (61, N'HR', N'Croacia')
  251. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (62, N'CU', N'Cuba')
  252. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (63, N'DK', N'Dinamarca')
  253. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (64, N'DM', N'Dominica')
  254. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (65, N'DO', N'República Dominicana')
  255. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (66, N'EC', N'Ecuador')
  256. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (67, N'EG', N'Egipto')
  257. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (68, N'SV', N'El Salvador')
  258. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (69, N'AE', N'Emiratos Árabes Unidos')
  259. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (70, N'ER', N'Eritrea')
  260. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (71, N'SK', N'Eslovaquia')
  261. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (72, N'SI', N'Eslovenia')
  262. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (73, N'ES', N'España')
  263. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (74, N'UM', N'Islas ultramarinas de Estados Unidos')
  264. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (75, N'US', N'Estados Unidos')
  265. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (76, N'EE', N'Estonia')
  266. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (77, N'ET', N'Etiopía')
  267. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (78, N'FO', N'Islas Feroe')
  268. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (79, N'PH', N'Filipinas')
  269. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (80, N'FI', N'Finlandia')
  270. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (81, N'FJ', N'Fiyi')
  271. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (82, N'FR', N'Francia')
  272. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (83, N'GA', N'Gabón')
  273. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (84, N'GM', N'Gambia')
  274. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (85, N'GE', N'Georgia')
  275. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (86, N'GS', N'Islas Georgias del Sur y Sandwich del Sur')
  276. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (87, N'GH', N'Ghana')
  277. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (88, N'GI', N'Gibraltar')
  278. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (89, N'GD', N'Granada')
  279. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (90, N'GR', N'Grecia')
  280. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (91, N'GL', N'Groenlandia')
  281. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (92, N'GP', N'Guadalupe')
  282. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (93, N'GU', N'Guam')
  283. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (94, N'GT', N'Guatemala')
  284. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (95, N'GF', N'Guayana Francesa')
  285. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (96, N'GN', N'Guinea')
  286. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (97, N'GQ', N'Guinea Ecuatorial')
  287. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (98, N'GW', N'Guinea-Bissau')
  288. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (99, N'GY', N'Guyana')
  289. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (100, N'HT', N'Haití')
  290. GO
  291. print 'Processed 100 total records'
  292. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (101, N'HM', N'Islas Heard y McDonald')
  293. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (102, N'HN', N'Honduras')
  294. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (103, N'HK', N'Hong Kong')
  295. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (104, N'HU', N'Hungría')
  296. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (105, N'IN', N'India')
  297. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (106, N'ID', N'Indonesia')
  298. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (107, N'IR', N'Irán')
  299. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (108, N'IQ', N'Iraq')
  300. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (109, N'IE', N'Irlanda')
  301. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (110, N'IS', N'Islandia')
  302. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (111, N'IL', N'Israel')
  303. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (112, N'IT', N'Italia')
  304. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (113, N'JM', N'Jamaica')
  305. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (114, N'JP', N'Japón')
  306. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (115, N'JO', N'Jordania')
  307. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (116, N'KZ', N'Kazajstán')
  308. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (117, N'KE', N'Kenia')
  309. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (118, N'KG', N'Kirguistán')
  310. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (119, N'KI', N'Kiribati')
  311. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (120, N'KW', N'Kuwait')
  312. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (121, N'LA', N'Laos')
  313. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (122, N'LS', N'Lesotho')
  314. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (123, N'LV', N'Letonia')
  315. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (124, N'LB', N'Líbano')
  316. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (125, N'LR', N'Liberia')
  317. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (126, N'LY', N'Libia')
  318. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (127, N'LI', N'Liechtenstein')
  319. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (128, N'LT', N'Lituania')
  320. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (129, N'LU', N'Luxemburgo')
  321. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (130, N'MO', N'Macao')
  322. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (131, N'MK', N'ARY Macedonia')
  323. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (132, N'MG', N'Madagascar')
  324. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (133, N'MY', N'Malasia')
  325. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (134, N'MW', N'Malawi')
  326. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (135, N'MV', N'Maldivas')
  327. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (136, N'ML', N'Malí')
  328. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (137, N'MT', N'Malta')
  329. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (138, N'FK', N'Islas Malvinas')
  330. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (139, N'MP', N'Islas Marianas del Norte')
  331. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (140, N'MA', N'Marruecos')
  332. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (141, N'MH', N'Islas Marshall')
  333. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (142, N'MQ', N'Martinica')
  334. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (143, N'MU', N'Mauricio')
  335. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (144, N'MR', N'Mauritania')
  336. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (145, N'YT', N'Mayotte')
  337. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (146, N'MX', N'México')
  338. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (147, N'FM', N'Micronesia')
  339. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (148, N'MD', N'Moldavia')
  340. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (149, N'MC', N'Mónaco')
  341. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (150, N'MN', N'Mongolia')
  342. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (151, N'MS', N'Montserrat')
  343. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (152, N'MZ', N'Mozambique')
  344. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (153, N'MM', N'Myanmar')
  345. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (154, N'NA', N'Namibia')
  346. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (155, N'NR', N'Nauru')
  347. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (156, N'NP', N'Nepal')
  348. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (157, N'NI', N'Nicaragua')
  349. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (158, N'NE', N'Níger')
  350. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (159, N'NG', N'Nigeria')
  351. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (160, N'NU', N'Niue')
  352. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (161, N'NF', N'Isla Norfolk')
  353. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (162, N'NO', N'Noruega')
  354. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (163, N'NC', N'Nueva Caledonia')
  355. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (164, N'NZ', N'Nueva Zelanda')
  356. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (165, N'OM', N'Omán')
  357. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (166, N'NL', N'Países Bajos')
  358. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (167, N'PK', N'Pakistán')
  359. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (168, N'PW', N'Palau')
  360. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (169, N'PS', N'Palestina')
  361. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (170, N'PA', N'Panamá')
  362. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (171, N'PG', N'Papúa Nueva Guinea')
  363. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (172, N'PY', N'Paraguay')
  364. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (173, N'PE', N'Perú')
  365. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (174, N'PN', N'Islas Pitcairn')
  366. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (175, N'PF', N'Polinesia Francesa')
  367. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (176, N'PL', N'Polonia')
  368. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (177, N'PT', N'Portugal')
  369. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (178, N'PR', N'Puerto Rico')
  370. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (179, N'QA', N'Qatar')
  371. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (180, N'GB', N'Reino Unido')
  372. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (181, N'RE', N'Reunión')
  373. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (182, N'RW', N'Ruanda')
  374. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (183, N'RO', N'Rumania')
  375. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (184, N'RU', N'Rusia')
  376. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (185, N'EH', N'Sahara Occidental')
  377. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (186, N'SB', N'Islas Salomón')
  378. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (187, N'WS', N'Samoa')
  379. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (188, N'AS', N'Samoa Americana')
  380. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (189, N'KN', N'San Cristóbal y Nevis')
  381. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (190, N'SM', N'San Marino')
  382. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (191, N'PM', N'San Pedro y Miquelón')
  383. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (192, N'VC', N'San Vicente y las Granadinas')
  384. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (193, N'SH', N'Santa Helena')
  385. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (194, N'LC', N'Santa Lucía')
  386. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (195, N'ST', N'Santo Tomé y Príncipe')
  387. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (196, N'SN', N'Senegal')
  388. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (197, N'CS', N'Serbia y Montenegro')
  389. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (198, N'SC', N'Seychelles')
  390. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (199, N'SL', N'Sierra Leona')
  391. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (200, N'SG', N'Singapur')
  392. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (201, N'SY', N'Siria')
  393. GO
  394. print 'Processed 200 total records'
  395. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (202, N'SO', N'Somalia')
  396. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (203, N'LK', N'Sri Lanka')
  397. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (204, N'SZ', N'Suazilandia')
  398. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (205, N'ZA', N'Sudáfrica')
  399. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (206, N'SD', N'Sudán')
  400. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (207, N'SE', N'Suecia')
  401. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (208, N'CH', N'Suiza')
  402. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (209, N'SR', N'Surinam')
  403. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (210, N'SJ', N'Svalbard y Jan Mayen')
  404. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (211, N'TH', N'Tailandia')
  405. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (212, N'TW', N'Taiwán')
  406. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (213, N'TZ', N'Tanzania')
  407. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (214, N'TJ', N'Tayikistán')
  408. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (215, N'IO', N'Territorio Británico del Océano Índico')
  409. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (216, N'TF', N'Territorios Australes Franceses')
  410. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (217, N'TL', N'Timor Oriental')
  411. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (218, N'TG', N'Togo')
  412. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (219, N'TK', N'Tokelau')
  413. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (220, N'TO', N'Tonga')
  414. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (221, N'TT', N'Trinidad y Tobago')
  415. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (222, N'TN', N'Túnez')
  416. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (223, N'TC', N'Islas Turcas y Caicos')
  417. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (224, N'TM', N'Turkmenistán')
  418. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (225, N'TR', N'Turquía')
  419. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (226, N'TV', N'Tuvalu')
  420. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (227, N'UA', N'Ucrania')
  421. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (228, N'UG', N'Uganda')
  422. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (229, N'UY', N'Uruguay')
  423. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (230, N'UZ', N'Uzbekistán')
  424. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (231, N'VU', N'Vanuatu')
  425. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (232, N'VE', N'Venezuela')
  426. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (233, N'VN', N'Vietnam')
  427. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (234, N'VG', N'Islas Vírgenes Británicas')
  428. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (235, N'VI', N'Islas Vírgenes de los Estados Unidos')
  429. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (236, N'WF', N'Wallis y Futuna')
  430. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (237, N'YE', N'Yemen')
  431. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (238, N'DJ', N'Yibuti')
  432. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (239, N'ZM', N'Zambia')
  433. INSERT [dbo].[paises] ([id], [iso], [pais]) VALUES (240, N'ZW', N'Zimbabue')
  434. SET IDENTITY_INSERT [dbo].[paises] OFF
  435. /****** Object: Table [dbo].[Servidores] Script Date: 12/12/2016 19:59:29 ******/
  436. SET ANSI_NULLS ON
  437. GO
  438. SET QUOTED_IDENTIFIER ON
  439. GO
  440. SET ANSI_PADDING ON
  441. GO
  442. CREATE TABLE [dbo].[Servidores](
  443. [Nombre_Servidor] [varchar](50) NULL,
  444. [ID_Servidor] [int] IDENTITY(1,1) NOT NULL,
  445. CONSTRAINT [PK_Servidores] PRIMARY KEY CLUSTERED
  446. (
  447. [ID_Servidor] ASC
  448. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  449. ) ON [PRIMARY]
  450. GO
  451. SET ANSI_PADDING OFF
  452. GO
  453. SET IDENTITY_INSERT [dbo].[Servidores] ON
  454. INSERT [dbo].[Servidores] ([Nombre_Servidor], [ID_Servidor]) VALUES (N'Server 1', 1)
  455. INSERT [dbo].[Servidores] ([Nombre_Servidor], [ID_Servidor]) VALUES (N'Server 2', 2)
  456. INSERT [dbo].[Servidores] ([Nombre_Servidor], [ID_Servidor]) VALUES (N'Server 3', 3)
  457. SET IDENTITY_INSERT [dbo].[Servidores] OFF
  458. /****** Object: Table [dbo].[Productos] Script Date: 12/12/2016 19:59:29 ******/
  459. SET ANSI_NULLS ON
  460. GO
  461. SET QUOTED_IDENTIFIER ON
  462. GO
  463. SET ANSI_PADDING ON
  464. GO
  465. CREATE TABLE [dbo].[Productos](
  466. [IdProducto] [int] IDENTITY(1,1) NOT NULL,
  467. [NombreProducto] [varchar](100) NOT NULL,
  468. [NombreImagen] [varchar](150) NOT NULL,
  469. [Precio] [float] NOT NULL,
  470. [PostbackURL] [varchar](150) NULL,
  471. CONSTRAINT [PK_Productos] PRIMARY KEY CLUSTERED
  472. (
  473. [IdProducto] ASC
  474. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  475. ) ON [PRIMARY]
  476. GO
  477. SET ANSI_PADDING OFF
  478. GO
  479. SET IDENTITY_INSERT [dbo].[Productos] ON
  480. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (1, N'Vanquish', N'vanquish-ps3.jpg', 15.99, NULL)
  481. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (3, N'Assassins Creed', N'Assassins-creed-iv-black-flag-pc.jpg', 59.99, NULL)
  482. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (4, N'Battlefield 1', N'battlefield-1-201656231240_1.jpg', 59.99, NULL)
  483. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (5, N'GTA 5', N'37303.gtav_portada_ps3.jpg', 59.99, NULL)
  484. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (6, N'Super Mario Galaxy', N'12.jpg', 9.99, NULL)
  485. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (7, N'Resistance 2', N'resistance2-portada.jpg', 4.99, NULL)
  486. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (8, N'Uncharted 2', N'9784_1024_32471.jpg', 29.99, NULL)
  487. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (9, N'La brujula dorada', N'[PS2]_Portada-del-videojuego-La-Brujula-Dorada.jpg', 11.49, NULL)
  488. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (10, N'Saints Row 4', N'2490417-9474755454-hk5ju.jpg', 19.99, NULL)
  489. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (11, N'Dark Souls', N'project_dark-1723897.jpg', 14.99, NULL)
  490. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (12, N'Lego', N'the-lego-movie-videogame-2013112010446_1.jpg', 7.99, NULL)
  491. INSERT [dbo].[Productos] ([IdProducto], [NombreProducto], [NombreImagen], [Precio], [PostbackURL]) VALUES (13, N'FLM', N'castle_zpswhdmnxyh.jpg', 14.99, NULL)
  492. SET IDENTITY_INSERT [dbo].[Productos] OFF
  493. /****** Object: Table [dbo].[Personajes] Script Date: 12/12/2016 19:59:29 ******/
  494. SET ANSI_NULLS ON
  495. GO
  496. SET QUOTED_IDENTIFIER ON
  497. GO
  498. SET ANSI_PADDING ON
  499. GO
  500. CREATE TABLE [dbo].[Personajes](
  501. [IdPersonaje] [int] IDENTITY(1,1) NOT NULL,
  502. [Nombre] [varchar](50) NOT NULL,
  503. [Agilidad] [int] NOT NULL,
  504. [Fuerza] [int] NOT NULL,
  505. [Constitucion] [int] NOT NULL,
  506. [Inteligencia] [int] NOT NULL,
  507. [Carisma] [int] NOT NULL,
  508. [Ranking] [int] NULL,
  509. [Sexo] [int] NOT NULL,
  510. [Nivel] [int] NOT NULL,
  511. [Experiencia] [int] NULL,
  512. [IdClase] [int] NOT NULL,
  513. PRIMARY KEY CLUSTERED
  514. (
  515. [IdPersonaje] ASC
  516. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  517. ) ON [PRIMARY]
  518. GO
  519. SET ANSI_PADDING OFF
  520. GO
  521. SET IDENTITY_INSERT [dbo].[Personajes] ON
  522. INSERT [dbo].[Personajes] ([IdPersonaje], [Nombre], [Agilidad], [Fuerza], [Constitucion], [Inteligencia], [Carisma], [Ranking], [Sexo], [Nivel], [Experiencia], [IdClase]) VALUES (1, N'Amatiel', 57, 15, 20, 10, 7, 1, 1, 25, 100, 3)
  523. INSERT [dbo].[Personajes] ([IdPersonaje], [Nombre], [Agilidad], [Fuerza], [Constitucion], [Inteligencia], [Carisma], [Ranking], [Sexo], [Nivel], [Experiencia], [IdClase]) VALUES (2, N'BlazeFTW', 33, 10, 15, 50, 20, 3, 2, 24, 100, 1)
  524. INSERT [dbo].[Personajes] ([IdPersonaje], [Nombre], [Agilidad], [Fuerza], [Constitucion], [Inteligencia], [Carisma], [Ranking], [Sexo], [Nivel], [Experiencia], [IdClase]) VALUES (3, N'Kuzter', 15, 55, 40, 10, 15, 2, 1, 24, 150, 2)
  525. INSERT [dbo].[Personajes] ([IdPersonaje], [Nombre], [Agilidad], [Fuerza], [Constitucion], [Inteligencia], [Carisma], [Ranking], [Sexo], [Nivel], [Experiencia], [IdClase]) VALUES (10, N'as', 14, 9, 20, 22, 18, 4, 1, 1, 0, 1)
  526. INSERT [dbo].[Personajes] ([IdPersonaje], [Nombre], [Agilidad], [Fuerza], [Constitucion], [Inteligencia], [Carisma], [Ranking], [Sexo], [Nivel], [Experiencia], [IdClase]) VALUES (11, N'asd', 21, 13, 18, 15, 10, 5, 2, 1, 0, 3)
  527. SET IDENTITY_INSERT [dbo].[Personajes] OFF
  528. /****** Object: Table [dbo].[Usuarios] Script Date: 12/12/2016 19:59:29 ******/
  529. SET ANSI_NULLS ON
  530. GO
  531. SET QUOTED_IDENTIFIER ON
  532. GO
  533. SET ANSI_PADDING ON
  534. GO
  535. CREATE TABLE [dbo].[Usuarios](
  536. [IdUsuario] [int] IDENTITY(1,1) NOT NULL,
  537. [Contraseña] [varchar](20) NOT NULL,
  538. [Mail] [varchar](50) NOT NULL,
  539. [Username] [varchar](50) NOT NULL,
  540. [IdNacionalidad] [int] NULL,
  541. PRIMARY KEY CLUSTERED
  542. (
  543. [IdUsuario] ASC
  544. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  545. ) ON [PRIMARY]
  546. GO
  547. SET ANSI_PADDING OFF
  548. GO
  549. SET IDENTITY_INSERT [dbo].[Usuarios] ON
  550. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (10, N'123', N'lauti', N'Lucero', 1)
  551. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (11, N'ze', N'lauta@gmail.com', N'Bla', 1)
  552. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (12, N'lau', N'lautadf65@gmail.com', N'blazky', 1)
  553. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (13, N'21', N'casde@gmail.com', N'234', 1)
  554. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (14, N'23', N'dwe@gmail.com', N'2323', 1)
  555. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (15, N'23', N'qwqe@WOT.com', N'123123', 1)
  556. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (16, N'21', N'boteta@gmail.com', N'wqeqw', 1)
  557. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (17, N'asd', N'asd', N'Mauro', 13)
  558. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (18, N'asd', N'asd', N'Lauta', 13)
  559. INSERT [dbo].[Usuarios] ([IdUsuario], [Contraseña], [Mail], [Username], [IdNacionalidad]) VALUES (19, N'asd', N'asd', N'Facu', 13)
  560. SET IDENTITY_INSERT [dbo].[Usuarios] OFF
  561. /****** Object: Table [dbo].[Habilidades] Script Date: 12/12/2016 19:59:29 ******/
  562. SET ANSI_NULLS ON
  563. GO
  564. SET QUOTED_IDENTIFIER ON
  565. GO
  566. SET ANSI_PADDING ON
  567. GO
  568. CREATE TABLE [dbo].[Habilidades](
  569. [IdHabilidad] [int] NOT NULL,
  570. [IdClase] [int] NOT NULL,
  571. [Nombre] [varchar](20) NULL,
  572. [Descripcion] [text] NULL,
  573. PRIMARY KEY CLUSTERED
  574. (
  575. [IdHabilidad] ASC
  576. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  577. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  578. GO
  579. SET ANSI_PADDING OFF
  580. GO
  581. /****** Object: Table [dbo].[Enemies] Script Date: 12/12/2016 19:59:29 ******/
  582. SET ANSI_NULLS ON
  583. GO
  584. SET QUOTED_IDENTIFIER ON
  585. GO
  586. CREATE TABLE [dbo].[Enemies](
  587. [IdEnemy] [int] IDENTITY(1,1) NOT NULL,
  588. [Agilidad] [int] NOT NULL,
  589. [Fuerza] [int] NOT NULL,
  590. [Constitucion] [int] NOT NULL,
  591. [Inteligencia] [int] NOT NULL,
  592. [Carisma] [int] NOT NULL,
  593. [IdClase] [int] NOT NULL,
  594. PRIMARY KEY CLUSTERED
  595. (
  596. [IdEnemy] ASC
  597. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  598. ) ON [PRIMARY]
  599. GO
  600. /****** Object: Table [dbo].[Items] Script Date: 12/12/2016 19:59:29 ******/
  601. SET ANSI_NULLS ON
  602. GO
  603. SET QUOTED_IDENTIFIER ON
  604. GO
  605. SET ANSI_PADDING ON
  606. GO
  607. CREATE TABLE [dbo].[Items](
  608. [IdItem] [int] NOT NULL,
  609. [Nombre] [varchar](100) NOT NULL,
  610. [Agilidad] [int] NOT NULL,
  611. [Fuerza] [int] NOT NULL,
  612. [Constitucion] [int] NOT NULL,
  613. [Inteligencia] [int] NOT NULL,
  614. [Carisma] [int] NOT NULL,
  615. [Rareza] [int] NOT NULL,
  616. [IdClase] [int] NOT NULL,
  617. PRIMARY KEY CLUSTERED
  618. (
  619. [IdItem] ASC
  620. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  621. ) ON [PRIMARY]
  622. GO
  623. SET ANSI_PADDING OFF
  624. GO
  625. /****** Object: Table [dbo].[LxU] Script Date: 12/12/2016 19:59:29 ******/
  626. SET ANSI_NULLS ON
  627. GO
  628. SET QUOTED_IDENTIFIER ON
  629. GO
  630. CREATE TABLE [dbo].[LxU](
  631. [IdLogro] [int] NOT NULL,
  632. [IdUsuario] [int] NOT NULL,
  633. CONSTRAINT [PK_LxU] PRIMARY KEY CLUSTERED
  634. (
  635. [IdLogro] ASC,
  636. [IdUsuario] ASC
  637. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  638. ) ON [PRIMARY]
  639. GO
  640. /****** Object: Table [dbo].[UxP] Script Date: 12/12/2016 19:59:29 ******/
  641. SET ANSI_NULLS ON
  642. GO
  643. SET QUOTED_IDENTIFIER ON
  644. GO
  645. CREATE TABLE [dbo].[UxP](
  646. [IdUsuario] [int] NOT NULL,
  647. [IdPersonaje] [int] NOT NULL,
  648. [Id_Servidor] [int] NULL,
  649. CONSTRAINT [PK_UxP] PRIMARY KEY CLUSTERED
  650. (
  651. [IdUsuario] ASC,
  652. [IdPersonaje] ASC
  653. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  654. ) ON [PRIMARY]
  655. GO
  656. INSERT [dbo].[UxP] ([IdUsuario], [IdPersonaje], [Id_Servidor]) VALUES (17, 1, 1)
  657. INSERT [dbo].[UxP] ([IdUsuario], [IdPersonaje], [Id_Servidor]) VALUES (18, 2, 1)
  658. INSERT [dbo].[UxP] ([IdUsuario], [IdPersonaje], [Id_Servidor]) VALUES (19, 3, 1)
  659. /****** Object: Table [dbo].[Inventario] Script Date: 12/12/2016 19:59:29 ******/
  660. SET ANSI_NULLS ON
  661. GO
  662. SET QUOTED_IDENTIFIER ON
  663. GO
  664. CREATE TABLE [dbo].[Inventario](
  665. [IdPersonaje] [int] NOT NULL,
  666. [IdItem] [int] NOT NULL,
  667. [Slot] [int] NOT NULL,
  668. [ItemBag] [int] NOT NULL,
  669. [Cantidad] [int] NOT NULL,
  670. CONSTRAINT [PK_Inv] PRIMARY KEY CLUSTERED
  671. (
  672. [IdPersonaje] ASC,
  673. [IdItem] ASC,
  674. [Slot] ASC,
  675. [ItemBag] ASC
  676. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  677. ) ON [PRIMARY]
  678. GO
  679. /****** Object: Table [dbo].[HxP] Script Date: 12/12/2016 19:59:29 ******/
  680. SET ANSI_NULLS ON
  681. GO
  682. SET QUOTED_IDENTIFIER ON
  683. GO
  684. CREATE TABLE [dbo].[HxP](
  685. [IdPersonaje] [int] NOT NULL,
  686. [IdHabilidad] [int] NOT NULL,
  687. CONSTRAINT [PK_HxP] PRIMARY KEY CLUSTERED
  688. (
  689. [IdPersonaje] ASC,
  690. [IdHabilidad] ASC
  691. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  692. ) ON [PRIMARY]
  693. GO
  694. /****** Object: Table [dbo].[HxE] Script Date: 12/12/2016 19:59:29 ******/
  695. SET ANSI_NULLS ON
  696. GO
  697. SET QUOTED_IDENTIFIER ON
  698. GO
  699. CREATE TABLE [dbo].[HxE](
  700. [IdEnemigo] [int] NOT NULL,
  701. [IdHabilidad] [int] NOT NULL,
  702. CONSTRAINT [PK_HxE] PRIMARY KEY CLUSTERED
  703. (
  704. [IdEnemigo] ASC,
  705. [IdHabilidad] ASC
  706. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  707. ) ON [PRIMARY]
  708. GO
  709. /****** Object: Table [dbo].[HistorialDeCompra] Script Date: 12/12/2016 19:59:29 ******/
  710. SET ANSI_NULLS ON
  711. GO
  712. SET QUOTED_IDENTIFIER ON
  713. GO
  714. CREATE TABLE [dbo].[HistorialDeCompra](
  715. [IdUsuario] [int] NOT NULL,
  716. [IdProducto] [int] NOT NULL,
  717. [Fecha] [date] NOT NULL,
  718. CONSTRAINT [PK_HistorialDeCompra_1] PRIMARY KEY CLUSTERED
  719. (
  720. [IdUsuario] ASC,
  721. [IdProducto] ASC,
  722. [Fecha] ASC
  723. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  724. ) ON [PRIMARY]
  725. GO
  726. /****** Object: StoredProcedure [dbo].[ChangePasswd] Script Date: 12/12/2016 19:59:30 ******/
  727. SET ANSI_NULLS ON
  728. GO
  729. SET QUOTED_IDENTIFIER ON
  730. GO
  731. create procedure [dbo].[ChangePasswd]
  732. @password varchar(20) ,@username varchar(50)
  733. as
  734. update Usuarios set
  735. Contraseña = @password
  736. where Username = @username
  737. GO
  738. /****** Object: StoredProcedure [dbo].[ChangeMail] Script Date: 12/12/2016 19:59:30 ******/
  739. SET ANSI_NULLS ON
  740. GO
  741. SET QUOTED_IDENTIFIER ON
  742. GO
  743. create procedure [dbo].[ChangeMail]
  744. @mail varchar(20) ,@username varchar(50)
  745. as
  746. update Usuarios set
  747. Mail = @mail
  748. where Username = @username
  749. GO
  750. /****** Object: StoredProcedure [dbo].[NewUser] Script Date: 12/12/2016 19:59:30 ******/
  751. SET ANSI_NULLS ON
  752. GO
  753. SET QUOTED_IDENTIFIER ON
  754. GO
  755. CREATE procedure [dbo].[NewUser]
  756. @mail varchar(50),
  757. @username varchar(50),
  758. @paswd varchar(20),
  759. @idpais int
  760. as
  761. Insert into Usuarios(Mail,Username,Contraseña,IdNacionalidad)
  762. values (@mail,@username,@paswd,@idpais)
  763. GO
  764. /****** Object: StoredProcedure [dbo].[NewPJ] Script Date: 12/12/2016 19:59:30 ******/
  765. SET ANSI_NULLS ON
  766. GO
  767. SET QUOTED_IDENTIFIER ON
  768. GO
  769. CREATE procedure [dbo].[NewPJ]
  770. @nombre varchar(50), @agi int, @str int, @cons int, @int int, @char int,
  771. @sex int, @lvl int, @exp int, @class int, @user int, @server int
  772. as
  773. begin
  774. insert into Personajes values(@nombre,@agi,@str,@cons,@int,@char,
  775. (select top 1 (Ranking+1) from Personajes order by Ranking desc),@sex,@lvl,@exp,@class)
  776.  
  777. insert into UxP values (@user,(select top 1 (IdPersonaje) from Personajes order by IdPersonaje desc),@server)
  778.  
  779. end
  780. GO
  781. /****** Object: StoredProcedure [dbo].[NewHistorial] Script Date: 12/12/2016 19:59:30 ******/
  782. SET ANSI_NULLS ON
  783. GO
  784. SET QUOTED_IDENTIFIER ON
  785. GO
  786. CREATE procedure [dbo].[NewHistorial]
  787. @iduser int, @idpr int
  788. as
  789. begin
  790. insert into HistorialDeCompra values (@iduser,@idpr,GETDATE())
  791. end
  792. GO
  793. /****** Object: ForeignKey [FK_PxC] Script Date: 12/12/2016 19:59:29 ******/
  794. ALTER TABLE [dbo].[Personajes] WITH CHECK ADD CONSTRAINT [FK_PxC] FOREIGN KEY([IdClase])
  795. REFERENCES [dbo].[Clases] ([IdClase])
  796. GO
  797. ALTER TABLE [dbo].[Personajes] CHECK CONSTRAINT [FK_PxC]
  798. GO
  799. /****** Object: ForeignKey [FK_Usuarios_paises] Script Date: 12/12/2016 19:59:29 ******/
  800. ALTER TABLE [dbo].[Usuarios] WITH CHECK ADD CONSTRAINT [FK_Usuarios_paises] FOREIGN KEY([IdNacionalidad])
  801. REFERENCES [dbo].[paises] ([id])
  802. GO
  803. ALTER TABLE [dbo].[Usuarios] CHECK CONSTRAINT [FK_Usuarios_paises]
  804. GO
  805. /****** Object: ForeignKey [FK_HxC] Script Date: 12/12/2016 19:59:29 ******/
  806. ALTER TABLE [dbo].[Habilidades] WITH CHECK ADD CONSTRAINT [FK_HxC] FOREIGN KEY([IdClase])
  807. REFERENCES [dbo].[Clases] ([IdClase])
  808. GO
  809. ALTER TABLE [dbo].[Habilidades] CHECK CONSTRAINT [FK_HxC]
  810. GO
  811. /****** Object: ForeignKey [FK_ExC] Script Date: 12/12/2016 19:59:29 ******/
  812. ALTER TABLE [dbo].[Enemies] WITH CHECK ADD CONSTRAINT [FK_ExC] FOREIGN KEY([IdClase])
  813. REFERENCES [dbo].[Clases] ([IdClase])
  814. GO
  815. ALTER TABLE [dbo].[Enemies] CHECK CONSTRAINT [FK_ExC]
  816. GO
  817. /****** Object: ForeignKey [FK_IxC] Script Date: 12/12/2016 19:59:29 ******/
  818. ALTER TABLE [dbo].[Items] WITH CHECK ADD CONSTRAINT [FK_IxC] FOREIGN KEY([IdClase])
  819. REFERENCES [dbo].[Clases] ([IdClase])
  820. GO
  821. ALTER TABLE [dbo].[Items] CHECK CONSTRAINT [FK_IxC]
  822. GO
  823. /****** Object: ForeignKey [FK_L] Script Date: 12/12/2016 19:59:29 ******/
  824. ALTER TABLE [dbo].[LxU] WITH CHECK ADD CONSTRAINT [FK_L] FOREIGN KEY([IdLogro])
  825. REFERENCES [dbo].[Logros] ([IdLogro])
  826. GO
  827. ALTER TABLE [dbo].[LxU] CHECK CONSTRAINT [FK_L]
  828. GO
  829. /****** Object: ForeignKey [FK_Lu] Script Date: 12/12/2016 19:59:29 ******/
  830. ALTER TABLE [dbo].[LxU] WITH CHECK ADD CONSTRAINT [FK_Lu] FOREIGN KEY([IdUsuario])
  831. REFERENCES [dbo].[Usuarios] ([IdUsuario])
  832. GO
  833. ALTER TABLE [dbo].[LxU] CHECK CONSTRAINT [FK_Lu]
  834. GO
  835. /****** Object: ForeignKey [Fk_P] Script Date: 12/12/2016 19:59:29 ******/
  836. ALTER TABLE [dbo].[UxP] WITH CHECK ADD CONSTRAINT [Fk_P] FOREIGN KEY([IdPersonaje])
  837. REFERENCES [dbo].[Personajes] ([IdPersonaje])
  838. GO
  839. ALTER TABLE [dbo].[UxP] CHECK CONSTRAINT [Fk_P]
  840. GO
  841. /****** Object: ForeignKey [FK_U] Script Date: 12/12/2016 19:59:29 ******/
  842. ALTER TABLE [dbo].[UxP] WITH CHECK ADD CONSTRAINT [FK_U] FOREIGN KEY([IdUsuario])
  843. REFERENCES [dbo].[Usuarios] ([IdUsuario])
  844. GO
  845. ALTER TABLE [dbo].[UxP] CHECK CONSTRAINT [FK_U]
  846. GO
  847. /****** Object: ForeignKey [FK_UxP_Servidores] Script Date: 12/12/2016 19:59:29 ******/
  848. ALTER TABLE [dbo].[UxP] WITH CHECK ADD CONSTRAINT [FK_UxP_Servidores] FOREIGN KEY([Id_Servidor])
  849. REFERENCES [dbo].[Servidores] ([ID_Servidor])
  850. GO
  851. ALTER TABLE [dbo].[UxP] CHECK CONSTRAINT [FK_UxP_Servidores]
  852. GO
  853. /****** Object: ForeignKey [FK_InxIt] Script Date: 12/12/2016 19:59:29 ******/
  854. ALTER TABLE [dbo].[Inventario] WITH CHECK ADD CONSTRAINT [FK_InxIt] FOREIGN KEY([IdItem])
  855. REFERENCES [dbo].[Items] ([IdItem])
  856. GO
  857. ALTER TABLE [dbo].[Inventario] CHECK CONSTRAINT [FK_InxIt]
  858. GO
  859. /****** Object: ForeignKey [FK_InxP] Script Date: 12/12/2016 19:59:29 ******/
  860. ALTER TABLE [dbo].[Inventario] WITH CHECK ADD CONSTRAINT [FK_InxP] FOREIGN KEY([IdPersonaje])
  861. REFERENCES [dbo].[Personajes] ([IdPersonaje])
  862. GO
  863. ALTER TABLE [dbo].[Inventario] CHECK CONSTRAINT [FK_InxP]
  864. GO
  865. /****** Object: ForeignKey [FK_H] Script Date: 12/12/2016 19:59:29 ******/
  866. ALTER TABLE [dbo].[HxP] WITH CHECK ADD CONSTRAINT [FK_H] FOREIGN KEY([IdHabilidad])
  867. REFERENCES [dbo].[Habilidades] ([IdHabilidad])
  868. GO
  869. ALTER TABLE [dbo].[HxP] CHECK CONSTRAINT [FK_H]
  870. GO
  871. /****** Object: ForeignKey [FK_Ph] Script Date: 12/12/2016 19:59:29 ******/
  872. ALTER TABLE [dbo].[HxP] WITH CHECK ADD CONSTRAINT [FK_Ph] FOREIGN KEY([IdPersonaje])
  873. REFERENCES [dbo].[Personajes] ([IdPersonaje])
  874. GO
  875. ALTER TABLE [dbo].[HxP] CHECK CONSTRAINT [FK_Ph]
  876. GO
  877. /****** Object: ForeignKey [FK_E] Script Date: 12/12/2016 19:59:29 ******/
  878. ALTER TABLE [dbo].[HxE] WITH CHECK ADD CONSTRAINT [FK_E] FOREIGN KEY([IdEnemigo])
  879. REFERENCES [dbo].[Enemies] ([IdEnemy])
  880. GO
  881. ALTER TABLE [dbo].[HxE] CHECK CONSTRAINT [FK_E]
  882. GO
  883. /****** Object: ForeignKey [FK_SkillE] Script Date: 12/12/2016 19:59:29 ******/
  884. ALTER TABLE [dbo].[HxE] WITH CHECK ADD CONSTRAINT [FK_SkillE] FOREIGN KEY([IdHabilidad])
  885. REFERENCES [dbo].[Habilidades] ([IdHabilidad])
  886. GO
  887. ALTER TABLE [dbo].[HxE] CHECK CONSTRAINT [FK_SkillE]
  888. GO
  889. /****** Object: ForeignKey [fk_hist_prod] Script Date: 12/12/2016 19:59:29 ******/
  890. ALTER TABLE [dbo].[HistorialDeCompra] WITH CHECK ADD CONSTRAINT [fk_hist_prod] FOREIGN KEY([IdProducto])
  891. REFERENCES [dbo].[Productos] ([IdProducto])
  892. GO
  893. ALTER TABLE [dbo].[HistorialDeCompra] CHECK CONSTRAINT [fk_hist_prod]
  894. GO
  895. /****** Object: ForeignKey [fk_hist_user] Script Date: 12/12/2016 19:59:29 ******/
  896. ALTER TABLE [dbo].[HistorialDeCompra] WITH CHECK ADD CONSTRAINT [fk_hist_user] FOREIGN KEY([IdUsuario])
  897. REFERENCES [dbo].[Usuarios] ([IdUsuario])
  898. GO
  899. ALTER TABLE [dbo].[HistorialDeCompra] CHECK CONSTRAINT [fk_hist_user]
  900. 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!