Documentation>>Sitemap>>About Version 2.0.J

---

Databasetables and Fields

Table rd_sitemap_view

Function

This table holds the data for the views

Fields

Fields	Type	Kollation	Attributes	Null	Standard	Description
id	int		unsigned	no		Primary Key
type	varchar	utf8_general_ci		no		view or menu
title	text	utf8_general_ci		no
creation_date	varchar	utf8_general_ci		no		info from the XML - description
author	varchar	utf8_general_ci		no		info from the XML - description
copyright	varchar	utf8_general_ci		no		info from the XML - description
author_email	varchar	utf8_general_ci		no		info from the XML - description
author_url	varchar	utf8_general_ci		no		info from the XML - description
version	varchar	utf8_general_ci		no		info from the XML - description
description	varchar	utf8_general_ci		no		info from the XML - description
content	text	utf8_general_ci		no
checked_out	int		unsigned	no	0
checked_out_time	datetime			no	0000-00-00 00:00:00
published	tinyint		unsigned	no	0
params	text	utf8_general_ci		no
control	text	utf8_general_ci		no

Table rd_sitemap_viewset

Function

This table holds the data for the viewsets

Fields

Fields	Type	Kollation	Attributes	Null	Standard	Description
id	int		unsigned	no		Primary Key
title	text	utf8_general_ci		no
content	text	utf8_general_ci		no
checked_out	int		unsigned	no	0
checked_out_time	datetime			no	0000-00-00 00:00:00
published	tinyint		unsigned	no	0
params	text	utf8_general_ci		no

Table rd_sitemap_rel_viewset_has_view

Function

This table maps views and viewset

Felder

Fields	Type	Kollation	Attributes	Null	Standard	Description
id	int		unsigned	no		Primary Key
view	int		unsigned	no
viewset	int		unsigned	no
ordering	int		unsigned	no