-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Host: 10.131.109.56
-- Generation Time: Dec 22, 2015 at 01:40 PM
-- Server version: 10.0.22-MariaDB-0+deb8u1
-- PHP Version: 5.6.14-0+deb8u1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

-- --------------------------------------------------------

--
-- Table structure for table `Locale`
--

CREATE TABLE IF NOT EXISTS `Locale` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `locale` varchar(5) DEFAULT NULL,
  `shortCode` varchar(2) NOT NULL,
  `default` smallint(6) NOT NULL,
  `orderNr` int(11) NOT NULL,
  `dateFormat` varchar(255) NOT NULL,
  `timeFormat` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Locale`
--

INSERT INTO `Locale` (`id`, `name`, `locale`, `shortCode`, `default`, `orderNr`, `dateFormat`, `timeFormat`) VALUES
(1, 'Português', 'pt_pt', 'pt', 0, 3, 'd/m/Y', 'H:i'),
(2, 'Español', 'es_es', 'es', 0, 2, 'd/m/Y', 'H:i'),
(3, 'Русский', 'ru_ru', 'ru', 0, 5, 'd.m.Y', 'H:i'),
(4, 'English', 'en_us', 'en', 1, 1, 'n/j/Y', 'g:i a'),
(5, 'Suomi', 'fi_fi', 'fi', 0, 6, 'j.n.Y', 'H:i'),
(6, 'Français', 'fr_fr', 'fr', 0, 4, 'd-m-Y', 'H:i');

-- --------------------------------------------------------

--
-- Table structure for table `User`
--

CREATE TABLE IF NOT EXISTS `User` (
  `id` int(11) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `instanceId` varchar(255) NOT NULL,
  `timeFormat` varchar(255) DEFAULT 'g:i a',
  `dateFormat` varchar(255) DEFAULT 'n/j/Y',
  `firstDayOfWeek` smallint(1) NOT NULL DEFAULT '0',
  `localeId` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `User`
--

INSERT INTO `User` (`id`, `created`, `instanceId`, `timeFormat`, `dateFormat`, `firstDayOfWeek`, `localeId`) VALUES
(122, '2014-10-19 14:50:45', '139e8d93-03b7-a089-276c-5a5eaacea691', 'H:i', 'd-m-Y', 0, 6),
(123, '2014-10-21 18:36:27', '139f3da5-2d39-9e26-9b9f-e7fb887811a4', 'H:i', 'd-m-Y', 0, 6),
(124, '2014-10-22 09:45:07', '139f6f3b-415f-5d69-20b1-1696fc1cca52', 'H:i', 'd/m/Y', 0, 2),
(125, '2014-10-31 11:30:47', '136eed85-07e3-e1dd-3783-171306d16252', 'g:i a', 'n/j/Y', 0, 4),
(126, '2014-11-23 10:22:58', '13a943de-1f2a-a809-0e01-6aa4d3f186e4', 'g:i a', 'n/j/Y', 0, 4),
(127, '2014-11-30 11:33:39', '13ab6ab2-d7e7-2777-56d1-6a3b9a83a4ce', 'H:i', 'd.m.Y', 0, 3),
(128, '2014-12-06 14:47:48', '13ad4fae-de21-7d56-8b27-6bf989a4c706', 'H:i', 'd.n.Y', 0, 3),
(129, '2014-12-07 10:56:43', '13ad91d5-902c-6e7b-c9f8-64f9775909c5', 'H:i', 'd/m/Y', 0, 2),
(130, '2014-12-07 11:05:03', '13ad9249-e5ed-e257-c9f8-64f9775909c5', 'H:i', 'j.n.Y', 0, 5),
(131, '2014-12-08 18:41:05', '13adf9c1-1b39-5f65-b328-87a7c30ff5dc', 'H:i', 'd.m.Y', 0, 3),
(133, '2014-12-09 16:33:49', '13ae3b73-87aa-7656-b328-87a7c30ff5dc', 'H:i', 'd.m.Y', 0, 3),
(134, '2014-12-10 19:02:19', '13ae9812-f5c8-0c09-c72d-7062d59d1cf0', 'H:i', 'd.m.Y', 0, 3),
(135, '2014-12-10 19:07:52', '13ae9860-8394-1a9c-b328-87a7c30ff5dc', 'g:i a', 'n/j/Y', 0, 4),
(136, '2014-12-10 19:59:36', '13ae9b33-2a79-e401-1140-fc4e29c0137b', 'H:i', 'j.n.Y', 0, 5),
(137, '2014-12-12 17:52:27', '13af316c-1a8c-8a74-c72d-7062d59d1cf0', 'g:i a', 'n/j/Y', 0, 4),
(141, '2015-03-13 16:47:50', '13af8088-87d3-8bd5-dea1-ca8cb05a513d', 'g:i a', 'n/j/Y', 0, 4),
(143, '2015-01-18 18:32:05', '1395ed12-3074-6965-edaa-6952d8493d76', 'g:i a', 'n/j/Y', 0, 4),
(144, '2015-01-18 19:17:15', '13ba9185-8b2e-9b43-a3fe-8f75285e56e6', 'g:i a', 'n/j/Y', 0, 4),
(177, '2015-11-17 14:57:50', '13e9aae2-c958-386a-1196-21916a2e48f8', 'H:i', 'j.n.Y', 0, 5);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `User`
--
ALTER TABLE `User`
  ADD PRIMARY KEY (`id`),
  ADD KEY `localeId` (`localeId`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `Locale`
--
ALTER TABLE `Locale`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `User`
--
ALTER TABLE `User`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=178;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `User`
--
ALTER TABLE `User`
  ADD CONSTRAINT `userLocaleFK` FOREIGN KEY (`localeId`) REFERENCES `Locale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;