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)