https://dbxlite.com/_next/static/chunks/app/docs/%5Bslug%5D/page-394f4d4de01456b2.js

1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[121,308],{49729:function(e,t,r){Promise.resolve().then(r.t.bind(r,87639,23)),Promise.resolve().then(r.bind(r,82129))},82129:function(e,t,r){"use strict";r.d(t,{MDXContent:function(){return d}});var a=r(80752),n=r(62817),s=r(45262),l=r(39970);function o(e){let{chart:t,className:r=""}=e,n=(0,s.useRef)(null),[o,i]=(0,s.useState)(""),[d,c]=(0,s.useState)(null);return((0,s.useEffect)(()=>{(async()=>{if(n.current)try{let e="mermaid-".concat(Math.random().toString(36).substr(2,9)),{svg:r}=await l.Z.render(e,t);i(r),c(null)}catch(e){console.error("Mermaid render error:",e),c("Failed to render diagram")}})()},[t]),d)?(0,a.jsx)("div",{className:"p-4 bg-red-50 dark:bg-red-900/20 text-red-600 dark:text-red-400 rounded-lg",children:d}):(0,a.jsx)("div",{ref:n,className:"mermaid-container overflow-x-auto ".concat(r),dangerouslySetInnerHTML:{__html:o}})}l.Z.initialize({startOnLoad:!1,theme:"neutral",securityLevel:"loose",fontFamily:"Inter, system-ui, sans-serif"});let i={h2:function(e){let{children:t,...r}=e;return(0,a.jsx)("h2",{className:"text-2xl font-bold text-slate-900 dark:text-white mt-16 mb-6 pb-3 border-b-2 border-primary-500",...r,children:t})},h3:function(e){let{children:t,...r}=e;return(0,a.jsx)("h3",{className:"text-xl font-bold text-slate-800 dark:text-slate-100 mt-10 mb-4",...r,children:t})},p:function(e){let{children:t,...r}=e;return(0,a.jsx)("p",{className:"text-slate-600 dark:text-slate-400 my-4 leading-7",...r,children:t})},pre:function(e){var t;let{children:r,...n}=e;if((null==r?void 0:null===(t=r.props)||void 0===t?void 0:t.className)==="language-mermaid"){let e=r.props.children;return(0,a.jsx)(o,{chart:e,className:"my-8"})}return(0,a.jsx)("pre",{...n,className:"my-6 p-4 rounded-xl overflow-x-auto bg-slate-900 dark:bg-slate-950 border border-slate-700 shadow-lg",children:r})},code:function(e){let{children:t,className:r,...n}=e;return r?(0,a.jsx)("code",{className:"text-sm text-slate-300 font-mono leading-relaxed",...n,children:t}):(0,a.jsx)("code",{className:"text-primary-600 dark:text-primary-400 bg-slate-100 dark:bg-slate-800 px-1.5 py-0.5 rounded text-sm font-mono",...n,children:t})},table:function(e){let{children:t,...r}=e;return(0,a.jsx)("div",{className:"my-8 overflow-x-auto rounded-xl border border-slate-200 dark:border-slate-700 shadow-sm",children:(0,a.jsx)("table",{className:"min-w-full divide-y divide-slate-200 dark:divide-slate-700",...r,children:t})})},thead:function(e){let{children:t,...r}=e;return(0,a.jsx)("thead",{className:"bg-slate-50 dark:bg-slate-800",...r,children:t})},tbody:function(e){let{children:t,...r}=e;return(0,a.jsx)("tbody",{className:"divide-y divide-slate-200 dark:divide-slate-700 bg-white dark:bg-slate-900",...r,children:t})},th:function(e){let{children:t,...r}=e;return(0,a.jsx)("th",{className:"px-4 py-3 text-left text-xs font-semibold text-slate-600 dark:text-slate-300 uppercase tracking-wider bg-slate-50 dark:bg-slate-800",...r,children:t})},td:function(e){let{children:t,...r}=e;return(0,a.jsx)("td",{className:"px-4 py-3 text-sm text-slate-600 dark:text-slate-400",...r,children:t})},tr:function(e){let{children:t,...r}=e;return(0,a.jsx)("tr",{className:"hover:bg-slate-50 dark:hover:bg-slate-800/50 transition-colors",...r,children:t})},ul:function(e){let{children:t,...r}=e;return(0,a.jsx)("ul",{className:"my-6 space-y-3 text-slate-600 dark:text-slate-400 list-disc list-outside pl-6",...r,children:t})},ol:function(e){let{children:t,...r}=e;return(0,a.jsx)("ol",{className:"my-6 space-y-3 text-slate-600 dark:text-slate-400 list-decimal list-outside pl-6",...r,children:t})},li:function(e){let{children:t,...r}=e;return(0,a.jsx)("li",{className:"leading-7",...r,children:t})},a:function(e){let{children:t,href:r,...n}=e;return(0,a.jsx)("a",{href:r,className:"text-primary-600 dark:text-primary-400 font-medium hover:underline",...n,children:t})},strong:function(e){let{children:t,...r}=e;return(0,a.jsx)("strong",{className:"font-semibold text-slate-900 dark:text-slate-100",...r,children:t})},ExampleLinks:function(e){let{example:t,theme:r="dracula"}=e,n="https://sql.dbxlite.com",s="".concat(n,"/?example=").concat(t,"&theme=").concat(r),l="".concat(n,"/?example=").concat(t,"&run=true&theme=").concat(r);return(0,a.jsxs)("div",{className:"flex flex-wrap gap-3 my-4",children:[(0,a.jsxs)("a",{href:s,target:"_blank",rel:"noopener noreferrer",className:"inline-flex items-center gap-2 px-4 py-2 rounded-lg text-sm font-medium border-2 border-slate-300 dark:border-slate-600 text-slate-700 dark:text-slate-300 hover:border-primary-500 hover:text-primary-600 dark:hover:text-primary-400 transition-all hover:shadow-md",children:[(0,a.jsx)("svg",{className:"w-4 h-4",fill:"none",viewBox:"0 0 24 24",stroke:"currentColor",children:(0,a.jsx)("path",{strokeLinecap:"round",strokeLinejoin:"round",strokeWidth:2,d:"M10 6H6a2 2 0 00-2 2v10a2 2 0 002 2h10a2 2 0 002-2v-4M14 4h6m0 0v6m0-6L10 14"})}),"Open Example"]}),(0,a.jsxs)("a",{href:l,target:"_blank",rel:"noopener noreferrer",className:"inline-flex items-center gap-2 px-4 py-2 rounded-lg text-sm font-semibold bg-primary-500 hover:bg-primary-600 text-white transition-all shadow-md hover:shadow-lg no-underline hover:no-underline",style:{color:"white"},children:[(0,a.jsxs)("svg",{className:"w-4 h-4",fill:"none",viewBox:"0 0 24 24",stroke:"currentColor",children:[(0,a.jsx)("path",{strokeLinecap:"round",strokeLinejoin:"round",strokeWidth:2,d:"M14.752 11.168l-3.197-2.132A1 1 0 0010 9.87v4.263a1 1 0 001.555.832l3.197-2.132a1 1 0 000-1.664z"}),(0,a.jsx)("path",{strokeLinecap:"round",strokeLinejoin:"round",strokeWidth:2,d:"M21 12a9 9 0 11-18 0 9 9 0 0118 0z"})]}),"Open & Run"]}

1)]})},Bookmarklet:function(){return(0,a.jsxs)("div",{className:"my-4 p-4 bg-slate-100 dark:bg-slate-800 rounded-lg",children:[(0,a.jsxs)("p",{className:"text-sm text-slate-600 dark:text-slate-400 mb-3",children:[(0,a.jsx)("strong",{className:"font-semibold text-slate-900 dark:text-slate-100",children:"How to install:"})," Click and drag the button below to your bookmarks bar. (Show bookmarks bar: Cmd+Shift+B on Mac, Ctrl+Shift+B on Windows)"]}),(0,a.jsxs)("a",{href:"javascript:(function(){var m=location.href.match(/gist\\.github\\.com\\/[^\\/]+\\/([a-f0-9]+)/);if(m)window.open('https://sql.dbxlite.com/?share=gist:'+m[1]+'&run=true');else alert('Not a gist page')})();",className:"inline-flex items-center gap-2 px-4 py-2 rounded-lg text-sm font-semibold bg-gradient-to-r from-primary-500 to-cyan-500 text-white hover:from-primary-600 hover:to-cyan-600 transition-all shadow-md cursor-grab",onClick:e=>e.preventDefault(),children:[(0,a.jsx)("svg",{className:"w-4 h-4",fill:"none",viewBox:"0 0 24 24",stroke:"currentColor",children:(0,a.jsx)("path",{strokeLinecap:"round",strokeLinejoin:"round",strokeWidth:2,d:"M5 5a2 2 0 012-2h10a2 2 0 012 2v16l-7-3.5L5 21V5z"})}),"Run in dbxlite"]})]})}};function d(e){let{code:t}=e,r=(0,n.z)(t);return(0,a.jsx)(r,{components:i})}}},function(e){e.O(0,[578,4233,7639,4455,3305,2410,1744],function(){return e(e.s=49729)}),_N_E=e.O()}]);