WebCMSEntities.cs 61 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634
  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.Url)
  973. .HasColumnType("varchar(200)")
  974. .HasCharSet("utf8")
  975. .HasCollation("utf8_general_ci");
  976. });
  977. modelBuilder.Entity<SysAdmin>(entity =>
  978. {
  979. entity.Property(e => e.Id).HasColumnType("int(11)");
  980. entity.Property(e => e.AdminName)
  981. .HasColumnType("varchar(50)")
  982. .HasCharSet("utf8")
  983. .HasCollation("utf8_general_ci");
  984. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  985. entity.Property(e => e.CreateMan)
  986. .HasColumnType("varchar(50)")
  987. .HasCharSet("utf8")
  988. .HasCollation("utf8_general_ci");
  989. entity.Property(e => e.LastLoginDate).HasColumnType("datetime");
  990. entity.Property(e => e.Password)
  991. .HasColumnType("varchar(32)")
  992. .HasCharSet("utf8")
  993. .HasCollation("utf8_general_ci");
  994. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  995. entity.Property(e => e.RealName)
  996. .HasColumnType("varchar(50)")
  997. .HasCharSet("utf8")
  998. .HasCollation("utf8_general_ci");
  999. entity.Property(e => e.Role)
  1000. .HasColumnType("varchar(30)")
  1001. .HasCharSet("utf8")
  1002. .HasCollation("utf8_general_ci");
  1003. entity.Property(e => e.SeoDescription)
  1004. .HasColumnType("varchar(500)")
  1005. .HasCharSet("utf8")
  1006. .HasCollation("utf8_general_ci");
  1007. entity.Property(e => e.SeoKeyword)
  1008. .HasColumnType("varchar(200)")
  1009. .HasCharSet("utf8")
  1010. .HasCollation("utf8_general_ci");
  1011. entity.Property(e => e.SeoTitle)
  1012. .HasColumnType("varchar(100)")
  1013. .HasCharSet("utf8")
  1014. .HasCollation("utf8_general_ci");
  1015. entity.Property(e => e.Sort).HasColumnType("int(11)");
  1016. entity.Property(e => e.Status).HasColumnType("int(11)");
  1017. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  1018. entity.Property(e => e.UpdateMan)
  1019. .HasColumnType("varchar(50)")
  1020. .HasCharSet("utf8")
  1021. .HasCollation("utf8_general_ci");
  1022. entity.Property(e => e.Version).HasColumnType("int(11)");
  1023. });
  1024. modelBuilder.Entity<SysAdminRole>(entity =>
  1025. {
  1026. entity.Property(e => e.Id).HasColumnType("int(11)");
  1027. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  1028. entity.Property(e => e.CreateMan)
  1029. .HasColumnType("varchar(50)")
  1030. .HasCharSet("utf8")
  1031. .HasCollation("utf8_general_ci");
  1032. entity.Property(e => e.Details)
  1033. .HasColumnType("longtext")
  1034. .HasCharSet("utf8")
  1035. .HasCollation("utf8_general_ci");
  1036. entity.Property(e => e.Name)
  1037. .HasColumnType("varchar(50)")
  1038. .HasCharSet("utf8")
  1039. .HasCollation("utf8_general_ci");
  1040. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  1041. entity.Property(e => e.RightInfo)
  1042. .HasColumnType("longtext")
  1043. .HasCharSet("utf8")
  1044. .HasCollation("utf8_general_ci");
  1045. entity.Property(e => e.SeoDescription)
  1046. .HasColumnType("varchar(500)")
  1047. .HasCharSet("utf8")
  1048. .HasCollation("utf8_general_ci");
  1049. entity.Property(e => e.SeoKeyword)
  1050. .HasColumnType("varchar(200)")
  1051. .HasCharSet("utf8")
  1052. .HasCollation("utf8_general_ci");
  1053. entity.Property(e => e.SeoTitle)
  1054. .HasColumnType("varchar(100)")
  1055. .HasCharSet("utf8")
  1056. .HasCollation("utf8_general_ci");
  1057. entity.Property(e => e.Sort).HasColumnType("int(11)");
  1058. entity.Property(e => e.Status).HasColumnType("int(11)");
  1059. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  1060. entity.Property(e => e.UpdateMan)
  1061. .HasColumnType("varchar(50)")
  1062. .HasCharSet("utf8")
  1063. .HasCollation("utf8_general_ci");
  1064. entity.Property(e => e.Version).HasColumnType("int(11)");
  1065. });
  1066. modelBuilder.Entity<SysLog>(entity =>
  1067. {
  1068. entity.Property(e => e.Id).HasColumnType("int(11)");
  1069. entity.Property(e => e.Contents)
  1070. .HasColumnType("varchar(200)")
  1071. .HasCharSet("utf8")
  1072. .HasCollation("utf8_general_ci");
  1073. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  1074. entity.Property(e => e.CreateMan)
  1075. .HasColumnType("varchar(50)")
  1076. .HasCharSet("utf8")
  1077. .HasCollation("utf8_general_ci");
  1078. });
  1079. modelBuilder.Entity<SystemSet>(entity =>
  1080. {
  1081. entity.Property(e => e.Id).HasColumnType("int(11)");
  1082. entity.Property(e => e.Address)
  1083. .HasColumnType("varchar(100)")
  1084. .HasCharSet("utf8")
  1085. .HasCollation("utf8_general_ci");
  1086. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  1087. entity.Property(e => e.CreateMan)
  1088. .HasColumnType("varchar(50)")
  1089. .HasCharSet("utf8")
  1090. .HasCollation("utf8_general_ci");
  1091. entity.Property(e => e.IndexDescription)
  1092. .HasColumnType("longtext")
  1093. .HasCharSet("utf8")
  1094. .HasCollation("utf8_general_ci");
  1095. entity.Property(e => e.IndexKeyword)
  1096. .HasColumnType("varchar(200)")
  1097. .HasCharSet("utf8")
  1098. .HasCollation("utf8_general_ci");
  1099. entity.Property(e => e.Logo)
  1100. .HasColumnType("varchar(200)")
  1101. .HasCharSet("utf8")
  1102. .HasCollation("utf8_general_ci");
  1103. entity.Property(e => e.Phone)
  1104. .HasColumnType("varchar(100)")
  1105. .HasCharSet("utf8")
  1106. .HasCollation("utf8_general_ci");
  1107. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  1108. entity.Property(e => e.RightInfo)
  1109. .HasColumnType("longtext")
  1110. .HasCharSet("utf8")
  1111. .HasCollation("utf8_general_ci");
  1112. entity.Property(e => e.SeoDescription)
  1113. .HasColumnType("varchar(500)")
  1114. .HasCharSet("utf8")
  1115. .HasCollation("utf8_general_ci");
  1116. entity.Property(e => e.SeoKeyword)
  1117. .HasColumnType("varchar(200)")
  1118. .HasCharSet("utf8")
  1119. .HasCollation("utf8_general_ci");
  1120. entity.Property(e => e.SeoTitle)
  1121. .HasColumnType("varchar(100)")
  1122. .HasCharSet("utf8")
  1123. .HasCollation("utf8_general_ci");
  1124. entity.Property(e => e.Sort).HasColumnType("int(11)");
  1125. entity.Property(e => e.StartAdPhoto)
  1126. .HasColumnType("varchar(200)")
  1127. .HasCharSet("utf8")
  1128. .HasCollation("utf8_general_ci");
  1129. entity.Property(e => e.Status).HasColumnType("int(11)");
  1130. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  1131. entity.Property(e => e.UpdateMan)
  1132. .HasColumnType("varchar(50)")
  1133. .HasCharSet("utf8")
  1134. .HasCollation("utf8_general_ci");
  1135. entity.Property(e => e.UploadAutoWater)
  1136. .HasColumnType("bit(1)")
  1137. .HasDefaultValueSql("b'0'");
  1138. entity.Property(e => e.UploadAutoZoom)
  1139. .HasColumnType("bit(1)")
  1140. .HasDefaultValueSql("b'0'");
  1141. entity.Property(e => e.UploadAutoZoomHeight).HasColumnType("int(11)");
  1142. entity.Property(e => e.UploadAutoZoomQuality).HasColumnType("int(11)");
  1143. entity.Property(e => e.UploadAutoZoomWidth).HasColumnType("int(11)");
  1144. entity.Property(e => e.UploadExt)
  1145. .HasColumnType("varchar(100)")
  1146. .HasCharSet("utf8")
  1147. .HasCollation("utf8_general_ci");
  1148. entity.Property(e => e.UploadMaxSize).HasColumnType("int(11)");
  1149. entity.Property(e => e.UploadOss)
  1150. .HasColumnType("bit(1)")
  1151. .HasDefaultValueSql("b'0'");
  1152. entity.Property(e => e.UploadWaterPath)
  1153. .HasColumnType("varchar(200)")
  1154. .HasCharSet("utf8")
  1155. .HasCollation("utf8_general_ci");
  1156. entity.Property(e => e.UploadWaterPosition)
  1157. .HasColumnType("varchar(15)")
  1158. .HasCharSet("utf8")
  1159. .HasCollation("utf8_general_ci");
  1160. entity.Property(e => e.Version).HasColumnType("int(11)");
  1161. entity.Property(e => e.WebName)
  1162. .HasColumnType("varchar(50)")
  1163. .HasCharSet("utf8")
  1164. .HasCollation("utf8_general_ci");
  1165. entity.Property(e => e.WebStatCode)
  1166. .HasColumnType("longtext")
  1167. .HasCharSet("utf8")
  1168. .HasCollation("utf8_general_ci");
  1169. entity.Property(e => e.WebUrl)
  1170. .HasColumnType("varchar(200)")
  1171. .HasCharSet("utf8")
  1172. .HasCollation("utf8_general_ci");
  1173. });
  1174. modelBuilder.Entity<UploadParams>(entity =>
  1175. {
  1176. entity.Property(e => e.Id).HasColumnType("int(11)");
  1177. entity.Property(e => e.ColumnEnName)
  1178. .HasColumnType("varchar(50)")
  1179. .HasCharSet("utf8")
  1180. .HasCollation("utf8_general_ci");
  1181. entity.Property(e => e.ColumnName)
  1182. .HasColumnType("varchar(50)")
  1183. .HasCharSet("utf8")
  1184. .HasCollation("utf8_general_ci");
  1185. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  1186. entity.Property(e => e.CreateMan)
  1187. .HasColumnType("varchar(50)")
  1188. .HasCharSet("utf8")
  1189. .HasCollation("utf8_general_ci");
  1190. entity.Property(e => e.ParamString)
  1191. .HasColumnType("varchar(200)")
  1192. .HasCharSet("utf8")
  1193. .HasCollation("utf8_general_ci");
  1194. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  1195. entity.Property(e => e.SeoDescription)
  1196. .HasColumnType("varchar(500)")
  1197. .HasCharSet("utf8")
  1198. .HasCollation("utf8_general_ci");
  1199. entity.Property(e => e.SeoKeyword)
  1200. .HasColumnType("varchar(200)")
  1201. .HasCharSet("utf8")
  1202. .HasCollation("utf8_general_ci");
  1203. entity.Property(e => e.SeoTitle)
  1204. .HasColumnType("varchar(100)")
  1205. .HasCharSet("utf8")
  1206. .HasCollation("utf8_general_ci");
  1207. entity.Property(e => e.Sort).HasColumnType("int(11)");
  1208. entity.Property(e => e.Status).HasColumnType("int(11)");
  1209. entity.Property(e => e.TableEnName)
  1210. .HasColumnType("varchar(50)")
  1211. .HasCharSet("utf8")
  1212. .HasCollation("utf8_general_ci");
  1213. entity.Property(e => e.TableName)
  1214. .HasColumnType("varchar(50)")
  1215. .HasCharSet("utf8")
  1216. .HasCollation("utf8_general_ci");
  1217. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  1218. entity.Property(e => e.UpdateMan)
  1219. .HasColumnType("varchar(50)")
  1220. .HasCharSet("utf8")
  1221. .HasCollation("utf8_general_ci");
  1222. entity.Property(e => e.Version).HasColumnType("int(11)");
  1223. });
  1224. OnModelCreatingPartial(modelBuilder);
  1225. }
  1226. partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
  1227. }
  1228. }