{"id":224,"date":"2017-03-02T06:11:34","date_gmt":"2017-03-02T08:11:34","guid":{"rendered":"http:\/\/vejas.defas.lt\/?p=224"},"modified":"2017-07-10T10:05:12","modified_gmt":"2017-07-10T12:05:12","slug":"darbas-su-mysql-ir-lenteliu-struktura","status":"publish","type":"post","link":"http:\/\/vejas.defas.lt\/?p=224","title":{"rendered":"darbas su MySQL ir lenteli\u0173 strukt\u016bra"},"content":{"rendered":"<p>Mysql lenteli\u0173 strukt\u016bra:<\/p>\n<pre>-- MySQL Administrator dump 1.4\r\n-- Server version\u00a0\u00a0 \u00a05.5.44-0+deb8u1\r\n\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;\r\n\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;\r\n\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;\r\n\/*!40101 SET NAMES utf8 *\/;\r\n\/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 *\/;\r\n\/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 *\/;\r\n\/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' *\/;\r\n\r\n-- Create schema vejojegaines\r\nCREATE DATABASE IF NOT EXISTS vejojegaines;\r\nUSE vejojegaines;\r\n-- Definition of table `duomenys`\r\nDROP TABLE IF EXISTS `duomenys`;\r\nCREATE TABLE `duomenys` (\r\n`id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n`laikas` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n`itampa` double(7,2) NOT NULL,\r\n`srove` double(7,2) NOT NULL,\r\n`temperatura` double(7,2) NOT NULL,\r\n`vejas` double(7,2) NOT NULL,\r\n`vejokorekcija` double(7,2) NOT NULL,\r\n`vid` int(11) NOT NULL,\r\nPRIMARY KEY (`id`),\r\nKEY `Index_2` (`vid`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;\r\n\r\n-- Definition of table `grupes`\r\nDROP TABLE IF EXISTS `grupes`;\r\nCREATE TABLE `grupes` (\r\n`id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n`Pavadinimas` varchar(128) CHARACTER SET latin1 NOT NULL,\r\nPRIMARY KEY (`id`),\r\nCONSTRAINT `FK_grupes_1` FOREIGN KEY (`id`) REFERENCES `jegaine` (`gid`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;\r\n\r\nDROP TABLE IF EXISTS `komandos`;\r\n\/*!40101 SET @saved_cs_client\u00a0\u00a0\u00a0\u00a0 = @@character_set_client *\/;\r\n\/*!40101 SET character_set_client = utf8 *\/;\r\nCREATE TABLE `komandos` (\r\n\u00a0 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\u00a0 `komanda` varchar(256) NOT NULL,\r\n\u00a0 `Atlikta` int(10) unsigned NOT NULL DEFAULT '0',\r\n\u00a0 `ModData` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n\u00a0 PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;\r\n\/*!40101 SET character_set_client = @saved_cs_client *\/;\r\n\r\n-- Definition of table `jegaine`\r\nDROP TABLE IF EXISTS `jegaine`;\r\nCREATE TABLE `jegaine` (\r\n`id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n`Pavadinimas` varchar(128) CHARACTER SET latin1 NOT NULL,\r\n`vid` int(10) unsigned NOT NULL COMMENT 'Vartotojo identifikatorius',\r\n`gid` int(10) unsigned NOT NULL COMMENT 'Grupes identifikatorius',\r\nPRIMARY KEY (`id`),\r\nKEY `Index_2` (`vid`),\r\nKEY `Index_3` (`gid`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;\r\n\r\n-- Definition of table `spi`\r\nDROP TABLE IF EXISTS `spi`;\r\nCREATE TABLE `spi` (\r\n`id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n`A1` smallint(5) unsigned NOT NULL,\r\n`A2` smallint(5) unsigned NOT NULL,\r\n`A3` smallint(5) unsigned NOT NULL,\r\n`A4` smallint(5) unsigned NOT NULL,\r\n`A5` smallint(5) unsigned NOT NULL,\r\n`A6` smallint(5) unsigned NOT NULL,\r\n`TSL` int(10) unsigned NOT NULL,\r\n`TSH` int(10) unsigned NOT NULL,\r\n`Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\nPRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;\r\n\r\n\/*!40101 SET SQL_MODE=@OLD_SQL_MODE *\/;\r\n\/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS *\/;\r\n\/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS *\/;\r\n\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;\r\n\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;\r\n\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;\r\n\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;\r\n<\/pre>\n<p>Gautas klaidos prane\u0161imas:<\/p>\n<p>got error -1 from storage engine<\/p>\n<p>I\u0161rtyniau \/var\/lib\/mysql\/ibdata1 ir ib_logfile0 bei iblogfile1<\/p>\n<p>Perstartavau \/etc\/init.d\/mysql &#8211; ok<\/p>\n<p>Ai\u0161ku visas lenteles teko atstatyti i\u0161 backup&#8217;o (atstatymo duomen\u0173 tekstas auk\u0161\u010diau). MysqlAdmin Backup&#8217;o failas yra \u010dia: <a href=\"http:\/\/vejas.defas.lt\/wp-content\/uploads\/2017\/03\/vj-20170409-1223.zip\">vj.zip<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mysql lenteli\u0173 strukt\u016bra: &#8212; MySQL Administrator dump 1.4 &#8212; Server version\u00a0\u00a0 \u00a05.5.44-0+deb8u1 \/*!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 *\/; \/*!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=&#8217;NO_AUTO_VALUE_ON_ZERO&#8217; *\/; &#8212; Create schema vejojegaines CREATE DATABASE IF NOT EXISTS vejojegaines; USE &hellip; <a href=\"http:\/\/vejas.defas.lt\/?p=224\" class=\"more-link\">Skaityti toliau: <span class=\"screen-reader-text\">darbas su MySQL ir lenteli\u0173 strukt\u016bra<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-224","post","type-post","status-publish","format-standard","hentry","category-be-kategorijos"],"acf":[],"_links":{"self":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts\/224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=224"}],"version-history":[{"count":9,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts\/224\/revisions"}],"predecessor-version":[{"id":266,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts\/224\/revisions\/266"}],"wp:attachment":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=224"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}