If you wish, you may manually edit the settings in the worshiplive_settings.php file yourself before uploading it. The file contains several lines that have different functions. ONLY edit the items between quote marks!!!!
$churchname = "Your Church of God"; // This determines what will appear on the title of your online access to the database
$host = "mysql01.yourserver.com"; // Set this to the host name of your MySQL server
$securityusername = "SQLusername"; // Set this to the login name for your MySQL server
$securitypassword = "SQLpassword"; // Set this to the login password for your MySQL server
$db_name = "worshiplive"; // This is the database name in which the song data will be stored on your MySQL server
$db_table = "wl_songs"; // This is the table name for the song data to be stored on your MySQL server
$leaderpassword = "worshipper"; // This is the administrator password for your song data. It gives full read/write/delete permission.
$userpassword = "user"; // This password is for general user access, where song data can only be read/downloaded but not written.
If you wish to set up the database table manually, you can use a MySQL query like this to do the job:
$query = "CREATE TABLE `worshiplive_songs` (
`uid` varchar(40) NOT NULL default '',
`title` varchar(128) NOT NULL default '',
`key` char(3) NOT NULL default '',
`tempo` varchar(12) NOT NULL default '',
`topic` varchar(128) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
`userinfo1` varchar(255) NOT NULL default '',
`userinfo2` varchar(255) NOT NULL default '',
`userinfo3` varchar(255) NOT NULL default '',
`lastprinted` varchar(16) NOT NULL default '',
`lastprojected` varchar(16) NOT NULL default '',
`musicby` varchar(255) NOT NULL default '',
`wordsby` varchar(255) NOT NULL default '',
`copyright` varchar(255) NOT NULL default '',
`cclinum` varchar(12) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`filedatetime` varchar(32) NOT NULL default '0000-00-00',
`textdatetime` varchar(32) NOT NULL default '',
`filecontents` text NOT NULL,
`textcontents` text NOT NULL,
`datemodified` date NOT NULL default '0000-00-00',
`datesynchronized` date NOT NULL default '0000-00-00',
`editorname` varchar(64) NOT NULL default '',
`backupdata` text NOT NULL,
UNIQUE KEY `uid` (`uid`)
) TYPE=MyISAM;";