20200703132950_Tracking.cs 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224
  1. using System;
  2. using Microsoft.EntityFrameworkCore.Migrations;
  3. namespace GreenTree.Strohrmann.ERP.Domain.Migrations
  4. {
  5. public partial class Tracking : Migration
  6. {
  7. protected override void Up(MigrationBuilder migrationBuilder)
  8. {
  9. migrationBuilder.AddColumn<string>(
  10. name: "ChangedBy",
  11. table: "Suppliers",
  12. nullable: true);
  13. migrationBuilder.AddColumn<DateTime>(
  14. name: "ChangedOn",
  15. table: "Suppliers",
  16. nullable: true);
  17. migrationBuilder.AddColumn<string>(
  18. name: "CreatedBy",
  19. table: "Suppliers",
  20. nullable: false);
  21. migrationBuilder.AddColumn<DateTime>(
  22. name: "CreatedOn",
  23. table: "Suppliers",
  24. nullable: false,
  25. defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified));
  26. migrationBuilder.AddColumn<string>(
  27. name: "ChangedBy",
  28. table: "Materials",
  29. nullable: true);
  30. migrationBuilder.AddColumn<DateTime>(
  31. name: "ChangedOn",
  32. table: "Materials",
  33. nullable: true);
  34. migrationBuilder.AddColumn<string>(
  35. name: "CreatedBy",
  36. table: "Materials",
  37. nullable: false);
  38. migrationBuilder.AddColumn<DateTime>(
  39. name: "CreatedOn",
  40. table: "Materials",
  41. nullable: false,
  42. defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified));
  43. migrationBuilder.AddColumn<string>(
  44. name: "ChangedBy",
  45. table: "Employees",
  46. nullable: true);
  47. migrationBuilder.AddColumn<DateTime>(
  48. name: "ChangedOn",
  49. table: "Employees",
  50. nullable: true);
  51. migrationBuilder.AddColumn<string>(
  52. name: "CreatedBy",
  53. table: "Employees",
  54. nullable: false);
  55. migrationBuilder.AddColumn<DateTime>(
  56. name: "CreatedOn",
  57. table: "Employees",
  58. nullable: false,
  59. defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified));
  60. migrationBuilder.AlterColumn<int>(
  61. name: "TaxId",
  62. table: "Customers",
  63. nullable: true,
  64. oldClrType: typeof(int),
  65. oldType: "int");
  66. migrationBuilder.AddColumn<string>(
  67. name: "ChangedBy",
  68. table: "Customers",
  69. nullable: true);
  70. migrationBuilder.AddColumn<DateTime>(
  71. name: "ChangedOn",
  72. table: "Customers",
  73. nullable: true);
  74. migrationBuilder.AddColumn<string>(
  75. name: "CreatedBy",
  76. table: "Customers",
  77. nullable: false);
  78. migrationBuilder.AddColumn<DateTime>(
  79. name: "CreatedOn",
  80. table: "Customers",
  81. nullable: false,
  82. defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified));
  83. migrationBuilder.AddColumn<bool>(
  84. name: "IsBusiness",
  85. table: "Customers",
  86. nullable: false,
  87. defaultValue: false);
  88. migrationBuilder.AddColumn<string>(
  89. name: "ChangedBy",
  90. table: "Crafts",
  91. nullable: true);
  92. migrationBuilder.AddColumn<DateTime>(
  93. name: "ChangedOn",
  94. table: "Crafts",
  95. nullable: true);
  96. migrationBuilder.AddColumn<string>(
  97. name: "CreatedBy",
  98. table: "Crafts",
  99. nullable: false);
  100. migrationBuilder.AddColumn<DateTime>(
  101. name: "CreatedOn",
  102. table: "Crafts",
  103. nullable: false,
  104. defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified));
  105. }
  106. protected override void Down(MigrationBuilder migrationBuilder)
  107. {
  108. migrationBuilder.DropColumn(
  109. name: "ChangedBy",
  110. table: "Suppliers");
  111. migrationBuilder.DropColumn(
  112. name: "ChangedOn",
  113. table: "Suppliers");
  114. migrationBuilder.DropColumn(
  115. name: "CreatedBy",
  116. table: "Suppliers");
  117. migrationBuilder.DropColumn(
  118. name: "CreatedOn",
  119. table: "Suppliers");
  120. migrationBuilder.DropColumn(
  121. name: "ChangedBy",
  122. table: "Materials");
  123. migrationBuilder.DropColumn(
  124. name: "ChangedOn",
  125. table: "Materials");
  126. migrationBuilder.DropColumn(
  127. name: "CreatedBy",
  128. table: "Materials");
  129. migrationBuilder.DropColumn(
  130. name: "CreatedOn",
  131. table: "Materials");
  132. migrationBuilder.DropColumn(
  133. name: "ChangedBy",
  134. table: "Employees");
  135. migrationBuilder.DropColumn(
  136. name: "ChangedOn",
  137. table: "Employees");
  138. migrationBuilder.DropColumn(
  139. name: "CreatedBy",
  140. table: "Employees");
  141. migrationBuilder.DropColumn(
  142. name: "CreatedOn",
  143. table: "Employees");
  144. migrationBuilder.DropColumn(
  145. name: "ChangedBy",
  146. table: "Customers");
  147. migrationBuilder.DropColumn(
  148. name: "ChangedOn",
  149. table: "Customers");
  150. migrationBuilder.DropColumn(
  151. name: "CreatedBy",
  152. table: "Customers");
  153. migrationBuilder.DropColumn(
  154. name: "CreatedOn",
  155. table: "Customers");
  156. migrationBuilder.DropColumn(
  157. name: "IsBusiness",
  158. table: "Customers");
  159. migrationBuilder.DropColumn(
  160. name: "ChangedBy",
  161. table: "Crafts");
  162. migrationBuilder.DropColumn(
  163. name: "ChangedOn",
  164. table: "Crafts");
  165. migrationBuilder.DropColumn(
  166. name: "CreatedBy",
  167. table: "Crafts");
  168. migrationBuilder.DropColumn(
  169. name: "CreatedOn",
  170. table: "Crafts");
  171. migrationBuilder.AlterColumn<int>(
  172. name: "TaxId",
  173. table: "Customers",
  174. type: "int",
  175. nullable: false,
  176. oldClrType: typeof(int),
  177. oldNullable: true);
  178. }
  179. }
  180. }