WebCMSEntities.cs 60 KB

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