WebCMSEntities.cs 62 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639
  1. using System;
  2. using Microsoft.EntityFrameworkCore;
  3. using Microsoft.EntityFrameworkCore.Metadata;
  4. namespace MySystem.BsModels
  5. {
  6. public partial class WebCMSEntities : DbContext
  7. {
  8. public WebCMSEntities()
  9. {
  10. }
  11. public WebCMSEntities(DbContextOptions<WebCMSEntities> options)
  12. : base(options)
  13. {
  14. }
  15. public virtual DbSet<Advertisment> Advertisment { get; set; }
  16. public virtual DbSet<Col> Col { get; set; }
  17. public virtual DbSet<MenuRight> MenuRight { get; set; }
  18. public virtual DbSet<MsgBlackList> MsgBlackList { get; set; }
  19. public virtual DbSet<MsgPersonal> MsgPersonal { get; set; }
  20. public virtual DbSet<MsgPlacard> MsgPlacard { get; set; }
  21. public virtual DbSet<MsgPlacardRead> MsgPlacardRead { get; set; }
  22. public virtual DbSet<MsgPush> MsgPush { get; set; }
  23. public virtual DbSet<MsgSms> MsgSms { get; set; }
  24. public virtual DbSet<MsgSmsSet> MsgSmsSet { get; set; }
  25. public virtual DbSet<MsgTemplate> MsgTemplate { get; set; }
  26. public virtual DbSet<OperateLog> OperateLog { get; set; }
  27. public virtual DbSet<OperateRightList> OperateRightList { get; set; }
  28. public virtual DbSet<PageInfo> PageInfo { get; set; }
  29. public virtual DbSet<PublicAccountSet> PublicAccountSet { get; set; }
  30. public virtual DbSet<RefreshTokens> RefreshTokens { get; set; }
  31. public virtual DbSet<RightDic> RightDic { get; set; }
  32. public virtual DbSet<SysAdmin> SysAdmin { get; set; }
  33. public virtual DbSet<SysAdminRole> SysAdminRole { get; set; }
  34. public virtual DbSet<SysLog> SysLog { get; set; }
  35. public virtual DbSet<SystemSet> SystemSet { get; set; }
  36. public virtual DbSet<UploadParams> UploadParams { get; set; }
  37. protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
  38. {
  39. if (!optionsBuilder.IsConfigured)
  40. {
  41. optionsBuilder.UseMySql(Library.ConfigurationManager.AppSettings["BsSqlConnStr"].ToString(), x => x.ServerVersion("5.7.17-mysql"));
  42. }
  43. }
  44. protected override void OnModelCreating(ModelBuilder modelBuilder)
  45. {
  46. modelBuilder.Entity<Advertisment>(entity =>
  47. {
  48. entity.Property(e => e.Id).HasColumnType("int(11)");
  49. entity.Property(e => e.ColId)
  50. .HasColumnType("varchar(30)")
  51. .HasCharSet("utf8")
  52. .HasCollation("utf8_general_ci");
  53. entity.Property(e => e.Contents)
  54. .HasColumnType("longtext")
  55. .HasCharSet("utf8")
  56. .HasCollation("utf8_general_ci");
  57. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  58. entity.Property(e => e.CreateMan)
  59. .HasColumnType("varchar(50)")
  60. .HasCharSet("utf8")
  61. .HasCollation("utf8_general_ci");
  62. entity.Property(e => e.PicPath)
  63. .HasColumnType("varchar(200)")
  64. .HasCharSet("utf8")
  65. .HasCollation("utf8_general_ci");
  66. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  67. entity.Property(e => e.SeoDescription)
  68. .HasColumnType("varchar(500)")
  69. .HasCharSet("utf8")
  70. .HasCollation("utf8_general_ci");
  71. entity.Property(e => e.SeoKeyword)
  72. .HasColumnType("varchar(200)")
  73. .HasCharSet("utf8")
  74. .HasCollation("utf8_general_ci");
  75. entity.Property(e => e.SeoTitle)
  76. .HasColumnType("varchar(100)")
  77. .HasCharSet("utf8")
  78. .HasCollation("utf8_general_ci");
  79. entity.Property(e => e.Sort).HasColumnType("int(11)");
  80. entity.Property(e => e.Status).HasColumnType("int(11)");
  81. entity.Property(e => e.Title)
  82. .HasColumnType("varchar(50)")
  83. .HasCharSet("utf8")
  84. .HasCollation("utf8_general_ci");
  85. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  86. entity.Property(e => e.UpdateMan)
  87. .HasColumnType("varchar(50)")
  88. .HasCharSet("utf8")
  89. .HasCollation("utf8_general_ci");
  90. entity.Property(e => e.Url)
  91. .HasColumnType("longtext")
  92. .HasCharSet("utf8")
  93. .HasCollation("utf8_general_ci");
  94. entity.Property(e => e.Version).HasColumnType("int(11)");
  95. });
  96. modelBuilder.Entity<Col>(entity =>
  97. {
  98. entity.Property(e => e.Id).HasColumnType("int(11)");
  99. entity.Property(e => e.ColDetail)
  100. .HasColumnType("varchar(50)")
  101. .HasCharSet("utf8")
  102. .HasCollation("utf8_general_ci");
  103. entity.Property(e => e.ColEnName)
  104. .HasColumnType("varchar(50)")
  105. .HasCharSet("utf8")
  106. .HasCollation("utf8_general_ci");
  107. entity.Property(e => e.ColId)
  108. .HasColumnType("varchar(30)")
  109. .HasCharSet("utf8")
  110. .HasCollation("utf8_general_ci");
  111. entity.Property(e => e.ColName)
  112. .HasColumnType("varchar(50)")
  113. .HasCharSet("utf8")
  114. .HasCollation("utf8_general_ci");
  115. entity.Property(e => e.ColPicPath)
  116. .HasColumnType("varchar(200)")
  117. .HasCharSet("utf8")
  118. .HasCollation("utf8_general_ci");
  119. entity.Property(e => e.Contents)
  120. .HasColumnType("longtext")
  121. .HasCharSet("utf8")
  122. .HasCollation("utf8_general_ci");
  123. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  124. entity.Property(e => e.CreateMan)
  125. .HasColumnType("varchar(50)")
  126. .HasCharSet("utf8")
  127. .HasCollation("utf8_general_ci");
  128. entity.Property(e => e.ParentId).HasColumnType("int(11)");
  129. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  130. entity.Property(e => e.Recommend)
  131. .HasColumnType("bit(1)")
  132. .HasDefaultValueSql("b'0'");
  133. entity.Property(e => e.SeoDescription)
  134. .HasColumnType("varchar(500)")
  135. .HasCharSet("utf8")
  136. .HasCollation("utf8_general_ci");
  137. entity.Property(e => e.SeoKeyword)
  138. .HasColumnType("varchar(200)")
  139. .HasCharSet("utf8")
  140. .HasCollation("utf8_general_ci");
  141. entity.Property(e => e.SeoTitle)
  142. .HasColumnType("varchar(100)")
  143. .HasCharSet("utf8")
  144. .HasCollation("utf8_general_ci");
  145. entity.Property(e => e.Sort).HasColumnType("int(11)");
  146. entity.Property(e => e.Status).HasColumnType("int(11)");
  147. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  148. entity.Property(e => e.UpdateMan)
  149. .HasColumnType("varchar(50)")
  150. .HasCharSet("utf8")
  151. .HasCollation("utf8_general_ci");
  152. entity.Property(e => e.Url)
  153. .HasColumnType("longtext")
  154. .HasCharSet("utf8")
  155. .HasCollation("utf8_general_ci");
  156. entity.Property(e => e.Version).HasColumnType("int(11)");
  157. });
  158. modelBuilder.Entity<MenuRight>(entity =>
  159. {
  160. entity.HasKey(e => e.MenuId)
  161. .HasName("PRIMARY");
  162. entity.Property(e => e.MenuId)
  163. .HasColumnType("varchar(50)")
  164. .HasCharSet("utf8")
  165. .HasCollation("utf8_general_ci");
  166. entity.Property(e => e.Name)
  167. .HasColumnType("varchar(50)")
  168. .HasCharSet("utf8")
  169. .HasCollation("utf8_general_ci");
  170. });
  171. modelBuilder.Entity<MsgBlackList>(entity =>
  172. {
  173. entity.Property(e => e.Id).HasColumnType("int(11)");
  174. entity.Property(e => e.ColId)
  175. .HasColumnType("varchar(30)")
  176. .HasCharSet("utf8")
  177. .HasCollation("utf8_general_ci");
  178. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  179. entity.Property(e => e.CreateMan)
  180. .HasColumnType("varchar(50)")
  181. .HasCharSet("utf8")
  182. .HasCollation("utf8_general_ci");
  183. entity.Property(e => e.Extend)
  184. .HasColumnType("varchar(2000)")
  185. .HasCharSet("utf8")
  186. .HasCollation("utf8_general_ci");
  187. entity.Property(e => e.Ip)
  188. .HasColumnType("varchar(64)")
  189. .HasCharSet("utf8")
  190. .HasCollation("utf8_general_ci");
  191. entity.Property(e => e.Mobile)
  192. .HasColumnType("varchar(11)")
  193. .HasCharSet("utf8")
  194. .HasCollation("utf8_general_ci");
  195. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  196. entity.Property(e => e.Reason)
  197. .HasColumnType("varchar(512)")
  198. .HasCharSet("utf8")
  199. .HasCollation("utf8_general_ci");
  200. entity.Property(e => e.Remark)
  201. .HasColumnType("varchar(64)")
  202. .HasCharSet("utf8")
  203. .HasCollation("utf8_general_ci");
  204. entity.Property(e => e.SeoDescription)
  205. .HasColumnType("varchar(500)")
  206. .HasCharSet("utf8")
  207. .HasCollation("utf8_general_ci");
  208. entity.Property(e => e.SeoKeyword)
  209. .HasColumnType("varchar(200)")
  210. .HasCharSet("utf8")
  211. .HasCollation("utf8_general_ci");
  212. entity.Property(e => e.SeoTitle)
  213. .HasColumnType("varchar(100)")
  214. .HasCharSet("utf8")
  215. .HasCollation("utf8_general_ci");
  216. entity.Property(e => e.Sort).HasColumnType("int(11)");
  217. entity.Property(e => e.Status).HasColumnType("int(11)");
  218. entity.Property(e => e.TemplateId).HasColumnType("int(11)");
  219. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  220. entity.Property(e => e.UpdateMan)
  221. .HasColumnType("varchar(50)")
  222. .HasCharSet("utf8")
  223. .HasCollation("utf8_general_ci");
  224. entity.Property(e => e.Version).HasColumnType("int(11)");
  225. });
  226. modelBuilder.Entity<MsgPersonal>(entity =>
  227. {
  228. entity.Property(e => e.Id).HasColumnType("int(11)");
  229. entity.Property(e => e.BgPic)
  230. .HasColumnType("varchar(200)")
  231. .HasCharSet("utf8")
  232. .HasCollation("utf8_general_ci");
  233. entity.Property(e => e.Content)
  234. .HasColumnType("longtext")
  235. .HasCharSet("utf8")
  236. .HasCollation("utf8_general_ci");
  237. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  238. entity.Property(e => e.CreateMan)
  239. .HasColumnType("varchar(50)")
  240. .HasCharSet("utf8")
  241. .HasCollation("utf8_general_ci");
  242. entity.Property(e => e.ExtendColumn)
  243. .HasColumnType("mediumtext")
  244. .HasCharSet("utf8")
  245. .HasCollation("utf8_general_ci");
  246. entity.Property(e => e.MsgType).HasColumnType("int(11)");
  247. entity.Property(e => e.PushFlag).HasColumnType("int(11)");
  248. entity.Property(e => e.PushParam)
  249. .HasColumnType("varchar(255)")
  250. .HasCharSet("utf8")
  251. .HasCollation("utf8_general_ci");
  252. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  253. entity.Property(e => e.ReadFlag)
  254. .HasColumnType("bit(1)")
  255. .HasDefaultValueSql("b'0'");
  256. entity.Property(e => e.Remark)
  257. .HasColumnType("varchar(255)")
  258. .HasCharSet("utf8")
  259. .HasCollation("utf8_general_ci");
  260. entity.Property(e => e.SeoDescription)
  261. .HasColumnType("varchar(500)")
  262. .HasCharSet("utf8")
  263. .HasCollation("utf8_general_ci");
  264. entity.Property(e => e.SeoKeyword)
  265. .HasColumnType("varchar(200)")
  266. .HasCharSet("utf8")
  267. .HasCollation("utf8_general_ci");
  268. entity.Property(e => e.SeoTitle)
  269. .HasColumnType("varchar(100)")
  270. .HasCharSet("utf8")
  271. .HasCollation("utf8_general_ci");
  272. entity.Property(e => e.Sort).HasColumnType("int(11)");
  273. entity.Property(e => e.Status).HasColumnType("int(11)");
  274. entity.Property(e => e.Summary)
  275. .HasColumnType("varchar(500)")
  276. .HasCharSet("utf8")
  277. .HasCollation("utf8_general_ci");
  278. entity.Property(e => e.TemplateId).HasColumnType("int(11)");
  279. entity.Property(e => e.Title)
  280. .HasColumnType("varchar(50)")
  281. .HasCharSet("utf8")
  282. .HasCollation("utf8_general_ci");
  283. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  284. entity.Property(e => e.UpdateMan)
  285. .HasColumnType("varchar(50)")
  286. .HasCharSet("utf8")
  287. .HasCollation("utf8_general_ci");
  288. entity.Property(e => e.Url)
  289. .HasColumnType("varchar(500)")
  290. .HasCharSet("utf8")
  291. .HasCollation("utf8_general_ci");
  292. entity.Property(e => e.UserId).HasColumnType("int(11)");
  293. entity.Property(e => e.Version).HasColumnType("int(11)");
  294. });
  295. modelBuilder.Entity<MsgPlacard>(entity =>
  296. {
  297. entity.Property(e => e.Id).HasColumnType("int(11)");
  298. entity.Property(e => e.BgPic)
  299. .HasColumnType("varchar(200)")
  300. .HasCharSet("utf8")
  301. .HasCollation("utf8_general_ci");
  302. entity.Property(e => e.Content)
  303. .HasColumnType("longtext")
  304. .HasCharSet("utf8")
  305. .HasCollation("utf8_general_ci");
  306. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  307. entity.Property(e => e.CreateMan)
  308. .HasColumnType("varchar(50)")
  309. .HasCharSet("utf8")
  310. .HasCollation("utf8_general_ci");
  311. entity.Property(e => e.EffectEndDate).HasColumnType("datetime");
  312. entity.Property(e => e.EffectStartDate).HasColumnType("datetime");
  313. entity.Property(e => e.ExtendColumn)
  314. .HasColumnType("mediumtext")
  315. .HasCharSet("utf8")
  316. .HasCollation("utf8_general_ci");
  317. entity.Property(e => e.IsTop)
  318. .HasColumnType("bit(1)")
  319. .HasDefaultValueSql("b'0'");
  320. entity.Property(e => e.MsgType).HasColumnType("int(11)");
  321. entity.Property(e => e.PushFlag).HasColumnType("int(11)");
  322. entity.Property(e => e.PushParam)
  323. .HasColumnType("varchar(255)")
  324. .HasCharSet("utf8")
  325. .HasCollation("utf8_general_ci");
  326. entity.Property(e => e.PushTime).HasColumnType("datetime");
  327. entity.Property(e => e.PushType).HasColumnType("int(11)");
  328. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  329. entity.Property(e => e.Remark)
  330. .HasColumnType("varchar(255)")
  331. .HasCharSet("utf8")
  332. .HasCollation("utf8_general_ci");
  333. entity.Property(e => e.SeoDescription)
  334. .HasColumnType("varchar(500)")
  335. .HasCharSet("utf8")
  336. .HasCollation("utf8_general_ci");
  337. entity.Property(e => e.SeoKeyword)
  338. .HasColumnType("varchar(200)")
  339. .HasCharSet("utf8")
  340. .HasCollation("utf8_general_ci");
  341. entity.Property(e => e.SeoTitle)
  342. .HasColumnType("varchar(100)")
  343. .HasCharSet("utf8")
  344. .HasCollation("utf8_general_ci");
  345. entity.Property(e => e.ShowType).HasColumnType("int(11)");
  346. entity.Property(e => e.Sort).HasColumnType("int(11)");
  347. entity.Property(e => e.Status).HasColumnType("int(11)");
  348. entity.Property(e => e.Summary)
  349. .HasColumnType("varchar(500)")
  350. .HasCharSet("utf8")
  351. .HasCollation("utf8_general_ci");
  352. entity.Property(e => e.Title)
  353. .HasColumnType("varchar(50)")
  354. .HasCharSet("utf8")
  355. .HasCollation("utf8_general_ci");
  356. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  357. entity.Property(e => e.UpdateMan)
  358. .HasColumnType("varchar(50)")
  359. .HasCharSet("utf8")
  360. .HasCollation("utf8_general_ci");
  361. entity.Property(e => e.Url)
  362. .HasColumnType("varchar(500)")
  363. .HasCharSet("utf8")
  364. .HasCollation("utf8_general_ci");
  365. entity.Property(e => e.Version).HasColumnType("int(11)");
  366. });
  367. modelBuilder.Entity<MsgPlacardRead>(entity =>
  368. {
  369. entity.Property(e => e.Id).HasColumnType("int(11)");
  370. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  371. entity.Property(e => e.CreateMan)
  372. .HasColumnType("varchar(50)")
  373. .HasCharSet("utf8")
  374. .HasCollation("utf8_general_ci");
  375. entity.Property(e => e.PlacardId).HasColumnType("int(11)");
  376. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  377. entity.Property(e => e.ReadFlag)
  378. .HasColumnType("bit(1)")
  379. .HasDefaultValueSql("b'0'");
  380. entity.Property(e => e.Remark)
  381. .HasColumnType("varchar(255)")
  382. .HasCharSet("utf8")
  383. .HasCollation("utf8_general_ci");
  384. entity.Property(e => e.SeoDescription)
  385. .HasColumnType("varchar(500)")
  386. .HasCharSet("utf8")
  387. .HasCollation("utf8_general_ci");
  388. entity.Property(e => e.SeoKeyword)
  389. .HasColumnType("varchar(200)")
  390. .HasCharSet("utf8")
  391. .HasCollation("utf8_general_ci");
  392. entity.Property(e => e.SeoTitle)
  393. .HasColumnType("varchar(100)")
  394. .HasCharSet("utf8")
  395. .HasCollation("utf8_general_ci");
  396. entity.Property(e => e.Sort).HasColumnType("int(11)");
  397. entity.Property(e => e.Status).HasColumnType("int(11)");
  398. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  399. entity.Property(e => e.UpdateMan)
  400. .HasColumnType("varchar(50)")
  401. .HasCharSet("utf8")
  402. .HasCollation("utf8_general_ci");
  403. entity.Property(e => e.UserId)
  404. .HasColumnType("varchar(64)")
  405. .HasCharSet("utf8")
  406. .HasCollation("utf8_general_ci");
  407. entity.Property(e => e.Version).HasColumnType("int(11)");
  408. });
  409. modelBuilder.Entity<MsgPush>(entity =>
  410. {
  411. entity.Property(e => e.Id).HasColumnType("int(11)");
  412. entity.Property(e => e.AutoPushDate).HasColumnType("datetime");
  413. entity.Property(e => e.ClientType)
  414. .HasColumnType("varchar(20)")
  415. .HasCharSet("utf8")
  416. .HasCollation("utf8_general_ci");
  417. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  418. entity.Property(e => e.CreateMan)
  419. .HasColumnType("varchar(50)")
  420. .HasCharSet("utf8")
  421. .HasCollation("utf8_general_ci");
  422. entity.Property(e => e.Details)
  423. .HasColumnType("varchar(200)")
  424. .HasCharSet("utf8")
  425. .HasCollation("utf8_general_ci");
  426. entity.Property(e => e.Devices)
  427. .HasColumnType("mediumtext")
  428. .HasCharSet("utf8")
  429. .HasCollation("utf8_general_ci");
  430. entity.Property(e => e.IsSilent)
  431. .HasColumnType("bit(1)")
  432. .HasDefaultValueSql("b'0'");
  433. entity.Property(e => e.MessageId)
  434. .HasColumnType("varchar(50)")
  435. .HasCharSet("utf8")
  436. .HasCollation("utf8_general_ci");
  437. entity.Property(e => e.Mobiles)
  438. .HasColumnType("mediumtext")
  439. .HasCharSet("utf8")
  440. .HasCollation("utf8_general_ci");
  441. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  442. entity.Property(e => e.SeoDescription)
  443. .HasColumnType("varchar(500)")
  444. .HasCharSet("utf8")
  445. .HasCollation("utf8_general_ci");
  446. entity.Property(e => e.SeoKeyword)
  447. .HasColumnType("varchar(200)")
  448. .HasCharSet("utf8")
  449. .HasCollation("utf8_general_ci");
  450. entity.Property(e => e.SeoTitle)
  451. .HasColumnType("varchar(100)")
  452. .HasCharSet("utf8")
  453. .HasCollation("utf8_general_ci");
  454. entity.Property(e => e.Sort).HasColumnType("int(11)");
  455. entity.Property(e => e.Status).HasColumnType("int(11)");
  456. entity.Property(e => e.TemplateId).HasColumnType("int(11)");
  457. entity.Property(e => e.Title)
  458. .HasColumnType("varchar(50)")
  459. .HasCharSet("utf8")
  460. .HasCollation("utf8_general_ci");
  461. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  462. entity.Property(e => e.UpdateMan)
  463. .HasColumnType("varchar(50)")
  464. .HasCharSet("utf8")
  465. .HasCollation("utf8_general_ci");
  466. entity.Property(e => e.Url)
  467. .HasColumnType("varchar(500)")
  468. .HasCharSet("utf8")
  469. .HasCollation("utf8_general_ci");
  470. entity.Property(e => e.Version).HasColumnType("int(11)");
  471. });
  472. modelBuilder.Entity<MsgSms>(entity =>
  473. {
  474. entity.Property(e => e.Id).HasColumnType("int(11)");
  475. entity.Property(e => e.Code).HasColumnType("int(11)");
  476. entity.Property(e => e.ColId)
  477. .HasColumnType("varchar(30)")
  478. .HasCharSet("utf8")
  479. .HasCollation("utf8_general_ci");
  480. entity.Property(e => e.Content)
  481. .HasColumnType("varchar(200)")
  482. .HasCharSet("utf8")
  483. .HasCollation("utf8_general_ci");
  484. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  485. entity.Property(e => e.CreateMan)
  486. .HasColumnType("varchar(50)")
  487. .HasCharSet("utf8")
  488. .HasCollation("utf8_general_ci");
  489. entity.Property(e => e.ErrorNum).HasColumnType("int(11)");
  490. entity.Property(e => e.Ip)
  491. .HasColumnType("varchar(15)")
  492. .HasCharSet("utf8")
  493. .HasCollation("utf8_general_ci");
  494. entity.Property(e => e.Kind)
  495. .HasColumnType("varchar(64)")
  496. .HasCharSet("utf8")
  497. .HasCollation("utf8_general_ci");
  498. entity.Property(e => e.Mobile)
  499. .HasColumnType("varchar(11)")
  500. .HasCharSet("utf8")
  501. .HasCollation("utf8_general_ci");
  502. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  503. entity.Property(e => e.RespCode)
  504. .HasColumnType("varchar(16)")
  505. .HasCharSet("utf8")
  506. .HasCollation("utf8_general_ci");
  507. entity.Property(e => e.RespContent)
  508. .HasColumnType("varchar(500)")
  509. .HasCharSet("utf8")
  510. .HasCollation("utf8_general_ci");
  511. entity.Property(e => e.SendStatus).HasColumnType("int(11)");
  512. entity.Property(e => e.SendTime).HasColumnType("datetime");
  513. entity.Property(e => e.SendType).HasColumnType("int(11)");
  514. entity.Property(e => e.SeoDescription)
  515. .HasColumnType("varchar(500)")
  516. .HasCharSet("utf8")
  517. .HasCollation("utf8_general_ci");
  518. entity.Property(e => e.SeoKeyword)
  519. .HasColumnType("varchar(200)")
  520. .HasCharSet("utf8")
  521. .HasCollation("utf8_general_ci");
  522. entity.Property(e => e.SeoTitle)
  523. .HasColumnType("varchar(100)")
  524. .HasCharSet("utf8")
  525. .HasCollation("utf8_general_ci");
  526. entity.Property(e => e.SignName)
  527. .HasColumnType("varchar(10)")
  528. .HasCharSet("utf8")
  529. .HasCollation("utf8_general_ci");
  530. entity.Property(e => e.SmsType).HasColumnType("int(11)");
  531. entity.Property(e => e.Sort).HasColumnType("int(11)");
  532. entity.Property(e => e.Status).HasColumnType("int(11)");
  533. entity.Property(e => e.TemplateId).HasColumnType("int(11)");
  534. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  535. entity.Property(e => e.UpdateMan)
  536. .HasColumnType("varchar(50)")
  537. .HasCharSet("utf8")
  538. .HasCollation("utf8_general_ci");
  539. entity.Property(e => e.VerifyCode)
  540. .HasColumnType("varchar(6)")
  541. .HasCharSet("utf8")
  542. .HasCollation("utf8_general_ci");
  543. entity.Property(e => e.VerifyStatus).HasColumnType("int(11)");
  544. entity.Property(e => e.Version).HasColumnType("int(11)");
  545. });
  546. modelBuilder.Entity<MsgSmsSet>(entity =>
  547. {
  548. entity.Property(e => e.Id).HasColumnType("int(11)");
  549. entity.Property(e => e.AuthPwd)
  550. .HasColumnType("varchar(50)")
  551. .HasCharSet("utf8")
  552. .HasCollation("utf8_general_ci");
  553. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  554. entity.Property(e => e.CreateMan)
  555. .HasColumnType("varchar(50)")
  556. .HasCharSet("utf8")
  557. .HasCollation("utf8_general_ci");
  558. entity.Property(e => e.Name)
  559. .HasColumnType("varchar(50)")
  560. .HasCharSet("utf8")
  561. .HasCollation("utf8_general_ci");
  562. entity.Property(e => e.Params)
  563. .HasColumnType("varchar(200)")
  564. .HasCharSet("utf8")
  565. .HasCollation("utf8_general_ci");
  566. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  567. entity.Property(e => e.ReqUrl)
  568. .HasColumnType("varchar(200)")
  569. .HasCharSet("utf8")
  570. .HasCollation("utf8_general_ci");
  571. entity.Property(e => e.SeoDescription)
  572. .HasColumnType("varchar(500)")
  573. .HasCharSet("utf8")
  574. .HasCollation("utf8_general_ci");
  575. entity.Property(e => e.SeoKeyword)
  576. .HasColumnType("varchar(200)")
  577. .HasCharSet("utf8")
  578. .HasCollation("utf8_general_ci");
  579. entity.Property(e => e.SeoTitle)
  580. .HasColumnType("varchar(100)")
  581. .HasCharSet("utf8")
  582. .HasCollation("utf8_general_ci");
  583. entity.Property(e => e.SmsType).HasColumnType("int(11)");
  584. entity.Property(e => e.Sort).HasColumnType("int(11)");
  585. entity.Property(e => e.Status).HasColumnType("int(11)");
  586. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  587. entity.Property(e => e.UpdateMan)
  588. .HasColumnType("varchar(50)")
  589. .HasCharSet("utf8")
  590. .HasCollation("utf8_general_ci");
  591. entity.Property(e => e.UserName)
  592. .HasColumnType("varchar(50)")
  593. .HasCharSet("utf8")
  594. .HasCollation("utf8_general_ci");
  595. entity.Property(e => e.Version).HasColumnType("int(11)");
  596. });
  597. modelBuilder.Entity<MsgTemplate>(entity =>
  598. {
  599. entity.Property(e => e.Id).HasColumnType("int(11)");
  600. entity.Property(e => e.ColId)
  601. .HasColumnType("varchar(30)")
  602. .HasCharSet("utf8")
  603. .HasCollation("utf8_general_ci");
  604. entity.Property(e => e.Content)
  605. .HasColumnType("varchar(200)")
  606. .HasCharSet("utf8")
  607. .HasCollation("utf8_general_ci");
  608. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  609. entity.Property(e => e.CreateMan)
  610. .HasColumnType("varchar(50)")
  611. .HasCharSet("utf8")
  612. .HasCollation("utf8_general_ci");
  613. entity.Property(e => e.Extend)
  614. .HasColumnType("varchar(2000)")
  615. .HasCharSet("utf8")
  616. .HasCollation("utf8_general_ci");
  617. entity.Property(e => e.MsgType).HasColumnType("int(11)");
  618. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  619. entity.Property(e => e.Remark)
  620. .HasColumnType("varchar(64)")
  621. .HasCharSet("utf8")
  622. .HasCollation("utf8_general_ci");
  623. entity.Property(e => e.SeoDescription)
  624. .HasColumnType("varchar(500)")
  625. .HasCharSet("utf8")
  626. .HasCollation("utf8_general_ci");
  627. entity.Property(e => e.SeoKeyword)
  628. .HasColumnType("varchar(200)")
  629. .HasCharSet("utf8")
  630. .HasCollation("utf8_general_ci");
  631. entity.Property(e => e.SeoTitle)
  632. .HasColumnType("varchar(100)")
  633. .HasCharSet("utf8")
  634. .HasCollation("utf8_general_ci");
  635. entity.Property(e => e.SignName)
  636. .HasColumnType("varchar(10)")
  637. .HasCharSet("utf8")
  638. .HasCollation("utf8_general_ci");
  639. entity.Property(e => e.Sort).HasColumnType("int(11)");
  640. entity.Property(e => e.Status).HasColumnType("int(11)");
  641. entity.Property(e => e.TemplateType).HasColumnType("int(11)");
  642. entity.Property(e => e.Title)
  643. .HasColumnType("varchar(50)")
  644. .HasCharSet("utf8")
  645. .HasCollation("utf8_general_ci");
  646. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  647. entity.Property(e => e.UpdateMan)
  648. .HasColumnType("varchar(50)")
  649. .HasCharSet("utf8")
  650. .HasCollation("utf8_general_ci");
  651. entity.Property(e => e.Version).HasColumnType("int(11)");
  652. });
  653. modelBuilder.Entity<OperateLog>(entity =>
  654. {
  655. entity.Property(e => e.Id).HasColumnType("int(11)");
  656. entity.Property(e => e.AfterOperate)
  657. .HasColumnType("mediumtext")
  658. .HasCharSet("utf8")
  659. .HasCollation("utf8_general_ci");
  660. entity.Property(e => e.BeforeOperate)
  661. .HasColumnType("mediumtext")
  662. .HasCharSet("utf8")
  663. .HasCollation("utf8_general_ci");
  664. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  665. entity.Property(e => e.CreateMan)
  666. .HasColumnType("varchar(50)")
  667. .HasCharSet("utf8")
  668. .HasCollation("utf8_general_ci");
  669. entity.Property(e => e.OpMode)
  670. .HasColumnType("varchar(30)")
  671. .HasCharSet("utf8")
  672. .HasCollation("utf8_general_ci");
  673. entity.Property(e => e.OperateMan)
  674. .HasColumnType("varchar(50)")
  675. .HasCharSet("utf8")
  676. .HasCollation("utf8_general_ci");
  677. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  678. entity.Property(e => e.SeoDescription)
  679. .HasColumnType("varchar(500)")
  680. .HasCharSet("utf8")
  681. .HasCollation("utf8_general_ci");
  682. entity.Property(e => e.SeoKeyword)
  683. .HasColumnType("varchar(200)")
  684. .HasCharSet("utf8")
  685. .HasCollation("utf8_general_ci");
  686. entity.Property(e => e.SeoTitle)
  687. .HasColumnType("varchar(100)")
  688. .HasCharSet("utf8")
  689. .HasCollation("utf8_general_ci");
  690. entity.Property(e => e.Sort).HasColumnType("int(11)");
  691. entity.Property(e => e.Status).HasColumnType("int(11)");
  692. entity.Property(e => e.TableEnName)
  693. .HasColumnType("varchar(50)")
  694. .HasCharSet("utf8")
  695. .HasCollation("utf8_general_ci");
  696. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  697. entity.Property(e => e.UpdateMan)
  698. .HasColumnType("varchar(50)")
  699. .HasCharSet("utf8")
  700. .HasCollation("utf8_general_ci");
  701. entity.Property(e => e.Version).HasColumnType("int(11)");
  702. });
  703. modelBuilder.Entity<OperateRightList>(entity =>
  704. {
  705. entity.Property(e => e.Id).HasColumnType("int(11)");
  706. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  707. entity.Property(e => e.CreateMan)
  708. .HasColumnType("varchar(50)")
  709. .HasCharSet("utf8")
  710. .HasCollation("utf8_general_ci");
  711. entity.Property(e => e.EnName)
  712. .HasColumnType("varchar(50)")
  713. .HasCharSet("utf8")
  714. .HasCollation("utf8_general_ci");
  715. entity.Property(e => e.Name)
  716. .HasColumnType("varchar(50)")
  717. .HasCharSet("utf8")
  718. .HasCollation("utf8_general_ci");
  719. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  720. entity.Property(e => e.SeoDescription)
  721. .HasColumnType("varchar(500)")
  722. .HasCharSet("utf8")
  723. .HasCollation("utf8_general_ci");
  724. entity.Property(e => e.SeoKeyword)
  725. .HasColumnType("varchar(200)")
  726. .HasCharSet("utf8")
  727. .HasCollation("utf8_general_ci");
  728. entity.Property(e => e.SeoTitle)
  729. .HasColumnType("varchar(100)")
  730. .HasCharSet("utf8")
  731. .HasCollation("utf8_general_ci");
  732. entity.Property(e => e.Sort).HasColumnType("int(11)");
  733. entity.Property(e => e.Status).HasColumnType("int(11)");
  734. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  735. entity.Property(e => e.UpdateMan)
  736. .HasColumnType("varchar(50)")
  737. .HasCharSet("utf8")
  738. .HasCollation("utf8_general_ci");
  739. entity.Property(e => e.Version).HasColumnType("int(11)");
  740. });
  741. modelBuilder.Entity<PageInfo>(entity =>
  742. {
  743. entity.Property(e => e.Id).HasColumnType("int(11)");
  744. entity.Property(e => e.ColId)
  745. .HasColumnType("varchar(30)")
  746. .HasCharSet("utf8")
  747. .HasCollation("utf8_general_ci");
  748. entity.Property(e => e.Contents)
  749. .HasColumnType("longtext")
  750. .HasCharSet("utf8")
  751. .HasCollation("utf8_general_ci");
  752. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  753. entity.Property(e => e.CreateMan)
  754. .HasColumnType("varchar(50)")
  755. .HasCharSet("utf8")
  756. .HasCollation("utf8_general_ci");
  757. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  758. entity.Property(e => e.SeoDescription)
  759. .HasColumnType("varchar(500)")
  760. .HasCharSet("utf8")
  761. .HasCollation("utf8_general_ci");
  762. entity.Property(e => e.SeoKeyword)
  763. .HasColumnType("varchar(200)")
  764. .HasCharSet("utf8")
  765. .HasCollation("utf8_general_ci");
  766. entity.Property(e => e.SeoTitle)
  767. .HasColumnType("varchar(100)")
  768. .HasCharSet("utf8")
  769. .HasCollation("utf8_general_ci");
  770. entity.Property(e => e.Sort).HasColumnType("int(11)");
  771. entity.Property(e => e.Status).HasColumnType("int(11)");
  772. entity.Property(e => e.Title)
  773. .HasColumnType("varchar(200)")
  774. .HasCharSet("utf8")
  775. .HasCollation("utf8_general_ci");
  776. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  777. entity.Property(e => e.UpdateMan)
  778. .HasColumnType("varchar(50)")
  779. .HasCharSet("utf8")
  780. .HasCollation("utf8_general_ci");
  781. entity.Property(e => e.Version).HasColumnType("int(11)");
  782. });
  783. modelBuilder.Entity<PublicAccountSet>(entity =>
  784. {
  785. entity.Property(e => e.Id).HasColumnType("int(11)");
  786. entity.Property(e => e.AlipayAppId)
  787. .HasColumnType("varchar(50)")
  788. .HasCharSet("utf8")
  789. .HasCollation("utf8_general_ci");
  790. entity.Property(e => e.AlipayPartnerId)
  791. .HasColumnType("varchar(50)")
  792. .HasCharSet("utf8")
  793. .HasCollation("utf8_general_ci");
  794. entity.Property(e => e.AlipayPrivateKey)
  795. .HasColumnType("mediumtext")
  796. .HasCharSet("utf8")
  797. .HasCollation("utf8_general_ci");
  798. entity.Property(e => e.AlipayPublicKey)
  799. .HasColumnType("mediumtext")
  800. .HasCharSet("utf8")
  801. .HasCollation("utf8_general_ci");
  802. entity.Property(e => e.AliyunAccessKeyId)
  803. .HasColumnType("varchar(50)")
  804. .HasCharSet("utf8")
  805. .HasCollation("utf8_general_ci");
  806. entity.Property(e => e.AliyunAccessKeySecret)
  807. .HasColumnType("varchar(50)")
  808. .HasCharSet("utf8")
  809. .HasCollation("utf8_general_ci");
  810. entity.Property(e => e.AliyunAndroidActivity)
  811. .HasColumnType("varchar(100)")
  812. .HasCharSet("utf8")
  813. .HasCollation("utf8_general_ci");
  814. entity.Property(e => e.AliyunAndroidNotifyTitle)
  815. .HasColumnType("varchar(20)")
  816. .HasCharSet("utf8")
  817. .HasCollation("utf8_general_ci");
  818. entity.Property(e => e.AliyunPushAndroidAppId)
  819. .HasColumnType("varchar(50)")
  820. .HasCharSet("utf8")
  821. .HasCollation("utf8_general_ci");
  822. entity.Property(e => e.AliyunPushAndroidAppSecret)
  823. .HasColumnType("varchar(50)")
  824. .HasCharSet("utf8")
  825. .HasCollation("utf8_general_ci");
  826. entity.Property(e => e.AliyunPushIosAppId)
  827. .HasColumnType("varchar(500)")
  828. .HasCharSet("utf8")
  829. .HasCollation("utf8_general_ci");
  830. entity.Property(e => e.AliyunPushIosAppSecret)
  831. .HasColumnType("varchar(50)")
  832. .HasCharSet("utf8")
  833. .HasCollation("utf8_general_ci");
  834. entity.Property(e => e.AliyunRegionId)
  835. .HasColumnType("varchar(30)")
  836. .HasCharSet("utf8")
  837. .HasCollation("utf8_general_ci");
  838. entity.Property(e => e.ErpApiUrl)
  839. .HasColumnType("varchar(200)")
  840. .HasCharSet("utf8")
  841. .HasCollation("utf8_general_ci");
  842. entity.Property(e => e.ErpAppCode)
  843. .HasColumnType("varchar(100)")
  844. .HasCharSet("utf8")
  845. .HasCollation("utf8_general_ci");
  846. entity.Property(e => e.MeiQiaAppKey)
  847. .HasColumnType("varchar(50)")
  848. .HasCharSet("utf8")
  849. .HasCollation("utf8_general_ci");
  850. entity.Property(e => e.MobAppKey)
  851. .HasColumnType("varchar(50)")
  852. .HasCharSet("utf8")
  853. .HasCollation("utf8_general_ci");
  854. entity.Property(e => e.MobAppSecret)
  855. .HasColumnType("varchar(50)")
  856. .HasCharSet("utf8")
  857. .HasCollation("utf8_general_ci");
  858. entity.Property(e => e.QqAndroidAppId)
  859. .HasColumnType("varchar(50)")
  860. .HasCharSet("utf8")
  861. .HasCollation("utf8_general_ci");
  862. entity.Property(e => e.QqAndroidAppKey)
  863. .HasColumnType("varchar(50)")
  864. .HasCharSet("utf8")
  865. .HasCollation("utf8_general_ci");
  866. entity.Property(e => e.QqIosAppId)
  867. .HasColumnType("varchar(50)")
  868. .HasCharSet("utf8")
  869. .HasCollation("utf8_general_ci");
  870. entity.Property(e => e.QqIosAppKey)
  871. .HasColumnType("varchar(50)")
  872. .HasCharSet("utf8")
  873. .HasCollation("utf8_general_ci");
  874. entity.Property(e => e.ServerIp)
  875. .HasColumnType("varchar(15)")
  876. .HasCharSet("utf8")
  877. .HasCollation("utf8_general_ci");
  878. entity.Property(e => e.SmsApiDefaultTemplate)
  879. .HasColumnType("varchar(200)")
  880. .HasCharSet("utf8")
  881. .HasCollation("utf8_general_ci");
  882. entity.Property(e => e.SmsApiPwd)
  883. .HasColumnType("varchar(50)")
  884. .HasCharSet("utf8")
  885. .HasCollation("utf8_general_ci");
  886. entity.Property(e => e.SmsApiSign)
  887. .HasColumnType("varchar(10)")
  888. .HasCharSet("utf8")
  889. .HasCollation("utf8_general_ci");
  890. entity.Property(e => e.SmsApiUserId)
  891. .HasColumnType("varchar(50)")
  892. .HasCharSet("utf8")
  893. .HasCollation("utf8_general_ci");
  894. entity.Property(e => e.WeChatAppId)
  895. .HasColumnType("varchar(50)")
  896. .HasCharSet("utf8")
  897. .HasCollation("utf8_general_ci");
  898. entity.Property(e => e.WeChatAppSecret)
  899. .HasColumnType("varchar(50)")
  900. .HasCharSet("utf8")
  901. .HasCollation("utf8_general_ci");
  902. entity.Property(e => e.WeChatMchId)
  903. .HasColumnType("varchar(20)")
  904. .HasCharSet("utf8")
  905. .HasCollation("utf8_general_ci");
  906. entity.Property(e => e.WeChatMiniAppId)
  907. .HasColumnType("varchar(50)")
  908. .HasCharSet("utf8")
  909. .HasCollation("utf8_general_ci");
  910. entity.Property(e => e.WeChatMiniAppSecret)
  911. .HasColumnType("varchar(50)")
  912. .HasCharSet("utf8")
  913. .HasCollation("utf8_general_ci");
  914. entity.Property(e => e.WeChatOpenAppId)
  915. .HasColumnType("varchar(50)")
  916. .HasCharSet("utf8")
  917. .HasCollation("utf8_general_ci");
  918. entity.Property(e => e.WeChatOpenAppSecret)
  919. .HasColumnType("varchar(50)")
  920. .HasCharSet("utf8")
  921. .HasCollation("utf8_general_ci");
  922. entity.Property(e => e.WeChatPayKey)
  923. .HasColumnType("varchar(50)")
  924. .HasCharSet("utf8")
  925. .HasCollation("utf8_general_ci");
  926. });
  927. modelBuilder.Entity<RefreshTokens>(entity =>
  928. {
  929. entity.HasKey(e => e.UserId)
  930. .HasName("PRIMARY");
  931. entity.Property(e => e.UserId).HasColumnType("int(11)");
  932. entity.Property(e => e.ExpiredDate).HasColumnType("datetime");
  933. entity.Property(e => e.RefreshToken)
  934. .HasColumnType("varchar(50)")
  935. .HasCharSet("utf8")
  936. .HasCollation("utf8_general_ci");
  937. });
  938. modelBuilder.Entity<RightDic>(entity =>
  939. {
  940. entity.Property(e => e.Id)
  941. .HasColumnName("ID")
  942. .HasColumnType("varchar(50)")
  943. .HasCharSet("utf8")
  944. .HasCollation("utf8_general_ci");
  945. entity.Property(e => e.Icon)
  946. .HasColumnType("varchar(50)")
  947. .HasCharSet("utf8")
  948. .HasCollation("utf8_general_ci");
  949. entity.Property(e => e.MainDataList)
  950. .HasColumnType("bit(1)")
  951. .HasDefaultValueSql("b'0'");
  952. entity.Property(e => e.MainMenu)
  953. .HasColumnType("bit(1)")
  954. .HasDefaultValueSql("b'0'");
  955. entity.Property(e => e.MainStat)
  956. .HasColumnType("bit(1)")
  957. .HasDefaultValueSql("b'0'");
  958. entity.Property(e => e.Name)
  959. .HasColumnType("varchar(50)")
  960. .HasCharSet("utf8")
  961. .HasCollation("utf8_general_ci");
  962. entity.Property(e => e.OtherRight)
  963. .HasColumnType("varchar(500)")
  964. .HasCharSet("utf8")
  965. .HasCollation("utf8_general_ci");
  966. entity.Property(e => e.Path)
  967. .HasColumnType("varchar(200)")
  968. .HasCharSet("utf8")
  969. .HasCollation("utf8_general_ci");
  970. entity.Property(e => e.RightLevel).HasColumnType("int(11)");
  971. entity.Property(e => e.Sort).HasColumnType("int(11)");
  972. entity.Property(e => e.Title)
  973. .HasColumnType("varchar(50)")
  974. .HasCharSet("utf8")
  975. .HasCollation("utf8_general_ci");
  976. entity.Property(e => e.Url)
  977. .HasColumnType("varchar(200)")
  978. .HasCharSet("utf8")
  979. .HasCollation("utf8_general_ci");
  980. });
  981. modelBuilder.Entity<SysAdmin>(entity =>
  982. {
  983. entity.Property(e => e.Id).HasColumnType("int(11)");
  984. entity.Property(e => e.AdminName)
  985. .HasColumnType("varchar(50)")
  986. .HasCharSet("utf8")
  987. .HasCollation("utf8_general_ci");
  988. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  989. entity.Property(e => e.CreateMan)
  990. .HasColumnType("varchar(50)")
  991. .HasCharSet("utf8")
  992. .HasCollation("utf8_general_ci");
  993. entity.Property(e => e.LastLoginDate).HasColumnType("datetime");
  994. entity.Property(e => e.Password)
  995. .HasColumnType("varchar(32)")
  996. .HasCharSet("utf8")
  997. .HasCollation("utf8_general_ci");
  998. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  999. entity.Property(e => e.RealName)
  1000. .HasColumnType("varchar(50)")
  1001. .HasCharSet("utf8")
  1002. .HasCollation("utf8_general_ci");
  1003. entity.Property(e => e.Role)
  1004. .HasColumnType("varchar(30)")
  1005. .HasCharSet("utf8")
  1006. .HasCollation("utf8_general_ci");
  1007. entity.Property(e => e.SeoDescription)
  1008. .HasColumnType("varchar(500)")
  1009. .HasCharSet("utf8")
  1010. .HasCollation("utf8_general_ci");
  1011. entity.Property(e => e.SeoKeyword)
  1012. .HasColumnType("varchar(200)")
  1013. .HasCharSet("utf8")
  1014. .HasCollation("utf8_general_ci");
  1015. entity.Property(e => e.SeoTitle)
  1016. .HasColumnType("varchar(100)")
  1017. .HasCharSet("utf8")
  1018. .HasCollation("utf8_general_ci");
  1019. entity.Property(e => e.Sort).HasColumnType("int(11)");
  1020. entity.Property(e => e.Status).HasColumnType("int(11)");
  1021. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  1022. entity.Property(e => e.UpdateMan)
  1023. .HasColumnType("varchar(50)")
  1024. .HasCharSet("utf8")
  1025. .HasCollation("utf8_general_ci");
  1026. entity.Property(e => e.Version).HasColumnType("int(11)");
  1027. });
  1028. modelBuilder.Entity<SysAdminRole>(entity =>
  1029. {
  1030. entity.Property(e => e.Id).HasColumnType("int(11)");
  1031. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  1032. entity.Property(e => e.CreateMan)
  1033. .HasColumnType("varchar(50)")
  1034. .HasCharSet("utf8")
  1035. .HasCollation("utf8_general_ci");
  1036. entity.Property(e => e.Details)
  1037. .HasColumnType("longtext")
  1038. .HasCharSet("utf8")
  1039. .HasCollation("utf8_general_ci");
  1040. entity.Property(e => e.Name)
  1041. .HasColumnType("varchar(50)")
  1042. .HasCharSet("utf8")
  1043. .HasCollation("utf8_general_ci");
  1044. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  1045. entity.Property(e => e.RightInfo)
  1046. .HasColumnType("longtext")
  1047. .HasCharSet("utf8")
  1048. .HasCollation("utf8_general_ci");
  1049. entity.Property(e => e.SeoDescription)
  1050. .HasColumnType("varchar(500)")
  1051. .HasCharSet("utf8")
  1052. .HasCollation("utf8_general_ci");
  1053. entity.Property(e => e.SeoKeyword)
  1054. .HasColumnType("varchar(200)")
  1055. .HasCharSet("utf8")
  1056. .HasCollation("utf8_general_ci");
  1057. entity.Property(e => e.SeoTitle)
  1058. .HasColumnType("varchar(100)")
  1059. .HasCharSet("utf8")
  1060. .HasCollation("utf8_general_ci");
  1061. entity.Property(e => e.Sort).HasColumnType("int(11)");
  1062. entity.Property(e => e.Status).HasColumnType("int(11)");
  1063. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  1064. entity.Property(e => e.UpdateMan)
  1065. .HasColumnType("varchar(50)")
  1066. .HasCharSet("utf8")
  1067. .HasCollation("utf8_general_ci");
  1068. entity.Property(e => e.Version).HasColumnType("int(11)");
  1069. });
  1070. modelBuilder.Entity<SysLog>(entity =>
  1071. {
  1072. entity.Property(e => e.Id).HasColumnType("int(11)");
  1073. entity.Property(e => e.Contents)
  1074. .HasColumnType("varchar(200)")
  1075. .HasCharSet("utf8")
  1076. .HasCollation("utf8_general_ci");
  1077. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  1078. entity.Property(e => e.CreateMan)
  1079. .HasColumnType("varchar(50)")
  1080. .HasCharSet("utf8")
  1081. .HasCollation("utf8_general_ci");
  1082. });
  1083. modelBuilder.Entity<SystemSet>(entity =>
  1084. {
  1085. entity.Property(e => e.Id).HasColumnType("int(11)");
  1086. entity.Property(e => e.Address)
  1087. .HasColumnType("varchar(100)")
  1088. .HasCharSet("utf8")
  1089. .HasCollation("utf8_general_ci");
  1090. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  1091. entity.Property(e => e.CreateMan)
  1092. .HasColumnType("varchar(50)")
  1093. .HasCharSet("utf8")
  1094. .HasCollation("utf8_general_ci");
  1095. entity.Property(e => e.IndexDescription)
  1096. .HasColumnType("longtext")
  1097. .HasCharSet("utf8")
  1098. .HasCollation("utf8_general_ci");
  1099. entity.Property(e => e.IndexKeyword)
  1100. .HasColumnType("varchar(200)")
  1101. .HasCharSet("utf8")
  1102. .HasCollation("utf8_general_ci");
  1103. entity.Property(e => e.Logo)
  1104. .HasColumnType("varchar(200)")
  1105. .HasCharSet("utf8")
  1106. .HasCollation("utf8_general_ci");
  1107. entity.Property(e => e.Phone)
  1108. .HasColumnType("varchar(100)")
  1109. .HasCharSet("utf8")
  1110. .HasCollation("utf8_general_ci");
  1111. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  1112. entity.Property(e => e.RightInfo)
  1113. .HasColumnType("longtext")
  1114. .HasCharSet("utf8")
  1115. .HasCollation("utf8_general_ci");
  1116. entity.Property(e => e.SeoDescription)
  1117. .HasColumnType("varchar(500)")
  1118. .HasCharSet("utf8")
  1119. .HasCollation("utf8_general_ci");
  1120. entity.Property(e => e.SeoKeyword)
  1121. .HasColumnType("varchar(200)")
  1122. .HasCharSet("utf8")
  1123. .HasCollation("utf8_general_ci");
  1124. entity.Property(e => e.SeoTitle)
  1125. .HasColumnType("varchar(100)")
  1126. .HasCharSet("utf8")
  1127. .HasCollation("utf8_general_ci");
  1128. entity.Property(e => e.Sort).HasColumnType("int(11)");
  1129. entity.Property(e => e.StartAdPhoto)
  1130. .HasColumnType("varchar(200)")
  1131. .HasCharSet("utf8")
  1132. .HasCollation("utf8_general_ci");
  1133. entity.Property(e => e.Status).HasColumnType("int(11)");
  1134. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  1135. entity.Property(e => e.UpdateMan)
  1136. .HasColumnType("varchar(50)")
  1137. .HasCharSet("utf8")
  1138. .HasCollation("utf8_general_ci");
  1139. entity.Property(e => e.UploadAutoWater)
  1140. .HasColumnType("bit(1)")
  1141. .HasDefaultValueSql("b'0'");
  1142. entity.Property(e => e.UploadAutoZoom)
  1143. .HasColumnType("bit(1)")
  1144. .HasDefaultValueSql("b'0'");
  1145. entity.Property(e => e.UploadAutoZoomHeight).HasColumnType("int(11)");
  1146. entity.Property(e => e.UploadAutoZoomQuality).HasColumnType("int(11)");
  1147. entity.Property(e => e.UploadAutoZoomWidth).HasColumnType("int(11)");
  1148. entity.Property(e => e.UploadExt)
  1149. .HasColumnType("varchar(100)")
  1150. .HasCharSet("utf8")
  1151. .HasCollation("utf8_general_ci");
  1152. entity.Property(e => e.UploadMaxSize).HasColumnType("int(11)");
  1153. entity.Property(e => e.UploadOss)
  1154. .HasColumnType("bit(1)")
  1155. .HasDefaultValueSql("b'0'");
  1156. entity.Property(e => e.UploadWaterPath)
  1157. .HasColumnType("varchar(200)")
  1158. .HasCharSet("utf8")
  1159. .HasCollation("utf8_general_ci");
  1160. entity.Property(e => e.UploadWaterPosition)
  1161. .HasColumnType("varchar(15)")
  1162. .HasCharSet("utf8")
  1163. .HasCollation("utf8_general_ci");
  1164. entity.Property(e => e.Version).HasColumnType("int(11)");
  1165. entity.Property(e => e.WebName)
  1166. .HasColumnType("varchar(50)")
  1167. .HasCharSet("utf8")
  1168. .HasCollation("utf8_general_ci");
  1169. entity.Property(e => e.WebStatCode)
  1170. .HasColumnType("longtext")
  1171. .HasCharSet("utf8")
  1172. .HasCollation("utf8_general_ci");
  1173. entity.Property(e => e.WebUrl)
  1174. .HasColumnType("varchar(200)")
  1175. .HasCharSet("utf8")
  1176. .HasCollation("utf8_general_ci");
  1177. });
  1178. modelBuilder.Entity<UploadParams>(entity =>
  1179. {
  1180. entity.Property(e => e.Id).HasColumnType("int(11)");
  1181. entity.Property(e => e.ColumnEnName)
  1182. .HasColumnType("varchar(50)")
  1183. .HasCharSet("utf8")
  1184. .HasCollation("utf8_general_ci");
  1185. entity.Property(e => e.ColumnName)
  1186. .HasColumnType("varchar(50)")
  1187. .HasCharSet("utf8")
  1188. .HasCollation("utf8_general_ci");
  1189. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  1190. entity.Property(e => e.CreateMan)
  1191. .HasColumnType("varchar(50)")
  1192. .HasCharSet("utf8")
  1193. .HasCollation("utf8_general_ci");
  1194. entity.Property(e => e.ParamString)
  1195. .HasColumnType("varchar(200)")
  1196. .HasCharSet("utf8")
  1197. .HasCollation("utf8_general_ci");
  1198. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  1199. entity.Property(e => e.SeoDescription)
  1200. .HasColumnType("varchar(500)")
  1201. .HasCharSet("utf8")
  1202. .HasCollation("utf8_general_ci");
  1203. entity.Property(e => e.SeoKeyword)
  1204. .HasColumnType("varchar(200)")
  1205. .HasCharSet("utf8")
  1206. .HasCollation("utf8_general_ci");
  1207. entity.Property(e => e.SeoTitle)
  1208. .HasColumnType("varchar(100)")
  1209. .HasCharSet("utf8")
  1210. .HasCollation("utf8_general_ci");
  1211. entity.Property(e => e.Sort).HasColumnType("int(11)");
  1212. entity.Property(e => e.Status).HasColumnType("int(11)");
  1213. entity.Property(e => e.TableEnName)
  1214. .HasColumnType("varchar(50)")
  1215. .HasCharSet("utf8")
  1216. .HasCollation("utf8_general_ci");
  1217. entity.Property(e => e.TableName)
  1218. .HasColumnType("varchar(50)")
  1219. .HasCharSet("utf8")
  1220. .HasCollation("utf8_general_ci");
  1221. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  1222. entity.Property(e => e.UpdateMan)
  1223. .HasColumnType("varchar(50)")
  1224. .HasCharSet("utf8")
  1225. .HasCollation("utf8_general_ci");
  1226. entity.Property(e => e.Version).HasColumnType("int(11)");
  1227. });
  1228. OnModelCreatingPartial(modelBuilder);
  1229. }
  1230. partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
  1231. }
  1232. }