CREATE TABLE IF NOT EXISTS `pro_location` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,email VARCHAR(150) NOT NULL,parentlocation INT(11) NOT NULL DEFAULT 0,startdate DATE NULL,enddate DATE NULL,enabled BOOLEAN NOT NULL DEFAULT 1,comment VARCHAR(255) NOT NULL,dir VARCHAR(150) NULL,forreg  BOOLEAN NOT NULL DEFAULT 0,regorder INT(3) NOT NULL DEFAULT 999,prometatyperegistration INT(11) NOT NULL DEFAULT 0,prometacatregistration INT(11) NOT NULL DEFAULT 0,prometatypepeople INT(11) NOT NULL DEFAULT 0,prometacatpeople INT(11) NOT NULL DEFAULT 0,email_body BLOB NULL,prometa INT(11) NOT NULL DEFAULT 0,prometatype INT(11) NOT NULL DEFAULT 0,prometacat INT(11) NOT NULL DEFAULT 0,prometacat2 INT(11) NOT NULL DEFAULT 0,prometacat3 INT(11) NOT NULL DEFAULT 0,canparent BOOLEAN NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_location_staff` (id INT(11) NOT NULL AUTO_INCREMENT, staff INT(11) NOT NULL,prolocation INT(11) NOT NULL,prolocationposition INT(11) NOT NULL,created DATETIME NULL,description BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_location_position` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_location_connect` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,prolocation INT(11) NOT NULL,prolocationconnectiontype INT(11) NOT NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_location_connect_type` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_people` (id INT(11) NOT NULL AUTO_INCREMENT, first_name VARCHAR(75) NOT NULL,last_name VARCHAR(75) NOT NULL,name VARCHAR(75) NOT NULL,prolocation INT(11) NOT NULL,description BLOB NULL,canreferee BOOLEAN NOT NULL DEFAULT 0,email VARCHAR(150) NOT NULL,dob DATETIME NULL,created DATETIME NULL,lastlogin DATETIME NULL,cell VARCHAR(75) NOT NULL,user INT(11) NULL,firstpage VARCHAR(150) NULL,propeopletype INT(11) NOT NULL,comment VARCHAR(255) NOT NULL,propeoplecategory INT(11) NOT NULL,gender BOOLEAN NOT NULL DEFAULT 1,enabled BOOLEAN NOT NULL DEFAULT 1,prometa INT(11) NOT NULL DEFAULT 0,prometatype INT(11) NOT NULL DEFAULT 0,prometacat INT(11) NOT NULL DEFAULT 0,prometacat2 INT(11) NOT NULL DEFAULT 0,prometacat3 INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_people_child` (id INT(11) NOT NULL AUTO_INCREMENT, propeople INT(11) NOT NULL,propeoplechildtype INT(11) NOT NULL,propeoplechildsubtype INT(11) NULL,childtext VARCHAR(255)  NULL,childdate DATE NULL,childdatetime DATETIME NULL,childboolean BOOLEAN NULL,childinteger INTEGER NULL,childfloat FLOAT NULL,childblob BLOB NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometasub INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_people_info` (id INT(11) NOT NULL AUTO_INCREMENT, propeople INT(11) NOT NULL,propeopleinfotype INT(11) NOT NULL,propeopleinfosubtype INT(11) NULL,infotext VARCHAR(255)  NULL,infodate DATE NULL,infodatetime DATETIME NULL,infoboolean BOOLEAN NULL,infointeger INTEGER NULL,infofloat FLOAT NULL,infoblob BLOB NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometasub INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_location_child` (id INT(11) NOT NULL AUTO_INCREMENT, prolocation INT(11) NOT NULL,prolocationchildtype INT(11) NOT NULL,prolocationchildsubtype INT(11) NULL,childtext VARCHAR(255)  NULL,childdate DATE NULL,childdatetime DATETIME NULL,childboolean BOOLEAN NULL,childinteger INTEGER NULL,childfloat FLOAT NULL,childblob BLOB NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometasub INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_location_info` (id INT(11) NOT NULL AUTO_INCREMENT, prolocation INT(11) NOT NULL,prolocationinfotype INT(11) NOT NULL,prolocationinfosubtype INT(11) NULL,infotext VARCHAR(255)  NULL,infodate DATE NULL,infodatetime DATETIME NULL,infoboolean BOOLEAN NULL,infointeger INTEGER NULL,infofloat FLOAT NULL,infoblob BLOB NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometasub INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_display_type` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(75) NOT NULL,description BLOB NULL,open VARCHAR(50) NOT NULL,close VARCHAR(10) NOT NULL,fortext BOOLEAN NULL,fordate BOOLEAN NULL,fordatetime BOOLEAN NULL,forboolean BOOLEAN NULL,forinteger BOOLEAN NULL,forfloat BOOLEAN NULL,forblob BOOLEAN NULL,forselect BOOLEAN NULL,fororder VARCHAR(20) NULL,readonly BOOLEAN NOT NULL DEFAULT 0,adminonly BOOLEAN NOT NULL DEFAULT 0,superadminonly BOOLEAN NOT NULL DEFAULT 0,defaulttext VARCHAR(255)  NULL,defaultdate DATETIME NULL,defaultdatetime DATETIME NULL,defaultboolean BOOLEAN NULL,defaultinteger INTEGER NULL,defaultfloat FLOAT NULL,defaultblob BLOB NULL,errorcolor VARCHAR(15),errordisplay BOOLEAN NULL,errortext VARCHAR(20) NULL,errordate VARCHAR(20) NULL,errordatetime VARCHAR(20) NULL,errorboolean VARCHAR(20) NULL,errorinteger VARCHAR(20) NULL,errorfloat VARCHAR(20) NULL,errorblob VARCHAR(20) NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_settings` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometatsub INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_settings_items` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,settingstype INT(11) NOT NULL,prometatype INT(11) NOT NULL DEFAULT 0,settingstext VARCHAR(255)  NULL,settingsdate DATE NULL,settingsdatetime DATETIME NULL,settingsboolean BOOLEAN NULL,settingsinteger INTEGER NULL,settingsfloat FLOAT NULL,settingsblob BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_settings_type` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(75) NOT NULL,description BLOB NULL,displayorder INT(11) NULL,displaytype INT(11) NOT NULL,enabled BOOLEAN NOT NULL DEFAULT 1,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_pages` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,categories VARCHAR(100) NOT NULL,url VARCHAR(100) NOT NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_all_tables` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(100) NOT NULL,fullname VARCHAR(100) NOT NULL,description BLOB NULL,date DATE NOT NULL,candelete  BOOLEAN NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_audit` (id INT(11) NOT NULL AUTO_INCREMENT, created DATETIME NOT NULL,actor_user INT(11) NOT NULL DEFAULT 0,actor_people INT(11) NOT NULL DEFAULT 0,action VARCHAR(25) NOT NULL DEFAULT "update",fortable VARCHAR(50) NOT NULL DEFAULT "",forid INT(11) NOT NULL DEFAULT 0,childtable VARCHAR(50) NOT NULL DEFAULT "",childid INT(11) NOT NULL DEFAULT 0,source VARCHAR(30) NOT NULL DEFAULT "admin",summary VARCHAR(255) NOT NULL DEFAULT "",changed JSON NULL,beforerec JSON NULL,afterrec JSON NULL,prometatype INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id),KEY idx_for (fortable, forid, created),KEY idx_actor (actor_user, created),KEY idx_action (action, created)');
CREATE TABLE IF NOT EXISTS `pro_people_connect` (id INT(11) NOT NULL AUTO_INCREMENT, propeopleparent INT(11) NOT NULL,propeoplechild INT(11) NOT NULL,propeopleconnecttype INT(11) NOT NULL,date DATETIME NOT NULL,comment BLOB NULL,prometatype INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_people_connect_type` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_document` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,document BLOB NULL,created DATETIME NOT NULL,modified DATETIME NOT NULL,propeople INT(11) NOT NULL,prodocumenttype INT(11) NOT NULL,prometatype INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_validation` (id INT(11) NOT NULL AUTO_INCREMENT, propeople INT(11) NOT NULL,prolocation INT(11) NOT NULL,validation_code varchar(255) NOT NULL,is_valid tinyint(1) DEFAULT 1 NOT NULL,created_at DATETIME NOT NULL,date_used  DATETIME NOT NULL,procampaignprofile INT(11) NOT NULL,email VARCHAR(150) NOT NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_emails` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,emailsubject VARCHAR(255) NOT NULL,emailbody BLOB NULL,created DATETIME NOT NULL,modified DATETIME NOT NULL,propeopletype INT(11) NOT NULL,forall BOOLEAN NOT NULL DEFAULT 0,prometatype INT(11) NOT NULL DEFAULT 0,prometaub INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_campaign` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,procampaigntype INT(11) NOT NULL, enabled BOOLEAN NOT NULL DEFAULT 1,procampaigndefaultquestion INT(11) NOT NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_campaign_type` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,enabled BOOLEAN NOT NULL DEFAULT 1,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_campaign_profile` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,procampaign INT(11) NOT NULL, prolocation INT(11) NOT NULL DEFAULT 0,  propeople INT(11) NOT NULL DEFAULT 0, enabled BOOLEAN NOT NULL DEFAULT 1,323);
CREATE TABLE IF NOT EXISTS `pro_campaign_participant` (id INT(11) NOT NULL AUTO_INCREMENT, propeople INT(11) NOT NULL,procampaignprofile INT(11) NOT NULL, PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_campaign_question` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(125) NOT NULL,procampaignprofile INT(11) NOT NULL, whoanswered INT(11) NOT NULL, PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_campaign_question_item` (id INT(11) NOT NULL AUTO_INCREMENT, procampaignquestion INT(11) NOT NULL, question VARCHAR(255) NOT NULL,description BLOB NULL,propeoplechildtype INT(11) NOT NULL DEFAULT 0,propeopleinfotype INT(11) NOT NULL DEFAULT 0,people BOOLEAN NOT NULL DEFAULT 0,propeoplefield INT(11) NOT NULL DEFAULT 0,prolocationchildtype INT(11) NOT NULL DEFAULT 0,prolocationinfotype INT(11) NOT NULL DEFAULT 0,location BOOLEAN NOT NULL DEFAULT 0,prolocationfield INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_campaign_default_question` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(125) NOT NULL,description BLOB NULL,procampaigntype INT(11) NOT NULL, PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_campaign_default_question_item` (id INT(11) NOT NULL AUTO_INCREMENT, procampaigndefaultquestion INT(11) NOT NULL, question VARCHAR(255) NOT NULL,description BLOB NULL,propeoplechildtype INT(11) NOT NULL DEFAULT 0,propeopleinfotype INT(11) NOT NULL DEFAULT 0,people BOOLEAN NOT NULL DEFAULT 0,propeoplefield INT(11) NOT NULL DEFAULT 0,prolocationchildtype INT(11) NOT NULL DEFAULT 0,prolocationinfotype INT(11) NOT NULL DEFAULT 0,location BOOLEAN NOT NULL DEFAULT 0,prolocationfield INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_campaign_result` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,procampaignprofile INT(11) NOT NULL, html BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_campaign_result_item` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,action BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_registration` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,parentregistration INT(11) NOT NULL DEFAULT 0,enabled BOOLEAN NOT NULL DEFAULT 1,proregistrationtype INT(11) NOT NULL,proregistrationcategory INT(11) NOT NULL,prolocation INT(11) NULL,propeople INT(11) NULL,created DATE NOT NULL,prometa INT(11) NOT NULL DEFAULT 0,prometatype INT(11) NOT NULL DEFAULT 0,prometacat INT(11) NOT NULL DEFAULT 0,prometacat2 INT(11) NOT NULL DEFAULT 0,prometacat3 INT(11) NOT NULL DEFAULT 0,canparent BOOLEAN NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_registration_position` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_registration_connect` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,proregistration INT(11) NOT NULL,proregistrationconnectiontype INT(11) NOT NULL,prometatype INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_registration_connect_type` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_registration_child` (id INT(11) NOT NULL AUTO_INCREMENT, proregistration INT(11) NOT NULL,proregistrationchildtype INT(11) NOT NULL,proregistrationchildsubtype INT(11) NULL,childtext VARCHAR(255)  NULL,childdate DATE NULL,childdatetime DATETIME NULL,childboolean BOOLEAN NULL,childinteger INTEGER NULL,childfloat FLOAT NULL,childblob BLOB NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometasub INT(11) NOT NULL DEFAULT 0,accepted BOOLEAN NOT NULL DEFAULT 0,comment BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_registration_info` (id INT(11) NOT NULL AUTO_INCREMENT, proregistration INT(11) NOT NULL,proregistrationinfotype INT(11) NOT NULL,proregistrationinfosubtype INT(11) NULL,infotext VARCHAR(255)  NULL,infodate DATE NULL,infodatetime DATETIME NULL,infoboolean BOOLEAN NULL,infointeger INTEGER NULL,infofloat FLOAT NULL,infoblob BLOB NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometasub INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_report` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,description BLOB NULL,proreporttype INT(11) NOT NULL,export BOOLEAN NOT NULL DEFAULT 0,prometatype INT(11) NOT NULL DEFAULT 0,showid INT(11) NOT NULL DEFAULT 0,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_report_item` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,proreport INT(11) NOT NULL,baseitem enum("people","location", "registration") DEFAULT NULL,basefield VARCHAR(25) NULL,basesearch enum("all", "Do Not Use", "equal", "like", "not equal", "greater than", "less than") DEFAULT "Do Not Use",basevalue VARCHAR(50) NULL,basechild VARCHAR(50) NULL,basechildsearch enum("all", "Do Not Use", "equal", "like", "not equal", "greater than", "less than") DEFAULT "Do Not Use",basechildvalue VARCHAR(50) NULL,baseinfo VARCHAR(50) NULL,baseinfosearch enum("all", "Do Not Use", "equal", "like", "not equal", "greater than", "less than") DEFAULT "Do Not Use",baseinfovalue VARCHAR(50) NULL,searchby BOOLEAN NOT NULL DEFAULT 0,reportby BOOLEAN NOT NULL DEFAULT 0,itemorder INT(5) NOT NULL DEFAULT 0,661);
CREATE TABLE IF NOT EXISTS `pro_report_action` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(75) NOT NULL,description BLOB NULL,proreport INT(11) NOT NULL,proreportitem INT(11) NOT NULL,dateplus INT(11) NOT NULL,nextnumber INT(11) NOT NULL,enabled BOOLEAN NOT NULL DEFAULT 1,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_meta` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(150) NOT NULL,prometaoption INT(11) NOT NULL,prometatable INT(11) NOT NULL,metavalue JSON,enabled BOOLEAN NOT NULL DEFAULT 1,plr BOOLEAN NOT NULL DEFAULT 0,contains JSON,closed BOOLEAN NOT NULL DEFAULT 0,PRIMARY KEY (id),KEY idx_prometatable (prometatable),KEY idx_prometaoption (prometaoption)');
CREATE TABLE IF NOT EXISTS `pro_meta_item` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(150) NOT NULL,prometaoption INT(11) NOT NULL,prometatable INT(11) NOT NULL,metavalue JSON,enabled BOOLEAN NOT NULL DEFAULT 1,plr BOOLEAN NOT NULL DEFAULT 0,PRIMARY KEY (id),KEY idx_prometatable (prometatable),KEY idx_prometaoption (prometaoption)');
CREATE TABLE IF NOT EXISTS `pro_meta_data` (id INT(11) NOT NULL AUTO_INCREMENT, prometa INT(11) NOT NULL,fortable INT(11) NOT NULL,forid INT(11) NOT NULL,metavalue JSON,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_meta_option` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(75) NOT NULL,description BLOB NULL,displayorder INT(11) NULL,enabled BOOLEAN NOT NULL DEFAULT 1,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_meta_table` (id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(75) NOT NULL,plr BOOLEAN NOT NULL DEFAULT 1,enabled BOOLEAN NOT NULL DEFAULT 1,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_reference` (id INT(11) NOT NULL AUTO_INCREMENT, first_name VARCHAR(255) NOT NULL,last_name VARCHAR(255) NOT NULL,description BLOB NULL,proregistration INT(11) NOT NULL DEFAULT 0,created DATE NOT NULL,prometa INT(11) NOT NULL DEFAULT 0,registrar INT(11) NOT NULL DEFAULT 0,registrant INT(11) NOT NULL DEFAULT 0,referee INT(11) NOT NULL DEFAULT 0,referee_email VARCHAR(100) NOT NULL,category INT(11) NOT NULL DEFAULT 0,type INT(11) NOT NULL DEFAULT 0,prometatype INT(11) NOT NULL DEFAULT 0,prometacat INT(11) NOT NULL DEFAULT 0,enabled BOOLEAN NOT NULL DEFAULT 1,referee_enabled BOOLEAN NOT NULL DEFAULT 1,comment VARCHAR(75) NOT NULL,744);
CREATE TABLE IF NOT EXISTS `pro_reference_child` (id INT(11) NOT NULL AUTO_INCREMENT, proreference INT(11) NOT NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometasub INT(11) NOT NULL DEFAULT 0,childtext VARCHAR(255)  NULL,childdate DATE NULL,childdatetime DATETIME NULL,childboolean BOOLEAN NULL,childinteger INTEGER NULL,childfloat FLOAT NULL,childblob BLOB NULL,accepted BOOLEAN NOT NULL DEFAULT 0,comment BLOB NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_reference_info` (id INT(11) NOT NULL AUTO_INCREMENT, proreference INT(11) NOT NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometasub INT(11) NOT NULL DEFAULT 0,infotext VARCHAR(255)  NULL,infodate DATE NULL,infodatetime DATETIME NULL,infoboolean BOOLEAN NULL,infointeger INTEGER NULL,infofloat FLOAT NULL,infoblob BLOB NULL,PRIMARY KEY (id)');