CREATE TABLE acf_audit ( logid int NOT NULL PRIMARY KEY , timestamp datetime NULL , userid int NOT NULL , loginname varchar(12) NULL , ipaddress varchar(50) NULL , action varchar(20) NULL , message varchar(100) NULL ) TYPE=MYISAM CREATE TABLE acf_nextid ( tablename varchar(30) NOT NULL PRIMARY KEY , nextid int NOT NULL ) TYPE=MYISAM CREATE TABLE acf_task_parameter ( taskParameterId int NOT NULL PRIMARY KEY , hostId int NOT NULL , taskId int NOT NULL , parameterName varchar(30) NOT NULL , parameterValue varchar(254) NULL , FULLTEXT (parameterName,parameterValue) ) TYPE=MYISAM CREATE TABLE acf_task ( taskId int NOT NULL PRIMARY KEY , hostId int NOT NULL , userId int NOT NULL , shortText varchar(254) NULL , className varchar(254) NOT NULL , priority int NULL , message varchar(254) NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE um_user ( userId int NOT NULL PRIMARY KEY , hostId int NOT NULL , loginName varchar(12) NOT NULL , title varchar(20) NULL , firstName varchar(50) NULL , middleName varchar(50) NULL , lastName varchar(50) NULL , suffix varchar(20) NULL , password varchar(12) NULL , email varchar(50) NULL , phoneNumber varchar(20) NULL , userType int NOT NULL , language varchar(2) NULL , country varchar(2) NULL , dateFormatView varchar(20) NULL , dateFormatInput varchar(20) NULL , timeFormatView varchar(20) NULL , timeFormatInput varchar(20) NULL , styleSheet varchar(20) NULL , status int NOT NULL , lastLogin datetime NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE um_host ( hostId int NOT NULL PRIMARY KEY , shortText varchar(40) NULL , description longtext NULL , title varchar(20) NULL , firstName varchar(50) NULL , middleName varchar(50) NULL , lastName varchar(50) NULL , suffix varchar(20) NULL , email varchar(50) NULL , phoneNumber varchar(20) NULL , hostType int NOT NULL , language varchar(2) NULL , country varchar(2) NULL , street1 varchar(50) NULL , street2 varchar(50) NULL , zip varchar(10) NULL , city varchar(50) NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE um_user_role ( userRoleId int NOT NULL PRIMARY KEY , userId int NOT NULL , roleId int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_md_imagesize ( imageSizeId int NOT NULL PRIMARY KEY , hostId int NOT NULL , shortText varchar(255) NULL , description longtext NULL , imageSizeType int NULL , width int NOT NULL , height int NOT NULL , keepAspectRatio int NULL , status int NOT NULL , viewTypeList int NOT NULL , viewTypeDetail int NOT NULL , viewTypeTable int NOT NULL , viewTypeView int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_l_album_accesslist ( albumAccesListId int NOT NULL PRIMARY KEY , hostId int NOT NULL , albumId int NOT NULL , accessListId int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_p_image ( imageId int NOT NULL PRIMARY KEY , hostId int NOT NULL , imageStoreId int NOT NULL , imageName varchar(80) NOT NULL , pixelWidth int NOT NULL , pixelHeight int NOT NULL , path varchar(250) NOT NULL , type varchar(5) NULL , size bigint NOT NULL , folderId int NOT NULL , isOriginal int NULL , hasProperties int NULL , shortText varchar(255) NULL , description longtext NULL , registrationId int NOT NULL , eventDate date NULL , photographerId int NOT NULL , imageSourceId int NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL , FULLTEXT (imageName,path,shortText,description) ) TYPE=MYISAM CREATE TABLE ims_server_md_copyright ( copyrightId int NOT NULL PRIMARY KEY , hostId int NOT NULL , shortText varchar(255) NULL , description longtext NULL , copyrightName varchar(50) NULL , addWatermark int NULL , font varchar(50) NULL , fontSize double NULL , bold int NULL , italic int NULL , colorRed int NULL , colorGreen int NOT NULL , colorBlue int NOT NULL , location int NULL , watermarkType varchar(50) NULL , alpha int NULL , offset int NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_l_album_folder ( albumFolderId int NOT NULL PRIMARY KEY , hostId int NOT NULL , albumParentFolderId int NOT NULL , orderId int NOT NULL , folderName varchar(80) NOT NULL , description longtext NULL , albumId int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_p_registration ( registrationId int NOT NULL PRIMARY KEY , hostId int NOT NULL , shortText varchar(255) NULL , description longtext NULL , registrationType int NOT NULL , defaultShortText varchar(255) NULL , defaultDescription longtext NULL , defaultEventDate date NULL , defaultFolderState int NOT NULL , defaultImageState int NOT NULL , photographerId int NOT NULL , copyrightId int NOT NULL , imageSourceId int NULL , isOriginal int NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_p_image_store ( imageStoreId int NOT NULL PRIMARY KEY , hostId int NOT NULL , image MEDIUMBLOB NOT NULL , imageName varchar(80) NOT NULL , fileName varchar(250) NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_md_classification ( classificationId int NOT NULL PRIMARY KEY , hostId int NOT NULL , shortText varchar(255) NOT NULL , description longtext NULL , multipleSelection int NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_p_image_viewed ( imageViewedId int NOT NULL PRIMARY KEY , hostId int NOT NULL , imageId int NOT NULL , imageSizeId int NOT NULL , userId int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_l_album_imagesize ( albumImageSizeId int NOT NULL PRIMARY KEY , hostId int NOT NULL , albumId int NOT NULL , imageSizeId int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_p_image_property ( imagePropertyId int NOT NULL PRIMARY KEY , hostId int NOT NULL , imageId int NOT NULL , propertyName varchar(30) NOT NULL , propertyValue varchar(250) NULL , FULLTEXT (propertyName,propertyValue) ) TYPE=MYISAM CREATE TABLE ims_server_ud_imagesizepreference ( imageSizePreferenceId int NOT NULL PRIMARY KEY , hostId int NOT NULL , userId int NOT NULL , viewImageSizeId int NOT NULL , listImageSizeId int NOT NULL , detailImageSizeId int NOT NULL , tableImageSizeId int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_p_image_thumbnail ( imageThumbnailId int NOT NULL PRIMARY KEY , hostId int NOT NULL , imageId int NOT NULL , imageStoreId int NOT NULL , imageVersionId int NOT NULL , imageSizeId int NOT NULL , imageName varchar(30) NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_md_classification_node ( classificationNodeId int NOT NULL PRIMARY KEY , hostId int NOT NULL , classificationParentNodeId int NOT NULL , classificationId int NOT NULL , shortText varchar(255) NOT NULL , description longtext NULL , externalNodeId varchar(40) NOT NULL , isRootNode int NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_md_classification_value ( classificationValueId int NOT NULL PRIMARY KEY , hostId int NOT NULL , classificationId int NOT NULL , componentId int NOT NULL , objectId int NOT NULL , classificationNodeId int NOT NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_p_folder ( folderId int NOT NULL PRIMARY KEY , hostId int NOT NULL , folderName varchar(80) NOT NULL , shortText varchar(80) NOT NULL , description longtext NULL , path varchar(250) NOT NULL , noOfImiSubFolders int NOT NULL , noOfImiImages int NOT NULL , noOfAllSubFolders int NOT NULL , noOfAllImages int NOT NULL , parentFolderId int NOT NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL , FULLTEXT (folderName,description,path) ) TYPE=MYISAM CREATE TABLE ims_server_md_accesslist_header ( accessListId int NOT NULL PRIMARY KEY , hostId int NOT NULL , shortText varchar(255) NULL , description longtext NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_md_accesslist_member ( memberId int NOT NULL PRIMARY KEY , hostId int NOT NULL , accessListId int NOT NULL , userId int NOT NULL , shortText varchar(255) NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_md_photographer ( photographerId int NOT NULL PRIMARY KEY , hostId int NOT NULL , firstName varchar(50) NULL , lastName varchar(50) NULL , userId int NULL , personId int NOT NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_l_album_image ( albumImageId int NOT NULL PRIMARY KEY , hostId int NOT NULL , albumId int NOT NULL , albumFolderId int NOT NULL , imageId int NOT NULL , orderId int NOT NULL , shortText varchar(80) NOT NULL , description longtext NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_p_image_version ( imageVersionId int NOT NULL PRIMARY KEY , hostId int NOT NULL , imageId int NOT NULL , imageStoreId int NOT NULL , version int NOT NULL , imageName varchar(30) NOT NULL , shortText varchar(255) NULL , description longtext NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_md_classification_map ( classificationMapId int NOT NULL PRIMARY KEY , hostId int NOT NULL , classificationId int NOT NULL , componentId int NOT NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_md_imagesource ( imageSourceId int NOT NULL PRIMARY KEY , hostId int NOT NULL , shortText varchar(255) NULL , description longtext NULL , inventoryNumber varchar(50) NULL , imageSourceType int NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL ) TYPE=MYISAM CREATE TABLE ims_server_td_l_album ( albumId int NOT NULL PRIMARY KEY , hostId int NOT NULL , shortText varchar(255) NULL , description longtext NULL , isPublic char(1) NULL , albumType int NOT NULL , status int NOT NULL , createdAt datetime NULL , createdBy int NOT NULL , modifiedAt datetime NULL , modifiedBy int NULL , FULLTEXT (shortText,description) ) TYPE=MYISAM