You must be logged in. Please login now.
customDatasource = application.ptProfile.profileSync.getSyncDataSource();
customDbType = application.ptProfile.profileSync.getSyncDbType(); // mssql, mysql
profileSyncTableName = application.ptProfile.profileSync.getSyncTableName(); // "profiles_sync";
shim_idFieldName = application.ptProfile.profileSync.getSyncIdFieldName();
shim_idFieldSqlType = application.ptProfile.profileSync.getSyncIdFieldSqlType();
if ( customDbType EQ "mysql" )
{
shim_primaryKeyFieldSqlType = "INT NOT NULL PRIMARY KEY AUTO_INCREMENT";
shim_longTextSqlType = "longtext NULL";
}
else
{
shim_primaryKeyFieldSqlType = "INT IDENTITY(1,1) PRIMARY KEY";
shim_longTextSqlType = "varchar(max) NULL";
}
// Set these rebuild variable to true to rebuild the database schema
rebuildProfiles = false;
dropProfiles = false;
if ( StructKeyExists(request.params,"buildSchema") AND request.params.buildSchema EQ 1 )
{
rebuildProfiles = true;
}
if ( StructKeyExists(request.params,"dropSchema") AND request.params.dropSchema EQ 1 )
{
dropProfiles = true;
}
/*
NOTE: To UPDATE the Page Sync code table NAMES, code in the App
that query these tables will also need to be updated.
*/
Build schema for Profile Sync
tableName = profileSyncTableName;
if ( rebuildProfiles )
{
dropTable = true;
buildTable = true;
}
else if ( dropProfiles )
{
dropTable = true;
buildTable = false;
}
Creating #tableName# Table!
Droping existing #tableName# Table!
DROP TABLE #tableName#
CREATE TABLE #tableName# (
ID #shim_primaryKeyFieldSqlType#
,#shim_idFieldName# #shim_idFieldSqlType#
,PageID INT NOT NULL
,DataPageID INT NOT NULL
,UserID VARCHAR(255) NULL
,Description #shim_longTextSqlType#
,lastUpdate VARCHAR(20) NOT NULL
,name VARCHAR(1024) NOT NULL
,Title VARCHAR(255) NULL
,Caption VARCHAR(255) NULL
,FileName VARCHAR(1024) NOT NULL
,saveType VARCHAR(255) NULL
)
#tableName# Created Successfully!
#tableName# Creation Failed!
tableName = profileSyncTableName;
SELECT *
FROM #tableName#
#tableName# Creation Failed!