Code Samples: January 2017

Tuesday, January 31, 2017

MySQL increment row value dynamically

SELECT @i := 0;
UPDATE table SET field = (select @i := @i + 1);

How to download files from command line in Windows, like Wget

Create a file named 'Download_File.vbs' with following contents:

DownloadUrl = "http://ovh.net/files/10Mb.dat"
FileLocation = "Download.dat"

Wscript.Echo "Start Downloading"
Set ObjXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.6.0")
ObjXMLHTTP.open "GET", DownloadUrl, false, "username", "password"
'http.setTimeouts 5000, 5000, 10000, 10000 'ms - resolve, connect, send, receive'
'http.setRequestHeader "Authorization", "Basic MY_AUTH_STRING"
ObjXMLHTTP.send()

If ObjXMLHTTP.Status = 200 Then
 Set ObjADOStream = CreateObject("ADODB.Stream")
 ObjADOStream.Open
 ObjADOStream.Type = 1
 'adTypeBinary

 ObjADOStream.Write ObjXMLHTTP.ResponseBody
 ObjADOStream.Position = 0
 'Set the stream position to the start

 Set ObjFSO = Createobject("Scripting.FileSystemObject")
 If ObjFSO.Fileexists(FileLocation) Then ObjFSO.DeleteFile FileLocation
 Set ObjFSO = Nothing

 ObjADOStream.SaveToFile FileLocation
 ObjADOStream.Close
 Set ObjADOStream = Nothing
 Wscript.Echo "Download Completed: " + FileLocation
Else
 Wscript.Echo "File Not Found"
End if

Set ObjXMLHTTP = Nothing

And create another file in the same folder named 'Download_Command.bat' with following contents & double click to download file from defined url:

@ECHO OFF
cscript.exe Download_File.vbs
pause
exit;

Monday, January 30, 2017

Windows Batch Script to create new MySQL database and import

Create a file named restore.bat with following contents & double to click to create new database & import data to selected database

@ECHO OFF
cd C:\xampp\mysql\bin
mysql.exe -uroot -hlocalhost -e "drop database if exists some_db_name";
mysql.exe -uroot -hlocalhost -e "create database some_db_name default character set utf8 default collate utf8_general_ci;";
echo DB Created
mysql.exe -uroot -hlocalhost some_db_name < "C:\tmp\back_up.sql"
echo DB Restored
pause
exit;

Windows Batch Script to backup local MySQL database

Create a file name "backup.bat" with following contents and double click to backup selected database to local file.

@ECHO OFF
cd C:\xampp\mysql\bin
mysqldump.exe -uroot -hlocalhost some_db_name > "C:\tmp\back_up.sql"
echo DB Backuped
mysql.exe -uroot -hlocalhost -e "drop database if exists some_db_name";
echo DB Removed
pause
exit;

Saturday, January 28, 2017

DateTime Picker · Bootstrap

You can download full example from here

<head>
    <title>Bootstrap Date Time Picker Example</title>
    <script type="text/javascript" src="jquery-2.1.1.min.js"></script>
    <script type="text/javascript" src="moment-with-locales.js"></script>
    <script type="text/javascript" src="bootstrap.min.js"></script>
    <script type="text/javascript" src="bootstrap-datetimepicker.js"></script>

    <link rel="stylesheet" href="bootstrap.min.css"/>
    <link rel="stylesheet" href="font-awesome.min.css"/>
    <link rel="stylesheet" href="bootstrap-datetimepicker.css"/>

    <script type="text/javascript">
        $(function () {
            var start = new Date();
            start.setMinutes(start.getMinutes() + 20);
            var start_value = start.getFullYear() + "-" + (start.getMonth() + 1) + "-" + start.getDate();
            start_value += " " + start.getHours() + ":" + start.getMinutes();

            start.setDate(start.getDate() + 1);

            $('#datetimepicker1').datetimepicker({
                defaultDate: start_value,
                format: 'DD-MM-YYYY hh:mm A',
                disabledDates: [
                    start
                ],
                daysOfWeekDisabled: [0, 6],
                sideBySide: false,
                showTodayButton: true,
                showClear: true,
                showClose: true,
                onSelect: function () {
                    var minDate = $(this).datepicker('getDate');
                    $('#datetimepicker2').datepicker( "option", "minDate", minDate);
                }
            });

            $('#datetimepicker2').datetimepicker({
                defaultDate: start_value,
                format: 'DD-MM-YYYY hh:mm A',
                disabledDates: [
                    start
                ],
                daysOfWeekDisabled: [0, 6],
                sideBySide: false,
                showTodayButton: true,
                showClear: true,
                showClose: true
            });

            $('#datetimepicker3').datetimepicker({
                format: 'DD-MM-YYYY hh:mm A'
            });
            $('#datetimepicker4').datetimepicker({
                useCurrent: false,
                format: 'DD-MM-YYYY hh:mm A'
            });
            $("#datetimepicker3").on("dp.change", function (e) {
                $('#datetimepicker4').data("DateTimePicker").minDate(e.date);
            });
            $("#datetimepicker4").on("dp.change", function (e) {
                $('#datetimepicker3').data("DateTimePicker").maxDate(e.date);
            });
        });
    </script>
</head>
<body>
<div class="container">
    <div class="row">
        <div class='col-sm-6'>
            <div class="form-group">
                <div class='input-group date' id='datetimepicker1'>
                    <input type='text' class="form-control" />
                    <span class="input-group-addon">
                        <span class="glyphicon glyphicon-calendar"></span>
                    </span>
                </div>
            </div>
        </div>
        <div class='col-sm-6'>
            <div class="form-group">
                <input id="datetimepicker2" type="text" class="form-control"/>
            </div>
        </div>
    </div>
    <div class="row">
        <div class='col-md-6'>
            <div class="form-group">
                <div class='input-group date' id='datetimepicker3'>
                    <input type='text' class="form-control" />
                <span class="input-group-addon">
                    <span class="glyphicon glyphicon-calendar"></span>
                </span>
                </div>
            </div>
        </div>
        <div class='col-md-6'>
            <div class="form-group">
                <div class='input-group date' id='datetimepicker4'>
                    <input type='text' class="form-control" />
                <span class="input-group-addon">
                    <span class="glyphicon glyphicon-calendar"></span>
                </span>
                </div>
            </div>
        </div>
    </div>
</div>
</body>

Tuesday, January 24, 2017

List all timeZones in SQL Format

CREATE TABLE IF NOT EXISTS time_zone_list 
(id int(11) NOT NULL AUTO_INCREMENT,name varchar(50) NOT NULL,display_value varchar(100) NOT NULL,PRIMARY KEY (id))
ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Abidjan', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Accra', 'Ghana Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Addis_Ababa', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Algiers', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Asmara', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Asmera', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bamako', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bangui', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Banjul', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bissau', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Blantyre', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Brazzaville', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bujumbura', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Cairo', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Casablanca', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Ceuta', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Conakry', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Dakar', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Dar_es_Salaam', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Djibouti', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Douala', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/El_Aaiun', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Freetown', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Gaborone', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Harare', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Johannesburg', 'South Africa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Juba', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Kampala', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Khartoum', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Kigali', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Kinshasa', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lagos', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Libreville', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lome', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Luanda', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lubumbashi', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lusaka', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Malabo', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Maputo', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Maseru', 'South Africa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Mbabane', 'South Africa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Mogadishu', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Monrovia', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Nairobi', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Ndjamena', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Niamey', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Nouakchott', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Ouagadougou', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Porto-Novo', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Sao_Tome', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Timbuktu', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Tripoli', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Tunis', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Windhoek', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Adak', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Anchorage', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Anguilla', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Antigua', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Araguaina', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Buenos_Aires', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Catamarca', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/ComodRivadavia', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Cordoba', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Jujuy', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/La_Rioja', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Mendoza', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Rio_Gallegos', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Salta', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/San_Juan', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/San_Luis', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Tucuman', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Ushuaia', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Aruba', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Asuncion', 'Paraguay Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Atikokan', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Atka', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Bahia', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Bahia_Banderas', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Barbados', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Belem', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Belize', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Blanc-Sablon', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Boa_Vista', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Bogota', 'Colombia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Boise', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Buenos_Aires', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cambridge_Bay', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Campo_Grande', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cancun', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Caracas', 'Venezuela Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Catamarca', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cayenne', 'French Guiana Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cayman', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Chicago', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Chihuahua', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Coral_Harbour', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cordoba', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Costa_Rica', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Creston', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cuiaba', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Curacao', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Danmarkshavn', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Dawson', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Dawson_Creek', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Denver', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Detroit', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Dominica', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Edmonton', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Eirunepe', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/El_Salvador', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Ensenada', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Fort_Nelson', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Fort_Wayne', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Fortaleza', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Glace_Bay', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Godthab', 'Western Greenland Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Goose_Bay', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Grand_Turk', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Grenada', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guadeloupe', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guatemala', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guayaquil', 'Ecuador Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guyana', 'Guyana Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Halifax', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Havana', 'Cuba Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Hermosillo', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Indianapolis', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Knox', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Marengo', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Petersburg', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Tell_City', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Vevay', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Vincennes', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Winamac', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indianapolis', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Inuvik', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Iqaluit', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Jamaica', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Jujuy', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Juneau', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Kentucky/Louisville', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Kentucky/Monticello', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Knox_IN', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Kralendijk', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/La_Paz', 'Bolivia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Lima', 'Peru Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Los_Angeles', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Louisville', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Lower_Princes', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Maceio', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Managua', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Manaus', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Marigot', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Martinique', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Matamoros', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Mazatlan', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Mendoza', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Menominee', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Merida', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Metlakatla', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Mexico_City', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Miquelon', 'Pierre & Miquelon Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Moncton', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Monterrey', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Montevideo', 'Uruguay Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Montreal', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Montserrat', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Nassau', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/New_York', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Nipigon', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Nome', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Noronha', 'Fernando de Noronha Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/North_Dakota/Beulah', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/North_Dakota/Center', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/North_Dakota/New_Salem', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Ojinaga', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Panama', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Pangnirtung', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Paramaribo', 'Suriname Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Phoenix', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Port-au-Prince', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Port_of_Spain', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Porto_Acre', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Porto_Velho', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Puerto_Rico', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rainy_River', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rankin_Inlet', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Recife', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Regina', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Resolute', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rio_Branco', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rosario', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santa_Isabel', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santarem', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santiago', 'Chile Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santo_Domingo', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Sao_Paulo', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Scoresbysund', 'Eastern Greenland Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Shiprock', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Sitka', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Barthelemy', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Johns', 'Newfoundland Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Kitts', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Lucia', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Thomas', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Vincent', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Swift_Current', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Tegucigalpa', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Thule', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Thunder_Bay', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Tijuana', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Toronto', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Tortola', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Vancouver', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Virgin', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Whitehorse', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Winnipeg', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Yakutat', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Yellowknife', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Casey', 'Australian Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Davis', 'Davis Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/DumontDUrville', 'Dumont-d''Urville Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Macquarie', 'Macquarie Island Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Mawson', 'Mawson Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/McMurdo', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Palmer', 'Chile Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Rothera', 'Rothera Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/South_Pole', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Syowa', 'Syowa Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Troll', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Vostok', 'Vostok Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Arctic/Longyearbyen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Aden', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Almaty', 'Alma-Ata Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Amman', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Anadyr', 'Anadyr Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Aqtau', 'Aqtau Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Aqtobe', 'Aqtobe Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ashgabat', 'Turkmenistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ashkhabad', 'Turkmenistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Baghdad', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Bahrain', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Baku', 'Azerbaijan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Bangkok', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Beirut', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Bishkek', 'Kirgizstan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Brunei', 'Brunei Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Calcutta', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Chita', 'Yakutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Choibalsan', 'Choibalsan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Chongqing', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Chungking', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Colombo', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dacca', 'Bangladesh Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Damascus', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dhaka', 'Bangladesh Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dili', 'Timor-Leste Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dubai', 'Gulf Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dushanbe', 'Tajikistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Gaza', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Harbin', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Hebron', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ho_Chi_Minh', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Hong_Kong', 'Hong Kong Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Hovd', 'Hovd Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Irkutsk', 'Irkutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Istanbul', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Jakarta', 'West Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Jayapura', 'East Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Jerusalem', 'Israel Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kabul', 'Afghanistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kamchatka', 'Petropavlovsk-Kamchatski Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Karachi', 'Pakistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kashgar', 'Xinjiang Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kathmandu', 'Nepal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Katmandu', 'Nepal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Khandyga', 'Yakutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kolkata', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Krasnoyarsk', 'Krasnoyarsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kuala_Lumpur', 'Malaysia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kuching', 'Malaysia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kuwait', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Macao', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Macau', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Magadan', 'Magadan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Makassar', 'Central Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Manila', 'Philippines Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Muscat', 'Gulf Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Nicosia', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Novokuznetsk', 'Krasnoyarsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Novosibirsk', 'Novosibirsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Omsk', 'Omsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Oral', 'Oral Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Phnom_Penh', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Pontianak', 'West Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Pyongyang', 'Korea Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Qatar', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Qyzylorda', 'Qyzylorda Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Rangoon', 'Myanmar Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Riyadh', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Saigon', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Sakhalin', 'Sakhalin Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Samarkand', 'Uzbekistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Seoul', 'Korea Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Shanghai', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Singapore', 'Singapore Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Srednekolymsk', 'Srednekolymsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Taipei', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tashkent', 'Uzbekistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tbilisi', 'Georgia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tehran', 'Iran Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tel_Aviv', 'Israel Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Thimbu', 'Bhutan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Thimphu', 'Bhutan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tokyo', 'Japan Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ujung_Pandang', 'Central Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ulaanbaatar', 'Ulaanbaatar Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ulan_Bator', 'Ulaanbaatar Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Urumqi', 'Xinjiang Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ust-Nera', 'Ust-Nera Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Vientiane', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Vladivostok', 'Vladivostok Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Yakutsk', 'Yakutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Yekaterinburg', 'Yekaterinburg Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Yerevan', 'Armenia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Azores', 'Azores Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Bermuda', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Canary', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Cape_Verde', 'Cape Verde Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Faeroe', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Faroe', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Jan_Mayen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Madeira', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Reykjavik', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/South_Georgia', 'South Georgia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/St_Helena', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Stanley', 'Falkland Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/ACT', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Adelaide', 'Australian Central Standard Time (South Australia)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Brisbane', 'Australian Eastern Standard Time (Queensland)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Broken_Hill', 'Australian Central Standard Time (South Australia/New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Canberra', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Currie', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Darwin', 'Australian Central Standard Time (Northern Territory)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Eucla', 'Australian Central Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Hobart', 'Australian Eastern Standard Time (Tasmania)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/LHI', 'Lord Howe Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Lindeman', 'Australian Eastern Standard Time (Queensland)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Lord_Howe', 'Lord Howe Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Melbourne', 'Australian Eastern Standard Time (Victoria)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/NSW', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/North', 'Australian Central Standard Time (Northern Territory)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Perth', 'Australian Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Queensland', 'Australian Eastern Standard Time (Queensland)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/South', 'Australian Central Standard Time (South Australia)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Sydney', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Tasmania', 'Australian Eastern Standard Time (Tasmania)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Victoria', 'Australian Eastern Standard Time (Victoria)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/West', 'Australian Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Yancowinna', 'Australian Central Standard Time (South Australia/New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/Acre', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/DeNoronha', 'Fernando de Noronha Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/East', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/West', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CET', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CST6CDT', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Atlantic', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Central', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/East-Saskatchewan', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Eastern', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Mountain', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Newfoundland', 'Newfoundland Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Pacific', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Saskatchewan', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Yukon', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Chile/Continental', 'Chile Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Chile/EasterIsland', 'Easter Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Cuba', 'Cuba Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EET', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EST5EDT', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Egypt', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Eire', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+1', 'GMT-01:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+10', 'GMT-10:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+11', 'GMT-11:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+12', 'GMT-12:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+2', 'GMT-02:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+3', 'GMT-03:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+4', 'GMT-04:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+5', 'GMT-05:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+6', 'GMT-06:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+7', 'GMT-07:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+8', 'GMT-08:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+9', 'GMT-09:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-1', 'GMT+01:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-10', 'GMT+10:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-11', 'GMT+11:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-12', 'GMT+12:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-13', 'GMT+13:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-14', 'GMT+14:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-2', 'GMT+02:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-3', 'GMT+03:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-4', 'GMT+04:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-5', 'GMT+05:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-6', 'GMT+06:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-7', 'GMT+07:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-8', 'GMT+08:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-9', 'GMT+09:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/Greenwich', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/UCT', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/UTC', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/Universal', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/Zulu', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Amsterdam', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Andorra', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Athens', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Belfast', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Belgrade', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Berlin', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Bratislava', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Brussels', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Bucharest', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Budapest', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Busingen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Chisinau', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Copenhagen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Dublin', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Gibraltar', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Guernsey', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Helsinki', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Isle_of_Man', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Istanbul', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Jersey', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Kaliningrad', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Kiev', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Lisbon', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Ljubljana', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/London', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Luxembourg', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Madrid', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Malta', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Mariehamn', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Minsk', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Monaco', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Moscow', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Nicosia', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Oslo', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Paris', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Podgorica', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Prague', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Riga', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Rome', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Samara', 'Samara Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/San_Marino', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Sarajevo', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Simferopol', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Skopje', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Sofia', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Stockholm', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Tallinn', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Tirane', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Tiraspol', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Uzhgorod', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vaduz', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vatican', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vienna', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vilnius', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Volgograd', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Warsaw', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Zagreb', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Zaporozhye', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Zurich', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GB', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GB-Eire', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GMT', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GMT0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Greenwich', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Hongkong', 'Hong Kong Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Iceland', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Antananarivo', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Chagos', 'Indian Ocean Territory Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Christmas', 'Christmas Island Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Cocos', 'Cocos Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Comoro', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Kerguelen', 'French Southern & Antarctic Lands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Mahe', 'Seychelles Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Maldives', 'Maldives Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Mauritius', 'Mauritius Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Mayotte', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Reunion', 'Reunion Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Iran', 'Iran Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Israel', 'Israel Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Jamaica', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Japan', 'Japan Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Kwajalein', 'Marshall Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Libya', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MET', 'Middle Europe Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MST7MDT', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Mexico/BajaNorte', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Mexico/BajaSur', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Mexico/General', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NZ', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NZ-CHAT', 'Chatham Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Navajo', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PRC', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PST8PDT', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Apia', 'West Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Auckland', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Bougainville', 'Bougainville Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Chatham', 'Chatham Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Chuuk', 'Chuuk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Easter', 'Easter Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Efate', 'Vanuatu Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Enderbury', 'Phoenix Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Fakaofo', 'Tokelau Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Fiji', 'Fiji Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Funafuti', 'Tuvalu Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Galapagos', 'Galapagos Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Gambier', 'Gambier Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Guadalcanal', 'Solomon Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Guam', 'Chamorro Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Honolulu', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Johnston', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Kiritimati', 'Line Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Kosrae', 'Kosrae Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Kwajalein', 'Marshall Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Majuro', 'Marshall Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Marquesas', 'Marquesas Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Midway', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Nauru', 'Nauru Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Niue', 'Niue Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Norfolk', 'Norfolk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Noumea', 'New Caledonia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Pago_Pago', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Palau', 'Palau Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Pitcairn', 'Pitcairn Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Pohnpei', 'Pohnpei Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Ponape', 'Pohnpei Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Port_Moresby', 'Papua New Guinea Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Rarotonga', 'Cook Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Saipan', 'Chamorro Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Samoa', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Tahiti', 'Tahiti Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Tarawa', 'Gilbert Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Tongatapu', 'Tonga Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Truk', 'Chuuk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Wake', 'Wake Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Wallis', 'Wallis & Futuna Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Yap', 'Chuuk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Poland', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Portugal', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ROK', 'Korea Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Singapore', 'Singapore Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/AST4', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/AST4ADT', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/CST6', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/CST6CDT', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/EST5', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/EST5EDT', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/HST10', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/MST7', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/MST7MDT', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/PST8', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/PST8PDT', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/YST9', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/YST9YDT', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Turkey', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('UCT', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Alaska', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Aleutian', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Arizona', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Central', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/East-Indiana', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Eastern', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Hawaii', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Indiana-Starke', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Michigan', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Mountain', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Pacific', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Pacific-New', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Samoa', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('UTC', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Universal', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('W-SU', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('WET', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Zulu', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EST', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('HST', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MST', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ACT', 'Australian Central Standard Time (Northern Territory)');
INSERT INTO time_zone_list(name, display_value) VALUES('AET', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('AGT', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ART', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('AST', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('BET', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('BST', 'Bangladesh Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CAT', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CNT', 'Newfoundland Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CST', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CTT', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EAT', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ECT', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('IET', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('IST', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('JST', 'Japan Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MIT', 'West Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NET', 'Armenia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NST', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PLT', 'Pakistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PNT', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PRT', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PST', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SST', 'Solomon Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('VST', 'Indochina Time');

Thursday, January 19, 2017

php - Send ics calendar invite using Swift Mailer

Download full source code from here

This code works fine with Gmail, Yahoo, Office 365, Outlook & Others. Some screenshots of different mail system are below.

Sample Request

BEGIN:VCALENDAR
VERSION:2.0
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART:20170118T134600Z
DTEND:20170118T141600Z
DTSTAMP:20170118T132600Z
UID:PKMf3c65f6ac8d3c3e1a99f3464acb6d11723400878
ORGANIZER;CN=email@organizer.pkm:mailto:email@organizer.pkm
ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;
    CN=pritomkucse@yahoo.com;X-NUM-GUESTS=0:mailto:pritomkucse@yahoo.com
ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;
    CN=pritomkucse@gmail.com;X-NUM-GUESTS=0:mailto:pritomkucse@gmail.com
CLASS:PRIVATE
DESCRIPTION:Some Calendar Description
LOCATION:Some Calendar Location
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Some Calendar Summary
TRANSP:OPAQUE
PRIORITY:5
BEGIN:VALARM
DESCRIPTION:REMINDER
TRIGGER:-P0DT0H10M0S
ACTION:DISPLAY
END:VALARM
END:VEVENT
END:VCALENDAR

Sample response

Google Email Inbox View:

Google Calendar Box View:

Yahoo Email Inbox View:

Yahoo Calendar Box View:

Office 365 Email Inbox View:

Customized Email Inbox View

Outlook 2013 Email Inbox View

Calendar Reminder Notification Example

Saturday, January 14, 2017

Implement Redirect Interceptor For All Http Call - Angular JS

Download resources from here

<script type="text/javascript" src="angular.js"></script>
<script type="text/javascript" src="angular-resource.js"></script>

<div data-ng-app="myApp" data-ng-controller="MyCtrl">[[dataFromAngularJS]]</div>

<script type="text/javascript">
    var app = angular.module('myApp', ['ngResource'], function ($interpolateProvider) {
        $interpolateProvider.startSymbol('[[');
        $interpolateProvider.endSymbol(']]');
    });
    app.config(['$httpProvider', '$controllerProvider', function ($httpProvider, $controllerProvider, $window) {
        $httpProvider.interceptors.push('redirectInterceptor');
    }])
    .run(function ($rootScope, $window) {
        console.log("MY_APP START RUNNING");
        $rootScope.baseUrl = "/";
    })
    .factory('redirectInterceptor', function ($q, $location, $window, $rootScope) {
        return {
            response: function (response) {
                console.log("GOT DATA VIA AJAX CALL");
                console.log(response);
                return response;
            },
            responseError: function(response) {
                console.log("GOT ERROR VIA AJAX CALL");
                console.log(response);
                response.data = "ERROR";
                return $q.reject(response);
            }
        }
    });

    app.controller('MyCtrl', ['$scope', '$http', function ($scope, $http) {
        $scope.dataFromAngularJS = "Data From Angular JS";

        $http.get('data.html').
        success(function(response, status, headers, config) {
            $scope.dataFromAngularJS = "Success=" + response;
        }).
        error(function(response, status, headers, config) {
            $scope.dataFromAngularJS = "Error=" + response;
        });
    }]);
</script>

Abort / Cancel jQuery Ajax Request Example

<script type="text/javascript" src="jquery-min.js"></script>
<script type="text/javascript">
    $(document).ready(function() {
        var $xhr = $.ajax({
            url: "search.php",
            type: "POST",
            data: {id: 1, name: "Pritom Kumar"},
            beforeSend: function(xhr){
                xhr.setRequestHeader('X-Test-Header1', 'test-value1');
                xhr.setRequestHeader('X-Test-Header2', 'test-value2');
            },
            dataType: "json"
        }).done(function(data, textStatus, jqXHR) {

        }).fail(function(jqXHR, textStatus, errorThrown) {
            alert("Failed With Reason=" + textStatus);
        });
        setTimeout(function() {
            $xhr.abort();
        }, 100);
    });
</script>

Send Calendar invite using Php & SwiftMailer

Download full source code from here

This code works fine with Gmail, Yahoo, Office 365, Outlook & Others. Some screenshots of different mail system are below.

Sample Request

BEGIN:VCALENDAR
VERSION:2.0
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART:20170118T134600Z
DTEND:20170118T141600Z
DTSTAMP:20170118T132600Z
UID:PKMf3c65f6ac8d3c3e1a99f3464acb6d11723400878
ORGANIZER;CN=email@organizer.pkm:mailto:email@organizer.pkm
ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;
    CN=pritomkucse@yahoo.com;X-NUM-GUESTS=0:mailto:pritomkucse@yahoo.com
ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;
    CN=pritomkucse@gmail.com;X-NUM-GUESTS=0:mailto:pritomkucse@gmail.com
CLASS:PRIVATE
DESCRIPTION:Some Calendar Description
LOCATION:Some Calendar Location
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Some Calendar Summary
TRANSP:OPAQUE
PRIORITY:5
BEGIN:VALARM
DESCRIPTION:REMINDER
TRIGGER:-P0DT0H10M0S
ACTION:DISPLAY
END:VALARM
END:VEVENT
END:VCALENDAR

Pages

Tuesday, January 31, 2017

Create a file named 'Download_File.vbs' with following contents:

And create another file in the same folder named 'Download_Command.bat' with following contents & double click to download file from defined url:

Monday, January 30, 2017

Create a file named restore.bat with following contents & double to click to create new database & import data to selected database

Create a file name "backup.bat" with following contents and double click to backup selected database to local file.

Saturday, January 28, 2017

You can download full example from here

Tuesday, January 24, 2017

Thursday, January 19, 2017

Download full source code from here

Sample Request

Sample response

Google Email Inbox View:

Google Calendar Box View:

Yahoo Email Inbox View:

Yahoo Calendar Box View:

Office 365 Email Inbox View:

Customized Email Inbox View

Outlook 2013 Email Inbox View

Calendar Reminder Notification Example

Saturday, January 14, 2017

Download resources from here

Download full source code from here

Sample Request

Sample response

Google Email Inbox View:

Google Calendar Box View:

Yahoo Email Inbox View:

Yahoo Calendar Box View:

Office 365 Email Inbox View:

Customized Email Inbox View

Outlook 2013 Email Inbox View

Calendar Reminder Notification Example