plat.sql 4.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  1. -- ============================================================================
  2. -- 【历史参考脚本,严禁对运行期平台库执行】
  3. --
  4. -- plat(qingjian/system/db/plat)现在是运行期加密 SQLite 主库。本脚本以
  5. -- drop table if exists 开头,执行它会删掉在用的表并丢失数据;且 SQLite JDBC
  6. -- 对多语句串只执行第一条,整篇灌进去本来也不是预期行为。
  7. --
  8. -- 保留此文件仅为查阅 Solon 时代的平台表结构。新环境初始化 / 补建缺失表请用
  9. -- sql/ai_clean_sqlite.sql(幂等 create table if not exists),步骤见 QUICK_START。
  10. -- 另注:本脚本的 system_info 缺 first_date_time,chat_* / knowledge_* 属已删除模块。
  11. -- ============================================================================
  12. drop table if exists bank_card_issuer_info;
  13. create table bank_card_issuer_info
  14. (
  15. bank_bin TEXT not null primary key,
  16. bank_name TEXT,
  17. card_type TEXT,
  18. flag INTEGER
  19. );
  20. drop table if exists case_info;
  21. create table case_info
  22. (
  23. -- 主键由应用侧雪花算法生成,不使用自增
  24. id BIGINT not null primary key,
  25. name TEXT,
  26. pwd TEXT,
  27. type TEXT,
  28. remark TEXT,
  29. db TEXT,
  30. db_Path TEXT,
  31. init INTEGER,
  32. create_time DATE
  33. );
  34. drop table if exists phone_isp;
  35. create table phone_isp
  36. (
  37. paragraph TEXT not null primary key,
  38. province TEXT,
  39. city TEXT,
  40. isp TEXT
  41. );
  42. drop table if exists system_info;
  43. create table system_info
  44. (
  45. machinecode TEXT,
  46. client_no TEXT,
  47. unit TEXT,
  48. phone TEXT,
  49. active_date_time DATE,
  50. authdatetime DATE,
  51. overdatetime DATE
  52. );
  53. drop table if exists table_field;
  54. create table table_field
  55. (
  56. -- 主键由应用侧雪花算法生成,不使用自增
  57. id BIGINT not null primary key,
  58. table_id INTEGER not null,
  59. field_name_cn TEXT,
  60. field_name_en TEXT,
  61. field_type TEXT,
  62. required INTEGER default 0 not null,
  63. field_len INTEGER default 0 not null,
  64. matched INTEGER,
  65. direction_conf TEXT,
  66. field_sort INTEGER
  67. );
  68. drop table if exists table_info;
  69. create table table_info
  70. (
  71. id INTEGER not null primary key,
  72. main_id INTEGER,
  73. table_name_cn TEXT,
  74. table_name_en TEXT,
  75. headers TEXT,
  76. classify TEXT,
  77. func_regex TEXT,
  78. line_no INTEGER default 0,
  79. has_inner INTEGER default 0,
  80. create_time DATE
  81. );
  82. DROP TABLE IF EXISTS `chat_message`;
  83. CREATE TABLE `chat_message`
  84. (
  85. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  86. `session_id` TEXT,
  87. `content` TEXT,
  88. `role` TEXT,
  89. `model_name` TEXT
  90. );
  91. DROP TABLE IF EXISTS `chat_session`;
  92. CREATE TABLE `chat_session`
  93. (
  94. `id` TEXT,
  95. `case_id` INTEGER,
  96. `session_title` TEXT,
  97. `session_content` TEXT,
  98. `conversation_id` TEXT
  99. );
  100. DROP TABLE IF EXISTS `chat_model`;
  101. CREATE TABLE `chat_model`
  102. (
  103. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  104. `category` TEXT,
  105. `model_name` TEXT,
  106. `provider_code` TEXT,
  107. `model_describe` TEXT,
  108. `model_dimension` INTEGER,
  109. `api_host` TEXT,
  110. `api_key` TEXT
  111. );
  112. DROP TABLE IF EXISTS `chat_provider`;
  113. CREATE TABLE `chat_provider`
  114. (
  115. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  116. `provider_name` TEXT,
  117. `provider_code` TEXT,
  118. `provider_icon` TEXT,
  119. `provider_desc` TEXT,
  120. `api_host` TEXT
  121. );
  122. DROP TABLE IF EXISTS `knowledge_attach`;
  123. CREATE TABLE `knowledge_attach`
  124. (
  125. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  126. `knowledge_id` INTEGER,
  127. `oss_id` INTEGER,
  128. `doc_id` TEXT,
  129. `name` TEXT,
  130. `type` TEXT
  131. );
  132. DROP TABLE IF EXISTS `knowledge_fragment`;
  133. CREATE TABLE `knowledge_fragment`
  134. (
  135. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  136. `idx` INTEGER,
  137. `doc_id` TEXT,
  138. `content` TEXT
  139. );
  140. DROP TABLE IF EXISTS `knowledge_info`;
  141. CREATE TABLE `knowledge_info`
  142. (
  143. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  144. `name` TEXT,
  145. `share` INTEGER,
  146. `description` TEXT,
  147. `separator` TEXT,
  148. `overlap_char` INTEGER,
  149. `retrieve_limit` INTEGER,
  150. `text_block_size` INTEGER,
  151. `vector_model` TEXT,
  152. `embedding_model` TEXT
  153. );