1. Mikito Takada
  2. Kohana-translate

Source

Kohana-translate / backup.sql

-- MySQL dump 10.13  Distrib 5.1.52, for redhat-linux-gnu (x86_64)
--
-- Host: localhost    Database: translate
-- ------------------------------------------------------
-- Server version	5.1.52

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'login','Login privileges, granted after account confirmation'),(2,'admin','Administrative user, has access to everything.'),(3,'translate','Allow user to access translation module');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles_users`
--

DROP TABLE IF EXISTS `roles_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles_users` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `fk_role_id` (`role_id`),
  CONSTRAINT `roles_users_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `roles_users_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles_users`
--

LOCK TABLES `roles_users` WRITE;
/*!40000 ALTER TABLE `roles_users` DISABLE KEYS */;
INSERT INTO `roles_users` VALUES (3,1),(3,2),(3,3);
/*!40000 ALTER TABLE `roles_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `translate_file_languages`
--

DROP TABLE IF EXISTS `translate_file_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `translate_file_languages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `translate_file_id` int(11) NOT NULL,
  `translate_language_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `translate_file_languages`
--

LOCK TABLES `translate_file_languages` WRITE;
/*!40000 ALTER TABLE `translate_file_languages` DISABLE KEYS */;
INSERT INTO `translate_file_languages` VALUES (2,1,47),(3,1,153);
/*!40000 ALTER TABLE `translate_file_languages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `translate_files`
--

DROP TABLE IF EXISTS `translate_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `translate_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `application` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `language_code` varchar(255) NOT NULL,
  `language_description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `translate_files`
--

LOCK TABLES `translate_files` WRITE;
/*!40000 ALTER TABLE `translate_files` DISABLE KEYS */;
INSERT INTO `translate_files` VALUES (1,'Kohana-Translate','','en-us','English (en-us)');
/*!40000 ALTER TABLE `translate_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `translate_key_locks`
--

DROP TABLE IF EXISTS `translate_key_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `translate_key_locks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `translate_key_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `locked` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `translate_key_locks`
--

LOCK TABLES `translate_key_locks` WRITE;
/*!40000 ALTER TABLE `translate_key_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `translate_key_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `translate_keys`
--

DROP TABLE IF EXISTS `translate_keys`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `translate_keys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id` int(11) NOT NULL,
  `key` longtext NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `translate_keys`
--

LOCK TABLES `translate_keys` WRITE;
/*!40000 ALTER TABLE `translate_keys` DISABLE KEYS */;
INSERT INTO `translate_keys` VALUES (1,1,'The file was imported successfully.'),(2,1,'Save'),(3,1,'Change language'),(4,1,'Log out'),(5,1,'Admin'),(6,1,'Profile'),(7,1,'Adminstration'),(8,1,'Translate \":application\"'),(9,1,'(locked for editing by :user)'),(10,1,'Translated :translated_count strings out of :total_count.'),(11,1,'Write more translations'),(12,1,'View all translations'),(13,1,'Edit translation'),(14,1,'View completed translations'),(15,1,'Note: If you see text starting with a :, such as \"Dear :firstname, your username is: :user\", do not translate the :firstname and :user parts. These are placeholder texts, which will be replaced with values when the translation is used.'),(16,1,'Instead, put the :placeholder to the correct place in the sentence in your language, such as \"Hyvä :firstname, sinun käyttäjätunnuksesi on: :user\".'),(17,1,'Text in English'),(18,1,'Translated text'),(19,1,'Translate'),(20,1,'Translate to :language'),(21,1,'To get started, select the project you would like to translate and the language you want to translate to.'),(22,1,'Delete translation file'),(23,1,'Delete file?'),(24,1,'Are you sure you want to delete \":file\"'),(25,1,'Translated application name'),(26,1,'Source language code'),(27,1,'Source language description'),(28,1,'Default languages'),(29,1,'The default languages are shown on the index for translators. All other languages are shown under \"Other languages\".'),(30,1,'Shown as default?'),(31,1,'Language code'),(32,1,'Language description'),(33,1,'Export translation file'),(34,1,'Export'),(35,1,'Download translations for language'),(36,1,'First'),(37,1,'Previous'),(38,1,'Next'),(39,1,'Last'),(40,1,'Import translation file'),(41,1,'Imported file should be a PHP file which returns an array of translations.'),(42,1,'Obviously, this is a huge security risk, since the code needs to be evaluated. Don\'t give admin rights to untrusted users, or delete the import code from deployed versions... I\'m not going to write a parser for PHP files.'),(43,1,'Important'),(44,1,'I strongly recommend using UNIX line endings in your multi-line strings AND multi-line string lookups (e.g. __(\'\"String\\nNewline\\nSecond newline\"\')! Otherwise, there is the risk that you accidentally save with Windows file endings, causing translation lookups to fail for multi-line strings.'),(45,1,'All newlines (\\r\\n and \\r) are automatically converted to \\n only during import and export in this application. Make sure you use \\n in your string lookups, and that any old translation files are in UNIX newline format.'),(46,1,'Translate new application'),(47,1,'New application'),(48,1,'Update existing application'),(49,1,'Data to import'),(50,1,'Import file'),(51,1,'File source language'),(52,1,'File target language'),(53,1,'Import'),(54,1,'User admin'),(55,1,'Application name'),(56,1,'Suggested translation languages'),(57,1,'Edit file translation settings'),(58,1,'Export file'),(59,1,'Delete file'),(60,1,'Home'),(61,1,'Welcome to the Kohana-Translate Admin Interface.'),(62,1,'Edit translation options'),(63,1,'Kohana'),(64,1,'Benchmark'),(65,1,'Min'),(66,1,'Max'),(67,1,'Average'),(68,1,'Total'),(69,1,'seconds'),(70,1,'Requests'),(71,1,'Database (default)'),(72,1,'Application Execution'),(73,1,'Hello world');
/*!40000 ALTER TABLE `translate_keys` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `translate_languages`
--

DROP TABLE IF EXISTS `translate_languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `translate_languages` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `language_family` varchar(31) DEFAULT NULL,
  `language_description` varchar(80) DEFAULT NULL,
  `language_code` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=185 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `translate_languages`
--

LOCK TABLES `translate_languages` WRITE;
/*!40000 ALTER TABLE `translate_languages` DISABLE KEYS */;
INSERT INTO `translate_languages` VALUES (1,'Northwest Caucasian','Abkhaz','ab'),(2,'Afro-Asiatic','Afar','aa'),(3,'Indo-European','Afrikaans','af'),(4,'Niger-Congo','Akan','ak'),(5,'Indo-European','Albanian','sq'),(6,'Afro-Asiatic','Amharic','am'),(7,'Afro-Asiatic','Arabic','ar'),(8,'Indo-European','Aragonese','an'),(9,'Indo-European','Armenian','hy'),(10,'Indo-European','Assamese','as'),(11,'Northeast Caucasian','Avaric','av'),(12,'Indo-European','Avestan','ae'),(13,'Aymaran','Aymara','ay'),(14,'Turkic','Azerbaijani','az'),(15,'Niger-Congo','Bambara','bm'),(16,'Turkic','Bashkir','ba'),(17,'Language isolate','Basque','eu'),(18,'Indo-European','Belarusian','be'),(19,'Indo-European','Bengali','bn'),(20,'Indo-European','Bihari','bh'),(21,'Creole','Bislama','bi'),(22,'Indo-European','Bosnian','bs'),(23,'Indo-European','Breton','br'),(24,'Indo-European','Bulgarian','bg'),(25,'Sino-Tibetan','Burmese','my'),(26,'Indo-European','Catalan;Valencian','ca'),(27,'Austronesian','Chamorro','ch'),(28,'Northeast Caucasian','Chechen','ce'),(29,'Niger-Congo','Chichewa; Chewa; Nyanja','ny'),(30,'Sino-Tibetan','Chinese','zh'),(31,'Turkic','Chuvash','cv'),(32,'Indo-European','Cornish','kw'),(33,'Indo-European','Corsican','co'),(34,'Algonquian','Cree','cr'),(35,'Indo-European','Croatian','hr'),(36,'Indo-European','Czech','cs'),(37,'Indo-European','Danish','da'),(38,'Indo-European','Divehi; Dhivehi; Maldivian;','dv'),(39,'Indo-European','Dutch','nl'),(40,'Sino-Tibetan','Dzongkha','dz'),(41,'Indo-European','English (en-us)','en-us'),(42,'Constructed','Esperanto','eo'),(43,'Finno-Ugric','Estonian','et'),(44,'Niger-Congo','Ewe','ee'),(45,'Indo-European','Faroese','fo'),(46,'Austronesian','Fijian','fj'),(47,'Finno-Ugric','Finnish','fi'),(48,'Indo-European','French','fr'),(49,'Niger-Congo','Fula; Fulah; Pulaar; Pular','ff'),(50,'Indo-European','Galician','gl'),(51,'South Caucasian','Georgian','ka'),(52,'Indo-European','German','de'),(53,'Indo-European','Greek, Modern','el'),(54,'Tupi-Guarani','Guaraní','gn'),(55,'Indo-European','Gujarati','gu'),(56,'Creole','Haitian; Haitian Creole','ht'),(57,'Afro-Asiatic','Hausa','ha'),(58,'Afro-Asiatic','Hebrew(modern)','he'),(59,'Niger-Congo','Herero','hz'),(60,'Indo-European','Hindi','hi'),(61,'Austronesian','Hiri Motu','ho'),(62,'Finno-Ugric','Hungarian','hu'),(63,'Constructed','Interlingua','ia'),(64,'Austronesian','Indonesian','id'),(65,'Constructed','Interlingue','ie'),(66,'Indo-European','Irish','ga'),(67,'Niger-Congo','Igbo','ig'),(68,'Eskimo-Aleut','Inupiaq','ik'),(69,'Constructed','Ido','io'),(70,'Indo-European','Icelandic','is'),(71,'Indo-European','Italian','it'),(72,'Eskimo-Aleut','Inuktitut','iu'),(73,'Japonic','Japanese','ja'),(74,'Austronesian','Javanese','jv'),(75,'Eskimo-Aleut','Kalaallisut, Greenlandic','kl'),(76,'Dravidian','Kannada','kn'),(77,'Nilo-Saharan','Kanuri','kr'),(78,'Indo-European','Kashmiri','ks'),(79,'Turkic','Kazakh','kk'),(80,'Austro-Asiatic','Khmer','km'),(81,'Niger-Congo','Kikuyu, Gikuyu','ki'),(82,'Niger-Congo','Kinyarwanda','rw'),(83,'Turkic','Kirghiz, Kyrgyz','ky'),(84,'Finno-Ugric','Komi','kv'),(85,'Niger-Congo','Kongo','kg'),(86,'Language isolate(controversial)','Korean','ko'),(87,'Indo-European','Kurdish','ku'),(88,'Niger-Congo','Kwanyama, Kuanyama','kj'),(89,'Indo-European','Latin','la'),(90,'Indo-European','Luxembourgish, Letzeburgesch','lb'),(91,'Niger-Congo','Luganda','lg'),(92,'Indo-European','Limburgish, Limburgan, Limburger','li'),(93,'Niger-Congo','Lingala','ln'),(94,'Tai-Kadai','Lao','lo'),(95,'Indo-European','Lithuanian','lt'),(96,'Niger-Congo','Luba-Katanga','lu'),(97,'Indo-European','Latvian','lv'),(98,'Indo-European','Manx','gv'),(99,'Indo-European','Macedonian','mk'),(100,'Austronesian','Malagasy','mg'),(101,'Austronesian','Malay','ms'),(102,'Dravidian','Malayalam','ml'),(103,'Afro-Asiatic','Maltese','mt'),(104,'Austronesian','Māori','mi'),(105,'Indo-European','Marathi (Marāṭhī)','mr'),(106,'Austronesian','Marshallese','mh'),(107,'Mongolic','Mongolian','mn'),(108,'Austronesian','Nauru','na'),(109,'Dene-Yeniseian','Navajo, Navaho','nv'),(110,'Indo-European','Norwegian Bokmål','nb'),(111,'Niger-Congo','North Ndebele','nd'),(112,'Indo-European','Nepali','ne'),(113,'Niger-Congo','Ndonga','ng'),(114,'Indo-European','Norwegian Nynorsk','nn'),(115,'Indo-European','Norwegian','no'),(116,'Sino-Tibetan','Nuosu','ii'),(117,'Niger-Congo','South Ndebele','nr'),(118,'Indo-European','Occitan','oc'),(119,'Algonquian','Ojibwe, Ojibwa','oj'),(120,'Indo-European','Old Church Slavonic, Church Slavic, Church Slavonic, Old Bulgarian, Old Slavonic','cu'),(121,'Afro-Asiatic','Oromo','om'),(122,'Indo-European','Oriya','or'),(123,'Indo-European','Ossetian, Ossetic','os'),(124,'Indo-European','Panjabi, Punjabi','pa'),(125,'Indo-European','Pāli','pi'),(126,'Indo-European','Persian','fa'),(127,'Indo-European','Polish','pl'),(128,'Indo-European','Pashto, Pushto','ps'),(129,'Indo-European','Portuguese','pt'),(130,'Quechuan','Quechua','qu'),(131,'Indo-European','Romansh','rm'),(132,'Niger-Congo','Kirundi','rn'),(133,'Indo-European','Romanian,Moldavian, Moldovan','ro'),(134,'Indo-European','Russian','ru'),(135,'Indo-European','Sanskrit (Saṁskṛta)','sa'),(136,'Indo-European','Sardinian','sc'),(137,'Indo-European','Sindhi','sd'),(138,'Finno-Ugric','Northern Sami','se'),(139,'Austronesian','Samoan','sm'),(140,'Creole','Sango','sg'),(141,'Indo-European','Serbian','sr'),(142,'Indo-European','Scottish Gaelic; Gaelic','gd'),(143,'Niger-Congo','Shona','sn'),(144,'Indo-European','Sinhala, Sinhalese','si'),(145,'Indo-European','Slovak','sk'),(146,'Indo-European','Slovene','sl'),(147,'Afro-Asiatic','Somali','so'),(148,'Niger-Congo','Southern Sotho','st'),(149,'Indo-European','Spanish; Castilian','es'),(150,'Austronesian','Sundanese','su'),(151,'Niger-Congo','Swahili','sw'),(152,'Niger-Congo','Swati','ss'),(153,'Indo-European','Swedish','sv'),(154,'Dravidian','Tamil','ta'),(155,'Dravidian','Telugu','te'),(156,'Indo-European','Tajik','tg'),(157,'Tai-Kadai','Thai','th'),(158,'Afro-Asiatic','Tigrinya','ti'),(159,'Sino-Tibetan','Tibetan Standard, Tibetan, Central','bo'),(160,'Turkic','Turkmen','tk'),(161,'Austronesian','Tagalog','tl'),(162,'Niger-Congo','Tswana','tn'),(163,'Austronesian','Tonga (Tonga Islands)','to'),(164,'Turkic','Turkish','tr'),(165,'Niger-Congo','Tsonga','ts'),(166,'Turkic','Tatar','tt'),(167,'Niger-Congo','Twi','tw'),(168,'Austronesian','Tahitian','ty'),(169,'Turkic','Uighur, Uyghur','ug'),(170,'Indo-European','Ukrainian','uk'),(171,'Indo-European','Urdu','ur'),(172,'Turkic','Uzbek','uz'),(173,'Niger-Congo','Venda','ve'),(174,'Austro-Asiatic','Vietnamese','vi'),(175,'Constructed','Volapük','vo'),(176,'Indo-European','Walloon','wa'),(177,'Indo-European','Welsh','cy'),(178,'Niger-Congo','Wolof','wo'),(179,'Indo-European','Western Frisian','fy'),(180,'Niger-Congo','Xhosa','xh'),(181,'Indo-European','Yiddish','yi'),(182,'Niger-Congo','Yoruba','yo'),(183,'Tai-Kadai','Zhuang, Chuang','za'),(184,'Niger-Congo','Zulu','zu');
/*!40000 ALTER TABLE `translate_languages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `translate_strings`
--

DROP TABLE IF EXISTS `translate_strings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `translate_strings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id` int(11) NOT NULL,
  `translate_key_id` int(11) NOT NULL,
  `target_language_code` varchar(255) NOT NULL,
  `string` longtext NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `translate_strings`
--

LOCK TABLES `translate_strings` WRITE;
/*!40000 ALTER TABLE `translate_strings` DISABLE KEYS */;
INSERT INTO `translate_strings` VALUES (1,1,1,'fi','Tiedosto tuotu onnistuneesti.',0),(2,1,2,'fi','Tallenna',0),(3,1,3,'fi','Vaihda kieli',0),(4,1,4,'fi','Kirjaudu ulos',0),(5,1,5,'fi','Hallinta',0),(6,1,6,'fi','Profiili',0),(7,1,7,'fi','Hallinta',0),(8,1,8,'fi','Käännä \":application\"',0),(9,1,9,'fi','(lukittu muokattavaksi käyttäjällä :user)',0),(10,1,10,'fi',':translated_count tekstiä käännetty, kokonaismäärä :total_count',0),(11,1,11,'fi','Kirjoita käännöksiä',0),(12,1,12,'fi','Tarkastele kaikkia käännöksiä',0),(13,1,13,'fi','Muokkaa käännöstä',0),(14,1,14,'fi','Näytä käännetyt tekstit',0),(15,1,15,'fi','Huom.: Jos näet merkkijonon, joka alkaa kaksoispisteellä (:), kuten \"Hyvä :firstname, käyttäjätunnuksesi on: :user\", älä käännä kohtia :firstname ja :user. Nämä merkkijonot korvataan käännöstä käytettäessä tapauskohtaisilla tiedoilla, joten niiden täytyy säilyä samanlaisina tekstissä.',0),(16,1,16,'fi','Sen sijaan kopioi :merkkijono oikeaan kohtaan lauseessa kääntämättä sitä, kuten \"Hyvä :firstname, sinun käyttäjätunnuksesi on :user\".',0),(17,1,17,'fi','Teksti englanniksi',0),(18,1,18,'fi','Käännös',0),(19,1,19,'fi','Käännä',0),(20,1,20,'fi','Käännä kielelle: :language',0),(21,1,21,'fi','Aloittaaksesi valitse projekti, jonka haluat kääntää sekä kieli, jolle haluat kääntää.',0),(22,1,22,'fi','Poista käännöstiedosto',0),(23,1,23,'fi','Poista tiedosto?',0),(24,1,24,'fi','Oletko varma että haluat poistaa tiedoston \":file\"',0),(25,1,25,'fi','Käännetyn sovelluksen nimi',0),(26,1,26,'fi','Lähdetiedoston kielikoodi',0),(27,1,27,'fi','Lähdetiedoston kielikoodin kuvaus',0),(28,1,28,'fi','Oletuskielet',0),(29,1,29,'fi','Oletuskielet näytetään kääntäjille etusivulla. Muut kielet näytetään kohdassa \"Muut kielet\".',0),(30,1,30,'fi','Näytetään oletuksena?',0),(31,1,31,'fi','Kielikoodi',0),(32,1,32,'fi','Kielen kuvaus',0),(33,1,33,'fi','Vie käännöstiedosto',0),(34,1,34,'fi','Vienti',0),(35,1,35,'fi','Lataa käännökset kielelle',0),(36,1,36,'fi','Ensimmäinen',0),(37,1,37,'fi','Edellinen',0),(38,1,38,'fi','Seuraava',0),(39,1,39,'fi','Viimeinen',0),(40,1,40,'fi','Tuo käännöstiedosto',0),(41,1,41,'fi','Tuontitiedoston tulee olla PHP-tiedosto, joka palauttaa käännettävät tekstit sisältävän taulukon.',0),(42,1,42,'fi','Tämä on ilmiselvästi valtava tietoturvariski, koska tuontitiedoston koodi ajetaan palvelimella. Älä anna hallinnointitunnuksia muille käyttäjille, tai poista tuonnin tekevä koodi kun otat järjestelmän käyttöön. En aio kirjoittaa parseria PHP-tiedostoille.',0),(43,1,43,'fi','Tärkeää',0),(44,1,44,'fi','Suosittelen, että käytät UNIX -rivinvaihtoja kaikissa monirivisissä käännöksissä JA koodissa hakiessasi käännöksiä (esim. __(\'\"String\\nNewline\\nSecond newline\"\')! Muuten saattaa käydä niin, että tallennat tiedoston vahingossa Windows -rivinvaihdoilla ja käännettyjen monirivisten merkkijonojen haut epäonnistuvat.',0),(45,1,45,'fi','Kaikki rivinvaihdot (\\r\\n ja \\r) muunnetaan automaattisesti \\n -rivinvaihdoiksi tuonnin ja viennin yhteydessä tässä sovelluksessa. Varmista, että käytät \\n -rivinvaihtoja koodissasi ja että kaikki vanhat käännöstiedostot on tallennettu UNIX-formaatissa.',0),(46,1,46,'fi','Käännä uusi sovellus',0),(47,1,47,'fi','Uusi sovellus',0),(48,1,48,'fi','Päivitä olemassaoleva sovellus',0),(49,1,49,'fi','Tuonnissa käytettävä data',0),(50,1,50,'fi','Tuontitiedosto',0),(51,1,51,'fi','Tiedoston lähdekieli',0),(52,1,52,'fi','Tiedoston kohdekieli',0),(53,1,53,'fi','Tuonti',0),(54,1,54,'fi','Käyttäjien hallinta',0),(55,1,55,'fi','Sovelluksen nimi',0),(56,1,56,'fi','Kääntäjille ehdotetut kielet',0),(57,1,57,'fi','Muokkaa käännöstiedoston asetuksia',0),(58,1,58,'fi','Vie tiedosto',0),(59,1,59,'fi','Poista tiedosto',0),(60,1,60,'fi','Etusivu',0),(61,1,61,'fi','Tervetuloa Kohana-Translaten hallinnointipuolelle.',0),(62,1,62,'fi','Muokkaa käännösasetuksia',0),(63,1,63,'fi','Kohana',0),(64,1,64,'fi','Benchmark',0),(65,1,65,'fi','Min',0),(66,1,66,'fi','Max',0),(67,1,67,'fi','Average',0),(68,1,68,'fi','Total',0),(69,1,69,'fi','seconds',0),(70,1,70,'fi','Requests',0),(71,1,71,'fi','Database (default)',0),(72,1,72,'fi','Application Execution',0),(73,1,73,'fi','Terve maailma',0);
/*!40000 ALTER TABLE `translate_strings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_tokens`
--

DROP TABLE IF EXISTS `user_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_tokens` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `user_agent` varchar(40) NOT NULL,
  `token` varchar(32) NOT NULL,
  `created` int(10) unsigned NOT NULL,
  `expires` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_token` (`token`),
  KEY `fk_user_id` (`user_id`),
  CONSTRAINT `user_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_tokens`
--

LOCK TABLES `user_tokens` WRITE;
/*!40000 ALTER TABLE `user_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(127) NOT NULL,
  `username` varchar(32) NOT NULL DEFAULT '',
  `password` char(50) NOT NULL,
  `logins` int(10) unsigned NOT NULL DEFAULT '0',
  `last_login` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_username` (`username`),
  UNIQUE KEY `uniq_email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (3,'admin@example.com','admin','6ee3b3d69853015891fc68c74040714ad581379299023631c7',5,1288792595);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-12-09 17:52:03