{"id":7093,"date":"2019-04-14T18:54:40","date_gmt":"2019-04-14T17:54:40","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=7093&#038;lang=en"},"modified":"2019-04-14T19:04:15","modified_gmt":"2019-04-14T18:04:15","slug":"create-useroptions","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=7093","title":{"rendered":"Create UserOption"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><code>Insert Into [UserOptions] ([DBId], [UserId], [Variable], [Value])  <br> Select -1 as [ResDBId], [User].[Id] as [ResUserId], 'BehaviourAcctEntries' as [ResVariable], '2' as [ResValue] from [User] LEFT JOIN [UserOptions] ON ([User].[Id] = [UserOptions].[UserId] and [UserOptions].[Variable] = 'BehaviourAcctEntries')<br> where [UserOptions].[UserId] Is Null<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Insert Into [UserOptions] ([DBId], [UserId], [Variable], [Value]) Select -1 as [ResDBId], [User].[Id] as [ResUserId], &#8216;BehaviourAcctEntries&#8217; as [ResVariable], &#8216;2&#8217; as [ResValue] from [User] LEFT JOIN [UserOptions] ON ([User].[Id] = [UserOptions].[UserId] and [UserOptions].[Variable] = &#8216;BehaviourAcctEntries&#8217;) where [UserOptions].[UserId] Is Null<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7093","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/7093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7093"}],"version-history":[{"count":6,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/7093\/revisions"}],"predecessor-version":[{"id":7100,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/7093\/revisions\/7100"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}