20240219082242_altrLogs.cs 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649
  1. using Microsoft.EntityFrameworkCore.Migrations;
  2. #nullable disable
  3. namespace MTWorkHR.Infrastructure.Migrations
  4. {
  5. /// <inheritdoc />
  6. public partial class altrLogs : Migration
  7. {
  8. /// <inheritdoc />
  9. protected override void Up(MigrationBuilder migrationBuilder)
  10. {
  11. migrationBuilder.AlterColumn<string>(
  12. name: "userAgent",
  13. table: "UserLogs",
  14. type: "nvarchar(max)",
  15. nullable: true,
  16. oldClrType: typeof(string),
  17. oldType: "nvarchar(max)");
  18. migrationBuilder.AlterColumn<string>(
  19. name: "UserIP",
  20. table: "UserLogs",
  21. type: "nvarchar(max)",
  22. nullable: true,
  23. oldClrType: typeof(string),
  24. oldType: "nvarchar(max)");
  25. migrationBuilder.AlterColumn<string>(
  26. name: "ServerIP",
  27. table: "UserLogs",
  28. type: "nvarchar(max)",
  29. nullable: true,
  30. oldClrType: typeof(string),
  31. oldType: "nvarchar(max)");
  32. migrationBuilder.AlterColumn<string>(
  33. name: "QueryString",
  34. table: "UserLogs",
  35. type: "nvarchar(max)",
  36. nullable: true,
  37. oldClrType: typeof(string),
  38. oldType: "nvarchar(max)");
  39. migrationBuilder.AlterColumn<string>(
  40. name: "Input",
  41. table: "UserLogs",
  42. type: "nvarchar(max)",
  43. nullable: true,
  44. oldClrType: typeof(string),
  45. oldType: "nvarchar(max)");
  46. migrationBuilder.AlterColumn<string>(
  47. name: "InnerException",
  48. table: "UserLogs",
  49. type: "nvarchar(max)",
  50. nullable: true,
  51. oldClrType: typeof(string),
  52. oldType: "nvarchar(max)");
  53. migrationBuilder.AlterColumn<string>(
  54. name: "Channel",
  55. table: "UserLogs",
  56. type: "nvarchar(max)",
  57. nullable: true,
  58. oldClrType: typeof(string),
  59. oldType: "nvarchar(max)");
  60. migrationBuilder.AlterColumn<string>(
  61. name: "userAgent",
  62. table: "SettingLogs",
  63. type: "nvarchar(max)",
  64. nullable: true,
  65. oldClrType: typeof(string),
  66. oldType: "nvarchar(max)");
  67. migrationBuilder.AlterColumn<string>(
  68. name: "UserIP",
  69. table: "SettingLogs",
  70. type: "nvarchar(max)",
  71. nullable: true,
  72. oldClrType: typeof(string),
  73. oldType: "nvarchar(max)");
  74. migrationBuilder.AlterColumn<string>(
  75. name: "ServerIP",
  76. table: "SettingLogs",
  77. type: "nvarchar(max)",
  78. nullable: true,
  79. oldClrType: typeof(string),
  80. oldType: "nvarchar(max)");
  81. migrationBuilder.AlterColumn<string>(
  82. name: "QueryString",
  83. table: "SettingLogs",
  84. type: "nvarchar(max)",
  85. nullable: true,
  86. oldClrType: typeof(string),
  87. oldType: "nvarchar(max)");
  88. migrationBuilder.AlterColumn<string>(
  89. name: "Input",
  90. table: "SettingLogs",
  91. type: "nvarchar(max)",
  92. nullable: true,
  93. oldClrType: typeof(string),
  94. oldType: "nvarchar(max)");
  95. migrationBuilder.AlterColumn<string>(
  96. name: "InnerException",
  97. table: "SettingLogs",
  98. type: "nvarchar(max)",
  99. nullable: true,
  100. oldClrType: typeof(string),
  101. oldType: "nvarchar(max)");
  102. migrationBuilder.AlterColumn<string>(
  103. name: "Channel",
  104. table: "SettingLogs",
  105. type: "nvarchar(max)",
  106. nullable: true,
  107. oldClrType: typeof(string),
  108. oldType: "nvarchar(max)");
  109. migrationBuilder.AlterColumn<string>(
  110. name: "userAgent",
  111. table: "RoleLogs",
  112. type: "nvarchar(max)",
  113. nullable: true,
  114. oldClrType: typeof(string),
  115. oldType: "nvarchar(max)");
  116. migrationBuilder.AlterColumn<string>(
  117. name: "UserIP",
  118. table: "RoleLogs",
  119. type: "nvarchar(max)",
  120. nullable: true,
  121. oldClrType: typeof(string),
  122. oldType: "nvarchar(max)");
  123. migrationBuilder.AlterColumn<string>(
  124. name: "ServerIP",
  125. table: "RoleLogs",
  126. type: "nvarchar(max)",
  127. nullable: true,
  128. oldClrType: typeof(string),
  129. oldType: "nvarchar(max)");
  130. migrationBuilder.AlterColumn<string>(
  131. name: "QueryString",
  132. table: "RoleLogs",
  133. type: "nvarchar(max)",
  134. nullable: true,
  135. oldClrType: typeof(string),
  136. oldType: "nvarchar(max)");
  137. migrationBuilder.AlterColumn<string>(
  138. name: "Input",
  139. table: "RoleLogs",
  140. type: "nvarchar(max)",
  141. nullable: true,
  142. oldClrType: typeof(string),
  143. oldType: "nvarchar(max)");
  144. migrationBuilder.AlterColumn<string>(
  145. name: "InnerException",
  146. table: "RoleLogs",
  147. type: "nvarchar(max)",
  148. nullable: true,
  149. oldClrType: typeof(string),
  150. oldType: "nvarchar(max)");
  151. migrationBuilder.AlterColumn<string>(
  152. name: "Channel",
  153. table: "RoleLogs",
  154. type: "nvarchar(max)",
  155. nullable: true,
  156. oldClrType: typeof(string),
  157. oldType: "nvarchar(max)");
  158. migrationBuilder.AlterColumn<string>(
  159. name: "userAgent",
  160. table: "FileLogs",
  161. type: "nvarchar(max)",
  162. nullable: true,
  163. oldClrType: typeof(string),
  164. oldType: "nvarchar(max)");
  165. migrationBuilder.AlterColumn<string>(
  166. name: "UserIP",
  167. table: "FileLogs",
  168. type: "nvarchar(max)",
  169. nullable: true,
  170. oldClrType: typeof(string),
  171. oldType: "nvarchar(max)");
  172. migrationBuilder.AlterColumn<string>(
  173. name: "ServerIP",
  174. table: "FileLogs",
  175. type: "nvarchar(max)",
  176. nullable: true,
  177. oldClrType: typeof(string),
  178. oldType: "nvarchar(max)");
  179. migrationBuilder.AlterColumn<string>(
  180. name: "QueryString",
  181. table: "FileLogs",
  182. type: "nvarchar(max)",
  183. nullable: true,
  184. oldClrType: typeof(string),
  185. oldType: "nvarchar(max)");
  186. migrationBuilder.AlterColumn<string>(
  187. name: "Input",
  188. table: "FileLogs",
  189. type: "nvarchar(max)",
  190. nullable: true,
  191. oldClrType: typeof(string),
  192. oldType: "nvarchar(max)");
  193. migrationBuilder.AlterColumn<string>(
  194. name: "InnerException",
  195. table: "FileLogs",
  196. type: "nvarchar(max)",
  197. nullable: true,
  198. oldClrType: typeof(string),
  199. oldType: "nvarchar(max)");
  200. migrationBuilder.AlterColumn<string>(
  201. name: "Channel",
  202. table: "FileLogs",
  203. type: "nvarchar(max)",
  204. nullable: true,
  205. oldClrType: typeof(string),
  206. oldType: "nvarchar(max)");
  207. migrationBuilder.AlterColumn<string>(
  208. name: "userAgent",
  209. table: "AuthLogs",
  210. type: "nvarchar(max)",
  211. nullable: true,
  212. oldClrType: typeof(string),
  213. oldType: "nvarchar(max)");
  214. migrationBuilder.AlterColumn<string>(
  215. name: "UserIP",
  216. table: "AuthLogs",
  217. type: "nvarchar(max)",
  218. nullable: true,
  219. oldClrType: typeof(string),
  220. oldType: "nvarchar(max)");
  221. migrationBuilder.AlterColumn<string>(
  222. name: "ServerIP",
  223. table: "AuthLogs",
  224. type: "nvarchar(max)",
  225. nullable: true,
  226. oldClrType: typeof(string),
  227. oldType: "nvarchar(max)");
  228. migrationBuilder.AlterColumn<string>(
  229. name: "QueryString",
  230. table: "AuthLogs",
  231. type: "nvarchar(max)",
  232. nullable: true,
  233. oldClrType: typeof(string),
  234. oldType: "nvarchar(max)");
  235. migrationBuilder.AlterColumn<string>(
  236. name: "Input",
  237. table: "AuthLogs",
  238. type: "nvarchar(max)",
  239. nullable: true,
  240. oldClrType: typeof(string),
  241. oldType: "nvarchar(max)");
  242. migrationBuilder.AlterColumn<string>(
  243. name: "InnerException",
  244. table: "AuthLogs",
  245. type: "nvarchar(max)",
  246. nullable: true,
  247. oldClrType: typeof(string),
  248. oldType: "nvarchar(max)");
  249. migrationBuilder.AlterColumn<string>(
  250. name: "Channel",
  251. table: "AuthLogs",
  252. type: "nvarchar(max)",
  253. nullable: true,
  254. oldClrType: typeof(string),
  255. oldType: "nvarchar(max)");
  256. }
  257. /// <inheritdoc />
  258. protected override void Down(MigrationBuilder migrationBuilder)
  259. {
  260. migrationBuilder.AlterColumn<string>(
  261. name: "userAgent",
  262. table: "UserLogs",
  263. type: "nvarchar(max)",
  264. nullable: false,
  265. defaultValue: "",
  266. oldClrType: typeof(string),
  267. oldType: "nvarchar(max)",
  268. oldNullable: true);
  269. migrationBuilder.AlterColumn<string>(
  270. name: "UserIP",
  271. table: "UserLogs",
  272. type: "nvarchar(max)",
  273. nullable: false,
  274. defaultValue: "",
  275. oldClrType: typeof(string),
  276. oldType: "nvarchar(max)",
  277. oldNullable: true);
  278. migrationBuilder.AlterColumn<string>(
  279. name: "ServerIP",
  280. table: "UserLogs",
  281. type: "nvarchar(max)",
  282. nullable: false,
  283. defaultValue: "",
  284. oldClrType: typeof(string),
  285. oldType: "nvarchar(max)",
  286. oldNullable: true);
  287. migrationBuilder.AlterColumn<string>(
  288. name: "QueryString",
  289. table: "UserLogs",
  290. type: "nvarchar(max)",
  291. nullable: false,
  292. defaultValue: "",
  293. oldClrType: typeof(string),
  294. oldType: "nvarchar(max)",
  295. oldNullable: true);
  296. migrationBuilder.AlterColumn<string>(
  297. name: "Input",
  298. table: "UserLogs",
  299. type: "nvarchar(max)",
  300. nullable: false,
  301. defaultValue: "",
  302. oldClrType: typeof(string),
  303. oldType: "nvarchar(max)",
  304. oldNullable: true);
  305. migrationBuilder.AlterColumn<string>(
  306. name: "InnerException",
  307. table: "UserLogs",
  308. type: "nvarchar(max)",
  309. nullable: false,
  310. defaultValue: "",
  311. oldClrType: typeof(string),
  312. oldType: "nvarchar(max)",
  313. oldNullable: true);
  314. migrationBuilder.AlterColumn<string>(
  315. name: "Channel",
  316. table: "UserLogs",
  317. type: "nvarchar(max)",
  318. nullable: false,
  319. defaultValue: "",
  320. oldClrType: typeof(string),
  321. oldType: "nvarchar(max)",
  322. oldNullable: true);
  323. migrationBuilder.AlterColumn<string>(
  324. name: "userAgent",
  325. table: "SettingLogs",
  326. type: "nvarchar(max)",
  327. nullable: false,
  328. defaultValue: "",
  329. oldClrType: typeof(string),
  330. oldType: "nvarchar(max)",
  331. oldNullable: true);
  332. migrationBuilder.AlterColumn<string>(
  333. name: "UserIP",
  334. table: "SettingLogs",
  335. type: "nvarchar(max)",
  336. nullable: false,
  337. defaultValue: "",
  338. oldClrType: typeof(string),
  339. oldType: "nvarchar(max)",
  340. oldNullable: true);
  341. migrationBuilder.AlterColumn<string>(
  342. name: "ServerIP",
  343. table: "SettingLogs",
  344. type: "nvarchar(max)",
  345. nullable: false,
  346. defaultValue: "",
  347. oldClrType: typeof(string),
  348. oldType: "nvarchar(max)",
  349. oldNullable: true);
  350. migrationBuilder.AlterColumn<string>(
  351. name: "QueryString",
  352. table: "SettingLogs",
  353. type: "nvarchar(max)",
  354. nullable: false,
  355. defaultValue: "",
  356. oldClrType: typeof(string),
  357. oldType: "nvarchar(max)",
  358. oldNullable: true);
  359. migrationBuilder.AlterColumn<string>(
  360. name: "Input",
  361. table: "SettingLogs",
  362. type: "nvarchar(max)",
  363. nullable: false,
  364. defaultValue: "",
  365. oldClrType: typeof(string),
  366. oldType: "nvarchar(max)",
  367. oldNullable: true);
  368. migrationBuilder.AlterColumn<string>(
  369. name: "InnerException",
  370. table: "SettingLogs",
  371. type: "nvarchar(max)",
  372. nullable: false,
  373. defaultValue: "",
  374. oldClrType: typeof(string),
  375. oldType: "nvarchar(max)",
  376. oldNullable: true);
  377. migrationBuilder.AlterColumn<string>(
  378. name: "Channel",
  379. table: "SettingLogs",
  380. type: "nvarchar(max)",
  381. nullable: false,
  382. defaultValue: "",
  383. oldClrType: typeof(string),
  384. oldType: "nvarchar(max)",
  385. oldNullable: true);
  386. migrationBuilder.AlterColumn<string>(
  387. name: "userAgent",
  388. table: "RoleLogs",
  389. type: "nvarchar(max)",
  390. nullable: false,
  391. defaultValue: "",
  392. oldClrType: typeof(string),
  393. oldType: "nvarchar(max)",
  394. oldNullable: true);
  395. migrationBuilder.AlterColumn<string>(
  396. name: "UserIP",
  397. table: "RoleLogs",
  398. type: "nvarchar(max)",
  399. nullable: false,
  400. defaultValue: "",
  401. oldClrType: typeof(string),
  402. oldType: "nvarchar(max)",
  403. oldNullable: true);
  404. migrationBuilder.AlterColumn<string>(
  405. name: "ServerIP",
  406. table: "RoleLogs",
  407. type: "nvarchar(max)",
  408. nullable: false,
  409. defaultValue: "",
  410. oldClrType: typeof(string),
  411. oldType: "nvarchar(max)",
  412. oldNullable: true);
  413. migrationBuilder.AlterColumn<string>(
  414. name: "QueryString",
  415. table: "RoleLogs",
  416. type: "nvarchar(max)",
  417. nullable: false,
  418. defaultValue: "",
  419. oldClrType: typeof(string),
  420. oldType: "nvarchar(max)",
  421. oldNullable: true);
  422. migrationBuilder.AlterColumn<string>(
  423. name: "Input",
  424. table: "RoleLogs",
  425. type: "nvarchar(max)",
  426. nullable: false,
  427. defaultValue: "",
  428. oldClrType: typeof(string),
  429. oldType: "nvarchar(max)",
  430. oldNullable: true);
  431. migrationBuilder.AlterColumn<string>(
  432. name: "InnerException",
  433. table: "RoleLogs",
  434. type: "nvarchar(max)",
  435. nullable: false,
  436. defaultValue: "",
  437. oldClrType: typeof(string),
  438. oldType: "nvarchar(max)",
  439. oldNullable: true);
  440. migrationBuilder.AlterColumn<string>(
  441. name: "Channel",
  442. table: "RoleLogs",
  443. type: "nvarchar(max)",
  444. nullable: false,
  445. defaultValue: "",
  446. oldClrType: typeof(string),
  447. oldType: "nvarchar(max)",
  448. oldNullable: true);
  449. migrationBuilder.AlterColumn<string>(
  450. name: "userAgent",
  451. table: "FileLogs",
  452. type: "nvarchar(max)",
  453. nullable: false,
  454. defaultValue: "",
  455. oldClrType: typeof(string),
  456. oldType: "nvarchar(max)",
  457. oldNullable: true);
  458. migrationBuilder.AlterColumn<string>(
  459. name: "UserIP",
  460. table: "FileLogs",
  461. type: "nvarchar(max)",
  462. nullable: false,
  463. defaultValue: "",
  464. oldClrType: typeof(string),
  465. oldType: "nvarchar(max)",
  466. oldNullable: true);
  467. migrationBuilder.AlterColumn<string>(
  468. name: "ServerIP",
  469. table: "FileLogs",
  470. type: "nvarchar(max)",
  471. nullable: false,
  472. defaultValue: "",
  473. oldClrType: typeof(string),
  474. oldType: "nvarchar(max)",
  475. oldNullable: true);
  476. migrationBuilder.AlterColumn<string>(
  477. name: "QueryString",
  478. table: "FileLogs",
  479. type: "nvarchar(max)",
  480. nullable: false,
  481. defaultValue: "",
  482. oldClrType: typeof(string),
  483. oldType: "nvarchar(max)",
  484. oldNullable: true);
  485. migrationBuilder.AlterColumn<string>(
  486. name: "Input",
  487. table: "FileLogs",
  488. type: "nvarchar(max)",
  489. nullable: false,
  490. defaultValue: "",
  491. oldClrType: typeof(string),
  492. oldType: "nvarchar(max)",
  493. oldNullable: true);
  494. migrationBuilder.AlterColumn<string>(
  495. name: "InnerException",
  496. table: "FileLogs",
  497. type: "nvarchar(max)",
  498. nullable: false,
  499. defaultValue: "",
  500. oldClrType: typeof(string),
  501. oldType: "nvarchar(max)",
  502. oldNullable: true);
  503. migrationBuilder.AlterColumn<string>(
  504. name: "Channel",
  505. table: "FileLogs",
  506. type: "nvarchar(max)",
  507. nullable: false,
  508. defaultValue: "",
  509. oldClrType: typeof(string),
  510. oldType: "nvarchar(max)",
  511. oldNullable: true);
  512. migrationBuilder.AlterColumn<string>(
  513. name: "userAgent",
  514. table: "AuthLogs",
  515. type: "nvarchar(max)",
  516. nullable: false,
  517. defaultValue: "",
  518. oldClrType: typeof(string),
  519. oldType: "nvarchar(max)",
  520. oldNullable: true);
  521. migrationBuilder.AlterColumn<string>(
  522. name: "UserIP",
  523. table: "AuthLogs",
  524. type: "nvarchar(max)",
  525. nullable: false,
  526. defaultValue: "",
  527. oldClrType: typeof(string),
  528. oldType: "nvarchar(max)",
  529. oldNullable: true);
  530. migrationBuilder.AlterColumn<string>(
  531. name: "ServerIP",
  532. table: "AuthLogs",
  533. type: "nvarchar(max)",
  534. nullable: false,
  535. defaultValue: "",
  536. oldClrType: typeof(string),
  537. oldType: "nvarchar(max)",
  538. oldNullable: true);
  539. migrationBuilder.AlterColumn<string>(
  540. name: "QueryString",
  541. table: "AuthLogs",
  542. type: "nvarchar(max)",
  543. nullable: false,
  544. defaultValue: "",
  545. oldClrType: typeof(string),
  546. oldType: "nvarchar(max)",
  547. oldNullable: true);
  548. migrationBuilder.AlterColumn<string>(
  549. name: "Input",
  550. table: "AuthLogs",
  551. type: "nvarchar(max)",
  552. nullable: false,
  553. defaultValue: "",
  554. oldClrType: typeof(string),
  555. oldType: "nvarchar(max)",
  556. oldNullable: true);
  557. migrationBuilder.AlterColumn<string>(
  558. name: "InnerException",
  559. table: "AuthLogs",
  560. type: "nvarchar(max)",
  561. nullable: false,
  562. defaultValue: "",
  563. oldClrType: typeof(string),
  564. oldType: "nvarchar(max)",
  565. oldNullable: true);
  566. migrationBuilder.AlterColumn<string>(
  567. name: "Channel",
  568. table: "AuthLogs",
  569. type: "nvarchar(max)",
  570. nullable: false,
  571. defaultValue: "",
  572. oldClrType: typeof(string),
  573. oldType: "nvarchar(max)",
  574. oldNullable: true);
  575. }
  576. }
  577. }