text: CREATE TABLE " . $sqltblpre . "faqinstances (id SERIAL NOT NULL,url VARCHAR(255) NOT NULL,instance VARCHAR(255) NOT NULL,comment TEXT NULL,created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,modified TIMESTAMP NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqdata_group (record_id int4 NOT NULL,group_id int4 NOT NULL,PRIMARY KEY (record_id, group_id))
  CREATE TABLE ".$sqltblpre."faquser (user_id integer NOT NULL,login varchar(25) NOT NULL,session_id varchar(150) NULL,session_timestamp integer NULL,ip varchar(15) NULL,account_status varchar(50) NULL,last_login varchar(14) NULL,auth_source varchar(100) NULL,member_since varchar(14) NULL,remember_me varchar(150) NULL,success INT(1) NULL DEFAULT 1,PRIMARY KEY (user_id))
  CREATE TABLE ".$sqltblpre."faqnews (id int(11) NOT NULL,lang varchar(5) NOT NULL,header varchar(255) NOT NULL,artikel text NOT NULL,datum varchar(14) NOT NULL,author_name varchar(255) NULL,author_email varchar(255) NULL,active char(1) default 'y',comment char(1) default 'n',date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',link varchar(255) DEFAULT NULL,linktitel varchar(255) DEFAULT NULL,target varchar(255) NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faquserlogin (login VARCHAR(128) NOT NULL,pass VARCHAR(80) NULL,PRIMARY KEY(login))
  CREATE TABLE ".$sqltblpre."faqdata_revisions (id integer NOT NULL,lang varchar(5) NOT NULL,solution_id int(11) NOT NULL,revision_id int(11) NOT NULL DEFAULT 0,active char(3) NOT NULL,sticky INTEGER NOT NULL,keywords text DEFAULT NULL,thema text NOT NULL,content text DEFAULT NULL,author varchar(255) NOT NULL,email varchar(255) NOT NULL,comment char(1) default 'y',datum varchar(15) NOT NULL,links_state VARCHAR(7) DEFAULT NULL,links_check_date INT(11) DEFAULT 0 NOT NULL,date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',PRIMARY KEY (id, lang, solution_id, revision_id))
  CREATE TABLE ".$sqltblpre."faqsearches (id INT(11) NOT NULL ,lang VARCHAR(5) NOT NULL ,searchterm VARCHAR(255) NOT NULL ,searchdate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqsearches (id SERIAL NOT NULL ,lang VARCHAR(5) NOT NULL ,searchterm VARCHAR(255) NOT NULL ,searchdate TIMESTAMP,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqquestions (id SERIAL NOT NULL,username varchar(100) NOT NULL,email varchar(100) NOT NULL,category_id int4 NOT NULL,question text NOT NULL,created varchar(20) NOT NULL,is_visible char(1) default 'Y',answer_id INTEGER NOT NULL DEFAULT 0,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqconfig (config_name varchar(255) NOT NULL default '',config_value varchar(255) DEFAULT NULL,PRIMARY KEY (config_name))
  CREATE TABLE ".$sqltblpre."faqgroup_right (group_id int4 NOT NULL,right_id int4 NOT NULL,PRIMARY KEY (group_id, right_id))
  CREATE TABLE ".$sqltblpre."faqquestions (id int(11) unsigned NOT NULL,username varchar(100) NOT NULL,email varchar(100) NOT NULL,category_id int(11) NOT NULL,question text NOT NULL,created varchar(20) NOT NULL,is_visible char(1) default 'Y',answer_id INTEGER NOT NULL DEFAULT 0,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqdata_user (record_id INT(11) NOT NULL,user_id INT(11) NOT NULL,PRIMARY KEY (record_id, user_id))
  CREATE TABLE ".$sqltblpre."faqsessions (sid int(11) NOT NULL,user_id int(11) NOT NULL,ip text NOT NULL,time int(11) NOT NULL,PRIMARY KEY (sid))
  CREATE TABLE ".$sqltblpre."faqcategories (id SERIAL NOT NULL,lang varchar(5) NOT NULL,parent_id int4 NOT NULL,name varchar(255) NOT NULL,description varchar(255) DEFAULT NULL,user_id int4 NOT NULL,PRIMARY KEY (id, lang))
  SELECT * FROM " . PMF_Db::getTablePrefix() . "faquserlogin";
  SELECT * FROM " . PMF_Db::getTablePrefix() . "faqquestions_temp";
  CREATE TABLE ".$sqltblpre."faqglossary (id INT(11) NOT NULL ,lang VARCHAR(5) NOT NULL ,item VARCHAR(255) NOT NULL ,definition TEXT NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqcategoryrelations (category_id INT(11) NOT NULL,category_lang VARCHAR(5) NOT NULL default '',record_id INT(11) NOT NULL,record_lang VARCHAR(5) NOT NULL default '',PRIMARY KEY (category_id, category_lang, record_id, record_lang))
  CREATE TABLE " . $sqltblpre . "faqattachment_file (virtual_hash CHAR(32) NOT NULL,contents BLOB NOT NULL,PRIMARY KEY (virtual_hash))
  CREATE TABLE ".$sqltblpre."faqtags (tagging_id INT(11) NOT NULL,tagging_name VARCHAR(255) NOT NULL ,PRIMARY KEY (tagging_id, tagging_name))
  CREATE TABLE " . $sqltblpre . "faqattachment_file (virtual_hash char(32) NOT NULL,contents bytea,PRIMARY KEY (virtual_hash))
  SELECT name FROM sysobjects WHERE type = \'u\''.(('' == $prefix) ? '' : ' AND name LIKE \''.$prefix.'%\' ORDER BY name'));
  CREATE TABLE ".$sqltblpre."faquserlogin (login varchar(128) NOT NULL,pass varchar(80) NULL,PRIMARY KEY (login))
  SELECT name FROM sqlite_master WHERE type='table' ".(('' == $prefix) ? '': "AND name LIKE '".$prefix."%' ")."ORDER BY name
  CREATE TABLE " . $sqltblpre . "faqattachment_file (virtual_hash char(32) NOT NULL,contents blob NOT NULL,PRIMARY KEY (virtual_hash))
  CREATE TABLE ".$sqltblpre."faqdata (id int(11) NOT NULL,lang varchar(5) NOT NULL,solution_id int(11) NOT NULL,revision_id int(11) NOT NULL DEFAULT 0,active char(3) NOT NULL,sticky INTEGER NOT NULL,keywords text DEFAULT NULL,thema text NOT NULL,content longtext DEFAULT NULL,author varchar(255) NOT NULL,email varchar(255) NOT NULL,comment enum('y','n') NOT NULL default 'y',datum varchar(15) NOT NULL,links_state VARCHAR(7) DEFAULT NULL,links_check_date INT(11) DEFAULT 0 NOT NULL,date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',FULLTEXT (keywords,thema,content),PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqvoting (id integer NOT NULL,artikel SMALLINT NOT NULL,vote SMALLINT NOT NULL,usr SMALLINT NOT NULL,datum varchar(20) DEFAULT '',ip varchar(15) DEFAULT '',PRIMARY KEY (id))
  SELECT * FROM %sfaqinstances WHERE url = '%s'
  CREATE TABLE ".$sqltblpre."faquser_group (user_id INT(11) NOT NULL,group_id INT(11) NOT NULL,PRIMARY KEY (user_id, group_id))
  CREATE TABLE ".$sqltblpre."faqsearches (id INTEGER NOT NULL ,lang VARCHAR(5) NOT NULL ,searchterm VARCHAR(255) NOT NULL ,searchdate TIMESTAMP,PRIMARY KEY (id, lang))
  SELECT name FROM sqlite_master WHERE type='table' ".(('' == $prefix) ? '': "AND name LIKE '".$prefix."%' ")."ORDER BY name
  SELECT id, username, email, category_id, question, created, is_visible, 0 FROM " . PMF_Db::getTablePrefix() . "faqquestions_temp";
  CREATE TABLE ".$sqltblpre."faqstopwords (id INTEGER NOT NULL,lang VARCHAR(5) NOT NULL,stopword VARCHAR(64) NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqdata (id integer NOT NULL,lang varchar(5) NOT NULL,solution_id integer NOT NULL,revision_id integer NOT NULL DEFAULT 0,active char(3) NOT NULL,sticky INTEGER NOT NULL,keywords text DEFAULT NULL,thema text NOT NULL,content text DEFAULT NULL,author varchar(255) NOT NULL,email varchar(255) NOT NULL,comment char(1) default 'y',datum varchar(15) NOT NULL,links_state varchar(7) DEFAULT NULL,links_check_date integer DEFAULT 0 NOT NULL,date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',PRIMARY KEY (id, lang))
  CREATE TABLE " . $sqltblpre . "faqinstances (id INT NOT NULL,url VARCHAR(255) NOT NULL,instance VARCHAR(255) NOT NULL,comment TEXT NULL,created DATETIME NOT NULL,modified DATETIME NOT NULL,PRIMARY KEY (id))
  CREATE TABLE " . $sqltblpre . "faqinstances (id INT(11) NOT NULL,url VARCHAR(255) NOT NULL,instance VARCHAR(255) NOT NULL,comment TEXT NULL,created TIMESTAMP DEFAULT 0,modified TIMESTAMP ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqnews (id integer NOT NULL,lang varchar(5) NOT NULL,header varchar(255) NOT NULL,artikel text NOT NULL,datum varchar(14) NOT NULL,author_name varchar(255) NULL,author_email varchar(255) NULL,active char(1) default 'y',comment char(1) default 'n',date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',link varchar(255) DEFAULT NULL,linktitel varchar(255) DEFAULT NULL,target varchar(255) NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faquser_right (user_id INT(11) NOT NULL,right_id INT(11) NOT NULL,PRIMARY KEY (user_id, right_id))
  CREATE TABLE ".$sqltblpre."faquser (user_id integer NOT NULL,login varchar(25) NOT NULL,session_id varchar(150) NULL,session_timestamp integer NULL,ip varchar(15) NULL,account_status varchar(50) NULL,last_login varchar(14) NULL,auth_source varchar(100) NULL,member_since varchar(14) NULL,remember_me VARCHAR(150) NULL,success INT(1) NULL DEFAULT 1,PRIMARY KEY (user_id))
  CREATE TABLE ".$sqltblpre."faqinstances_config (instance_id INT(11) NOT NULL,config_name VARCHAR(255) NOT NULL default '',config_value VARCHAR(255) DEFAULT NULL,PRIMARY KEY (instance_id, config_name))
  CREATE TABLE ".$sqltblpre."faquserlogin (login VARCHAR(128) NOT NULL,pass VARCHAR(80) NULL,PRIMARY KEY (login))
  CREATE TABLE ".$sqltblpre."faqgroup (group_id SERIAL NOT NULL,name VARCHAR(25) NULL,description TEXT NULL,auto_join int4 NULL,PRIMARY KEY (group_id))
  CREATE TABLE ".$sqltblpre."faqvoting (id int(11) NOT NULL,artikel int(11) NOT NULL,vote int(11) NOT NULL,usr int(11) NOT NULL,datum varchar(20) NOT NULL default '',ip varchar(15) NOT NULL default '',PRIMARY KEY (id))
  SELECT * FROM " . PMF_Db::getTablePrefix() . "faqquestions";
  CREATE TABLE ".$sqltblpre."faqglossary (id integer NOT NULL ,lang varchar(5) NOT NULL ,item varchar(255) NOT NULL ,definition text NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqtags (tagging_id INTEGER NOT NULL,tagging_name VARCHAR(255) NOT NULL ,PRIMARY KEY (tagging_id, tagging_name))
  CREATE TABLE " . $sqltblpre . "faqattachment (id SERIAL NOT NULL,record_id int4 NOT NULL,record_lang varchar(5) NOT NULL,real_hash char(32) NOT NULL,virtual_hash char(32) NOT NULL,password_hash char(40) NULL,filename varchar(255) NOT NULL,filesize int NOT NULL,encrypted int4 NOT NULL DEFAULT 0,mime_type varchar(255) NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqsessions (sid SERIAL NOT NULL,user_id int4 NOT NULL,ip text NOT NULL,time int4 NOT NULL,PRIMARY KEY (sid))
  CREATE TABLE ".$sqltblpre."faquser (user_id INT(11) NOT NULL,login VARCHAR(25) NOT NULL,session_id VARCHAR(150) NULL,session_timestamp INT(11) NULL,ip VARCHAR(15) NULL,account_status VARCHAR(50) NULL,last_login TIMESTAMP(14) NULL,auth_source VARCHAR(100) NULL,member_since TIMESTAMP(14) NULL,remember_me VARCHAR(150) NULL,success INT(1) NULL DEFAULT 1,PRIMARY KEY(user_id))
  CREATE TABLE ".$sqltblpre."faqdata (id SERIAL NOT NULL,lang varchar(5) NOT NULL,solution_id int4 NOT NULL,revision_id int4 NOT NULL DEFAULT 0,active char(3) NOT NULL,sticky INTEGER NOT NULL,keywords text DEFAULT NULL,thema text NOT NULL,content text DEFAULT NULL,author varchar(255) NOT NULL,email varchar(255) NOT NULL,comment char(1) NOT NULL default 'y',datum varchar(15) NOT NULL,links_state varchar(7) DEFAULT NULL,links_check_date int4 DEFAULT 0 NOT NULL,date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',PRIMARY KEY (id, lang))
  SELECT id FROM %sfaqcaptcha', PMF_Db::getTablePrefix());
  CREATE TABLE ".$sqltblpre."faqgroup_right (group_id integer NOT NULL,right_id integer NOT NULL,PRIMARY KEY(group_id, right_id))
  CREATE TABLE ".$sqltblpre."faqcategoryrelations (category_id integer NOT NULL,category_lang varchar(5) NOT NULL,record_id integer NOT NULL,record_lang varchar(5) NOT NULL,PRIMARY KEY (category_id, category_lang, record_id, record_lang))
  CREATE TABLE ".$sqltblpre."faquserdata (user_id integer NOT NULL,last_modified varchar(14) NULL,display_name varchar(50) NULL,email varchar(100) NULL)
  CREATE TABLE ".$sqltblpre."faqdata_revisions (id integer NOT NULL,lang varchar(5) NOT NULL,solution_id integer NOT NULL,revision_id integer NOT NULL DEFAULT 0,active char(3) NOT NULL,sticky INTEGER NOT NULL,keywords text DEFAULT NULL,thema text NOT NULL,content text DEFAULT NULL,author varchar(255) NOT NULL,email varchar(255) NOT NULL,comment char(1) default 'y',datum varchar(15) NOT NULL,links_state varchar(7) DEFAULT NULL,links_check_date integer DEFAULT 0 NOT NULL,date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',PRIMARY KEY (id, lang, solution_id, revision_id))
  CREATE TABLE ".$sqltblpre."faqcomments (id_comment integer NOT NULL,id integer NOT NULL,type varchar(10) NOT NULL,usr varchar(255) NOT NULL,email varchar(255) NOT NULL,comment text NOT NULL,datum varchar(64) NOT NULL,helped text DEFAULT NULL,PRIMARY KEY (id_comment))
  CREATE TABLE ".$sqltblpre."faqvoting (id int(11) unsigned NOT NULL,artikel int(11) unsigned NOT NULL,vote int(11) unsigned NOT NULL,usr int(11) unsigned NOT NULL,datum varchar(20) NOT NULL default '',ip varchar(15) NOT NULL default '',PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faquser_right (user_id integer NOT NULL,right_id integer NOT NULL,PRIMARY KEY (user_id, right_id))
  CREATE TABLE ".$sqltblpre."faqcaptcha (id varchar(6) NOT NULL,useragent varchar(255) NOT NULL,language varchar(5) NOT NULL,ip varchar(64) NOT NULL,captcha_time int(11) NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqdata_group (record_id INT(11) NOT NULL,group_id INT(11) NOT NULL,PRIMARY KEY (record_id, group_id))
  CREATE TABLE ".$sqltblpre."faqsessions (sid integer NOT NULL,user_id integer NOT NULL,ip varchar(64) NOT NULL,time integer NOT NULL,PRIMARY KEY (sid))
  CREATE TABLE ".$sqltblpre."faqdata_revisions (id integer NOT NULL,lang varchar(5) NOT NULL,solution_id int(11) NOT NULL,revision_id int(11) NOT NULL DEFAULT 0,active char(3) NOT NULL,sticky INTEGER NOT NULL,keywords text DEFAULT NULL,thema text NOT NULL,content longtext DEFAULT NULL,author varchar(255) NOT NULL,email varchar(255) NOT NULL,comment char(1) default 'y',datum varchar(15) NOT NULL,links_state VARCHAR(7) DEFAULT NULL,links_check_date INT(11) DEFAULT 0 NOT NULL,date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',PRIMARY KEY (id, lang, solution_id, revision_id))
  CREATE TABLE ".$sqltblpre."faqinstances_config (instance_id INT NOT NULL,config_name VARCHAR(255) NOT NULL default '',config_value VARCHAR(255) DEFAULT NULL,PRIMARY KEY (instance_id, config_name))
  CREATE TABLE ".$sqltblpre."faqvisits (id int(11) NOT NULL,lang varchar(5) NOT NULL,visits int(11) NOT NULL,last_visit int(15) NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqgroup_right (group_id INT(11) NOT NULL,right_id INT(11) UNSIGNED NOT NULL,PRIMARY KEY (group_id, right_id))
  CREATE TABLE ".$sqltblpre."faqvisits (id int(11) NOT NULL,lang varchar(5) NOT NULL,visits int(11) NOT NULL,last_visit int(15) NOT NULL,PRIMARY KEY (id, lang))
  SELECT * FROM %sfaqinstances ORDER BY id
  CREATE TABLE " . $sqltblpre . "faqattachment (id int(11) NOT NULL,record_id int(11) NOT NULL,record_lang varchar(5) NOT NULL,real_hash char(32) NOT NULL,virtual_hash char(32) NOT NULL,password_hash char(40) NULL,filename varchar(255) NOT NULL,filesize int NOT NULL,encrypted tinyint NOT NULL DEFAULT 0,mime_type varchar(255) NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqcomments (id_comment int(11) NOT NULL,id int(11) NOT NULL,type varchar(10) NOT NULL,usr varchar(255) NOT NULL,email varchar(255) NOT NULL,comment text NOT NULL,datum int(15) NOT NULL,helped text DEFAULT NULL,PRIMARY KEY (id_comment))
  CREATE TABLE ".$sqltblpre."faqchanges (id SERIAL NOT NULL,beitrag int4 NOT NULL,lang varchar(5) NOT NULL,revision_id int4 NOT NULL DEFAULT 0,usr int4 NOT NULL,datum int4 NOT NULL,what text DEFAULT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqcategoryrelations (category_id int4 NOT NULL,category_lang VARCHAR(5) NOT NULL,record_id int4 NOT NULL,record_lang VARCHAR(5) NOT NULL,PRIMARY KEY (category_id, category_lang, record_id, record_lang))
  SELECT * FROM " . PMF_Db::getTablePrefix() . "faquserlogin_temp";
  CREATE TABLE ".$sqltblpre."faqcategory_user (category_id INT(11) NOT NULL,user_id INT(11) NOT NULL,PRIMARY KEY (category_id, user_id))
  CREATE TABLE ".$sqltblpre."faqsessions (sid int(11) NOT NULL,user_id INT(11) NOT NULL,ip text NOT NULL,time int(11) NOT NULL,PRIMARY KEY (sid))
  CREATE TABLE ".$sqltblpre."faqdata_revisions (id SERIAL NOT NULL,lang varchar(5) NOT NULL,solution_id int4 NOT NULL,revision_id int4 NOT NULL DEFAULT 0,active char(3) NOT NULL,sticky INTEGER NOT NULL,keywords text DEFAULT NULL,thema text NOT NULL,content text DEFAULT NULL,author varchar(255) NOT NULL,email varchar(255) NOT NULL,comment char(1) default 'y',datum varchar(15) NOT NULL,links_state varchar(7) DEFAULT NULL,links_check_date int4 DEFAULT 0 NOT NULL,date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',PRIMARY KEY (id, lang, solution_id, revision_id))
  CREATE TABLE ".$sqltblpre."faqchanges (id integer NOT NULL,beitrag SMALLINT NOT NULL,lang varchar(5) NOT NULL,revision_id integer NOT NULL DEFAULT 0,usr integer NOT NULL ,datum integer NOT NULL,what text DEFAULT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqchanges (id int(11) NOT NULL,beitrag int(11) NOT NULL,lang varchar(5) NOT NULL,revision_id integer NOT NULL DEFAULT 0,usr int(11) NOT NULL,datum int(11) NOT NULL,what text DEFAULT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqstopwords (id INTEGER NOT NULL,lang VARCHAR(5) NOT NULL,stopword VARCHAR(64) NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqcategory_user (category_id int4 NOT NULL,user_id int4 NOT NULL,PRIMARY KEY (category_id, user_id))
  CREATE TABLE ".$sqltblpre."faquserdata (user_id INT(11) NOT NULL,last_modified VARCHAR(14) NULL,display_name VARCHAR(50) NULL,email VARCHAR(100) NULL,PRIMARY KEY (user_id))
  CREATE TABLE ".$sqltblpre."faqinstances_config (instance_id int4 NOT NULL,config_name VARCHAR(255) NOT NULL default '',config_value VARCHAR(255) DEFAULT NULL,PRIMARY KEY (instance_id, config_name))
  CREATE TABLE ".$sqltblpre."faqdata_tags (record_id INT4 NOT NULL,tagging_id INT4 NOT NULL,PRIMARY KEY (record_id, tagging_id))
  CREATE TABLE ".$sqltblpre."faqgroup (group_id INT(11) NOT NULL,name VARCHAR(25) NULL,description TEXT NULL,auto_join INT(1) NULL,PRIMARY KEY (group_id))
  SELECT * FROM " . PMF_Db::getTablePrefix() . "faquser";
  CREATE TABLE " . $sqltblpre . "faqattachment (id INTEGER NOT NULL,record_id INTEGER NOT NULL,record_lang VARCHAR(5) NOT NULL,real_hash CHAR(32) NOT NULL,virtual_hash CHAR(32) NOT NULL,password_hash CHAR(40) NULL,filename VARCHAR(255) NOT NULL,filesize INTEGER NOT NULL,encrypted INTEGER NOT NULL DEFAULT 0,mime_type VARCHAR(255) NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqcaptcha (id varchar(6) NOT NULL,useragent varchar(255) NOT NULL,language varchar(5) NOT NULL,ip varchar(64) NOT NULL,captcha_time int4 NOT NULL,PRIMARY KEY (id))
  SELECT id FROM $this->table_name WHERE LOWER(stopword) = LOWER('%s') AND lang = '%s'
  CREATE TABLE ".$sqltblpre."faqquestions (id INTEGER NOT NULL,username varchar(100) NOT NULL,email varchar(100) NOT NULL,category_id INTEGER NOT NULL,question text NOT NULL,created varchar(20) NOT NULL,is_visible char(1) default 'Y',answer_id INTEGER NOT NULL DEFAULT 0,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqvisits (id integer NOT NULL,lang varchar(5) NOT NULL,visits SMALLINT NOT NULL,last_visit integer NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqglossary (id INT(11) NOT NULL ,lang VARCHAR(5) NOT NULL ,item VARCHAR(255) NOT NULL ,definition TEXT NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faquserdata (user_id SERIAL NOT NULL,last_modified varchar(14) NULL,display_name VARCHAR(50) NULL,email VARCHAR(100) NULL)
  CREATE TABLE ".$sqltblpre."faqconfig (config_name varchar(255) NOT NULL default '',config_value varchar(255) DEFAULT NULL,PRIMARY KEY (config_name))
  CREATE TABLE ".$sqltblpre."faqadminlog (id SERIAL NOT NULL,time int4 NOT NULL,usr int4 NOT NULL,text text NOT NULL,ip text NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqcomments (id_comment int(11) NOT NULL,id int(11) NOT NULL,type varchar(10) NOT NULL,usr varchar(255) NOT NULL,email varchar(255) NOT NULL,comment text NOT NULL,datum int(15) NOT NULL,helped text DEFAULT NULL,PRIMARY KEY (id_comment))
  CREATE TABLE ".$sqltblpre."faqright (right_id INT(11) NOT NULL,name VARCHAR(50) NULL,description TEXT NULL,for_users INT(1) NULL DEFAULT 1,for_groups INT(1) NULL DEFAULT 1,PRIMARY KEY(right_id))
  CREATE TABLE ".$sqltblpre."faquser_group (user_id INT(11) NOT NULL,group_id INT(11) NOT NULL,PRIMARY KEY (user_id, group_id))
  CREATE TABLE ".$sqltblpre."faqcategory_group (category_id INT(11) NOT NULL,group_id INT(11) NOT NULL,PRIMARY KEY (category_id, group_id))
  CREATE TABLE ".$sqltblpre."faqgroup_right (group_id INT(11) NOT NULL,right_id INT(11) NOT NULL,PRIMARY KEY (group_id, right_id))
  CREATE TABLE ".$sqltblpre."faqcategories (id integer NOT NULL,lang varchar(5) NOT NULL,parent_id SMALLINT NOT NULL,name varchar(255) NOT NULL,description varchar(255) DEFAULT NULL,user_id integer NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqcaptcha (id varchar(6) NOT NULL,useragent varchar(255) NOT NULL,language varchar(5) NOT NULL,ip varchar(64) NOT NULL,captcha_time integer NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqnews (id int(11) NOT NULL,lang varchar(5) NOT NULL,header varchar(255) NOT NULL,artikel text NOT NULL,datum varchar(14) NOT NULL,author_name varchar(255) NULL,author_email varchar(255) NULL,active char(1) default 'y',comment char(1) default 'n',date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',link varchar(255) DEFAULT NULL,linktitel varchar(255) DEFAULT NULL,target varchar(255) NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqcategories (id integer NOT NULL,lang varchar(5) NOT NULL,parent_id INTEGER NOT NULL,name varchar(255) NOT NULL,description varchar(255) DEFAULT NULL,user_id integer NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faquser_right (user_id int4 NOT NULL,right_id int4 NOT NULL,PRIMARY KEY (user_id, right_id))
  CREATE TABLE ".$sqltblpre."faqcategoryrelations (category_id INT(11) NOT NULL,category_lang VARCHAR(5) NOT NULL default '',record_id INT(11) NOT NULL,record_lang VARCHAR(5) NOT NULL default '',PRIMARY KEY (category_id, category_lang, record_id, record_lang),KEY idx_records (record_id, record_lang))
  CREATE TABLE ".$sqltblpre."faquser (user_id INT(11) NOT NULL,login VARCHAR(25) NOT NULL,session_id VARCHAR(150) NULL,session_timestamp INT(11) UNSIGNED NULL,ip VARCHAR(15) NULL,account_status VARCHAR(50) NULL,last_login VARCHAR(14) NULL,auth_source VARCHAR(100) NULL,member_since VARCHAR(14) NULL,remember_me VARCHAR(150) NULL,success INT(1) NULL DEFAULT 1,PRIMARY KEY (user_id),UNIQUE INDEX session(session_id),UNIQUE INDEX login(login))
  CREATE TABLE ".$sqltblpre."faqglossary (id SERIAL NOT NULL,lang VARCHAR(5) NOT NULL,item VARCHAR(255) NOT NULL,definition TEXT NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqdata_tags (record_id INT(11) NOT NULL,tagging_id INT(11) NOT NULL,PRIMARY KEY (record_id, tagging_id))
  CREATE TABLE ".$sqltblpre."faqdata_group (record_id integer NOT NULL,group_id integer NOT NULL,PRIMARY KEY (record_id, group_id))
  CREATE TABLE " . $sqltblpre . "faqattachment_file (virtual_hash CHAR(32) NOT NULL,contents TEXT NOT NULL,PRIMARY KEY (virtual_hash))
  CREATE TABLE ".$sqltblpre."faqcomments (id_comment SERIAL NOT NULL,id int4 NOT NULL,type varchar(10) NOT NULL,usr varchar(255) NOT NULL,email varchar(255) NOT NULL,comment text NOT NULL,datum int4 NOT NULL,helped text DEFAULT NULL,PRIMARY KEY (id_comment))
  CREATE TABLE ".$sqltblpre."faqcategory_user (category_id integer NOT NULL,user_id integer NOT NULL,PRIMARY KEY (category_id, user_id))
  CREATE TABLE ".$sqltblpre."faqvoting (id SERIAL NOT NULL,artikel int4 NOT NULL,vote int4 NOT NULL,usr int4 NOT NULL,datum varchar(20) NOT NULL default '',ip varchar(15) NOT NULL default '',PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqcategory_user (category_id INT(11) NOT NULL,user_id INT(11) NOT NULL,PRIMARY KEY (category_id, user_id))
  CREATE TABLE ".$sqltblpre."faqdata_tags (record_id INTEGER NOT NULL,tagging_id INTEGER NOT NULL,PRIMARY KEY (record_id, tagging_id))
  CREATE TABLE ".$sqltblpre."faqdata_user (record_id int4 NOT NULL,user_id int4 NOT NULL,PRIMARY KEY (record_id, user_id))
  SELECT relname FROM pg_stat_user_tables ORDER BY relname;";
  CREATE TABLE " . $sqltblpre . "faqinstances_config (instance_id INT(11) NOT NULL,config_name VARCHAR(255) NOT NULL default '',config_value VARCHAR(255) DEFAULT NULL,PRIMARY KEY (instance_id, config_name))
  CREATE TABLE ".$sqltblpre."faqcategory_group (category_id integer NOT NULL,group_id integer NOT NULL,PRIMARY KEY (category_id, group_id))
  CREATE TABLE ".$sqltblpre."faquserdata (user_id INT(11) NOT NULL,last_modified TIMESTAMP(14) NULL,display_name VARCHAR(50) NULL,email VARCHAR(100) NULL)
  CREATE TABLE ".$sqltblpre."faquserlogin (login VARCHAR(128) NOT NULL,pass VARCHAR(80) NULL,PRIMARY KEY (login))
  CREATE TABLE ".$sqltblpre."faquser_right (user_id INT(11) NOT NULL,right_id INT(11) NOT NULL,PRIMARY KEY (user_id, right_id))
  CREATE TABLE ".$sqltblpre."faqgroup (group_id integer NOT NULL,name varchar(25) NULL,description text NULL,auto_join integer NULL,PRIMARY KEY(group_id))
  CREATE TABLE ".$sqltblpre."faqchanges (id int(11) NOT NULL,beitrag int(11) NOT NULL,lang varchar(5) NOT NULL,revision_id integer NOT NULL DEFAULT 0,usr int(11) NOT NULL,datum int(11) NOT NULL,what text DEFAULT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faquser_group (user_id int4 NOT NULL,group_id int4 NOT NULL,PRIMARY KEY (user_id, group_id))
  SELECT * FROM '.$row['name']);
  CREATE TABLE ".$sqltblpre."faqdata (id int(11) NOT NULL,lang varchar(5) NOT NULL,solution_id int(11) NOT NULL,revision_id int(11) NOT NULL DEFAULT 0,active char(3) NOT NULL,sticky INTEGER NOT NULL,keywords text DEFAULT NULL,thema text NOT NULL,content longtext DEFAULT NULL,author varchar(255) NOT NULL,email varchar(255) NOT NULL,comment char(1) NOT NULL default 'y',datum varchar(15) NOT NULL,links_state VARCHAR(7) DEFAULT NULL,links_check_date INT(11) DEFAULT 0 NOT NULL,date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqdata_user (record_id INT(11) NOT NULL,user_id INT(11) NOT NULL,PRIMARY KEY (record_id, user_id))
  SELECT relname FROM pg_stat_user_tables WHERE relname LIKE '%sfaq%%' ORDER BY relname
  SELECT count(1) FROM ".$row["relname"].";
  SELECT * FROM " . $table, $table);
  SELECT * FROM %sfaqcategory_%s WHERE category_id = %d AND %s_id = %d
  SELECT name FROM sqlite_master WHERE type='table' ORDER BY name
  SELECT * FROM %sfaqinstances WHERE id = %d
  CREATE TABLE ".$sqltblpre."faqcategories (id INT(11) NOT NULL,lang VARCHAR(5) NOT NULL,parent_id INT(11) NOT NULL,name VARCHAR(255) NOT NULL,description VARCHAR(255) DEFAULT NULL,user_id int(2) NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqcaptcha (id varchar(6) NOT NULL,useragent varchar(255) NOT NULL,language varchar(5) NOT NULL,ip varchar(64) NOT NULL,captcha_time int(11) NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqcategory_group (category_id INT(11) NOT NULL,group_id INT(11) NOT NULL,PRIMARY KEY (category_id, group_id))
  CREATE TABLE ".$sqltblpre."faqquestions (id integer NOT NULL,username varchar(100) NOT NULL,email varchar(100) NOT NULL,category_id integer NOT NULL,question text NOT NULL,created varchar(20) NOT NULL,is_visible char(1) default 'Y',answer_id INTEGER NOT NULL DEFAULT 0,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faquser_group (user_id integer NOT NULL,group_id integer NOT NULL,PRIMARY KEY (user_id, group_id))
  CREATE TABLE ".$sqltblpre."faqquestions (id int(11) NOT NULL,username varchar(100) NOT NULL,email varchar(100) NOT NULL,category_id int(11) NOT NULL,question text NOT NULL,created varchar(20) NOT NULL,is_visible char(1) default 'Y',answer_id INTEGER NOT NULL DEFAULT 0,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqtags (tagging_id SERIAL NOT NULL,tagging_name VARCHAR(255) NOT NULL,PRIMARY KEY (tagging_id, tagging_name))
  CREATE TABLE ".$sqltblpre."faqdata_group (record_id INT(11) NOT NULL,group_id INT(11) NOT NULL,PRIMARY KEY (record_id, group_id))
  CREATE TABLE ".$sqltblpre."faqnews (id SERIAL NOT NULL,lang varchar(5) NOT NULL,header varchar(255) NOT NULL,artikel text NOT NULL,datum varchar(14) NOT NULL,author_name varchar(255) NULL,author_email varchar(255) NULL,active char(1) default 'y',comment char(1) default 'n',date_start varchar(14) NOT NULL DEFAULT '00000000000000',date_end varchar(14) NOT NULL DEFAULT '99991231235959',link varchar(255) DEFAULT NULL,linktitel varchar(255) DEFAULT NULL,target varchar(255) NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqcategory_group (category_id int4 NOT NULL,group_id int4 NOT NULL,PRIMARY KEY (category_id, group_id))
  CREATE TABLE ".$sqltblpre."faqright (right_id SERIAL NOT NULL,name VARCHAR(50) NULL,description TEXT NULL,for_users int4 NULL DEFAULT 1,for_groups int4 NULL DEFAULT 1,PRIMARY KEY (right_id))
  CREATE TABLE ".$sqltblpre."faqvisits (id SERIAL NOT NULL,lang varchar(5) NOT NULL,visits int4 NOT NULL,last_visit int4 NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqgroup (group_id INT(11) NOT NULL,name VARCHAR(25) NULL,description TEXT NULL,auto_join INT(1) UNSIGNED NULL,PRIMARY KEY (group_id),UNIQUE INDEX name(name))
  CREATE TABLE ".$sqltblpre."faqadminlog (id integer NOT NULL,time integer NOT NULL,usr integer NOT NULL,text VARCHAR(8000) NOT NULL,ip varchar(64) NOT NULL,PRIMARY KEY (id))
  CREATE TABLE ".$sqltblpre."faqtags (tagging_id INT(11) NOT NULL,tagging_name VARCHAR(255) NOT NULL ,PRIMARY KEY (tagging_id, tagging_name))
  CREATE TABLE ".$sqltblpre."faqright (right_id INT(11) UNSIGNED NOT NULL,name VARCHAR(50) NULL,description TEXT NULL,for_users INT(1) NULL DEFAULT 1,for_groups INT(1) NULL DEFAULT 1,PRIMARY KEY (right_id))
  CREATE TABLE ".$sqltblpre."faqright (right_id integer NOT NULL,name varchar(50) NULL,description text NULL,for_users integer NULL DEFAULT 1,for_groups integer NULL DEFAULT 1,PRIMARY KEY (right_id))
  CREATE TABLE ".$sqltblpre."faqcategories (id INT(11) NOT NULL,lang VARCHAR(5) NOT NULL,parent_id INT(11) NOT NULL,name VARCHAR(255) NOT NULL,description VARCHAR(255) DEFAULT NULL,user_id INT(11) NOT NULL,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqsearches (id INTEGER NOT NULL ,lang VARCHAR(5) NOT NULL ,searchterm VARCHAR(255) NOT NULL ,searchdate DATETIME,PRIMARY KEY (id, lang))
  CREATE TABLE ".$sqltblpre."faqdata_tags (record_id INT(11) NOT NULL,tagging_id INT(11) NOT NULL,PRIMARY KEY (record_id, tagging_id))
  CREATE TABLE " . $sqltblpre . "faqinstances (id INT(11) NOT NULL,url VARCHAR(255) NOT NULL,instance VARCHAR(255) NOT NULL,comment TEXT NULL,created DATETIME NOT NULL,modified DATETIME NOT NULL,PRIMARY KEY (id))
  