20220430083606_13.cs 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
  1. using Microsoft.EntityFrameworkCore.Migrations;
  2. #nullable disable
  3. namespace WCS.Service.Migrations
  4. {
  5. public partial class _13 : Migration
  6. {
  7. protected override void Up(MigrationBuilder migrationBuilder)
  8. {
  9. migrationBuilder.DropColumn(
  10. name: "Finish_1",
  11. table: "WCS_RGV521");
  12. migrationBuilder.DropColumn(
  13. name: "Finish_2",
  14. table: "WCS_RGV521");
  15. migrationBuilder.DropColumn(
  16. name: "PH_Status_1",
  17. table: "WCS_RGV521");
  18. migrationBuilder.DropColumn(
  19. name: "PH_Status_2",
  20. table: "WCS_RGV521");
  21. migrationBuilder.DropColumn(
  22. name: "RES3_1",
  23. table: "WCS_RGV521");
  24. migrationBuilder.DropColumn(
  25. name: "RES3_2",
  26. table: "WCS_RGV521");
  27. migrationBuilder.DropColumn(
  28. name: "RES4_1",
  29. table: "WCS_RGV521");
  30. migrationBuilder.DropColumn(
  31. name: "RES4_2",
  32. table: "WCS_RGV521");
  33. migrationBuilder.DropColumn(
  34. name: "RES5_1",
  35. table: "WCS_RGV521");
  36. migrationBuilder.DropColumn(
  37. name: "RES5_2",
  38. table: "WCS_RGV521");
  39. migrationBuilder.DropColumn(
  40. name: "RES6_1",
  41. table: "WCS_RGV521");
  42. migrationBuilder.DropColumn(
  43. name: "RES6_2",
  44. table: "WCS_RGV521");
  45. migrationBuilder.DropColumn(
  46. name: "RES7_1",
  47. table: "WCS_RGV521");
  48. migrationBuilder.DropColumn(
  49. name: "RES7_2",
  50. table: "WCS_RGV521");
  51. migrationBuilder.DropColumn(
  52. name: "ToSition_1",
  53. table: "WCS_RGV521");
  54. migrationBuilder.DropColumn(
  55. name: "ToSition_2",
  56. table: "WCS_RGV521");
  57. migrationBuilder.AddColumn<int>(
  58. name: "Status_1",
  59. table: "WCS_RGV521",
  60. type: "int",
  61. nullable: false,
  62. defaultValue: 0);
  63. migrationBuilder.AddColumn<int>(
  64. name: "Status_2",
  65. table: "WCS_RGV521",
  66. type: "int",
  67. nullable: false,
  68. defaultValue: 0);
  69. }
  70. protected override void Down(MigrationBuilder migrationBuilder)
  71. {
  72. migrationBuilder.DropColumn(
  73. name: "Status_1",
  74. table: "WCS_RGV521");
  75. migrationBuilder.DropColumn(
  76. name: "Status_2",
  77. table: "WCS_RGV521");
  78. migrationBuilder.AddColumn<bool>(
  79. name: "Finish_1",
  80. table: "WCS_RGV521",
  81. type: "bit",
  82. nullable: false,
  83. defaultValue: false);
  84. migrationBuilder.AddColumn<bool>(
  85. name: "Finish_2",
  86. table: "WCS_RGV521",
  87. type: "bit",
  88. nullable: false,
  89. defaultValue: false);
  90. migrationBuilder.AddColumn<bool>(
  91. name: "PH_Status_1",
  92. table: "WCS_RGV521",
  93. type: "bit",
  94. nullable: false,
  95. defaultValue: false);
  96. migrationBuilder.AddColumn<bool>(
  97. name: "PH_Status_2",
  98. table: "WCS_RGV521",
  99. type: "bit",
  100. nullable: false,
  101. defaultValue: false);
  102. migrationBuilder.AddColumn<bool>(
  103. name: "RES3_1",
  104. table: "WCS_RGV521",
  105. type: "bit",
  106. nullable: false,
  107. defaultValue: false);
  108. migrationBuilder.AddColumn<bool>(
  109. name: "RES3_2",
  110. table: "WCS_RGV521",
  111. type: "bit",
  112. nullable: false,
  113. defaultValue: false);
  114. migrationBuilder.AddColumn<bool>(
  115. name: "RES4_1",
  116. table: "WCS_RGV521",
  117. type: "bit",
  118. nullable: false,
  119. defaultValue: false);
  120. migrationBuilder.AddColumn<bool>(
  121. name: "RES4_2",
  122. table: "WCS_RGV521",
  123. type: "bit",
  124. nullable: false,
  125. defaultValue: false);
  126. migrationBuilder.AddColumn<bool>(
  127. name: "RES5_1",
  128. table: "WCS_RGV521",
  129. type: "bit",
  130. nullable: false,
  131. defaultValue: false);
  132. migrationBuilder.AddColumn<bool>(
  133. name: "RES5_2",
  134. table: "WCS_RGV521",
  135. type: "bit",
  136. nullable: false,
  137. defaultValue: false);
  138. migrationBuilder.AddColumn<bool>(
  139. name: "RES6_1",
  140. table: "WCS_RGV521",
  141. type: "bit",
  142. nullable: false,
  143. defaultValue: false);
  144. migrationBuilder.AddColumn<bool>(
  145. name: "RES6_2",
  146. table: "WCS_RGV521",
  147. type: "bit",
  148. nullable: false,
  149. defaultValue: false);
  150. migrationBuilder.AddColumn<bool>(
  151. name: "RES7_1",
  152. table: "WCS_RGV521",
  153. type: "bit",
  154. nullable: false,
  155. defaultValue: false);
  156. migrationBuilder.AddColumn<bool>(
  157. name: "RES7_2",
  158. table: "WCS_RGV521",
  159. type: "bit",
  160. nullable: false,
  161. defaultValue: false);
  162. migrationBuilder.AddColumn<bool>(
  163. name: "ToSition_1",
  164. table: "WCS_RGV521",
  165. type: "bit",
  166. nullable: false,
  167. defaultValue: false);
  168. migrationBuilder.AddColumn<bool>(
  169. name: "ToSition_2",
  170. table: "WCS_RGV521",
  171. type: "bit",
  172. nullable: false,
  173. defaultValue: false);
  174. }
  175. }
  176. }