Головна сторінка Огляд Довідка
Увійти
yp
/
pet-system
11
0
Відгалуження 0
Файли Проблеми 0 Запити на злиття 0 Wiki
Дерево: ce8828ab2d
Гілки Теги
pet-system
/
script
/
sql
/
business
/
update.sql

update.sql 22 KB
Історія Запис

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194 
  1. # 2026/02/10
    2. 

  2. ALTER TABLE `pet_system`.`sys_menu` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';
    3. 

  3. ALTER TABLE `pet_system`.`sys_user` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';
    4. 

  4. 

  5. # 2026/02/11
    6. 

  6. -- 菜单 SQL
    7. 

  7. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    8. 

  8. values(2021464069248733185, '商户分类', '6', '1', 'tenantCategories', 'system/tenantCategories/index', 1, 0, 'C', '0', '0', 'system:tenantCategories:list', '#', 103, 1, sysdate(), null, null, '商户分类菜单', 0);
    9. 

  9. 

  10. -- 按钮 SQL
    11. 

  11. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    12. 

  12. values(2021464069248733186, '商户分类查询', 2021464069248733185, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:query',        '#', 103, 1, sysdate(), null, null, '', 0);
    13. 

  13. 

  14. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    15. 

  15. values(2021464069248733187, '商户分类新增', 2021464069248733185, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:add',          '#', 103, 1, sysdate(), null, null, '', 0);
    16. 

  16. 

  17. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    18. 

  18. values(2021464069248733188, '商户分类修改', 2021464069248733185, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:edit',         '#', 103, 1, sysdate(), null, null, '', 0);
    19. 

  19. 

  20. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    21. 

  21. values(2021464069248733189, '商户分类删除', 2021464069248733185, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:remove',       '#', 103, 1, sysdate(), null, null, '', 0);
    22. 

  22. 

  23. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    24. 

  24. values(2021464069248733190, '商户分类导出', 2021464069248733185, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:export',       '#', 103, 1, sysdate(), null, null, '', 0);
    25. 

  25. 

  26. ALTER TABLE `pet_system`.`sys_tenant` ADD COLUMN `logo` bigint COMMENT '品牌LOGO';
    27. 

  27. 

  28. ALTER TABLE `pet_system`.`sys_tenant` ADD COLUMN `admin` bigint NOT NULL COMMENT '管理员';
    29. 

  29. ALTER TABLE `pet_system`.`sys_role` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';
    30. 

  30. 

  31. # 2026/02/24
    32. 

  32. -- 菜单 SQL
    33. 

  33. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    34. 

  34. values(2026190519642099713, '门店管理', '6', '1', 'store', 'system/store/index', 1, 0, 'C', '0', '0', 'system:store:list', '#', 103, 1, sysdate(), null, null, '门店管理菜单', 0);
    35. 

  35. 

  36. -- 按钮 SQL
    37. 

  37. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    38. 

  38. values(2026190519642099714, '门店管理查询', 2026190519642099713, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:store:query',        '#', 103, 1, sysdate(), null, null, '', 0);
    39. 

  39. 

  40. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    41. 

  41. values(2026190519642099715, '门店管理新增', 2026190519642099713, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:store:add',          '#', 103, 1, sysdate(), null, null, '', 0);
    42. 

  42. 

  43. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    44. 

  44. values(2026190519642099716, '门店管理修改', 2026190519642099713, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:store:edit',         '#', 103, 1, sysdate(), null, null, '', 0);
    45. 

  45. 

  46. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    47. 

  47. values(2026190519642099717, '门店管理删除', 2026190519642099713, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:store:remove',       '#', 103, 1, sysdate(), null, null, '', 0);
    48. 

  48. 

  49. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    50. 

  50. values(2026190519642099718, '门店管理导出', 2026190519642099713, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:store:export',       '#', 103, 1, sysdate(), null, null, '', 0);
    51. 

  51. 

  52. ALTER TABLE `pet_system`.`sys_dept` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';
    53. 

  53. ALTER TABLE `pet_system`.`sys_post` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';
    54. 

  54. 

  55. # 2026/02/25
    56. 

  56. -- 菜单 SQL
    57. 

  57. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    58. 

  58. values(2026533580326912001, '服务列表', '2020736413590941698', '1', 'list', 'service/list/index', 1, 0, 'C', '0', '0', 'service:list:list', '#', 103, 1, sysdate(), null, null, '服务列表菜单', 0);
    59. 

  59. 

  60. -- 按钮 SQL
    61. 

  61. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    62. 

  62. values(2026533580326912002, '服务列表查询', 2026533580326912001, '1',  '#', '', 1, 0, 'F', '0', '0', 'service:list:query',        '#', 103, 1, sysdate(), null, null, '', 0);
    63. 

  63. 

  64. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    65. 

  65. values(2026533580326912003, '服务列表新增', 2026533580326912001, '2',  '#', '', 1, 0, 'F', '0', '0', 'service:list:add',          '#', 103, 1, sysdate(), null, null, '', 0);
    66. 

  66. 

  67. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    68. 

  68. values(2026533580326912004, '服务列表修改', 2026533580326912001, '3',  '#', '', 1, 0, 'F', '0', '0', 'service:list:edit',         '#', 103, 1, sysdate(), null, null, '', 0);
    69. 

  69. 

  70. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    71. 

  71. values(2026533580326912005, '服务列表删除', 2026533580326912001, '4',  '#', '', 1, 0, 'F', '0', '0', 'service:list:remove',       '#', 103, 1, sysdate(), null, null, '', 0);
    72. 

  72. 

  73. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    74. 

  74. values(2026533580326912006, '服务列表导出', 2026533580326912001, '5',  '#', '', 1, 0, 'F', '0', '0', 'service:list:export',       '#', 103, 1, sysdate(), null, null, '', 0);
    75. 

  75. 

  76. -- 菜单 SQL
    77. 

  77. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    78. 

  78. values(2021464069248733192, '商户分类', '6', '12', 'tenantCategories', 'system/tenantCategories/index', 1, 0, 'C', '0', '0', 'system:tenantCategories:list', '#', 103, 1, sysdate(), null, null, '商户分类菜单', 0);
    79. 

  79. 

  80. -- 按钮 SQL
    81. 

  81. -- 菜单 SQL
    82. 

  82. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    83. 

  83. values(2026556930960998402, '区域站点', '1', '1', 'areaStation', 'system/areaStation/index', 1, 0, 'C', '0', '0', 'system:areaStation:list', '#', 103, 1, sysdate(), null, null, '区域站点菜单', 0);
    84. 

  84. 

  85. -- 按钮 SQL
    86. 

  86. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    87. 

  87. values(2026556930960998403, '区域站点查询', 2026556930960998402, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:query',        '#', 103, 1, sysdate(), null, null, '', 0);
    88. 

  88. 

  89. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    90. 

  90. values(2026556930960998404, '区域站点新增', 2026556930960998402, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:add',          '#', 103, 1, sysdate(), null, null, '', 0);
    91. 

  91. 

  92. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    93. 

  93. values(2026556930960998405, '区域站点修改', 2026556930960998402, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:edit',         '#', 103, 1, sysdate(), null, null, '', 0);
    94. 

  94. 

  95. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    96. 

  96. values(2026556930960998406, '区域站点删除', 2026556930960998402, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:remove',       '#', 103, 1, sysdate(), null, null, '', 0);
    97. 

  97. 

  98. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    99. 

  99. values(2026556930960998407, '区域站点导出', 2026556930960998402, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:export',       '#', 103, 1, sysdate(), null, null, '', 0);
    100. 

  100. 

  101. # 2026/02/26
    102. 

  102. -- 菜单 SQL
    103. 

  103. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    104. 

  104. values(2026924472514756609, '短信配置', '1', '12', 'smsConfig', 'resource/smsConfig/index', 1, 0, 'C', '0', '0', 'resource:smsConfig:list', '#', 103, 1, sysdate(), null, null, '短信配置菜单', 0);
    105. 

  105. 

  106. -- 按钮 SQL
    107. 

  107. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    108. 

  108. values(2026924472514756610, '短信配置查询', 2026924472514756609, '1',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:query',        '#', 103, 1, sysdate(), null, null, '', 0);
    109. 

  109. 

  110. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    111. 

  111. values(2026924472514756611, '短信配置新增', 2026924472514756609, '2',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:add',          '#', 103, 1, sysdate(), null, null, '', 0);
    112. 

  112. 

  113. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    114. 

  114. values(2026924472514756612, '短信配置修改', 2026924472514756609, '3',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:edit',         '#', 103, 1, sysdate(), null, null, '', 0);
    115. 

  115. 

  116. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    117. 

  117. values(2026924472514756613, '短信配置删除', 2026924472514756609, '4',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:remove',       '#', 103, 1, sysdate(), null, null, '', 0);
    118. 

  118. 

  119. insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
    120. 

  120. values(2026924472514756614, '短信配置导出', 2026924472514756609, '5',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:export',       '#', 103, 1, sysdate(), null, null, '', 0);
    121. 

  121. 

  122. # 2026/02/27 档案管理模块 - 业务字典
    123. 

  123. -- 用户性别复用框架已有字典 sys_user_sex (0:男, 1:女, 2:未知)
    124. 

  124. -- 字典类型
    125. 

  125. insert into sys_dict_type values(101, '000000', '用户状态',   'sys_customer_status',   103, 1, sysdate(), null, null, '用户档案状态');
    126. 

  126. insert into sys_dict_type values(102, '000000', '宠物类型',   'sys_pet_type',          103, 1, sysdate(), null, null, '宠物类型列表');
    127. 

  127. insert into sys_dict_type values(103, '000000', '宠物性别',   'sys_pet_gender',        103, 1, sysdate(), null, null, '宠物性别列表');
    128. 

  128. insert into sys_dict_type values(104, '000000', '宠物体型',   'sys_pet_size',          103, 1, sysdate(), null, null, '宠物体型列表');
    129. 

  129. insert into sys_dict_type values(105, '000000', '房屋类型',   'sys_house_type',        103, 1, sysdate(), null, null, '房屋类型列表');
    130. 

  130. insert into sys_dict_type values(106, '000000', '入门方式',   'sys_entry_method',      103, 1, sysdate(), null, null, '入门方式列表');
    131. 

  131. insert into sys_dict_type values(107, '000000', '标签颜色',   'sys_tag_color_type',    103, 1, sysdate(), null, null, '标签颜色样式');
    132. 

  132. insert into sys_dict_type values(108, '000000', '宠物品种',   'sys_pet_breed',         103, 1, sysdate(), null, null, '宠物品种列表');
    133. 

  133. 

  134. -- 字典数据: 用户状态 sys_customer_status
    135. 

  135. insert into sys_dict_data values(103, '000000', 1, '正常', '0', 'sys_customer_status', '', 'primary', 'Y', 103, 1, sysdate(), null, null, '');
    136. 

  136. insert into sys_dict_data values(104, '000000', 2, '冻结', '1', 'sys_customer_status', '', 'danger',  'N', 103, 1, sysdate(), null, null, '');
    137. 

  137. 

  138. -- 字典数据: 宠物类型 sys_pet_type
    139. 

  139. insert into sys_dict_data values(105, '000000', 1, '猫',   '1', 'sys_pet_type', '', '',        'N', 103, 1, sysdate(), null, null, '');
    140. 

  140. insert into sys_dict_data values(106, '000000', 2, '狗',   '2', 'sys_pet_type', '', '',        'N', 103, 1, sysdate(), null, null, '');
    141. 

  141. insert into sys_dict_data values(107, '000000', 3, '其他', '3', 'sys_pet_type', '', '',        'N', 103, 1, sysdate(), null, null, '');
    142. 

  142. 

  143. -- 字典数据: 宠物性别 sys_pet_gender
    144. 

  144. insert into sys_dict_data values(108, '000000', 1, '公', '1', 'sys_pet_gender', '', '',        'N', 103, 1, sysdate(), null, null, '');
    145. 

  145. insert into sys_dict_data values(109, '000000', 2, '母', '2', 'sys_pet_gender', '', '',        'N', 103, 1, sysdate(), null, null, '');
    146. 

  146. 

  147. -- 字典数据: 宠物体型 sys_pet_size
    148. 

  148. insert into sys_dict_data values(110, '000000', 1, '小型', 'small',  'sys_pet_size', '', '',        'N', 103, 1, sysdate(), null, null, '');
    149. 

  149. insert into sys_dict_data values(111, '000000', 2, '中型', 'medium', 'sys_pet_size', '', '',        'N', 103, 1, sysdate(), null, null, '');
    150. 

  150. insert into sys_dict_data values(112, '000000', 3, '大型', 'large',  'sys_pet_size', '', '',        'N', 103, 1, sysdate(), null, null, '');
    151. 

  151. 

  152. -- 字典数据: 房屋类型 sys_house_type
    153. 

  153. insert into sys_dict_data values(113, '000000', 1, '楼梯', 'stairs',   'sys_house_type', '', '',        'N', 103, 1, sysdate(), null, null, '');
    154. 

  154. insert into sys_dict_data values(114, '000000', 2, '电梯', 'elevator', 'sys_house_type', '', '',        'N', 103, 1, sysdate(), null, null, '');
    155. 

  155. 

  156. -- 字典数据: 入门方式 sys_entry_method
    157. 

  157. insert into sys_dict_data values(115, '000000', 1, '密码开门', 'password', 'sys_entry_method', '', '',        'N', 103, 1, sysdate(), null, null, '');
    158. 

  158. insert into sys_dict_data values(116, '000000', 2, '钥匙开门', 'key',      'sys_entry_method', '', '',        'N', 103, 1, sysdate(), null, null, '');
    159. 

  159. 

  160. -- 字典数据: 标签颜色 sys_tag_color_type
    161. 

  161. insert into sys_dict_data values(117, '000000', 1, '默认',  'info',    'sys_tag_color_type', '', 'info',    'Y', 103, 1, sysdate(), null, null, '');
    162. 

  162. insert into sys_dict_data values(118, '000000', 2, '主要',  'primary', 'sys_tag_color_type', '', 'primary', 'N', 103, 1, sysdate(), null, null, '');
    163. 

  163. insert into sys_dict_data values(119, '000000', 3, '成功',  'success', 'sys_tag_color_type', '', 'success', 'N', 103, 1, sysdate(), null, null, '');
    164. 

  164. insert into sys_dict_data values(120, '000000', 4, '警告',  'warning', 'sys_tag_color_type', '', 'warning', 'N', 103, 1, sysdate(), null, null, '');
    165. 

  165. insert into sys_dict_data values(121, '000000', 5, '危险',  'danger',  'sys_tag_color_type', '', 'danger',  'N', 103, 1, sysdate(), null, null, '');
    166. 

  166. 

  167. -- 字典数据: 宠物品种 sys_pet_breed (value=品种名称，后续可在字典管理中自行增删)
    168. 

  168. insert into sys_dict_data values(122, '000000', 1,  '金毛',           '金毛',           'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    169. 

  169. insert into sys_dict_data values(123, '000000', 2,  '拉布拉多',       '拉布拉多',       'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    170. 

  170. insert into sys_dict_data values(124, '000000', 3,  '柴犬',           '柴犬',           'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    171. 

  171. insert into sys_dict_data values(125, '000000', 4,  '柯基',           '柯基',           'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    172. 

  172. insert into sys_dict_data values(126, '000000', 5,  '哈士奇',         '哈士奇',         'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    173. 

  173. insert into sys_dict_data values(127, '000000', 6,  '阿拉斯加',       '阿拉斯加',       'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    174. 

  174. insert into sys_dict_data values(128, '000000', 7,  '萨摩耶',         '萨摩耶',         'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    175. 

  175. insert into sys_dict_data values(129, '000000', 8,  '边境牧羊犬',     '边境牧羊犬',     'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    176. 

  176. insert into sys_dict_data values(130, '000000', 9,  '德国牧羊犬',     '德国牧羊犬',     'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    177. 

  177. insert into sys_dict_data values(131, '000000', 10, '贵宾犬/泰迪',    '贵宾犬/泰迪',    'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    178. 

  178. insert into sys_dict_data values(132, '000000', 11, '比熊',           '比熊',           'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    179. 

  179. insert into sys_dict_data values(133, '000000', 12, '博美',           '博美',           'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    180. 

  180. insert into sys_dict_data values(134, '000000', 13, '雪纳瑞',         '雪纳瑞',         'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    181. 

  181. insert into sys_dict_data values(135, '000000', 14, '法斗',           '法斗',           'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    182. 

  182. insert into sys_dict_data values(136, '000000', 15, '中华田园犬',     '中华田园犬',     'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    183. 

  183. insert into sys_dict_data values(137, '000000', 16, '英短',           '英短',           'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    184. 

  184. insert into sys_dict_data values(138, '000000', 17, '美短',           '美短',           'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    185. 

  185. insert into sys_dict_data values(139, '000000', 18, '布偶猫',         '布偶猫',         'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    186. 

  186. insert into sys_dict_data values(140, '000000', 19, '加菲猫',         '加菲猫',         'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    187. 

  187. insert into sys_dict_data values(141, '000000', 20, '暹罗猫',         '暹罗猫',         'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    188. 

  188. insert into sys_dict_data values(142, '000000', 21, '波斯猫',         '波斯猫',         'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    189. 

  189. insert into sys_dict_data values(143, '000000', 22, '缅因猫',         '缅因猫',         'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    190. 

  190. insert into sys_dict_data values(144, '000000', 23, '中华田园猫',     '中华田园猫',     'sys_pet_breed', '', '', 'N', 103, 1, sysdate(), null, null, '');
    191. 

  191. 

  192. # 2026/02/28
    193. 

  193. -- 门店信息加入区域编码
    194. 

  194. ALTER TABLE `pet_system`.`sys_store` ADD COLUMN `area_code` varchar(255) NOT NULL COMMENT '区域编码';
    195.