mysql_250.sql

-- phpMyAdmin SQL Dump
-- version 2.11.9.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 05. Juni 2010 um 22:53
-- Server Version: 5.1.36
-- PHP-Version: 5.3.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datenbank: `opentimetool`
--

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

--
-- Tabellenstruktur für Tabelle `errorLog`
--

CREATE TABLE IF NOT EXISTS `errorLog` (
  `id` int(11) NOT NULL DEFAULT '0',
  `text` varchar(255) NOT NULL DEFAULT '',
  `log` tinyint(4) NOT NULL DEFAULT '0',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  `query` varchar(255) DEFAULT NULL,
  `session_id` varchar(32) NOT NULL DEFAULT '',
  `user_id` int(11) DEFAULT '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `errorLog`
--


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

--
-- Tabellenstruktur für Tabelle `exported`
--

CREATE TABLE IF NOT EXISTS `exported` (
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(20) NOT NULL DEFAULT '',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `filename` varchar(40) NOT NULL DEFAULT '',
  `OOoTemplate_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `exported`
--


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

--
-- Tabellenstruktur für Tabelle `exported2project`
--

CREATE TABLE IF NOT EXISTS `exported2project` (
  `id` int(11) NOT NULL DEFAULT '0',
  `projectTree_id` int(11) NOT NULL DEFAULT '0',
  `exported_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `exported2project`
--


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

--
-- Tabellenstruktur für Tabelle `exported_seq`
--

CREATE TABLE IF NOT EXISTS `exported_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Daten für Tabelle `exported_seq`
--

INSERT INTO `exported_seq` (`id`) VALUES
(6);

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

--
-- Tabellenstruktur für Tabelle `kmLog`
--

CREATE TABLE IF NOT EXISTS `kmLog` (
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `numKm` float(24,1) NOT NULL DEFAULT '0.0',
  `comment` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `kmLog`
--


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

--
-- Tabellenstruktur für Tabelle `kmLog_seq`
--

CREATE TABLE IF NOT EXISTS `kmLog_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Daten für Tabelle `kmLog_seq`
--

INSERT INTO `kmLog_seq` (`id`) VALUES
(13);

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

--
-- Tabellenstruktur für Tabelle `OOoTemplate`
--

CREATE TABLE IF NOT EXISTS `OOoTemplate` (
  `id` int(11) NOT NULL DEFAULT '0',
  `data` longblob NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `type` char(3) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `OOoTemplate`
--

INSERT INTO `OOoTemplate` (`id`, `data`, `name`, `timestamp`, `type`) VALUES
(1, 0x504b0304140000080000978dbf3c5ec6320c2700000027000000080000006d696d65747970656170706c69636174696f6e2f766e642e6f617369732e6f70656e646f63756d656e742e74657874504b0304140000080000978dbf3c0000000000000000000000001a000000436f6e66696775726174696f6e73322f7374617475736261722f504b0304140000080800978dbf3c00000000020000000000000027000000436f6e66696775726174696f6e73322f616363656c657261746f722f63757272656e742e786d6c0300504b0304140000080000978dbf3c00000000000000000000000018000000436f6e66696775726174696f6e73322f666c6f617465722f504b0304140000080000978dbf3c0000000000000000000000001a000000436f6e66696775726174696f6e73322f706f7075706d656e752f504b0304140000080000978dbf3c0000000000000000000000001c000000436f6e66696775726174696f6e73322f70726f67726573736261722f504b0304140000080000978dbf3c00000000000000000000000018000000436f6e66696775726174696f6e73322f6d656e756261722f504b0304140000080000978dbf3c00000000000000000000000018000000436f6e66696775726174696f6e73322f746f6f6c6261722f504b0304140000080000978dbf3c0000000000000000000000001f000000436f6e66696775726174696f6e73322f696d616765732f4269746d6170732f504b0304140008080800978dbf3c0000000000000000000000000b000000636f6e74656e742e786d6ced5beb6ee3b815fedfa7103c83c56e0159be6472f14cbc4832d8ddb69345d064d0a245113012657323912a49c5f104799bbe495fac87a46e96255bb1ec5cdace8f4cc4730ef99def1c1e52a4f2e9c7fb30b0ee301784d1e34ebfdbeb5898bacc237472dcf97af5937dd8f971fcbb4fccf7898b471e73e3105369bb8c4af8df026b2a46467adc89391d312488185114623192ee884598a656a3a2f6488f655a849c078dcdb572d15ae27bd9d458e92ed8a29be6236be5a2b5c7d1aca9b1d205528be63e6b6a7c2f02db67c07a1821494a28ee03426f8f3b5329a391e3cc66b3ee6cd8657ce2f48f8e8e1c2dcd00bb995e14f3406b79ae8303ac06134ebfdb7752dd104bd4149fd22d42a271788379636a90444b51157793c6197137a9a1c69d22de3837b4f26278875ef3f00ebda26d88e4b4262687ce3908f58ff32f792ef0b0e9584a77812a9793a8b19b46bb68cf18cba02a03334135dc41afb7e798e782f66ca5fa8c13897941dd5da9eea2c0cd1867611569a0d77740c3c6772a4db3c45744881a838163c499b2f06abbfeebf9974b778a43942b93f5ca36a142229a33c355106a3dfde0701c312e3362fce60513a235c8b04d6518d44f77254d5527dcf32a5501ced081a90f13cfbe2378f62e4b43828334e7330f1270f83ec29c285c285061b543011440a859342a589bcc4a2c0b2b0b38a0f18c244754a8d8c07c55a2041e382dba9a0c5b0dad719a5ea02c413445201de6f903eef95d78e88cd345c924b470b2061f1627db472eb63dec0662fcc91497acd932cfcaabe3cea544fc721ede30600d0a49aa1592605e12e69da84a213004fbde1646eaac1ee42f50f9d5922a2ac628caf22e22225d2820778813b5eab41bbedebf65df8cc89e600ac18699cb5988e8eea09d402755c84cfb1ae333167382b9f52b9e5574f11d8a98f858d0310d2bbd0d9987396d04dafa4a096c94b0757e593b7859b1024199cd3543fff2b3754ea83b65d61732994aeb8fb5632f69b61ffc67c451c8a857316641d42697d600b882f2235428ad3f275d55fb5ed26b10f8d6d074a8fbb599bc6a6c312362f5ec5f33f6396cbf7e550535b0eb78a9506909c8a9abb6493b8a255325deb5753f5919d63f17e04ba2f68fc55292805e680c618f88b91da109b68d5d27ed52ebd9112c44984b029137cd33e2a94d587fbf7b341cb861c7f219f4c22784da01f6a148d9bd2eaccb8b12ae264b5164fa32c326db5a58dfccbb000ac8045630639a3126a6c8537b24ca28d65ddf621cd93322a736d5ef2a8a1a4d61819106f4744f2a0982bd6f1087b4c486695c2625694fb839ec1eec1de55e721cd88b0a7b47fbbddf6f82f574eb583f748f0efbabb00e8747fd8db09e6d1deba03be8adc4da1fec1d6e84f5a45f03160741192a3415814226de20f776c2594c3d8587412ebfc3fb78dff7759e46c8332ffe90fc262d9409e3b026263346cd0a984a966001f1ac773dfdafa8964c9f2cf59366c9a206c6374c4af506a0ad535f0a904908b330e7acd2cb0d32f545192d33f506093c7b8d04aee5ea35337a3268c3e8f6a6713312cb1158e06c931237dc82f7b9a7072905a924776e499426c55e5990faf45629ddff2fa6b4b2566e9bc1d337c5e0e67e9ebd293fb7b1066c7dae1dbc8ee2fd3cd36257ceb6c8e01df3ffba92addf7bb3ef03755c5477fa8cdbd917a57427e9f522945e2cbd174488a30947d1343f56e1ea3a593fd8d9813cf510f772a6f1bd2c71accf9c66d83073c302aff9d4b958da5a6f042a332a21d3609363219c1f87fe160b49fcb92d20f6d0e90ca273dcf151200a677b157ea6095488761bd797f6d54d5cbf5229703de85d9f993b7fb11b0e1abab0b75d17b69c5b1f5aa1fb0523551b9ec4af90485d29b6ca32edb196aa02a2ce8817ce7e0d562408a22be4ea023ec0f7994673d296369c3b27cdc554df50bf65d69636394d58fb8689e4280e6bf3bfd00aab01e601a1387732595bdacc90c356b0d75f0554863f15158ef0d323f835e125dfb03aab8db229f6646a16620edda52951ec341766f9a0c58d69bd5a3e81039c2dab9c537b9193086e9837cf1ed418851b781eaa617858b0f6991b8b746625c2280ae6b687054c4b5bddbd16269efe544be07fc698e6774bcb8d966ef288880234b7592c755c027c87037351a3c486a53f04014c75ae3f3ba81ee1099d5da5f760ed7a51616adbc967f369998e603d6b913129ce2b988de39358cc202d623a498ca315fa0719d66ae9f86fc94c1d590fefd58e5a4488fec459f868dd105168fb4a25091e1b8fa82fdbf4cfe4e26de9e2d034174d73e14207c93dcc2a83ee4969d02636a71bd89c956da6b098a92d3f9b894501b4947a872df96a1ffaf947382888b12de71156fb056e56cb5ac63f74c67f5205ceb9e0ec377c2bf3203965004f8474da02d2d5bfff25c9e416d26b7b78ce36c5b36f127d251267297cceae223d48d3df2c6e49e6095b4d348a613333dccccf8a6df303946d8cdce9f7ef6381b9b090b0dea3aff0eb0fa3c7068171d91de6d8b37389b352b44c624baa86cf475552d3a1e30af57e677c8a692cbf61ae4aa5a6f0efe63315a5617efbc7634924625e94a6d51e8618ff9ffcea3cb51608f4d05c24ec99d4fd8ce6d6ff78eac22bf5f84133919124cb29f6aa89d9df41752bd0a1b72c0b49a3be2e83a47920fef7e621d1bc9648dc5e538c3da1d74e5726663f3c3ebc8f4ccb15c7f8f39cdadf4de4c7099617484e4fc4a5c6bad85941ff9a7859475652568c3faefa4027dff76d638dde229b0bfe286e9e90554d97f00de15e0ccbf8bcd8bc18a41897a25b528004b0a60f987ac45fedcfd6f3fd607b1102f849ca7fcc7fdd62784eb786b55c3836c9951d83d97aa09f735ff7b4f0bf78cd7f3e6a5625de8bd3d0efade361b0617d840dea651c86d89a6081c2262f5d2bc8683a41fbbd0dd10e543517710825b9c54b59fd00d9f54fe1bb6773e0e52c9c85a54fe5bf931cff07504b07083cd607b25b08000068390000504b0304140000080800978dbf3ce6c6024ff4000000140200000c0000006d616e69666573742e726466a591414ec3301045f73d85e5aee3699c0db1927441d535821318c74923124fe471487b7b4c880a050909b1b4fdf5de9f71b13f0f3d7bb59e3a74254fc58e33eb0cd69d6b4b3e8526b9e3fb6a53f8ba518f87238b69472a9e4a7e0a615400f33c8b3913e85b48f33c879d0429939848e8e2823e278eb6bcda3056384ad553b8f4968e5d6f5754bcbca26a3424505347098ed62d4c47804dd3190ba99030d8a001eb66cbd97b23fd8c5328392d5011811c5693540734d3605db87ae45f3de34b7beb59c658f1274d0fda87e5d95bc2c91b5b72832e44e767955fd33f7ac3d7e2eb2499baff80de2c2dfbf7d2be552d60fde26af306504b0304140008080800978dbf3c0000000000000000000000000a0000007374796c65732e786d6ced5d4992e3b815ddfb140c75d8e15e501229656a706576b4dbd583a3aaed7055472d2b201292d845110c104a65d6cae12bf8105e7b631fc0a7f0d617f015fc3191e02852432acb95bda8ce243efefff8131e4010f9e2abfb4d68dd619a0424bae939fd61cfc29147fc205addf47e7afbad3ded7d75fb8b1764b90c3c3cf789b7dde088d9097b08716241e72899cbc69bde964673829220994768839339f3e624c691ee3437a9e742947c2298b5ed2e88cdde0cdfb3b69d396dae2f5ab4972c88cdde3e45bbb69d392dd8d4ecbe246d3bdf27a1bd24b64736316241418bfb30883edcf4d68cc5f3c160b7dbf577a33ea1ab81339bcd06a23555d84be9e22d0d0595ef0d7088b9b064e0f49d81a6dd6086daeac7694d95a2ed6681696bd320864a5e4dee56ad23e26e55631a6f8d68ebd810c479f78efcf6ee1df966df0d62eb1a9f4c07afa151fcf3fa55160b74d35616a7cd99caa341dc7a9892daec4f084955e51d64820a75dde1703c90bf1bd4bb46f21d0d18a606b9d748eea1d04b2d4e365546033a67001436bee361aaa9291f742de7ab01c531a12c5564d9be408175dc34bdd66c13d6a7176fd5a42beafb95a4a0ce6800a906816edf0578f745cf5255d0a8bc20513098338aa2843b19029a37297ea065d217dadb5c69c1587281bc75075023d880f84b97facb3efcd2bbd5457b49a0602f91876d1f7b6172fb42265bfad892bf7393dcf4de3044df3c6c1604460589a5a93641f85068cc98f0cc493038e3de4e64eba059c83ba8847c86492a64986d198b38601e24d41da201afc2c789af1f5f796cb2c95ee108d3002299920d8acea7dad7c0a44a33f97c4fe76fc89606985a3fe25d058b5fa19824bf3168e483c6d16e888f69d44a69eba72800dc80add76f6a8517092b34285a738fe8efbfb35e0791b726d6ab60b566d6ef6b6597288f17fe1da2684322bf42a6d1744c2ced51e06d00558cbbd2fa9362553df6025d0bc71fad9a70b5531bc94db2935d903467ff1ed9af018efcc8eb6768d7d9a582e448850675d5563d9788592beee325da860a476bce4ab71545f13af07a9a56fd6ec714ea3e6501b892a3c979b2463ed9d9c01f4a8c7d7fd31bf647dea657d5f85068843ace6c4086d84e62e441b5b5d784061f417514725277da487cc7d5f0caa43095b6e55a22ade0a9cc12c23876015bdb12e933ba3522208644130632cd239b38b98db68c70111016818f89244561bc469abfd062413102109d307038d32d1cc970d57815bce985d4668b5c1404918f397ce00b22732c37bd250a139c3a10160ee06812273c4cead54ec9b9dec6689664ee9190009efe6228feebf147428324f8089a396eccc4b31045ab2d5ac1231ff764bf6dc42878ff772f739af37e36400914e9deca168a816efb787faf9b142bdd129108975972181ee2fb1aa6696b05dbb44d30ce0c954b9436d9935ab6d71822609cf543bcc691005976887c98e96ca10dd701fcb909d211b48ca4781b796c2b19eea019a01b0c1d02627fa8e910b1fd00f22de242dcbe3bbccad2201f8c31d8334b82161163782a87348e8d24ce4cc744d5647cd69813c2d3c8a98021670a4f337ab0cef6624851bc41412420a08e2bb744146f937581e488d8173b1466d909b1191672036341280f751e47506c13ccd38347d6d1826d4a7605e1f0a410971f308e6d465698adf90e010a77e821d927da14992e53221fd10c5f95b25f3b304449020a4286ec2d081b44215b413bc8dc21cfbcecd98230c617a7fc7153da99b9348418cb06b667406f81d77b77f87e41fc07ad3bd48238440f76466199cdb5638607e91e9d5d6daf539ba5ef3aae344dbbe17e8f916f14c6638612712f980455a63c78bcfdb13b6a1e731ad502a34402a364615d1d292dabf138ab52c714db4a360795cd719790563ee6ae70aa435a5158ce59e2a029e6d5a30d4a18d4423e9baa4ea7c9066736534d62ca5f63ee225e1286bfcc46c465aa8d528e2d0e0a241d303b2521126b9a9c0b65930e860509fd835ce836bbd07d7417ee73d46139299e6e01d35389e8f94398254918a44a14487681cff77aa50b2b291416933b42fce75ec96fc22d67f0daa8d96ba3ff13af152ba9532aa58e02b6cd56cf954da750368f71c92b80f587d8ba612e0b39cb8e134ca710e29bf827431aa01f45cdde172fe7644514cbe92445d6a245a4922e98c3f2e2baf840ab489240eea34ffbe3d9345b50b18718d4f5407f18e8606f6fe7ba3f9355ddec4e7948186635b4695ce9b7f3c2b784b047f6c221661d0e9d63cc3a1cba8f6bd6b77c6dc2b3ea1bc80ff946a9aa480a32ab4873a2ec3d793eb45f69e8d1173078d5e08f80e9b5466e6f80127cbae2f0099ecafd9830584569a429e63f6f13162c1fa090472b5065076bddbcd5bad8b319722968103050c46b33b708e3a8d943f76a9e5ecadd53285ecf2025e936437d83629e918f5bf24babad6c4955b7da3a91176b26c8aa357c9dc7eb70c3b0801bf639beb0c6aaee5e747c6bbf7e4be17f3c0fbdc66227c8ac22cde315bb936fbf4cab009f5a1eb536de0f80e1ef4f981281e077daaa7f1e00a8ab76c3ea5d931cb67ccf99b6bd79b29808f1929502854a3feba7c22a817843a31e4ad67cb166e71a6bded8ecc72f234095e36afca237980596d6d5c38750c67ea14dbed9ea9f0df198deac5912a6de3c684d782a6f02c69e5edaa32e78f4eaa97bf4dd3b5bd718eed4f7eef4fd3bbc78efcede57bbd7a0b77e0d945f1e55d5ba4deacee4ba76a34c34b5af62a5130f55efafea2666b7cbee25188ccf681ffef50f0ada34ec80e5098fdc086bf1466fb9ac79a3573ad3d065ac5f4714fbf814535dfd76d0c936de55934ab86c896023068504252cdfdf5c2ea805428bf542fba02c1ef60931e3bbca1f308dc469007d62a19d333ee200d0d276b3d717c76e5ef71db96eafcc4b73495fdeaa3eddc9865ab09d5b47b536de8f424bb5f9298ff3d500de94d22a90a5ef34f976e5a05ed46fb721387aaf1c49d628a475a099e72ff3b69b35bc29aa39b56996c6caeee992a389414a34eb525c7fe06bf6485a4f1e50af329da6b24c929ce5eaab122f698b04b18fe9b497786b1a2cf961a6365596d7d8e5b266435f4dfca77e2bd0a95ed70eae6318bf7b378554187f1c1e179a8d07eacc682ccee01d062d152dad36ba296a1e92ed2cbb34b977939d9d6dee2cb984ca3b568ef4f47117b19363a3a27c40f52c4131e91814153b05358571da0d324a652e1525934b45c9f86229393a36426b5e1756edfbe977eb2ddeb9b7df0fdcfbc2beeb9695b6cbe5cae4e86209307aec04e02fe822c27086026b7657159d5580512de7e89791df468a223b5088d8012e766a71165d6c4b227e1289da72afc45ca9dcade6f77aa3067e7ec86ddac843b29c1c3072aab0dafce48d31f6ed945b523e98cb696cbe690dd19aee93ca267d9edc8e093f7b40e25203e5e71fb3e58adafbd664d9d175c921ff9ec968ad61d33a86be93262d2d0d1ec3f4e689daae063bd250ed0df487572f3f7bdb88d1902dcb961f7913c9965e8130c4773854e4f2ed017f005392916a76b25d2e0330c69796f9547e7f080b98d4c6fcbc89e29899992b5a27b2a5326e95d8b34b1d5d44eaf82252af2e22f5fa22522717913abd88d4d945a43ac3538b1d94ab9bd24530ab437be39e496570b41772cfad50f2c4af92a066ebc32c877dd541f212df68dcf4ece6612a11fc23217b81c13498efa55e8faed2830b1bfeaa0b2da097da20d2cded779b2bb7f99becd0c14a6e83952a278d4a2b91ee5672fab3e13156d26bb2137cec6c92a8ef3c61a8d83fa59d470d76765bdbf9bf7ff95b774b8ffacee4a4f1985fad9dc840e306038d3a18e89fdd0d34ee8fc7273590b1a83c9175ae2e95a657fd89f319a5e9f5e5d2f4ba3f9b3efd349d5c2e4da77df7ea89a7e9f452693aeb5fb99f519ace2e97a6ceb03f993db13c95fb670d98dd304319c83b87cc985743b7c90663f1e144fd78a4c6b9e6d6ab80c9695601934f6c1550f5c6ecec8b804987b27580914ebd0878bb2634f251e14ea683aeba393ff09f3c03ff66e03f7906fe0dc0df7809fb0cfccf08fccf9ea69f3af03f7b9a7ed2c0ffcc69fa0cfc1f2b4d9f81ffa581ffe834c07fd401f8fffbef4f00f9ab134b8f02f847cfbbfe8f02fe47cfe0bf19fc8f9ec17f03f83f739a3e83ffc74ad34f1dfc9f3d4d3f69f07fe6347d06ff8f95a6cfe0ff11c03f3fca9cf0e3b4cb60b5a5e2ba542b6db0d537e64b75b05a69e1054cdeab6a0645fd21edbc057438f1ebaeef50b8e5e05d3dd462123bfb4e5c5cc16bf689f4178536e7a76fe86d3f162c8f6f370da5e220b8b47ee953d0979a59eb910ed2c88a7036942a9d6b2fa790b78d67be6f10ae9864e6e41700a8b620f2a8f88b341cf30cb2abd505b7ec4675fe6d1dff1b199ead1ba4386185103d902dcb2d1b5fc79b2ccc0da2420d142d2a885d475f6ea51bf45d44eeac3fa91da1120106643681ea1931f5a73cf81f24a12860bde2c7b8aebe5cacfc316ee11b5d795182dbbf1a57de93e0a806a942e30de632a4ed0dba4f47c50f416b0ba50409d69724a4a93d748c8bd4f495d5aa3270fad227c4290d5af240ad22413eff185bba5d06837c4eb39ae25ea5d76716eeb736bf3fae72ac1ed4dab8b961608e543f2c10aa26b374dfade6e985547d673aab724ff3ad2485efdccd54f11f20567944e76f92cf8697d7b53ce61649e0764d82a1119cc524b86e48f4ee6950f33d7a750a54c7ff73f01f1efc958c5a44d4e8c996d5ea7872dbc7937bb6787ad22e1fd4ceb1aa41218efccc6bc0905c8814af083175ae989ba57e0a8ec465945fbed2ec16c61df123118c90d0facf9fff6aedf062811258b8306cfd91929ff107c62fd6c07409586b1bad247386161af634fc68c99f150af678450407bce1ec5493714386521787d863c212373d6f4bf9fd04bd5b47615d83fcd6ba035c6570117f07204f291fe92785a920fdd530fe3e7f7cff96ffe5b9065fb8d9d2a58e47016056b21999e8ad103183ea3f2979fb3f504b0708c4acf3e9140e000092720000504b0304140000080000978dbf3c6a1aa654f2040000f2040000080000006d6574612e786d6c3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d38223f3e0a3c6f66666963653a646f63756d656e742d6d65746120786d6c6e733a6f66666963653d2275726e3a6f617369733a6e616d65733a74633a6f70656e646f63756d656e743a786d6c6e733a6f66666963653a312e302220786d6c6e733a786c696e6b3d22687474703a2f2f7777772e77332e6f72672f313939392f786c696e6b2220786d6c6e733a64633d22687474703a2f2f7075726c2e6f72672f64632f656c656d656e74732f312e312f2220786d6c6e733a6d6574613d2275726e3a6f617369733a6e616d65733a74633a6f70656e646f63756d656e743a786d6c6e733a6d6574613a312e302220786d6c6e733a6f6f6f3d22687474703a2f2f6f70656e6f66666963652e6f72672f323030342f6f66666963652220786d6c6e733a677264646c3d22687474703a2f2f7777772e77332e6f72672f323030332f672f646174612d766965772322206f66666963653a76657273696f6e3d22312e322220677264646c3a7472616e73666f726d6174696f6e3d22687474703a2f2f646f63732e6f617369732d6f70656e2e6f72672f6f66666963652f312e322f78736c742f6f6466327264662e78736c223e3c6f66666963653a6d6574613e3c6d6574613a67656e657261746f723e4f70656e4f66666963652e6f72672f332e322457696e3332204f70656e4f66666963652e6f72675f70726f6a6563742f3332306d3132244275696c642d393438333c2f6d6574613a67656e657261746f723e3c6d6574613a696e697469616c2d63726561746f723e4769616d70616f6c6f2050616e74c3b23c2f6d6574613a696e697469616c2d63726561746f723e3c6d6574613a6372656174696f6e2d646174653e323030322d30382d32395431363a32333a33393c2f6d6574613a6372656174696f6e2d646174653e3c64633a63726561746f723e4a6f68616e6e2056616c656e74696e69747363683c2f64633a63726561746f723e3c64633a646174653e323031302d30352d33315431393a34343a34362e36353c2f64633a646174653e3c6d6574613a65646974696e672d6379636c65733e3130343c2f6d6574613a65646974696e672d6379636c65733e3c6d6574613a65646974696e672d6475726174696f6e3e505430384834304d3235533c2f6d6574613a65646974696e672d6475726174696f6e3e3c6d6574613a646f63756d656e742d737461746973746963206d6574613a7461626c652d636f756e743d223122206d6574613a696d6167652d636f756e743d223022206d6574613a6f626a6563742d636f756e743d223022206d6574613a706167652d636f756e743d223122206d6574613a7061726167726170682d636f756e743d22313722206d6574613a776f72642d636f756e743d22343022206d6574613a6368617261637465722d636f756e743d22353938222f3e3c6d6574613a757365722d646566696e6564206d6574613a6e616d653d22496e666f2031222f3e3c6d6574613a757365722d646566696e6564206d6574613a6e616d653d22496e666f2032222f3e3c6d6574613a757365722d646566696e6564206d6574613a6e616d653d22496e666f2033222f3e3c6d6574613a757365722d646566696e6564206d6574613a6e616d653d22496e666f2034222f3e3c2f6f66666963653a6d6574613e3c2f6f66666963653a646f63756d656e742d6d6574613e504b0304140008080800978dbf3c000000000000000000000000180000005468756d626e61696c732f7468756d626e61696c2e706e67ed9757541388d2c771594541c1820b288a82223d52059144164280a5485f030157aaf422bd29880852a405e93d404288f41e1484282d94d00221482721444a0809edfa78bfb7efdca7fb70e765e69cdfd3cc99f99ff9c73d31825ce0bec6cdc1c171414f57dbf4576ee0e038c571f6b75f558866610207c725493d6d4df3a05c5a1ec86b467fa237f9f5117f138fcc65c01919b23e25c1facde5cda8ab280ea4cc0f4bf312f3dfa33890553a557fa44b9faafcfb52a0e6d61f9a0f2b2378a2ceaa727b361dc8ef0e9dbf3be3b3611f3cb84f06826ef1827993df2e89e52bc6c62e911b67644f79f3448652785f395fd83da55ac8f7f9543807ef1aa7f76391579c6c0ee161aef957400eaeff0841c4d8df62f35cdbb9a1612512b551eac457ab3a9cec29edca9fdf29da0aa5031413f1e8cff1c509a90ef5b67c4e8a80b32eaa0631174d08759505a35d8ab2e559b27d48012d653c3c966a9f96512c305332a26dc95b59527d35edd2dd32fa70b6f6538aa5be30a2a18a800ba97534cb82c7ac6934f3cc976f7987d747a93e39f168aa66a34ed6eb5e5fff90ff022e18f599643c71c555cf688715f6294164f6f4cfb1a0be7d426293f5bbc5e0e82d9effdb4ed2dbed72c895db02e986fd269a9ce5122b4612e08c4ac780acd2a50f0238a501e97f4e6ba86d04ae12f2593f22469aaf39754ce5dff45fa54dfb3a96432aef818900b044456d7fed355c47957da2cbfd615a8794690021c134f27d7dbf27c5839ac55432d230358b11cb65e902782bff4c654a5d58c215576cc3799ac097cec98fb500f03916195502565d4c7724f2c26957991c140c23507fe3c4d7448e560314dfaa8599372a2c0e124ceefd90f611e4b11d266a539e99fd08fe33abd6dd3a672ff3a6e3d5694f1949f2070ff298aa9062970909618a464c109f9e09cdfe967cba4d66aae74d17c9b9bf3aec0e4a5f4c9a77617c1c22de9a8996215b899044ac1ef42e12dba92bddb77b3cfb0f87a82bad47e2d9c7905ed2149a9606bce4dacf247361322189a0804a4b27966679c003ac246ae2cd568eecc983e87dfe7f5b0697c722100884efc16f370bb46e769007588b8bb85329107198a642cac4422025d0a1b97614df997422645092b27fe8acd789eb8cd8b41928c79b89de06a57b9d5c2d501a4d2ec065aed1eb464e12e0bb9edb0c7bc19152b1a3644b4910ff846b918a7644e16afd5516ab85216d48cd0bb32747b0960bedfccd8e7bd411bbc697ff58d78e064f3b9bb661d8d4a030b6ce71dad79cb49be175c664f7a1ef45c6699d405923f2708bcc1a6d8aed02ca21f53d19f552a4e6b0252bd0a881894abbae432a2418a1a2edb1af488c1f64a9e5e58f660216c7b89868a1f0dcfc56ed4dd93c97a3ad5837e2da6ef73ae6cfd1fda5af0605e8ddedb4cc0f43c0b893298ffc3938809eec043f5c945155ae33329e1ee8b71f430632e2d67f721eecad6dade7cc6fecd674d6f9180d35e257dcb7fc5ee8889c64be148f13613b8e5f378bd407defd3e7bae6985383595bfd7b6848f3711d24f7620d2b85b688e2129ae360f6304311beb29d85e7800722b8a6d29847c117e7b700cf4b79ac13ded24c19c3dac2053a27f43fa2e7ade79240128c52dc0d3c72e79d37e7f17a917d861e9b723938552c37a9f41bceba828d56df52b7e3dfb440140ab110851cacaa4d86bc67c03d7c895c97901a494d12b1faca0909e678fa9ac108d9fe6073ecf4610e3b592c40f07971f8df52384c2772b52d1b7fef670b35b6d9d39badb16d2455a52eb717a3805f0a57eb1e847df9b258da2c6108e1a67dbdaefa7aeb6cca40a31bcf7827ecf1ec1e54d62a19ef6903aec99eb8f50ef7e32a20e25e75d74444cd299eea916c8c5b1f5eacdf7153210f08865cab7cf761512fed073b0de144837923f40787838ddd7c2b4e51e2cd89230f8f27edbee86545efaf3a205be1b6588a3f4dce25ba4c7c86fe26613a19ab7301f29a3a633a34cdf9b8658c5f11202e58fba2cccfbe9d698cd418bba836b753ed305dc76bb4f4001312b432216d9c4c566f00876f3bd815ad62d7263686bab4150dba558d98d5a839dd9b1321bff4b991abcf0b1222cc3080d149bf147234d036a5b67fbf9a3334e076ba2c0b27d0ce89eb2194d0f9cef2169f707608c6ed0f00dd6a85e4949aeb5e79eadceeea890775ba6f09880f63406d7ba85831ecc199285afd91ccaa09103bd3e55a0f19aaf9e1137a2ce680228067e30d9463e07e6b2ed81a0b8715aa97757063b8844f04ca41b56dedd74f5d7e0581888d230be18390b5b6b584035cf06459e1771a738d5cd4739eda6400257705d1eeee01be25be3c66191233c4bf5637918aefe328825b1e18d0ddcccdfd567e7c7e03925f91a1dea9767f70bd2a038d3396d90cbefe7eadf06110e057de230f7efa0c6890e3d44a5ba47140157fdd6fccc2b1ec89c2b2ea6b1573c18592e1a4535d8c2c5bd10dd42e59ec5659c0adb1d7f175bfc8f538b808ecac8b09dbb95ac9959f510b700f55aa8d5c64655620c94f4ed76e6e573f5882020abc6ade66b0f8ed3ad0f6005f90dad991d0fa2844ed6a6ebbcbc5ba639676a3eee922e93c9831a35e94e6dad2c3f79f7346558b41426ce99341f3c3abcef1848872a947f710f5cb579e17b5eca3437e14c115b0f92e1357a83cd37f8c623d9ea217cd659e1735da950f8ec4bfb5cbdd866a904ef33e0ecb10bacf3a5c2f920c31e91a6e5db84cbe2618ffb7eb44453fd5e2d8e6cdbfb1f4d314ae1dccf348abfdf81c9bc71bc1bad92b278f64829f61f90e4213828d0d700fcc83c5dc02de3b9bc27500d0ee956cac24f2afd9d0df07762732f381463ad64c7591d550577b0f4047d12be24ee634c631e22e32248c3d08a99380094efb102ed1982de379ed7c2d763c42bc3bda1ac142aaefa5e0377d1ceb3a44e97068736da9aaf82a3812721be2fca0fe29bb0d0630aee515947b933a049804ad6d214a298b463fd5e3fbc72a341776594572b6734eea1f8dc549d1619235179a0476549c03c353a94c78d8dc6686cf8c7f0d19b3202350c2df246fc047255745dfc58e13c2e96672f8e820bd8b14fe33253c0abf06f008a5aac64663384cdb6063dc9f489be1d9b1b6d88347b74feb53cb49cd73dd7f50423b74e34c3f2e3eae349cd20ef1196f9bb50e184d85d0f7f56c7038607237c6bee8b52099f9e630664fd8d76457b8fcbcbc5605543aa1f0c538e29e353cfa8c0f72a197f35587145a9b03e1584a0d871a086f73e5d31c1ad6d01d2ec2d4dca9b75ead7ef510884214e3f77f9b98da3e9918da969e7d44b5593a442c30e306d5db7ad1d286b8910254a1f48a6ecf1d74dbf1a68faa8f0a27f37580f66a693ea3479931d6ef5dbcf5e0e52a2c8f253d126c6a0eaf274bbb59c3385d954533ea12d130e0bf1e1cb9c4c8fbca4c208e1915caede5ddcdbf1c69435f55e9ec4f7b6f6b7de8aaeb792a2c90b0994181934586ffdd9e22f897754cec2e4c9485354903174a9f78d2f65cb525f40d5a31abd50d582c69912c9f5b6ea0851a8ba3a992724ff833e8ec4b626d8d5f51998a739dce761bc0e3ffd7d922869d666383ed48ffaa04beeb46c6be7442b2ddbe9b6225e42562628db7702c6829b31d1695f7c51495f1aea6ae2ab09879f8faa9f67ed793a3a972d431553bf6c325b03b52804cdb974dd82c225fda187477da380f4e108d72be0bd09fe0a9b808147212e4cd95075a4577d90069dbbd9bbaf3e72a8e540a4b9fd970c644045db70048bbc92af42157ecd0f63dcf86a4bf5a4724525bf9db3f269afd53b57145a9a1b83055a7fe076617c7724e57f2fcb03e7797e8f5968bd68a20bdb373be0b5a66ce442a14f6dd5b2e0945088184d3d4130b1606dba76cf0658d678affe7abc97ea97390b836d9b114676a3a03f246437d0df61f53c71a745519020a64ed3a9d3e707af93ba8314d99fc06a89be78ebb7522ab915af63e9c1a66ae48a125e7116fba977ebd018aa387106c55d97c4a6f2e027f22c52be3d9b0f6dad355f25f2c8f133dd9545b1bb37f2a1f0ac1467ebd935f5e766f9e2a8e7b077e0b5714f895070e6f183de9699bae98454135fb55ab3219891de9a7cbad0f47a5be21e675634e92f2db677f4544790e1f0d593da82e34dd205abeb1b2b14e721ff74c81aacb9dc5a6bab5e86f01abba0eee03d38cfc4dad31b5f5ed7b886240dbb5de2a2f502aa51e4545f8f4913aae86315b983bec72bcfb2070a8077acb1d64d3dd7f76f5b4732b556abb1778ae5ae7ae7b409ac3efd34c3c5ac2e543dbb346977e5ba32562cedb6ec8dbc1ccb9402dfc9e7359fcaa50eb9f5c0b62ba921f01b2183c2ec208bb58f06ceba0cd8605cd2a1b941ad9cc2af73780d7e7848bc6a77d3e5223bc8b03e42f79f36cd27a19321de7f414511fba92e2f7fb5be68518cdb2175d9654b237a5baadacd1339b8948aea4dbb0f26d66e053f16c1a4ebabd28aab2806f5dff5a9f5518b890270a5ee034eda2f72591911175ada7bdcdbdfbc82074e8661de670ee350cbf09ace504cdf712f65322ea0da28b4a50c73981b18daf244aa4bbe6cba888696936d0ac274990d1318d6c579283fa21200d9f3fcb61740603470d039ad7b067f468f1dafb000885ba9264f88493f98e3ab88107683c17946e416439f852a43e99ac2c65d622410f3fee6aa8266f423bdc3d7410b3d3fef6c712dc40974a77d157977cff6bcf1e5c85bf941f2b74067fecd6f289524479eb45d529c9ffef5d30ce177c6cca8878fccc6700aac34e110f58803673bc3b023fd4ef0d6fa7536f57061d06f6b0b9434175e1c58e0407a3b17b22b176e44f70afd12a6261291b6b02f53c884d0b143c0e3001fed852672f183f20e3cfd60142aec82963fd95e0e931a3c58c53e3d9eb167ef1966c76d4b07eb0b6be7487b958a3db4c69610880d268971c0908b1045e1f7f64f8f598e7e018d87e44e6a793c3d707b65b046f2af09c0d974ae6b074fe9058a00901ff34afc448df07a60236d4e65353f0f36878efced85122ec76b7995bca8789433dbc1c2ac2cdd893cc91f328232aeaf03c354bf4115d9aa3f1db3f45b3b8527647fde020e78cd0c16004978534eb6ea9272db7c4cd496ec7f6ed8fe87feab51522c554ce4a661fc5e48c74d99a645e498f12fbdb60d21c83a293aa79f15825b523cc673e3b22c2305084d7dde7a30e54e5b70d1c4352b2d3725ab807629649fc90b38340eb3919ecf0f4311ece473898b3ecab47b7edb6505127fcdc82f4f97e6bc99898142a5ec4f074b776cea32a50244da53f059615395bd8c2434f3eddcdca3f8aac2cc0b0cdbe24662938062f4447802c846c4b3bd63f664d3f52ae1ca0cfa1870bfc080b3c9d3f204e60158a55b557a9caec93a6bc3ed1a6d7d14e9e164dd143748b620294c8d7a9e1efb64db4a1fd8ebda96d6a17177880c0ecdd22e7480063c67e8652845fae9439effc7608e456c2e38ec8b25ac8872fc0a3db09176f59fcfa2fe05504b07086b5628745b0f000062110000504b0304140008080800978dbf3c0000000000000000000000000c00000073657474696e67732e786d6ced1bdb76a2caf2fd7c4596af7bcd16d4cc895933d9ab51f032f102022a6b5e1a6885b1a1595c82e6eb77356a9249f44c62c29c79b01e40e8eeaaeaeaba35567ff9671dd08b3b12273e0bbf56c4bf85ca05091de6fae1f26bc5d0954f57957f6efef3852d16be43ae5de6640109d34f094953e8925cc0f030b9de367fad647178cd70e227d7210e48729d3ad72c22e17ed8f5d3ded705b1ed9b35f5c3d5d78a97a6d175b59ae7f9df79fd6f162fab62b3d9ac16adfbae0e0b17fef2b5a4b6bd9f92628c3d10e203b6cc14c46a82d0a86e9f2b173b269f88a656b9d9cb613ffd9b2f3b02dbdb273f250197cdc5ee3567ed6b05485edff9247f905ae5d0b89fc798d01fc504eb2caaec5bd24d042d7e98566e6acd46f34bf52592d723be258bf41066f1aade781fe6a9efa6de41a605f14a7c1fee2ef197de61be859a78791af289c7728db8a065a4e5e170499267046cc628c161e5268d33721a8d5e28c52c4fc880b9e418f605a6c9abd17f0a70f4c90f5db226ee4b591d56b1620c1847bc799dc47bee3356933406fdaddc706dae9dbe92c774efb3d0b83a1deb1153b9121b272b74e2db9494612905e2126cbbc0ab1db3911a5860fd5da82596a62c38288dbaf8f94495b0180b74c0f45cd93c160362e11d7a86372c4b5b8c6641f8dca677d8dfe18fb6d825c6561f66d42fe5a2602765f111de2f4f944d2f99104a9c94b84a0c2f4e60fdc0cba7cee558f3ce5f1dee00d1f1f5f174fb228b710ad1f92d8115b9ee18c77812610746e84cc7a0d62d42e951a7ff8e151c83bb4cc73822b112b36042d2ecb9c57f04955ef28dc4214a7c1c8eb3d049b34228654d47233c2722cf43c347e0bf853ccf885c9c1e0a93ef33d8361bb2b485a3348b493bc6f9c8fe918cc2315e9661b8137c47cc6de2380a5b942565102916430ea274c3675142ca521098809150d2677619e681286579410608b470e810faf1d300832fbcdc68b10037519a95f32ca1cc8528fc5429c8590aa14061f1f3b0fe11a2817c3a4e5196b2ad5997249b1683b0c38e7bf077a227f141cf8d13f2b921f9218e37951be2d97f55c5b5a375ccc46e2b0eeea2a5de51eead59ff9b355397837b743f6849aa2ae4cbe112fddfe10dfc4d1192512e19fb6709216f0277d985cb40d44666de432d243948c99186248a3a39b2115af3678ca41c1a918e240f7507c852a50d9219bf0bfcfd2047396a0fd000a1255210527369c0df3ff0a0aa484a735497b4f67f1ba88b54d4477d763b44de8af3d5cea5395af6a0dfc35d426df57788507afc29f34b8b5fda4bf83dae025c1d1ca4c974644e7a306238902c3496aa496ce6afa267bf89bb6322c81ff83dc3197e27a85cf70c413426cbdd3398cbbbfc834c33a76b0a6a4033245b636325eaba684e54c140c6cad435793d408a99e1599f3a8236001a6327a0d40e35cfedd03b7b29a9bad8378c95d23791d433e4e6064fcdcc55fa776e47112c5d6e0c90d4994fd7f7c0cfd09a6ad1dcd42e9d8e81d49929d8398c5124187329e8b5cb965dd79851a32b6b361ccea797228c4b88fa301ef08b9e1d9a9e2d6ba2d359532203bee9face12a8604dc5fb623e756de34e87029e36b389a12d066d65a1534945b2a7ea532573a74aa20526b5f6bc029fbc2fcc5f520553d6457754f4ad9bc25e367abd1f59c0e37ca64576ad81b495d2d60c6d6c0a0d3451a43dafb23b93126be6c91868d8357768d7346a23697bef98f74e7e600e8ae4593513e4aa516729296e606646470941061d90fbbd8bb6639c87711605391ab6a86de6b315c4083e5f033de517d62c773a26e881f9c3ae5dded9d3e6ca7a94a361caca3df413eca9923be290ba5d9857e02053d10a5e392ebb4333e83bd14cad8d3bcd685e3390d9ed8b059ed950300213e46d79767748b9bcd45a33b1ebfd623c92c5b1be6ab6274a7fac1be642379ab2a6166b2debca76fd0d591bcc44a9adb7e75c86ea64b556ec60786771bab9649af2bcc1f14e82a6af4e873fec3a5faba20de4118d55580355d4169355b3a51ac351a17f0ac767a9c0dfbdd9f136302604fb309cd02c78d48266e66e75c4b341f6206fc3a0a68214d06fe0dfddadeff007caadae1421581b2e47d0c9cf306f6958d0f086ba6c45b09ea65333571cef5416075a4013cbb8f46c580ba3db8fc04634ae6b78a65d6a75b08719d8aea2749da0293acad5e6a39cc20a5d713b360d792921691f971ee3e98b38f63c56427a803aeaf68e7adc4bfc341ed207e14d0c15f4e66f1af24b004ea6b91423d01bac4aa0df6f63e90c67f85dd043928d3a098fbf11ea34d0ecb7a4d26738c35b01f679dd1ef7a71edf6f9ee10c7f2c14df23a4279ef471ff9d0fdafb4ef0fba78f0a4f60c52f4593f5f4750f550f133cb8bf6f15b98dfadabdbff40d291f9c079de10c25c1b888070682fde61dea0868cebf1f745608f6ac3f506789c67fc037d7339ce1b74311758a6fd1a3c7bdf4f3e7e731e1b1bd5da4568dc361e90c6738c319fe60c03cee8f855bc86723fe5c5513c4bf6f8067abb6c0b761eedfc60dde9ef2f6bf8a76fe7dae7dd93abaadec15e3399cf8b77816c7244cdb38c5fc6f647e9fb02c765ed4bcecea2d25dfa63e5bc638f2362796d630ec6a04bb2ca49b32fee7ff79422d1604383c563d6a17b33991100b13df25b14ed6e914e4310a47f68f312ba53a258ae8c64848cc67554a5d0a2f442bea3a76d568254c42f10975cb2cc0e82d431613c58f93f4d60f492f74410f7ae1300b6c12ff8f399d4e1124966884e2d4bf233adb122c6b5e9c160a5d89e27095282ce6536c61ea64b4d41a3b14862c2d281c2f843bb1f6f380daa17492e2f8a80cdf3119b09e11757745340302f6ef9450a453cc4563f93742ca28afdcb13f7c5929bb7768dfbfb709a5e2772fbab805ef17f7497a5117eac2c5b8757bf1f91d5415bc3e4eb6fa0af9876b505a87582466f23abd8500508a496e2bd4c0258f297688c72878e81256a228e2ec6749ea2f36dc1293a99f7a031c66984a31c1ab922656d4d39754dbc70be4b003ea0521338a49c26b463fbc161ecc90d7f73d46cda8142de825b7d826b4bd3b82554ac1a8bf0cc1dc27298b20e8fb65fae0aeef4264e1122b4b93359290943b6394a6318f2e103415564630dbd5a12f89849dd53266d98bdcec2354f9600e7840998bf32227aaf2284bf939ad5b7247e89ce736498999c6566c314b22e294a10505fe0ecfea4b898bbc0cbd43998d1f4c9217d89777ce6127284dbf2d2795d8fa30eef87f912fbf2b29873849e210d35f04cb8f980a6c5d405e7b4756ca8476e71a7755de40e51b79b1ff7b5ac8fc8aa4a245fd08250f810b850e0427e24e63e81a2b745354db97a0cedb64b26c73e787438aa34465d592f30d0b3fa8cccdb138417624a974fd84e7b5eec939312ace246cf747a06f3cd0145f10925e78eb27a5f933d82b392b1ec6ca7034db5d2c3f4ca59320a227ed688f9e3dabbe38dd5d3d76eefde65f504b0708d7f0836ec1090000393f0000504b0304140008080800978dbf3c000000000000000000000000150000004d4554412d494e462f6d616e69666573742e786d6cb5954d6ec2301085f73d45e46d15bb65554504a456ea09e8018c330996fc27cf18c1edeb2001694bab82f0ceb6c6ef7b33c98ce7cb9d35d516226aef5af6cc9f58054ef94ebba1651fabf7fa852d170f732b9dee01a9392eaa7ccfe169dbb2145de3256a6c9cb4800da9c607709d57c982a3e66b7c3392160fd559b8d706ea1c18f7d519069d9635ed03b44c8660b492947d8aadebf881c5a7084eb02376be3dc96a3639ee93317590b4699960e22a0f9755debcebf590e2c11bce0492a4846b19cbc84ba5c040defa28548a71cc3c17b738ab08a0375e1214120f3ea490ff8c54483efa210296fbd2a3f562e2e4bd2926aead1c00c5ab262b0316655ca9fd7d8c607263f7f0a4b99a02fee7e14af838a0c4d8ab17c5339f6e6be66952b1eb1f7f451ccf788ebaab77a4bd01bcc1fadfb21648de6db8ad36c9ae9dd406051d973cb8e1dee2f72d2c10e5b7f854dab9f8f1142f3e01504b0708e270c51f55010000c5070000504b01021400140000080000978dbf3c5ec6320c27000000270000000800000000000000000000000000000000006d696d6574797065504b01021400140000080000978dbf3c0000000000000000000000001a000000000000000000000000004d000000436f6e66696775726174696f6e73322f7374617475736261722f504b01021400140000080800978dbf3c000000000200000000000000270000000000000000000000000085000000436f6e66696775726174696f6e73322f616363656c657261746f722f63757272656e742e786d6c504b01021400140000080000978dbf3c0000000000000000000000001800000000000000000000000000cc000000436f6e66696775726174696f6e73322f666c6f617465722f504b01021400140000080000978dbf3c0000000000000000000000001a0000000000000000000000000002010000436f6e66696775726174696f6e73322f706f7075706d656e752f504b01021400140000080000978dbf3c0000000000000000000000001c000000000000000000000000003a010000436f6e66696775726174696f6e73322f70726f67726573736261722f504b01021400140000080000978dbf3c000000000000000000000000180000000000000000000000000074010000436f6e66696775726174696f6e73322f6d656e756261722f504b01021400140000080000978dbf3c0000000000000000000000001800000000000000000000000000aa010000436f6e66696775726174696f6e73322f746f6f6c6261722f504b01021400140000080000978dbf3c0000000000000000000000001f00000000000000000000000000e0010000436f6e66696775726174696f6e73322f696d616765732f4269746d6170732f504b01021400140008080800978dbf3c3cd607b25b080000683900000b000000000000000000000000001d020000636f6e74656e742e786d6c504b01021400140000080800978dbf3ce6c6024ff4000000140200000c00000000000000000000000000b10a00006d616e69666573742e726466504b01021400140008080800978dbf3cc4acf3e9140e0000927200000a00000000000000000000000000cf0b00007374796c65732e786d6c504b01021400140000080000978dbf3c6a1aa654f2040000f204000008000000000000000000000000001b1a00006d6574612e786d6c504b01021400140008080800978dbf3c6b5628745b0f0000621100001800000000000000000000000000331f00005468756d626e61696c732f7468756d626e61696c2e706e67504b01021400140008080800978dbf3cd7f0836ec1090000393f00000c00000000000000000000000000d42e000073657474696e67732e786d6c504b01021400140008080800978dbf3ce270c51f55010000c50700001500000000000000000000000000cf3800004d4554412d494e462f6d616e69666573742e786d6c504b0506000000001000100028040000673a00000000, 'Standard Report', 1159653600, 'odt');

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

--
-- Tabellenstruktur für Tabelle `OOoTemplate_seq`
--

CREATE TABLE IF NOT EXISTS `OOoTemplate_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=136 ;

--
-- Daten für Tabelle `OOoTemplate_seq`
--

INSERT INTO `OOoTemplate_seq` (`id`) VALUES
(1);

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

--
-- Tabellenstruktur für Tabelle `price`
--

CREATE TABLE IF NOT EXISTS `price` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `comment` varchar(255) NOT NULL DEFAULT '',
  `projectTree_id` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `validFrom` int(10) unsigned NOT NULL DEFAULT '0',
  `validUntil` int(11) NOT NULL DEFAULT '0',
  `internal` int(11) DEFAULT NULL,
  `external` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`task_id`,`validFrom`,`user_id`,`projectTree_id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `price`
--


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

--
-- Tabellenstruktur für Tabelle `projectTree`
--

CREATE TABLE IF NOT EXISTS `projectTree` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `l` int(11) NOT NULL DEFAULT '0',
  `r` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  `comment` varchar(255) NOT NULL DEFAULT '',
  `startDate` int(11) DEFAULT NULL,
  `endDate` int(11) DEFAULT NULL,
  `roundTo` tinyint(4) DEFAULT NULL,
  `fixedPrice` int(11) DEFAULT NULL,
  `close` tinyint(4) DEFAULT NULL,
  `maxDuration` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `projectTree`
--

INSERT INTO `projectTree` (`id`, `name`, `l`, `r`, `parent`, `comment`, `startDate`, `endDate`, `roundTo`, `fixedPrice`, `close`, `maxDuration`) VALUES
(1, 'Leistungserfassung', 1, 50, 0, '', NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'Projektname', 8, 49, 1, '', 0, 0, NULL, NULL, NULL, NULL);

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

--
-- Tabellenstruktur für Tabelle `projectTree2user`
--

CREATE TABLE IF NOT EXISTS `projectTree2user` (
  `id` int(11) NOT NULL DEFAULT '0',
  `projectTree_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `isManager` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`projectTree_id`,`user_id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `projectTree2user`
--

INSERT INTO `projectTree2user` (`id`, `projectTree_id`, `user_id`, `isManager`) VALUES
(1, 4, 1, 1);

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

--
-- Tabellenstruktur für Tabelle `projectTree2user_seq`
--

CREATE TABLE IF NOT EXISTS `projectTree2user_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Daten für Tabelle `projectTree2user_seq`
--

INSERT INTO `projectTree2user_seq` (`id`) VALUES
(1);

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

--
-- Tabellenstruktur für Tabelle `projectTree_seq`
--

CREATE TABLE IF NOT EXISTS `projectTree_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;

--
-- Daten für Tabelle `projectTree_seq`
--

INSERT INTO `projectTree_seq` (`id`) VALUES
(6);

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

--
-- Tabellenstruktur für Tabelle `task`
--

CREATE TABLE IF NOT EXISTS `task` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL DEFAULT '',
  `comment` varchar(255) NOT NULL DEFAULT '',
  `needsProject` tinyint(4) NOT NULL DEFAULT '0',
  `calcTime` tinyint(4) NOT NULL DEFAULT '0',
  `color` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `task`
--

INSERT INTO `task` (`id`, `name`, `comment`, `needsProject`, `calcTime`, `color`) VALUES
(1, 'Kommen', '', 1, 1, 'green'),
(2, 'Gehen', '', 0, 0, ''),
(3, 'Pause', '', 0, 1, 'lightgrey');

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

--
-- Tabellenstruktur für Tabelle `task_seq`
--

CREATE TABLE IF NOT EXISTS `task_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Daten für Tabelle `task_seq`
--

INSERT INTO `task_seq` (`id`) VALUES
(3);

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

--
-- Tabellenstruktur für Tabelle `time`
--

CREATE TABLE IF NOT EXISTS `time` (
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `projectTree_id` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `durationSec` int(11) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `time`
--


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

--
-- Tabellenstruktur für Tabelle `time_seq`
--

CREATE TABLE IF NOT EXISTS `time_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;

--
-- Daten für Tabelle `time_seq`
--

INSERT INTO `time_seq` (`id`) VALUES
(3);

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

--
-- Tabellenstruktur für Tabelle `translate_de`
--

CREATE TABLE IF NOT EXISTS `translate_de` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `string` mediumtext NOT NULL,
  `convertHtml` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=297 ;

--
-- Daten für Tabelle `translate_de`
--

INSERT INTO `translate_de` (`id`, `string`, `convertHtml`) VALUES
(55, 'gültig ab', '0'),
(46, 'gültig', '0'),
(188, 'Admin Modus aktiviert!', '0'),
(42, 'Benutzer', '0'),
(40, 'Benutzer', '0'),
(99, 'Benutzer:', '0'),
(38, 'Benutzer', '0'),
(184, 'Hier können Sie Buchungen für einen längeren Zeitraum durchführen (z.B. 2 Wochen Urlaub, usw.).', '0'),
(128, 'Hier können Sie mit Unterstützung der $1 Funktion (Eingabehilfe) mehrere Zeiten erfassen.', '0'),
(223, 'Vorlage verwenden (Hochladen)', '0'),
(215, 'Seite neu laden', '0'),
(6, 'Update', ''),
(45, 'bis', '0'),
(123, 'heute ist', '0'),
(198, 'Typ', '0'),
(65, 'unter', '0'),
(201, 'nach PDF', '0'),
(15, 'heute', '0'),
(101, 'Zeitübersicht und Filter', '0'),
(173, 'Zeit(en) gespeichert.', '0'),
(47, 'bis', '0'),
(39, 'Zeit', '0'),
(162, 'Dieses Projekt ist an diesem Datum nicht mehr verfügbar oder nur noch mit Adminberechtigungen zu verändern!', '0'),
(238, 'Dieses Login ist schon vergeben!', '0'),
(207, 'Das ist kein gültiger Zugangsname!', '0'),
(236, 'Die Passwörter stimmen nicht überein!', '0'),
(170, 'Es wurden schon $1 Zeiten ausserhalb des neuen Projekt-Gültigkeitszeitraumes gebucht, der neue Zeitraum muss diese Buchungen beinhalten!', '0'),
(160, 'Das Projekt ist nicht mehr verfügbar, der Eintrag kann nicht gelöscht werden!', '0'),
(85, 'Die Anzahl Arbeitstage nach denen $1 die Zeiten nicht mehr editierbar sind.', '0'),
(61, 'Dankeschön', '0'),
(197, 'Vorlage', '0'),
(135, 'Tätigkeiten', '0'),
(94, 'Tätigkeiten', '0'),
(43, 'Tätigkeit', '0'),
(3, 'Tätigkeit', '0'),
(129, 'Nachname', '0'),
(72, 'gesamt', '0'),
(16, 'Summe', '0'),
(175, 'Start-Tätigkeit', '0'),
(87, 'Extras', '0'),
(49, 'Beginn', '0'),
(83, 'Extras', '0'),
(194, 'Quelle', '0'),
(157, 'Sorry, diese Tätigkeit wurde schon $1 mal benutzt und kann nicht gelöscht werden!', '0'),
(152, 'Sorry, der von Ihnen gewählte Eintrag wurde in der Zwischenzeit gelöscht!', '0'),
(216, 'Alle Spalten anzeigen', '0'),
(53, 'Anzeigen', '0'),
(5, 'Als neuen speichern', ''),
(4, 'Speichern', '0'),
(80, 'Runden', '0'),
(76, 'Runden', '0'),
(244, 'Zurücksetzen', '0'),
(251, 'Passwort-Wiederholung', ''),
(35, 'Projekte', '0'),
(86, 'Projekte', '0'),
(127, 'aktualisieren', '0'),
(196, 'Projekt(e)', '0'),
(32, 'Gewinn:', '0'),
(2, 'Projekt', '0'),
(144, 'Projekt - Team', '0'),
(37, 'Preise', '0'),
(41, 'Preise', '0'),
(192, 'Drucken', '0'),
(54, 'Druckansicht', '0'),
(36, 'Preis', '0'),
(204, 'Bitte geben Sie ein gültiges Format für Zeit und Datum ein!', '0'),
(210, 'Bitte geben Sie ihren Zugangsnamen ein!', '0'),
(240, 'Bitte den kompletten Namen eingeben!', '0'),
(237, 'Bitte ein gültiges Login eingeben!', '0'),
(163, 'Bitte geben Sie eine gültige E-Mail Adresse an!', '0'),
(241, 'Bitte Passwort eingeben!', '0'),
(239, 'Zum Ändern des Logins wird das Passwort benötigt!', '0'),
(154, 'Bitte geben Sie ein Start- und Enddatum an!', '0'),
(155, 'Bitte korrigieren Sie die Daten!', '0'),
(242, 'Passwort', '0'),
(66, 'Vorgänger', '0'),
(18, 'Übersicht', '0'),
(252, 'Öffnen', '0'),
(84, 'Braucht nur angegeben werden, wenn dieses Projekt$1einen Festpreis hat.', '0'),
(193, 'weiter >>', '0'),
(25, 'nein', '0'),
(19, 'jetzt!', '0'),
(224, 'Neue Vorlage (Hochladen und Speichern)', '0'),
(126, 'Neujahr', '0'),
(89, 'neuer Name', '0'),
(21, 'benötigt Projekt?', '0'),
(143, 'Name', '0'),
(79, 'Projekt verschieben', '0'),
(63, 'Projekt verschieben', '0'),
(64, 'Verschieben', '0'),
(81, 'Minuten', '0'),
(202, 'Meldungen', '0'),
(146, 'Mitarbeiter', '0'),
(182, 'Login', '0'),
(17, 'Abmelden', '0'),
(56, 'erstellen', '0'),
(145, 'Projektleiter', '0'),
(180, 'Handbuch', '0'),
(67, 'Erfassung', '0'),
(189, 'Als Benutzer angemeldet', '0'),
(181, 'Lizenziert für: $1 Benutzer', '0'),
(227, 'Zeiten erfassen für das Projekt', '0'),
(31, 'jetzt loggen', '0'),
(183, 'ist Admin', '0'),
(91, 'Sprachen', '0'),
(199, 'Zuletzt exportiert', '0'),
(60, 'Leerlassen falls der Preis immer gültig ist', '0'),
(33, 'intern', '0'),
(69, 'Impressum', '0'),
(23, 'HTML-Farbe', '0'),
(68, 'Feiertag', '0'),
(179, 'Hilfe', '0'),
(30, 'Hallo $1!', '0'),
(122, 'zum aktuellen Monat', '0'),
(44, 'von', '0'),
(228, 'für:', '0'),
(9, 'Vorname', '0'),
(48, 'Festpreis', '0'),
(34, 'extern', '0'),
(222, 'Datei', '0'),
(102, 'Filter', '0'),
(200, 'Export', '0'),
(225, 'Exportierte Daten', '0'),
(185, 'erweiterter Filter', '0'),
(186, 'erweiterter Filter AUS', '0'),
(168, 'Fehler beim Speichern in das Export-Verzeichnis (''$1'')!', '0'),
(153, 'Fehler beim Speichern der Zeit für den $1!', '0'),
(167, 'Fehler beim Empfangen des Templates, bitte versuchen Sie es erneut!', '0'),
(130, 'Email', '0'),
(50, 'Ende', '0'),
(176, 'End-Tätigkeit', '0'),
(213, 'eingeben', '0'),
(57, 'Ändern/Hinzufügen eines Preises', '0'),
(95, 'Tätigkeit ändern', '0'),
(203, 'Benutzer ändern', '0'),
(88, 'Projekt ändern', '0'),
(132, 'Preis ändern', '0'),
(220, 'Eintrag ändern', '0'),
(7, 'Ändern', '0'),
(11, 'Dauer', '0'),
(195, 'Zielformat', '0'),
(59, 'Beschreibung', '0'),
(51, 'löschen', '0'),
(149, 'deaktivieren', '0'),
(82, 'Tage', '0'),
(151, 'Daten gespeichert.', '0'),
(10, 'Datum', '0'),
(13, 'aktuelle Tätigkeit:', '0'),
(1, 'Kunde', '0'),
(187, 'aktuelles Datum:', '0'),
(12, 'aktuelles Projekt:', '0'),
(166, 'Es konnte nicht in das OpenOffice-Template Verzeichnis geschrieben werden!', '0'),
(156, 'Verzeichnis ''$1'' konnte nicht erstellt werden!', '0'),
(58, 'Kommentar', '0'),
(8, 'Kommentar', '0'),
(29, 'Farbe', '0'),
(77, 'Schliessen', '0'),
(125, 'Weihnachten', '0'),
(221, 'wechseln', '0'),
(90, 'Abbrechen', '0'),
(22, 'Zeit berechnen?', '0'),
(71, 'nach Datum', '0'),
(208, 'Authentifizierungs-Modul konnte nicht geladen werden - bitte verständigen Sie ihren Anbieter!', '0'),
(253, 'Auth-Modus:', '0'),
(229, 'Sind Sie sicher?', '0'),
(178, 'Sind Sie sicher, dass Sie diesen Benutzer löschen wollen?\\n\\nAchtung! Alle Daten dieses Benutzers werden unwiderruflich gelöscht!', '0'),
(177, 'Sind Sie sicher, dass Sie diesen Eintrag löschen wollen?', '0'),
(20, 'alle', '0'),
(219, 'Der Admin Modus wurde ausgeschaltet, Sie arbeiten nun wieder wie ein Standard-Benutzer!', '0'),
(190, 'Admin Modus EIN', '0'),
(217, 'Admin Modus AUS', '0'),
(100, 'Administrator', '0'),
(150, 'Admin Modus', '0'),
(133, 'Benutzer hinzufügen', '0'),
(96, 'Tätigkeit hinzufügen', '0'),
(62, 'Projekt hinzufügen', '0'),
(78, 'Projekt hinzufügen', '0'),
(131, 'Preis hinzufügen', '0'),
(211, 'Zugangsname', '0'),
(212, 'Zugangsname', '0'),
(231, 'Zugangsname:', '0'),
(148, 'aktivieren', '0'),
(14, '- seit', '0'),
(165, 'Es wurde schon ein Preis für diesen Eintrag gespeichert!', '0'),
(174, '$1 Datensätze gespeichert.', '0'),
(92, '(tt.mm.jjjj)', '0'),
(158, '$1 $2 ist kein Team-Mitglied im Projekt ''$3''!', '0'),
(169, '$1 $2 hat schon Zeiten auf dieses Projekt gebucht, der Benutzer kann nicht gelöscht werden!', '0'),
(27, '''ja'' wenn für diese Tätigkeit die Zeit berechnet werden soll', '0'),
(26, '''nein'' wenn diese Tätigkeit keinem Projekt zugeordnet werden braucht', '0'),
(124, 'KW', '0'),
(24, 'ja', '0'),
(214, 'Sie sind kein Team-Mitglied eines Projektes, bitte verständigen Sie ihren Administrator!', '0'),
(159, 'Sie sind kein Team-Mitglied im Projekt: ''$1''!', '0'),
(235, 'Sie haben keine Berechtigung Benutzer zu ändern!', '0'),
(161, 'Dieser Benutzer kann nicht gelöscht werden, da nicht alle Zeiten für ihn/sie gelöscht werden konnten!', '0'),
(164, 'Sie können nicht in den Administrator-Modus schalten!', '0'),
(232, 'Sie haben keine Berechtigung diesen Eintrag zu ändern!', '0'),
(234, 'Sie haben keine Berechtigung diesen Eintrag zu löschen!', '0'),
(218, 'Sie haben den Admin Modus eingeschaltet!', '0'),
(230, 'Zugang gültig bis:', '0'),
(209, 'Ihr Zugang ist nicht aktiv - bitte verständigen Sie ihren Anbieter!', '0'),
(206, 'Ihre Lizenz erlaubt nur $1 Benutzer!', '0'),
(205, 'Die Passwörter stimmen nicht überein!', '0'),
(172, 'Ihr Start-Datum lag nach dem End-Datum, sie wurden getauscht.', '0'),
(171, 'Ihre Start-Zeit lag nach der End-Zeit, sie wurden getauscht.', '0'),
(226, '* Wenn Sie die OpenOffice.org-Suite nicht auf Ihrem System installiert haben,$1können Sie diese kostenlos unter $2www.openoffice.org$3 herunterladen.', '0'),
(255, 'löschen', '1'),
(257, 'Kürzel', '1'),
(258, 'Alle Benutzer', '1'),
(259, 'Projektleiter', '1'),
(260, 'Teammitglieder', '1'),
(262, 'Hallo $1,\r\n\r\n$2 hat Sie als User für openTimetool angemeldet.\r\nIhre Zugangsdaten sind wie folgt:\r\n\r\nUsername:\\\\t$3\r\nPasswort:\\\\t$4\r\n\\(Bitte ändern Sie Ihr Passwort sofort!\\)\r\n\r\nHier k?nnen Sie sich einloggen\r\n\\\\t$5\r\n\r\nMit freundlichen Gr??en\r\n$6', '1'),
(263, 'Ihre timetool Registration', '1'),
(270, 'Fehler beim Versenden der E-Mail an ''$1''!', '1'),
(265, 'Infomail wurde an ''$1'' gesendet.', '1'),
(264, 'Die Zeit wurde gerundet von $1 auf $2 ($3 Minuten Rundung).', '1'),
(271, 'Sie haben keine E-Mail angegeben an die die Infomail geschickt werden soll!', '1'),
(273, 'nach Projekt', '1'),
(272, 'nach Woche', '1'),
(276, 'Wochenübersicht', '1'),
(275, 'Legende (Tätigkeiten)', '1'),
(274, 'Wochenübersicht vom $1 bis $2', '1'),
(277, 'Aufwand', '1'),
(279, 'Aufwand in %', '1'),
(278, 'max. Aufwand', '1'),
(280, 'Projektübersicht', '1'),
(281, 'Stunden', '1'),
(282, 'Eintrag Ändern/Hinzufügen', '1'),
(283, 'Sie sind kein Projektmanager eines Projekts', '0'),
(284, 'Nichts selektiert zum exportieren', '0'),
(285, 'Wenn die nachstehende Option ausgewählt ist, erhält der Benutzer ein neues Zufallspasswort und wird per Mail darüber informiert.', '0'),
(286, 'Password rücksetzen', '0'),
(287, 'Team aus ''$1'' übernehmen', '0'),
(290, 'Benutzer', '0'),
(291, 'Passwort', '0'),
(292, 'ändern', '0'),
(293, 'Datum, Uhrzeit', '0'),
(294, 'Sind Sie sicher, dass Sie dieses Projekt, all Unterprojekte und all gebuchten Zeiten löschen wollen ?\\n\\nAchtung! Sämtliche Informationen dieser Projekte werden unwiderruflich gelöscht!', '1'),
(295, 'Wollen Sie diesen Export wirklich löschen??', '0'),
(296, 'Today-Log', '0');

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

--
-- Tabellenstruktur für Tabelle `translate_de_seq`
--

CREATE TABLE IF NOT EXISTS `translate_de_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=297 ;

--
-- Daten für Tabelle `translate_de_seq`
--

INSERT INTO `translate_de_seq` (`id`) VALUES
(296);

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

--
-- Tabellenstruktur für Tabelle `translate_en`
--

CREATE TABLE IF NOT EXISTS `translate_en` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `string` mediumtext NOT NULL,
  `numSubPattern` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=297 ;

--
-- Daten für Tabelle `translate_en`
--

INSERT INTO `translate_en` (`id`, `string`, `numSubPattern`) VALUES
(1, 'Customer', 0),
(2, 'Project', 0),
(3, 'Task', 0),
(4, 'save', 0),
(5, 'save as new', 0),
(6, 'update', 0),
(7, 'edit', 0),
(8, 'Comment', 0),
(9, 'first name', 0),
(10, 'date', 0),
(11, 'Duration', 0),
(12, 'current project:', 0),
(13, 'current task:', 0),
(14, '- since', 0),
(15, 'today', 0),
(16, 'Sum', 0),
(17, 'Logout', 0),
(18, 'Overview', 0),
(19, 'now!', 0),
(20, 'all ', 0),
(21, 'needs project?', 0),
(22, 'calculate time?', 0),
(23, 'HTML-color', 0),
(24, 'yes', 0),
(25, 'no', 0),
(26, '''no'' if this task doesnt require a specific project', 0),
(27, '''yes'' if the time for this task shall be calculated', 0),
(29, 'color', 0),
(30, 'Hello (.*)!', 1),
(31, 'log now', 0),
(32, 'Profit:', 0),
(33, 'internal', 0),
(34, 'external', 0),
(35, 'Projects', 0),
(36, 'price', 0),
(37, 'prices', 0),
(38, 'user', 0),
(39, 'time', 0),
(40, 'users', 0),
(41, 'Prices', 0),
(42, 'Users', 0),
(43, 'task', 0),
(44, 'from', 0),
(45, 'until', 0),
(46, 'valid', 0),
(47, 'through', 0),
(48, 'fixed price', 0),
(49, 'start', 0),
(50, 'end', 0),
(51, 'delete', 0),
(214, 'You are not a team member of any project, please contact your admin!', 0),
(53, 'show', 0),
(54, 'print view', 0),
(55, 'valid from', 0),
(56, 'make', 0),
(57, 'Edit/Add Price', 0),
(58, 'comment', 0),
(59, 'Description', 0),
(60, 'leave empty if the price is always valid', 0),
(61, 'Thanks', 0),
(62, 'Add Project', 0),
(63, 'Move Project', 0),
(64, 'Move', 0),
(65, 'under', 0),
(66, 'Parent', 0),
(67, 'Logging', 0),
(68, 'Holiday', 0),
(69, 'Imprint', 0),
(72, 'Summary', 0),
(71, 'by date', 0),
(193, 'next >>', 0),
(192, 'print', 0),
(76, 'round', 0),
(77, 'close', 0),
(78, 'add project', 0),
(79, 'move project', 0),
(80, 'rounding', 0),
(81, 'minutes', 0),
(82, 'days', 0),
(83, 'specials', 0),
(84, 'Only needs to be given if this project has a fixed price,(.*)if not leave empty.\r\n', 1),
(85, 'The number of work days after which the old months data(.*)are still editable.', 1),
(86, 'projects', 0),
(87, 'Specials', 0),
(88, 'edit project', 0),
(89, 'new name', 0),
(90, 'Cancel', 0),
(91, 'Languages', 0),
(92, '(dd.mm.yyyy)', 0),
(94, 'tasks', 0),
(95, 'edit task', 0),
(96, 'add task', 0),
(100, 'Admin', 0),
(101, 'time overview and filter', 0),
(99, 'User:', 0),
(102, 'filter', 0),
(188, 'using Admin mode!', 0),
(187, 'current date:', 0),
(186, 'extended filter OFF', 0),
(185, 'extended filter', 0),
(184, 'Use this page to log times for a longer period (i.e. 2 weeks for your holidays, etc.).', 0),
(122, 'go to current month', 0),
(123, 'today is', 0),
(124, 'Wk', 0),
(125, 'Christmas', 0),
(126, 'New Years Eve', 0),
(127, 'refresh', 0),
(128, 'Use this page to log multiple times. It uses the (.*) functionality for helping you to fill in the fields.', 1),
(129, 'surname', 0),
(130, 'email', 0),
(131, 'add price', 0),
(132, 'edit price', 0),
(133, 'add user', 0),
(135, 'Tasks', 0),
(202, 'Messages', 0),
(180, 'Manual', 0),
(183, 'is admin', 0),
(182, 'login', 0),
(181, 'licensed for: (.{0,50}) user', 1),
(143, 'name', 0),
(144, 'project - team members', 0),
(145, 'manager(s)', 0),
(146, 'member(s)', 0),
(190, 'Admin mode - ON', 0),
(148, 'activate', 0),
(149, 'deactivate', 0),
(150, 'Admin mode', 0),
(151, 'Data successfully saved.', 0),
(152, 'Sorry, but the Entry you chose was removed meanwhile. Log failed!', 0),
(153, 'Error saving time for the (.*)!', 1),
(154, 'Please define a start and end date for your holiday period!', 0),
(155, 'Please correct the data of the shown entries!', 0),
(156, 'Could not make directory ''(.*)''!', 1),
(157, 'Sorry, this task has already been used (.*) times, it cant be removed!', 1),
(158, '(.{0,30}) (.{0,30}) is not a team member of project: ''(.*)''!', 3),
(159, 'You are not a team member of project: ''(.*)''!', 1),
(160, 'The project is not available anymore, you must not remove the entry!', 0),
(161, 'You can not remove this user, because there are still times logged for him/her!', 0),
(162, 'This project is not available at the date you specified or not modifyable anymore without admin permissions!', 0),
(163, 'Please enter a valid email-address!', 0),
(164, 'You can not switch to admin-mode!', 0),
(165, 'A price for this entry does already exist', 0),
(166, 'Could not write into the OpenOffice-Template directory!', 0),
(167, 'Error retreiving the template, please try again!', 0),
(168, 'Error saving file in export directory (''(.*)'')!', 1),
(169, '(.{0,30}) (.{0,30}) has already booked times on this project, user can''t be removed!', 2),
(170, 'There are already (\\d+) entries saved outside the new period, you want to specify!', 1),
(171, 'Your start time was later than the end time, they were switched!', 0),
(172, 'Your start date was after the end date, they were switched!', 0),
(173, 'Time(s) saved.', 0),
(174, '(\\d+) datasets successfully saved.', 1),
(175, 'start task', 0),
(176, 'end task', 0),
(177, 'Are you sure to delete this entry?', 0),
(178, 'Are you sure you want to delete this user?\\n\\nAttention! All data of this user will be irrevocably deleted!', 0),
(179, 'Help', 0),
(189, 'logged in as User', 0),
(194, 'source', 0),
(195, 'destination format', 0),
(196, 'project(s)', 0),
(197, 'template', 0),
(198, 'type', 0),
(199, 'last exports', 0),
(200, 'export', 0),
(201, 'to PDF', 0),
(203, 'edit user', 0),
(204, 'Please specify a valid time and date!', 0),
(205, 'Your passwords don''t match!', 0),
(206, 'Your license only allows (\\d+) users!', 1),
(207, 'This is not a valid account name!', 0),
(208, 'Authentication modules could not be loaded properly, please contact your vendor!', 0),
(209, 'Your account is not active, please contact your vendor!', 0),
(210, 'Please enter your account name!', 0),
(211, 'Account name', 0),
(212, 'account name', 0),
(213, 'enter', 0),
(215, 'update page', 0),
(216, 'show all columns', 0),
(217, 'Admin mode - OFF', 0),
(218, 'You have switched to admin mode!', 0),
(219, 'Admin mode has been turned off, now you can work again as if you were a standard user!', 0),
(220, 'edit entry', 0),
(221, 'change', 0),
(222, 'file', 0),
(223, 'use template (upload)', 0),
(224, 'new template (upload and store)', 0),
(225, 'export data', 0),
(226, '\\* If you don''t have the OpenOffice-Suite installed on your system,(.*)you can download it for free from (.*)www.openoffice.org(.*)\\.\r\n', 3),
(227, 'Log for the project', 0),
(228, 'for:', 0),
(229, 'Are you sure?', 0),
(230, 'your account expires:', 0),
(231, 'account name:', 0),
(232, 'You don''t have the permission to edit this entry!', 0),
(235, 'You are not allowed to edit users!', 0),
(234, 'You don''t have the permission to remove this entry!', 0),
(236, 'The passwords don''t match!', 0),
(237, 'Please enter a valid login!', 0),
(238, 'This login is not available anymore!', 0),
(239, 'Please enter a password in order to change the username!', 0),
(240, 'Please enter the complete name!', 0),
(241, 'Please enter a password!', 0),
(242, 'password', 0),
(257, 'quick code', 0),
(244, 'reset', 0),
(255, 'remove', 0),
(253, 'authentication mode:', 0),
(252, 'open', 0),
(251, 'repeat password', 0),
(258, 'all users', 0),
(259, 'project managers', 0),
(260, 'team members', 0),
(262, 'Hello (.*),\r\n\r\n(.*) has registered you for openTimetool.\r\nYour access data are:\r\n\r\nusername:   (.*)\r\npassword:   (.*)\r\n(Please change your password right away!)\r\n\r\nYou can login here\r\n    (.*)\r\n\r\nbest regards\r\n\r\n(.*)', 0),
(263, 'Your timetool registration', 0),
(264, 'Time was rounded from (\\d+:\\d+) to (\\d+:\\d+) \\((\\d+) min. rounding\\).', 3),
(265, 'Info e-mail sent to ''(.*)''.', 1),
(266, 'Error copying template file!', 0),
(267, 'Could not open template file, please try again!', 0),
(268, 'Could not read template file, please try again!', 0),
(269, 'Could not copy uploaded file, please try again!', 0),
(270, 'Error sending the mail to ''(.*)''!', 1),
(271, 'You have not given an e-mail to send the info mail to!', 0),
(272, 'by week', 0),
(273, 'by project', 0),
(274, 'Overview from (.*) through (.*)', 2),
(275, 'task legend', 0),
(276, 'overview by week', 0),
(277, 'effort', 0),
(278, 'max. effort', 0),
(279, 'effort in %', 0),
(280, 'overview by project', 0),
(281, 'hours', 0),
(282, 'Edit/Add entry', 0),
(283, 'You are not a project manager of any project!', 0),
(284, 'No data for export', 0),
(285, 'If you check the subsequent option, the user gets a new random password and will be notified by mail.', 0),
(286, 'reset password', 0),
(287, 'Inherit team from parent project ''(.*)''', 1),
(290, 'User', 0),
(291, 'Password', 0),
(292, 'change', 0),
(293, 'date, time', 0),
(294, 'Are you sure you want to delete this project, all its sub projects and all  logged times ?\\n\\nAttention! All data of these projects will be irrevocably deleted!', 0),
(295, 'Are you sure you want to delete this report?', 0),
(296, 'Today-Log', 0);

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

--
-- Tabellenstruktur für Tabelle `translate_en_seq`
--

CREATE TABLE IF NOT EXISTS `translate_en_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=297 ;

--
-- Daten für Tabelle `translate_en_seq`
--

INSERT INTO `translate_en_seq` (`id`) VALUES
(296);

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

--
-- Tabellenstruktur für Tabelle `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL DEFAULT '0',
  `login` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `surname` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `isAdmin` tinyint(4) NOT NULL DEFAULT '0',
  `password` varchar(32) DEFAULT NULL,
  `hoursPerDay` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `user`
--

INSERT INTO `user` (`id`, `login`, `name`, `surname`, `email`, `isAdmin`, `password`, `hoursPerDay`) VALUES
(1, 'root', 'Root', 'Master', 'root@localhost', 1, 'b4b8daf4b8ea9d39568719e1e320076f', NULL);

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

--
-- Tabellenstruktur für Tabelle `user_seq`
--

CREATE TABLE IF NOT EXISTS `user_seq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Daten für Tabelle `user_seq`
--

INSERT INTO `user_seq` (`id`) VALUES
(4);