INSERT INTO `mw_zone` (`zone_id`, `country_id`, `name`, `code`, `status`, `date_added`, `last_updated`) VALUES
(3493, 220, 'L''viv', 'LV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3494, 220, 'Mykolayiv', 'MY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3495, 220, 'Odesa', 'OD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3496, 220, 'Poltava', 'PO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3497, 220, 'Rivne', 'RI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3498, 220, 'Sevastopol', 'SE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3499, 220, 'Sumy', 'SU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3500, 220, 'Ternopil''', 'TE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3501, 220, 'Vinnytsya', 'VI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3502, 220, 'Volyn''', 'VO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3503, 220, 'Zakarpattya', 'ZK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3504, 220, 'Zaporizhzhya', 'ZA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3505, 220, 'Zhytomyr', 'ZH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3506, 221, 'Abu Zaby', 'AZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3507, 221, '''Ajman', 'AJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3508, 221, 'Al Fujayrah', 'FU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3509, 221, 'Ash Shariqah', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3510, 221, 'Dubayy', 'DU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3511, 221, 'R''as al Khaymah', 'RK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3512, 221, 'Umm al Qaywayn', 'UQ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3513, 222, 'Aberdeen', 'ABN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3514, 222, 'Aberdeenshire', 'ABNS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3515, 222, 'Anglesey', 'ANG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3516, 222, 'Angus', 'AGS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3517, 222, 'Argyll and Bute', 'ARY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3518, 222, 'Bedfordshire', 'BEDS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3519, 222, 'Berkshire', 'BERKS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3520, 222, 'Blaenau Gwent', 'BLA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3521, 222, 'Bridgend', 'BRI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3522, 222, 'Bristol', 'BSTL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3523, 222, 'Buckinghamshire', 'BUCKS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3524, 222, 'Caerphilly', 'CAE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3525, 222, 'Cambridgeshire', 'CAMBS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3526, 222, 'Cardiff', 'CDF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3527, 222, 'Carmarthenshire', 'CARM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3528, 222, 'Ceredigion', 'CDGN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3529, 222, 'Cheshire', 'CHES', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3530, 222, 'Clackmannanshire', 'CLACK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3531, 222, 'Conwy', 'CON', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3532, 222, 'Cornwall', 'CORN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3533, 222, 'Denbighshire', 'DNBG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3534, 222, 'Derbyshire', 'DERBY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3535, 222, 'Devon', 'DVN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3536, 222, 'Dorset', 'DOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3537, 222, 'Dumfries and Galloway', 'DGL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3538, 222, 'Dundee', 'DUND', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3539, 222, 'Durham', 'DHM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3540, 222, 'East Ayrshire', 'ARYE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3541, 222, 'East Dunbartonshire', 'DUNBE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3542, 222, 'East Lothian', 'LOTE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3543, 222, 'East Renfrewshire', 'RENE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3544, 222, 'East Riding of Yorkshire', 'ERYS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3545, 222, 'East Sussex', 'SXE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3546, 222, 'Edinburgh', 'EDIN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3547, 222, 'Essex', 'ESX', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3548, 222, 'Falkirk', 'FALK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3549, 222, 'Fife', 'FFE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3550, 222, 'Flintshire', 'FLINT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3551, 222, 'Glasgow', 'GLAS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3552, 222, 'Gloucestershire', 'GLOS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3553, 222, 'Greater London', 'LDN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3554, 222, 'Greater Manchester', 'MCH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3555, 222, 'Gwynedd', 'GDD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3556, 222, 'Hampshire', 'HANTS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3557, 222, 'Herefordshire', 'HWR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3558, 222, 'Hertfordshire', 'HERTS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3559, 222, 'Highlands', 'HLD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3560, 222, 'Inverclyde', 'IVER', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3561, 222, 'Isle of Wight', 'IOW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3562, 222, 'Kent', 'KNT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3563, 222, 'Lancashire', 'LANCS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3564, 222, 'Leicestershire', 'LEICS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3565, 222, 'Lincolnshire', 'LINCS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3566, 222, 'Merseyside', 'MSY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3567, 222, 'Merthyr Tydfil', 'MERT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3568, 222, 'Midlothian', 'MLOT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3569, 222, 'Monmouthshire', 'MMOUTH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3570, 222, 'Moray', 'MORAY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3571, 222, 'Neath Port Talbot', 'NPRTAL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3572, 222, 'Newport', 'NEWPT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3573, 222, 'Norfolk', 'NOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3574, 222, 'North Ayrshire', 'ARYN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3575, 222, 'North Lanarkshire', 'LANN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3576, 222, 'North Yorkshire', 'YSN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3577, 222, 'Northamptonshire', 'NHM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3578, 222, 'Northumberland', 'NLD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3579, 222, 'Nottinghamshire', 'NOT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3580, 222, 'Orkney Islands', 'ORK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3581, 222, 'Oxfordshire', 'OFE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3582, 222, 'Pembrokeshire', 'PEM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3583, 222, 'Perth and Kinross', 'PERTH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3584, 222, 'Powys', 'PWS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3585, 222, 'Renfrewshire', 'REN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3586, 222, 'Rhondda Cynon Taff', 'RHON', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3587, 222, 'Rutland', 'RUT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3588, 222, 'Scottish Borders', 'BOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3589, 222, 'Shetland Islands', 'SHET', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3590, 222, 'Shropshire', 'SPE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3591, 222, 'Somerset', 'SOM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3592, 222, 'South Ayrshire', 'ARYS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3593, 222, 'South Lanarkshire', 'LANS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3594, 222, 'South Yorkshire', 'YSS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3595, 222, 'Staffordshire', 'SFD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3596, 222, 'Stirling', 'STIR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3597, 222, 'Suffolk', 'SFK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3598, 222, 'Surrey', 'SRY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3599, 222, 'Swansea', 'SWAN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3600, 222, 'Torfaen', 'TORF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3601, 222, 'Tyne and Wear', 'TWR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3602, 222, 'Vale of Glamorgan', 'VGLAM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3603, 222, 'Warwickshire', 'WARKS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3604, 222, 'West Dunbartonshire', 'WDUN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3605, 222, 'West Lothian', 'WLOT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3606, 222, 'West Midlands', 'WMD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3607, 222, 'West Sussex', 'SXW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3608, 222, 'West Yorkshire', 'YSW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3609, 222, 'Western Isles', 'WIL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3610, 222, 'Wiltshire', 'WLT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3611, 222, 'Worcestershire', 'WORCS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3612, 222, 'Wrexham', 'WRX', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3613, 223, 'Alabama', 'AL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3614, 223, 'Alaska', 'AK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3615, 223, 'American Samoa', 'AS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3616, 223, 'Arizona', 'AZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3617, 223, 'Arkansas', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3618, 223, 'Armed Forces Africa', 'AF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3619, 223, 'Armed Forces Americas', 'AA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3620, 223, 'Armed Forces Canada', 'AC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3621, 223, 'Armed Forces Europe', 'AE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3622, 223, 'Armed Forces Middle East', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3623, 223, 'Armed Forces Pacific', 'AP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3624, 223, 'California', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3625, 223, 'Colorado', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3626, 223, 'Connecticut', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3627, 223, 'Delaware', 'DE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3628, 223, 'District of Columbia', 'DC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3629, 223, 'Federated States Of Micronesia', 'FM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3630, 223, 'Florida', 'FL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3631, 223, 'Georgia', 'GA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3632, 223, 'Guam', 'GU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3633, 223, 'Hawaii', 'HI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3634, 223, 'Idaho', 'ID', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3635, 223, 'Illinois', 'IL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3636, 223, 'Indiana', 'IN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3637, 223, 'Iowa', 'IA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3638, 223, 'Kansas', 'KS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3639, 223, 'Kentucky', 'KY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3640, 223, 'Louisiana', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3641, 223, 'Maine', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3642, 223, 'Marshall Islands', 'MH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3643, 223, 'Maryland', 'MD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3644, 223, 'Massachusetts', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3645, 223, 'Michigan', 'MI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3646, 223, 'Minnesota', 'MN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3647, 223, 'Mississippi', 'MS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3648, 223, 'Missouri', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3649, 223, 'Montana', 'MT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3650, 223, 'Nebraska', 'NE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3651, 223, 'Nevada', 'NV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3652, 223, 'New Hampshire', 'NH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3653, 223, 'New Jersey', 'NJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3654, 223, 'New Mexico', 'NM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3655, 223, 'New York', 'NY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3656, 223, 'North Carolina', 'NC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3657, 223, 'North Dakota', 'ND', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3658, 223, 'Northern Mariana Islands', 'MP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3659, 223, 'Ohio', 'OH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3660, 223, 'Oklahoma', 'OK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3661, 223, 'Oregon', 'OR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3662, 223, 'Palau', 'PW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3663, 223, 'Pennsylvania', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3664, 223, 'Puerto Rico', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3665, 223, 'Rhode Island', 'RI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3666, 223, 'South Carolina', 'SC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3667, 223, 'South Dakota', 'SD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3668, 223, 'Tennessee', 'TN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3669, 223, 'Texas', 'TX', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3670, 223, 'Utah', 'UT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3671, 223, 'Vermont', 'VT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3672, 223, 'Virgin Islands', 'VI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3673, 223, 'Virginia', 'VA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3674, 223, 'Washington', 'WA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3675, 223, 'West Virginia', 'WV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3676, 223, 'Wisconsin', 'WI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3677, 223, 'Wyoming', 'WY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3678, 224, 'Baker Island', 'BI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3679, 224, 'Howland Island', 'HI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3680, 224, 'Jarvis Island', 'JI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3681, 224, 'Johnston Atoll', 'JA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3682, 224, 'Kingman Reef', 'KR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3683, 224, 'Midway Atoll', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3684, 224, 'Navassa Island', 'NI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3685, 224, 'Palmyra Atoll', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3686, 224, 'Wake Island', 'WI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3687, 225, 'Artigas', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3688, 225, 'Canelones', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3689, 225, 'Cerro Largo', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3690, 225, 'Colonia', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3691, 225, 'Durazno', 'DU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3692, 225, 'Flores', 'FS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3693, 225, 'Florida', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3694, 225, 'Lavalleja', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3695, 225, 'Maldonado', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3696, 225, 'Montevideo', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3697, 225, 'Paysandu', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3698, 225, 'Rio Negro', 'RN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3699, 225, 'Rivera', 'RV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3700, 225, 'Rocha', 'RO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3701, 225, 'Salto', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3702, 225, 'San Jose', 'SJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3703, 225, 'Soriano', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3704, 225, 'Tacuarembo', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3705, 225, 'Treinta y Tres', 'TT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3706, 226, 'Andijon', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3707, 226, 'Buxoro', 'BU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3708, 226, 'Farg''ona', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3709, 226, 'Jizzax', 'JI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3710, 226, 'Namangan', 'NG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3711, 226, 'Navoiy', 'NW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3712, 226, 'Qashqadaryo', 'QA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3713, 226, 'Qoraqalpog''iston Republikasi', 'QR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3714, 226, 'Samarqand', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3715, 226, 'Sirdaryo', 'SI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3716, 226, 'Surxondaryo', 'SU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3717, 226, 'Toshkent City', 'TK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3718, 226, 'Toshkent Region', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3719, 226, 'Xorazm', 'XO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3720, 227, 'Malampa', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3721, 227, 'Penama', 'PE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3722, 227, 'Sanma', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3723, 227, 'Shefa', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3724, 227, 'Tafea', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3725, 227, 'Torba', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3726, 229, 'Amazonas', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3727, 229, 'Anzoategui', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3728, 229, 'Apure', 'AP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3729, 229, 'Aragua', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3730, 229, 'Barinas', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3731, 229, 'Bolivar', 'BO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3732, 229, 'Carabobo', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3733, 229, 'Cojedes', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3734, 229, 'Delta Amacuro', 'DA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3735, 229, 'Dependencias Federales', 'DF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3736, 229, 'Distrito Federal', 'DI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3737, 229, 'Falcon', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3738, 229, 'Guarico', 'GU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3739, 229, 'Lara', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3740, 229, 'Merida', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3741, 229, 'Miranda', 'MI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3742, 229, 'Monagas', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3743, 229, 'Nueva Esparta', 'NE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3744, 229, 'Portuguesa', 'PO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3745, 229, 'Sucre', 'SU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3746, 229, 'Tachira', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3747, 229, 'Trujillo', 'TR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3748, 229, 'Vargas', 'VA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3749, 229, 'Yaracuy', 'YA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3750, 229, 'Zulia', 'ZU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3751, 230, 'An Giang', 'AG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3752, 230, 'Bac Giang', 'BG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3753, 230, 'Bac Kan', 'BK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3754, 230, 'Bac Lieu', 'BL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3755, 230, 'Bac Ninh', 'BC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3756, 230, 'Ba Ria-Vung Tau', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3757, 230, 'Ben Tre', 'BN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3758, 230, 'Binh Dinh', 'BH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3759, 230, 'Binh Duong', 'BU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3760, 230, 'Binh Phuoc', 'BP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3761, 230, 'Binh Thuan', 'BT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3762, 230, 'Ca Mau', 'CM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3763, 230, 'Can Tho', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3764, 230, 'Cao Bang', 'CB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3765, 230, 'Dak Lak', 'DL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3766, 230, 'Dak Nong', 'DG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3767, 230, 'Da Nang', 'DN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3768, 230, 'Dien Bien', 'DB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3769, 230, 'Dong Nai', 'DI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3770, 230, 'Dong Thap', 'DT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3771, 230, 'Gia Lai', 'GL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3772, 230, 'Ha Giang', 'HG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3773, 230, 'Hai Duong', 'HD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3774, 230, 'Hai Phong', 'HP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3775, 230, 'Ha Nam', 'HM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3776, 230, 'Ha Noi', 'HI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3777, 230, 'Ha Tay', 'HT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3778, 230, 'Ha Tinh', 'HH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3779, 230, 'Hoa Binh', 'HB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3780, 230, 'Ho Chi Minh City', 'HC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3781, 230, 'Hau Giang', 'HU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3782, 230, 'Hung Yen', 'HY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3783, 232, 'Saint Croix', 'C', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3784, 232, 'Saint John', 'J', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3785, 232, 'Saint Thomas', 'T', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3786, 233, 'Alo', 'A', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3787, 233, 'Sigave', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3788, 233, 'Wallis', 'W', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3789, 235, 'Abyan', 'AB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3790, 235, 'Adan', 'AD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3791, 235, 'Amran', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3792, 235, 'Al Bayda', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3793, 235, 'Ad Dali', 'DA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3794, 235, 'Dhamar', 'DH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3795, 235, 'Hadramawt', 'HD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3796, 235, 'Hajjah', 'HJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3797, 235, 'Al Hudaydah', 'HU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3798, 235, 'Ibb', 'IB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3799, 235, 'Al Jawf', 'JA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3800, 235, 'Lahij', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3801, 235, 'Ma''rib', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3802, 235, 'Al Mahrah', 'MR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3803, 235, 'Al Mahwit', 'MW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3804, 235, 'Sa''dah', 'SD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3805, 235, 'San''a', 'SN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3806, 235, 'Shabwah', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3807, 235, 'Ta''izz', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3808, 236, 'Kosovo', 'KOS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3809, 236, 'Montenegro', 'MON', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3810, 236, 'Serbia', 'SER', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3811, 236, 'Vojvodina', 'VOJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3812, 237, 'Bas-Congo', 'BC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3813, 237, 'Bandundu', 'BN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3814, 237, 'Equateur', 'EQ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3815, 237, 'Katanga', 'KA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3816, 237, 'Kasai-Oriental', 'KE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3817, 237, 'Kinshasa', 'KN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3818, 237, 'Kasai-Occidental', 'KW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3819, 237, 'Maniema', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3820, 237, 'Nord-Kivu', 'NK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3821, 237, 'Orientale', 'OR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3822, 237, 'Sud-Kivu', 'SK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3823, 238, 'Central', 'CE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3824, 238, 'Copperbelt', 'CB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3825, 238, 'Eastern', 'EA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3826, 238, 'Luapula', 'LP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3827, 238, 'Lusaka', 'LK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3828, 238, 'Northern', 'NO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3829, 238, 'North-Western', 'NW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3830, 238, 'Southern', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3831, 238, 'Western', 'WE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3832, 239, 'Bulawayo', 'BU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3833, 239, 'Harare', 'HA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3834, 239, 'Manicaland', 'ML', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3835, 239, 'Mashonaland Central', 'MC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3836, 239, 'Mashonaland East', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3837, 239, 'Mashonaland West', 'MW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3838, 239, 'Masvingo', 'MV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3839, 239, 'Matabeleland North', 'MN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3840, 239, 'Matabeleland South', 'MS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3841, 239, 'Midlands', 'MD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3842, 105, 'Agrigento', 'AG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3843, 105, 'Alessandria', 'AL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3844, 105, 'Ancona', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3845, 105, 'Aosta', 'AO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3846, 105, 'Arezzo', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3847, 105, 'Ascoli Piceno', 'AP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3848, 105, 'Asti', 'AT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3849, 105, 'Avellino', 'AV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3850, 105, 'Bari', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3851, 105, 'Belluno', 'BL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3852, 105, 'Benevento', 'BN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3853, 105, 'Bergamo', 'BG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3854, 105, 'Biella', 'BI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3855, 105, 'Bologna', 'BO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3856, 105, 'Bolzano', 'BZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3857, 105, 'Brescia', 'BS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3858, 105, 'Brindisi', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3859, 105, 'Cagliari', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3860, 105, 'Caltanissetta', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3861, 105, 'Campobasso', 'CB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3862, 105, 'Carbonia-Iglesias', 'CI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3863, 105, 'Caserta', 'CE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3864, 105, 'Catania', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3865, 105, 'Catanzaro', 'CZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3866, 105, 'Chieti', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3867, 105, 'Como', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3868, 105, 'Cosenza', 'CS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3869, 105, 'Cremona', 'CR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3870, 105, 'Crotone', 'KR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3871, 105, 'Cuneo', 'CN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3872, 105, 'Enna', 'EN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3873, 105, 'Ferrara', 'FE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3874, 105, 'Firenze', 'FI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3875, 105, 'Foggia', 'FG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3876, 105, 'Forli-Cesena', 'FC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3877, 105, 'Frosinone', 'FR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3878, 105, 'Genova', 'GE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3879, 105, 'Gorizia', 'GO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3880, 105, 'Grosseto', 'GR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3881, 105, 'Imperia', 'IM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3882, 105, 'Isernia', 'IS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3883, 105, 'L&#39;Aquila', 'AQ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3884, 105, 'La Spezia', 'SP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3885, 105, 'Latina', 'LT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3886, 105, 'Lecce', 'LE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3887, 105, 'Lecco', 'LC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3888, 105, 'Livorno', 'LI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3889, 105, 'Lodi', 'LO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3890, 105, 'Lucca', 'LU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3891, 105, 'Macerata', 'MC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3892, 105, 'Mantova', 'MN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3893, 105, 'Massa-Carrara', 'MS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3894, 105, 'Matera', 'MT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3895, 105, 'Medio Campidano', 'VS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3896, 105, 'Messina', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3897, 105, 'Milano', 'MI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3898, 105, 'Modena', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3899, 105, 'Napoli', 'NA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3900, 105, 'Novara', 'NO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3901, 105, 'Nuoro', 'NU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3902, 105, 'Ogliastra', 'OG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3903, 105, 'Olbia-Tempio', 'OT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3904, 105, 'Oristano', 'OR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3905, 105, 'Padova', 'PD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3906, 105, 'Palermo', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3907, 105, 'Parma', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3908, 105, 'Pavia', 'PV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3909, 105, 'Perugia', 'PG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3910, 105, 'Pesaro e Urbino', 'PU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3911, 105, 'Pescara', 'PE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3912, 105, 'Piacenza', 'PC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3913, 105, 'Pisa', 'PI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3914, 105, 'Pistoia', 'PT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3915, 105, 'Pordenone', 'PN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3916, 105, 'Potenza', 'PZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3917, 105, 'Prato', 'PO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3918, 105, 'Ragusa', 'RG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3919, 105, 'Ravenna', 'RA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3920, 105, 'Reggio Calabria', 'RC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3921, 105, 'Reggio Emilia', 'RE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3922, 105, 'Rieti', 'RI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3923, 105, 'Rimini', 'RN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3924, 105, 'Roma', 'RM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3925, 105, 'Rovigo', 'RO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3926, 105, 'Salerno', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3927, 105, 'Sassari', 'SS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3928, 105, 'Savona', 'SV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3929, 105, 'Siena', 'SI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3930, 105, 'Siracusa', 'SR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3931, 105, 'Sondrio', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3932, 105, 'Taranto', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3933, 105, 'Teramo', 'TE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3934, 105, 'Terni', 'TR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3935, 105, 'Torino', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3936, 105, 'Trapani', 'TP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3937, 105, 'Trento', 'TN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3938, 105, 'Treviso', 'TV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3939, 105, 'Trieste', 'TS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3940, 105, 'Udine', 'UD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3941, 105, 'Varese', 'VA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3942, 105, 'Venezia', 'VE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3943, 105, 'Verbano-Cusio-Ossola', 'VB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3944, 105, 'Vercelli', 'VC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3945, 105, 'Verona', 'VR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3946, 105, 'Vibo Valentia', 'VV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3947, 105, 'Vicenza', 'VI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3948, 105, 'Viterbo', 'VT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3949, 222, 'County Antrim', 'ANT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3950, 222, 'County Armagh', 'ARM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3951, 222, 'County Down', 'DOW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3952, 222, 'County Fermanagh', 'FER', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3953, 222, 'County Londonderry', 'LDY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3954, 222, 'County Tyrone', 'TYR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3955, 222, 'Cumbria', 'CMA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3956, 190, 'Pomurska', '1', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3957, 190, 'Podravska', '2', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3958, 190, 'Koroška', '3', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3959, 190, 'Savinjska', '4', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3960, 190, 'Zasavska', '5', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3961, 190, 'Spodnjeposavska', '6', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3962, 190, 'Jugovzhodna Slovenija', '7', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3963, 190, 'Osrednjeslovenska', '8', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3964, 190, 'Gorenjska', '9', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3965, 190, 'Notranjsko-kraška', '10', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3966, 190, 'Goriška', '11', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3967, 190, 'Obalno-kraška', '12', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3968, 33, 'Ruse', '', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3969, 101, 'Alborz', 'ALB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mw_article`
--
ALTER TABLE `mw_article`
 ADD PRIMARY KEY (`article_id`), ADD UNIQUE KEY `slug` (`slug`);

--
-- Indexes for table `mw_article_category`
--
ALTER TABLE `mw_article_category`
 ADD PRIMARY KEY (`category_id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `fk_article_category_article_category1_idx` (`parent_id`);

--
-- Indexes for table `mw_article_to_category`
--
ALTER TABLE `mw_article_to_category`
 ADD PRIMARY KEY (`article_id`,`category_id`), ADD KEY `fk_article_to_category_article_category1_idx` (`category_id`), ADD KEY `fk_article_to_category_article1_idx` (`article_id`);

--
-- Indexes for table `mw_bounce_server`
--
ALTER TABLE `mw_bounce_server`
 ADD PRIMARY KEY (`server_id`), ADD KEY `fk_bounce_server_customer1_idx` (`customer_id`), ADD KEY `status` (`status`);

--
-- Indexes for table `mw_campaign`
--
ALTER TABLE `mw_campaign`
 ADD PRIMARY KEY (`campaign_id`), ADD UNIQUE KEY `campaign_uid_UNIQUE` (`campaign_uid`), ADD KEY `fk_campaign_list1_idx` (`list_id`), ADD KEY `fk_campaign_list_segment1_idx` (`segment_id`), ADD KEY `fk_campaign_customer1_idx` (`customer_id`), ADD KEY `fk_campaign_campaign_group1_idx` (`group_id`), ADD KEY `type` (`type`), ADD KEY `status_delivery_logs_archived_campaign_id` (`status`,`delivery_logs_archived`,`campaign_id`);

--
-- Indexes for table `mw_campaign_abuse_report`
--
ALTER TABLE `mw_campaign_abuse_report`
 ADD PRIMARY KEY (`report_id`), ADD KEY `fk_campaign_abuse_report_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_abuse_report_customer1_idx` (`customer_id`), ADD KEY `fk_campaign_abuse_report_list1_idx` (`list_id`), ADD KEY `fk_campaign_abuse_report_list_subscriber1_idx` (`subscriber_id`);

--
-- Indexes for table `mw_campaign_attachment`
--
ALTER TABLE `mw_campaign_attachment`
 ADD PRIMARY KEY (`attachment_id`), ADD KEY `fk_campaign_attachment_campaign1_idx` (`campaign_id`);

--
-- Indexes for table `mw_campaign_bounce_log`
--
ALTER TABLE `mw_campaign_bounce_log`
 ADD PRIMARY KEY (`log_id`), ADD KEY `fk_campaign_bounce_log_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_bounce_log_list_subscriber1_idx` (`subscriber_id`), ADD KEY `sub_proc_bt` (`subscriber_id`,`processed`,`bounce_type`), ADD KEY `proc_bt` (`processed`,`bounce_type`);

--
-- Indexes for table `mw_campaign_delivery_log`
--
ALTER TABLE `mw_campaign_delivery_log`
 ADD PRIMARY KEY (`log_id`), ADD KEY `fk_campaign_delivery_log_list_subscriber1_idx` (`subscriber_id`), ADD KEY `fk_campaign_delivery_log_campaign1_idx` (`campaign_id`), ADD KEY `sub_proc_status` (`subscriber_id`,`processed`,`status`), ADD KEY `proc_status` (`processed`,`status`), ADD KEY `email_message_id` (`email_message_id`), ADD KEY `cid_status` (`campaign_id`,`status`), ADD KEY `cid_date_added` (`campaign_id`,`date_added`);

--
-- Indexes for table `mw_campaign_delivery_log_archive`
--
ALTER TABLE `mw_campaign_delivery_log_archive`
 ADD PRIMARY KEY (`log_id`), ADD KEY `fk_campaign_delivery_log_archive_list_subscriber1_idx` (`subscriber_id`), ADD KEY `fk_campaign_delivery_log_archive_campaign1_idx` (`campaign_id`), ADD KEY `sub_proc_status` (`subscriber_id`,`processed`,`status`), ADD KEY `proc_status` (`processed`,`status`), ADD KEY `email_message_id` (`email_message_id`);

--
-- Indexes for table `mw_campaign_forward_friend`
--
ALTER TABLE `mw_campaign_forward_friend`
 ADD PRIMARY KEY (`forward_id`), ADD KEY `fk_campaign_forward_friend_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_forward_friend_list_subscriber1_idx` (`subscriber_id`);

--
-- Indexes for table `mw_campaign_group`
--
ALTER TABLE `mw_campaign_group`
 ADD PRIMARY KEY (`group_id`), ADD UNIQUE KEY `group_uid` (`group_uid`), ADD KEY `fk_campaign_group_customer1_idx` (`customer_id`);

--
-- Indexes for table `mw_campaign_open_action_list_field`
--
ALTER TABLE `mw_campaign_open_action_list_field`
 ADD PRIMARY KEY (`action_id`), ADD KEY `fk_campaign_open_action_list_field_list1_idx` (`list_id`), ADD KEY `fk_campaign_open_action_list_field_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_open_action_list_field_list_field1_idx` (`field_id`);

--
-- Indexes for table `mw_campaign_open_action_subscriber`
--
ALTER TABLE `mw_campaign_open_action_subscriber`
 ADD PRIMARY KEY (`action_id`), ADD KEY `fk_campaign_open_action_subscriber_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_open_action_subscriber_list1_idx` (`list_id`);

--
-- Indexes for table `mw_campaign_option`
--
ALTER TABLE `mw_campaign_option`
 ADD PRIMARY KEY (`campaign_id`), ADD KEY `fk_campaign_option_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_option_campaign2_idx` (`autoresponder_open_campaign_id`), ADD KEY `fk_campaign_option_campaign3_idx` (`regular_open_unopen_campaign_id`);

--
-- Indexes for table `mw_campaign_template`
--
ALTER TABLE `mw_campaign_template`
 ADD PRIMARY KEY (`template_id`), ADD KEY `fk_customer_email_template1_idx` (`customer_template_id`), ADD KEY `fk_campaign_template_campaign1_idx` (`campaign_id`);

--
-- Indexes for table `mw_campaign_template_url_action_list_field`
--
ALTER TABLE `mw_campaign_template_url_action_list_field`
 ADD PRIMARY KEY (`url_id`), ADD KEY `fk_campaign_template_url_action_list_field_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_template_url_action_list_field_list1_idx` (`list_id`), ADD KEY `fk_campaign_template_url_action_list_field_campaign_temp_idx` (`template_id`), ADD KEY `fk_campaign_template_url_action_list_field_list_field1_idx` (`field_id`);

--
-- Indexes for table `mw_campaign_template_url_action_subscriber`
--
ALTER TABLE `mw_campaign_template_url_action_subscriber`
 ADD PRIMARY KEY (`url_id`), ADD KEY `fk_campaign_template_url_action_subscriber_campaign_t_idx` (`template_id`), ADD KEY `fk_campaign_template_url_action_subscriber_list1_idx` (`list_id`), ADD KEY `fk_campaign_template_url_action_subscriber_campaign1_idx` (`campaign_id`);

--
-- Indexes for table `mw_campaign_temporary_source`
--
ALTER TABLE `mw_campaign_temporary_source`
 ADD PRIMARY KEY (`source_id`), ADD KEY `fk_campaign_temporary_source_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_temporary_source_list1_idx` (`list_id`), ADD KEY `fk_campaign_temporary_source_list_segment1_idx` (`segment_id`);

--
-- Indexes for table `mw_campaign_to_delivery_server`
--
ALTER TABLE `mw_campaign_to_delivery_server`
 ADD PRIMARY KEY (`campaign_id`,`server_id`), ADD KEY `fk_campaign_to_delivery_server_delivery_server1_idx` (`server_id`), ADD KEY `fk_campaign_to_delivery_server_campaign1_idx` (`campaign_id`);

--
-- Indexes for table `mw_campaign_track_open`
--
ALTER TABLE `mw_campaign_track_open`
 ADD PRIMARY KEY (`id`), ADD KEY `fk_campaign_track_open_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_track_open_list_subscriber1_idx` (`subscriber_id`), ADD KEY `fk_campaign_track_open_ip_location1_idx` (`location_id`);

--
-- Indexes for table `mw_campaign_track_unsubscribe`
--
ALTER TABLE `mw_campaign_track_unsubscribe`
 ADD PRIMARY KEY (`id`), ADD KEY `fk_campaign_track_unsubscribe_campaign1_idx` (`campaign_id`), ADD KEY `fk_campaign_track_unsubscribe_list_subscriber1_idx` (`subscriber_id`), ADD KEY `fk_campaign_track_unsubscribe_ip_location1_idx` (`location_id`), ADD KEY `date_added` (`date_added`);

--
-- Indexes for table `mw_campaign_track_url`
--
ALTER TABLE `mw_campaign_track_url`
 ADD PRIMARY KEY (`id`), ADD KEY `fk_campaign_track_url_list_subscriber1_idx` (`subscriber_id`), ADD KEY `fk_campaign_track_url_ip_location1_idx` (`location_id`), ADD KEY `fk_campaign_track_url_campaign_url1_idx` (`url_id`);

--
-- Indexes for table `mw_campaign_url`
--
ALTER TABLE `mw_campaign_url`
 ADD PRIMARY KEY (`url_id`), ADD KEY `campaign_hash` (`campaign_id`,`hash`), ADD KEY `fk_campaign_url_campaign1_idx` (`campaign_id`);

--
-- Indexes for table `mw_company_type`
--
ALTER TABLE `mw_company_type`
 ADD PRIMARY KEY (`type_id`), ADD UNIQUE KEY `name_UNIQUE` (`name`);

--
-- Indexes for table `mw_country`
--
ALTER TABLE `mw_country`
 ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `mw_currency`
--
ALTER TABLE `mw_currency`
 ADD PRIMARY KEY (`currency_id`), ADD UNIQUE KEY `code_UNIQUE` (`code`);

--
-- Indexes for table `mw_customer`
--
ALTER TABLE `mw_customer`
 ADD PRIMARY KEY (`customer_id`), ADD UNIQUE KEY `customer_uid_UNIQUE` (`customer_uid`), ADD UNIQUE KEY `email_UNIQUE` (`email`), ADD KEY `fk_customer_language1_idx` (`language_id`), ADD KEY `fk_customer_customer_group1_idx` (`group_id`), ADD KEY `oauth` (`oauth_uid`,`oauth_provider`);

--
-- Indexes for table `mw_customer_action_log`
--
ALTER TABLE `mw_customer_action_log`
 ADD PRIMARY KEY (`log_id`), ADD KEY `fk_customer_notification_log_customer1_idx` (`customer_id`), ADD KEY `customer_category_reference` (`customer_id`,`category`,`reference_id`);

--
-- Indexes for table `mw_customer_api_key`
--
ALTER TABLE `mw_customer_api_key`
 ADD PRIMARY KEY (`key_id`), ADD UNIQUE KEY `public_UNIQUE` (`public`), ADD UNIQUE KEY `private_UNIQUE` (`private`), ADD KEY `fk_customer_api_key_customer1_idx` (`customer_id`);

--
-- Indexes for table `mw_customer_auto_login_token`
--
ALTER TABLE `mw_customer_auto_login_token`
 ADD PRIMARY KEY (`token_id`), ADD KEY `fk_customer_auto_login_token_customer1_idx` (`customer_id`);

--
-- Indexes for table `mw_customer_campaign_tag`
--
ALTER TABLE `mw_customer_campaign_tag`
 ADD PRIMARY KEY (`tag_id`), ADD UNIQUE KEY `customer_campaign_tag_uid` (`tag_uid`), ADD KEY `fk_customer_campaign_tag_customer1_idx` (`customer_id`);

--
-- Indexes for table `mw_customer_company`
--
ALTER TABLE `mw_customer_company`
 ADD PRIMARY KEY (`company_id`), ADD KEY `fk_customer_company_country1_idx` (`country_id`), ADD KEY `fk_customer_company_zone1_idx` (`zone_id`), ADD KEY `fk_customer_company_customer1_idx` (`customer_id`), ADD KEY `fk_customer_company_company_type1_idx` (`type_id`);

--
-- Indexes for table `mw_customer_email_template`
--
ALTER TABLE `mw_customer_email_template`
 ADD PRIMARY KEY (`template_id`), ADD KEY `fk_customer_email_template_customer1_idx` (`customer_id`);

--
-- Indexes for table `mw_customer_group`
--
ALTER TABLE `mw_customer_group`
 ADD PRIMARY KEY (`group_id`);

--
-- Indexes for table `mw_customer_group_option`
--
ALTER TABLE `mw_customer_group_option`
 ADD PRIMARY KEY (`option_id`), ADD KEY `fk_customer_group_option_customer_group1_idx` (`group_id`), ADD KEY `group_code` (`group_id`,`code`);

--
-- Indexes for table `mw_customer_message`
--
ALTER TABLE `mw_customer_message`
 ADD PRIMARY KEY (`message_id`), ADD KEY `fk_customer_message_customer1_idx` (`customer_id`);

--
-- Indexes for table `mw_customer_password_reset`
--
ALTER TABLE `mw_customer_password_reset`
 ADD PRIMARY KEY (`request_id`), ADD KEY `fk_customer_password_reset_customer1` (`customer_id`), ADD KEY `key_status` (`reset_key`,`status`);

--
-- Indexes for table `mw_customer_quota_mark`
--
ALTER TABLE `mw_customer_quota_mark`
 ADD PRIMARY KEY (`mark_id`), ADD KEY `fk_customer_quota_mark_customer1_idx` (`customer_id`);

--
-- Indexes for table `mw_delivery_server`
--
ALTER TABLE `mw_delivery_server`
 ADD PRIMARY KEY (`server_id`), ADD KEY `fk_delivery_server_bounce_server1_idx` (`bounce_server_id`), ADD KEY `idx_gen0` (`status`,`hourly_quota`,`probability`), ADD KEY `fk_delivery_server_customer1_idx` (`customer_id`), ADD KEY `fk_delivery_server_tracking_domain1_idx` (`tracking_domain_id`);

--
-- Indexes for table `mw_delivery_server_domain_policy`
--
ALTER TABLE `mw_delivery_server_domain_policy`
 ADD PRIMARY KEY (`domain_id`), ADD KEY `fk_delivery_server_domain_policy_delivery_server1_idx` (`server_id`), ADD KEY `server_domain_policy` (`server_id`,`domain`,`policy`);

--
-- Indexes for table `mw_delivery_server_to_customer_group`
--
ALTER TABLE `mw_delivery_server_to_customer_group`
 ADD PRIMARY KEY (`server_id`,`group_id`), ADD KEY `fk_delivery_server_to_customer_group_customer_group1_idx` (`group_id`), ADD KEY `fk_delivery_server_to_customer_group_delivery_server1_idx` (`server_id`);

--
-- Indexes for table `mw_delivery_server_usage_log`
--
ALTER TABLE `mw_delivery_server_usage_log`
 ADD PRIMARY KEY (`log_id`), ADD KEY `fk_delivery_server_usage_log_delivery_server1_idx` (`server_id`), ADD KEY `fk_delivery_server_usage_log_customer1_idx` (`customer_id`), ADD KEY `server_date` (`server_id`,`date_added`), ADD KEY `customer_countable_date` (`customer_id`,`customer_countable`,`date_added`);

--
-- Indexes for table `mw_email_blacklist`
--
ALTER TABLE `mw_email_blacklist`
 ADD PRIMARY KEY (`email_id`), ADD UNIQUE KEY `email` (`email`), ADD KEY `fk_email_blacklist_list_subscriber1_idx` (`subscriber_id`);

--
-- Indexes for table `mw_feedback_loop_server`
--
ALTER TABLE `mw_feedback_loop_server`
 ADD PRIMARY KEY (`server_id`), ADD KEY `fk_feedback_loop_server_customer1_idx` (`customer_id`);

--
-- Indexes for table `mw_guest_fail_attempt`
--
ALTER TABLE `mw_guest_fail_attempt`
 ADD PRIMARY KEY (`attempt_id`), ADD KEY `ip_hash_date` (`ip_address_hash`,`date_added`);

--
-- Indexes for table `mw_ip_location`
--
ALTER TABLE `mw_ip_location`
 ADD PRIMARY KEY (`location_id`), ADD UNIQUE KEY `ip_address_UNIQUE` (`ip_address`);

--
-- Indexes for table `mw_language`
--
ALTER TABLE `mw_language`
 ADD PRIMARY KEY (`language_id`), ADD KEY `is_default` (`is_default`);

--
-- Indexes for table `mw_list`
--
ALTER TABLE `mw_list`
 ADD PRIMARY KEY (`list_id`), ADD UNIQUE KEY `unique_id_UNIQUE` (`list_uid`), ADD KEY `fk_list_customer1_idx` (`customer_id`), ADD KEY `status_visibility` (`status`,`visibility`);

--
-- Indexes for table `mw_list_company`
--
ALTER TABLE `mw_list_company`
 ADD PRIMARY KEY (`list_id`), ADD KEY `fk_customer_company_country1_idx` (`country_id`), ADD KEY `fk_customer_company_zone1_idx` (`zone_id`), ADD KEY `fk_list_company_company_type1_idx` (`type_id`);

--
-- Indexes for table `mw_list_customer_notification`
--
ALTER TABLE `mw_list_customer_notification`
 ADD PRIMARY KEY (`list_id`);

--
-- Indexes for table `mw_list_default`
--
ALTER TABLE `mw_list_default`
 ADD PRIMARY KEY (`list_id`);

--
-- Indexes for table `mw_list_field`
--
ALTER TABLE `mw_list_field`
 ADD PRIMARY KEY (`field_id`), ADD KEY `fk_list_field_list1_idx` (`list_id`), ADD KEY `fk_list_field_list_field_type1_idx` (`type_id`), ADD KEY `list_tag` (`list_id`,`tag`);

--
-- Indexes for table `mw_list_field_option`
--
ALTER TABLE `mw_list_field_option`
 ADD PRIMARY KEY (`option_id`), ADD KEY `fk_list_field_option_list_field1_idx` (`field_id`);

--
-- Indexes for table `mw_list_field_type`
--
ALTER TABLE `mw_list_field_type`
 ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `mw_list_field_value`
--
ALTER TABLE `mw_list_field_value`
 ADD PRIMARY KEY (`value_id`), ADD KEY `fk_list_field_value_list_field1_idx` (`field_id`), ADD KEY `fk_list_field_value_list_subscriber1_idx` (`subscriber_id`), ADD KEY `field_subscriber` (`field_id`,`subscriber_id`), ADD KEY `field_id_value` (`field_id`,`value`);

--
-- Indexes for table `mw_list_page`
--
ALTER TABLE `mw_list_page`
 ADD PRIMARY KEY (`list_id`,`type_id`), ADD KEY `fk_list_page_list_page_type1_idx` (`type_id`);

--
-- Indexes for table `mw_list_page_type`
--
ALTER TABLE `mw_list_page_type`
 ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `mw_list_segment`
--
ALTER TABLE `mw_list_segment`
 ADD PRIMARY KEY (`segment_id`), ADD UNIQUE KEY `segment_uid` (`segment_uid`), ADD KEY `fk_list_segment_list1_idx` (`list_id`);

--
-- Indexes for table `mw_list_segment_condition`
--
ALTER TABLE `mw_list_segment_condition`
 ADD PRIMARY KEY (`condition_id`), ADD KEY `fk_list_segment_condition_list_segment_operator1_idx` (`operator_id`), ADD KEY `fk_list_segment_condition_list_segment1_idx` (`segment_id`), ADD KEY `fk_list_segment_condition_list_field1_idx` (`field_id`);

--
-- Indexes for table `mw_list_segment_operator`
--
ALTER TABLE `mw_list_segment_operator`
 ADD PRIMARY KEY (`operator_id`);

--
-- Indexes for table `mw_list_subscriber`
--
ALTER TABLE `mw_list_subscriber`
 ADD PRIMARY KEY (`subscriber_id`), ADD UNIQUE KEY `unique_id_UNIQUE` (`subscriber_uid`), ADD KEY `fk_list_subscriber_list1_idx` (`list_id`), ADD KEY `list_email` (`list_id`,`email`), ADD KEY `status_last_updated` (`status`,`last_updated`), ADD KEY `list_id_status` (`list_id`,`status`), ADD KEY `email` (`email`);

--
-- Indexes for table `mw_list_subscriber_action`
--
ALTER TABLE `mw_list_subscriber_action`
 ADD PRIMARY KEY (`action_id`), ADD KEY `fk_list_subscriber_action_list1_idx` (`source_list_id`), ADD KEY `fk_list_subscriber_action_list2_idx` (`target_list_id`);

--
-- Indexes for table `mw_option`
--
ALTER TABLE `mw_option`
 ADD PRIMARY KEY (`category`,`key`);

--
-- Indexes for table `mw_price_plan`
--
ALTER TABLE `mw_price_plan`
 ADD PRIMARY KEY (`plan_id`), ADD UNIQUE KEY `plan_uid_UNIQUE` (`plan_uid`), ADD KEY `fk_price_plan_customer_group1_idx` (`group_id`);

--
-- Indexes for table `mw_price_plan_order`
--
ALTER TABLE `mw_price_plan_order`
 ADD PRIMARY KEY (`order_id`), ADD UNIQUE KEY `order_uid_UNIQUE` (`order_uid`), ADD KEY `fk_price_plan_order_price_plan1_idx` (`plan_id`), ADD KEY `fk_price_plan_order_customer1_idx` (`customer_id`), ADD KEY `fk_price_plan_order_price_plan_promo_code1_idx` (`promo_code_id`), ADD KEY `fk_price_plan_order_currency1_idx` (`currency_id`), ADD KEY `fk_price_plan_order_price_plan_tax1_idx` (`tax_id`);

--
-- Indexes for table `mw_price_plan_order_note`
--
ALTER TABLE `mw_price_plan_order_note`
 ADD PRIMARY KEY (`note_id`), ADD KEY `fk_price_plan_order_note_price_plan_order1_idx` (`order_id`), ADD KEY `fk_price_plan_order_note_customer1_idx` (`customer_id`), ADD KEY `fk_price_plan_order_note_user1_idx` (`user_id`);

--
-- Indexes for table `mw_price_plan_order_transaction`
--
ALTER TABLE `mw_price_plan_order_transaction`
 ADD PRIMARY KEY (`transaction_id`), ADD UNIQUE KEY `transaction_uid_UNIQUE` (`transaction_uid`), ADD KEY `fk_price_plan_order_transaction_price_plan_order1_idx` (`order_id`);

--
-- Indexes for table `mw_price_plan_promo_code`
--
ALTER TABLE `mw_price_plan_promo_code`
 ADD PRIMARY KEY (`promo_code_id`);

--
-- Indexes for table `mw_sending_domain`
--
ALTER TABLE `mw_sending_domain`
 ADD PRIMARY KEY (`domain_id`), ADD KEY `fk_sending_domain_customer1_idx` (`customer_id`), ADD KEY `name_verified_customer` (`name`,`verified`,`customer_id`);

--
-- Indexes for table `mw_session`
--
ALTER TABLE `mw_session`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mw_tag_registry`
--
ALTER TABLE `mw_tag_registry`
 ADD PRIMARY KEY (`tag_id`), ADD UNIQUE KEY `tag_UNIQUE` (`tag`);

--
-- Indexes for table `mw_tax`
--
ALTER TABLE `mw_tax`
 ADD PRIMARY KEY (`tax_id`), ADD KEY `fk_tax_zone1_idx` (`zone_id`), ADD KEY `fk_tax_country1_idx` (`country_id`);

--
-- Indexes for table `mw_tracking_domain`
--
ALTER TABLE `mw_tracking_domain`
 ADD PRIMARY KEY (`domain_id`), ADD KEY `fk_tracking_domain_customer1_idx` (`customer_id`);

--
-- Indexes for table `mw_transactional_email`
--
ALTER TABLE `mw_transactional_email`
 ADD PRIMARY KEY (`email_id`), ADD UNIQUE KEY `email_uid_UNIQUE` (`email_uid`), ADD KEY `fk_transactional_email_customer1_idx` (`customer_id`), ADD KEY `status_send_at_retries_max_retries` (`status`,`send_at`,`retries`,`max_retries`);

--
-- Indexes for table `mw_transactional_email_log`
--
ALTER TABLE `mw_transactional_email_log`
 ADD PRIMARY KEY (`log_id`), ADD KEY `fk_transactional_email_log_transactional_email1_idx` (`email_id`);

--
-- Indexes for table `mw_user`
--
ALTER TABLE `mw_user`
 ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `user_uid_UNIQUE` (`user_uid`), ADD UNIQUE KEY `email_UNIQUE` (`email`), ADD KEY `fk_user_language1_idx` (`language_id`), ADD KEY `fk_user_user_group1_idx` (`group_id`);

--
-- Indexes for table `mw_user_auto_login_token`
--
ALTER TABLE `mw_user_auto_login_token`
 ADD PRIMARY KEY (`token_id`), ADD KEY `fk_user_auto_login_token_user1_idx` (`user_id`);

--
-- Indexes for table `mw_user_group`
--
ALTER TABLE `mw_user_group`
 ADD PRIMARY KEY (`group_id`), ADD UNIQUE KEY `name_UNIQUE` (`name`);

--
-- Indexes for table `mw_user_group_route_access`
--
ALTER TABLE `mw_user_group_route_access`
 ADD PRIMARY KEY (`route_id`), ADD KEY `fk_user_group_route_access_user_group1_idx` (`group_id`), ADD KEY `group_route_access` (`group_id`,`route`,`access`);

--
-- Indexes for table `mw_user_password_reset`
--
ALTER TABLE `mw_user_password_reset`
 ADD PRIMARY KEY (`request_id`), ADD KEY `fk_user_password_reset_user1_idx` (`user_id`), ADD KEY `key_status` (`reset_key`,`status`);

--
-- Indexes for table `mw_zone`
--
ALTER TABLE `mw_zone`
 ADD PRIMARY KEY (`zone_id`), ADD KEY `fk_zone_country1_idx` (`country_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mw_article`
--
ALTER TABLE `mw_article`
MODIFY `article_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `mw_article_category`
--
ALTER TABLE `mw_article_category`
MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `mw_bounce_server`
--
ALTER TABLE `mw_bounce_server`
MODIFY `server_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mw_campaign`
--
ALTER TABLE `mw_campaign`
MODIFY `campaign_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_abuse_report`
--
ALTER TABLE `mw_campaign_abuse_report`
MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_attachment`
--
ALTER TABLE `mw_campaign_attachment`
MODIFY `attachment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_bounce_log`
--
ALTER TABLE `mw_campaign_bounce_log`
MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_delivery_log`
--
ALTER TABLE `mw_campaign_delivery_log`
MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_delivery_log_archive`
--
ALTER TABLE `mw_campaign_delivery_log_archive`
MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_forward_friend`
--
ALTER TABLE `mw_campaign_forward_friend`
MODIFY `forward_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_group`
--
ALTER TABLE `mw_campaign_group`
MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_open_action_list_field`
--
ALTER TABLE `mw_campaign_open_action_list_field`
MODIFY `action_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_open_action_subscriber`
--
ALTER TABLE `mw_campaign_open_action_subscriber`
MODIFY `action_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_template`
--
ALTER TABLE `mw_campaign_template`
MODIFY `template_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_template_url_action_list_field`
--
ALTER TABLE `mw_campaign_template_url_action_list_field`
MODIFY `url_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_template_url_action_subscriber`
--
ALTER TABLE `mw_campaign_template_url_action_subscriber`
MODIFY `url_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_temporary_source`
--
ALTER TABLE `mw_campaign_temporary_source`
MODIFY `source_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_track_open`
--
ALTER TABLE `mw_campaign_track_open`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_track_unsubscribe`
--
ALTER TABLE `mw_campaign_track_unsubscribe`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_track_url`
--
ALTER TABLE `mw_campaign_track_url`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_campaign_url`
--
ALTER TABLE `mw_campaign_url`
MODIFY `url_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_company_type`
--
ALTER TABLE `mw_company_type`
MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=46;
--
-- AUTO_INCREMENT for table `mw_country`
--
ALTER TABLE `mw_country`
MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=240;
--
-- AUTO_INCREMENT for table `mw_currency`
--
ALTER TABLE `mw_currency`
MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mw_customer`
--
ALTER TABLE `mw_customer`
MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mw_customer_action_log`
--
ALTER TABLE `mw_customer_action_log`
MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_customer_api_key`
--
ALTER TABLE `mw_customer_api_key`
MODIFY `key_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_customer_auto_login_token`
--
ALTER TABLE `mw_customer_auto_login_token`
MODIFY `token_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mw_customer_campaign_tag`
--
ALTER TABLE `mw_customer_campaign_tag`
MODIFY `tag_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_customer_company`
--
ALTER TABLE `mw_customer_company`
MODIFY `company_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_customer_email_template`
--
ALTER TABLE `mw_customer_email_template`
MODIFY `template_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_customer_group`
--
ALTER TABLE `mw_customer_group`
MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_customer_group_option`
--
ALTER TABLE `mw_customer_group_option`
MODIFY `option_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_customer_message`
--
ALTER TABLE `mw_customer_message`
MODIFY `message_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_customer_password_reset`
--
ALTER TABLE `mw_customer_password_reset`
MODIFY `request_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_customer_quota_mark`
--
ALTER TABLE `mw_customer_quota_mark`
MODIFY `mark_id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mw_delivery_server`
--
ALTER TABLE `mw_delivery_server`
MODIFY `server_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mw_delivery_server_domain_policy`
--
ALTER TABLE `mw_delivery_server_domain_policy`
MODIFY `domain_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_delivery_server_usage_log`
--
ALTER TABLE `mw_delivery_server_usage_log`
MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_email_blacklist`
--
ALTER TABLE `mw_email_blacklist`
MODIFY `email_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_feedback_loop_server`
--
ALTER TABLE `mw_feedback_loop_server`
MODIFY `server_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `mw_guest_fail_attempt`
--
ALTER TABLE `mw_guest_fail_attempt`
MODIFY `attempt_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_ip_location`
--
ALTER TABLE `mw_ip_location`
MODIFY `location_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_language`
--
ALTER TABLE `mw_language`
MODIFY `language_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_list`
--
ALTER TABLE `mw_list`
MODIFY `list_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_list_field`
--
ALTER TABLE `mw_list_field`
MODIFY `field_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_list_field_option`
--
ALTER TABLE `mw_list_field_option`
MODIFY `option_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_list_field_type`
--
ALTER TABLE `mw_list_field_type`
MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `mw_list_field_value`
--
ALTER TABLE `mw_list_field_value`
MODIFY `value_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_list_page_type`
--
ALTER TABLE `mw_list_page_type`
MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `mw_list_segment`
--
ALTER TABLE `mw_list_segment`
MODIFY `segment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_list_segment_condition`
--
ALTER TABLE `mw_list_segment_condition`
MODIFY `condition_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_list_segment_operator`
--
ALTER TABLE `mw_list_segment_operator`
MODIFY `operator_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `mw_list_subscriber`
--
ALTER TABLE `mw_list_subscriber`
MODIFY `subscriber_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_list_subscriber_action`
--
ALTER TABLE `mw_list_subscriber_action`
MODIFY `action_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_price_plan`
--
ALTER TABLE `mw_price_plan`
MODIFY `plan_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_price_plan_order`
--
ALTER TABLE `mw_price_plan_order`
MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_price_plan_order_note`
--
ALTER TABLE `mw_price_plan_order_note`
MODIFY `note_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_price_plan_order_transaction`
--
ALTER TABLE `mw_price_plan_order_transaction`
MODIFY `transaction_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_price_plan_promo_code`
--
ALTER TABLE `mw_price_plan_promo_code`
MODIFY `promo_code_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_sending_domain`
--
ALTER TABLE `mw_sending_domain`
MODIFY `domain_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_tag_registry`
--
ALTER TABLE `mw_tag_registry`
MODIFY `tag_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=106;
--
-- AUTO_INCREMENT for table `mw_tax`
--
ALTER TABLE `mw_tax`
MODIFY `tax_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_tracking_domain`
--
ALTER TABLE `mw_tracking_domain`
MODIFY `domain_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_transactional_email`
--
ALTER TABLE `mw_transactional_email`
MODIFY `email_id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mw_transactional_email_log`
--
ALTER TABLE `mw_transactional_email_log`
MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mw_user`
--
ALTER TABLE `mw_user`
MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `mw_user_auto_login_token`
--
ALTER TABLE `mw_user_auto_login_token`
MODIFY `token_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `mw_user_group`
--
ALTER TABLE `mw_user_group`
MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_user_group_route_access`
--
ALTER TABLE `mw_user_group_route_access`
MODIFY `route_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mw_user_password_reset`
--
ALTER TABLE `mw_user_password_reset`
MODIFY `request_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mw_zone`
--
ALTER TABLE `mw_zone`
MODIFY `zone_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3970;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `mw_article_category`
--
ALTER TABLE `mw_article_category`
ADD CONSTRAINT `fk_article_category_article_category1` FOREIGN KEY (`parent_id`) REFERENCES `mw_article_category` (`category_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_article_to_category`
--
ALTER TABLE `mw_article_to_category`
ADD CONSTRAINT `fk_article_to_category_article1` FOREIGN KEY (`article_id`) REFERENCES `mw_article` (`article_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_article_to_category_article_category1` FOREIGN KEY (`category_id`) REFERENCES `mw_article_category` (`category_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_bounce_server`
--
ALTER TABLE `mw_bounce_server`
ADD CONSTRAINT `fk_bounce_server_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign`
--
ALTER TABLE `mw_campaign`
ADD CONSTRAINT `fk_campaign_campaign_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_campaign_group` (`group_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_list_segment1` FOREIGN KEY (`segment_id`) REFERENCES `mw_list_segment` (`segment_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_abuse_report`
--
ALTER TABLE `mw_campaign_abuse_report`
ADD CONSTRAINT `fk_campaign_abuse_report_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_abuse_report_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_abuse_report_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_abuse_report_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_attachment`
--
ALTER TABLE `mw_campaign_attachment`
ADD CONSTRAINT `fk_campaign_attachment_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_bounce_log`
--
ALTER TABLE `mw_campaign_bounce_log`
ADD CONSTRAINT `fk_campaign_bounce_log_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_bounce_log_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_delivery_log`
--
ALTER TABLE `mw_campaign_delivery_log`
ADD CONSTRAINT `fk_campaign_delivery_log_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_delivery_log_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_delivery_log_archive`
--
ALTER TABLE `mw_campaign_delivery_log_archive`
ADD CONSTRAINT `fk_campaign_delivery_log_archive_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_delivery_log_archive_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_forward_friend`
--
ALTER TABLE `mw_campaign_forward_friend`
ADD CONSTRAINT `fk_campaign_forward_friend_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_forward_friend_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_group`
--
ALTER TABLE `mw_campaign_group`
ADD CONSTRAINT `fk_campaign_group_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_open_action_list_field`
--
ALTER TABLE `mw_campaign_open_action_list_field`
ADD CONSTRAINT `fk_campaign_open_action_list_field_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_open_action_list_field_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_open_action_list_field_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_open_action_subscriber`
--
ALTER TABLE `mw_campaign_open_action_subscriber`
ADD CONSTRAINT `fk_campaign_open_action_subscriber_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_open_action_subscriber_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_option`
--
ALTER TABLE `mw_campaign_option`
ADD CONSTRAINT `fk_campaign_option_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_option_campaign2` FOREIGN KEY (`autoresponder_open_campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_option_campaign3` FOREIGN KEY (`regular_open_unopen_campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_template`
--
ALTER TABLE `mw_campaign_template`
ADD CONSTRAINT `fk_campaign_template_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_customer_email_template1` FOREIGN KEY (`customer_template_id`) REFERENCES `mw_customer_email_template` (`template_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_template_url_action_list_field`
--
ALTER TABLE `mw_campaign_template_url_action_list_field`
ADD CONSTRAINT `fk_campaign_template_url_action_list_field_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_template_url_action_list_field_campaign_templa1` FOREIGN KEY (`template_id`) REFERENCES `mw_campaign_template` (`template_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_template_url_action_list_field_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_template_url_action_list_field_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_template_url_action_subscriber`
--
ALTER TABLE `mw_campaign_template_url_action_subscriber`
ADD CONSTRAINT `fk_campaign_template_url_action_subscriber_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_template_url_action_subscriber_campaign_tem1` FOREIGN KEY (`template_id`) REFERENCES `mw_campaign_template` (`template_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_template_url_action_subscriber_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_temporary_source`
--
ALTER TABLE `mw_campaign_temporary_source`
ADD CONSTRAINT `fk_campaign_temporary_source_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_temporary_source_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_temporary_source_list_segment1` FOREIGN KEY (`segment_id`) REFERENCES `mw_list_segment` (`segment_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_to_delivery_server`
--
ALTER TABLE `mw_campaign_to_delivery_server`
ADD CONSTRAINT `fk_campaign_to_delivery_server_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_to_delivery_server_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_track_open`
--
ALTER TABLE `mw_campaign_track_open`
ADD CONSTRAINT `fk_campaign_track_open_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_track_open_ip_location1` FOREIGN KEY (`location_id`) REFERENCES `mw_ip_location` (`location_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_track_open_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_track_unsubscribe`
--
ALTER TABLE `mw_campaign_track_unsubscribe`
ADD CONSTRAINT `fk_campaign_track_unsubscribe_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_track_unsubscribe_ip_location1` FOREIGN KEY (`location_id`) REFERENCES `mw_ip_location` (`location_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_track_unsubscribe_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_track_url`
--
ALTER TABLE `mw_campaign_track_url`
ADD CONSTRAINT `fk_campaign_track_url_campaign_url1` FOREIGN KEY (`url_id`) REFERENCES `mw_campaign_url` (`url_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_track_url_ip_location1` FOREIGN KEY (`location_id`) REFERENCES `mw_ip_location` (`location_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_campaign_track_url_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_campaign_url`
--
ALTER TABLE `mw_campaign_url`
ADD CONSTRAINT `fk_campaign_url_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer`
--
ALTER TABLE `mw_customer`
ADD CONSTRAINT `fk_customer_customer_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_customer_group` (`group_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_customer_language1` FOREIGN KEY (`language_id`) REFERENCES `mw_language` (`language_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_action_log`
--
ALTER TABLE `mw_customer_action_log`
ADD CONSTRAINT `fk_customer_notification_log_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_api_key`
--
ALTER TABLE `mw_customer_api_key`
ADD CONSTRAINT `fk_customer_api_key_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_auto_login_token`
--
ALTER TABLE `mw_customer_auto_login_token`
ADD CONSTRAINT `fk_customer_auto_login_token_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_campaign_tag`
--
ALTER TABLE `mw_customer_campaign_tag`
ADD CONSTRAINT `fk_customer_campaign_tag_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_company`
--
ALTER TABLE `mw_customer_company`
ADD CONSTRAINT `fk_customer_company_company_type1` FOREIGN KEY (`type_id`) REFERENCES `mw_company_type` (`type_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_customer_company_country10` FOREIGN KEY (`country_id`) REFERENCES `mw_country` (`country_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_customer_company_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_customer_company_zone10` FOREIGN KEY (`zone_id`) REFERENCES `mw_zone` (`zone_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_email_template`
--
ALTER TABLE `mw_customer_email_template`
ADD CONSTRAINT `fk_customer_email_template_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_group_option`
--
ALTER TABLE `mw_customer_group_option`
ADD CONSTRAINT `fk_customer_group_option_customer_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_customer_group` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_message`
--
ALTER TABLE `mw_customer_message`
ADD CONSTRAINT `fk_customer_message_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_password_reset`
--
ALTER TABLE `mw_customer_password_reset`
ADD CONSTRAINT `fk_customer_password_reset_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_customer_quota_mark`
--
ALTER TABLE `mw_customer_quota_mark`
ADD CONSTRAINT `fk_customer_quota_mark_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_delivery_server`
--
ALTER TABLE `mw_delivery_server`
ADD CONSTRAINT `fk_delivery_server1` FOREIGN KEY (`bounce_server_id`) REFERENCES `mw_bounce_server` (`server_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_delivery_server_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_delivery_server_tracking_domain1` FOREIGN KEY (`tracking_domain_id`) REFERENCES `mw_tracking_domain` (`domain_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_delivery_server_domain_policy`
--
ALTER TABLE `mw_delivery_server_domain_policy`
ADD CONSTRAINT `fk_delivery_server_domain_policy_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_delivery_server_to_customer_group`
--
ALTER TABLE `mw_delivery_server_to_customer_group`
ADD CONSTRAINT `fk_delivery_server_to_customer_group_customer_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_customer_group` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_delivery_server_to_customer_group_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_delivery_server_usage_log`
--
ALTER TABLE `mw_delivery_server_usage_log`
ADD CONSTRAINT `fk_delivery_server_usage_log_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_delivery_server_usage_log_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_email_blacklist`
--
ALTER TABLE `mw_email_blacklist`
ADD CONSTRAINT `fk_email_blacklist1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_feedback_loop_server`
--
ALTER TABLE `mw_feedback_loop_server`
ADD CONSTRAINT `fk_feedback_loop_server_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list`
--
ALTER TABLE `mw_list`
ADD CONSTRAINT `fk_list_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_company`
--
ALTER TABLE `mw_list_company`
ADD CONSTRAINT `fk_customer_company_country100` FOREIGN KEY (`country_id`) REFERENCES `mw_country` (`country_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_customer_company_zone100` FOREIGN KEY (`zone_id`) REFERENCES `mw_zone` (`zone_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_list_company_company_type1` FOREIGN KEY (`type_id`) REFERENCES `mw_company_type` (`type_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_list_company_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_customer_notification`
--
ALTER TABLE `mw_list_customer_notification`
ADD CONSTRAINT `fk_list_notification_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_default`
--
ALTER TABLE `mw_list_default`
ADD CONSTRAINT `fk_list_default_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_field`
--
ALTER TABLE `mw_list_field`
ADD CONSTRAINT `fk_list_field_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_list_field_list_field_type1` FOREIGN KEY (`type_id`) REFERENCES `mw_list_field_type` (`type_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_field_option`
--
ALTER TABLE `mw_list_field_option`
ADD CONSTRAINT `fk_list_field_option_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_field_value`
--
ALTER TABLE `mw_list_field_value`
ADD CONSTRAINT `fk_list_field_value_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_list_field_value_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_page`
--
ALTER TABLE `mw_list_page`
ADD CONSTRAINT `fk_list_page_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_list_page_list_page_type1` FOREIGN KEY (`type_id`) REFERENCES `mw_list_page_type` (`type_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_segment`
--
ALTER TABLE `mw_list_segment`
ADD CONSTRAINT `fk_list_segment_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_segment_condition`
--
ALTER TABLE `mw_list_segment_condition`
ADD CONSTRAINT `fk_list_segment_condition_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_list_segment_condition_list_segment1` FOREIGN KEY (`segment_id`) REFERENCES `mw_list_segment` (`segment_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_list_segment_condition_list_segment_operator1` FOREIGN KEY (`operator_id`) REFERENCES `mw_list_segment_operator` (`operator_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_subscriber`
--
ALTER TABLE `mw_list_subscriber`
ADD CONSTRAINT `fk_subscriber_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_list_subscriber_action`
--
ALTER TABLE `mw_list_subscriber_action`
ADD CONSTRAINT `fk_list_subscriber_action_list1` FOREIGN KEY (`source_list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_list_subscriber_action_list2` FOREIGN KEY (`target_list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_price_plan`
--
ALTER TABLE `mw_price_plan`
ADD CONSTRAINT `fk_price_plan_customer_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_customer_group` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_price_plan_order`
--
ALTER TABLE `mw_price_plan_order`
ADD CONSTRAINT `fk_price_plan_order_currency1` FOREIGN KEY (`currency_id`) REFERENCES `mw_currency` (`currency_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_price_plan_order_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_price_plan_order_price_plan1` FOREIGN KEY (`plan_id`) REFERENCES `mw_price_plan` (`plan_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_price_plan_order_price_plan_promo_code1` FOREIGN KEY (`promo_code_id`) REFERENCES `mw_price_plan_promo_code` (`promo_code_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_price_plan_order_tax1` FOREIGN KEY (`tax_id`) REFERENCES `mw_tax` (`tax_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_price_plan_order_note`
--
ALTER TABLE `mw_price_plan_order_note`
ADD CONSTRAINT `fk_price_plan_order_note_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_price_plan_order_note_price_plan_order1` FOREIGN KEY (`order_id`) REFERENCES `mw_price_plan_order` (`order_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_price_plan_order_note_user1` FOREIGN KEY (`user_id`) REFERENCES `mw_user` (`user_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_price_plan_order_transaction`
--
ALTER TABLE `mw_price_plan_order_transaction`
ADD CONSTRAINT `fk_price_plan_order_transaction_price_plan_order1` FOREIGN KEY (`order_id`) REFERENCES `mw_price_plan_order` (`order_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_sending_domain`
--
ALTER TABLE `mw_sending_domain`
ADD CONSTRAINT `fk_sending_domain_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_tax`
--
ALTER TABLE `mw_tax`
ADD CONSTRAINT `fk_tax_country1` FOREIGN KEY (`country_id`) REFERENCES `mw_country` (`country_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_tax_zone1` FOREIGN KEY (`zone_id`) REFERENCES `mw_zone` (`zone_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_tracking_domain`
--
ALTER TABLE `mw_tracking_domain`
ADD CONSTRAINT `fk_tracking_domain_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_transactional_email`
--
ALTER TABLE `mw_transactional_email`
ADD CONSTRAINT `fk_transactional_email_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_transactional_email_log`
--
ALTER TABLE `mw_transactional_email_log`
ADD CONSTRAINT `fk_transactional_email_log_transactional_email1` FOREIGN KEY (`email_id`) REFERENCES `mw_transactional_email` (`email_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_user`
--
ALTER TABLE `mw_user`
ADD CONSTRAINT `fk_user_language1` FOREIGN KEY (`language_id`) REFERENCES `mw_language` (`language_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_user_user_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_user_group` (`group_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Constraints for table `mw_user_auto_login_token`
--
ALTER TABLE `mw_user_auto_login_token`
ADD CONSTRAINT `fk_user_auto_login_token_user1` FOREIGN KEY (`user_id`) REFERENCES `mw_user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_user_group_route_access`
--
ALTER TABLE `mw_user_group_route_access`
ADD CONSTRAINT `fk_user_group_route_access_user_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_user_group` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_user_password_reset`
--
ALTER TABLE `mw_user_password_reset`
ADD CONSTRAINT `fk_user_password_reset_user1` FOREIGN KEY (`user_id`) REFERENCES `mw_user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `mw_zone`
--
ALTER TABLE `mw_zone`
ADD CONSTRAINT `fk_zone_country1` FOREIGN KEY (`country_id`) REFERENCES `mw_country` (`country_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

