API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 19th, 2019
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.90 KB | None | 0 0
raw download clone embed print report
  1. using System;
  2. using Microsoft.EntityFrameworkCore.Metadata;
  3. using Microsoft.EntityFrameworkCore.Migrations;
  4.  
  5. namespace WebzMarket.Migrations
  6. {
  7. public partial class test : Migration
  8. {
  9. protected override void Up(MigrationBuilder migrationBuilder)
  10. {
  11. migrationBuilder.CreateTable(
  12. name: "AspNetRoles",
  13. columns: table => new
  14. {
  15. Id = table.Column<string>(nullable: false),
  16. Name = table.Column<string>(maxLength: 256, nullable: true),
  17. NormalizedName = table.Column<string>(maxLength: 256, nullable: true),
  18. ConcurrencyStamp = table.Column<string>(nullable: true)
  19. },
  20. constraints: table =>
  21. {
  22. table.PrimaryKey("PK_AspNetRoles", x => x.Id);
  23. });
  24.  
  25. migrationBuilder.CreateTable(
  26. name: "AspNetUsers",
  27. columns: table => new
  28. {
  29. Id = table.Column<string>(nullable: false),
  30. UserName = table.Column<string>(maxLength: 256, nullable: true),
  31. NormalizedUserName = table.Column<string>(maxLength: 256, nullable: true),
  32. Email = table.Column<string>(maxLength: 256, nullable: true),
  33. NormalizedEmail = table.Column<string>(maxLength: 256, nullable: true),
  34. EmailConfirmed = table.Column<bool>(nullable: false),
  35. PasswordHash = table.Column<string>(nullable: true),
  36. SecurityStamp = table.Column<string>(nullable: true),
  37. ConcurrencyStamp = table.Column<string>(nullable: true),
  38. PhoneNumber = table.Column<string>(nullable: true),
  39. PhoneNumberConfirmed = table.Column<bool>(nullable: false),
  40. TwoFactorEnabled = table.Column<bool>(nullable: false),
  41. LockoutEnd = table.Column<DateTimeOffset>(nullable: true),
  42. LockoutEnabled = table.Column<bool>(nullable: false),
  43. AccessFailedCount = table.Column<int>(nullable: false)
  44. },
  45. constraints: table =>
  46. {
  47. table.PrimaryKey("PK_AspNetUsers", x => x.Id);
  48. });
  49.  
  50. migrationBuilder.CreateTable(
  51. name: "Produits",
  52. columns: table => new
  53. {
  54. ProduitId = table.Column<Guid>(nullable: false),
  55. Nom = table.Column<string>(nullable: true),
  56. Prix = table.Column<decimal>(nullable: false),
  57. Quantite = table.Column<int>(nullable: false),
  58. Categorie = table.Column<string>(nullable: true),
  59. Description = table.Column<string>(nullable: true),
  60. ImageName = table.Column<string>(nullable: true)
  61. },
  62. constraints: table =>
  63. {
  64. table.PrimaryKey("PK_Produits", x => x.ProduitId);
  65. });
  66.  
  67. migrationBuilder.CreateTable(
  68. name: "AspNetRoleClaims",
  69. columns: table => new
  70. {
  71. Id = table.Column<int>(nullable: false)
  72. .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
  73. RoleId = table.Column<string>(nullable: false),
  74. ClaimType = table.Column<string>(nullable: true),
  75. ClaimValue = table.Column<string>(nullable: true)
  76. },
  77. constraints: table =>
  78. {
  79. table.PrimaryKey("PK_AspNetRoleClaims", x => x.Id);
  80. table.ForeignKey(
  81. name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
  82. column: x => x.RoleId,
  83. principalTable: "AspNetRoles",
  84. principalColumn: "Id",
  85. onDelete: ReferentialAction.Cascade);
  86. });
  87.  
  88. migrationBuilder.CreateTable(
  89. name: "Adresses",
  90. columns: table => new
  91. {
  92. ID = table.Column<int>(nullable: false)
  93. .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
  94. UtilisateurId = table.Column<string>(nullable: true),
  95. UserAdresse = table.Column<string>(nullable: true),
  96. Province = table.Column<string>(nullable: true),
  97. Pays = table.Column<string>(nullable: true),
  98. Ville = table.Column<string>(nullable: true),
  99. CodePostal = table.Column<string>(nullable: true)
  100. },
  101. constraints: table =>
  102. {
  103. table.PrimaryKey("PK_Adresses", x => x.ID);
  104. table.ForeignKey(
  105. name: "FK_Adresses_AspNetUsers_UtilisateurId",
  106. column: x => x.UtilisateurId,
  107. principalTable: "AspNetUsers",
  108. principalColumn: "Id",
  109. onDelete: ReferentialAction.Restrict);
  110. });
  111.  
  112. migrationBuilder.CreateTable(
  113. name: "AspNetUserClaims",
  114. columns: table => new
  115. {
  116. Id = table.Column<int>(nullable: false)
  117. .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
  118. UserId = table.Column<string>(nullable: false),
  119. ClaimType = table.Column<string>(nullable: true),
  120. ClaimValue = table.Column<string>(nullable: true)
  121. },
  122. constraints: table =>
  123. {
  124. table.PrimaryKey("PK_AspNetUserClaims", x => x.Id);
  125. table.ForeignKey(
  126. name: "FK_AspNetUserClaims_AspNetUsers_UserId",
  127. column: x => x.UserId,
  128. principalTable: "AspNetUsers",
  129. principalColumn: "Id",
  130. onDelete: ReferentialAction.Cascade);
  131. });
  132.  
  133. migrationBuilder.CreateTable(
  134. name: "AspNetUserLogins",
  135. columns: table => new
  136. {
  137. LoginProvider = table.Column<string>(nullable: false),
  138. ProviderKey = table.Column<string>(nullable: false),
  139. ProviderDisplayName = table.Column<string>(nullable: true),
  140. UserId = table.Column<string>(nullable: false)
  141. },
  142. constraints: table =>
  143. {
  144. table.PrimaryKey("PK_AspNetUserLogins", x => new { x.LoginProvider, x.ProviderKey });
  145. table.ForeignKey(
  146. name: "FK_AspNetUserLogins_AspNetUsers_UserId",
  147. column: x => x.UserId,
  148. principalTable: "AspNetUsers",
  149. principalColumn: "Id",
  150. onDelete: ReferentialAction.Cascade);
  151. });
  152.  
  153. migrationBuilder.CreateTable(
  154. name: "AspNetUserRoles",
  155. columns: table => new
  156. {
  157. UserId = table.Column<string>(nullable: false),
  158. RoleId = table.Column<string>(nullable: false)
  159. },
  160. constraints: table =>
  161. {
  162. table.PrimaryKey("PK_AspNetUserRoles", x => new { x.UserId, x.RoleId });
  163. table.ForeignKey(
  164. name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
  165. column: x => x.RoleId,
  166. principalTable: "AspNetRoles",
  167. principalColumn: "Id",
  168. onDelete: ReferentialAction.Cascade);
  169. table.ForeignKey(
  170. name: "FK_AspNetUserRoles_AspNetUsers_UserId",
  171. column: x => x.UserId,
  172. principalTable: "AspNetUsers",
  173. principalColumn: "Id",
  174. onDelete: ReferentialAction.Cascade);
  175. });
  176.  
  177. migrationBuilder.CreateTable(
  178. name: "AspNetUserTokens",
  179. columns: table => new
  180. {
  181. UserId = table.Column<string>(nullable: false),
  182. LoginProvider = table.Column<string>(nullable: false),
  183. Name = table.Column<string>(nullable: false),
  184. Value = table.Column<string>(nullable: true)
  185. },
  186. constraints: table =>
  187. {
  188. table.PrimaryKey("PK_AspNetUserTokens", x => new { x.UserId, x.LoginProvider, x.Name });
  189. table.ForeignKey(
  190. name: "FK_AspNetUserTokens_AspNetUsers_UserId",
  191. column: x => x.UserId,
  192. principalTable: "AspNetUsers",
  193. principalColumn: "Id",
  194. onDelete: ReferentialAction.Cascade);
  195. });
  196.  
  197. migrationBuilder.CreateTable(
  198. name: "Commandes",
  199. columns: table => new
  200. {
  201. Id = table.Column<int>(nullable: false)
  202. .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
  203. UtilisateurId = table.Column<string>(nullable: true),
  204. AdresseID = table.Column<int>(nullable: false),
  205. ProduitId = table.Column<Guid>(nullable: true)
  206. },
  207. constraints: table =>
  208. {
  209. table.PrimaryKey("PK_Commandes", x => x.Id);
  210. table.ForeignKey(
  211. name: "FK_Commandes_Adresses_AdresseID",
  212. column: x => x.AdresseID,
  213. principalTable: "Adresses",
  214. principalColumn: "ID",
  215. onDelete: ReferentialAction.Cascade);
  216. table.ForeignKey(
  217. name: "FK_Commandes_Produits_ProduitId",
  218. column: x => x.ProduitId,
  219. principalTable: "Produits",
  220. principalColumn: "ProduitId",
  221. onDelete: ReferentialAction.Restrict);
  222. table.ForeignKey(
  223. name: "FK_Commandes_AspNetUsers_UtilisateurId",
  224. column: x => x.UtilisateurId,
  225. principalTable: "AspNetUsers",
  226. principalColumn: "Id",
  227. onDelete: ReferentialAction.Restrict);
  228. });
  229.  
  230. migrationBuilder.CreateTable(
  231. name: "CommandeProduit",
  232. columns: table => new
  233. {
  234. ID = table.Column<int>(nullable: false)
  235. .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
  236. CommandeID = table.Column<int>(nullable: false),
  237. ProduitID = table.Column<Guid>(nullable: false)
  238. },
  239. constraints: table =>
  240. {
  241. table.PrimaryKey("PK_CommandeProduit", x => x.ID);
  242. table.ForeignKey(
  243. name: "FK_CommandeProduit_Commandes_CommandeID",
  244. column: x => x.CommandeID,
  245. principalTable: "Commandes",
  246. principalColumn: "Id",
  247. onDelete: ReferentialAction.Cascade);
  248. table.ForeignKey(
  249. name: "FK_CommandeProduit_Produits_ProduitID",
  250. column: x => x.ProduitID,
  251. principalTable: "Produits",
  252. principalColumn: "ProduitId",
  253. onDelete: ReferentialAction.Cascade);
  254. });
  255.  
  256. migrationBuilder.CreateTable(
  257. name: "Paniers",
  258. columns: table => new
  259. {
  260. ID = table.Column<int>(nullable: false)
  261. .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
  262. UtilisateurId = table.Column<string>(nullable: true),
  263. ProduitId = table.Column<Guid>(nullable: false),
  264. CommandeId = table.Column<int>(nullable: true)
  265. },
  266. constraints: table =>
  267. {
  268. table.PrimaryKey("PK_Paniers", x => x.ID);
  269. table.ForeignKey(
  270. name: "FK_Paniers_Commandes_CommandeId",
  271. column: x => x.CommandeId,
  272. principalTable: "Commandes",
  273. principalColumn: "Id",
  274. onDelete: ReferentialAction.Restrict);
  275. table.ForeignKey(
  276. name: "FK_Paniers_Produits_ProduitId",
  277. column: x => x.ProduitId,
  278. principalTable: "Produits",
  279. principalColumn: "ProduitId",
  280. onDelete: ReferentialAction.Cascade);
  281. table.ForeignKey(
  282. name: "FK_Paniers_AspNetUsers_UtilisateurId",
  283. column: x => x.UtilisateurId,
  284. principalTable: "AspNetUsers",
  285. principalColumn: "Id",
  286. onDelete: ReferentialAction.Restrict);
  287. });
  288.  
  289. migrationBuilder.CreateIndex(
  290. name: "IX_Adresses_UtilisateurId",
  291. table: "Adresses",
  292. column: "UtilisateurId");
  293.  
  294. migrationBuilder.CreateIndex(
  295. name: "IX_AspNetRoleClaims_RoleId",
  296. table: "AspNetRoleClaims",
  297. column: "RoleId");
  298.  
  299. migrationBuilder.CreateIndex(
  300. name: "RoleNameIndex",
  301. table: "AspNetRoles",
  302. column: "NormalizedName",
  303. unique: true,
  304. filter: "[NormalizedName] IS NOT NULL");
  305.  
  306. migrationBuilder.CreateIndex(
  307. name: "IX_AspNetUserClaims_UserId",
  308. table: "AspNetUserClaims",
  309. column: "UserId");
  310.  
  311. migrationBuilder.CreateIndex(
  312. name: "IX_AspNetUserLogins_UserId",
  313. table: "AspNetUserLogins",
  314. column: "UserId");
  315.  
  316. migrationBuilder.CreateIndex(
  317. name: "IX_AspNetUserRoles_RoleId",
  318. table: "AspNetUserRoles",
  319. column: "RoleId");
  320.  
  321. migrationBuilder.CreateIndex(
  322. name: "EmailIndex",
  323. table: "AspNetUsers",
  324. column: "NormalizedEmail");
  325.  
  326. migrationBuilder.CreateIndex(
  327. name: "UserNameIndex",
  328. table: "AspNetUsers",
  329. column: "NormalizedUserName",
  330. unique: true,
  331. filter: "[NormalizedUserName] IS NOT NULL");
  332.  
  333. migrationBuilder.CreateIndex(
  334. name: "IX_CommandeProduit_CommandeID",
  335. table: "CommandeProduit",
  336. column: "CommandeID");
  337.  
  338. migrationBuilder.CreateIndex(
  339. name: "IX_CommandeProduit_ProduitID",
  340. table: "CommandeProduit",
  341. column: "ProduitID");
  342.  
  343. migrationBuilder.CreateIndex(
  344. name: "IX_Commandes_AdresseID",
  345. table: "Commandes",
  346. column: "AdresseID");
  347.  
  348. migrationBuilder.CreateIndex(
  349. name: "IX_Commandes_ProduitId",
  350. table: "Commandes",
  351. column: "ProduitId");
  352.  
  353. migrationBuilder.CreateIndex(
  354. name: "IX_Commandes_UtilisateurId",
  355. table: "Commandes",
  356. column: "UtilisateurId");
  357.  
  358. migrationBuilder.CreateIndex(
  359. name: "IX_Paniers_CommandeId",
  360. table: "Paniers",
  361. column: "CommandeId");
  362.  
  363. migrationBuilder.CreateIndex(
  364. name: "IX_Paniers_ProduitId",
  365. table: "Paniers",
  366. column: "ProduitId");
  367.  
  368. migrationBuilder.CreateIndex(
  369. name: "IX_Paniers_UtilisateurId",
  370. table: "Paniers",
  371. column: "UtilisateurId");
  372. }
  373.  
  374. protected override void Down(MigrationBuilder migrationBuilder)
  375. {
  376. migrationBuilder.DropTable(
  377. name: "AspNetRoleClaims");
  378.  
  379. migrationBuilder.DropTable(
  380. name: "AspNetUserClaims");
  381.  
  382. migrationBuilder.DropTable(
  383. name: "AspNetUserLogins");
  384.  
  385. migrationBuilder.DropTable(
  386. name: "AspNetUserRoles");
  387.  
  388. migrationBuilder.DropTable(
  389. name: "AspNetUserTokens");
  390.  
  391. migrationBuilder.DropTable(
  392. name: "CommandeProduit");
  393.  
  394. migrationBuilder.DropTable(
  395. name: "Paniers");
  396.  
  397. migrationBuilder.DropTable(
  398. name: "AspNetRoles");
  399.  
  400. migrationBuilder.DropTable(
  401. name: "Commandes");
  402.  
  403. migrationBuilder.DropTable(
  404. name: "Adresses");
  405.  
  406. migrationBuilder.DropTable(
  407. name: "Produits");
  408.  
  409. migrationBuilder.DropTable(
  410. name: "AspNetUsers");
  411. }
  412. }
  413. }
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!