202004250810364_AddWeInfo.cs 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563
  1. namespace WePlatform.Migrations
  2. {
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Data.Entity.Infrastructure.Annotations;
  6. using System.Data.Entity.Migrations;
  7. public partial class AddWeInfo : DbMigration
  8. {
  9. public override void Up()
  10. {
  11. CreateTable(
  12. "dbo.WeLib_Behaviors",
  13. c => new
  14. {
  15. Id = c.String(nullable: false, maxLength: 128),
  16. SceneCategory = c.String(maxLength: 128),
  17. BehaviorTag = c.String(maxLength: 500),
  18. Description = c.String(maxLength: 500),
  19. RoleLogicType = c.Int(nullable: false),
  20. RuleKeyword = c.String(maxLength: 500),
  21. IsDeleted = c.Boolean(nullable: false),
  22. DeleterUserId = c.Long(),
  23. DeletionTime = c.DateTime(),
  24. LastModificationTime = c.DateTime(),
  25. LastModifierUserId = c.Long(),
  26. CreationTime = c.DateTime(nullable: false),
  27. CreatorUserId = c.Long(),
  28. },
  29. annotations: new Dictionary<string, object>
  30. {
  31. { "DynamicFilter_BehaviorInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  32. })
  33. .PrimaryKey(t => t.Id)
  34. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  35. .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  36. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  37. .ForeignKey("dbo.WeBase_SceneCategories", t => t.SceneCategory)
  38. .Index(t => t.SceneCategory)
  39. .Index(t => t.IsDeleted)
  40. .Index(t => t.DeleterUserId)
  41. .Index(t => t.LastModifierUserId)
  42. .Index(t => t.CreatorUserId);
  43. CreateTable(
  44. "dbo.WeBase_BehaviorRoles",
  45. c => new
  46. {
  47. Id = c.String(nullable: false, maxLength: 128),
  48. RoleName = c.String(maxLength: 50),
  49. Description = c.String(maxLength: 500),
  50. SceneCategory = c.String(maxLength: 128),
  51. Remark = c.String(maxLength: 500),
  52. LastModificationTime = c.DateTime(),
  53. LastModifierUserId = c.Long(),
  54. CreationTime = c.DateTime(nullable: false),
  55. CreatorUserId = c.Long(),
  56. })
  57. .PrimaryKey(t => t.Id)
  58. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  59. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  60. .ForeignKey("dbo.WeBase_SceneCategories", t => t.SceneCategory)
  61. .Index(t => t.SceneCategory)
  62. .Index(t => t.LastModifierUserId)
  63. .Index(t => t.CreatorUserId);
  64. CreateTable(
  65. "dbo.WeBase_SceneCategories",
  66. c => new
  67. {
  68. Id = c.String(nullable: false, maxLength: 128),
  69. ParentNo = c.String(maxLength: 128),
  70. CategoryName = c.String(maxLength: 50),
  71. CategoryPath = c.String(maxLength: 500),
  72. Sort = c.Int(nullable: false),
  73. Description = c.String(maxLength: 500),
  74. Remark = c.String(maxLength: 500),
  75. LastModificationTime = c.DateTime(),
  76. LastModifierUserId = c.Long(),
  77. CreationTime = c.DateTime(nullable: false),
  78. CreatorUserId = c.Long(),
  79. })
  80. .PrimaryKey(t => t.Id)
  81. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  82. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  83. .ForeignKey("dbo.WeBase_SceneCategories", t => t.ParentNo)
  84. .Index(t => t.ParentNo)
  85. .Index(t => t.LastModifierUserId)
  86. .Index(t => t.CreatorUserId);
  87. CreateTable(
  88. "dbo.WeLib_BehaviorKnowledges",
  89. c => new
  90. {
  91. Id = c.Int(nullable: false, identity: true),
  92. BehaviorNo = c.String(maxLength: 128),
  93. KnowledgeNo = c.String(maxLength: 128),
  94. CreationTime = c.DateTime(nullable: false),
  95. CreatorUserId = c.Long(),
  96. })
  97. .PrimaryKey(t => t.Id)
  98. .ForeignKey("dbo.WeLib_Behaviors", t => t.BehaviorNo)
  99. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  100. .ForeignKey("dbo.WeLib_Knowledges", t => t.KnowledgeNo)
  101. .Index(t => t.BehaviorNo)
  102. .Index(t => t.KnowledgeNo)
  103. .Index(t => t.CreatorUserId);
  104. CreateTable(
  105. "dbo.WeLib_Knowledges",
  106. c => new
  107. {
  108. Id = c.String(nullable: false, maxLength: 128),
  109. Name = c.String(maxLength: 50),
  110. Description = c.String(maxLength: 500),
  111. Remark = c.String(maxLength: 500),
  112. IsDeleted = c.Boolean(nullable: false),
  113. DeleterUserId = c.Long(),
  114. DeletionTime = c.DateTime(),
  115. LastModificationTime = c.DateTime(),
  116. LastModifierUserId = c.Long(),
  117. CreationTime = c.DateTime(nullable: false),
  118. CreatorUserId = c.Long(),
  119. },
  120. annotations: new Dictionary<string, object>
  121. {
  122. { "DynamicFilter_KnowledgeInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  123. })
  124. .PrimaryKey(t => t.Id)
  125. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  126. .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  127. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  128. .Index(t => t.IsDeleted)
  129. .Index(t => t.DeleterUserId)
  130. .Index(t => t.LastModifierUserId)
  131. .Index(t => t.CreatorUserId);
  132. CreateTable(
  133. "dbo.WeModel_Engines",
  134. c => new
  135. {
  136. Id = c.String(nullable: false, maxLength: 128),
  137. EngineName = c.String(maxLength: 50),
  138. Version = c.String(maxLength: 50),
  139. Description = c.String(maxLength: 500),
  140. RunnerClassName = c.String(maxLength: 200),
  141. ScoreEvalClassName = c.String(maxLength: 200),
  142. Remark = c.String(maxLength: 500),
  143. IsDeleted = c.Boolean(nullable: false),
  144. DeleterUserId = c.Long(),
  145. DeletionTime = c.DateTime(),
  146. LastModificationTime = c.DateTime(),
  147. LastModifierUserId = c.Long(),
  148. CreationTime = c.DateTime(nullable: false),
  149. CreatorUserId = c.Long(),
  150. },
  151. annotations: new Dictionary<string, object>
  152. {
  153. { "DynamicFilter_EngineInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  154. })
  155. .PrimaryKey(t => t.Id)
  156. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  157. .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  158. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  159. .Index(t => t.IsDeleted)
  160. .Index(t => t.DeleterUserId)
  161. .Index(t => t.LastModifierUserId)
  162. .Index(t => t.CreatorUserId);
  163. CreateTable(
  164. "dbo.WeModel_EngineModels",
  165. c => new
  166. {
  167. Id = c.String(nullable: false, maxLength: 128),
  168. ModelName = c.String(maxLength: 50),
  169. Version = c.String(maxLength: 50),
  170. Description = c.String(maxLength: 500),
  171. ModelType = c.Int(nullable: false),
  172. EngineNo = c.String(maxLength: 128),
  173. Remark = c.String(maxLength: 500),
  174. IsDeleted = c.Boolean(nullable: false),
  175. DeleterUserId = c.Long(),
  176. DeletionTime = c.DateTime(),
  177. LastModificationTime = c.DateTime(),
  178. LastModifierUserId = c.Long(),
  179. CreationTime = c.DateTime(nullable: false),
  180. CreatorUserId = c.Long(),
  181. },
  182. annotations: new Dictionary<string, object>
  183. {
  184. { "DynamicFilter_EngineModelInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  185. })
  186. .PrimaryKey(t => t.Id)
  187. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  188. .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  189. .ForeignKey("dbo.WeModel_Engines", t => t.EngineNo)
  190. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  191. .Index(t => t.EngineNo)
  192. .Index(t => t.IsDeleted)
  193. .Index(t => t.DeleterUserId)
  194. .Index(t => t.LastModifierUserId)
  195. .Index(t => t.CreatorUserId);
  196. CreateTable(
  197. "dbo.WeLib_EnvironResources",
  198. c => new
  199. {
  200. Id = c.String(nullable: false, maxLength: 128),
  201. ResourceName = c.String(maxLength: 50),
  202. ResourceType = c.Int(nullable: false),
  203. ResourcePath = c.String(maxLength: 500),
  204. Description = c.String(maxLength: 500),
  205. MessageCode = c.String(maxLength: 20),
  206. Remark = c.String(maxLength: 500),
  207. IsDeleted = c.Boolean(nullable: false),
  208. DeleterUserId = c.Long(),
  209. DeletionTime = c.DateTime(),
  210. LastModificationTime = c.DateTime(),
  211. LastModifierUserId = c.Long(),
  212. CreationTime = c.DateTime(nullable: false),
  213. CreatorUserId = c.Long(),
  214. },
  215. annotations: new Dictionary<string, object>
  216. {
  217. { "DynamicFilter_EnvironResourceInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  218. })
  219. .PrimaryKey(t => t.Id)
  220. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  221. .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  222. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  223. .Index(t => t.MessageCode, unique: true)
  224. .Index(t => t.IsDeleted)
  225. .Index(t => t.DeleterUserId)
  226. .Index(t => t.LastModifierUserId)
  227. .Index(t => t.CreatorUserId);
  228. CreateTable(
  229. "dbo.WeLib_Guides",
  230. c => new
  231. {
  232. Id = c.String(nullable: false, maxLength: 128),
  233. Name = c.String(maxLength: 50),
  234. Description = c.String(maxLength: 500),
  235. GuideType = c.Int(nullable: false),
  236. Remark = c.String(maxLength: 500),
  237. IsDeleted = c.Boolean(nullable: false),
  238. DeleterUserId = c.Long(),
  239. DeletionTime = c.DateTime(),
  240. LastModificationTime = c.DateTime(),
  241. LastModifierUserId = c.Long(),
  242. CreationTime = c.DateTime(nullable: false),
  243. CreatorUserId = c.Long(),
  244. },
  245. annotations: new Dictionary<string, object>
  246. {
  247. { "DynamicFilter_GuideInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  248. })
  249. .PrimaryKey(t => t.Id)
  250. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  251. .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  252. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  253. .Index(t => t.IsDeleted)
  254. .Index(t => t.DeleterUserId)
  255. .Index(t => t.LastModifierUserId)
  256. .Index(t => t.CreatorUserId);
  257. CreateTable(
  258. "dbo.WeLib_Packages",
  259. c => new
  260. {
  261. Id = c.String(nullable: false, maxLength: 128),
  262. PackageName = c.String(maxLength: 50),
  263. SceneCategory = c.String(maxLength: 128),
  264. EngineModelNo = c.String(maxLength: 128),
  265. MasterPlanner = c.String(maxLength: 50),
  266. Planner = c.String(maxLength: 500),
  267. ContentInfo = c.String(),
  268. PackageState = c.Int(nullable: false),
  269. IsDeleted = c.Boolean(nullable: false),
  270. DeleterUserId = c.Long(),
  271. DeletionTime = c.DateTime(),
  272. LastModificationTime = c.DateTime(),
  273. LastModifierUserId = c.Long(),
  274. CreationTime = c.DateTime(nullable: false),
  275. CreatorUserId = c.Long(),
  276. },
  277. annotations: new Dictionary<string, object>
  278. {
  279. { "DynamicFilter_PackageInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  280. })
  281. .PrimaryKey(t => t.Id)
  282. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  283. .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  284. .ForeignKey("dbo.WeModel_EngineModels", t => t.EngineModelNo)
  285. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  286. .ForeignKey("dbo.WeBase_SceneCategories", t => t.SceneCategory)
  287. .Index(t => t.SceneCategory)
  288. .Index(t => t.EngineModelNo)
  289. .Index(t => t.IsDeleted)
  290. .Index(t => t.DeleterUserId)
  291. .Index(t => t.LastModifierUserId)
  292. .Index(t => t.CreatorUserId);
  293. CreateTable(
  294. "dbo.WeLib_SceneBehaviors",
  295. c => new
  296. {
  297. Id = c.Int(nullable: false, identity: true),
  298. SceneNo = c.String(maxLength: 128),
  299. BehaviorNo = c.String(maxLength: 128),
  300. BehaviorEvalType = c.Int(nullable: false),
  301. BehaviorWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
  302. CreationTime = c.DateTime(nullable: false),
  303. CreatorUserId = c.Long(),
  304. })
  305. .PrimaryKey(t => t.Id)
  306. .ForeignKey("dbo.WeLib_Behaviors", t => t.BehaviorNo)
  307. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  308. .ForeignKey("dbo.WeLib_Scenes", t => t.SceneNo)
  309. .Index(t => t.SceneNo)
  310. .Index(t => t.BehaviorNo)
  311. .Index(t => t.CreatorUserId);
  312. CreateTable(
  313. "dbo.WeLib_Scenes",
  314. c => new
  315. {
  316. Id = c.String(nullable: false, maxLength: 128),
  317. Name = c.String(maxLength: 50),
  318. SceneCategory = c.String(maxLength: 128),
  319. SceneTag = c.String(maxLength: 200),
  320. Description = c.String(maxLength: 500),
  321. SceneType = c.Int(nullable: false),
  322. Remark = c.String(maxLength: 500),
  323. IsDeleted = c.Boolean(nullable: false),
  324. DeleterUserId = c.Long(),
  325. DeletionTime = c.DateTime(),
  326. LastModificationTime = c.DateTime(),
  327. LastModifierUserId = c.Long(),
  328. CreationTime = c.DateTime(nullable: false),
  329. CreatorUserId = c.Long(),
  330. },
  331. annotations: new Dictionary<string, object>
  332. {
  333. { "DynamicFilter_SceneInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  334. })
  335. .PrimaryKey(t => t.Id)
  336. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  337. .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  338. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  339. .ForeignKey("dbo.WeBase_SceneCategories", t => t.SceneCategory)
  340. .Index(t => t.SceneCategory)
  341. .Index(t => t.IsDeleted)
  342. .Index(t => t.DeleterUserId)
  343. .Index(t => t.LastModifierUserId)
  344. .Index(t => t.CreatorUserId);
  345. CreateTable(
  346. "dbo.WeLib_SceneFlows",
  347. c => new
  348. {
  349. Id = c.String(nullable: false, maxLength: 128),
  350. FlowName = c.String(maxLength: 50),
  351. SceneCategory = c.String(maxLength: 128),
  352. ContentInfo = c.String(),
  353. SceneFlowState = c.Int(nullable: false),
  354. IsDeleted = c.Boolean(nullable: false),
  355. DeleterUserId = c.Long(),
  356. DeletionTime = c.DateTime(),
  357. LastModificationTime = c.DateTime(),
  358. LastModifierUserId = c.Long(),
  359. CreationTime = c.DateTime(nullable: false),
  360. CreatorUserId = c.Long(),
  361. },
  362. annotations: new Dictionary<string, object>
  363. {
  364. { "DynamicFilter_SceneFlowInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  365. })
  366. .PrimaryKey(t => t.Id)
  367. .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  368. .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  369. .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  370. .ForeignKey("dbo.WeBase_SceneCategories", t => t.SceneCategory)
  371. .Index(t => t.SceneCategory)
  372. .Index(t => t.IsDeleted)
  373. .Index(t => t.DeleterUserId)
  374. .Index(t => t.LastModifierUserId)
  375. .Index(t => t.CreatorUserId);
  376. CreateTable(
  377. "dbo.BehaviorRoleInfoBehaviorInfoes",
  378. c => new
  379. {
  380. BehaviorRoleInfo_Id = c.String(nullable: false, maxLength: 128),
  381. BehaviorInfo_Id = c.String(nullable: false, maxLength: 128),
  382. })
  383. .PrimaryKey(t => new { t.BehaviorRoleInfo_Id, t.BehaviorInfo_Id })
  384. .ForeignKey("dbo.WeBase_BehaviorRoles", t => t.BehaviorRoleInfo_Id, cascadeDelete: true)
  385. .ForeignKey("dbo.WeLib_Behaviors", t => t.BehaviorInfo_Id, cascadeDelete: true)
  386. .Index(t => t.BehaviorRoleInfo_Id)
  387. .Index(t => t.BehaviorInfo_Id);
  388. }
  389. public override void Down()
  390. {
  391. DropForeignKey("dbo.WeLib_SceneFlows", "SceneCategory", "dbo.WeBase_SceneCategories");
  392. DropForeignKey("dbo.WeLib_SceneFlows", "LastModifierUserId", "dbo.Sys_Users");
  393. DropForeignKey("dbo.WeLib_SceneFlows", "DeleterUserId", "dbo.Sys_Users");
  394. DropForeignKey("dbo.WeLib_SceneFlows", "CreatorUserId", "dbo.Sys_Users");
  395. DropForeignKey("dbo.WeLib_SceneBehaviors", "SceneNo", "dbo.WeLib_Scenes");
  396. DropForeignKey("dbo.WeLib_Scenes", "SceneCategory", "dbo.WeBase_SceneCategories");
  397. DropForeignKey("dbo.WeLib_Scenes", "LastModifierUserId", "dbo.Sys_Users");
  398. DropForeignKey("dbo.WeLib_Scenes", "DeleterUserId", "dbo.Sys_Users");
  399. DropForeignKey("dbo.WeLib_Scenes", "CreatorUserId", "dbo.Sys_Users");
  400. DropForeignKey("dbo.WeLib_SceneBehaviors", "CreatorUserId", "dbo.Sys_Users");
  401. DropForeignKey("dbo.WeLib_SceneBehaviors", "BehaviorNo", "dbo.WeLib_Behaviors");
  402. DropForeignKey("dbo.WeLib_Packages", "SceneCategory", "dbo.WeBase_SceneCategories");
  403. DropForeignKey("dbo.WeLib_Packages", "LastModifierUserId", "dbo.Sys_Users");
  404. DropForeignKey("dbo.WeLib_Packages", "EngineModelNo", "dbo.WeModel_EngineModels");
  405. DropForeignKey("dbo.WeLib_Packages", "DeleterUserId", "dbo.Sys_Users");
  406. DropForeignKey("dbo.WeLib_Packages", "CreatorUserId", "dbo.Sys_Users");
  407. DropForeignKey("dbo.WeLib_Guides", "LastModifierUserId", "dbo.Sys_Users");
  408. DropForeignKey("dbo.WeLib_Guides", "DeleterUserId", "dbo.Sys_Users");
  409. DropForeignKey("dbo.WeLib_Guides", "CreatorUserId", "dbo.Sys_Users");
  410. DropForeignKey("dbo.WeLib_EnvironResources", "LastModifierUserId", "dbo.Sys_Users");
  411. DropForeignKey("dbo.WeLib_EnvironResources", "DeleterUserId", "dbo.Sys_Users");
  412. DropForeignKey("dbo.WeLib_EnvironResources", "CreatorUserId", "dbo.Sys_Users");
  413. DropForeignKey("dbo.WeModel_EngineModels", "LastModifierUserId", "dbo.Sys_Users");
  414. DropForeignKey("dbo.WeModel_EngineModels", "EngineNo", "dbo.WeModel_Engines");
  415. DropForeignKey("dbo.WeModel_EngineModels", "DeleterUserId", "dbo.Sys_Users");
  416. DropForeignKey("dbo.WeModel_EngineModels", "CreatorUserId", "dbo.Sys_Users");
  417. DropForeignKey("dbo.WeModel_Engines", "LastModifierUserId", "dbo.Sys_Users");
  418. DropForeignKey("dbo.WeModel_Engines", "DeleterUserId", "dbo.Sys_Users");
  419. DropForeignKey("dbo.WeModel_Engines", "CreatorUserId", "dbo.Sys_Users");
  420. DropForeignKey("dbo.WeLib_BehaviorKnowledges", "KnowledgeNo", "dbo.WeLib_Knowledges");
  421. DropForeignKey("dbo.WeLib_Knowledges", "LastModifierUserId", "dbo.Sys_Users");
  422. DropForeignKey("dbo.WeLib_Knowledges", "DeleterUserId", "dbo.Sys_Users");
  423. DropForeignKey("dbo.WeLib_Knowledges", "CreatorUserId", "dbo.Sys_Users");
  424. DropForeignKey("dbo.WeLib_BehaviorKnowledges", "CreatorUserId", "dbo.Sys_Users");
  425. DropForeignKey("dbo.WeLib_BehaviorKnowledges", "BehaviorNo", "dbo.WeLib_Behaviors");
  426. DropForeignKey("dbo.WeLib_Behaviors", "SceneCategory", "dbo.WeBase_SceneCategories");
  427. DropForeignKey("dbo.WeBase_BehaviorRoles", "SceneCategory", "dbo.WeBase_SceneCategories");
  428. DropForeignKey("dbo.WeBase_SceneCategories", "ParentNo", "dbo.WeBase_SceneCategories");
  429. DropForeignKey("dbo.WeBase_SceneCategories", "LastModifierUserId", "dbo.Sys_Users");
  430. DropForeignKey("dbo.WeBase_SceneCategories", "CreatorUserId", "dbo.Sys_Users");
  431. DropForeignKey("dbo.WeBase_BehaviorRoles", "LastModifierUserId", "dbo.Sys_Users");
  432. DropForeignKey("dbo.WeBase_BehaviorRoles", "CreatorUserId", "dbo.Sys_Users");
  433. DropForeignKey("dbo.BehaviorRoleInfoBehaviorInfoes", "BehaviorInfo_Id", "dbo.WeLib_Behaviors");
  434. DropForeignKey("dbo.BehaviorRoleInfoBehaviorInfoes", "BehaviorRoleInfo_Id", "dbo.WeBase_BehaviorRoles");
  435. DropForeignKey("dbo.WeLib_Behaviors", "LastModifierUserId", "dbo.Sys_Users");
  436. DropForeignKey("dbo.WeLib_Behaviors", "DeleterUserId", "dbo.Sys_Users");
  437. DropForeignKey("dbo.WeLib_Behaviors", "CreatorUserId", "dbo.Sys_Users");
  438. DropIndex("dbo.BehaviorRoleInfoBehaviorInfoes", new[] { "BehaviorInfo_Id" });
  439. DropIndex("dbo.BehaviorRoleInfoBehaviorInfoes", new[] { "BehaviorRoleInfo_Id" });
  440. DropIndex("dbo.WeLib_SceneFlows", new[] { "CreatorUserId" });
  441. DropIndex("dbo.WeLib_SceneFlows", new[] { "LastModifierUserId" });
  442. DropIndex("dbo.WeLib_SceneFlows", new[] { "DeleterUserId" });
  443. DropIndex("dbo.WeLib_SceneFlows", new[] { "IsDeleted" });
  444. DropIndex("dbo.WeLib_SceneFlows", new[] { "SceneCategory" });
  445. DropIndex("dbo.WeLib_Scenes", new[] { "CreatorUserId" });
  446. DropIndex("dbo.WeLib_Scenes", new[] { "LastModifierUserId" });
  447. DropIndex("dbo.WeLib_Scenes", new[] { "DeleterUserId" });
  448. DropIndex("dbo.WeLib_Scenes", new[] { "IsDeleted" });
  449. DropIndex("dbo.WeLib_Scenes", new[] { "SceneCategory" });
  450. DropIndex("dbo.WeLib_SceneBehaviors", new[] { "CreatorUserId" });
  451. DropIndex("dbo.WeLib_SceneBehaviors", new[] { "BehaviorNo" });
  452. DropIndex("dbo.WeLib_SceneBehaviors", new[] { "SceneNo" });
  453. DropIndex("dbo.WeLib_Packages", new[] { "CreatorUserId" });
  454. DropIndex("dbo.WeLib_Packages", new[] { "LastModifierUserId" });
  455. DropIndex("dbo.WeLib_Packages", new[] { "DeleterUserId" });
  456. DropIndex("dbo.WeLib_Packages", new[] { "IsDeleted" });
  457. DropIndex("dbo.WeLib_Packages", new[] { "EngineModelNo" });
  458. DropIndex("dbo.WeLib_Packages", new[] { "SceneCategory" });
  459. DropIndex("dbo.WeLib_Guides", new[] { "CreatorUserId" });
  460. DropIndex("dbo.WeLib_Guides", new[] { "LastModifierUserId" });
  461. DropIndex("dbo.WeLib_Guides", new[] { "DeleterUserId" });
  462. DropIndex("dbo.WeLib_Guides", new[] { "IsDeleted" });
  463. DropIndex("dbo.WeLib_EnvironResources", new[] { "CreatorUserId" });
  464. DropIndex("dbo.WeLib_EnvironResources", new[] { "LastModifierUserId" });
  465. DropIndex("dbo.WeLib_EnvironResources", new[] { "DeleterUserId" });
  466. DropIndex("dbo.WeLib_EnvironResources", new[] { "IsDeleted" });
  467. DropIndex("dbo.WeLib_EnvironResources", new[] { "MessageCode" });
  468. DropIndex("dbo.WeModel_EngineModels", new[] { "CreatorUserId" });
  469. DropIndex("dbo.WeModel_EngineModels", new[] { "LastModifierUserId" });
  470. DropIndex("dbo.WeModel_EngineModels", new[] { "DeleterUserId" });
  471. DropIndex("dbo.WeModel_EngineModels", new[] { "IsDeleted" });
  472. DropIndex("dbo.WeModel_EngineModels", new[] { "EngineNo" });
  473. DropIndex("dbo.WeModel_Engines", new[] { "CreatorUserId" });
  474. DropIndex("dbo.WeModel_Engines", new[] { "LastModifierUserId" });
  475. DropIndex("dbo.WeModel_Engines", new[] { "DeleterUserId" });
  476. DropIndex("dbo.WeModel_Engines", new[] { "IsDeleted" });
  477. DropIndex("dbo.WeLib_Knowledges", new[] { "CreatorUserId" });
  478. DropIndex("dbo.WeLib_Knowledges", new[] { "LastModifierUserId" });
  479. DropIndex("dbo.WeLib_Knowledges", new[] { "DeleterUserId" });
  480. DropIndex("dbo.WeLib_Knowledges", new[] { "IsDeleted" });
  481. DropIndex("dbo.WeLib_BehaviorKnowledges", new[] { "CreatorUserId" });
  482. DropIndex("dbo.WeLib_BehaviorKnowledges", new[] { "KnowledgeNo" });
  483. DropIndex("dbo.WeLib_BehaviorKnowledges", new[] { "BehaviorNo" });
  484. DropIndex("dbo.WeBase_SceneCategories", new[] { "CreatorUserId" });
  485. DropIndex("dbo.WeBase_SceneCategories", new[] { "LastModifierUserId" });
  486. DropIndex("dbo.WeBase_SceneCategories", new[] { "ParentNo" });
  487. DropIndex("dbo.WeBase_BehaviorRoles", new[] { "CreatorUserId" });
  488. DropIndex("dbo.WeBase_BehaviorRoles", new[] { "LastModifierUserId" });
  489. DropIndex("dbo.WeBase_BehaviorRoles", new[] { "SceneCategory" });
  490. DropIndex("dbo.WeLib_Behaviors", new[] { "CreatorUserId" });
  491. DropIndex("dbo.WeLib_Behaviors", new[] { "LastModifierUserId" });
  492. DropIndex("dbo.WeLib_Behaviors", new[] { "DeleterUserId" });
  493. DropIndex("dbo.WeLib_Behaviors", new[] { "IsDeleted" });
  494. DropIndex("dbo.WeLib_Behaviors", new[] { "SceneCategory" });
  495. DropTable("dbo.BehaviorRoleInfoBehaviorInfoes");
  496. DropTable("dbo.WeLib_SceneFlows",
  497. removedAnnotations: new Dictionary<string, object>
  498. {
  499. { "DynamicFilter_SceneFlowInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  500. });
  501. DropTable("dbo.WeLib_Scenes",
  502. removedAnnotations: new Dictionary<string, object>
  503. {
  504. { "DynamicFilter_SceneInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  505. });
  506. DropTable("dbo.WeLib_SceneBehaviors");
  507. DropTable("dbo.WeLib_Packages",
  508. removedAnnotations: new Dictionary<string, object>
  509. {
  510. { "DynamicFilter_PackageInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  511. });
  512. DropTable("dbo.WeLib_Guides",
  513. removedAnnotations: new Dictionary<string, object>
  514. {
  515. { "DynamicFilter_GuideInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  516. });
  517. DropTable("dbo.WeLib_EnvironResources",
  518. removedAnnotations: new Dictionary<string, object>
  519. {
  520. { "DynamicFilter_EnvironResourceInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  521. });
  522. DropTable("dbo.WeModel_EngineModels",
  523. removedAnnotations: new Dictionary<string, object>
  524. {
  525. { "DynamicFilter_EngineModelInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  526. });
  527. DropTable("dbo.WeModel_Engines",
  528. removedAnnotations: new Dictionary<string, object>
  529. {
  530. { "DynamicFilter_EngineInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  531. });
  532. DropTable("dbo.WeLib_Knowledges",
  533. removedAnnotations: new Dictionary<string, object>
  534. {
  535. { "DynamicFilter_KnowledgeInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  536. });
  537. DropTable("dbo.WeLib_BehaviorKnowledges");
  538. DropTable("dbo.WeBase_SceneCategories");
  539. DropTable("dbo.WeBase_BehaviorRoles");
  540. DropTable("dbo.WeLib_Behaviors",
  541. removedAnnotations: new Dictionary<string, object>
  542. {
  543. { "DynamicFilter_BehaviorInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  544. });
  545. }
  546. }
  547. }