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,showdates BOOLEAN NOT NULL DEFAULT 1,enabled BOOLEAN NOT NULL DEFAULT 1,comment VARCHAR(255) NOT NULL,dir VARCHAR(150) NULL,forreg BOOLEAN NOT NULL DEFAULT 0,sectionone 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,publish INT(11) NOT NULL DEFAULT 0,newsletters JSON,doreports BOOLEAN NOT NULL DEFAULT 0,reports JSON,prolocationid INT(11) NOT NULL,closed BOOLEAN NOT NULL DEFAULT 0,modified DATETIME NULL,created DATETIME NULL,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 DATE 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,newsletters JSON,modified DATETIME NULL,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,childsection INT(4) NOT NULL DEFAULT 0,modified DATETIME NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_people_info` (id INT(11) NOT NULL AUTO_INCREMENT, propeople INT(11) NOT 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,infosection INT(4) NOT NULL DEFAULT 0,PRIMARY KEY (id)'PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_location_child` (id INT(11) NOT NULL AUTO_INCREMENT, prolocation INT(11) NOT 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,childsection INT(4) NOT NULL DEFAULT 0,modified DATETIME NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_location_info` (id INT(11) NOT NULL AUTO_INCREMENT, prolocation INT(11) NOT 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,infosection INT(4) NOT NULL DEFAULT 0,modified DATETIME NULL,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,html BOOLEAN NOT NULL DEFAULT 0,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,displayorder INT(11) NULL,prometatype INT(11) NOT NULL DEFAULT 0,prometatsub INT(11) NOT NULL DEFAULT 0,settingsblob BLOB NULL,closed BOOLEAN NOT NULL DEFAULT 0,enabled BOOLEAN NOT NULL DEFAULT 1,prosettingsid int(11) null,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,proemailid INT(11) 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,prometasub INT(11) NOT NULL DEFAULT 0,enabled BOOLEAN NOT NULL DEFAULT 1,closed BOOLEAN NOT NULL DEFAULT 0,testto VARCHAR(75) NOT NULL,metavalue JSON,contains JSON,prolocation 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,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,comment VARCHAR(255) NOT NULL,accepted BOOLEAN NOT NULL DEFAULT 0,publish INT(11) NOT NULL DEFAULT 0,newsletters JSON,options JSON,modified DATETIME NULL,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,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,childsection INT(4) NOT NULL DEFAULT 0,modified DATETIME NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_registration_info` (id INT(11) NOT NULL AUTO_INCREMENT, proregistration INT(11) NOT 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,infosection INT(4) NOT NULL DEFAULT 0,modified DATETIME NULL,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,proreportid INT(11) NOT NULL,closed BOOLEAN 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", "true", "false") 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", "true", "false") 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", "true", "false") 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,orderby BOOLEAN NOT NULL DEFAULT 0,theorder BOOLEAN NOT NULL DEFAULT 0,proreportitemid INT(11) NOT NULL,closed BOOLEAN NOT NULL DEFAULT 0,PRIMARY KEY (id)');
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,metavalue JSON,actionorder INT(5) NOT NULL DEFAULT 0,dateplus INT(11) NOT NULL,nextnumber INT(11) NOT NULL,enabled BOOLEAN NOT NULL DEFAULT 1,proreportactionid INT(11) NOT NULL,closed BOOLEAN NOT NULL DEFAULT 0,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,prometaid 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,prometaid 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,prometacat2 INT(11) NOT NULL DEFAULT 0,prometacat3 INT(11) NOT NULL DEFAULT 0,enabled BOOLEAN NOT NULL DEFAULT 1,referee_enabled BOOLEAN NOT NULL DEFAULT 1,comment VARCHAR(75) NOT NULL,newsletters JSON,modified DATETIME NULL,569);
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,modified DATETIME 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,modified DATETIME NULL,PRIMARY KEY (id)');
CREATE TABLE IF NOT EXISTS `pro_newsletters` (id INT(11) NOT NULL AUTO_INCREMENT, next INT(11) NOT NULL DEFAULT 0,name VARCHAR(255) NOT NULL,description BLOB NULL,pronewsletterid INT(11) NOT NULL,emailsubject VARCHAR(255) NOT NULL,emailbody BLOB NULL,created DATETIME NOT NULL,modified DATETIME NOT NULL,displayorder INT(11) NULL,prometatype INT(11) NOT NULL DEFAULT 0,gapdays INT(11) NOT NULL DEFAULT 0,testto VARCHAR(75) NOT NULL,enabled BOOLEAN NOT NULL DEFAULT 1,closed BOOLEAN NOT NULL DEFAULT 0,prolocation INT(11) NOT NULL,proregistration INT(11) NOT NULL,template INT(11) NOT NULL DEFAULT 0,publish INT(11) NOT NULL DEFAULT 0,schedule_time DATETIME NOT NULL DEFAULT "2000-01-01 08:00:00",run BOOLEAN NOT NULL DEFAULT 0,lastrun DATETIME NOT NULL,delays JSON,progression JSON,pinned BOOLEAN NOT NULL DEFAULT 0,PRIMARY KEY (id)');