mysql problems by installing concrete5
Permalink
I want to install concrete5 as an replacement for my current website. I have done a test on my local machine everything went well. Now I want to install it on the server from my hosting company and I get the following error :
mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create table areagroupblocktypes ( cid integer(10) unsi' at line 1] in EXECUTE("create table areagroupblocktypes ( cid integer(10) unsigned not null default 0, arhandle varchar(255) not null, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, btid integer(10) unsigned not null default 0, primary key (cid, arhandle, gid, uid, btid) ); create table areagroups ( cid integer(10) unsigned not null default 0, arhandle varchar(255) not null, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, agpermissions varchar(64) not null, primary key (cid, arhandle, gid, uid) ); create table areas ( arid integer(10) unsigned not null auto_increment, cid integer(10) unsigned not null default 0, arhandle varchar(255) not null, aroverridecollectionpermissions tinyint(1) not null default 0, arinheritpermissionsfromareaoncid integer(10) unsigned not null default 0, primary key (arid) ); create table attributesetkeys ( akid integer(10) unsigned not null default 0, asid integer(10) unsigned not null default 0, displayorder integer(10) unsigned not null default 0, primary key (akid, asid) ); create table attributesets ( asid integer(10) unsigned not null auto_increment, asname varchar(255), ashandle varchar(255) not null, akcategoryid integer(10) unsigned not null default 0, pkgid integer(10) unsigned not null default 0, primary key (asid) ); create table attributekeys ( akid integer(10) unsigned not null auto_increment, akhandle varchar(255) not null, akname varchar(255) not null, akissearchable tinyint(1) not null default 0, akissearchableindexed tinyint(1) not null default 0, akisautocreated tinyint(1) not null default 0, akiscolumnheader tinyint(1) not null default 0, akiseditable tinyint(1) not null default 0, atid integer(10) unsigned, akcategoryid integer(10) unsigned, pkgid integer(10) unsigned, primary key (akid) ); alter table attributekeys add unique index akhandle (akhandle, akcategoryid); create table attributekeycategories ( akcategoryid integer(10) unsigned not null auto_increment, akcategoryhandle varchar(255) not null, akcategoryallowsets smallint(4) not null default 0, pkgid integer(10) unsigned, primary key (akcategoryid) ); create table attributetypecategories ( atid integer(10) unsigned not null default 0, akcategoryid integer(10) unsigned not null default 0, primary key (atid, akcategoryid) ); create table attributetypes ( atid integer(10) unsigned not null auto_increment, athandle varchar(255) not null, atname varchar(255) not null, pkgid integer(10) unsigned, primary key (atid) ); create table attributevalues ( avid integer(10) unsigned not null auto_increment, akid integer(10) unsigned, avdateadded datetime not null default '0000-00-00 00:00:00', uid integer(10) unsigned, atid integer(10) unsigned, primary key (avid) ); create table blockrelations ( brid integer(10) unsigned not null auto_increment, bid integer(10) unsigned not null default 0, originalbid integer(10) unsigned not null default 0, relationtype varchar(50) not null, primary key (brid) ); create table blocktypes ( btid integer(10) unsigned not null auto_increment, bthandle varchar(32) not null, btname varchar(128) not null, btdescription text, btactivewhenadded tinyint(1) not null default 1, btcopywhenpropagate tinyint(1) not null default 0, btincludeall tinyint(1) not null default 0, btisinternal tinyint(1) not null default 0, btinterfacewidth integer(10) unsigned not null default 400, btinterfaceheight integer(10) unsigned not null default 400, pkgid integer(10) unsigned not null default 0, primary key (btid) ); alter table blocktypes add unique index bthandle (bthandle); create table blocks ( bid integer(10) unsigned not null auto_increment, bname varchar(60), bdateadded datetime not null default '0000-00-00 00:00:00', bdatemodified datetime not null default '0000-00-00 00:00:00', bfilename varchar(32), bisactive varchar(1) not null default '1', btid integer(10) unsigned not null default 0, uid integer(10) unsigned, primary key (bid) ); create table collectionattributevalues ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 0, akid integer(10) unsigned not null default 0, avid integer(10) unsigned not null default 0, primary key (cid, cvid, akid, avid) ); create table collectionversionblockpermissions ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 1, bid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, cbgpermissions varchar(32), primary key (cid, cvid, bid, gid, uid) ); create table collectionversionblocks ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 1, bid integer(10) unsigned not null default 0, arhandle varchar(255) not null, cbdisplayorder integer(10) unsigned not null default 0, isoriginal varchar(1) not null default '0', cboverrideareapermissions tinyint(1) not null default 0, cbincludeall tinyint(1) not null default 0, primary key (cid, cvid, bid, arhandle) ); alter table collectionversionblocks add index cbincludeall (cbincludeall); create table collectionversionblockstyles ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 0, bid integer(10) unsigned not null default 0, arhandle varchar(255) not null, csrid integer(10) unsigned not null default 0, primary key (cid, cvid, bid, arhandle) ); create table collectionversionarealayouts ( cvalid integer(10) unsigned not null auto_increment, cid integer(10) unsigned default 0, cvid integer(10) unsigned default 0, arhandle varchar(255), layoutid integer(10) unsigned not null default 0, position integer(10) default 1000, areanamenumber integer(10) unsigned default 0, primary key (cvalid) ); alter table collectionversionarealayouts add index arealayoutsindex (cid, cvid, arhandle); create table collectionversionareastyles ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 0, arhandle varchar(255) not null, csrid integer(10) unsigned not null default 0, primary key (cid, cvid, arhandle) ); create table collectionversions ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 1, cvname text, cvhandle varchar(64), cvdescription text, cvdatepublic datetime, cvdatecreated datetime not null default '0000-00-00 00:00:00', cvcomments varchar(255), cvisapproved tinyint(1) not null default 0, cvisnew tinyint(1) not null default 0, cvauthoruid integer(10) unsigned, cvapproveruid integer(10) unsigned, cvactivatedatetime datetime, primary key (cid, cvid) ); alter table collectionversions add index cvisapproved (cvisapproved); alter table collectionversions add index cvname (cvname(128)); create table collections ( cid integer(10) unsigned not null auto_increment, cdateadded datetime not null default '0000-00-00 00:00:00', cdatemodified datetime not null default '0000-00-00 00:00:00', chandle varchar(255), primary key (cid) ); alter table collections add index cdatemodified (cdatemodified); alter table collections add index cdateadded (cdateadded); create table config ( cfkey varchar(64) not null, timestamp timestamp not null, cfvalue longtext, uid integer(10) unsigned not null default 0, pkgid integer(10) unsigned not null default 0, primary key (cfkey, uid) ); alter table config add index uid (uid); create table dashboardhomepage ( dbhid integer(10) unsigned not null auto_increment, dbhmodule varchar(255) not null, dbhdisplayname varchar(255), dbhdisplayorder integer(10) unsigned not null default 0, pkgid integer(10) unsigned not null default 0, primary key (dbhid) ); create table downloadstatistics ( dsid integer(10) unsigned not null auto_increment, fid integer(10) unsigned not null, fvid integer(10) unsigned not null, uid integer(10) unsigned not null, rcid integer(10) unsigned not null, timestamp timestamp not null, primary key (dsid) ); create table fileattributevalues ( fid integer(10) unsigned not null default 0, fvid integer(10) unsigned not null default 0, akid integer(10) unsigned not null default 0, avid integer(10) unsigned not null default 0, primary key (fid, fvid, akid, avid) ); create table filepermissionfiletypes ( fsid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, extension varchar(32) not null, primary key (fsid, gid, uid, extension) ); create table customstylepresets ( cspid integer(10) unsigned not null auto_increment, cspname varchar(255) not null, csrid integer(10) unsigned not null default 0, primary key (cspid) ); create table customstylerules ( csrid integer(10) unsigned not null auto_increment, css_id varchar(128), css_class varchar(128), css_serialized text, css_custom text, primary key (csrid) ); create table filepermissions ( fid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, canread integer(4) not null default 0, canwrite integer(4) not null default 0, canadmin integer(4) not null default 0, cansearch integer(4) not null default 0, primary key (fid, gid, uid) ); create table taskpermissionusergroups ( tpid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, canread integer(1) not null default 0, primary key (tpid, gid, uid) ); create table taskpermissions ( tpid integer(10) unsigned not null auto_increment, tphandle varchar(255), tpname varchar(255), tpdescription text, pkgid integer(10) unsigned not null default 0, primary key (tpid) ); alter table taskpermissions add unique index tphandle (tphandle); create table filesetpermissions ( fsid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, canread integer(4), canwrite integer(4), canadmin integer(4), canadd integer(4), cansearch integer(3) unsigned, primary key (fsid, gid, uid) ); alter table filesetpermissions add index canread (canread); alter table filesetpermissions add index canwrite (canwrite); alter table filesetpermissions add index canadmin (canadmin); alter table filesetpermissions add index cansearch (cansearch); alter table filesetpermissions add index canadd (canadd); create table fileversions ( fid integer(10) unsigned not null default 0, fvid integer(10) unsigned not null default 0, fvfilename varchar(255) not null, fvprefix varchar(12), fvgenerictype integer(3) unsigned not null default 0, fvsize integer(20) unsigned not null default 0, fvtitle varchar(255), fvdescription text, fvtags varchar(255), fvisapproved integer(10) unsigned not null default 1, fvdateadded datetime, fvapproveruid integer(10) unsigned not null default 0, fvauthoruid integer(10) unsigned not null default 0, fvactivatedatetime datetime, fvhasthumbnail1 integer(1) not null default 0, fvhasthumbnail2 integer(1) not null default 0, fvhasthumbnail3 integer(1) not null default 0, fvextension varchar(32), fvtype integer(10) unsigned not null default 0, primary key (fid, fvid) )engine=myisam; alter table fileversions add index fvextension (fvtype); alter table fileversions add index fvtitle (fvtitle); create table fileversionlog ( fvlid integer(10) unsigned not null auto_increment, fid integer(10) unsigned not null default 0, fvid integer(10) unsigned not null default 0, fvupdatetypeid integer(3) unsigned not null default 0, fvupdatetypeattributeid integer(10) unsigned not null default 0, primary key (fvlid) ); create table filestoragelocations ( fslid integer(10) unsigned not null default 0, fslname varchar(255) not null, fsldirectory varchar(255) not null, primary key (fslid) ); create table files ( fid integer(10) unsigned not null auto_increment, fdateadded datetime, uid integer(10) unsigned not null default 0, fslid integer(10) unsigned not null default 0, ocid integer(10) unsigned not null default 0, foverridesetpermissions integer(1) not null default 0, fpassword varchar(255), primary key (fid, uid, fslid) ); alter table files add index foverridesetpermissions (foverridesetpermissions); create table groups ( gid integer(10) unsigned not null auto_increment, gname varchar(128) not null, gdescription varchar(255) not null, guserexpirationisenabled integer(1) not null default 0, guserexpirationmethod varchar(12), guserexpirationsetdatetime datetime, guserexpirationinterval integer(10) unsigned not null default 0, guserexpirationaction varchar(20), primary key (gid) ); alter table groups add unique index gname (gname); create table jobs ( jid integer(10) unsigned not null auto_increment, jname varchar(100) not null, jdescription varchar(255) not null, jdateinstalled datetime, jdatelastrun datetime, pkgid integer(10) unsigned not null default 0, jlaststatustext varchar(255), jlaststatuscode smallint(4) not null default 0, jstatus varchar(14) not null default 'enabled', jhandle varchar(255) not null, jnotuninstallable smallint(4) not null default 0, primary key (jid) ); create table jobslog ( jlid integer(10) unsigned not null auto_increment, jid integer(10) unsigned not null, jlmessage varchar(255) not null, jltimestamp timestamp not null, jlerror integer(10) not null default 0, primary key (jlid) ); create table layouts ( layoutid integer unsigned not null auto_increment, layout_rows integer(5) not null default 3, layout_columns integer(3) not null default 3, spacing integer(3) not null default 3, breakpoints varchar(255) not null default '', locked tinyint(1) not null default 0, primary key (layoutid) ); create table layoutpresets ( lpid integer unsigned not null auto_increment, lpname varchar(128) not null, layoutid integer(10) unsigned not null default 0, primary key (lpid) ); alter table layoutpresets add unique index layoutid (layoutid); create table systemnotifications ( snid integer(10) unsigned not null auto_increment, sntypeid integer(3) unsigned not null default 0, snurl text, snurl2 text, sndatetime datetime not null, snisarchived integer(1) not null default 0, snisnew integer(1) not null default 0, sntitle varchar(255), sndescription text, snbody text, primary key (snid) ); create table packages ( pkgid integer(10) unsigned not null auto_increment, pkgname varchar(255) not null, pkghandle varchar(64) not null, pkgdescription text, pkgdateinstalled datetime not null, pkgisinstalled tinyint(1) not null default 1, pkgversion varchar(32), pkgavailableversion varchar(32), primary key (pkgid) ); alter table packages add unique index pkghandle (pkghandle); create table pagepaths ( ppid integer(10) unsigned not null auto_increment, cid integer(10) unsigned default 0, cpath text, ppiscanonical varchar(1) not null default '1', primary key (ppid) ); alter table pagepaths add index cid (cid); alter table pagepaths add index ppiscanonical (ppiscanonical); alter table pagepaths add index cpath (cpath(128)); create table pagesearchindex ( cid integer(10) unsigned not null default 0, content text, cname varchar(255), cdescription text, cpath text, cdatepublic datetime, cdatelastindexed datetime, cdatelastsitemapped datetime, primary key (cid) )engine=myisam; alter table pagesearchindex add fulltext index cname (cname); alter table pagesearchindex add fulltext index cdescription (cdescription); alter table pagesearchindex add fulltext index content (content); alter table pagesearchindex add fulltext index content2 (cname, cdescription, content); alter table pagesearchindex add index cdatelastindexed (cdatelastindexed); alter table pagesearchindex add index cdatelastsitemapped (cdatelastsitemapped); create table pagepermissionpagetypes ( cid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, ctid integer(10) unsigned not null default 0, primary key (cid, gid, uid, ctid) ); create table pagepermissions ( cid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, cgpermissions varchar(32), cgstartdate datetime, cgenddate datetime, primary key (cid, gid, uid) ); create table pagestatistics ( pstid bigint(20) unsigned not null auto_increment, cid integer(10) unsigned not null default 0, date date, timestamp timestamp not null, uid integer(10) unsigned not null default 0, primary key (pstid) )engine=myisam; alter table pagestatistics add index cid (cid); alter table pagestatistics add index date (date); alter table pagestatistics add index uid (uid); create table pagethemes ( ptid integer(10) unsigned not null auto_increment, pthandle varchar(64) not null, ptname varchar(255), ptdescription text, pkgid integer(10) unsigned not null default 0, primary key (ptid) ); alter table pagethemes add unique index pthandle (pthandle); create table pagethemestyles ( ptid integer(10) unsigned not null default 0, ptshandle varchar(128) not null, ptsvalue longtext, ptstype varchar(32) not null, primary key (ptid, ptshandle, ptstype) ); create table pagetypeattributes ( ctid integer(10) unsigned not null default 0, akid integer(10) unsigned not null default 0, primary key (ctid, akid) ); create table pagetypes ( ctid integer(10) unsigned not null auto_increment, cthandle varchar(32) not null, cticon varchar(128), ctname varchar(90) not null, pkgid integer(10) unsigned not null default 0, primary key (ctid) ); alter table pagetypes add unique index cthandle (cthandle); create table pages ( cid integer(10) unsigned not null default 0, ctid integer(10) unsigned not null default 0, cistemplate varchar(1) not null default '0', uid integer(10) unsigned, cischeckedout tinyint(1) not null default 0, ccheckedoutuid integer(10) unsigned, ccheckedoutdatetime datetime, ccheckedoutdatetimelastedit datetime, cpendingaction varchar(6), cpendingactiondatetime datetime not null default '0000-00-00 00:00:00', cpendingactionuid integer(10) unsigned, cpendingactiontargetcid integer(10) unsigned, coverridetemplatepermissions tinyint(1) not null default 1, cinheritpermissionsfromcid integer(10) unsigned not null default 0, cinheritpermissionsfrom varchar(8) not null default 'parent', cfilename varchar(255), cpointerid integer(10) unsigned not null default 0, cpointerexternallink varchar(255), cpointerexternallinknewwindow tinyint(1) not null default 0, cchildren integer(10) unsigned not null default 0, cdisplayorder integer(10) unsigned not null default 0, cparentid integer(10) unsigned not null default 0, pkgid integer(10) unsigned not null default 0, ptid integer(10) unsigned not null default 0, ccachefullpagecontent integer(4) not null default -1, ccachefullpagecontentoverridelifetime varchar(32) not null default '0', ccachefullpagecontentlifetimecustom integer(10) unsigned not null default 0, primary key (cid) ); alter table pages add index cparentid (cparentid); alter table pages add index ccheckedoutuid (ccheckedoutuid); alter table pages add index cpointerid (cpointerid); alter table pages add index uid (uid); alter table pages add index ctid (ctid); create table pilecontents ( pcid integer(10) unsigned not null auto_increment, pid integer(10) unsigned not null default 0, itemid integer(10) unsigned not null default 0, itemtype varchar(64) not null, quantity integer(10) unsigned not null default 1, timestamp timestamp not null, displayorder integer(10) unsigned not null default 0, primary key (pcid) ); create table piles ( pid integer(10) unsigned not null auto_increment, uid integer(10) unsigned, isdefault tinyint(1) not null default 0, timestamp timestamp not null, name varchar(255), state varchar(64) not null, primary key (pid) ); create table userattributekeys ( akid integer(10) unsigned not null, uakprofiledisplay tinyint(1) not null default 0, uakmemberlistdisplay tinyint(1) not null default 0, uakprofileedit tinyint(1) not null default 1, uakprofileeditrequired tinyint(1) not null default 0, uakregisteredit tinyint(1) not null default 0, uakregistereditrequired tinyint(1) not null default 0, displayorder integer(10) unsigned default 0, uakisactive tinyint(1) not null default 1, primary key (akid) ); create table userattributevalues ( uid integer(10) unsigned not null default 0, akid integer(10) unsigned not null default 0, avid integer(10) unsigned not null default 0, primary key (uid, akid, avid) ); create table userprivatemessages ( msgid integer(10) unsigned not null auto_increment, uauthorid integer(10) unsigned not null default 0, msgdatecreated datetime not null, msgsubject varchar(255) not null, msgbody text, utoid integer(10) unsigned not null default 0, primary key (msgid) ); create table userprivatemessagesto ( msgid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, uauthorid integer(10) unsigned not null default 0, msgmailboxid integer(11) not null, msgisnew integer(1) not null default 0, msgisunread integer(1) not null default 0, msgisreplied integer(1) not null default 0, primary key (msgid, uid, uauthorid) ); alter table userprivatemessagesto add index uid (uid); alter table userprivatemessagesto add index uauthorid (uauthorid); alter table userprivatemessagesto add index msgfolderid (msgmailboxid); alter table userprivatemessagesto add index msgisnew (msgisnew); create table userbannedips ( ipfrom integer(10) unsigned not null default 0, ipto integer(10) unsigned not null default 0, bancode integer(1) unsigned not null default 1, expires integer(10) unsigned not null default 0, ismanual integer(1) not null default 0, primary key (ipfrom, ipto) ); alter table userbannedips add index ipfrom (ipfrom); alter table userbannedips add index ipto (ipto); create table usergroups ( uid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, ugentered datetime not null default '0000-00-00 00:00:00', type varchar(64), primary key (uid, gid) ); alter table usergroups add index uid (uid); alter table usergroups add index gid (gid); create table uservalidationhashes ( uvhid integer(10) unsigned not null auto_increment, uid integer(10) unsigned, uhash varchar(64) not null, type integer(4) unsigned not null default 0, udategenerated integer(10) unsigned not null default 0, udateredeemed integer(10) unsigned not null default 0, primary key (uvhid) ); create table logs ( logid integer(10) unsigned not null auto_increment, logtype varchar(64) not null, timestamp timestamp not null, logtext longtext, logisinternal tinyint(1) not null default 0, primary key (logid) ); alter table logs add index logtype (logtype); alter table logs add index logisinternal (logisinternal); create table mailimporters ( miid integer(10) unsigned not null auto_increment, mihandle varchar(64) not null, miserver varchar(255), miusername varchar(255), mipassword varchar(255), miencryption varchar(32), miisenabled integer(1) not null default 0, miemail varchar(255), miport integer(10) unsigned not null default 0, pkgid integer(10) unsigned, primary key (miid) ); create table mailvalidationhashes ( mvhid integer(10) unsigned not null auto_increment, miid integer(10) unsigned not null default 0, email varchar(255) not null, mhash varchar(128) not null, mdategenerated integer(10) unsigned not null default 0, mdateredeemed integer(10) unsigned not null default 0, data text, primary key (mvhid) ); create table useropenids ( uid integer(10) unsigned not null, uopenid varchar(255) not null, primary key (uopenid) ); alter table useropenids add index uid (uid); create table users ( uid integer(10) unsigned not null auto_increment, uname varchar(64) not null, uemail varchar(64) not null, upassword varchar(255) not null, uisactive varchar(1) not null default '0', uisvalidated tinyint not null default -1, uisfullrecord tinyint(1) not null default 1, udateadded datetime not null default '0000-00-00 00:00:00', uhasavatar tinyint(1) not null default 0, ulastonline integer(10) unsigned not null default 0, ulastlogin integer(10) unsigned not null default 0, upreviouslogin integer(10) unsigned not null default 0, unumlogins integer(10) unsigned not null default 0, utimezone varchar(255), primary key (uid) ); alter table users add unique index uname (uname); create table usersfriends ( ufid integer(10) unsigned not null auto_increment, uid integer(10) unsigned, status varchar(64) not null, frienduid integer(10) unsigned, udateadded datetime not null default '0000-00-00 00:00:00', primary key (ufid) ); create table signuprequests ( id integer(11) not null auto_increment, ipfrom integer(10) unsigned not null default 0, date_access timestamp not null, primary key (id) ); alter table signuprequests add index index_ipfrom (ipfrom); create table filesets ( fsid integer(10) unsigned not null auto_increment, fsname varchar(64) not null, uid integer(10) unsigned not null default 0, fstype integer(4) not null, fsoverrideglobalpermissions integer(4), primary key (fsid) ); alter table filesets add index fsoverrideglobalpermissions (fsoverrideglobalpermissions); create table filesetsavedsearches ( fsid integer(10) unsigned not null default 0, fssearchrequest text, fsresultcolumns text, primary key (fsid) ); create table filesetfiles ( fsfid integer(10) unsigned not null auto_increment, fid integer(10) unsigned not null, fsid integer(10) unsigned not null, timestamp timestamp not null, fsdisplayorder integer(10) unsigned not null, primary key (fsfid) ); alter table filesetfiles add index fid (fid); alter table filesetfiles add index fsid (fsid); create table atboolean ( avid integer(10) unsigned not null, value tinyint(1) not null default 0, primary key (avid) ); create table atbooleansettings ( akid integer(10) unsigned not null, akcheckedbydefault tinyint(1) not null default 0, primary key (akid) ); create table atdatetimesettings ( akid integer(10) unsigned not null, akdatedisplaymode varchar(255), primary key (akid) ); create table atdatetime ( avid integer(10) unsigned not null, value datetime default '0000-00-00 00:00:00', primary key (avid) ); create table atdefault ( avid integer(10) unsigned not null, value longtext, primary key (avid) ); create table atfile ( avid integer(10) unsigned not null, fid integer(10) unsigned not null, primary key (avid) ); create table atnumber ( avid integer(10) unsigned not null, value numeric(14,4) default 0, primary key (avid) ); create table atselectsettings ( akid integer(10) unsigned not null, akselectallowmultiplevalues tinyint(1) not null default 0, akselectoptiondisplayorder varchar(255) not null default 'display_asc', akselectallowothervalues tinyint(1) not null default 0, primary key (akid) ); create table attextareasettings ( akid integer(10) unsigned not null default 0, aktextareadisplaymode varchar(255), primary key (akid) ); create table atselectoptions ( id integer(10) unsigned not null auto_increment, akid integer(10) unsigned, value varchar(255), displayorder integer(10) unsigned, isenduseradded tinyint(1) not null default 0, primary key (id) ); create table atselectoptionsselected ( avid integer(10) unsigned not null, atselectoptionid integer(10) unsigned not null, primary key (avid, atselectoptionid) ); alter table atselectoptionsselected add index `atselectoptionid` (atselectoptionid); create table ataddress ( avid integer(10) unsigned not null default 0, address1 varchar(255), address2 varchar(255), city varchar(255), state_province varchar(255), country varchar(4), postal_code varchar(32), primary key (avid) ); create table ataddresscustomcountries ( ataddresscustomcountryid integer(10) unsigned not null auto_increment, akid integer(10) unsigned not null default 0, country varchar(5) not null, primary key (ataddresscustomcountryid) ); create table ataddresssettings ( akid integer(10) unsigned not null default 0, akhascustomcountries integer(1) not null default 0, akdefaultcountry varchar(12), primary key (akid) ); create table btnavigation ( bid integer unsigned not null, orderby varchar(255) default 'alpha_asc', displaypages varchar(255) default 'top', displaypagescid integer unsigned not null default 1, displaypagesincludeself tinyint unsigned not null default 0, displaysubpages varchar(255) default 'none', displaysubpagelevels varchar(255) default 'none', displaysubpagelevelsnum smallint unsigned not null default 0, displayunavailablepages tinyint unsigned not null default 0, primary key (bid) ); create table btdatenav ( bid integer unsigned not null, num smallint unsigned not null, cparentid integer unsigned not null default 1, cthis tinyint unsigned not null default 0, ctid smallint unsigned, flatdisplay integer default 0, defaultnode varchar(64) default 'current_page', truncatetitles integer default 0, truncatesummaries integer default 0, displayfeaturedonly integer default 0, truncatechars integer default 128, truncatetitlechars integer default 128, showdescriptions integer default 0, primary key (bid) ); create table btexternalform ( bid integer unsigned not null, filename varchar(128), primary key (bid) ); create table btcontentfile ( bid integer unsigned not null, fid integer unsigned, filelinktext varchar(255), filepassword varchar(255), primary key (bid) ); create table btflashcontent ( bid integer unsigned not null, fid integer unsigned, quality varchar(255), minversion varchar(255), primary key (bid) ); create table btform ( bid integer unsigned not null, questionsetid integer unsigned default 0, surveyname varchar(255), thankyoumsg text, notifymeonsubmission tinyint unsigned not null default 0, recipientemail varchar(255), displaycaptcha integer default 1, redirectcid integer default 0, primary key (bid) ); alter table btform add index questionsetidforeign (questionsetid); create table btformquestions ( qid integer unsigned not null auto_increment, msqid integer unsigned default 0, bid integer unsigned default 0, questionsetid integer unsigned default 0, question varchar(255), inputtype varchar(255), options text, position integer unsigned default 1000, width integer unsigned default 50, height integer unsigned default 3, required integer default 0, primary key (qid) ); alter table btformquestions add index questionsetid (questionsetid); alter table btformquestions add index msqid (msqid); create table btformanswerset ( asid integer unsigned not null auto_increment, questionsetid integer unsigned default 0, created timestamp, uid integer unsigned default 0, primary key (asid) ); create table btformanswers ( aid integer unsigned not null auto_increment, asid integer unsigned default 0, msqid integer unsigned default 0, answer varchar(255), answerlong text, primary key (aid) ); create table btgooglemap ( bid integer unsigned not null, title varchar(255), api_key varchar(255), location varchar(255), latitude double, longitude double, zoom integer(8), primary key (bid) ); create table btguestbook ( bid integer unsigned not null, requireapproval integer default 0, title varchar(100) default 'comments', dateformat varchar(100), displayguestbookform integer default 1, displaycaptcha integer default 1, authenticationrequired integer default 0, notifyemail varchar(100), primary key (bid) ); create table btguestbookentries ( bid integer, cid integer default 1, entryid integer not null auto_increment, uid integer default 0, commenttext longtext, user_name varchar(100), user_email varchar(100), entrydate timestamp, approved integer default 1, primary key (entryid) ); alter table btguestbookentries add index cid (cid); create table btcontentlocal ( bid integer unsigned not null, content longtext, primary key (bid) ); create table btcontentimage ( bid integer unsigned not null, fid integer unsigned default 0, fonstateid integer unsigned default 0, maxwidth integer unsigned default 0, maxheight integer unsigned default 0, externallink varchar(255), alttext varchar(255), primary key (bid) ); create table btfile ( bid integer unsigned not null, filename varchar(255), origfilename varchar(255), url varchar(255), type varchar(32), generictype varchar(32), primary key (bid) ); create table btnextprevious ( bid integer unsigned not null, linkstyle varchar(32), nextlabel varchar(128), previouslabel varchar(128), showarrows integer default 1, loopsequence integer default 1, excludesystempages integer default 1, primary key (bid) ); create table btpagelist ( bid integer unsigned not null, num smallint unsigned not null, orderby varchar(32), cparentid integer unsigned not null default 1, cthis tinyint unsigned not null default 0, paginate tinyint unsigned not null default 0, displayaliases tinyint unsigned not null default 1, ctid smallint unsigned, rss integer default 0, rsstitle varchar(255), rssdescription longtext, truncatesummaries integer default 0, displayfeaturedonly integer default 0, truncatechars integer default 128, primary key (bid) ); create table btrssdisplay ( bid integer unsigned not null, title varchar(255), url varchar(255), dateformat varchar(100), itemstodisplay integer unsigned default 5, showsummary tinyint unsigned not null default 1, launchinnewwindow tinyint unsigned not null default 1, primary key (bid) ); create table btsearch ( bid integer unsigned not null, title varchar(255), buttontext varchar(128), basesearchpath varchar(255), resultsurl varchar(255), primary key (bid) ); create table btslideshow ( bid integer unsigned not null, fsid integer unsigned, playback varchar(50), duration integer unsigned, fadeduration integer unsigned, primary key (bid) ); create table btslideshowimg ( slideshowimgid integer unsigned not null auto_increment, bid integer unsigned, fid integer unsigned, url varchar(255), duration integer unsigned, fadeduration integer unsigned, groupset integer unsigned, position integer unsigned, imgheight integer unsigned, primary key (slideshowimgid) ); create table btsurvey ( bid integer unsigned not null, question varchar(255) default '', requiresregistration integer default 0, primary key (bid) ); create table btsurveyoptions ( optionid integer unsigned not null auto_increment, bid integer, optionname varchar(255), displayorder integer default 0, primary key (optionid) ); create table btsurveyresults ( resultid integer unsigned not null auto_increment, optionid integer unsigned default 0, uid integer unsigned default 0, bid integer, cid integer, ipaddress varchar(128), timestamp timestamp, primary key (resultid) ); create table bttags ( bid integer unsigned not null, title varchar(255), targetcid integer, primary key (bid) ); create table btvideo ( bid integer unsigned not null, fid integer unsigned, width integer unsigned, height integer unsigned, primary key (bid) ); create table btyoutube ( bid integer unsigned not null, title varchar(255), videourl varchar(255), primary key (bid) ); create table if not exists `collectionsearchindexattributes` ( `cid` int(11) unsigned not null default '0', `ak_meta_title` text, `ak_meta_description` text, `ak_meta_keywords` text, `ak_exclude_nav` tinyint(4) default '0', `ak_exclude_page_list` tinyint(4) default '0', `ak_header_extra_content` text, `ak_exclude_search_index` tinyint(4) default '0', `ak_exclude_sitemapxml` tinyint(4) default '0', `ak_tags` text, primary key (`cid`) ) engine=myisam default charset=latin1; create table if not exists `filesearchindexattributes` ( `fid` int(11) unsigned not null default '0', `ak_width` decimal(14,4) default '0.0000', `ak_height` decimal(14,4) default '0.0000', primary key (`fid`) ) engine=myisam default charset=latin1; create table usersearchindexattributes ( uid integer(11) unsigned not null default 0, primary key (uid) );")
mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create table areagroupblocktypes ( cid integer(10) unsi' at line 1] in EXECUTE("create table areagroupblocktypes ( cid integer(10) unsigned not null default 0, arhandle varchar(255) not null, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, btid integer(10) unsigned not null default 0, primary key (cid, arhandle, gid, uid, btid) ); create table areagroups ( cid integer(10) unsigned not null default 0, arhandle varchar(255) not null, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, agpermissions varchar(64) not null, primary key (cid, arhandle, gid, uid) ); create table areas ( arid integer(10) unsigned not null auto_increment, cid integer(10) unsigned not null default 0, arhandle varchar(255) not null, aroverridecollectionpermissions tinyint(1) not null default 0, arinheritpermissionsfromareaoncid integer(10) unsigned not null default 0, primary key (arid) ); create table attributesetkeys ( akid integer(10) unsigned not null default 0, asid integer(10) unsigned not null default 0, displayorder integer(10) unsigned not null default 0, primary key (akid, asid) ); create table attributesets ( asid integer(10) unsigned not null auto_increment, asname varchar(255), ashandle varchar(255) not null, akcategoryid integer(10) unsigned not null default 0, pkgid integer(10) unsigned not null default 0, primary key (asid) ); create table attributekeys ( akid integer(10) unsigned not null auto_increment, akhandle varchar(255) not null, akname varchar(255) not null, akissearchable tinyint(1) not null default 0, akissearchableindexed tinyint(1) not null default 0, akisautocreated tinyint(1) not null default 0, akiscolumnheader tinyint(1) not null default 0, akiseditable tinyint(1) not null default 0, atid integer(10) unsigned, akcategoryid integer(10) unsigned, pkgid integer(10) unsigned, primary key (akid) ); alter table attributekeys add unique index akhandle (akhandle, akcategoryid); create table attributekeycategories ( akcategoryid integer(10) unsigned not null auto_increment, akcategoryhandle varchar(255) not null, akcategoryallowsets smallint(4) not null default 0, pkgid integer(10) unsigned, primary key (akcategoryid) ); create table attributetypecategories ( atid integer(10) unsigned not null default 0, akcategoryid integer(10) unsigned not null default 0, primary key (atid, akcategoryid) ); create table attributetypes ( atid integer(10) unsigned not null auto_increment, athandle varchar(255) not null, atname varchar(255) not null, pkgid integer(10) unsigned, primary key (atid) ); create table attributevalues ( avid integer(10) unsigned not null auto_increment, akid integer(10) unsigned, avdateadded datetime not null default '0000-00-00 00:00:00', uid integer(10) unsigned, atid integer(10) unsigned, primary key (avid) ); create table blockrelations ( brid integer(10) unsigned not null auto_increment, bid integer(10) unsigned not null default 0, originalbid integer(10) unsigned not null default 0, relationtype varchar(50) not null, primary key (brid) ); create table blocktypes ( btid integer(10) unsigned not null auto_increment, bthandle varchar(32) not null, btname varchar(128) not null, btdescription text, btactivewhenadded tinyint(1) not null default 1, btcopywhenpropagate tinyint(1) not null default 0, btincludeall tinyint(1) not null default 0, btisinternal tinyint(1) not null default 0, btinterfacewidth integer(10) unsigned not null default 400, btinterfaceheight integer(10) unsigned not null default 400, pkgid integer(10) unsigned not null default 0, primary key (btid) ); alter table blocktypes add unique index bthandle (bthandle); create table blocks ( bid integer(10) unsigned not null auto_increment, bname varchar(60), bdateadded datetime not null default '0000-00-00 00:00:00', bdatemodified datetime not null default '0000-00-00 00:00:00', bfilename varchar(32), bisactive varchar(1) not null default '1', btid integer(10) unsigned not null default 0, uid integer(10) unsigned, primary key (bid) ); create table collectionattributevalues ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 0, akid integer(10) unsigned not null default 0, avid integer(10) unsigned not null default 0, primary key (cid, cvid, akid, avid) ); create table collectionversionblockpermissions ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 1, bid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, cbgpermissions varchar(32), primary key (cid, cvid, bid, gid, uid) ); create table collectionversionblocks ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 1, bid integer(10) unsigned not null default 0, arhandle varchar(255) not null, cbdisplayorder integer(10) unsigned not null default 0, isoriginal varchar(1) not null default '0', cboverrideareapermissions tinyint(1) not null default 0, cbincludeall tinyint(1) not null default 0, primary key (cid, cvid, bid, arhandle) ); alter table collectionversionblocks add index cbincludeall (cbincludeall); create table collectionversionblockstyles ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 0, bid integer(10) unsigned not null default 0, arhandle varchar(255) not null, csrid integer(10) unsigned not null default 0, primary key (cid, cvid, bid, arhandle) ); create table collectionversionarealayouts ( cvalid integer(10) unsigned not null auto_increment, cid integer(10) unsigned default 0, cvid integer(10) unsigned default 0, arhandle varchar(255), layoutid integer(10) unsigned not null default 0, position integer(10) default 1000, areanamenumber integer(10) unsigned default 0, primary key (cvalid) ); alter table collectionversionarealayouts add index arealayoutsindex (cid, cvid, arhandle); create table collectionversionareastyles ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 0, arhandle varchar(255) not null, csrid integer(10) unsigned not null default 0, primary key (cid, cvid, arhandle) ); create table collectionversions ( cid integer(10) unsigned not null default 0, cvid integer(10) unsigned not null default 1, cvname text, cvhandle varchar(64), cvdescription text, cvdatepublic datetime, cvdatecreated datetime not null default '0000-00-00 00:00:00', cvcomments varchar(255), cvisapproved tinyint(1) not null default 0, cvisnew tinyint(1) not null default 0, cvauthoruid integer(10) unsigned, cvapproveruid integer(10) unsigned, cvactivatedatetime datetime, primary key (cid, cvid) ); alter table collectionversions add index cvisapproved (cvisapproved); alter table collectionversions add index cvname (cvname(128)); create table collections ( cid integer(10) unsigned not null auto_increment, cdateadded datetime not null default '0000-00-00 00:00:00', cdatemodified datetime not null default '0000-00-00 00:00:00', chandle varchar(255), primary key (cid) ); alter table collections add index cdatemodified (cdatemodified); alter table collections add index cdateadded (cdateadded); create table config ( cfkey varchar(64) not null, timestamp timestamp not null, cfvalue longtext, uid integer(10) unsigned not null default 0, pkgid integer(10) unsigned not null default 0, primary key (cfkey, uid) ); alter table config add index uid (uid); create table dashboardhomepage ( dbhid integer(10) unsigned not null auto_increment, dbhmodule varchar(255) not null, dbhdisplayname varchar(255), dbhdisplayorder integer(10) unsigned not null default 0, pkgid integer(10) unsigned not null default 0, primary key (dbhid) ); create table downloadstatistics ( dsid integer(10) unsigned not null auto_increment, fid integer(10) unsigned not null, fvid integer(10) unsigned not null, uid integer(10) unsigned not null, rcid integer(10) unsigned not null, timestamp timestamp not null, primary key (dsid) ); create table fileattributevalues ( fid integer(10) unsigned not null default 0, fvid integer(10) unsigned not null default 0, akid integer(10) unsigned not null default 0, avid integer(10) unsigned not null default 0, primary key (fid, fvid, akid, avid) ); create table filepermissionfiletypes ( fsid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, extension varchar(32) not null, primary key (fsid, gid, uid, extension) ); create table customstylepresets ( cspid integer(10) unsigned not null auto_increment, cspname varchar(255) not null, csrid integer(10) unsigned not null default 0, primary key (cspid) ); create table customstylerules ( csrid integer(10) unsigned not null auto_increment, css_id varchar(128), css_class varchar(128), css_serialized text, css_custom text, primary key (csrid) ); create table filepermissions ( fid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, canread integer(4) not null default 0, canwrite integer(4) not null default 0, canadmin integer(4) not null default 0, cansearch integer(4) not null default 0, primary key (fid, gid, uid) ); create table taskpermissionusergroups ( tpid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, canread integer(1) not null default 0, primary key (tpid, gid, uid) ); create table taskpermissions ( tpid integer(10) unsigned not null auto_increment, tphandle varchar(255), tpname varchar(255), tpdescription text, pkgid integer(10) unsigned not null default 0, primary key (tpid) ); alter table taskpermissions add unique index tphandle (tphandle); create table filesetpermissions ( fsid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, canread integer(4), canwrite integer(4), canadmin integer(4), canadd integer(4), cansearch integer(3) unsigned, primary key (fsid, gid, uid) ); alter table filesetpermissions add index canread (canread); alter table filesetpermissions add index canwrite (canwrite); alter table filesetpermissions add index canadmin (canadmin); alter table filesetpermissions add index cansearch (cansearch); alter table filesetpermissions add index canadd (canadd); create table fileversions ( fid integer(10) unsigned not null default 0, fvid integer(10) unsigned not null default 0, fvfilename varchar(255) not null, fvprefix varchar(12), fvgenerictype integer(3) unsigned not null default 0, fvsize integer(20) unsigned not null default 0, fvtitle varchar(255), fvdescription text, fvtags varchar(255), fvisapproved integer(10) unsigned not null default 1, fvdateadded datetime, fvapproveruid integer(10) unsigned not null default 0, fvauthoruid integer(10) unsigned not null default 0, fvactivatedatetime datetime, fvhasthumbnail1 integer(1) not null default 0, fvhasthumbnail2 integer(1) not null default 0, fvhasthumbnail3 integer(1) not null default 0, fvextension varchar(32), fvtype integer(10) unsigned not null default 0, primary key (fid, fvid) )engine=myisam; alter table fileversions add index fvextension (fvtype); alter table fileversions add index fvtitle (fvtitle); create table fileversionlog ( fvlid integer(10) unsigned not null auto_increment, fid integer(10) unsigned not null default 0, fvid integer(10) unsigned not null default 0, fvupdatetypeid integer(3) unsigned not null default 0, fvupdatetypeattributeid integer(10) unsigned not null default 0, primary key (fvlid) ); create table filestoragelocations ( fslid integer(10) unsigned not null default 0, fslname varchar(255) not null, fsldirectory varchar(255) not null, primary key (fslid) ); create table files ( fid integer(10) unsigned not null auto_increment, fdateadded datetime, uid integer(10) unsigned not null default 0, fslid integer(10) unsigned not null default 0, ocid integer(10) unsigned not null default 0, foverridesetpermissions integer(1) not null default 0, fpassword varchar(255), primary key (fid, uid, fslid) ); alter table files add index foverridesetpermissions (foverridesetpermissions); create table groups ( gid integer(10) unsigned not null auto_increment, gname varchar(128) not null, gdescription varchar(255) not null, guserexpirationisenabled integer(1) not null default 0, guserexpirationmethod varchar(12), guserexpirationsetdatetime datetime, guserexpirationinterval integer(10) unsigned not null default 0, guserexpirationaction varchar(20), primary key (gid) ); alter table groups add unique index gname (gname); create table jobs ( jid integer(10) unsigned not null auto_increment, jname varchar(100) not null, jdescription varchar(255) not null, jdateinstalled datetime, jdatelastrun datetime, pkgid integer(10) unsigned not null default 0, jlaststatustext varchar(255), jlaststatuscode smallint(4) not null default 0, jstatus varchar(14) not null default 'enabled', jhandle varchar(255) not null, jnotuninstallable smallint(4) not null default 0, primary key (jid) ); create table jobslog ( jlid integer(10) unsigned not null auto_increment, jid integer(10) unsigned not null, jlmessage varchar(255) not null, jltimestamp timestamp not null, jlerror integer(10) not null default 0, primary key (jlid) ); create table layouts ( layoutid integer unsigned not null auto_increment, layout_rows integer(5) not null default 3, layout_columns integer(3) not null default 3, spacing integer(3) not null default 3, breakpoints varchar(255) not null default '', locked tinyint(1) not null default 0, primary key (layoutid) ); create table layoutpresets ( lpid integer unsigned not null auto_increment, lpname varchar(128) not null, layoutid integer(10) unsigned not null default 0, primary key (lpid) ); alter table layoutpresets add unique index layoutid (layoutid); create table systemnotifications ( snid integer(10) unsigned not null auto_increment, sntypeid integer(3) unsigned not null default 0, snurl text, snurl2 text, sndatetime datetime not null, snisarchived integer(1) not null default 0, snisnew integer(1) not null default 0, sntitle varchar(255), sndescription text, snbody text, primary key (snid) ); create table packages ( pkgid integer(10) unsigned not null auto_increment, pkgname varchar(255) not null, pkghandle varchar(64) not null, pkgdescription text, pkgdateinstalled datetime not null, pkgisinstalled tinyint(1) not null default 1, pkgversion varchar(32), pkgavailableversion varchar(32), primary key (pkgid) ); alter table packages add unique index pkghandle (pkghandle); create table pagepaths ( ppid integer(10) unsigned not null auto_increment, cid integer(10) unsigned default 0, cpath text, ppiscanonical varchar(1) not null default '1', primary key (ppid) ); alter table pagepaths add index cid (cid); alter table pagepaths add index ppiscanonical (ppiscanonical); alter table pagepaths add index cpath (cpath(128)); create table pagesearchindex ( cid integer(10) unsigned not null default 0, content text, cname varchar(255), cdescription text, cpath text, cdatepublic datetime, cdatelastindexed datetime, cdatelastsitemapped datetime, primary key (cid) )engine=myisam; alter table pagesearchindex add fulltext index cname (cname); alter table pagesearchindex add fulltext index cdescription (cdescription); alter table pagesearchindex add fulltext index content (content); alter table pagesearchindex add fulltext index content2 (cname, cdescription, content); alter table pagesearchindex add index cdatelastindexed (cdatelastindexed); alter table pagesearchindex add index cdatelastsitemapped (cdatelastsitemapped); create table pagepermissionpagetypes ( cid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, ctid integer(10) unsigned not null default 0, primary key (cid, gid, uid, ctid) ); create table pagepermissions ( cid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, cgpermissions varchar(32), cgstartdate datetime, cgenddate datetime, primary key (cid, gid, uid) ); create table pagestatistics ( pstid bigint(20) unsigned not null auto_increment, cid integer(10) unsigned not null default 0, date date, timestamp timestamp not null, uid integer(10) unsigned not null default 0, primary key (pstid) )engine=myisam; alter table pagestatistics add index cid (cid); alter table pagestatistics add index date (date); alter table pagestatistics add index uid (uid); create table pagethemes ( ptid integer(10) unsigned not null auto_increment, pthandle varchar(64) not null, ptname varchar(255), ptdescription text, pkgid integer(10) unsigned not null default 0, primary key (ptid) ); alter table pagethemes add unique index pthandle (pthandle); create table pagethemestyles ( ptid integer(10) unsigned not null default 0, ptshandle varchar(128) not null, ptsvalue longtext, ptstype varchar(32) not null, primary key (ptid, ptshandle, ptstype) ); create table pagetypeattributes ( ctid integer(10) unsigned not null default 0, akid integer(10) unsigned not null default 0, primary key (ctid, akid) ); create table pagetypes ( ctid integer(10) unsigned not null auto_increment, cthandle varchar(32) not null, cticon varchar(128), ctname varchar(90) not null, pkgid integer(10) unsigned not null default 0, primary key (ctid) ); alter table pagetypes add unique index cthandle (cthandle); create table pages ( cid integer(10) unsigned not null default 0, ctid integer(10) unsigned not null default 0, cistemplate varchar(1) not null default '0', uid integer(10) unsigned, cischeckedout tinyint(1) not null default 0, ccheckedoutuid integer(10) unsigned, ccheckedoutdatetime datetime, ccheckedoutdatetimelastedit datetime, cpendingaction varchar(6), cpendingactiondatetime datetime not null default '0000-00-00 00:00:00', cpendingactionuid integer(10) unsigned, cpendingactiontargetcid integer(10) unsigned, coverridetemplatepermissions tinyint(1) not null default 1, cinheritpermissionsfromcid integer(10) unsigned not null default 0, cinheritpermissionsfrom varchar(8) not null default 'parent', cfilename varchar(255), cpointerid integer(10) unsigned not null default 0, cpointerexternallink varchar(255), cpointerexternallinknewwindow tinyint(1) not null default 0, cchildren integer(10) unsigned not null default 0, cdisplayorder integer(10) unsigned not null default 0, cparentid integer(10) unsigned not null default 0, pkgid integer(10) unsigned not null default 0, ptid integer(10) unsigned not null default 0, ccachefullpagecontent integer(4) not null default -1, ccachefullpagecontentoverridelifetime varchar(32) not null default '0', ccachefullpagecontentlifetimecustom integer(10) unsigned not null default 0, primary key (cid) ); alter table pages add index cparentid (cparentid); alter table pages add index ccheckedoutuid (ccheckedoutuid); alter table pages add index cpointerid (cpointerid); alter table pages add index uid (uid); alter table pages add index ctid (ctid); create table pilecontents ( pcid integer(10) unsigned not null auto_increment, pid integer(10) unsigned not null default 0, itemid integer(10) unsigned not null default 0, itemtype varchar(64) not null, quantity integer(10) unsigned not null default 1, timestamp timestamp not null, displayorder integer(10) unsigned not null default 0, primary key (pcid) ); create table piles ( pid integer(10) unsigned not null auto_increment, uid integer(10) unsigned, isdefault tinyint(1) not null default 0, timestamp timestamp not null, name varchar(255), state varchar(64) not null, primary key (pid) ); create table userattributekeys ( akid integer(10) unsigned not null, uakprofiledisplay tinyint(1) not null default 0, uakmemberlistdisplay tinyint(1) not null default 0, uakprofileedit tinyint(1) not null default 1, uakprofileeditrequired tinyint(1) not null default 0, uakregisteredit tinyint(1) not null default 0, uakregistereditrequired tinyint(1) not null default 0, displayorder integer(10) unsigned default 0, uakisactive tinyint(1) not null default 1, primary key (akid) ); create table userattributevalues ( uid integer(10) unsigned not null default 0, akid integer(10) unsigned not null default 0, avid integer(10) unsigned not null default 0, primary key (uid, akid, avid) ); create table userprivatemessages ( msgid integer(10) unsigned not null auto_increment, uauthorid integer(10) unsigned not null default 0, msgdatecreated datetime not null, msgsubject varchar(255) not null, msgbody text, utoid integer(10) unsigned not null default 0, primary key (msgid) ); create table userprivatemessagesto ( msgid integer(10) unsigned not null default 0, uid integer(10) unsigned not null default 0, uauthorid integer(10) unsigned not null default 0, msgmailboxid integer(11) not null, msgisnew integer(1) not null default 0, msgisunread integer(1) not null default 0, msgisreplied integer(1) not null default 0, primary key (msgid, uid, uauthorid) ); alter table userprivatemessagesto add index uid (uid); alter table userprivatemessagesto add index uauthorid (uauthorid); alter table userprivatemessagesto add index msgfolderid (msgmailboxid); alter table userprivatemessagesto add index msgisnew (msgisnew); create table userbannedips ( ipfrom integer(10) unsigned not null default 0, ipto integer(10) unsigned not null default 0, bancode integer(1) unsigned not null default 1, expires integer(10) unsigned not null default 0, ismanual integer(1) not null default 0, primary key (ipfrom, ipto) ); alter table userbannedips add index ipfrom (ipfrom); alter table userbannedips add index ipto (ipto); create table usergroups ( uid integer(10) unsigned not null default 0, gid integer(10) unsigned not null default 0, ugentered datetime not null default '0000-00-00 00:00:00', type varchar(64), primary key (uid, gid) ); alter table usergroups add index uid (uid); alter table usergroups add index gid (gid); create table uservalidationhashes ( uvhid integer(10) unsigned not null auto_increment, uid integer(10) unsigned, uhash varchar(64) not null, type integer(4) unsigned not null default 0, udategenerated integer(10) unsigned not null default 0, udateredeemed integer(10) unsigned not null default 0, primary key (uvhid) ); create table logs ( logid integer(10) unsigned not null auto_increment, logtype varchar(64) not null, timestamp timestamp not null, logtext longtext, logisinternal tinyint(1) not null default 0, primary key (logid) ); alter table logs add index logtype (logtype); alter table logs add index logisinternal (logisinternal); create table mailimporters ( miid integer(10) unsigned not null auto_increment, mihandle varchar(64) not null, miserver varchar(255), miusername varchar(255), mipassword varchar(255), miencryption varchar(32), miisenabled integer(1) not null default 0, miemail varchar(255), miport integer(10) unsigned not null default 0, pkgid integer(10) unsigned, primary key (miid) ); create table mailvalidationhashes ( mvhid integer(10) unsigned not null auto_increment, miid integer(10) unsigned not null default 0, email varchar(255) not null, mhash varchar(128) not null, mdategenerated integer(10) unsigned not null default 0, mdateredeemed integer(10) unsigned not null default 0, data text, primary key (mvhid) ); create table useropenids ( uid integer(10) unsigned not null, uopenid varchar(255) not null, primary key (uopenid) ); alter table useropenids add index uid (uid); create table users ( uid integer(10) unsigned not null auto_increment, uname varchar(64) not null, uemail varchar(64) not null, upassword varchar(255) not null, uisactive varchar(1) not null default '0', uisvalidated tinyint not null default -1, uisfullrecord tinyint(1) not null default 1, udateadded datetime not null default '0000-00-00 00:00:00', uhasavatar tinyint(1) not null default 0, ulastonline integer(10) unsigned not null default 0, ulastlogin integer(10) unsigned not null default 0, upreviouslogin integer(10) unsigned not null default 0, unumlogins integer(10) unsigned not null default 0, utimezone varchar(255), primary key (uid) ); alter table users add unique index uname (uname); create table usersfriends ( ufid integer(10) unsigned not null auto_increment, uid integer(10) unsigned, status varchar(64) not null, frienduid integer(10) unsigned, udateadded datetime not null default '0000-00-00 00:00:00', primary key (ufid) ); create table signuprequests ( id integer(11) not null auto_increment, ipfrom integer(10) unsigned not null default 0, date_access timestamp not null, primary key (id) ); alter table signuprequests add index index_ipfrom (ipfrom); create table filesets ( fsid integer(10) unsigned not null auto_increment, fsname varchar(64) not null, uid integer(10) unsigned not null default 0, fstype integer(4) not null, fsoverrideglobalpermissions integer(4), primary key (fsid) ); alter table filesets add index fsoverrideglobalpermissions (fsoverrideglobalpermissions); create table filesetsavedsearches ( fsid integer(10) unsigned not null default 0, fssearchrequest text, fsresultcolumns text, primary key (fsid) ); create table filesetfiles ( fsfid integer(10) unsigned not null auto_increment, fid integer(10) unsigned not null, fsid integer(10) unsigned not null, timestamp timestamp not null, fsdisplayorder integer(10) unsigned not null, primary key (fsfid) ); alter table filesetfiles add index fid (fid); alter table filesetfiles add index fsid (fsid); create table atboolean ( avid integer(10) unsigned not null, value tinyint(1) not null default 0, primary key (avid) ); create table atbooleansettings ( akid integer(10) unsigned not null, akcheckedbydefault tinyint(1) not null default 0, primary key (akid) ); create table atdatetimesettings ( akid integer(10) unsigned not null, akdatedisplaymode varchar(255), primary key (akid) ); create table atdatetime ( avid integer(10) unsigned not null, value datetime default '0000-00-00 00:00:00', primary key (avid) ); create table atdefault ( avid integer(10) unsigned not null, value longtext, primary key (avid) ); create table atfile ( avid integer(10) unsigned not null, fid integer(10) unsigned not null, primary key (avid) ); create table atnumber ( avid integer(10) unsigned not null, value numeric(14,4) default 0, primary key (avid) ); create table atselectsettings ( akid integer(10) unsigned not null, akselectallowmultiplevalues tinyint(1) not null default 0, akselectoptiondisplayorder varchar(255) not null default 'display_asc', akselectallowothervalues tinyint(1) not null default 0, primary key (akid) ); create table attextareasettings ( akid integer(10) unsigned not null default 0, aktextareadisplaymode varchar(255), primary key (akid) ); create table atselectoptions ( id integer(10) unsigned not null auto_increment, akid integer(10) unsigned, value varchar(255), displayorder integer(10) unsigned, isenduseradded tinyint(1) not null default 0, primary key (id) ); create table atselectoptionsselected ( avid integer(10) unsigned not null, atselectoptionid integer(10) unsigned not null, primary key (avid, atselectoptionid) ); alter table atselectoptionsselected add index `atselectoptionid` (atselectoptionid); create table ataddress ( avid integer(10) unsigned not null default 0, address1 varchar(255), address2 varchar(255), city varchar(255), state_province varchar(255), country varchar(4), postal_code varchar(32), primary key (avid) ); create table ataddresscustomcountries ( ataddresscustomcountryid integer(10) unsigned not null auto_increment, akid integer(10) unsigned not null default 0, country varchar(5) not null, primary key (ataddresscustomcountryid) ); create table ataddresssettings ( akid integer(10) unsigned not null default 0, akhascustomcountries integer(1) not null default 0, akdefaultcountry varchar(12), primary key (akid) ); create table btnavigation ( bid integer unsigned not null, orderby varchar(255) default 'alpha_asc', displaypages varchar(255) default 'top', displaypagescid integer unsigned not null default 1, displaypagesincludeself tinyint unsigned not null default 0, displaysubpages varchar(255) default 'none', displaysubpagelevels varchar(255) default 'none', displaysubpagelevelsnum smallint unsigned not null default 0, displayunavailablepages tinyint unsigned not null default 0, primary key (bid) ); create table btdatenav ( bid integer unsigned not null, num smallint unsigned not null, cparentid integer unsigned not null default 1, cthis tinyint unsigned not null default 0, ctid smallint unsigned, flatdisplay integer default 0, defaultnode varchar(64) default 'current_page', truncatetitles integer default 0, truncatesummaries integer default 0, displayfeaturedonly integer default 0, truncatechars integer default 128, truncatetitlechars integer default 128, showdescriptions integer default 0, primary key (bid) ); create table btexternalform ( bid integer unsigned not null, filename varchar(128), primary key (bid) ); create table btcontentfile ( bid integer unsigned not null, fid integer unsigned, filelinktext varchar(255), filepassword varchar(255), primary key (bid) ); create table btflashcontent ( bid integer unsigned not null, fid integer unsigned, quality varchar(255), minversion varchar(255), primary key (bid) ); create table btform ( bid integer unsigned not null, questionsetid integer unsigned default 0, surveyname varchar(255), thankyoumsg text, notifymeonsubmission tinyint unsigned not null default 0, recipientemail varchar(255), displaycaptcha integer default 1, redirectcid integer default 0, primary key (bid) ); alter table btform add index questionsetidforeign (questionsetid); create table btformquestions ( qid integer unsigned not null auto_increment, msqid integer unsigned default 0, bid integer unsigned default 0, questionsetid integer unsigned default 0, question varchar(255), inputtype varchar(255), options text, position integer unsigned default 1000, width integer unsigned default 50, height integer unsigned default 3, required integer default 0, primary key (qid) ); alter table btformquestions add index questionsetid (questionsetid); alter table btformquestions add index msqid (msqid); create table btformanswerset ( asid integer unsigned not null auto_increment, questionsetid integer unsigned default 0, created timestamp, uid integer unsigned default 0, primary key (asid) ); create table btformanswers ( aid integer unsigned not null auto_increment, asid integer unsigned default 0, msqid integer unsigned default 0, answer varchar(255), answerlong text, primary key (aid) ); create table btgooglemap ( bid integer unsigned not null, title varchar(255), api_key varchar(255), location varchar(255), latitude double, longitude double, zoom integer(8), primary key (bid) ); create table btguestbook ( bid integer unsigned not null, requireapproval integer default 0, title varchar(100) default 'comments', dateformat varchar(100), displayguestbookform integer default 1, displaycaptcha integer default 1, authenticationrequired integer default 0, notifyemail varchar(100), primary key (bid) ); create table btguestbookentries ( bid integer, cid integer default 1, entryid integer not null auto_increment, uid integer default 0, commenttext longtext, user_name varchar(100), user_email varchar(100), entrydate timestamp, approved integer default 1, primary key (entryid) ); alter table btguestbookentries add index cid (cid); create table btcontentlocal ( bid integer unsigned not null, content longtext, primary key (bid) ); create table btcontentimage ( bid integer unsigned not null, fid integer unsigned default 0, fonstateid integer unsigned default 0, maxwidth integer unsigned default 0, maxheight integer unsigned default 0, externallink varchar(255), alttext varchar(255), primary key (bid) ); create table btfile ( bid integer unsigned not null, filename varchar(255), origfilename varchar(255), url varchar(255), type varchar(32), generictype varchar(32), primary key (bid) ); create table btnextprevious ( bid integer unsigned not null, linkstyle varchar(32), nextlabel varchar(128), previouslabel varchar(128), showarrows integer default 1, loopsequence integer default 1, excludesystempages integer default 1, primary key (bid) ); create table btpagelist ( bid integer unsigned not null, num smallint unsigned not null, orderby varchar(32), cparentid integer unsigned not null default 1, cthis tinyint unsigned not null default 0, paginate tinyint unsigned not null default 0, displayaliases tinyint unsigned not null default 1, ctid smallint unsigned, rss integer default 0, rsstitle varchar(255), rssdescription longtext, truncatesummaries integer default 0, displayfeaturedonly integer default 0, truncatechars integer default 128, primary key (bid) ); create table btrssdisplay ( bid integer unsigned not null, title varchar(255), url varchar(255), dateformat varchar(100), itemstodisplay integer unsigned default 5, showsummary tinyint unsigned not null default 1, launchinnewwindow tinyint unsigned not null default 1, primary key (bid) ); create table btsearch ( bid integer unsigned not null, title varchar(255), buttontext varchar(128), basesearchpath varchar(255), resultsurl varchar(255), primary key (bid) ); create table btslideshow ( bid integer unsigned not null, fsid integer unsigned, playback varchar(50), duration integer unsigned, fadeduration integer unsigned, primary key (bid) ); create table btslideshowimg ( slideshowimgid integer unsigned not null auto_increment, bid integer unsigned, fid integer unsigned, url varchar(255), duration integer unsigned, fadeduration integer unsigned, groupset integer unsigned, position integer unsigned, imgheight integer unsigned, primary key (slideshowimgid) ); create table btsurvey ( bid integer unsigned not null, question varchar(255) default '', requiresregistration integer default 0, primary key (bid) ); create table btsurveyoptions ( optionid integer unsigned not null auto_increment, bid integer, optionname varchar(255), displayorder integer default 0, primary key (optionid) ); create table btsurveyresults ( resultid integer unsigned not null auto_increment, optionid integer unsigned default 0, uid integer unsigned default 0, bid integer, cid integer, ipaddress varchar(128), timestamp timestamp, primary key (resultid) ); create table bttags ( bid integer unsigned not null, title varchar(255), targetcid integer, primary key (bid) ); create table btvideo ( bid integer unsigned not null, fid integer unsigned, width integer unsigned, height integer unsigned, primary key (bid) ); create table btyoutube ( bid integer unsigned not null, title varchar(255), videourl varchar(255), primary key (bid) ); create table if not exists `collectionsearchindexattributes` ( `cid` int(11) unsigned not null default '0', `ak_meta_title` text, `ak_meta_description` text, `ak_meta_keywords` text, `ak_exclude_nav` tinyint(4) default '0', `ak_exclude_page_list` tinyint(4) default '0', `ak_header_extra_content` text, `ak_exclude_search_index` tinyint(4) default '0', `ak_exclude_sitemapxml` tinyint(4) default '0', `ak_tags` text, primary key (`cid`) ) engine=myisam default charset=latin1; create table if not exists `filesearchindexattributes` ( `fid` int(11) unsigned not null default '0', `ak_width` decimal(14,4) default '0.0000', `ak_height` decimal(14,4) default '0.0000', primary key (`fid`) ) engine=myisam default charset=latin1; create table usersearchindexattributes ( uid integer(11) unsigned not null default 0, primary key (uid) );")
