Developer's Manual  Database Structure  Content tables

Content tables

SiteSupra stores content separately for every language. In addition, SiteSupra uses two different tables for storing content of public and edit websites.

A content table name has the following format: pages_LangMode
where Lang is language abbreviation and Mode is SiteSupra mode. The abbreviation should be the same as it is configured in .htsupra file in $suLANG array. Mode is either 0 (public mode) or 1 (edit mode).

Field Type Description
id int(11) unsigned, auto increment Unique page id, auto increment. Primary index.
parent int(11) unsigned Id of page parent. Indexed field.
sort varchar(256) Sort order in a folder page is located in (binary value). Used in SORT BY clause to retrieve pages in the order they are stored in the folder. Indexed field.
sorttype tinyint(3) unsigned Sort type for child pages. Sort type is set from SiteMap window.
childs smallint(5) unsigned Number of child pages.
path varchar(255) Relative page path. The path does not include domain name and language. Indexed field.
active tinyint(3) unsigned Page status. A page can be active or inactive.
map tinyint(3) unsigned Bitwise value. Zero bit contains map checkbox state. First bit contains search checkbox state.
title varchar(255) Page title.
short text Short description of a page.
date datetime Initially the field stores date when a page created. Later on, SiteSupra user can change the value of the field.
template longtext Page template. The template is an array that is stored incompressed and serialized way.
blocks longtext Page blocks. The field blocks stores array of blocks inserted to a page. The array is stored in compressed and serialized way.
custom longtext Custom properties of a page. The properties are stored in serialized way.
search longtext Contains text formatted for search engine. See Searching in SiteSupra Content Tables for more details. Full text search index.
redirect varchar(64) The field stores URL address or ID of the page a SiteSupra will redirected site visitor to.
owner tinyint(3) unsigned ID of SiteSupra user who created the page. See Table auth.
chger tinyint(3) unsigned ID of SiteSupra user who modified the page last time. See Table auth.
cdate datetime Date of page creation.
udate datetime Date of last modification.
cache text Page cache. For itnernal use only.
userint int(11) See Using of userint, userbit, and userstr for more details. Indexed field.
userbit int(11) See Using of userint, userbit, and userstr for more details. Indexed field.
userstr varchar(255) See Using of userint, userbit, and userstr for more details. Indexed filed.
status int(11) For internal use only.
data longtext For internal use only.
Please login to add comments.