3 <html lang=
"en" class=
"no-js">
7 <meta name=
"viewport" content=
"width=device-width,initial-scale=1">
11 <link rel=
"canonical" href=
"https://docs.woltlab.com/6.0/package/pip/sql/">
14 <link rel=
"prev" href=
"../smiley/">
17 <link rel=
"next" href=
"../style/">
19 <link rel=
"icon" href=
"../../../assets/default.favicon.ico">
20 <meta name=
"generator" content=
"mkdocs-1.4.3, mkdocs-material-9.1.16">
24 <title>sql - WoltLab Suite Documentation
</title>
28 <link rel=
"stylesheet" href=
"../../../assets/stylesheets/main.26e3688c.min.css">
31 <link rel=
"stylesheet" href=
"../../../assets/stylesheets/palette.ecc896b0.min.css">
41 <link rel=
"stylesheet" href=
"../../../stylesheets/extra.css">
43 <script>__md_scope=new URL(
"../../..",location),__md_hash=e=
>[...e].reduce((e,_)=
>(e<
<5)-e+_.charCodeAt(
0),
0),__md_get=(e,_=localStorage,t=__md_scope)=
>JSON.parse(_.getItem(t.pathname+
"."+e)),__md_set=(e,_,t=localStorage,a=__md_scope)=
>{try{t.setItem(a.pathname+
"."+e,JSON.stringify(_))}catch(e){}}
</script>
58 <body dir=
"ltr" data-md-color-scheme=
"default" data-md-color-primary=
"teal" data-md-color-accent=
"indigo">
62 <input class=
"md-toggle" data-md-toggle=
"drawer" type=
"checkbox" id=
"__drawer" autocomplete=
"off">
63 <input class=
"md-toggle" data-md-toggle=
"search" type=
"checkbox" id=
"__search" autocomplete=
"off">
64 <label class=
"md-overlay" for=
"__drawer"></label>
65 <div data-md-component=
"skip">
68 <a href=
"#sql-package-installation-plugin" class=
"md-skip">
73 <div data-md-component=
"announce">
75 <aside class=
"md-banner">
76 <div class=
"md-banner__inner md-grid md-typeset">
79 <a href=
"https://www.woltlab.com">Back to
<strong>woltlab.com
</strong></a>
87 <div data-md-color-scheme=
"default" data-md-component=
"outdated" hidden
>
96 <header class=
"md-header md-header--shadow" data-md-component=
"header">
97 <nav class=
"md-header__inner md-grid" aria-label=
"Header">
98 <a href=
"../../.." title=
"WoltLab Suite Documentation" class=
"md-header__button md-logo" aria-label=
"WoltLab Suite Documentation" data-md-component=
"logo">
100 <img src=
"../../../assets/logo.png" alt=
"logo">
103 <label class=
"md-header__button md-icon" for=
"__drawer">
104 <svg xmlns=
"http://www.w3.org/2000/svg" viewBox=
"0 0 24 24"><path d=
"M3 6h18v2H3V6m0 5h18v2H3v-2m0 5h18v2H3v-2Z"/></svg>
106 <div class=
"md-header__title" data-md-component=
"header-title">
107 <div class=
"md-header__ellipsis">
108 <div class=
"md-header__topic">
109 <span class=
"md-ellipsis">
110 WoltLab Suite Documentation
113 <div class=
"md-header__topic" data-md-component=
"header-topic">
114 <span class=
"md-ellipsis">
127 <label class=
"md-header__button md-icon" for=
"__search">
128 <svg xmlns=
"http://www.w3.org/2000/svg" viewBox=
"0 0 24 24"><path d=
"M9.5 3A6.5 6.5 0 0 1 16 9.5c0 1.61-.59 3.09-1.56 4.23l.27.27h.79l5 5-1.5 1.5-5-5v-.79l-.27-.27A6.516 6.516 0 0 1 9.5 16 6.5 6.5 0 0 1 3 9.5 6.5 6.5 0 0 1 9.5 3m0 2C7 5 5 7 5 9.5S7 14 9.5 14 14 12 14 9.5 12 5 9.5 5Z"/></svg>
130 <div class=
"md-search" data-md-component=
"search" role=
"dialog">
131 <label class=
"md-search__overlay" for=
"__search"></label>
132 <div class=
"md-search__inner" role=
"search">
133 <form class=
"md-search__form" name=
"search">
134 <input type=
"text" class=
"md-search__input" name=
"query" aria-label=
"Search" placeholder=
"Search" autocapitalize=
"off" autocorrect=
"off" autocomplete=
"off" spellcheck=
"false" data-md-component=
"search-query" required
>
135 <label class=
"md-search__icon md-icon" for=
"__search">
136 <svg xmlns=
"http://www.w3.org/2000/svg" viewBox=
"0 0 24 24"><path d=
"M9.5 3A6.5 6.5 0 0 1 16 9.5c0 1.61-.59 3.09-1.56 4.23l.27.27h.79l5 5-1.5 1.5-5-5v-.79l-.27-.27A6.516 6.516 0 0 1 9.5 16 6.5 6.5 0 0 1 3 9.5 6.5 6.5 0 0 1 9.5 3m0 2C7 5 5 7 5 9.5S7 14 9.5 14 14 12 14 9.5 12 5 9.5 5Z"/></svg>
137 <svg xmlns=
"http://www.w3.org/2000/svg" viewBox=
"0 0 24 24"><path d=
"M20 11v2H8l5.5 5.5-1.42 1.42L4.16 12l7.92-7.92L13.5 5.5 8 11h12Z"/></svg>
139 <nav class=
"md-search__options" aria-label=
"Search">
141 <button type=
"reset" class=
"md-search__icon md-icon" title=
"Clear" aria-label=
"Clear" tabindex=
"-1">
142 <svg xmlns=
"http://www.w3.org/2000/svg" viewBox=
"0 0 24 24"><path d=
"M19 6.41 17.59 5 12 10.59 6.41 5 5 6.41 10.59 12 5 17.59 6.41 19 12 13.41 17.59 19 19 17.59 13.41 12 19 6.41Z"/></svg>
147 <div class=
"md-search__output">
148 <div class=
"md-search__scrollwrap" data-md-scrollfix
>
149 <div class=
"md-search-result" data-md-component=
"search-result">
150 <div class=
"md-search-result__meta">
153 <ol class=
"md-search-result__list" role=
"presentation"></ol>
161 <div class=
"md-header__source">
162 <a href=
"https://github.com/WoltLab/docs.woltlab.com/" title=
"Go to repository" class=
"md-source" data-md-component=
"source">
163 <div class=
"md-source__icon md-icon">
165 <svg xmlns=
"http://www.w3.org/2000/svg" viewBox=
"0 0 448 512"><!--! Font Awesome Free 6.4.0 by @fontawesome - https://fontawesome.com License - https://fontawesome.com/license/free (Icons: CC BY 4.0, Fonts: SIL OFL 1.1, Code: MIT License) Copyright 2023 Fonticons, Inc.--><path d=
"M439.55 236.05 244 40.45a28.87 28.87 0 0 0-40.81 0l-40.66 40.63 51.52 51.52c27.06-9.14 52.68 16.77 43.39 43.68l49.66 49.66c34.23-11.8 61.18 31 35.47 56.69-26.49 26.49-70.21-2.87-56-37.34L240.22 199v121.85c25.3 12.54 22.26 41.85 9.08 55a34.34 34.34 0 0 1-48.55 0c-17.57-17.6-11.07-46.91 11.25-56v-123c-20.8-8.51-24.6-30.74-18.64-45L142.57 101 8.45 235.14a28.86 28.86 0 0 0 0 40.81l195.61 195.6a28.86 28.86 0 0 0 40.8 0l194.69-194.69a28.86 28.86 0 0 0 0-40.81z"/></svg>
167 <div class=
"md-source__repository">
177 <div class=
"md-container" data-md-component=
"container">
184 <main class=
"md-main" data-md-component=
"main">
185 <div class=
"md-main__inner md-grid">
189 <div class=
"md-sidebar md-sidebar--primary" data-md-component=
"sidebar" data-md-type=
"navigation" >
190 <div class=
"md-sidebar__scrollwrap">
191 <div class=
"md-sidebar__inner">
195 <nav class=
"md-nav md-nav--primary" aria-label=
"Navigation" data-md-level=
"0">
196 <label class=
"md-nav__title" for=
"__drawer">
197 <a href=
"../../.." title=
"WoltLab Suite Documentation" class=
"md-nav__button md-logo" aria-label=
"WoltLab Suite Documentation" data-md-component=
"logo">
199 <img src=
"../../../assets/logo.png" alt=
"logo">
202 WoltLab Suite Documentation
205 <div class=
"md-nav__source">
206 <a href=
"https://github.com/WoltLab/docs.woltlab.com/" title=
"Go to repository" class=
"md-source" data-md-component=
"source">
207 <div class=
"md-source__icon md-icon">
209 <svg xmlns=
"http://www.w3.org/2000/svg" viewBox=
"0 0 448 512"><!--! Font Awesome Free 6.4.0 by @fontawesome - https://fontawesome.com License - https://fontawesome.com/license/free (Icons: CC BY 4.0, Fonts: SIL OFL 1.1, Code: MIT License) Copyright 2023 Fonticons, Inc.--><path d=
"M439.55 236.05 244 40.45a28.87 28.87 0 0 0-40.81 0l-40.66 40.63 51.52 51.52c27.06-9.14 52.68 16.77 43.39 43.68l49.66 49.66c34.23-11.8 61.18 31 35.47 56.69-26.49 26.49-70.21-2.87-56-37.34L240.22 199v121.85c25.3 12.54 22.26 41.85 9.08 55a34.34 34.34 0 0 1-48.55 0c-17.57-17.6-11.07-46.91 11.25-56v-123c-20.8-8.51-24.6-30.74-18.64-45L142.57 101 8.45 235.14a28.86 28.86 0 0 0 0 40.81l195.61 195.6a28.86 28.86 0 0 0 40.8 0l194.69-194.69a28.86 28.86 0 0 0 0-40.81z"/></svg>
211 <div class=
"md-source__repository">
217 <ul class=
"md-nav__list" data-md-scrollfix
>
226 <li class=
"md-nav__item">
227 <a href=
"../../../getting-started/" class=
"md-nav__link">
242 <li class=
"md-nav__item md-nav__item--nested">
247 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_2" >
251 <label class=
"md-nav__link" for=
"__nav_2" id=
"__nav_2_label" tabindex=
"0">
253 <span class=
"md-nav__icon md-icon"></span>
256 <nav class=
"md-nav" data-md-level=
"1" aria-labelledby=
"__nav_2_label" aria-expanded=
"false">
257 <label class=
"md-nav__title" for=
"__nav_2">
258 <span class=
"md-nav__icon md-icon"></span>
261 <ul class=
"md-nav__list" data-md-scrollfix
>
268 <li class=
"md-nav__item">
269 <a href=
"../../../php/pages/" class=
"md-nav__link">
282 <li class=
"md-nav__item">
283 <a href=
"../../../php/database-objects/" class=
"md-nav__link">
296 <li class=
"md-nav__item">
297 <a href=
"../../../php/database-access/" class=
"md-nav__link">
310 <li class=
"md-nav__item">
311 <a href=
"../../../php/exceptions/" class=
"md-nav__link">
325 <li class=
"md-nav__item md-nav__item--nested">
330 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_2_5" >
334 <label class=
"md-nav__link" for=
"__nav_2_5" id=
"__nav_2_5_label" tabindex=
"0">
336 <span class=
"md-nav__icon md-icon"></span>
339 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_2_5_label" aria-expanded=
"false">
340 <label class=
"md-nav__title" for=
"__nav_2_5">
341 <span class=
"md-nav__icon md-icon"></span>
344 <ul class=
"md-nav__list" data-md-scrollfix
>
352 <li class=
"md-nav__item md-nav__item--nested">
357 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_2_5_1" >
361 <label class=
"md-nav__link" for=
"__nav_2_5_1" id=
"__nav_2_5_1_label" tabindex=
"0">
363 <span class=
"md-nav__icon md-icon"></span>
366 <nav class=
"md-nav" data-md-level=
"3" aria-labelledby=
"__nav_2_5_1_label" aria-expanded=
"false">
367 <label class=
"md-nav__title" for=
"__nav_2_5_1">
368 <span class=
"md-nav__icon md-icon"></span>
371 <ul class=
"md-nav__list" data-md-scrollfix
>
378 <li class=
"md-nav__item">
379 <a href=
"../../../php/api/caches/" class=
"md-nav__link">
392 <li class=
"md-nav__item">
393 <a href=
"../../../php/api/caches_persistent-caches/" class=
"md-nav__link">
406 <li class=
"md-nav__item">
407 <a href=
"../../../php/api/caches_runtime-caches/" class=
"md-nav__link">
427 <li class=
"md-nav__item">
428 <a href=
"../../../php/api/comments/" class=
"md-nav__link">
441 <li class=
"md-nav__item">
442 <a href=
"../../../php/api/cronjobs/" class=
"md-nav__link">
455 <li class=
"md-nav__item">
456 <a href=
"../../../php/api/events/" class=
"md-nav__link">
470 <li class=
"md-nav__item md-nav__item--nested">
475 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_2_5_5" >
479 <label class=
"md-nav__link" for=
"__nav_2_5_5" id=
"__nav_2_5_5_label" tabindex=
"0">
481 <span class=
"md-nav__icon md-icon"></span>
484 <nav class=
"md-nav" data-md-level=
"3" aria-labelledby=
"__nav_2_5_5_label" aria-expanded=
"false">
485 <label class=
"md-nav__title" for=
"__nav_2_5_5">
486 <span class=
"md-nav__icon md-icon"></span>
489 <ul class=
"md-nav__list" data-md-scrollfix
>
496 <li class=
"md-nav__item">
497 <a href=
"../../../php/api/form_builder/overview/" class=
"md-nav__link">
510 <li class=
"md-nav__item">
511 <a href=
"../../../php/api/form_builder/structure/" class=
"md-nav__link">
524 <li class=
"md-nav__item">
525 <a href=
"../../../php/api/form_builder/form_fields/" class=
"md-nav__link">
538 <li class=
"md-nav__item">
539 <a href=
"../../../php/api/form_builder/validation_data/" class=
"md-nav__link">
552 <li class=
"md-nav__item">
553 <a href=
"../../../php/api/form_builder/dependencies/" class=
"md-nav__link">
573 <li class=
"md-nav__item">
574 <a href=
"../../../php/api/package_installation_plugins/" class=
"md-nav__link">
575 Package Installation Plugins
587 <li class=
"md-nav__item">
588 <a href=
"../../../php/api/user_activity_points/" class=
"md-nav__link">
601 <li class=
"md-nav__item">
602 <a href=
"../../../php/api/user_notifications/" class=
"md-nav__link">
615 <li class=
"md-nav__item">
616 <a href=
"../../../php/api/sitemaps/" class=
"md-nav__link">
636 <li class=
"md-nav__item">
637 <a href=
"../../../php/code-style/" class=
"md-nav__link">
650 <li class=
"md-nav__item">
651 <a href=
"../../../php/apps/" class=
"md-nav__link">
664 <li class=
"md-nav__item">
665 <a href=
"../../../php/gdpr/" class=
"md-nav__link">
687 <li class=
"md-nav__item md-nav__item--nested">
692 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_3" >
696 <label class=
"md-nav__link" for=
"__nav_3" id=
"__nav_3_label" tabindex=
"0">
697 Languages, Templates & CSS
698 <span class=
"md-nav__icon md-icon"></span>
701 <nav class=
"md-nav" data-md-level=
"1" aria-labelledby=
"__nav_3_label" aria-expanded=
"false">
702 <label class=
"md-nav__title" for=
"__nav_3">
703 <span class=
"md-nav__icon md-icon"></span>
704 Languages, Templates & CSS
706 <ul class=
"md-nav__list" data-md-scrollfix
>
713 <li class=
"md-nav__item">
714 <a href=
"../../../view/languages/" class=
"md-nav__link">
727 <li class=
"md-nav__item">
728 <a href=
"../../../view/templates/" class=
"md-nav__link">
741 <li class=
"md-nav__item">
742 <a href=
"../../../view/template-modifiers/" class=
"md-nav__link">
755 <li class=
"md-nav__item">
756 <a href=
"../../../view/template-plugins/" class=
"md-nav__link">
769 <li class=
"md-nav__item">
770 <a href=
"../../../view/css/" class=
"md-nav__link">
792 <li class=
"md-nav__item md-nav__item--nested">
797 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_4" >
801 <label class=
"md-nav__link" for=
"__nav_4" id=
"__nav_4_label" tabindex=
"0">
802 TypeScript and JavaScript API
803 <span class=
"md-nav__icon md-icon"></span>
806 <nav class=
"md-nav" data-md-level=
"1" aria-labelledby=
"__nav_4_label" aria-expanded=
"false">
807 <label class=
"md-nav__title" for=
"__nav_4">
808 <span class=
"md-nav__icon md-icon"></span>
809 TypeScript and JavaScript API
811 <ul class=
"md-nav__list" data-md-scrollfix
>
818 <li class=
"md-nav__item">
819 <a href=
"../../../javascript/general-usage/" class=
"md-nav__link">
832 <li class=
"md-nav__item">
833 <a href=
"../../../javascript/typescript/" class=
"md-nav__link">
847 <li class=
"md-nav__item md-nav__item--nested">
852 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_4_3" >
856 <label class=
"md-nav__link" for=
"__nav_4_3" id=
"__nav_4_3_label" tabindex=
"0">
858 <span class=
"md-nav__icon md-icon"></span>
861 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_4_3_label" aria-expanded=
"false">
862 <label class=
"md-nav__title" for=
"__nav_4_3">
863 <span class=
"md-nav__icon md-icon"></span>
866 <ul class=
"md-nav__list" data-md-scrollfix
>
873 <li class=
"md-nav__item">
874 <a href=
"../../../javascript/components_confirmation/" class=
"md-nav__link">
887 <li class=
"md-nav__item">
888 <a href=
"../../../javascript/components_dialog/" class=
"md-nav__link">
901 <li class=
"md-nav__item">
902 <a href=
"../../../javascript/components_google_maps/" class=
"md-nav__link">
915 <li class=
"md-nav__item">
916 <a href=
"../../../javascript/components_pagination/" class=
"md-nav__link">
937 <li class=
"md-nav__item md-nav__item--nested">
942 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_4_4" >
946 <label class=
"md-nav__link" for=
"__nav_4_4" id=
"__nav_4_4_label" tabindex=
"0">
948 <span class=
"md-nav__icon md-icon"></span>
951 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_4_4_label" aria-expanded=
"false">
952 <label class=
"md-nav__title" for=
"__nav_4_4">
953 <span class=
"md-nav__icon md-icon"></span>
956 <ul class=
"md-nav__list" data-md-scrollfix
>
963 <li class=
"md-nav__item">
964 <a href=
"../../../javascript/new-api_writing-a-module/" class=
"md-nav__link">
977 <li class=
"md-nav__item">
978 <a href=
"../../../javascript/new-api_core/" class=
"md-nav__link">
991 <li class=
"md-nav__item">
992 <a href=
"../../../javascript/new-api_dom/" class=
"md-nav__link">
1005 <li class=
"md-nav__item">
1006 <a href=
"../../../javascript/new-api_events/" class=
"md-nav__link">
1019 <li class=
"md-nav__item">
1020 <a href=
"../../../javascript/new-api_ajax/" class=
"md-nav__link">
1033 <li class=
"md-nav__item">
1034 <a href=
"../../../javascript/new-api_dialogs/" class=
"md-nav__link">
1047 <li class=
"md-nav__item">
1048 <a href=
"../../../javascript/new-api_browser/" class=
"md-nav__link">
1049 Browser and Screen Sizes
1061 <li class=
"md-nav__item">
1062 <a href=
"../../../javascript/new-api_ui/" class=
"md-nav__link">
1082 <li class=
"md-nav__item">
1083 <a href=
"../../../javascript/legacy-api/" class=
"md-nav__link">
1096 <li class=
"md-nav__item">
1097 <a href=
"../../../javascript/code-snippets/" class=
"md-nav__link">
1121 <li class=
"md-nav__item md-nav__item--active md-nav__item--nested">
1126 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_5" checked
>
1130 <label class=
"md-nav__link" for=
"__nav_5" id=
"__nav_5_label" tabindex=
"0">
1132 <span class=
"md-nav__icon md-icon"></span>
1135 <nav class=
"md-nav" data-md-level=
"1" aria-labelledby=
"__nav_5_label" aria-expanded=
"true">
1136 <label class=
"md-nav__title" for=
"__nav_5">
1137 <span class=
"md-nav__icon md-icon"></span>
1140 <ul class=
"md-nav__list" data-md-scrollfix
>
1147 <li class=
"md-nav__item">
1148 <a href=
"../../package-xml/" class=
"md-nav__link">
1164 <li class=
"md-nav__item md-nav__item--active md-nav__item--nested">
1169 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_5_2" checked
>
1173 <label class=
"md-nav__link" for=
"__nav_5_2" id=
"__nav_5_2_label" tabindex=
"0">
1175 <span class=
"md-nav__icon md-icon"></span>
1178 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_5_2_label" aria-expanded=
"true">
1179 <label class=
"md-nav__title" for=
"__nav_5_2">
1180 <span class=
"md-nav__icon md-icon"></span>
1183 <ul class=
"md-nav__list" data-md-scrollfix
>
1190 <li class=
"md-nav__item">
1191 <a href=
"../" class=
"md-nav__link">
1204 <li class=
"md-nav__item">
1205 <a href=
"../acl-option/" class=
"md-nav__link">
1218 <li class=
"md-nav__item">
1219 <a href=
"../acp-menu/" class=
"md-nav__link">
1232 <li class=
"md-nav__item">
1233 <a href=
"../acp-search-provider/" class=
"md-nav__link">
1246 <li class=
"md-nav__item">
1247 <a href=
"../acp-template/" class=
"md-nav__link">
1260 <li class=
"md-nav__item">
1261 <a href=
"../acp-template-delete/" class=
"md-nav__link">
1274 <li class=
"md-nav__item">
1275 <a href=
"../bbcode/" class=
"md-nav__link">
1288 <li class=
"md-nav__item">
1289 <a href=
"../box/" class=
"md-nav__link">
1302 <li class=
"md-nav__item">
1303 <a href=
"../clipboard-action/" class=
"md-nav__link">
1316 <li class=
"md-nav__item">
1317 <a href=
"../core-object/" class=
"md-nav__link">
1330 <li class=
"md-nav__item">
1331 <a href=
"../cronjob/" class=
"md-nav__link">
1344 <li class=
"md-nav__item">
1345 <a href=
"../database/" class=
"md-nav__link">
1358 <li class=
"md-nav__item">
1359 <a href=
"../event-listener/" class=
"md-nav__link">
1372 <li class=
"md-nav__item">
1373 <a href=
"../file/" class=
"md-nav__link">
1386 <li class=
"md-nav__item">
1387 <a href=
"../file-delete/" class=
"md-nav__link">
1400 <li class=
"md-nav__item">
1401 <a href=
"../language/" class=
"md-nav__link">
1414 <li class=
"md-nav__item">
1415 <a href=
"../media-provider/" class=
"md-nav__link">
1428 <li class=
"md-nav__item">
1429 <a href=
"../menu/" class=
"md-nav__link">
1442 <li class=
"md-nav__item">
1443 <a href=
"../menu-item/" class=
"md-nav__link">
1456 <li class=
"md-nav__item">
1457 <a href=
"../object-type/" class=
"md-nav__link">
1470 <li class=
"md-nav__item">
1471 <a href=
"../object-type-definition/" class=
"md-nav__link">
1472 objectTypeDefinition
1484 <li class=
"md-nav__item">
1485 <a href=
"../option/" class=
"md-nav__link">
1498 <li class=
"md-nav__item">
1499 <a href=
"../page/" class=
"md-nav__link">
1512 <li class=
"md-nav__item">
1513 <a href=
"../pip/" class=
"md-nav__link">
1526 <li class=
"md-nav__item">
1527 <a href=
"../script/" class=
"md-nav__link">
1540 <li class=
"md-nav__item">
1541 <a href=
"../smiley/" class=
"md-nav__link">
1556 <li class=
"md-nav__item md-nav__item--active">
1558 <input class=
"md-nav__toggle md-toggle" type=
"checkbox" id=
"__toc">
1564 <label class=
"md-nav__link md-nav__link--active" for=
"__toc">
1566 <span class=
"md-nav__icon md-icon"></span>
1569 <a href=
"./" class=
"md-nav__link md-nav__link--active">
1575 <nav class=
"md-nav md-nav--secondary" aria-label=
"Table of contents">
1582 <label class=
"md-nav__title" for=
"__toc">
1583 <span class=
"md-nav__icon md-icon"></span>
1586 <ul class=
"md-nav__list" data-md-component=
"toc" data-md-scrollfix
>
1588 <li class=
"md-nav__item">
1589 <a href=
"#expected-value" class=
"md-nav__link">
1595 <li class=
"md-nav__item">
1596 <a href=
"#features" class=
"md-nav__link">
1600 <nav class=
"md-nav" aria-label=
"Features">
1601 <ul class=
"md-nav__list">
1603 <li class=
"md-nav__item">
1604 <a href=
"#logging" class=
"md-nav__link">
1610 <li class=
"md-nav__item">
1611 <a href=
"#instance-number" class=
"md-nav__link">
1617 <li class=
"md-nav__item">
1618 <a href=
"#table-type" class=
"md-nav__link">
1629 <li class=
"md-nav__item">
1630 <a href=
"#limitations" class=
"md-nav__link">
1634 <nav class=
"md-nav" aria-label=
"Limitations">
1635 <ul class=
"md-nav__list">
1637 <li class=
"md-nav__item">
1638 <a href=
"#logging_1" class=
"md-nav__link">
1644 <li class=
"md-nav__item">
1645 <a href=
"#triggers" class=
"md-nav__link">
1656 <li class=
"md-nav__item">
1657 <a href=
"#example" class=
"md-nav__link">
1677 <li class=
"md-nav__item">
1678 <a href=
"../style/" class=
"md-nav__link">
1691 <li class=
"md-nav__item">
1692 <a href=
"../template/" class=
"md-nav__link">
1705 <li class=
"md-nav__item">
1706 <a href=
"../template-delete/" class=
"md-nav__link">
1719 <li class=
"md-nav__item">
1720 <a href=
"../template-listener/" class=
"md-nav__link">
1733 <li class=
"md-nav__item">
1734 <a href=
"../user-group-option/" class=
"md-nav__link">
1747 <li class=
"md-nav__item">
1748 <a href=
"../user-menu/" class=
"md-nav__link">
1761 <li class=
"md-nav__item">
1762 <a href=
"../user-notification-event/" class=
"md-nav__link">
1763 userNotificationEvent
1775 <li class=
"md-nav__item">
1776 <a href=
"../user-option/" class=
"md-nav__link">
1789 <li class=
"md-nav__item">
1790 <a href=
"../user-profile-menu/" class=
"md-nav__link">
1810 <li class=
"md-nav__item">
1811 <a href=
"../../database-php-api/" class=
"md-nav__link">
1833 <li class=
"md-nav__item md-nav__item--nested">
1838 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_6" >
1842 <label class=
"md-nav__link" for=
"__nav_6" id=
"__nav_6_label" tabindex=
"0">
1844 <span class=
"md-nav__icon md-icon"></span>
1847 <nav class=
"md-nav" data-md-level=
"1" aria-labelledby=
"__nav_6_label" aria-expanded=
"false">
1848 <label class=
"md-nav__title" for=
"__nav_6">
1849 <span class=
"md-nav__icon md-icon"></span>
1852 <ul class=
"md-nav__list" data-md-scrollfix
>
1860 <li class=
"md-nav__item md-nav__item--nested">
1865 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_6_1" >
1869 <label class=
"md-nav__link" for=
"__nav_6_1" id=
"__nav_6_1_label" tabindex=
"0">
1870 From WoltLab Suite
5.5
1871 <span class=
"md-nav__icon md-icon"></span>
1874 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_6_1_label" aria-expanded=
"false">
1875 <label class=
"md-nav__title" for=
"__nav_6_1">
1876 <span class=
"md-nav__icon md-icon"></span>
1877 From WoltLab Suite
5.5
1879 <ul class=
"md-nav__list" data-md-scrollfix
>
1886 <li class=
"md-nav__item">
1887 <a href=
"../../../migration/wsc55/php/" class=
"md-nav__link">
1900 <li class=
"md-nav__item">
1901 <a href=
"../../../migration/wsc55/javascript/" class=
"md-nav__link">
1902 TypeScript and JavaScript
1914 <li class=
"md-nav__item">
1915 <a href=
"../../../migration/wsc55/templates/" class=
"md-nav__link">
1928 <li class=
"md-nav__item">
1929 <a href=
"../../../migration/wsc55/icons/" class=
"md-nav__link">
1942 <li class=
"md-nav__item">
1943 <a href=
"../../../migration/wsc55/dialogs/" class=
"md-nav__link">
1956 <li class=
"md-nav__item">
1957 <a href=
"../../../migration/wsc55/libraries/" class=
"md-nav__link">
1958 Third Party Libraries
1970 <li class=
"md-nav__item">
1971 <a href=
"../../../migration/wsc55/deprecations_removals/" class=
"md-nav__link">
1972 Deprecations and Removals
1992 <li class=
"md-nav__item md-nav__item--nested">
1997 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_6_2" >
2001 <label class=
"md-nav__link" for=
"__nav_6_2" id=
"__nav_6_2_label" tabindex=
"0">
2002 From WoltLab Suite
5.4
2003 <span class=
"md-nav__icon md-icon"></span>
2006 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_6_2_label" aria-expanded=
"false">
2007 <label class=
"md-nav__title" for=
"__nav_6_2">
2008 <span class=
"md-nav__icon md-icon"></span>
2009 From WoltLab Suite
5.4
2011 <ul class=
"md-nav__list" data-md-scrollfix
>
2018 <li class=
"md-nav__item">
2019 <a href=
"../../../migration/wsc54/php/" class=
"md-nav__link">
2032 <li class=
"md-nav__item">
2033 <a href=
"../../../migration/wsc54/javascript/" class=
"md-nav__link">
2034 TypeScript and JavaScript
2046 <li class=
"md-nav__item">
2047 <a href=
"../../../migration/wsc54/templates/" class=
"md-nav__link">
2060 <li class=
"md-nav__item">
2061 <a href=
"../../../migration/wsc54/libraries/" class=
"md-nav__link">
2062 Third Party Libraries
2074 <li class=
"md-nav__item">
2075 <a href=
"../../../migration/wsc54/deprecations_removals/" class=
"md-nav__link">
2076 Deprecations and Removals
2096 <li class=
"md-nav__item md-nav__item--nested">
2101 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_6_3" >
2105 <label class=
"md-nav__link" for=
"__nav_6_3" id=
"__nav_6_3_label" tabindex=
"0">
2106 From WoltLab Suite
5.3
2107 <span class=
"md-nav__icon md-icon"></span>
2110 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_6_3_label" aria-expanded=
"false">
2111 <label class=
"md-nav__title" for=
"__nav_6_3">
2112 <span class=
"md-nav__icon md-icon"></span>
2113 From WoltLab Suite
5.3
2115 <ul class=
"md-nav__list" data-md-scrollfix
>
2122 <li class=
"md-nav__item">
2123 <a href=
"../../../migration/wsc53/php/" class=
"md-nav__link">
2136 <li class=
"md-nav__item">
2137 <a href=
"../../../migration/wsc53/session/" class=
"md-nav__link">
2138 Session Handling and Authentication
2150 <li class=
"md-nav__item">
2151 <a href=
"../../../migration/wsc53/javascript/" class=
"md-nav__link">
2152 TypeScript and JavaScript
2164 <li class=
"md-nav__item">
2165 <a href=
"../../../migration/wsc53/templates/" class=
"md-nav__link">
2178 <li class=
"md-nav__item">
2179 <a href=
"../../../migration/wsc53/libraries/" class=
"md-nav__link">
2180 Third Party Libraries
2200 <li class=
"md-nav__item md-nav__item--nested">
2205 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_6_4" >
2209 <label class=
"md-nav__link" for=
"__nav_6_4" id=
"__nav_6_4_label" tabindex=
"0">
2210 From WoltLab Suite
5.2
2211 <span class=
"md-nav__icon md-icon"></span>
2214 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_6_4_label" aria-expanded=
"false">
2215 <label class=
"md-nav__title" for=
"__nav_6_4">
2216 <span class=
"md-nav__icon md-icon"></span>
2217 From WoltLab Suite
5.2
2219 <ul class=
"md-nav__list" data-md-scrollfix
>
2226 <li class=
"md-nav__item">
2227 <a href=
"../../../migration/wsc52/php/" class=
"md-nav__link">
2240 <li class=
"md-nav__item">
2241 <a href=
"../../../migration/wsc52/templates/" class=
"md-nav__link">
2242 Templates and Languages
2254 <li class=
"md-nav__item">
2255 <a href=
"../../../migration/wsc52/libraries/" class=
"md-nav__link">
2256 Third Party Libraries
2276 <li class=
"md-nav__item md-nav__item--nested">
2281 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_6_5" >
2285 <label class=
"md-nav__link" for=
"__nav_6_5" id=
"__nav_6_5_label" tabindex=
"0">
2286 From WoltLab Suite
3.1
2287 <span class=
"md-nav__icon md-icon"></span>
2290 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_6_5_label" aria-expanded=
"false">
2291 <label class=
"md-nav__title" for=
"__nav_6_5">
2292 <span class=
"md-nav__icon md-icon"></span>
2293 From WoltLab Suite
3.1
2295 <ul class=
"md-nav__list" data-md-scrollfix
>
2302 <li class=
"md-nav__item">
2303 <a href=
"../../../migration/wsc31/php/" class=
"md-nav__link">
2324 <li class=
"md-nav__item md-nav__item--nested">
2329 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_6_6" >
2333 <label class=
"md-nav__link" for=
"__nav_6_6" id=
"__nav_6_6_label" tabindex=
"0">
2334 From WoltLab Suite
3.0
2335 <span class=
"md-nav__icon md-icon"></span>
2338 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_6_6_label" aria-expanded=
"false">
2339 <label class=
"md-nav__title" for=
"__nav_6_6">
2340 <span class=
"md-nav__icon md-icon"></span>
2341 From WoltLab Suite
3.0
2343 <ul class=
"md-nav__list" data-md-scrollfix
>
2350 <li class=
"md-nav__item">
2351 <a href=
"../../../migration/wsc30/php/" class=
"md-nav__link">
2364 <li class=
"md-nav__item">
2365 <a href=
"../../../migration/wsc30/javascript/" class=
"md-nav__link">
2378 <li class=
"md-nav__item">
2379 <a href=
"../../../migration/wsc30/templates/" class=
"md-nav__link">
2392 <li class=
"md-nav__item">
2393 <a href=
"../../../migration/wsc30/css/" class=
"md-nav__link">
2406 <li class=
"md-nav__item">
2407 <a href=
"../../../migration/wsc30/package/" class=
"md-nav__link">
2428 <li class=
"md-nav__item md-nav__item--nested">
2433 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_6_7" >
2437 <label class=
"md-nav__link" for=
"__nav_6_7" id=
"__nav_6_7_label" tabindex=
"0">
2439 <span class=
"md-nav__icon md-icon"></span>
2442 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_6_7_label" aria-expanded=
"false">
2443 <label class=
"md-nav__title" for=
"__nav_6_7">
2444 <span class=
"md-nav__icon md-icon"></span>
2447 <ul class=
"md-nav__list" data-md-scrollfix
>
2454 <li class=
"md-nav__item">
2455 <a href=
"../../../migration/wcf21/php/" class=
"md-nav__link">
2468 <li class=
"md-nav__item">
2469 <a href=
"../../../migration/wcf21/templates/" class=
"md-nav__link">
2482 <li class=
"md-nav__item">
2483 <a href=
"../../../migration/wcf21/css/" class=
"md-nav__link">
2496 <li class=
"md-nav__item">
2497 <a href=
"../../../migration/wcf21/package/" class=
"md-nav__link">
2526 <li class=
"md-nav__item md-nav__item--nested">
2531 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_7" >
2535 <label class=
"md-nav__link" for=
"__nav_7" id=
"__nav_7_label" tabindex=
"0">
2537 <span class=
"md-nav__icon md-icon"></span>
2540 <nav class=
"md-nav" data-md-level=
"1" aria-labelledby=
"__nav_7_label" aria-expanded=
"false">
2541 <label class=
"md-nav__title" for=
"__nav_7">
2542 <span class=
"md-nav__icon md-icon"></span>
2545 <ul class=
"md-nav__list" data-md-scrollfix
>
2553 <li class=
"md-nav__item md-nav__item--nested">
2558 <input class=
"md-nav__toggle md-toggle " type=
"checkbox" id=
"__nav_7_1" >
2562 <label class=
"md-nav__link" for=
"__nav_7_1" id=
"__nav_7_1_label" tabindex=
"0">
2564 <span class=
"md-nav__icon md-icon"></span>
2567 <nav class=
"md-nav" data-md-level=
"2" aria-labelledby=
"__nav_7_1_label" aria-expanded=
"false">
2568 <label class=
"md-nav__title" for=
"__nav_7_1">
2569 <span class=
"md-nav__icon md-icon"></span>
2572 <ul class=
"md-nav__list" data-md-scrollfix
>
2579 <li class=
"md-nav__item">
2580 <a href=
"../../../tutorial/series/overview/" class=
"md-nav__link">
2593 <li class=
"md-nav__item">
2594 <a href=
"../../../tutorial/series/part_1/" class=
"md-nav__link">
2607 <li class=
"md-nav__item">
2608 <a href=
"../../../tutorial/series/part_2/" class=
"md-nav__link">
2621 <li class=
"md-nav__item">
2622 <a href=
"../../../tutorial/series/part_3/" class=
"md-nav__link">
2635 <li class=
"md-nav__item">
2636 <a href=
"../../../tutorial/series/part_4/" class=
"md-nav__link">
2649 <li class=
"md-nav__item">
2650 <a href=
"../../../tutorial/series/part_5/" class=
"md-nav__link">
2663 <li class=
"md-nav__item">
2664 <a href=
"../../../tutorial/series/part_6/" class=
"md-nav__link">
2693 <div class=
"md-sidebar md-sidebar--secondary" data-md-component=
"sidebar" data-md-type=
"toc" >
2694 <div class=
"md-sidebar__scrollwrap">
2695 <div class=
"md-sidebar__inner">
2698 <nav class=
"md-nav md-nav--secondary" aria-label=
"Table of contents">
2705 <label class=
"md-nav__title" for=
"__toc">
2706 <span class=
"md-nav__icon md-icon"></span>
2709 <ul class=
"md-nav__list" data-md-component=
"toc" data-md-scrollfix
>
2711 <li class=
"md-nav__item">
2712 <a href=
"#expected-value" class=
"md-nav__link">
2718 <li class=
"md-nav__item">
2719 <a href=
"#features" class=
"md-nav__link">
2723 <nav class=
"md-nav" aria-label=
"Features">
2724 <ul class=
"md-nav__list">
2726 <li class=
"md-nav__item">
2727 <a href=
"#logging" class=
"md-nav__link">
2733 <li class=
"md-nav__item">
2734 <a href=
"#instance-number" class=
"md-nav__link">
2740 <li class=
"md-nav__item">
2741 <a href=
"#table-type" class=
"md-nav__link">
2752 <li class=
"md-nav__item">
2753 <a href=
"#limitations" class=
"md-nav__link">
2757 <nav class=
"md-nav" aria-label=
"Limitations">
2758 <ul class=
"md-nav__list">
2760 <li class=
"md-nav__item">
2761 <a href=
"#logging_1" class=
"md-nav__link">
2767 <li class=
"md-nav__item">
2768 <a href=
"#triggers" class=
"md-nav__link">
2779 <li class=
"md-nav__item">
2780 <a href=
"#example" class=
"md-nav__link">
2795 <div class=
"md-content" data-md-component=
"content">
2796 <article class=
"md-content__inner md-typeset">
2804 <h1 id=
"sql-package-installation-plugin">SQL Package Installation Plugin
<a class=
"headerlink" href=
"#sql-package-installation-plugin" title=
"Permanent link">#
</a></h1>
2805 <p>Execute SQL instructions using a MySQL-flavored syntax.
</p>
2806 <div class=
"admonition warning">
2807 <p class=
"admonition-title">This file is parsed by WoltLab Suite Core to allow reverting of certain changes, but not every syntax MySQL supports is recognized by the parser. To avoid any troubles, you should always use statements relying on the SQL standard.
</p>
2809 <h2 id=
"expected-value">Expected Value
<a class=
"headerlink" href=
"#expected-value" title=
"Permanent link">#
</a></h2>
2810 <p>The
<code>sql
</code> package installation plugin expects a relative path to a
<code>.sql
</code> file.
</p>
2811 <h2 id=
"features">Features
<a class=
"headerlink" href=
"#features" title=
"Permanent link">#
</a></h2>
2812 <h3 id=
"logging">Logging
<a class=
"headerlink" href=
"#logging" title=
"Permanent link">#
</a></h3>
2813 <p>WoltLab Suite Core uses a SQL parser to extract queries and log certain actions.
2814 This allows WoltLab Suite Core to revert some of the changes you apply upon package uninstallation.
</p>
2815 <p>The logged changes are:
</p>
2817 <li><code>CREATE TABLE
</code></li>
2818 <li><code>ALTER TABLE … ADD COLUMN
</code></li>
2819 <li><code>ALTER TABLE … ADD … KEY
</code></li>
2821 <h3 id=
"instance-number">Instance Number
<a class=
"headerlink" href=
"#instance-number" title=
"Permanent link">#
</a></h3>
2822 <p>It is possible to use different instance numbers, e.g. two separate WoltLab Suite Core installations within one database.
2823 WoltLab Suite Core requires you to always use
<code>wcf1_
<tableName
></code> or
<code><app
>1_
<tableName
></code> (e.g.
<code>blog1_blog
</code> in WoltLab Suite Blog), the number (
<code>1</code>) will be automatically replaced prior to execution.
2824 If you every use anything other but
<code>1</code>, you will eventually break things, thus always use
<code>1</code>!
</p>
2825 <h3 id=
"table-type">Table Type
<a class=
"headerlink" href=
"#table-type" title=
"Permanent link">#
</a></h3>
2826 <p>WoltLab Suite Core will determine the type of database tables on its own:
2827 If the table contains a
<code>FULLTEXT
</code> index, it uses
<code>MyISAM
</code>, otherwise
<code>InnoDB
</code> is used.
</p>
2828 <h2 id=
"limitations">Limitations
<a class=
"headerlink" href=
"#limitations" title=
"Permanent link">#
</a></h2>
2829 <h3 id=
"logging_1">Logging
<a class=
"headerlink" href=
"#logging_1" title=
"Permanent link">#
</a></h3>
2830 <p>WoltLab Suite Core cannot revert changes to the database structure which would cause to the data to be either changed or new data to be incompatible with the original format.
2831 Additionally, WoltLab Suite Core does not track regular SQL queries such as
<code>DELETE
</code> or
<code>UPDATE
</code>.
</p>
2832 <h3 id=
"triggers">Triggers
<a class=
"headerlink" href=
"#triggers" title=
"Permanent link">#
</a></h3>
2833 <p>WoltLab Suite Core does not support trigger since MySQL does not support execution of triggers if the event was fired by a cascading foreign key action.
2834 If you really need triggers, you should consider adding them by custom SQL queries using a
<a href=
"../script/">script
</a>.
</p>
2835 <h2 id=
"example">Example
<a class=
"headerlink" href=
"#example" title=
"Permanent link">#
</a></h2>
2836 <p><code>package.xml
</code>:
</p>
2837 <div class=
"highlight"><table class=
"highlighttable"><tr><td class=
"linenos"><div class=
"linenodiv"><pre><span></span><span class=
"normal">1</span></pre></div></td><td class=
"code"><div><pre><span></span><code><span class=
"nt"><instruction
</span><span class=
"w"> </span><span class=
"na">type=
</span><span class=
"s">"sql
"</span><span class=
"nt">></span>install.sql
<span class=
"nt"></instruction
></span>
2838 </code></pre></div></td></tr></table></div>
2839 <p>Example content:
</p>
2840 <div class=
"highlight"><table class=
"highlighttable"><tr><th colspan=
"2" class=
"filename"><span class=
"filename">install.sql
<a class=
"codeBoxTitleGitHubLink" href=
"https://github.com/WoltLab/docs.woltlab.com/tree/6.0/snippets/package/pip/install.sql" title=
"View on GitHub"><span class=
"twemoji"><svg xmlns=
"http://www.w3.org/2000/svg" viewBox=
"0 0 24 24"><path d=
"M3.9 12c0-1.71 1.39-3.1 3.1-3.1h4V7H7a5 5 0 0 0-5 5 5 5 0 0 0 5 5h4v-1.9H7c-1.71 0-3.1-1.39-3.1-3.1M8 13h8v-2H8v2m9-6h-4v1.9h4c1.71 0 3.1 1.39 3.1 3.1 0 1.71-1.39 3.1-3.1 3.1h-4V17h4a5 5 0 0 0 5-5 5 5 0 0 0-5-5Z"/></svg></span></a></span></th></tr><tr><td class=
"linenos"><div class=
"linenodiv"><pre><span></span><span class=
"normal"> 1</span>
2841 <span class=
"normal"> 2</span>
2842 <span class=
"normal"> 3</span>
2843 <span class=
"normal"> 4</span>
2844 <span class=
"normal"> 5</span>
2845 <span class=
"normal"> 6</span>
2846 <span class=
"normal"> 7</span>
2847 <span class=
"normal"> 8</span>
2848 <span class=
"normal"> 9</span>
2849 <span class=
"normal">10</span></pre></div></td><td class=
"code"><div><pre><span></span><code><span class=
"k">CREATE
</span><span class=
"w"> </span><span class=
"k">TABLE
</span><span class=
"w"> </span><span class=
"n">wcf1_foo_bar
</span><span class=
"w"> </span><span class=
"p">(
</span>
2850 <span class=
"w"> </span><span class=
"n">fooID
</span><span class=
"w"> </span><span class=
"nb">INT
</span><span class=
"p">(
</span><span class=
"mi">10</span><span class=
"p">)
</span><span class=
"w"> </span><span class=
"k">NOT
</span><span class=
"w"> </span><span class=
"k">NULL
</span><span class=
"w"> </span><span class=
"n">AUTO_INCREMENT
</span><span class=
"w"> </span><span class=
"k">PRIMARY
</span><span class=
"w"> </span><span class=
"k">KEY
</span><span class=
"p">,
</span>
2851 <span class=
"w"> </span><span class=
"n">packageID
</span><span class=
"w"> </span><span class=
"nb">INT
</span><span class=
"p">(
</span><span class=
"mi">10</span><span class=
"p">)
</span><span class=
"w"> </span><span class=
"k">NOT
</span><span class=
"w"> </span><span class=
"k">NULL
</span><span class=
"p">,
</span>
2852 <span class=
"w"> </span><span class=
"n">bar
</span><span class=
"w"> </span><span class=
"nb">VARCHAR
</span><span class=
"p">(
</span><span class=
"mi">255</span><span class=
"p">)
</span><span class=
"w"> </span><span class=
"k">NOT
</span><span class=
"w"> </span><span class=
"k">NULL
</span><span class=
"w"> </span><span class=
"k">DEFAULT
</span><span class=
"w"> </span><span class=
"s1">''</span><span class=
"p">,
</span>
2853 <span class=
"w"> </span><span class=
"n">foobar
</span><span class=
"w"> </span><span class=
"nb">VARCHAR
</span><span class=
"p">(
</span><span class=
"mi">50</span><span class=
"p">)
</span><span class=
"w"> </span><span class=
"k">NOT
</span><span class=
"w"> </span><span class=
"k">NULL
</span><span class=
"w"> </span><span class=
"k">DEFAULT
</span><span class=
"w"> </span><span class=
"s1">''</span><span class=
"p">,
</span>
2855 <span class=
"w"> </span><span class=
"k">UNIQUE
</span><span class=
"w"> </span><span class=
"k">KEY
</span><span class=
"w"> </span><span class=
"n">baz
</span><span class=
"w"> </span><span class=
"p">(
</span><span class=
"n">bar
</span><span class=
"p">,
</span><span class=
"w"> </span><span class=
"n">foobar
</span><span class=
"p">)
</span>
2856 <span class=
"p">);
</span>
2858 <span class=
"k">ALTER
</span><span class=
"w"> </span><span class=
"k">TABLE
</span><span class=
"w"> </span><span class=
"n">wcf1_foo_bar
</span><span class=
"w"> </span><span class=
"k">ADD
</span><span class=
"w"> </span><span class=
"k">FOREIGN
</span><span class=
"w"> </span><span class=
"k">KEY
</span><span class=
"w"> </span><span class=
"p">(
</span><span class=
"n">packageID
</span><span class=
"p">)
</span><span class=
"w"> </span><span class=
"k">REFERENCES
</span><span class=
"w"> </span><span class=
"n">wcf1_package
</span><span class=
"w"> </span><span class=
"p">(
</span><span class=
"n">packageID
</span><span class=
"p">)
</span><span class=
"w"> </span><span class=
"k">ON
</span><span class=
"w"> </span><span class=
"k">DELETE
</span><span class=
"w"> </span><span class=
"k">CASCADE
</span><span class=
"p">;
</span>
2859 </code></pre></div></td></tr></table></div>
2862 <div class=
"md-source-file">
2884 <footer class=
"md-footer">
2886 <div class=
"md-footer-meta md-typeset">
2887 <div class=
"md-footer-meta__inner md-grid">
2888 <div class=
"md-copyright">
2890 <div class=
"md-copyright__highlight">
2891 Copyright ©
2020 WoltLab GmbH
2896 <a href=
"https://squidfunk.github.io/mkdocs-material/" target=
"_blank" rel=
"noopener">
2902 <div class=
"md-copyright">
2903 <a href=
"https://www.woltlab.com/legal-notice/">Legal Notice
</a>
2904 <a href=
"https://www.woltlab.com/privacy-policy/">Privacy Policy
</a>
2912 <div class=
"md-dialog" data-md-component=
"dialog">
2913 <div class=
"md-dialog__inner md-typeset"></div>
2916 <script id=
"__config" type=
"application/json">{
"base":
"../../..",
"features": [
"navigation.tracking"],
"search":
"../../../assets/javascripts/workers/search.208ed371.min.js",
"translations": {
"clipboard.copied":
"Copied to clipboard",
"clipboard.copy":
"Copy to clipboard",
"search.result.more.one":
"1 more on this page",
"search.result.more.other":
"# more on this page",
"search.result.none":
"No matching documents",
"search.result.one":
"1 matching document",
"search.result.other":
"# matching documents",
"search.result.placeholder":
"Type to start searching",
"search.result.term.missing":
"Missing",
"select.version":
"Select version"},
"version": {
"provider":
"mike"}}
</script>
2919 <script src=
"../../../assets/javascripts/bundle.a51614de.min.js"></script>