{"id":1282,"date":"2020-02-05T17:05:04","date_gmt":"2020-02-05T16:05:04","guid":{"rendered":"http:\/\/eiseler.de\/wordpress\/?p=1282"},"modified":"2020-02-05T17:05:28","modified_gmt":"2020-02-05T16:05:28","slug":"sqlite-how-to-use-2-foreign-keys","status":"publish","type":"post","link":"http:\/\/eiseler.de\/wordpress\/?p=1282","title":{"rendered":"SQLite: How to use 2 foreign keys"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>create table .....(\n   ....\n FOREIGN KEY (\n        reg,\n        ver\n    )\n    REFERENCES table2(reg,\n    ver) \n);\n<\/code><\/pre>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1282\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/eiseler.de\/wordpress\/?p=1282&amp;share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\"><span>Facebook<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1282\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/eiseler.de\/wordpress\/?p=1282&amp;share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1282\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/eiseler.de\/wordpress\/?p=1282&amp;share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-pocket\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-pocket sd-button share-icon\" href=\"http:\/\/eiseler.de\/wordpress\/?p=1282&amp;share=pocket\" target=\"_blank\" title=\"Click to share on Pocket\"><span>Pocket<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1282\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/eiseler.de\/wordpress\/?p=1282&amp;share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\"><span>Facebook<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1282\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/eiseler.de\/wordpress\/?p=1282&amp;share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1282\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/eiseler.de\/wordpress\/?p=1282&amp;share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-pocket\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-pocket sd-button share-icon\" href=\"http:\/\/eiseler.de\/wordpress\/?p=1282&amp;share=pocket\" target=\"_blank\" title=\"Click to share on Pocket\"><span>Pocket<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[1],"tags":[],"class_list":["post-1282","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8zAuQ-kG","jetpack-related-posts":[{"id":123,"url":"http:\/\/eiseler.de\/wordpress\/?p=123","url_meta":{"origin":1282,"position":0},"title":"iLOS 2.1 finished","date":"28\/01\/2011","format":false,"excerpt":"Good news about iLOS 2.1 and also iLOE. Today we finished iLOS 2.1 with 2 new features. The user definied search can now be easiliy extended. As you see in the picture above 2 new keys made it by now: natural and craft. The server database will soon get all\u2026","rel":"","context":"In &quot;iOS App&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":340,"url":"http:\/\/eiseler.de\/wordpress\/?p=340","url_meta":{"origin":1282,"position":1},"title":"Easy Arduino LED Clock","date":"31\/03\/2013","format":false,"excerpt":"How to build an easy arduino clock. Why building a clock, since one can buy all kind of clocks? Two causes, first for the fun of it and second I can build the functions as I like and how they work. I also plan to add more functions from time\u2026","rel":"","context":"In &quot;Arduino&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/eiseler.de\/wordpress\/wp-content\/uploads\/2013\/03\/IMG_4312-Kopie-300x257.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":844,"url":"http:\/\/eiseler.de\/wordpress\/?p=844","url_meta":{"origin":1282,"position":2},"title":"A Dockerfile for Oracle and perl","date":"27\/06\/2017","format":false,"excerpt":"I didn'f find a dockerfile for oracle and perl. So I did one by myself. Quick Instructions: Create dir; Create Dockerfile (above); create oracle_test.pl (above), download the oracle files. Build it: docker build -t perl-oracle . Run it: docker run -it --rm perl-oracle I took http:\/\/www.ecliptik.com\/Containerizing-a-Perl-Script\/ as the base and\u2026","rel":"","context":"In &quot;Docker&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":437,"url":"http:\/\/eiseler.de\/wordpress\/?p=437","url_meta":{"origin":1282,"position":3},"title":"Grove Tick Tock Shield Kit","date":"04\/11\/2013","format":false,"excerpt":"Giving the Tick Tock Shield Kit by Grove a try, I made same changes to the real time clock code. First I wanted to automaticaly change the brightness not only at the start of the code. And second I wanted the date to displayed to. Now it displays alternately with\u2026","rel":"","context":"In &quot;Arduino&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":12,"url":"http:\/\/eiseler.de\/wordpress\/?p=12","url_meta":{"origin":1282,"position":4},"title":"iLOE\u2018s back in town","date":"30\/06\/2011","format":false,"excerpt":"Today apple reviewed the new iLOE Version 1.9.4 so I could put it back in the store. If you are interested in iOS programming what happened? If you use a class from a external lib just in a xib there seems to be a chance that the compiler\/linker while optimizing\u2026","rel":"","context":"In &quot;iOS App&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1049,"url":"http:\/\/eiseler.de\/wordpress\/?p=1049","url_meta":{"origin":1282,"position":5},"title":"Arduino mirror image, orientation problem with display MAX7219","date":"13\/11\/2018","format":false,"excerpt":"How to use MAX7219 LED Matrix with Arduino https:\/\/youtu.be\/eAqVJXKpj8I Good Libraries to use with the MAX7219 LED are: https:\/\/github.com\/MajicDesigns\/MD_MAX72XX LED https:\/\/github.com\/MajicDesigns\/MD_Parola Scrolling You'll find lot's of examples after you install the libraries in the Arduino IDE. Arduino mirror image, orientation problem with display MAX7219 How to solve problem with the\u2026","rel":"","context":"In &quot;Arduino&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/eiseler.de\/wordpress\/wp-content\/uploads\/2018\/11\/img_8469.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1282"}],"version-history":[{"count":2,"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1282\/revisions"}],"predecessor-version":[{"id":1284,"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1282\/revisions\/1284"}],"wp:attachment":[{"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1282"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}