#NUMBER;PARENT;FOLDERNAME;ISFOLDER;ISCLICKABLE;ICON;TREEQUERY;SELECT PARAMS QUERY;UPDATE / INSERT PARAMS QUERY;DELETE1   ;;Group Management;true;false;dict;2	;1;New Group;false;true;new;;select '' txt_name;insert into usergroup(name) values('[name]');	3  ;1;Group;false;true;user;select ref,name from usergroup order by name;select 'See <a href=../permissions.txt target=_blank>the permissions help text file</a> for further information on permissions.',ref txt_reference,name txt_name,permissions txt_permissions,fixed_theme txt_fixed_theme,parent txt_parent,search_filter mtx_search_filter,'Wildcards are supported for IP address restrictions, e.g. 128.124.*',ip_restrict txt_IP_address_restriction from usergroup where ref='%2';update usergroup set name='[name]',permissions='[permissions]',fixed_theme='[fixed_theme]',parent='[parent]',search_filter='[search_filter]',ip_restrict='[IP_address_restriction]' where ref='%2';delete from usergroup where ref='%2';4	;999;New User;false;true;new;;select '' txt_login_username;insert into user(username,usergroup) values('[login_username]','%2');	5  ;999;User;false;true;identity;select ref,username name from user where usergroup='%2';select 'Group',usergroup drp_3,username txt_login_username,password txt_login_password,email txt_email, last_ip txt_last_IP_address,last_browser txt_last_browser,last_active txt_last_activity from user where ref='%3';update user set usergroup='[3]',username='[login_username]',password='[login_password]',email='[email]' where ref='%3';delete from user where ref='%3';6	;;Resource Types / Fields;true;false;dict;7	;6;New Resource Type;false;true;new;;select '' txt_name;insert into resource_type(name) values('[name]');	8	;6;Resource Type;true;true;box;select ref,name from resource_type union select 0,'Global Fields' union select 999, 'Archive Only' order by name;select name txt_name from resource_type where ref='%2';update resource_type set name='[name]' where ref='%2';delete from resource_type where ref='%2';9	;8;New Field;false;true;new;;select '' txt_title;insert into resource_type_field(title,resource_type) values('[title]','%2');	10	;8;Field;false;true;write;select ref,title name from resource_type_field where resource_type='%2' order by order_by;select ref txt_field_id,title txt_title,'Resource Type',resource_type drp_8,'Field Type',type drp_11,options mtx_options,required bit_required,order_by txt_order_by,keywords_index bit_index_this_field,name txt_shorthand_name,display_field bit_display_field,use_for_similar bit_use_for_find_similar_searching,iptc_equiv txt_iptc_equiv,display_template mtx_display_template,tab_name txt_tab_name,smart_theme_name txt_smart_theme_name,exiftool_field txt_exiftool_field from resource_type_field where ref='%3';update resource_type_field set title='[title]',name='[shorthand_name]',resource_type='[8]',type='[11]',options='[options]',required='[required]',order_by='[order_by]',keywords_index='[index_this_field]',display_field='[display_field]',use_for_similar='[use_for_find_similar_searching]',iptc_equiv='[iptc_equiv]',display_template='[display_template]',tab_name='[tab_name]',smart_theme_name='[smart_theme_name]',exiftool_field='[exiftool_field]' where ref='%3';delete from resource_type_field where ref='%3';11	;999;Type Dropdown Macro;;;;select 0 ref,'Text Box (single line)' name union select 1 ref,'Text Box (multi-line)' union select 5 ref,'Text Box (large multi-line)' name union select 2 ref,'Check box list' name union select 3 ref,'Drop down list' name union select 4 ref,'Date' name union select 6 ref,'Expiry Date' name;12	;999;13	;;Site Text;true;false;dict;14	;13;New Site Text Entry;false;true;new;;select '' txt_page,'' txt_name,'' btx_text;insert into site_text(page,name,language,text) values ('[page]','[name]','en','[text]');15	;13;Page;true;false;html;select distinct page ref,page name from site_text order by page;16  ;15;Site Text;false;true;write;select ref,name from site_text where page='%2' order by name;select page txt_page,name txt_name,language txt_language,text btx_text from site_text where ref='%3';update site_text set page='[page]',name='[name]',language='[language]',text='[text]' where ref='%3';delete from site_text where ref='%3';17	;;Reports;true;false;dict;18	;17;New Report;false;true;new;;select '' txt_name;insert into report(name) values('[name]');	19  ;17;Report;false;true;write;select ref,name from report order by name;select name txt_name,query btx_query from report where ref='%2';update report set name='[name]',query='[query]' where ref='%2';delete from report where ref='%2';20	;;Downloads / Preview Sizes;true;false;dict;21	;20;New Download / Preview Size;false;true;new;;select '' txt_name,'' txt_id;insert into preview_size(name,id) values('[name]','[id]');	22  ;20;Preview Size;false;true;write;select id ref,name from preview_size order by width;select name txt_name,width txt_width,height txt_height,padtosize bit_pad_to_size,internal bit_internal,allow_preview bit_allow_preview,allow_restricted bit_allow_restricted_download from preview_size where id='%2';update preview_size set name='[name]',width='[width]',height='[height]',padtosize='[pad_to_size]',internal='[internal]',allow_preview='[allow_preview]',allow_restricted='[allow_restricted_download]' where id='%2';delete from preview_size where id='%2';23	;;Database Statistics;false;true;query;;select (select count(*) from resource) txt_total_resources,(select count(*) from keyword) txt_total_keywords,(select count(*) from resource_keyword) txt_resource_keyword_relationships,(select count(*) from collection) txt_total_collections,(select count(*) from collection_resource) txt_collection_resource_relationships,(select count(*) from user) txt_total_users;