建站资讯

关于 twcms 转 lecms 数据表的变动

来源:站长源码网 作者:小瓶盖 时间:2026-07-05
浏览:7 收藏 点赞(0)
简介:数据表的变动: 1、不再每个模型使用单独的评论和评论排序表,lecms是所有的内容模型共用评论和评论排序表(毕竟评论功能用的不多,没必要再每个模型使用单独的) # 内容评论排序表 用来减小主表索引 (有评论时才写入) DROP TABLE IF EXISTS pre_cms_comment_sort; CREATE TA

数据表变动

1、不再每个模型使用单独的评论和评论排序表,lecms是所有的内容模型共用评论和评论排序表(毕竟评论功能用的不多,没必要再每个模型使用单独的)

# 内容评论排序表 用来减小主表索引 (有评论时才写入)
DROP TABLE IF EXISTS pre_cms_comment_sort;
CREATE TABLE pre_cms_comment_sort (
  mid tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '模型ID',
  id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容ID',
  cid int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
  comments int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论数',
  lastdate int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后回复时间',
  UNIQUE KEY mid_id (mid,id),
  KEY cid_comments (cid,comments),
  KEY comments (comments),
  KEY cid_lastdate (cid,lastdate),
  KEY lastdate (lastdate)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

# 内容评论表 该功能用的不多 所有的模型内容评论都写入此表
DROP TABLE IF EXISTS pre_cms_comment;
CREATE TABLE pre_cms_comment (
  commentid int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '评论ID',
  mid tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '模型ID',
  id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容ID',
  uid int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  author varchar(20) NOT NULL DEFAULT '' COMMENT '作者',
  content varchar(255) NOT NULL DEFAULT '' COMMENT '评论内容',
  ip int(10) NOT NULL DEFAULT '0' COMMENT 'IP',
  dateline int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发表时间',
  reply_commentid int(10) unsigned NOT NULL DEFAULT '0' COMMENT '回复某评论ID',
  PRIMARY KEY  (commentid),
  KEY mid_id (mid,id),
  KEY ip (ip,commentid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

2、内容模型主表,比如 pre_cms_article,删掉 color 字段,增加 jumpurl 字段,另外有几个字段长度有变动。

ALTER TABLE pre_cms_article DROP `color`;

ALTER TABLE pre_cms_article ADD jumpurl varchar(255) NOT NULL DEFAULT '' COMMENT '跳转URL';

ALTER TABLE pre_cms_article CHANGE `seo_title` `seo_title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

ALTER TABLE pre_cms_article CHANGE `seo_keywords` `seo_keywords` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

ALTER TABLE pre_cms_article CHANGE `seo_description` `seo_description` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

ALTER TABLE pre_cms_article CHANGE `cid` `cid` INT(10) UNSIGNED NOT NULL DEFAULT '0';

3、内容模型附件表,比如 pre_cms_article_attach,增加了 积分 金币 字段,cid字段长度变动。

ALTER TABLE pre_cms_article_attach ADD credits int(10) unsigned NOT NULL DEFAULT '0' COMMENT '积分';

ALTER TABLE pre_cms_article_attach ADD golds int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金币';

ALTER TABLE pre_cms_article_attach CHANGE `cid` `cid` INT(10) UNSIGNED NOT NULL DEFAULT '0';

4、内容模型标签表,比如 pre_cms_article_tag,增加了 pic SEO信息字段,name、content字段变动。

ALTER TABLE pre_cms_article_tag CHANGE `name` `name` CHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

ALTER TABLE pre_cms_article_tag CHANGE `content` `content` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

ALTER TABLE pre_cms_article_tag ADD pic varchar(255) NOT NULL DEFAULT '' COMMENT '标签缩略图';

ALTER TABLE pre_cms_article_tag ADD seo_title varchar(100) NOT NULL DEFAULT '' COMMENT 'SEO标题';

ALTER TABLE pre_cms_article_tag ADD seo_keywords varchar(200) NOT NULL DEFAULT '' COMMENT 'SEO关键词';

ALTER TABLE pre_cms_article_tag ADD seo_description varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO描述';

5、内容模型浏览量表,比如 pre_cms_article_views,cid字段变动。

ALTER TABLE pre_cms_article_views CHANGE `cid` `cid` INT(10) UNSIGNED NOT NULL DEFAULT '0';

6、单页表、伪静态别名表 cid字段变动

ALTER TABLE pre_cms_page CHANGE `cid` `cid` INT(10) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE pre_only_alias CHANGE `cid` `cid` INT(10) UNSIGNED NOT NULL DEFAULT '0';

7、模型表增加字段(模型内容缩略图宽度、高度、以及菜单图标)

ALTER TABLE pre_models ADD width smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '缩略图宽度';

ALTER TABLE pre_models ADD height smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '缩略图高度';

ALTER TABLE pre_models ADD icon varchar(30) NOT NULL DEFAULT 'fa fa-bars' COMMENT '后台菜单图标';

8、增加了模型字段表(自定义模型字段使用)

CREATE TABLE IF NOT EXISTS pre_models_field (
  id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  mid tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '模型ID',
  field char(20) NOT NULL DEFAULT '' COMMENT '字段名',
  name varchar(30) NOT NULL DEFAULT '' COMMENT '显示名',
  inputtype varchar(20) NOT NULL DEFAULT '' COMMENT '类型',
  tips varchar(255) NOT NULL DEFAULT '' COMMENT '提示',
  setting mediumtext NOT NULL COMMENT '设置',
  isbase tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否主表(0附表,1主表)',
  required tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否必填',
  orderby int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (id),
  KEY (mid),
  UNIQUE KEY mid_field (mid,field)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

9、分类表增加了 pic 和 投稿 字段,以及部分字段变动

ALTER TABLE pre_category ADD contribute tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '允许投稿';

ALTER TABLE pre_category ADD pic varchar(255) NOT NULL DEFAULT '' COMMENT '分类图';

ALTER TABLE pre_category CHANGE `cid` `cid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE pre_category CHANGE `orderby` `orderby` INT(10) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE pre_category CHANGE `seo_title` `seo_title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

ALTER TABLE pre_category CHANGE `seo_keywords` `seo_keywords` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

ALTER TABLE pre_category CHANGE `seo_description` `seo_description` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

10、用户组表增加两条用户组信息

INSERT INTO pre_user_group  (`groupid`, `groupname`, `system`, `purviews`) VALUES (10, '永久VIP', 1, ''),(12, 'VIP用户', 1, '');

11、用户表增加和删除字段、以及部分字段变动

ALTER TABLE pre_user ADD author varchar(20) NOT NULL DEFAULT '' COMMENT '昵称';
ALTER TABLE pre_user ADD credits int(10) unsigned NOT NULL DEFAULT '0' COMMENT '积分';
ALTER TABLE pre_user ADD golds int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金币';
ALTER TABLE pre_user ADD mobile varchar(20) NOT NULL DEFAULT '' COMMENT '手机号';
ALTER TABLE pre_user ADD avatar varchar(255) NOT NULL DEFAULT '' COMMENT '头像';

ALTER TABLE pre_user DROP comments;

ALTER TABLE pre_user CHANGE `homepage` `homepage` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE pre_user CHANGE `intro` `intro` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

12、kv表和runtime表字段变动

ALTER TABLE pre_kv CHANGE `v` `v` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE pre_runtime CHANGE `v` `v` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

你可以直接在 twcms后台安装插件转换哦: 传送门

在线
客服
1.2718
基本信息
SQL
$_GET
$_POST
$_COOKIE
包含文件
自动加载
  1. 模型: /www/wwwroot/adminhtml.com/lecms/model/
  2. 视图: /www/wwwroot/adminhtml.com/view/facai_down/jiaocheng_show.htm
  3. 控制器: /www/wwwroot/adminhtml.com/lecms/control/show_control.class.php
  4. 日志目录: /www/wwwroot/adminhtml.com/log/
  5. 当前页面: /www/wwwroot/adminhtml.com/index.php
  6. 当前时间: 2026-07-06 05:03:01
  7. 当前网协: 216.73.216.193
  8. 请求路径: /web/37.html
  9. 运行时间: 1.2718
  10. 内存开销: 1.55 MB
  1. #0 [time:0.0002s] SELECT * FROM le_runtime WHERE k='cfg' LIMIT 1
  2. #1 [time:0.0002s] SELECT * FROM le_runtime WHERE k='cate_7' LIMIT 1
  3. #2 [time:0.0007s] SELECT * FROM le_cms_jiaocheng WHERE id='37' LIMIT 1
  4. #3 [time:0.0004s] SELECT * FROM le_user WHERE uid='4' LIMIT 1
  5. #4 [time:0.0003s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=37 LIMIT 1
  6. #5 [time:0.0003s] SELECT * FROM le_cms_jiaocheng_data WHERE id='37' LIMIT 1
  7. #6 [time:0.0002s] SELECT groupid,groupname FROM le_user_group ORDER BY groupid ASC
  8. #7 [time:0.0002s] SELECT * FROM le_cms_jiaocheng_views WHERE id='37' LIMIT 1
  9. #8 [time:0.0024s] UPDATE LOW_PRIORITY le_cms_jiaocheng_views SET views=views+1 WHERE id='37' LIMIT 1
  10. #9 [time:0.0003s] SELECT id FROM le_cms_jiaocheng WHERE cid='7' AND id<'37' ORDER BY id DESC LIMIT 0,1
  11. #10 [time:0.0002s] SELECT * FROM le_cms_jiaocheng WHERE id='36'
  12. #11 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=36 LIMIT 1
  13. #12 [time:0.0003s] SELECT id FROM le_cms_jiaocheng WHERE cid='7' AND id>'37' ORDER BY id ASC LIMIT 0,1
  14. #13 [time:0.0002s] SELECT * FROM le_cms_jiaocheng WHERE id='38'
  15. #14 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=38 LIMIT 1
  16. #15 [time:0.0002s] SELECT * FROM le_kv WHERE k='navigate' LIMIT 1
  17. #16 [time:0.0001s] SELECT id FROM le_cms_jiaocheng_views ORDER BY views DESC LIMIT 0,8
  18. #17 [time:0.0002s] SELECT * FROM le_cms_jiaocheng_views WHERE id='109' OR id='91' OR id='86' OR id='83' OR id='71' OR id='70' OR id='69' OR id='64'
  19. #18 [time:0.0004s] SELECT * FROM le_cms_jiaocheng WHERE id='109' OR id='91' OR id='86' OR id='83' OR id='71' OR id='70' OR id='69' OR id='64'
  20. #19 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=109 LIMIT 1
  21. #20 [time:0.0003s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=91 LIMIT 1
  22. #21 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=86 LIMIT 1
  23. #22 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=83 LIMIT 1
  24. #23 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=71 LIMIT 1
  25. #24 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=70 LIMIT 1
  26. #25 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=69 LIMIT 1
  27. #26 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=64 LIMIT 1
  28. #27 [time:0.0002s] SELECT id FROM le_cms_jiaocheng ORDER BY id DESC LIMIT 0,5
  29. #28 [time:0.0003s] SELECT * FROM le_cms_jiaocheng WHERE id='112' OR id='111' OR id='110' OR id='109' OR id='108'
  30. #29 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=112 LIMIT 1
  31. #30 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=111 LIMIT 1
  32. #31 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=110 LIMIT 1
  33. #32 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=108 LIMIT 1
  34. #33 [time:0.0002s] SELECT id FROM le_cms_jiaocheng ORDER BY comments DESC LIMIT 0,5
  35. #34 [time:0.0003s] SELECT * FROM le_cms_jiaocheng WHERE id='1' OR id='2' OR id='3' OR id='4' OR id='5'
  36. #35 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=1 LIMIT 1
  37. #36 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=2 LIMIT 1
  38. #37 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=3 LIMIT 1
  39. #38 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=4 LIMIT 1
  40. #39 [time:0.0002s] SELECT * FROM le_facai_download_meta WHERE mid=3 AND id=5 LIMIT 1
  41. #40 [time:0.0001s] SELECT id FROM le_cms_jiaocheng_views ORDER BY views DESC LIMIT 0,5
  42. #41 [time:0.0002s] SELECT * FROM le_cms_jiaocheng_views WHERE id='109' OR id='91' OR id='86' OR id='83' OR id='71'
  43. #42 [time:0.0004s] SELECT * FROM le_cms_jiaocheng WHERE id='109' OR id='91' OR id='86' OR id='83' OR id='71'
  44. #43 [time:0.0003s] SELECT * FROM le_runtime WHERE k='5ffa307eeba53cd70486f886c39224f3' LIMIT 1
  45. #44 [time:0.0002s] SELECT * FROM le_runtime WHERE k='3321412b3916183dbc141b62fd638bf0' LIMIT 1
  46. #45 [time:0.0002s] SELECT * FROM le_runtime WHERE k='b37fc51586ded1371d640e6f8bb8a6c2' LIMIT 1
  47. #46 [time:0.0002s] SELECT * FROM le_runtime WHERE k='d67332cae4b3af9465005ad9ac27ad42' LIMIT 1
  48. #47 [time:0.0001s] SELECT id FROM le_links ORDER BY id DESC LIMIT 0,10
  49. #48 [time:0.0002s] SELECT * FROM le_links WHERE id='4' OR id='3' OR id='2' OR id='1'
  1. #control => show
  2. #action => index
  3. #cid => 7
  4. #id => 37
  5. #mid => 2
    1. #server_session_29d964de => c08643b748b42fd31a13e29a7064947e
    2. #PHPSESSID => jcr9s2dm0irtbjiqnrbsr38rae
    1. #0 /www/wwwroot/adminhtml.com/index.php
    2. #1 /www/wwwroot/adminhtml.com/lecms/xiunophp/xiunophp.php
    3. #2 /www/wwwroot/adminhtml.com/lecms/config/config.inc.php
    4. #3 /www/wwwroot/adminhtml.com/lecms/xiunophp/lib/base.func.php
    5. #4 /www/wwwroot/adminhtml.com/lecms/xiunophp/lib/core.class.php
    6. #5 /www/wwwroot/adminhtml.com/lecms/xiunophp/lib/debug.class.php
    7. #6 /www/wwwroot/adminhtml.com/lecms/xiunophp/lib/log.class.php
    8. #7 /www/wwwroot/adminhtml.com/lecms/xiunophp/lib/model.class.php
    9. #8 /www/wwwroot/adminhtml.com/lecms/xiunophp/lib/view.class.php
    10. #9 /www/wwwroot/adminhtml.com/lecms/xiunophp/lib/control.class.php
    11. #10 /www/wwwroot/adminhtml.com/lecms/xiunophp/db/db.interface.php
    12. #11 /www/wwwroot/adminhtml.com/lecms/xiunophp/db/db_pdo_mysql.class.php
    13. #12 /www/wwwroot/adminhtml.com/lecms/xiunophp/cache/cache.interface.php
    14. #13 /www/wwwroot/adminhtml.com/lecms/xiunophp/cache/cache_memcache.class.php
    15. #14 /www/wwwroot/adminhtml.com/lecms/xiunophp/ext/network/Network__interface.php
    16. #15 /www/wwwroot/adminhtml.com/lecms/config/plugin.inc.php
    17. #16 /www/wwwroot/adminhtml.com/lecms/plugin/editor_tinymce/conf.php
    18. #17 /www/wwwroot/adminhtml.com/lecms/plugin/editor_um/conf.php
    19. #18 /www/wwwroot/adminhtml.com/lecms/plugin/facai_download_meta/conf.php
    20. #19 /www/wwwroot/adminhtml.com/lecms/plugin/facai_thumb_beautify/conf.php
    21. #20 /www/wwwroot/adminhtml.com/lecms/plugin/le_category_filter/conf.php
    22. #21 /www/wwwroot/adminhtml.com/lecms/plugin/le_content_tag_url/conf.php
    23. #22 /www/wwwroot/adminhtml.com/lecms/plugin/le_data_table_split/conf.php
    24. #23 /www/wwwroot/adminhtml.com/lecms/plugin/le_drafts/conf.php
    25. #24 /www/wwwroot/adminhtml.com/lecms/plugin/le_html_cache/conf.php
    26. #25 /www/wwwroot/adminhtml.com/lecms/plugin/le_links/conf.php
    27. #26 /www/wwwroot/adminhtml.com/lecms/plugin/le_pic_list/conf.php
    28. #27 /www/wwwroot/adminhtml.com/lecms/plugin/le_rand404content/conf.php
    29. #28 /www/wwwroot/adminhtml.com/lecms/plugin/le_rand_author/conf.php
    30. #29 /www/wwwroot/adminhtml.com/lecms/plugin/le_rand_pic_cid/conf.php
    31. #30 /www/wwwroot/adminhtml.com/lecms/plugin/le_slide/conf.php
    32. #31 /www/wwwroot/adminhtml.com/lecms/plugin/le_title_pic/conf.php
    33. #32 /www/wwwroot/adminhtml.com/lecms/plugin/le_use_del_id/conf.php
    34. #33 /www/wwwroot/adminhtml.com/lecms/plugin/le_webp_oss/conf.php
    35. #34 /www/wwwroot/adminhtml.com/lecms/plugin/le_zhanqunsitemaps_pro_v303/conf.php
    36. #35 /www/wwwroot/adminhtml.com/lecms/plugin/lu_huochetou/conf.php
    37. #36 /www/wwwroot/adminhtml.com/lecms/plugin/sj_paidToReadForGolds/conf.php
    38. #37 /www/wwwroot/adminhtml.com/lecms/plugin/sj_rainbow_pay/conf.php
    39. #38 /www/wwwroot/adminhtml.com/runcache/misc.func.php
    40. #39 /www/wwwroot/adminhtml.com/runcache/core_lang/zh-cn.php
    41. #40 /www/wwwroot/adminhtml.com/runcache/lang/zh-cn.php
    42. #41 /www/wwwroot/adminhtml.com/runcache/lecms_control/parseurl_control.class.php
    43. #42 /www/wwwroot/adminhtml.com/runcache/lecms_model/runtime_model.class.php
    44. #43 /www/wwwroot/adminhtml.com/runcache/lecms_control/show_control.class.php
    45. #44 /www/wwwroot/adminhtml.com/runcache/lecms_control/base_control.class.php
    46. #45 /www/wwwroot/adminhtml.com/runcache/lecms_model/user_model.class.php
    47. #46 /www/wwwroot/adminhtml.com/runcache/lecms_model/urls_model.class.php
    48. #47 /www/wwwroot/adminhtml.com/runcache/lecms_model/category_model.class.php
    49. #48 /www/wwwroot/adminhtml.com/runcache/lecms_model/cms_content_model.class.php
    50. #49 /www/wwwroot/adminhtml.com/runcache/lecms_view/facai_down,jiaocheng_show.htm.php
    51. #50 /www/wwwroot/adminhtml.com/runcache/lecms_model/cms_content_data_model.class.php
    52. #51 /www/wwwroot/adminhtml.com/runcache/lecms_model/cms_content_tag_model.class.php
    53. #52 /www/wwwroot/adminhtml.com/lecms/plugin/facai_download_meta/facai_download_meta.func.php
    54. #53 /www/wwwroot/adminhtml.com/runcache/lecms_model/kv_model.class.php
    55. #54 /www/wwwroot/adminhtml.com/runcache/lecms_model/cms_content_views_model.class.php
    56. #55 /www/wwwroot/adminhtml.com/lecms/xiunophp/ext/utf8.class.php
    57. #56 /www/wwwroot/adminhtml.com/runcache/lecms_model/links_model.class.php
    58. #57 /www/wwwroot/adminhtml.com/lecms/xiunophp/tpl/sys_trace.php
    1. #0 utf8 类