integrity.view.php File Reference

Variables
	$_views ["USER_USERINFO"]
	$_views ["USER_SEMUSER"]
	$_views ["USER_INSTUSER"]
	$_views ["USER_CONTACT"]
	$_views ["USER_STUDUSER"]
	$_views ["USER_ARCHIVUSER"]
	$_views ["USER_ADMISSIONUSER"]
	$_views ["USER_STATUSGRUPPEUSER"]
	$_views ["USER_OBJECT_USER_VISIT"]
	$_views ["SEM_SEMUSER"]
	$_views ["SEM_ADMISSIONSTUD"]
	$_views ["SEM_ADMISSIONUSER"]
	$_views ["SEM_SEMINST"]
	$_views ["SEM_TERMINE"]
	$_views ["SEM_SEM_TREE"]
	$_views ["SEM_OBJECT_USER_VISIT"]
	$_views ["INST_USER"]
	$_views ["INST_SEM"]
	$_views ["INST_OBJECT_USER_VISIT"]
	$_views ["ARCHIV_USER"]
	$_views ["STUD_ADMISSONSEM"]
	$_views ["STUD_ADMISSONUSER"]
	$_views ["STUD_USER"]
	$_views ["DOCS_SEM"]
	$_views ["DOCS_INST"]
	$_views ["FOLDER_SEM"]
	$_views ["FOLDER_INST"]
	$_views ["FOLDER_TERM"]
	$_views ["FOLDER_FOLD"]

Variable Documentation

$_views["USER_USERINFO"]

Initial value:

 array("pk"=>"user_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT a.user_id FROM user_info a LEFT JOIN auth_user_md5 b USING(user_id) WHERE ISNULL(b.user_id)")

$_views["USER_SEMUSER"]

Initial value:

 array("pk"=>"user_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.user_id FROM seminar_user a LEFT JOIN auth_user_md5 b USING(user_id) WHERE ISNULL(b.user_id)")

$_views["USER_INSTUSER"]

Initial value:

 array("pk"=>"user_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.user_id FROM user_inst a LEFT JOIN auth_user_md5 b USING(user_id) WHERE ISNULL(b.user_id)")

$_views["USER_CONTACT"]

Initial value:

 array("pk"=>"contact_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.contact_id FROM contact a LEFT JOIN auth_user_md5 b ON(a.user_id=b.user_id) LEFT JOIN auth_user_md5 c ON(a.owner_id=c.user_id) WHERE ISNULL(b.user_id) OR ISNULL(c.user_id)")

$_views["USER_STUDUSER"]

Initial value:

 array("pk"=>"user_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.user_id FROM user_studiengang a LEFT JOIN auth_user_md5 b USING(user_id) WHERE ISNULL(b.user_id)")

$_views["USER_ARCHIVUSER"]

Initial value:

 array("pk"=>"user_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.user_id FROM archiv_user a LEFT JOIN auth_user_md5 b USING(user_id) WHERE ISNULL(b.user_id)")

$_views["USER_ADMISSIONUSER"]

Initial value:

 array("pk"=>"user_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.user_id FROM admission_seminar_user a LEFT JOIN auth_user_md5 b USING(user_id) WHERE ISNULL(b.user_id)")

$_views["USER_STATUSGRUPPEUSER"]

Initial value:

 array("pk"=>"user_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.user_id FROM statusgruppe_user a LEFT JOIN auth_user_md5 b USING(user_id) WHERE ISNULL(b.user_id)")

$_views["USER_OBJECT_USER_VISIT"]

Initial value:

 array("pk"=>"user_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT a.user_id FROM `object_user_visits` a LEFT JOIN auth_user_md5 b USING(user_id)
                            WHERE ISNULL(b.user_id)")

$_views["SEM_SEMUSER"]

Initial value:

 array("pk"=>"Seminar_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.Seminar_id FROM seminar_user a LEFT JOIN seminare b USING(Seminar_id) WHERE ISNULL(b.Seminar_id)")

$_views["SEM_ADMISSIONSTUD"]

Initial value:

 array("pk"=>"Seminar_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.Seminar_id FROM admission_seminar_studiengang a LEFT JOIN seminare b USING(Seminar_id) WHERE ISNULL(b.Seminar_id)")

$_views["SEM_ADMISSIONUSER"]

Initial value:

 array("pk"=>"Seminar_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.Seminar_id FROM admission_seminar_user a LEFT JOIN seminare b USING(Seminar_id) WHERE ISNULL(b.Seminar_id)")

$_views["SEM_SEMINST"]

Initial value:

 array("pk"=>"Seminar_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.Seminar_id FROM seminar_inst a LEFT JOIN seminare b USING(Seminar_id) WHERE ISNULL(b.Seminar_id)")

$_views["SEM_TERMINE"]

Initial value:

 array("pk"=>"range_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT range_id FROM termine a LEFT JOIN  seminare b ON (range_id=Seminar_id) WHERE ISNULL(b.Seminar_id)")

$_views["SEM_SEM_TREE"]

Initial value:

 array("pk"=>"seminar_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT a.seminar_id FROM seminar_sem_tree a LEFT JOIN  seminare b USING(Seminar_id) WHERE ISNULL(b.Seminar_id)")

$_views["SEM_OBJECT_USER_VISIT"]

Initial value:

 array("pk"=>"object_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT object_id FROM `object_user_visits` LEFT JOIN seminare b ON(object_id=Seminar_id ) 
                            WHERE b.Seminar_id is null AND type='sem' ")

$_views["INST_USER"]

Initial value:

 array("pk"=>"Institut_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.Institut_id FROM user_inst a LEFT JOIN Institute b USING(Institut_id) WHERE ISNULL(b.Institut_id)")

$_views["INST_SEM"]

Initial value:

 array("pk"=>"Institut_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.Institut_id FROM seminar_inst a LEFT JOIN Institute b USING(Institut_id) WHERE ISNULL(b.Institut_id)")

$_views["INST_OBJECT_USER_VISIT"]

Initial value:

 array("pk"=>"object_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT object_id FROM `object_user_visits` a LEFT JOIN Institute b ON(object_id=Institut_id ) 
                            WHERE b.Institut_id is null AND a.type='inst' ")

$_views["ARCHIV_USER"]

Initial value:

 array("pk"=>"Seminar_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.Seminar_id FROM archiv_user a LEFT JOIN archiv b USING(Seminar_id) WHERE ISNULL(b.Seminar_id)")

$_views["STUD_ADMISSONSEM"]

Initial value:

 array("pk"=>"studiengang_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.studiengang_id FROM admission_seminar_studiengang a LEFT JOIN studiengaenge b USING(studiengang_id) WHERE ISNULL(b.studiengang_id) AND a.studiengang_id NOT LIKE 'all'")

$_views["STUD_ADMISSONUSER"]

Initial value:

 array("pk"=>"studiengang_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.studiengang_id FROM admission_seminar_user a LEFT JOIN studiengaenge b USING(studiengang_id) WHERE ISNULL(b.studiengang_id) AND a.studiengang_id NOT LIKE 'all'")

$_views["STUD_USER"]

Initial value:

 array("pk"=>"studiengang_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT   a.studiengang_id FROM user_studiengang a LEFT JOIN studiengaenge b USING(studiengang_id) WHERE ISNULL(b.studiengang_id)")

$_views["DOCS_SEM"]

Initial value:

 array("pk"=>"Seminar_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT DISTINCT a.Seminar_id from dokumente a INNER JOIN seminare USING(Seminar_id)")

$_views["DOCS_INST"]

Initial value:

 array("pk"=>"Seminar_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT DISTINCT a.Seminar_id from dokumente a INNER JOIN Institute b ON(a.Seminar_id=b.Institut_id)")

$_views["FOLDER_SEM"]

Initial value:

 array("pk"=>"range_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT DISTINCT a.range_id from folder a INNER JOIN seminare b ON(b.Seminar_id=a.range_id)")

$_views["FOLDER_INST"]

Initial value:

 array("pk"=>"range_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT DISTINCT a.range_id from folder a INNER JOIN Institute b ON(b.Institut_id=a.range_id)")

$_views["FOLDER_TERM"]

Initial value:

 array("pk"=>"range_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT DISTINCT a.range_id from folder a INNER JOIN termine b ON(b.termin_id=a.range_id)")

$_views["FOLDER_FOLD"]

Initial value:

 array("pk"=>"range_id","temp_table_type"=>"HEAP",
                            "query"=>"SELECT DISTINCT a.range_id from folder a INNER JOIN folder b ON(b.folder_id=a.range_id)")