How to install Multi-language Database

Go to your MySQL database and execute the following:

Log-in on MySQL console, type:

mysql -p

Use the goautodial database.
mysql> use goautodial;

Create table go_language:

mysql> CREATE TABLE IF NOT EXISTS `go_language` (
        `id` int(6) UNSIGNED NOT NULL auto_increment,
        `lang` varchar(10) collate utf8_unicode_ci NOT NULL,
        `name` varchar(100) collate utf8_unicode_ci NOT NULL,
        `path` varchar(255) collate utf8_unicode_ci,
        PRIMARY KEY  (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

Copy and paste the following Insert queries:

mysql> INSERT INTO `go_language` (lang,name,path) VALUES('en_us','English (US)','english');
mysql> INSERT INTO `go_language` (lang,name,path) VALUES('fil','Filipino','filipino');
mysql> INSERT INTO `go_language` (lang,name,path) VALUES('es','Spanish','spanish');
mysql> INSERT INTO `go_language` (lang,name,path) VALUES('it','Italian','italian');

Use asterisk database:

mysql> use asterisk;

Alter the table system_settings:

mysql> ALTER TABLE system_settings ADD COLUMN default_language varchar(10) DEFAULT 'en_us';

Access your GOautodial web applications:


Done! You should see flags from upper left corner of GoAdmin & GoAgent login. Click your desired translation