aliro_general.sql File Reference

Go to the source code of this file.

Functions
Table structure for table CREATE TABLE IF NOT EXISTS id	int (11) NOT NULL auto_increment
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title	varchar (50) NOT NULL default ''
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name	varchar (255) NOT NULL default ''
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image	varchar (100) NOT NULL default ''
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position	varchar (10) NOT NULL default ''
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published	tinyint (1) NOT NULL default '0'
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access	tinyint (3) unsigned NOT NULL default '0'
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY	KEY (`id`)
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY KEY	cat_idx (`section`,`published`,`access`)
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY KEY KEY	idx_section (`section`)
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY KEY KEY KEY	idx_access (`access`)
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY KEY KEY KEY KEY	idx_checkout (`checked_out`)) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS id system component property value text NOT NULL PRIMARY KEY	owner (`system`,`component`)) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS group_id parent_id name lft rgt PRIMARY	KEY (`group_id`)
Table structure for table CREATE TABLE IF NOT EXISTS group_id parent_id name lft rgt PRIMARY KEY	parent_id_aro_groups (`parent_id`)
Table structure for table CREATE TABLE IF NOT EXISTS group_id parent_id name lft rgt PRIMARY KEY KEY	al_gacl_parent_id_aro_groups (`parent_id`)
Table structure for table CREATE TABLE IF NOT EXISTS group_id parent_id name lft rgt PRIMARY KEY KEY KEY	al_gacl_lft_rgt_aro_groups (`lft`,`rgt`)) ENGINE
INSERT	INTO (17, 0, 'ROOT', 1, 22)
Table structure for table CREATE TABLE IF NOT EXISTS time_stamp date NOT NULL item_table item_id hits PRIMARY	KEY (`time_stamp`,`item_table`,`item_id`)) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS id parentid ordering published	smallint (6) NOT NULL default '0'
Table structure for table CREATE TABLE IF NOT EXISTS id parentid ordering published childcount name title windowtitle keywords icon	varchar (25) NOT NULL default ''
Table structure for table CREATE TABLE IF NOT EXISTS id ordering frequency published hidden type name description text NOT PRIMARY FULLTEXT KEY	searchname (`name`)) ENGINE
INSERT	INTO (0, 'Public')
Table structure for table CREATE TABLE IF NOT EXISTS message_id	int (10) unsigned NOT NULL auto_increment
Table structure for table CREATE TABLE IF NOT EXISTS message_id user_id_from user_id_to folder_id date_time datetime NOT NULL state priority	int (1) unsigned NOT NULL default '0'
Table structure for table CREATE TABLE IF NOT EXISTS message_id user_id_from user_id_to folder_id date_time datetime NOT NULL state priority subject message text NOT NULL PRIMARY	KEY (`message_id`)) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS user_id cfg_name cfg_value UNIQUE KEY	idx_user_var_name (`user_id`,`cfg_name`)) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS id param_name param_file param_version params text NOT NULL PRIMARY KEY	names (`param_name`,`param_version`)) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS id title name image scope image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL ordering access count params text NOT NULL PRIMARY KEY	idx_scope (`scope`)) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS id name username email usertype block	tinyint (4) NOT NULL default '0'
Table structure for table CREATE TABLE IF NOT EXISTS id name username email usertype block sendEmail gid registerDate datetime NOT NULL lastvisitDate datetime NOT NULL params text NOT NULL PRIMARY UNIQUE KEY	idx_username (`username`)
Table structure for table CREATE TABLE IF NOT EXISTS id name username email usertype block sendEmail gid registerDate datetime NOT NULL lastvisitDate datetime NOT NULL params text NOT NULL PRIMARY UNIQUE KEY KEY	idx_email (`email`)
Table structure for table CREATE TABLE IF NOT EXISTS id name username email usertype block sendEmail gid registerDate datetime NOT NULL lastvisitDate datetime NOT NULL params text NOT NULL PRIMARY UNIQUE KEY KEY KEY	idx_name (`name`)) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS id type	varchar (20) NOT NULL default ''
Table structure for table CREATE TABLE IF NOT EXISTS id type name text NOT NULL modified text NOT NULL PRIMARY KEY	sequence (`type`,`name`(50))) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS id sef text NOT uri text NOT refreshed PRIMARY KEY	sef (`sef`(60))
Table structure for table CREATE TABLE IF NOT EXISTS id sef text NOT uri text NOT refreshed PRIMARY KEY KEY	uri (`uri`(250))) ENGINE
Table structure for table CREATE TABLE IF NOT EXISTS id type uri text NOT htmltitle robots keywords text NOT description text NOT PRIMARY KEY	finduri (`uri`(60))) ENGINE
Variables
Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL	default
INSERT	USERS
INSERT Public	Frontend
INSERT Public	Registered
INSERT Public	Author
INSERT Public	Editor
INSERT Public	Publisher
INSERT Public Public	Backend
INSERT Public Public	Manager
INSERT Public Public	Administrator
INSERT Public Public Super ON DUPLICATE KEY UPDATE	name = name
Table structure for table CREATE TABLE IF NOT EXISTS id ordering frequency published hidden type name description text NOT	NULL
INSERT	Special

---

Function Documentation

Table structure for table CREATE TABLE IF NOT EXISTS group_id parent_id name lft rgt PRIMARY KEY KEY KEY al_gacl_lft_rgt_aro_groups	(	`lft`	,
		`rgt`
	)

Table structure for table CREATE TABLE IF NOT EXISTS group_id parent_id name lft rgt PRIMARY KEY KEY al_gacl_parent_id_aro_groups

(

`parent_id`

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY KEY cat_idx	(	`section`	,
		`published`	,
		`access`
	)

Table structure for table CREATE TABLE IF NOT EXISTS id type uri text NOT htmltitle robots keywords text NOT description text NOT PRIMARY KEY finduri

(

`uri`

60

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY KEY KEY KEY idx_access

(

`access`

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY KEY KEY KEY KEY idx_checkout

(

`checked_out`

)

Table structure for table CREATE TABLE IF NOT EXISTS id name username email usertype block sendEmail gid registerDate datetime NOT NULL lastvisitDate datetime NOT NULL params text NOT NULL PRIMARY UNIQUE KEY KEY idx_email

(

`email`

)

Table structure for table CREATE TABLE IF NOT EXISTS id name username email usertype block sendEmail gid registerDate datetime NOT NULL lastvisitDate datetime NOT NULL params text NOT NULL PRIMARY UNIQUE KEY KEY KEY idx_name

(

`name`

)

Table structure for table CREATE TABLE IF NOT EXISTS id title name image scope image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL ordering access count params text NOT NULL PRIMARY KEY idx_scope

(

`scope`

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY KEY KEY idx_section

(

`section`

)

Table structure for table CREATE TABLE IF NOT EXISTS user_id cfg_name cfg_value UNIQUE KEY idx_user_var_name	(	`user_id`	,
		`cfg_name`
	)

Table structure for table CREATE TABLE IF NOT EXISTS id name username email usertype block sendEmail gid registerDate datetime NOT NULL lastvisitDate datetime NOT NULL params text NOT NULL PRIMARY UNIQUE KEY idx_username

(

`username`

)

Table structure for table CREATE TABLE IF NOT EXISTS message_id user_id_from user_id_to folder_id date_time datetime NOT NULL state priority int

(

1

)

Table structure for table CREATE TABLE IF NOT EXISTS user_id int

(

10

)

Table structure for table CREATE TABLE IF NOT EXISTS id int

(

11

)

INSERT INTO	(	0	,
		'Public'
	)

INSERT INTO	(	17	,
		0	,
		'ROOT'	,
		1	,
		22
	)

Table structure for table CREATE TABLE IF NOT EXISTS message_id user_id_from user_id_to folder_id date_time datetime NOT NULL state priority subject message text NOT NULL PRIMARY KEY

(

`message_id`

)

Type Constraints

Table structure for table CREATE TABLE IF NOT EXISTS time_stamp date NOT NULL item_table item_id hits PRIMARY KEY	(	`time_stamp`	,
		`item_table`	,
		`item_id`
	)

Table structure for table CREATE TABLE IF NOT EXISTS group_id parent_id name lft rgt PRIMARY KEY

(

`group_id`

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access count params text NOT NULL PRIMARY KEY

(

`id`

)

Type Constraints

Table structure for table CREATE TABLE IF NOT EXISTS id param_name param_file param_version params text NOT NULL PRIMARY KEY names	(	`param_name`	,
		`param_version`
	)

Table structure for table CREATE TABLE IF NOT EXISTS id system component property value text NOT NULL PRIMARY KEY owner	(	`system`	,
		`component`
	)

Table structure for table CREATE TABLE IF NOT EXISTS group_id parent_id name lft rgt PRIMARY KEY parent_id_aro_groups

(

`parent_id`

)

Table structure for table CREATE TABLE IF NOT EXISTS id ordering frequency published hidden type name description text NOT PRIMARY FULLTEXT KEY searchname

(

`name`

)

Table structure for table CREATE TABLE IF NOT EXISTS id sef text NOT uri text NOT refreshed PRIMARY KEY sef

(

`sef`

60

)

Referenced by aliroPathway::__construct(), aliroPathway::addItem(), sefAdminHTML::listmeta(), sefAdminHTML::listuris(), and aliroPathway::makePathway().

Table structure for table CREATE TABLE IF NOT EXISTS id type name text NOT NULL modified text NOT NULL PRIMARY KEY sequence	(	`type`	,
		`name`	50
	)

Table structure for table CREATE TABLE IF NOT EXISTS id parentid ordering published smallint

(

6

)

Table structure for table CREATE TABLE IF NOT EXISTS id name username email usertype block tinyint

(

4

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published checked_out checked_out_time datetime NOT NULL editor ordering access tinyint

(

3

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image section image_position description text NOT NULL published tinyint

(

1

)

Type Constraints

Table structure for table CREATE TABLE IF NOT EXISTS id sef text NOT uri text NOT refreshed PRIMARY KEY KEY uri

(

`uri`

250

)

Referenced by sefAdminHTML::listmeta(), and sefAdminHTML::listuris().

Table structure for table CREATE TABLE IF NOT EXISTS id type varchar

(

20

)

Table structure for table CREATE TABLE IF NOT EXISTS id parentid ordering published childcount name title windowtitle keywords icon varchar

(

25

)

Table structure for table CREATE TABLE IF NOT EXISTS id type varchar

(

10

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name image varchar

(

100

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title name varchar

(

255

)

Table structure for table CREATE TABLE IF NOT EXISTS id parent_id title varchar

(

50

)

---

Variable Documentation

INSERT Public Public Super Administrator

Definition at line 66 of file aliro_general.sql.

INSERT Public Author

Definition at line 66 of file aliro_general.sql.

INSERT Public Public Backend

Definition at line 66 of file aliro_general.sql.

Table structure for table CREATE TABLE IF NOT EXISTS id type name text NOT NULL modified text NOT NULL default

Definition at line 14 of file aliro_general.sql.

INSERT Public Editor

Definition at line 66 of file aliro_general.sql.

INSERT Public Frontend

Definition at line 66 of file aliro_general.sql.

INSERT Public Public Manager

Definition at line 66 of file aliro_general.sql.

INSERT Public Public Super ON DUPLICATE KEY UPDATE name = name

Definition at line 75 of file aliro_general.sql.

Table structure for table CREATE TABLE IF NOT EXISTS id type uri text NOT htmltitle robots keywords text NOT description text NOT NULL

Definition at line 127 of file aliro_general.sql.

INSERT Public Publisher

Definition at line 66 of file aliro_general.sql.

INSERT Registered

Definition at line 66 of file aliro_general.sql.

INSERT Special

Definition at line 146 of file aliro_general.sql.

INSERT USERS

Definition at line 66 of file aliro_general.sql.