System Tables

All tables have sec_id (and index) unless otherwise noted and all tables start zz_ 

1. pages
pageid int(11) auto_increment
pagedescription varchar(255)
layoutid int(11)
index layoutid (layoutid)

2. layouts
layoutid int(11) auto_increment
layoutdescription varchar(255)
xsltprefix varchar(50)
locations int(8)

3.preferredpages
pageid int(11)
index pageid (pageid)
userid int(11)
index userid (userid)
preferred varchar(1)

6.blockids
blockid int(11) auto_increment

5.blocks
*no need for sec_id since page access is determined on the pages table and individual block access is decided by either filter or process table.
blockuniqid int(11) auto_increment
blockid int(11) 
index blockid (blockid)
pageid int(11)
index pageid (pageid)
userid int(11)
index userid (userid)
location varchar(100)
revision varchar(10)
revisiondescription varchar(255)
type varchar(20)
•	Fields need on start-up by ZProcess->new and ZFilter->new .

6.blockorder
blockorderid int(11) auto_increment
blockid int(11)
index blockid (blockid)
userid int(11)
index userid (userid)
blockorder int(8)
deleted char(1)


7. searchparams
searchparamid int(11) auto_increment
filterref varchar(100)
index filterref (filterref)
name varchar(255)
displayname varchar(255)

8.reportfields
reportfieldid int(11) auto_increment
filterref varchar(100)
index filterref (filterref)
sourcetable varchar(255)
sourcetableas varchar(255)
joincondition mediumtext
sourcedisplayfieldname varchar(255)
displayasname varchar(255)
uniquedisplayname varchar(255)
uniqueasname varchar(255)

9.process
processid int(11) auto_increment
current_state varchar(255)

10.table_security
table_securityid int(11) auto_increment
Tablename varchar(255)
relationship_name varchar(255)
permissions varchar(255)

11.record_security
record_securityid int(11) auto_increment
id int(11)
index id (from ip_lists)
sec_id int(11)
permissions varchar(255)
permission_holder varchar(255)

12.ip_lists
id int 11 , autoincrement
ip_address varchar(255)

13.user_record
user varchar(255)
ptpassword varchar(20)
password varchar(20)
userid , int 11 , autoincrement

14.user_groups
user varchar(255)
name varchar(255)
groupid, int 11 , autoincrement


15.db_login_velocity
user varchar(255)
logintime timestamp
login_velocityid, int 11 , autoincrement


16. ldap_cache
sessionid int(11)
index sessionid
expiry,  timestamp
filter varchar(255)
attribute_name varchar(255)
attribute_value varchar(255)
ldap_cacheid, int 11 , autoincrement


17. system_options
option_name varchar(255)
option_value varchar(255)
system_optionid , int 11 , autoincrement


18. sessions
cookie_value varchar(255)
expires, timestamp
sessionid, int 11 , autoincrement


19. session_info
cookie_value varchar(255)
name varchar(255)
value varchar(255)
session_infoid,int 11 , autoincrement