oldCms

cms2020

Tables (6)

Copy Of spt_admin_data (spt_admin_html)

  • id (menu_id) — varchar(150) — Primary key — NOT NULL
  • Key (item_id) — varchar(30) — Primary key — NOT NULL
  • Key (view_type) — enum('mobile', 'pc') — Primary key — NOT NULL
  • Field (template_id) — varchar(100)
  • attach_type (contents) — mediumtext — NOT NULL
  • byte_size (is_auto) — enum('Y', 'N') — NOT NULL
  • Field (update_date_time) — datetime
  • Field (auto_create_min_period) — int(11)

Copy Of spt_headline_item (spt_headline_data)

  • id (menu_id) — varchar(100) — Primary key — NOT NULL
  • Key (item_id) — Primary key — NOT NULL
  • Key2 (data_id) — Primary key — NOT NULL
  • Field (contents_id)
  • date_created (seq) — int(100) — NOT NULL
  • Field (title) — varchar(255)
  • Field (image) — varchar(100)
  • Field (sub_content) — varchar(100)
  • Field (score) — double

confirm_email

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • date_expired — datetime — NOT NULL
  • email — varchar(255) — NOT NULL
  • secured_key — varchar(255) — NOT NULL

spt_admin_data

  • id (menu_id) — varchar(150) — Primary key — NOT NULL
  • Key (item_id) — varchar(30) — Primary key — NOT NULL
  • attach_type (data_list) — mediumtext — NOT NULL
  • byte_size (extra_info) — text — NOT NULL
  • Field (update_date_time) — datetime

spt_admin_item

  • id (menu_id) — varchar(150) — Primary key — NOT NULL
  • version (item_list) — mediumtext — NOT NULL
  • attach_type (extra_info) — text — NOT NULL
  • byte_size (update_date_time) — datetime — NOT NULL

spt_headline_item

  • id (menu_id) — varchar(100) — Primary key — NOT NULL
  • Key (item_id) — Primary key — NOT NULL
  • date_created (seq) — int(100) — NOT NULL
  • remote_addr (display_order) — int(100)
  • Field (template_id) — varchar(100)
  • Field (content_id) — varchar(100)
  • Field (title) — varchar(255)
  • Field (section_id) — varchar(100)
  • Field (news_type) — varchar(100)
  • Field (score) — double
  • Field (item_type)
  • Field (fixed_enable)