MySQL tabeller og felter i Instans CMS

Tabel	Beskrivelse
ACTIVITY_LOG	Monitor activities f.instance google ping
ATTACHMENTS	Deprecated, replaced by RELATED_CONTENT
BLOGPOSTS	Holds blogposts for all BLOGS
BLOGS	Holds all blogs created in the blog manager module
BOOKMATRICES	Deprecated (module bookmaker). Indeholder tema matricer
BOOKS	Deprecated (module bookmaker). Indeholder bog-stamdata
BOOKSECTIONS	Deprecated (module bookmaker). Bog kapitler og afsnit.
BOOKSTYLES	Deprecated (module bookmaker). Bog stylesheet.
BOOKTEMPLATES	Deprecated (module bookmaker). Bog-browser templates
BOX_SETTINGS	Where to show boxes (standard and custom)
CALENDARS	Holds calendars / event archives
CART_CONTENTS	Holds shopping cart items/orderlines
CART_ORDERS	Shopping-cart orders
CART_ORDERSTATUS	Holds possible orderstates
CART_ORDERS_ORDERSTATUS	Intersection table to join CART_ORDERS and CART_ORDERSTATUS
CART_PAYMENTTERMS	Holds possible payment terms
CMS_SITEDOMAINS	Table holds all domains used for this CMS installation
CMS_UPGRADES	Log of CMS upgrades performed automatically
COMMENTS	Holds comments, f.instance blog-comments
CUSTOMFIELDATTRIBUTES	Holds attributes for custom field types
CUSTOMFIELDDATA	Holds data for custom fields
CUSTOMFIELDS	Holds custom field definitions
CUSTOMFIELDTYPES	Holds custom field types
CUSTOM_BOXES	Customboxes displayed by the customBoxes template function
DATA_PERMISSIONS	Holds permission-settings to access specific data.
DEBATE	Deprecated
DEFINED_FORMFIELDS	Holds field-definitions for DEFINED_FORMS
DEFINED_FORMS	Holds forms created in Module: formeditor2
EMAIL_WHITELIST	Automatically approve comments from people on whitelist
EVENTS	Holds calendar events
FILEARCHIVE_FILES	Holds files in filearchive
FILEARCHIVE_FOLDERS	Holds filearchive folders
FILEARCHIVE_TYPE	Holds filetypes for use in filearchive
GALLERIES	Deprecated
GENERAL_SETTINGS	Site-wide settings editable in cms
GRANTS	Holds temporary grants used to view unpublished pages.
GROUPS	Holds usergroups
GROUPS_FORMFIELDS	Holds formfields for user self-registration form
GROUPS_PAGES	Holds frontend access restriction for pages
GROUPS_PERMISSIONS	Holds relation between usergroups and permissions in CMS
LANGUAGES	Holds languages. Find translatons in cms_baselanguage
MENUS	Holds website menus / page archives
NEWS	Holds newsitems
NEWSFEEDS	Holds newsarchives
NEWSLETTERS	Holds newsletter mailouts
NEWSLETTER_CATEGORIES	Newsletter interestgroup-items
NEWSLETTER_CATEGORIES_OPTOUT	Holds records of users opted out of interestgroup-items
NEWSLETTER_CATEGORYGROUPS	Newsletter interestgroups
NEWSLETTER_FORMFIELDS	Also used to hold formfields used when subscribing to GROUPS
NEWSLETTER_HISTORY	Holds history of newsletter mailings
NEWSLETTER_HISTORY_MAILLOG	Holds log of every mail sent to users through the newsletter
NEWSLETTER_ITEMS	Holds newsletter items (mail elements)
NEWSLETTER_NEWSLETTER_CATEGORIES	Send newsletter to subscribers not opted out of these cats
NEWSLETTER_STATS	Holds stats for newsletter opened/clicked items
NEWSLETTER_SUBSCRIPTIONS	Holds newsletter subscribtions
NEWSLETTER_TEMPLATES	Holds newsletters (templates for actual newsletter mailouts)
NEWSLETTER_TEMPLATES_CATEGORYGROUPS	Use these interest groups on the newsletter template
NEWSLETTER_TEMPLATES_FORMFIELDS	Formfields on newsletter subscription form
NEWSLETTER_TEMPLATES_USERGROUPS	Subscribed usergroups (in addition to subscribers)
PAGES	Holds pages
PAGES_FORMS	Intersection table, relates DEFINED_FORMS to PAGES
PERMISSIONGROUPS	Holds permission groups for use in CMS
PERMISSIONS	Holds permissions
PICTUREARCHIVE_FOLDERS	Holds imagearchive folders
PICTUREARCHIVE_IMPORTQUE	Holds import que used when importing images from dropbox
PICTUREARCHIVE_PICS	Holds imagearchive images
PINGCHECK	USED TO ENFORCE PING INTERVAL
RELATED_CONTENT	Intersection table to relate one content-item to another
REWRITE_KEYWORDS	Holds keywords for rewriting URLs
REWRITE_METHODS	Holds rewrite methods used in URLs
REWRITE_MODES	Holds MODES for rewriting URLs
SHOP_GROUPDISCOUNTS	Holds group discounts used in shop
SHOP_ORDERDETAILS	Holds orderdetails / orderlines for completed orders
SHOP_ORDERS	Holds completed shop orders
SHOP_ORDERSEQ	Holds sequence of order numbers
SHOP_PRODUCTGROUPS	Table to hold shop product groups
SHOP_PRODUCTGROUPS_FORMFIELDS	Holds information on which formfields to show for each produ
SHOP_PRODUCTS	Table holds shop products
SHOP_PRODUCTS_COLLI	Table to hold shop product collis
SHOP_PRODUCTS_GROUPS	Holds product-group association
SHOP_PRODUCTS_QUALITIES	Holds shop product qualities
SHOP_PRODUCTS_USERS	Holds association of SHOP_PRODUCTS and USERS for use in diff
SHOP_RELATED_PRODUCTS	Holds information on related products
SHOP_USERPRICES	Holds specific user prices
SITES	Holds sites managed by cms installation
TAGS	Tags used
TAG_REFERENCES	Intersection table to tag content items
TEMPLATES	Holds templates for use in CMS
TILMELDINGER	Holds data collected by DEFINED_FORMS (sorry)
USERS	Holds all cms users, website users, newsletter subscribers
USERS_GROUPS	Intersection table to include and position users in groups
USERS_VARIED_FIELDS	Holds userdata that vary across groups, see cms_config.inc.p

Tabel: ACTIVITY_LOG

Monitor activities f.instance google ping

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
NAME	text	NO				Name of activity being logged
LASTRUN	datetime	NO		0000-00-00 00:00:00		Start of last run
LASTRUN_COMPLETE	datetime	NO		0000-00-00 00:00:00		End of last run
DESCRIPTION	text	NO
STATUS	text	NO

Tabel: ATTACHMENTS

Deprecated, replaced by RELATED_CONTENT

Name	Type	Null	Key	Default	Extra	Comment
PAGE_ID	int(11)	NO		0
FILE_ID	int(11)	NO		0
TABEL	text	NO

Tabel: BLOGPOSTS

Holds blogposts for all BLOGS

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
BLOG_ID	int(11)	NO		0		Refers to BLOGS.ID
PUBLISHED	tinyint(1)	NO		0
HEADING	text	NO
CONTENT	text	NO
CONTENTSNIPPET	text	NO				Optional summary of content
COMMENTS_ALLOWED	tinyint(1)	NO		0		Allow comments on blogpost
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID
CREATED_DATE	datetime	NO		0000-00-00 00:00:00
CHANGED_BY	int(11)	NO		0
CHANGED_DATE	datetime	NO		0000-00-00 00:00:00
PUBLISHED_DATE	datetime	NO		0000-00-00 00:00:00
UNFINISHED	tinyint(1)	NO		0
DELETED	tinyint(1)	NO		0

Tabel: BLOGS

Holds all blogs created in the blog manager module

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
SITE_ID	int(11)	NO		0		Refers to SITES.ID
TEMPLATE_ID	int(11)	NO		0		Refers to TEMPLATES.ID
PUBLISHED	tinyint(1)	NO		0
TITLE	text	NO
SUBTITLE	text	NO
DESCRIPTION	text	NO
COMMENTS_ALLOWED	tinyint(1)	NO		0		Allow comments to be turned on for inividual posts
COMMENTS_STRIPTAGS	text	NO				Strip these tags from comments eg.
COMMENTS_EMAIL	tinyint(1)	NO		0		Send comments to this email
APPROVECOMMENTS	tinyint(1)	NO		0		Require comments to be approved before showing them on the site
SPAMPREVENT_AKISMETKEY	text	NO				Optional Akismet key, for spam-prevention
SPAMPREVENT_CAPTCHA	tinyint(1)	NO		0		Use a captcha for spam-prevention
SYNDICATION_ALLOWED	tinyint(1)	NO		0		Publish rss feed
SYNDICATION_SHOWCOMPLETEPOST	tinyint(4)	NO		0		Include entire posts in rss feed
SYNDICATION_SNIPPETLENGTH	int(11)	NO		0		Length in number of sentences
SYNDICATION_KEY	text	NO				Key used in rss feed filename - change it to kick all subscribers
CREATED_DATE	datetime	NO		0000-00-00 00:00:00
CHANGED_DATE	datetime	NO		0000-00-00 00:00:00
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID
UNFINISHED	tinyint(1)	NO		0
LANGUAGE_ID	int(11)	NO		0		Refers to LANGUAGES.ID
SHOW_PROFILEIMAGE	tinyint(1)	NO		0
SHOW_COMPLETEPOST	tinyint(1)	NO		0		Show complete posts on blog frontpage
DELETED	tinyint(1)	NO		0
ITEMS_DISPLAYCOUNT	int(11)	NO		0		Number of blog-entries to display on blog frontpage

Tabel: BOOKMATRICES

Deprecated (module bookmaker). Indeholder tema matricer

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
BOOK_ID	int(11)	NO		0
MATRIX_TITLE	text	NO
MATRIX_CONTENT	text	YES
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
CHANGED_BY	int(11)	YES
DELETED	char(1)	NO		N

Tabel: BOOKS

Deprecated (module bookmaker). Indeholder bog-stamdata

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
BOOKTITLE	text	NO
SUBTITLE	text	YES
PUBLISHER	text	YES
PUBMONTH	tinyint(2)	YES
PUBYEAR	smallint(4)	YES
PUBLISHED	tinyint(1)	YES
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
DELETED	char(1)	NO		N
CHANGED_BY	int(11)	YES
PICTUREFOLDER_ID	int(11)	NO		0

Tabel: BOOKSECTIONS

Deprecated (module bookmaker). Bog kapitler og afsnit.

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
BOOK_ID	int(11)	NO		0
PARENT_ID	int(11)	NO		0
SECTIONTHREAD_ID	int(11)	NO		0
POSITION	int(11)	NO		0
TITLE	text	NO
CONTENT	text	NO
CONTENT_SIDE	text	NO
DELETED	char(1)	NO		N
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
CHANGED_BY	int(11)	YES

Tabel: BOOKSTYLES

Deprecated (module bookmaker). Bog stylesheet.

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
BOOK_ID	int(11)	NO		0
HEADING_FONT	text	YES
MAIN_FONT	text	YES
SIDEBAR_FONT	text	YES
CAPTION_FONT	text	YES
ILL_BORDERWIDTH	int(11)	NO		0
ILL_BORDERCOLOUR	int(11)	NO		0
NUMBER_TO	tinyint(4)	NO		0
SHOW_TOGETHER_FROM	tinyint(4)	NO		0
SHOW_PARENT_LINKS	tinyint(4)	NO		0
SHOW_CHAPTER_FRONTPAGES	char(1)	NO		N
COVERIMAGE_URL	text	NO
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
CHANGED_BY	int(11)	NO		0

Tabel: BOOKTEMPLATES

Deprecated (module bookmaker). Bog-browser templates

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO		0
BOOK_ID	int(11)	NO		0
TEMPLATE_HTML	text	NO
TEMPLATE_CSS	text	NO
CREATED_DATE	text	NO
CHANGED_DATE	text	NO

Tabel: BOX_SETTINGS

Where to show boxes (standard and custom)

Name	Type	Null	Key	Default	Extra	Comment
PAGE_ID	int(11)	NO		0		Page that has boxes shown/hidden. Refers to PAGES.ID
CUSTOM	text	NO				Deprecated, custom boxes are related using RELATED_CONTENT
NEWS	tinyint(4)	NO		0		Show (1) / Hide (0) newsbox on PAGE_ID
EVENTS	tinyint(4)	NO		0		Show (1) / Hide (0) calendarbox on PAGE_ID
SEARCH	tinyint(4)	NO		0		Show (1) / Hide (0) searchbox on PAGE_ID
STF	tinyint(4)	NO		0		Show (1) / Hide (0) send-to-friend box on PAGE_ID
NEWSLETTER	tinyint(4)	NO		0		Deprecated, show/hide newsletter box
LASTEDITED	tinyint(4)	NO		0		Show (1) / Hide (0) last-edited box on PAGE_ID

Tabel: CALENDARS

Holds calendars / event archives

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
NAME	text	NO				Name of calendar
SITE_ID	int(11)	NO		0		Refers to SITES.ID / 0 = kan vises på alle sites
DEFAULT_LANGUAGE	int(11)	NO		0		Refers to LANGUAGES.ID

Tabel: CART_CONTENTS

Holds shopping cart items/orderlines

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
CART_ORDERS_ID	int(11)	NO		0		Refers to CART_ORDERS.ID
CART_ID	text	NO				Deprecated, show/hide newsletter box
PRODUCT_ID	int(11)	NO		0		Refers to SHOP_PRODUCTS.ID
PRODUCT_TABLENAME	text	NO				Name of product table. Usually SHOP_PRODUCTS but override is possible in cms_config
COLLI_ID	int(11)	NO		0		Refers to SHOP_PRODUCTS_COLLI.ID
AMOUNT	int(11)	NO		0		Quantity added to cart
FRAGT	float	NO		0		Freight price if calculated per item
DELIVERY_DAYS	int(11)	NO		0		Days until delivery, if calculated per item
CUSTOM_PRICE	float	NO		0		Custom price if calculated
CUSTOM_DESCRIPTION	text	NO				Custom description for customized items
TIME_ADDED	int(11)	NO		0		time added to cart, unix timestamp

Tabel: CART_ORDERS

Shopping-cart orders

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
UNIQUE_ORDERID	text	NO				Deprecated. Autogenerated unique order id
CART_ID	text	NO				Cookie/session id used to reload cart on revisit
USER_ID	int(11)	NO		0		User logged in while shopping. Refers to USERS.ID
NAME	text	NO
ADDRESS	text	NO
CITY	text	NO
ZIPCODE	int(11)	NO		0
PHONE	text	NO
CELLPHONE	text	NO
FAX	text	NO
EMAIL	text	NO
NOTES	text	NO
COMPANY	text	NO
VAT_NUMBER	text	NO
ATTENTION	text	NO
PAYMENTTERM	int(11)	NO		0		Refers to CART_PAYMENTTERMS.ID
DELIVERYNAME	text	NO
DELIVERYADDRESS	text	NO
DELIVERYZIPCODE	text	NO
DELIVERYCITY	text	NO
DELETED	tinyint(4)	NO		0		Cart orders are deleted upon checkout / transfer to SHOP_ORDERS
DELIVERYCOMPANY	text	NO

Tabel: CART_ORDERSTATUS

Holds possible orderstates

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
NAME	text	NO

Tabel: CART_ORDERS_ORDERSTATUS

Intersection table to join CART_ORDERS and CART_ORDERSTATUS

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
ORDER_ID	int(11)	NO		0		Refers to CART_ORDERS.ID
ORDERSTATUS_ID	int(11)	NO		0		Refers to CART_ORDERSTATUS.ID
CREATED_DATE	int(11)	NO		0		Time status was set, unix timestamp

Tabel: CART_PAYMENTTERMS

Holds possible payment terms

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
TITLE	text	NO				Name of payment term
PERMISSION	text	NO				Name of permission needed by logged in user to select this payment term. Refers to PERMISSIONS.NAME
IS_CARDPAYMENT	tinyint(1)	NO		0		If a paymentterm with IS_PAYMENT = 1 is chosen, user is presented with card-entry-step (not fully implemented)
POSITION	int(11)	NO		0		Paymentterms are ordered by POSITION

Tabel: CMS_SITEDOMAINS

Table holds all domains used for this CMS installation

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
SITE_ID	int(11)	NO		0		Refers til SITES.ID
SUBDOMAIN	text	NO				Subdomain (www f.instance) or wildcard (*)
DOMAIN	text	NO				Example: mydomain.com
DEFAULT	tinyint(1)	NO		0		Set one domain as default per site
REDIRECT	int(11)	NO		0		Redirect requests for this subdomain.domain to this row. Refers to CMS_SITEDOMAINS.ID
PREFERRED_FOR_LANGUAGE	int(11)	YES				Set to language_id if domain is preferred for site/language combination. Only set each language once per site.
LANGUAGE	int(11)	NO		0		Refers to LANGUAGES.ID. Set this language as default for this domain
REDIRECT_TO_URL	text	NO				Redirect to external url. Only use if REDIRECT is 0

Tabel: CMS_UPGRADES

Log of CMS upgrades performed automatically

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
UPGRADE_ID	text	NO
UPGRADE_DESCRIPTION	text	NO
UPGRADE_BEGIN	datetime	NO		0000-00-00 00:00:00
UPGRADE_END	datetime	NO		0000-00-00 00:00:00
USER_LOGGED_IN	int(11)	NO		0		Contains ID of user logged in when performing upgrade
CMS_VERSION	text	NO				CMS version at the time of upgrade
CMS_BUILD	text	NO				CMS build at the time of upgrade
COMMENTS	text	NO				Comments added by the upgrade process

Tabel: COMMENTS

Holds comments, f.instance blog-comments

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
TABLENAME	text	NO				Name of table to which holds the item being commented
REQUEST_ID	int(11)	NO		0		Refers to TABLENAME.ID - the id of the item being commented
COMMENT	text	NO				The comment
COMMENTER_ID	int(11)	NO		0		If commenter is logged in, this refers to USERS.ID
COMMENTER_NAME	text	NO				Name of commenter
COMMENTER_EMAIL	text	NO				E-mail of commenter
COMMENTER_URL	text	NO				Website of commenter
APPROVED	tinyint(1)	NO		0		Comment approved yes(1) / no (0)
IS_SPAM	tinyint(1)	NO		0		Marked as span (1) / ham (0) by spam prevention measures or by admin-user
CREATED_DATE	datetime	NO		0000-00-00 00:00:00
DELETED	tinyint(1)	NO		0

Tabel: CUSTOMFIELDATTRIBUTES

Holds attributes for custom field types

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
CUSTOMFIELDTYPE_ID	int(11)	NO		0		Refers to CUSTOMFIELDTYPES.ID
ATTRIBUTENAME	text	NO
ATTRIBUTEKEY	text	NO				Key used as a unique attribute identifyer in combination with CUSTOMFIELD_ID
ATTRIBUTETYPE	text	NO				Valid attributetypes are INT/TEXT/TEXTAREA/TEXTEDITOR/DROPDOWN/RADIOGROUP/IMAGESELECTOR/IMAGEARCHIVE/FILEARCHIVE or defined in custom_customfieldattributes.inc.php
OPTIONS	text	NO				option1___value1|||option2___value2 etc... (Only valid for types DROPDOWN and RADIOGROUP)
DEFAULTVALUE	text	NO
POSITION	int(11)	NO		0		Attributes are ordered by POSITION within each customfield
PREFERENCES	text	NO

Tabel: CUSTOMFIELDDATA

Holds data for custom fields

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
CUSTOMFIELD_ID	int(11)	NO		0		Refers to CUSTOMFIELDS.ID
ATTRIBUTE_ID	int(11)	NO		0		Refers to CUSTOMFIELDATTRIBUTES.ID
REQUEST_ID	int(11)	NO		0		Refers to ID of item with customfield. Table is defined in CUSTOMFIELDS.TABLENAME
VALUE	text	NO

Tabel: CUSTOMFIELDS

Holds custom field definitions

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
TEMPLATE_ID	int(11)	NO		0		Refers to TEMPLATES.ID, Use 0 for all templates
TABLENAME	text	NO				Show customfield on rows in this table. Currently only implemented for PAGES
DESCRIPTION	text	NO				Description of the custom field, displayed as a heading when editing
FIELDKEY	text	NO				Use a unique key to refer to this customfield in the template
TYPE_ID	int(11)	NO		0		Refers to CUSTOMFIELDTYPES.ID
POSITION	int(11)	NO		0		Customfields are displayed in the "Specialfelter"-tab ordered by POSITION
DELETED	int(11)	NO		0

Tabel: CUSTOMFIELDTYPES

Holds custom field types

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
TYPENAME	text	NO

Tabel: CUSTOM_BOXES

Customboxes displayed by the customBoxes template function

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
TYPE	tinyint(4)	NO		0		1 = fritekst / 2 = linkboks
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID
TITLE	text	NO
HEADING	text	NO
HEADING_BGCOL	text	NO
HEADING_TEXTCOL	text	NO
CONTENT	text	NO
CONTENT_BGCOL	text	NO
CONTENT_TEXTCOL	text	NO
UNFINISHED	tinyint(4)	NO		0
SITE_ID	int(11)	NO		0		Refers til SITES.ID / 0 = all sites

Tabel: DATA_PERMISSIONS

Holds permission-settings to access specific data.

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
USER_ID	int(11)	NO		0		Refers to USERS.ID. Used if datapermission is granted to individual user.
GROUP_ID	int(11)	NO		0		Refers to GROUPS.ID. Used when datapermission is granted to a usergroup
DATA_TABLE_NAME	text	NO				Permission granted for a row in this table
DATA_ID	int(11)	NO		0		Permission granted for this id on DATA_TABLE_NAME
PERMISSION_ID	int(11)	NO		0		Refers to PERMISSIONS.ID

Tabel: DEBATE

Deprecated

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
PARENT_ID	int(11)	NO		0
AUTHOR_ID	int(11)	NO		0
GROUP_ID	int(11)	NO		0
HEADING	text	NO
CONTENT	text	NO
DATE	text	NO
THREAD_ID	int(11)	NO		0

Tabel: DEFINED_FORMFIELDS

Holds field-definitions for DEFINED_FORMS

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
FORM_ID	int(11)	NO		0		Refers to DEFINED_FORMS.ID
FIELDTYPE	tinyint(4)	NO		0
CAPTION	text	NO
TEXT_SIZE	int(11)	NO		0
TEXT_MAXLENGTH	int(11)	NO		0
TEXT_DEFAULTTEXT	text	NO
TEXTAREA_COLS	int(11)	NO		0
TEXTAREA_ROWS	int(11)	NO		0
TEXTAREA_MAXLENGTH	int(11)	NO		0
TEXTAREA_DEFAULTTEXT	text	NO
RADIO_COUNT	int(11)	NO		0
RADIO_CAPTIONS	text	NO
RADIO_DISABLEDSTATES	text	NO
RADIO_SLETTETSTATES	text	NO
CHECKBOX_COUNT	int(11)	NO		0
CHECKBOX_CAPTIONS	text	NO
CHECKBOX_DISABLEDSTATES	text	NO
CHECKBOX_SLETTETSTATES	text	NO
CHECKBOX_MINFILLED	int(11)	NO		0
CHECKBOX_MAXFILLED	int(11)	NO		0
VERIFY_FILLED	tinyint(4)	NO		0
VERIFY_EMAIL	tinyint(4)	NO		0
VERIFY_NUMBER	tinyint(4)	NO		0
DISABLED	tinyint(4)	NO		0
READONLY	tinyint(4)	NO		0
EMAIL_MODTAGER	tinyint(4)	NO		0
POSITION	int(11)	NO		0
DELETED	tinyint(4)	NO		0
HELPTEXT	text	NO
MAPPED_FIELD_ID	int(11)	NO		0
LOCKED	tinyint(4)	NO		0

Tabel: DEFINED_FORMS

Holds forms created in Module: formeditor2

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
TITLE	text	NO
EMAIL	text	NO
CREATED_DATE	text	NO
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID
INTROTEXT	text	NO
ENDTEXT	text	NO
FORM_OPENDATE	date	NO		0000-00-00
FORM_CLOSEDATE	date	NO		0000-00-00
LINKTEXT	text	NO
SITE_ID	int(11)	NO		0		Refers to SITES.ID / 0 = kan vises på alle sites
SEND_MAIL	tinyint(4)	NO		0
SAVE_IN_DB	tinyint(4)	NO		0
DELETED	tinyint(1)	NO		0
MAPPED_NEWSLETTER_ID	int(11)	NO		0		Refers to NEWSLETTER_TEMPLATES.ID
MAPPED_USERGROUP_ID	int(11)	NO		0
SPAMPREVENT_CAPTCHA	tinyint(1)	NO		0

Tabel: EMAIL_WHITELIST

Automatically approve comments from people on whitelist

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
EMAIL	text	NO
TABLENAME	text	NO				Address whitelisted for a row in this table
REQUEST_ID	int(11)	NO		0		Address whitelisted for this id on TABLENAME

Tabel: EVENTS

Holds calendar events

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
TITLE	text	NO
HEADING	text	NO
SUBHEADING	text	NO
CONTENT	text	NO
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
UNFINISHED	tinyint(4)	NO		0
DELETED	tinyint(4)	NO		0
BEING_EDITED	tinyint(4)	NO		0		Deprecated
PUBLISHED	tinyint(4)	NO		0
LOCKED_BY_USER	tinyint(4)	NO		0		Deprecated
DURATION	tinyint(4)	NO		0		Deprecated
STARTDATE	date	NO		0000-00-00
ENDDATE	date	NO		0000-00-00
TIMEOFDAY	text	NO
CALENDAR_ID	int(11)	NO		0		Refers to CALENDARS.ID
SITE_ID	int(11)	NO		0		Refers to SITES.ID
LANGUAGE	int(11)	NO		0		Refers to LANGUAGES.ID
GLOBAL_STATUS	tinyint(4)	NO		0		Show on all sites
FOCUSEVENT	tinyint(1)	NO		0		Used to put focus on the event, can be used in plugins to draw out only focused elements or for css
IMAGE_ID	int(11)	NO		0		Used for event list-image

Tabel: FILEARCHIVE_FILES

Holds files in filearchive

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
FOLDER_ID	int(11)	NO		0		Refers to FILEARCHIVE_FOLDERS.ID
FILENAME	text	NO
ORIGINAL_FILENAME	text	NO
CREATED_DATE	text	NO
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID
TITLE	text	NO
DESCRIPTION	text	NO
EXTENSION	text	NO
MIMETYPE	text	NO
FILETYPE_ID	int(11)	NO		1		Refers to FILEARCHIVE_TYPE.ID

Tabel: FILEARCHIVE_FOLDERS

Holds filearchive folders

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
TITLE	text	NO
FOLDERNAME	text	NO
CREATED_DATE	text	NO
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID
PRIVATE	tinyint(4)	NO		0		Deprecated
SITE_ID	int(11)	NO		0		Refers to SITES.ID / 0 = kan vises på alle sites
PARENT_ID	int(11)	NO		0		ID of parent folder
PUBLIC_FOLDER	tinyint(1)	NO		0		Allow folder to be displayed on the website as a gallery (mode=picturearchive)
FOLDER_DESCRIPTION	text	NO
THREAD_ID	int(11)	NO		0		ID of top folder
LEVEL	int(11)	NO		0		Folder nested LEVELs deep

Tabel: FILEARCHIVE_TYPE

Holds filetypes for use in filearchive

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
INTERNAL_NAME	text	NO
ICON_PATH	text	NO
DESCRIPTION	text	NO

Tabel: GALLERIES

Deprecated

Name	Type	Null	Key	Default	Extra	Comment
PAGE_ID	int(11)	NO		0
FOLDER_ID	int(11)	NO		0
TABEL	text	NO

Tabel: GENERAL_SETTINGS

Site-wide settings editable in cms

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO		0		Refers to SITES.ID
META_DESCRIPTION	text	NO				Default meta description
META_KEYWORDS	text	NO				Defailt meta keywords
META_TITLE_USEPAGESCOLUMN	text	NO				Default setting for page title
CONTACT_EMAILS	text	NO
NEWSLETTER_GROUPID	int(11)	YES				Holds ID of the usergroup containing newsletter subscribers

Tabel: GRANTS

Holds temporary grants used to view unpublished pages.

Name	Type	Null	Key	Default	Extra	Comment
PAGE_ID	int(11)	NO		0		Refers to PAGES.ID
GRANTCODE	text	NO
USER_ID	int(11)	NO		0		Refers to USERS.ID

Tabel: GROUPS

Holds usergroups

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
PARENT_ID	int(11)	NO		0
GROUP_NAME	text	NO
DESCRIPTION	text	NO
AUTHOR_ID	int(11)	NO		0
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
UNFINISHED	tinyint(4)	NO		0
HIDDEN	tinyint(1)	NO		0		Hide group from all lists
DELETED	tinyint(4)	NO		0
REGISTRATION_OPEN	tinyint(4)	NO		0
EDITING_OPEN	tinyint(4)	NO		0
NOTIFY_USER_ID	int(11)	NO		0
LANDING_GROUP_ID	int(11)	NO		0
USERLIST_OPEN	tinyint(4)	NO		0
DEFAULT_CONTENT_IDENTIFIER	text	NO
SORT_BY	text	NO
SITE_ID	int(11)	NO		0
LOGIN_TO_URL	text	NO

Tabel: GROUPS_FORMFIELDS

Holds formfields for user self-registration form

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
GROUP_ID	int(11)	NO		0		Refers to GROUPS.ID
FIELD_ID	int(11)	NO		0		Refers to NEWSLETTER_FORMFIELDS.ID (sorry)
MANDATORY	tinyint(4)	NO		0

Tabel: GROUPS_PAGES

Holds frontend access restriction for pages

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
GROUP_ID	int(11)	NO		0		Refers to GROUPS.ID
PAGE_ID	int(11)	NO		0		Refers to PAGES.ID

Tabel: GROUPS_PERMISSIONS

Holds relation between usergroups and permissions in CMS

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
GROUPS_ID	int(11)	NO		0		Refers to GROUPS.ID
PERMISSIONS_ID	int(11)	NO		0		Refers to PERMISSIONS.ID

Tabel: LANGUAGES

Holds languages. Find translatons in cms_baselanguage

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
NAME	text	NO				Name of language
SHORTNAME	text	NO				Two-letter shortname matching shortname in cms_baselanguage.inc.php

Tabel: MENUS

Holds website menus / page archives

Name	Type	Null	Key	Default	Extra	Comment
MENU_ID	int(11)	NO	MUL		auto_increment
MENU_TITLE	text	NO
DEFAULT_LANGUAGE	int(11)	NO		0		Refers to LANGUAGES.ID
SITE_ID	int(11)	NO		0		Refers to SITES.ID / 0 = kan vises på alle sites

Tabel: NEWS

Holds newsitems

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
NEWSFEED_ID	int(11)	NO		0		Refers to NEWSFEEDS.ID
TITLE	text	NO
HEADING	text	NO
SUBHEADING	text	NO
CONTENT	text	NO
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID. Used if datapermission is granted to individual user.
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
UNFINISHED	tinyint(4)	NO		0
DELETED	tinyint(4)	NO		0
BEING_EDITED	tinyint(4)	NO		0		Deprecated
PUBLISHED	tinyint(4)	NO		0
LOCKED_BY_USER	tinyint(4)	NO		0		Deprecated
NEWS_DATE	date	NO		0000-00-00
FRONTPAGE_STATUS	tinyint(4)	NO		0		Show newsitem on frontpage
LIMITED	tinyint(4)	NO		0		Show newsitem within a timespan
LIMIT_START	date	NO		0000-00-00
LIMIT_END	date	NO		0000-00-00
SITE_ID	int(11)	NO		0		Refers to SITES.ID
LANGUAGE	int(11)	NO		0		Refers to LANGUAGES.ID
GLOBAL_STATUS	tinyint(4)	NO		0		Show on all sites
IMAGE_ID	int(11)	NO		0		Newsitem image. Refers to PICTUREARCHIVE_PICS.ID

Tabel: NEWSFEEDS

Holds newsarchives

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
NAME	text	NO
SITE_ID	int(11)	NO		0		0 = kan vises på alle sites
DEFAULT_LANGUAGE	int(11)	NO		0
SYNDICATION_SHOWCOMPLETEPOST	tinyint(1)	NO		1		Include complete newsitems in rss feed
SYNDICATION_SNIPPETLENGTH	int(11)	NO		5		Length of snippet, number of sentences
SYNDICATION_ALLOWED	tinyint(1)	NO		0		Publish rss feed
SYNDICATION_KEY	text	NO				Key used in rss feed filename - change it to kick all subscribers
SHOW_IMAGES	tinyint(1)	NO		0		Show images in newsarchive (not implemented)

Tabel: NEWSLETTERS

Holds newsletter mailouts

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
ARCHIVE_TITLE	text	NO
TITLE	text	NO
CONTENT_TOP	text	NO
CONTENT_BOTTOM	text	NO
IMAGES_DISPLAY	text	NO				Value is: NONE, LEFT, RIGHT or ALTERNATING
TEMPLATE_ID	int(11)	NO		0		Refers to row in NEWSLETTER_TEMPLATES table
PROOF_TO	text	NO				Holds e-mail adress to recieve the proof
APPROVED	tinyint(1)	NO		0		Only approved newsletters can be sent out
APPROVED_BY	int(11)	NO		0
APPROVED_TIME	text	NO
DELETED	tinyint(1)	NO		0
SHOW_INDEX	tinyint(4)	NO		0		Show newsitem index in mail

Tabel: NEWSLETTER_CATEGORIES

Newsletter interestgroup-items

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
GROUP_ID	int(11)	NO		0		Refers to NEWSLETTER_CATEGORYGROUPS.ID
NAME	text	NO
DELETED	tinyint(4)	NO		0

Tabel: NEWSLETTER_CATEGORIES_OPTOUT

Holds records of users opted out of interestgroup-items

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
TEMPLATE_ID	int(11)	NO		0		Refers to NEWSLETTER_TEMPLATES.ID
USER_ID	int(11)	NO		0		Refers to USERS.ID
CATEGORY_ID	int(11)	NO		0		Refers to NEWSLETTER_CATEGORIES.ID

Tabel: NEWSLETTER_CATEGORYGROUPS

Newsletter interestgroups

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
NAME	text	NO
DELETED	tinyint(4)	NO		0
SITE_ID	int(11)	NO		0		Refers to SITES.ID

Tabel: NEWSLETTER_FORMFIELDS

Also used to hold formfields used when subscribing to GROUPS

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
FIELD_NAME	text	NO
TABLE_NAME	text	NO
ID_COLUMN_NAME	text	NO
TEMPLATE_TAG	text	NO
POSITION	int(11)	NO		0
TEMPLATETAG_ONLY	tinyint(4)	NO		0
CMS_LABEL	text	NO
DEFAULT_VALUE	text	NO				Holds $cmsLang[key]-key for translating

Tabel: NEWSLETTER_HISTORY

Holds history of newsletter mailings

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
NEWSLETTER_ID	int(11)	NO		0		Refers to NEWSLETTERS.ID
TEMPLATE_ID	int(11)	NO		0		newsletter_templates.id
USER_ID	int(11)	NO		0		id of user who sent the mail
NO_RECIPIENTS	int(11)	NO		0
SENDOUT_BEGINTIME	timestamp	NO		CURRENT_TIMESTAMP
SENDOUT_COMPLETETIME	timestamp	NO		0000-00-00 00:00:00
SENDOUT_SUBJECT	text	NO
SENDOUT_HTML	text	NO
SENDOUT_PLAINTEXT	text	NO

Tabel: NEWSLETTER_HISTORY_MAILLOG

Holds log of every mail sent to users through the newsletter

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
HISTORY_ID	int(11)	NO		0		Refers to NEWSLETTER_HISTORY.ID
USER_ID	int(11)	NO		0		Refers to USERS.ID
SENDOUT_COMPLETED	tinyint(1)	NO		0
SENDOUT_COMPLETETIME	timestamp	NO		0000-00-00 00:00:00

Tabel: NEWSLETTER_ITEMS

Holds newsletter items (mail elements)

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
CREATED_BY	int(11)	NO		0
TEMPORARY	int(11)	NO		0
NEWSLETTER_ID	int(11)	NO		0		Refers to NEWSLETTER.ID
ORIGINAL_ID	int(11)	NO		0
ORIGINAL_TYPE	text	NO
HEADING	text	NO
CONTENT	text	NO
IMAGEMODE	text	NO
IMAGEURL	text	NO
LINKMODE	text	NO
LINKURL	text	NO
POSITION	int(11)	NO		0		Items are shown in newsletter sorted by POSITION asc
DELETED	tinyint(1)	NO		0

Tabel: NEWSLETTER_NEWSLETTER_CATEGORIES

Send newsletter to subscribers not opted out of these cats

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
NEWSLETTER_ID	int(11)	NO		0		Refers to NEWSLETTERS.ID
CATEGORY_ID	int(11)	NO		0		Refers to NEWSLETTER_CATEGORIES.ID
USER_ID	int(11)	NO		0		NOTE! This holds user_id of user who created intersection from newsletter. Used for deleting temporary items
TEMPORARY	tinyint(1)	NO		0

Tabel: NEWSLETTER_STATS

Holds stats for newsletter opened/clicked items

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
NEWSLETTER_ID	int(11)	NO		0		Refers to NEWSLETTERS.ID
USER_ID	int(11)	NO		0		Refers to USERS.ID
USER_ACTION	text	NO
TABLENAME	text	NO
REQUEST_ID	int(11)	NO		0
CLICKED_URL	text	NO
TIMES_REPEATED	int(11)	NO		0
CREATED_DATE	datetime	NO		0000-00-00 00:00:00
CHANGED_DATE	datetime	NO		0000-00-00 00:00:00

Tabel: NEWSLETTER_SUBSCRIPTIONS

Holds newsletter subscribtions

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
USER_ID	int(11)	NO		0		Refers to USERS.ID
TEMPLATE_ID	int(11)	NO		0		Refers to NEWSLETTER_TEMPLATES.ID
SUBSCRIBED	tinyint(4)	NO		0		User is subscribed (1) or unsubscribed (0)
CHANGED_DATE	int(11)	NO		0
CONFIRMED	tinyint(4)	NO		0		Usr has confirmed subscription, if required for this template

Tabel: NEWSLETTER_TEMPLATES

Holds newsletters (templates for actual newsletter mailouts)

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
OPEN_FOR_SUBSCRIPTIONS	tinyint(1)	NO		0		OPen for new subscribers, 1 (yes) or 0 (no)
SHOW_IN_NEWSARCHIVE	tinyint(1)	NO		0		Show in public newsletter archive
REQ_EMAIL_VALIDATION	tinyint(1)	NO		0		Require email confirmation from new users
SENDER_NAME	text	NO
SENDER_EMAIL	text	NO
REPLYTO_EMAIL	text	NO
BOUNCETO_EMAIL	text	NO
SUBSCRIPTIONPAGE_TEXTTOP	text	NO
SUBSCRIPTIONPAGE_TEXTBOTTOM	text	NO
SUBSCRIPTIONPAGE_TEXTTHANKS	text	NO
LANGUAGE_ID	int(11)	NO		0		Refers to LANGUAGES.ID
SITE_ID	int(11)	NO		0		Refers til SITES.ID
TEMPLATE_ID	int(11)	NO		0		Refers to a template in the TEMPLATES table
TITLE	text	NO
DELETED	tinyint(1)	NO		0
NEWSUBSCRIBER_NOTIFY_EMAIL	text	NO				Notify this mail about new subscribers

Tabel: NEWSLETTER_TEMPLATES_CATEGORYGROUPS

Use these interest groups on the newsletter template

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
TEMPLATE_ID	int(11)	NO		0		Refers to NEWSLETTER_TEMPLATES.ID
CATEGORYGROUP_ID	int(11)	NO		0		Refers to NEWSLETTER_CATEGORYGROUPS.ID

Tabel: NEWSLETTER_TEMPLATES_FORMFIELDS

Formfields on newsletter subscription form

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
TEMPLATE_ID	int(11)	NO		0		Refers to NEWSLETTER_TEMPLATES.ID
FIELD_ID	int(11)	NO		0		Refers to NEWSLETTER_FORMFIELDS.ID
MANDATORY	tinyint(4)	NO		0		1 (yes) or 0 (no)

Tabel: NEWSLETTER_TEMPLATES_USERGROUPS

Subscribed usergroups (in addition to subscribers)

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
GROUP_ID	int(11)	NO		0		Refers to GROUPS.ID
TEMPLATE_ID	int(11)	NO		0		Refers to NEWSLETTER_TEMPLATES.ID

Tabel: PAGES

Holds pages

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
PARENT_ID	int(11)	NO	MUL	0		ID of parent page
THREAD_ID	int(11)	NO		0		ID of top page
MENU_ID	int(11)	NO		0		Refers to MENUS.MENU_ID
SITE_ID	int(11)	NO		0		Refers til SITES.ID
ENTRY_TYPE	tinyint(4)	NO		0		Deprecated
BREADCRUMB	text	NO				Menu title
HEADING	text	NO
SUBHEADING	text	NO
CONTENT	text	NO
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
AUTHOR_ID	int(11)	NO		0		Page created by. Refers to USERS.ID
EDIT_AUTHOR_ID	int(11)	NO		0		Page last edited by. Refers to USERS.ID
DELETED	tinyint(4)	NO		0
UNFINISHED	tinyint(4)	NO		0
PUBLISHED	tinyint(4)	NO		0
NO_DISPLAY	tinyint(4)	NO		0		Hide in menus 1 (yes) / 0 (no)
IS_FRONTPAGE	tinyint(4)	NO		0
IS_MENUPLACEHOLDER	tinyint(11)	NO		0
CHECKED_OUT	tinyint(4)	NO		0		Deprecated
CHECKED_OUT_AUTHOR	int(11)	NO		0		Deprecated
LOCKED_BY_USER	tinyint(4)	NO		0		Deprecated
LANGUAGE	int(11)	NO		0		Refers to LANGUAGES.ID
PROTECTED	tinyint(4)	NO		0		Deprecated
POSITION	int(11)	NO		0
POPUP	tinyint(4)	NO		0
POINTTOPAGE_URL	text	NO
MAILTO_ADDRESS	text	NO
BOOK_ID	int(11)	YES				Deprecated
PHP_INCLUDE_PATH	text	NO
PHP_INCLUDEAFTER_PATH	text	NO
PHP_HEADERINCLUDE_PATH	text	YES
POINTTOPAGE_ID	int(11)	NO		0		Refers to PAGES.ID
TEMPLATE	int(11)	NO		0		Refers to TEMPLATES.ID
META_DESCRIPTION	text	NO
META_KEYWORDS	text	NO
META_SEOTITLE	text	NO
REDIRECT_TO_URL	text	NO

Tabel: PAGES_FORMS

Intersection table, relates DEFINED_FORMS to PAGES

Name	Type	Null	Key	Default	Extra	Comment
PAGE_ID	int(11)	NO		0		Refers to PAGES.ID
FORM_ID	int(11)	NO		0		Refers to DEFINED_FORMS.ID
TABEL	text	NO				On which table the PAGE_ID resides (usually PAGES)
INLINE	tinyint(4)	NO		0		1 (Show inline with page content) or (0) show as related content link

Tabel: PERMISSIONGROUPS

Holds permission groups for use in CMS

Name	Type	Null	Key	Default	Extra	Comment
ID	bigint(20)	NO	PRI		auto_increment
TITLE	text	NO

Tabel: PERMISSIONS

Holds permissions

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
NAME	text	NO				Name of permission. This is a unique key used when querying the permission.
DESCRIPTION	text	NO				Description of the permission
PERMISSIONGROUPS_ID	int(11)	NO		0		Refers to PERMISSIONGROUPS.ID
IS_DATAPERMISSION	tinyint(1)	NO		0		1 if the permission is a datapermission - that is a permission that you can grant usesrs/groups with respect to certain data elements. As opposed to normal permissions that are not data-relative and are granted to usergroups only

Tabel: PICTUREARCHIVE_FOLDERS

Holds imagearchive folders

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
TITLE	text	NO
FOLDERNAME	text	NO
CREATED_DATE	text	NO
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID
PRIVATE	tinyint(4)	NO		0		Deprecated
PARENT_ID	int(11)	NO		0		ID of parent folder
PUBLIC_FOLDER	tinyint(4)	NO		0		Allow folder to display as public archive? 1 (Yes) or 0 (No)
FOLDER_DESCRIPTION	text	NO
THUMBMODE	text	NO				NEWEST eller FIRSTPOS
THREAD_ID	int(11)	NO		0		ID of top folder
LEVEL	int(11)	NO		0		Folder nested LEVELs deep
SITE_ID	int(11)	NO		0		Refers to SITES.ID, 0 = available on all sites

Tabel: PICTUREARCHIVE_IMPORTQUE

Holds import que used when importing images from dropbox

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
BATCH_NUMBER	int(11)	NO		0
TARGET_GROUP	int(11)	NO		0		Refers to PICTUREARCHIVE_FOLDERS.ID
PATH	text	NO
NAME	text	NO
EXTENSION	text	NO
SIZE	int(11)	NO		0
PROCESSED	tinyint(1)	NO		0

Tabel: PICTUREARCHIVE_PICS

Holds imagearchive images

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
FOLDER_ID	int(11)	NO		0		Refers to PICTUREARCHIVE_FOLDERS.ID
FILENAME	text	NO
ORIGINAL_FILENAME	text	NO
AUTHOR_ID	int(11)	NO		0		Refers to USERS.ID
UNFINISHED	tinyint(4)	NO		0
CREATED_DATE	text	NO
IMAGETYPE	int(11)	NO		0		1 = gif, 2 = jpg, 3 = png
QUALITY	int(11)	NO		0		jpeg compression quality, if relevant
DESCRIPTION	text	NO
ALTTEXT	text	NO
SIZE_X	int(11)	NO		0		Width in pixels
SIZE_Y	int(11)	NO		0		Height in pixels
POSITION	int(11)	NO		0		Sort order of images in folders and public galleries, POSITION asc
VIEW_COUNT	int(11)	NO		0		number of full image views in public image gallery
ORIGINAL_ARCHIVED	tinyint(1)	NO		0		1 (original file archived) or 0 (original not archived)

Tabel: PINGCHECK

USED TO ENFORCE PING INTERVAL

Name	Type	Null	Key	Default	Extra	Comment
ID	mediumint(8) unsigned	NO	PRI		auto_increment
URL	tinytext	NO
SERVER	tinytext	NO
TIMECHECKED	datetime	NO		0000-00-00 00:00:00

Tabel: RELATED_CONTENT

Intersection table to relate one content-item to another

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
SRC_TABEL	text	NO				Name of table that holds thr item to which something is related
SRC_ID	int(11)	NO		0		ID of row that holds thr item to which something is related
REL_TABEL	text	NO				Name of table that holds whatever SRC_TABLE.SRC_ID is related to
REL_ID	int(11)	NO		0		ID of item that SRC_TABLE.SRC_ID is related to
CUSTOMBOX_ID	int(11)	NO		0		Deprecated, custom boxes use same structure as other related content

Tabel: REWRITE_KEYWORDS

Holds keywords for rewriting URLs

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
KEYWORD	text	NO				Keyword which will appear in the URL
TABLENAME	text	NO				Name of table for data lookup
REQUEST_ID	int(11)	NO		0		ID to look-up in TABLENAME
SITE_ID	int(11)	NO		0		Refers to SITES.ID

Tabel: REWRITE_METHODS

Holds rewrite methods used in URLs

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
NAME	text	NO				Method to run on content, will optionally appear as last part of URLs
INTERNALNAME	text	NO
LANGUAGE_ID	int(11)	NO		0		Used when rewriting urls to ensure correct language

Tabel: REWRITE_MODES

Holds MODES for rewriting URLs

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
NAME	text	NO				Modename which will appear in URLS
INTERNALNAME	text	NO				Site-internal modename
LANGUAGE_ID	int(11)	NO		0		Used when rewriting urls to ensure correct language

Tabel: SHOP_GROUPDISCOUNTS

Holds group discounts used in shop

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
GROUP_ID	int(11)	NO		0		Refers to GROUPS.ID
DISCOUNT_PERCENTAGE	float	NO		0
CHANGED_DATE	timestamp	NO		0000-00-00 00:00:00	on update CURRENT_TIMESTAMP
PRODUCTGROUP_ID	int(11)	NO		0		Refers to SHOP_PRODUCTGROUPS.ID

Tabel: SHOP_ORDERDETAILS

Holds orderdetails / orderlines for completed orders

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
ORDERNUMBER_SEQ	int(11)	NO		0		Refers to SHOP_ORDERS.ORDERNUMBER_SEQ
ORIGINAL_COOKIE_ID	text	NO				Copied from CART_ORDERS.CART_ID
PRODUCT_ID	int(11)	NO		0		Refers to SHOP_PRODUCTS.ID
PRODUCT_TABLENAME	text	NO
AMOUNT	int(11)	NO		0		Quantity
FRAGT	float	NO		0
FROZEN_PRODUCTNUMBER	text	NO
FROZEN_PRODUCTNAME	text	NO
FROZEN_PRODUCTDESCRIPTION	text	NO
FROZEN_PRODUCTPRICE	float	NO		0
FROZEN_GROUPDISCOUNT	float	NO		0
FROZEN_COLLIQUANTITY	int(11)	NO		0
FROZEN_COLLIDISCOUNT_PCT	float	NO		0
FROZEN_COLLIDISCOUNT_AMOUNT	float	NO		0
FROZEN_TIME_ADDED	int(11)	NO		0
FROZEN_USERPRICE	float	YES
FROZEN_CUSTOMPRICE	float	YES
FROZEN_CUSTOMDESCRIPTION	text	NO

Tabel: SHOP_ORDERS

Holds completed shop orders

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
UNIQUE_ORDERID	text	NO				Copied from CART_ORDERS.UNIQUE_ORDERID. (Deprecated. Autogenerated unique order id)
ORDERNUMBER_SEQ	int(11)	NO		0		Ordernumber shown to customer. Drawn from SHOP_ORDERSEQ
ORIGINAL_COOKIE_ID	text	NO				Copied from CART_ORDERS.CART_ID
USER_ID	int(11)	NO		0		Copied from CART_ORDERS.USER_ID (User logged in while shopping. Refers to USERS.ID)
NAME	text	NO
ADDRESS	text	NO
CITY	text	NO
ZIPCODE	text	NO
PHONE	text	NO
CELLPHONE	text	NO
FAX	text	NO
EMAIL	text	NO
COMPANY	text	NO
VAT_NUMBER	text	NO
ATTENTION	text	NO
NOTES	text	NO
DELIVERYNAME	text	NO
DELIVERYADDRESS	text	NO
DELIVERYZIPCODE	text	NO
DELIVERYCITY	text	NO
FROZEN_PAYMENTTERM	text	NO
SITE_ID	int(11)	NO		0		Refers to SITES.ID
DELIVERYCOMPANY	text	NO

Tabel: SHOP_ORDERSEQ

Holds sequence of order numbers

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
RESERVED_TIME	timestamp	NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP	Holds time when the ordernumber was drawn, unix timestamp

Tabel: SHOP_PRODUCTGROUPS

Table to hold shop product groups

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
PARENT_ID	int(11)	NO		0		ID of parent productgroup
NUMBER	text	NO
NAME	text	NO
DESCRIPTION	text	NO
IMAGE_ID	int(11)	NO		0		Refers to PICTUREARCHIVE_PICS.ID
PUBLISHED	int(1)	NO		0
DELETED	tinyint(1)	NO		0
LISTMODE	tinyint(1)	NO		1
SITE_ID	int(11)	NO		0		Refers to SITES.ID

Tabel: SHOP_PRODUCTGROUPS_FORMFIELDS

Holds information on which formfields to show for each produ

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
PRODUCTGROUP_ID	int(11)	NO		0		Refers to SHOP_PRODUCTGROUPS.ID
FIELDNAME	text	NO

Tabel: SHOP_PRODUCTS

Table holds shop products

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
GROUP_ID	int(11)	NO		0		Refers to SHOP_PRODUCTGROUPS.ID
PRODUCT_NUMBER	text	NO
ALT_PRODUCT_NUMBER	text	NO
NAME	text	NO
DESCRIPTION	text	NO
IMAGE_ID	int(11)	NO		0		Refers to PICTUREARCHIVE_PICS.ID
QUALITY_ID	int(11)	NO		0		Referst to SHOP_PRODUCTS_QUALITIES.ID
DIAMETER	float	NO		0
LENGTH	float	NO		0
PRICE	float	NO		0
DELETED	tinyint(1)	NO		0
DESCRIPTION_COMPLETE	text	NO
URL_EXT_INFO	text	NO
URL_EXT_PRODUCTSHEET	text	NO
SHOW_RELATED_PRODUCTS	tinyint(1)	NO		1		Show related products when displaying this item in the shop

Tabel: SHOP_PRODUCTS_COLLI

Table to hold shop product collis

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
PRODUCT_ID	int(11)	NO		0		Refers to SHOP_PRODUCTS.ID
QUANTITY	int(11)	NO		0
DISCOUNT_PERCENTAGE	float	NO		0
DISCOUNT_AMOUNTPERCOLLI	float	NO		0
DELETED	tinyint(1)	NO		0

Tabel: SHOP_PRODUCTS_GROUPS

Holds product-group association

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
PRODUCT_ID	int(11)	NO		0		Refers to SHOP_PRODUCTS.ID
GROUP_ID	int(11)	NO		0		Refers to SHOP_PRODUCTGROUPS.ID

Tabel: SHOP_PRODUCTS_QUALITIES

Holds shop product qualities

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
NAME	text	NO
DELETED	tinyint(1)	NO		0
SITE_ID	int(11)	NO		0		Refers to SITES.ID

Tabel: SHOP_PRODUCTS_USERS

Holds association of SHOP_PRODUCTS and USERS for use in diff

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
USER_ID	int(11)	NO		0		Refers to USERS.ID
PRODUCT_ID	int(11)	NO		0		Refers to SHOP_PRODUCTS.ID
CONTEXT	enum('defined','bought','viewed')	NO		defined
CREATED_DATE	datetime	NO		0000-00-00 00:00:00

Tabel: SHOP_RELATED_PRODUCTS

Holds information on related products

Name	Type	Null	Key	Default	Extra	Comment
ID	int(10) unsigned	NO	PRI		auto_increment
GROUP_ID	int(10) unsigned	NO		0		Used if relating products to a productgroup. Refers to SHOP_PRODUCTGROUPS.ID
ITEM_ID	int(10) unsigned	NO		0		Used if relating products to a product. Refers to SHOP_PRODUCTS.ID
RELATED_ITEM_ID	int(10) unsigned	NO		0		ID of related product. Refers to SHOP_PRODUCTS.ID

Tabel: SHOP_USERPRICES

Holds specific user prices

Name	Type	Null	Key	Default	Extra	Comment
ID	int(10) unsigned	NO	PRI		auto_increment
USER_ID	int(10) unsigned	NO		0		Refers to USERS.ID
PRODUCT_ID	int(10) unsigned	NO		0		Refers to SHOP_PRODUCTS.ID
USERPRICE	decimal(9,2)	NO		0.00
CHANGED_DATE	datetime	NO		0000-00-00 00:00:00

Tabel: SITES

Holds sites managed by cms installation

Name	Type	Null	Key	Default	Extra	Comment
SITE_ID	int(11)	NO	MUL		auto_increment
SITE_NAME	text	NO				Name of site
BASE_URL	text	NO				Site base url, f.instance "http://www.mydomain.com" Deprecated. Use CMS_SITEDOMAINS for new applications
SITE_PATH	text	NO				Make site appear to live in "/path-to-site". Deprecated
DEFAULT_TEMPLATE	int(11)	NO		0		Refers to TEMPLATES.ID
EMAIL_DOMAIN	text	NO				f.instance "mydomain.com". Only used sporadically

Tabel: TAGS

Tags used

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
SITE_ID	int(11)	NO		0		Refers to SITES.SITE_ID
TAGNAME	text	NO
DELETED	tinyint(4)	NO		0

Tabel: TAG_REFERENCES

Intersection table to tag content items

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
TAG_ID	int(11)	NO		0		Refers to TAGS.ID
TABLENAME	text	NO				Name of table that holds item being tagged
REQUEST_ID	int(11)	NO		0		ID of item being tagged

Tabel: TEMPLATES

Holds templates for use in CMS

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	PRI		auto_increment
NAME	text	NO
DESCRIPTION	text	NO
PATH	text	NO				Path to template, f.instance includes/templates/example.template.php (TYPE = PAGE only)
PRINTTEMPLATE_PATH	text	NO				Path to printable version of same template, f.instance includes/templates/example_printerfriendly.template.php (TYPE = PAGE only)
CARTTEMPLATE_PATH	text	NO				Path to shopping-cart template (TYPE = PAGE only)
CHECKOUTTEMPLATE_PATH	text	NO				Path to checkout template (remove distractions) (TYPE = PAGE only)
TYPE	text	NO				PAGE / NEWSLETTER
FOLDER_NAME	text	NO				Name of subfolder in /includes/templates that holds the template files (TYPE = NEWSLETTER only)
SITE_ID	int(11)	NO		0		Refers to SITES.SITE_ID, 0 = template available on all sites

Tabel: TILMELDINGER

Holds data collected by DEFINED_FORMS (sorry)

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
FORM_ID	int(11)	NO		0
FIELD_IDS	text	NO
FIELD_VALUES	text	NO
CREATED_DATE	text	NO
UNIK	text	NO

Tabel: USERS

Holds all cms users, website users, newsletter subscribers

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
USERNAME	text	NO				Must be unique, not enforced on database
PASSWORD	text	NO
FIRSTNAME	text	NO
LASTNAME	text	NO
ADDRESS	text	NO
ZIPCODE	text	NO
CITY	text	NO
PHONE	text	NO
CELLPHONE	text	NO
EMAIL	text	NO
CV	text	NO
COMPANY	text	NO
CREATED_DATE	text	NO
CHANGED_DATE	text	NO
UNFINISHED	tinyint(4)	NO		0
AUTHOR_ID	int(11)	NO		0		ID of user who created this user, Refers til USERS.ID
DELETED	tinyint(4)	NO		0
RECEIVE_LETTERS	tinyint(4)	NO		0		Deprecated
EMAIL_VERIFIED	tinyint(4)	NO		0		Only send newsletters to users with verified emails. Users created manually are automatically verified.
INITIALS	text	NO
DATE_OF_BIRTH	date	NO		0000-00-00
DATE_OF_HIRING	date	NO		0000-00-00
DEPARTMENT	text	NO
JOB_TITLE	text	NO
TRANSFER_TO_GROUP	int(11)	NO		0		Target group for user self-registration. user is moved to this group after approval.
NEVER_PUBLIC	tinyint(4)	NO		0		Exclude from lists generated by the system (by userlist plugin, f.instance)
IMAGE_ID	int(11)	NO		0		Photo of user, refers to PICTUREARCHIVE_PICS.ID
PASSWORD_ENCRYPTED	text	NO				md5 encrypted version of password. If no password is given in PASSWORD, login will check against this. Can be used when importing users from other systems. No plaintext password = problem sending out password per mail. Should probably be replaced by/combined with a reset password feature.
COUNTRY	text	NO

Tabel: USERS_GROUPS

Intersection table to include and position users in groups

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
USER_ID	int(11)	NO		0		Referst to USERS.ID
GROUP_ID	int(11)	NO		0		Refers to GROUPS.ID
POSITION	int(11)	NO		0

Tabel: USERS_VARIED_FIELDS

Holds userdata that vary across groups, see cms_config.inc.p

Name	Type	Null	Key	Default	Extra	Comment
ID	int(11)	NO	MUL		auto_increment
USER_ID	int(11)	NO		0		Refers to USERS.ID
GROUP_ID	int(11)	NO		0		Refers to GROUPS.ID
FIELD_NAME	text	NO
TABLE_NAME	text	NO
FIELD_VALUE	text	NO