This is the Textpattern welcome article. You can delete or edit it and then start creating your own content.
\n\nThis is an excerpt for the welcome article.
', '', 'hope-for-the-future', 'meaningful-labor', 1, 'Comment', 1, 4, '1', '1', 'articles', '', '', '', 'welcome-to-textpattern', '', '', '', '', '', '', '', '', '', '', '[[secret]]', '[[regday]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]txp_category`
--
CREATE TABLE `[[dbprefix]]txp_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`type` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`parent` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`lft` int(11) NOT NULL DEFAULT '0',
`rgt` int(11) NOT NULL DEFAULT '0',
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`description` varchar(1023) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=9 ;
--
-- Dumping data for table `[[dbprefix]]txp_category`
--
INSERT INTO `[[dbprefix]]txp_category` VALUES
(1, 'root', 'article', '', 1, 8, 'root', ''),
(2, 'root', 'link', '', 1, 4, 'root', ''),
(3, 'root', 'image', '', 1, 2, 'root', ''),
(4, 'root', 'file', '', 1, 2, 'root', ''),
(5, 'everything-is-going-to-be-alright', 'article', 'root', 2, 3, 'Everything is going to be alright', ''),
(6, 'hope-for-the-future', 'article', 'root', 4, 5, 'Hope for the future', ''),
(7, 'meaningful-labor', 'article', 'root', 6, 7, 'Meaningful labor', ''),
(8, 'textpattern', 'link', 'root', 2, 3, 'Textpattern', '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]txp_css`
--
CREATE TABLE `[[dbprefix]]txp_css` (
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`css` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`skin` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
`lastmod` datetime DEFAULT NULL,
PRIMARY KEY (`name`(63),`skin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]txp_css`
--
INSERT INTO `[[dbprefix]]txp_css` VALUES
('default', 'details,main,search{display:block}progress{vertical-align:baseline}summary{display:list-item}header::after,footer::after,nav ul::after,nav ol::after,.container::after{content:"";display:table;clear:both}@media screen{html{-webkit-text-size-adjust:100%;text-size-adjust:100%}body{position:relative;margin:0;background:#f7f7f7}.wrapper{padding:1px 0;border-bottom:1px solid #ccc;background:#fff}.site-header,.site-footer,.container{width:88%;max-width:54em;margin:0 auto}.site-header{padding:1em 0}.site-header h2{margin:0}.site-header h3{margin:.5em 0 0;font-family:"PT Serif",Constantia,"Lucida Bright",Lucidabright,"Lucida Serif",Lucida,"DejaVu Serif","Bitstream Vera Serif","Liberation Serif",Georgia,serif;font-size:1.25rem;font-style:italic;font-weight:normal;line-height:1.4}.site-footer{padding:.5em 0}.article{margin-bottom:2em;overflow-wrap:break-word}.complementary-content{margin:2em -6% 0;padding:0 6%;overflow-wrap:break-word;border-top:2px dashed #ccc}.accessibility{position:absolute;width:1px;height:1px;margin:-1px;padding:0;overflow:hidden;clip-path:inset(50%);border:0;white-space:nowrap}.site-navigation{background-color:hsl(0,0%,86.8333333333%)}.site-navigation>div{position:relative;max-width:54em;margin:0 auto}.site-navigation ul{margin:0;padding:0;border:solid hsl(0,0%,79.8333333333%);border-width:1px 0;list-style:none}.site-navigation li{border:solid hsl(0,0%,79.8333333333%);border-width:1px 0;background-color:#eee}.site-navigation li:hover{background-color:rgb(248.2,248.2,248.2)}.site-navigation li:active{background-color:hsl(0,0%,82.8333333333%);box-shadow:inset 0 .2em .25em rgba(0,0,0,.15)}.site-navigation li.active{background-color:hsl(0,0%,101.3333333333%);box-shadow:none}.site-navigation a{display:block;padding:.5em 6%;color:#333}.site-navigation a:hover,.site-navigation a:visited{color:#333;text-decoration:none}.site-navigation a:active{color:hsl(0,0%,10%);text-decoration:none}search{padding:1em 6% .5em;background:#fff}search input[type=search]{width:16em;height:2.125em;padding-right:.1875em;padding-left:2em;border-radius:.5em;background:url("data:image/svg+xml,%3Csvg xmlns=%27http://www.w3.org/2000/svg%27 width=%2732%27 height=%2732%27 viewBox=%270 0 32 32%27%3E%3Cg fill=%27%23333%27%3E%3Cpath d=%27M4,13c0-5,4-9,9-9c5,0,9,4,9,9c0,5-4,9-9,9C8,22,4,18,4,13z M13,19c3.3,0,6-2.7,6-6s-2.7-6-6-6s-6,2.7-6,6S9.7,19,13,19z%27/%3E%3Cpath d=%27M17.5,19l1.5-1.5l4.5,3L28,25c0,0,0,1.5-0.75,2.25S25,28,25,28l-4.5-4.5L17.5,19z%27/%3E%3C/g%3E%3C/svg%3E") no-repeat left center;background-size:2em 2em}a{color:#004cbf;text-decoration:none;-webkit-text-decoration-skip:ink;text-decoration-skip-ink:auto;touch-action:manipulation}a:hover,a:active{outline:0;color:#06f;text-decoration:underline}a:focus{outline:1px solid #06f}h1 a,h2 a,h3 a,h4 a,h5 a,h6 a{color:#000}h1 a:hover,h1 a:active,h2 a:hover,h2 a:active,h3 a:hover,h3 a:active,h4 a:hover,h4 a:active,h5 a:hover,h5 a:active,h6 a:hover,h6 a:active{color:#000;text-decoration-color:rgba(51,51,51,.5)}.paginator{display:flex;justify-content:space-between}.paginator [rel=next]{margin-inline-start:auto}.skip-link{position:absolute;z-index:2;top:1px;left:1px;padding:.25em .5em;transform:translateY(-5em);transition:transform .25s ease-in-out;background-color:hsl(0,0%,101.3333333333%);color:#333;font-family:system-ui,-apple-system,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol"}.skip-link:focus,.skip-link:active{transform:translateY(0)}html{font-size:16px;line-height:1.5}body{color:#333;font-family:"PT Serif",Constantia,"Lucida Bright",Lucidabright,"Lucida Serif",Lucida,"DejaVu Serif","Bitstream Vera Serif","Liberation Serif",Georgia,serif}.site-navigation{font-family:system-ui,-apple-system,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol";font-weight:bold}h1,h2,h3,h4,h5,h6{clear:both;color:#000;font-family:system-ui,-apple-system,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol"}h1{margin:.6315789em 0;font-size:2.375rem;letter-spacing:-0.25px;line-height:1.1842105}h2{margin:.75em 0;font-size:2rem;letter-spacing:-0.25px;line-height:1.25}h3{margin:1em 0;font-size:1.5rem;letter-spacing:-0.25px;line-height:1.3333333}h4{margin:1em 0;font-size:1.25rem;line-height:1.4}h5{margin:1em 0;font-size:1.125rem;line-height:1.4444444}h6{margin:1em 0;font-size:1rem;line-height:1.5}b,strong{font-weight:bolder}address{margin:1em 0}blockquote{margin:.8em 0;font-size:1.25rem;font-style:italic;line-height:1.4;text-align:center}abbr[title]{border-bottom:0;-webkit-text-decoration:underline dotted;text-decoration:underline dotted}mark,var{padding:0 .25em;border-radius:.25em;background:#fff9e1;color:#333}pre,code,kbd,samp{border:1px solid hsl(0,0%,89%);border-radius:.2857143em;background-color:#f7f7f7;color:#333;font-family:Menlo,Consolas,Monaco,monospace;font-size:.875rem;line-height:1.5}code,kbd,samp{padding:1px .21429em}pre{padding:.5714286em 1.1428571em;overflow-wrap:normal;overflow-x:auto;tab-size:4}pre code{padding:0;overflow-wrap:normal;border:0;background-color:rgba(0,0,0,0);direction:ltr;font-size:1em;-ms-hyphens:none;hyphens:none;text-align:left;word-break:normal;word-spacing:normal;white-space:pre}sub,sup.footnote,sup{position:relative;font-size:.75em;line-height:0;vertical-align:baseline}sup{top:-0.5em}sub{bottom:-0.25em}small,figcaption,tfoot,.footnote{font-size:.8125rem;line-height:1.5}figcaption,tfoot,.footnote{color:#585858}figcaption{margin-top:.5em;font-style:italic}hr{box-sizing:content-box;height:24px;margin:1em 0;overflow:visible;border:0;background:url("data:image/svg+xml,%3Csvg xmlns=%27http://www.w3.org/2000/svg%27 viewBox=%270 0 240 24%27%3E%3Cpath fill=%27%23333%27 d=%27M0,0c1.742,13.61,54.74,20.912,119.995,15.279C184.922,9.679,238.594,13.024,240,24c-1.744-13.613-54.742-20.913-120.005-15.284C55.078,14.32,1.405,10.973,0,0z%27/%3E%3C/svg%3E") 50% 50% no-repeat;background-size:240px 24px}[dir=ltr],[dir=rtl]{unicode-bidi:isolate}bdo[dir=ltr],bdo[dir=rtl]{unicode-bidi:isolate-override}:lang(ja){font-family:"Hiragino Sans","Hiragino Kaku Gothic Pro","Meiryo UI",sans-serif;font-weight:300}:lang(ko){font-family:GulimChe,Gulim,sans-serif}:lang(zh-cn){font-family:"PingFang SC",SimHei,sans-serif}:lang(zh-tw){font-family:"PingFang TC",PMingLiU,sans-serif}[lang|=ar] a:hover,[lang|=fa] a:hover,[lang|=ur] a:hover{text-decoration:none}[dir=rtl] code{direction:ltr}[dir=rtl] img.align-left{margin:1em 0 1em 1em;float:right}[dir=rtl] img.align-right{margin:1em 1em 1em 0;float:left}[dir=rtl] caption{text-align:right}[dir=rtl] th,[dir=rtl] td{text-align:right}[dir=rtl] menu,[dir=rtl] ol,[dir=rtl] ul{padding:0 2em 0 0}[dir=rtl] .site-navigation ul,[dir=rtl] .article-list{padding:0}[dir=rtl] dd{margin:0 2em 0 0}[dir=rtl] input[type=checkbox]+label,[dir=rtl] input[type=radio]+label{margin:0 0 0 .5em}[dir=rtl] input[type=checkbox]+label:last-of-type,[dir=rtl] input[type=radio]+label:last-of-type{margin:0}[dir=rtl] select{padding-right:.1875em;padding-left:1.5em;background-position:.5em center}[dir=rtl] .skip-link{right:1px;left:auto}[dir=rtl] .comments h4 .comment-anchor{float:left}video{display:inline-block}img,video{max-width:100%;height:auto}img{vertical-align:middle}img.align-left{margin:1em 1em 1em 0;float:left}img.align-right{margin:1em 0 1em 1em;float:right}img.align-center{display:block;margin:1em auto}figure{margin:1em 0}table{width:100%;margin-bottom:1em;border-spacing:0;border-collapse:collapse}caption{margin-bottom:.5em;font-style:italic;text-align:left}th,td{padding:.5em;border:1px solid #d4d4d4;vertical-align:top;text-align:left}thead tr{background-color:#eee}thead th,thead td{border:1px solid #ccc}tbody tr:nth-child(even){background-color:#f7f7f7}tfoot th,tfoot td{padding:.6666667em}[rowspan]{vertical-align:middle}menu,ol,ul{padding:0 0 0 2em}li>ul,li>ol{margin:0}li::marker{color:color-text-heading}dd{margin:0 0 0 2em}.article-list{margin:0 0 2em;padding:0;border-top:1px solid #ccc;list-style:none}.article-list li{margin-bottom:0;border-bottom:1px solid #ccc}fieldset{min-width:0;margin:1em 0;padding:1px 1em;border:1px solid #ccc}legend{display:table;box-sizing:border-box;max-width:100%;padding:0;color:inherit;white-space:normal}button,input{overflow:visible;touch-action:manipulation}button,input,optgroup,select,textarea{box-sizing:border-box;max-width:100%;margin:0;color:#000;font-family:system-ui,-apple-system,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol";font-size:1rem;line-height:1.375;vertical-align:baseline}[type=color],[type=date],[type=datetime],[type=datetime-local],[type=email],[type=month],[type=number],[type=password],[type=search],[type=tel],[type=text],[type=time],[type=url],[type=week],select,textarea{height:2em;padding:.25em .1875em;border:1px solid #ccc;border-radius:0;background:#fff;appearance:none}[type=color]:focus,[type=date]:focus,[type=datetime]:focus,[type=datetime-local]:focus,[type=email]:focus,[type=month]:focus,[type=number]:focus,[type=password]:focus,[type=search]:focus,[type=tel]:focus,[type=text]:focus,[type=time]:focus,[type=url]:focus,[type=week]:focus,select:focus,textarea:focus{border-color:#06f;outline:1px solid rgba(0,0,0,0)}[type=checkbox],[type=radio]{padding:0}[type=checkbox]+label,[type=radio]+label{margin:0 .5em 0 0}[type=checkbox]+label:last-of-type,[type=radio]+label:last-of-type{margin:0}[type=number]::-webkit-inner-spin-button,[type=number]::-webkit-outer-spin-button{height:auto}[type=search]::-webkit-search-decoration{appearance:none}select{padding-right:1.5em;background:#fff url("data:image/svg+xml,%3Csvg xmlns=%27http://www.w3.org/2000/svg%27 width=%2717%27 height=%275%27 viewBox=%270 0 17 5%27%3E%3Cpolygon fill=%27%23333%27 points=%270,0 5,5 10,0%27/%3E%3C/svg%3E") right center no-repeat;background-size:1.0625em .3125em;text-transform:none}select::-ms-expand{opacity:0}select[size],select[multiple]{height:auto;padding-right:.5em;background-image:none}select[size="0"],select[size="1"]{height:2em}optgroup{font-style:normal;font-weight:bold}textarea{width:100%;height:auto;min-height:3em;overflow:auto;vertical-align:top;resize:vertical}[disabled],[disabled] option,[disabled] optgroup,span.disabled{border-color:#d4d4d4 !important;opacity:1;background:#eee !important;box-shadow:none !important;color:#aaa !important;text-shadow:none !important;cursor:default !important}.small input{width:25%;min-width:151px}.small textarea{height:5.5em}.large input{width:50%;min-width:302px}.large textarea{height:9.75em}input:focus:invalid,select:focus:invalid,textarea:focus:invalid{border-color:#9d261d;box-shadow:none}input:-moz-ui-invalid,select:-moz-ui-invalid,textarea:-moz-ui-invalid{border-color:#9d261d;box-shadow:none}:-ms-input-placeholder{opacity:1;color:#999;font:inherit}::placeholder{opacity:1;color:#999;font:inherit}.required{border:0;color:#9d261d}button{overflow:visible;text-transform:none}button::-moz-focus-inner,[type=button]::-moz-focus-inner,[type=reset]::-moz-focus-inner,[type=submit]::-moz-focus-inner{padding:0;border-style:none}button,[type=button],[type=reset],[type=submit]{background-color:rgb(222.7,222.7,222.7);background-image:linear-gradient(#eeeeee, rgb(222.7, 222.7, 222.7));display:inline-block;position:relative;width:auto;height:2em;padding:.25em 1em;border:1px solid rgb(222.7,222.7,222.7);border-radius:1em;background-clip:padding-box;box-shadow:0 2px 0 rgb(171.7,171.7,171.7);color:#333;font-weight:normal;text-align:center;appearance:none;cursor:pointer}button:hover,[type=button]:hover,[type=reset]:hover,[type=submit]:hover{background-color:rgb(232.9,232.9,232.9);background-image:linear-gradient(rgb(248.2, 248.2, 248.2), rgb(232.9, 232.9, 232.9));border-color:hsl(0,0%,74.3333333333%);color:#333;text-decoration:none}button:active,[type=button]:active,[type=reset]:active,[type=submit]:active{top:2px;border-color:hsl(0,0%,74.3333333333%);box-shadow:none;color:hsl(0,0%,10%);text-decoration:none}button:focus,[type=button]:focus,[type=reset]:focus,[type=submit]:focus{border-color:#06f;outline:1px solid rgba(0,0,0,0)}button[disabled],[type=button][disabled],[type=reset][disabled],[type=submit][disabled]{top:2px !important}.comments{margin-bottom:1em;padding:1px 1em;overflow-wrap:break-word;border-radius:.5em;background:#f7f7f7}.comments h4 .is-author{font-weight:normal}.comments h4 .comment-anchor{float:right;font-weight:normal}.comments-author{background:hsl(0,0%,93.862745098%)}#cpreview{margin-bottom:2px;padding:1em;border-radius:.5em;background-color:#fff9e1}.error_message li{color:#9d261d}.comments_error{border-color:#9d261d}#popup-page .container{max-width:52em}}@media only screen and (min-width: 38em){.site-navigation{border-top:1px solid #ccc;border-bottom:1px solid #ccc}.site-navigation>div{display:flex;flex-wrap:wrap;justify-content:space-between;width:88%}.site-navigation ul{display:flex;flex-wrap:wrap;border:0}.site-navigation li{border-width:0 1px}.site-navigation a{padding:.5em 1em}search{margin-top:.2em;padding:0;background:rgba(0,0,0,0)}search input[type=search]{width:2.125em;padding-right:0;transition:width .2s ease-in-out,border-color .2s ease-in-out;background-color:#eee;cursor:pointer}search input[type=search]:hover{background-color:rgb(248.2,248.2,248.2)}search input[type=search]:focus{width:16em;padding-right:.1875em;background-color:hsl(0,0%,101.3333333333%);cursor:auto}}@media only screen and (min-width: 46em){html{font-size:1.125rem}}@media screen and (prefers-reduced-motion: reduce),(update: slow){search input[type=search]{transition-duration:0}}@media print{*,*::before,*::after{background:rgba(0,0,0,0) !important;box-shadow:none !important;color:#000 !important;text-shadow:none !important}html{font-size:8pt;line-height:1.5}body{margin:.5cm;padding:2em 5em;font-family:"Helvetica Neue",sans-serif}a{text-decoration:none}.site-header{border-bottom:1pt solid #000}.site-footer{margin-top:12pt;border-top:1pt solid #000}nav,audio,video,form,#comments-form,.comments h4 a:last-child,.complementary-content,.paginator,.skip-link{display:none}abbr[title]::after{content:" (" attr(title) ")"}h1{margin:16pt 0;font-size:32pt;font-weight:normal;line-height:36pt}h2{margin:14pt 0;font-size:24pt;line-height:28pt;orphans:2;widows:2;break-after:avoid}h3{margin:12pt 0;font-size:18pt;line-height:22pt;orphans:2;widows:2;break-after:avoid}h4{margin:11pt 0;font-size:14pt;line-height:18pt;orphans:2;widows:2;break-after:avoid}h5{margin:10pt 0;font-size:12pt;line-height:16pt;orphans:2;widows:2;break-after:avoid}h6{margin:9pt 0;font-size:10pt;line-height:14pt;orphans:2;widows:2;break-after:avoid}p{orphans:2;widows:2}footer,figcaption,tfoot,small,.footnote{font-size:6pt}blockquote{padding:0 0 0 8pt;border-left:3pt solid #000;font-size:16pt;break-inside:avoid}[dir=rtl] blockquote{padding:0 8pt 0 0;border-right:3pt solid #000;border-left:0}pre{margin-bottom:8pt;padding:8pt;border:1pt solid #000;white-space:pre-wrap !important}pre,code,kbd,samp,var{font-family:"Courier New",Courier,monospace}img{break-inside:avoid}img.align-left{margin:1em 1em 1em 0;float:left}img.align-right{margin:1em 0 1em 1em;float:right}img.align-center{display:block;margin:1em auto}[dir=rtl] img.align-left{margin:1em 0 1em 1em;float:right}[dir=rtl] img.align-right{margin:1em 1em 1em 0;float:left}figure{margin-bottom:8pt}figcaption{margin-top:4pt}ul{padding:0 0 8pt 1.8em;list-style:square}[dir=rtl] ul{padding:0 1.8em 8pt 0}ol{padding:0 0 8pt 1.8em;list-style:decimal}[dir=rtl] ol{padding:0 1.8em 8pt 0}dl{padding:0 0 8pt 1.8em}[dir=rtl] dl{padding:0 1.8em 8pt 0}table{width:100%;margin-bottom:8pt}caption{margin-bottom:4pt;font-weight:bold}tr{break-inside:avoid}th,td{padding:4pt 8pt;border-bottom:1pt solid #000}thead{display:table-header-group}thead th{border-top:1pt solid #000}.comments{break-inside:avoid}}', 'four-point-nine', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]txp_discuss`
--
CREATE TABLE `[[dbprefix]]txp_discuss` (
`discussid` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT,
`parentid` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`email` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`web` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`posted` datetime NOT NULL,
`message` text COLLATE utf8mb4_unicode_ci NOT NULL,
`visible` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`discussid`),
KEY `parentid` (`parentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]txp_discuss`
--
INSERT INTO `[[dbprefix]]txp_discuss` VALUES
(000001, 1, 'Donald Swain', 'donald.swain@example.com', 'https://docs.textpattern.com/brand/donald-swain', '[[regtime]]', 'I enjoy your site very much.
', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]txp_discuss_nonce`
--
CREATE TABLE `[[dbprefix]]txp_discuss_nonce` (
`issue_time` datetime NOT NULL,
`nonce` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`used` tinyint(4) NOT NULL DEFAULT '0',
`secret` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`nonce`(250))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]txp_file`
--
CREATE TABLE `[[dbprefix]]txp_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`category` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`permissions` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`downloads` int(10) unsigned NOT NULL DEFAULT '0',
`status` smallint(6) NOT NULL DEFAULT '4',
`modified` datetime NOT NULL,
`created` datetime NOT NULL,
`size` bigint(20) DEFAULT NULL,
`author` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `filename` (`filename`(250)),
KEY `author_idx` (`author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]txp_form`
--
CREATE TABLE `[[dbprefix]]txp_form` (
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`type` varchar(28) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`Form` text COLLATE utf8mb4_unicode_ci NOT NULL,
`skin` varchar(63) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
`lastmod` datetime DEFAULT NULL,
PRIMARY KEY (`name`(63),`skin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]txp_form`
--
INSERT INTO `[[dbprefix]]txp_form` VALUES
('article_listing', 'article', '\n \n\n \n
\n \n ">\n
\n \n\n \n \n \n \n " itemprop="datePublished">\n \n \n " />\n\n \n \n
\n \n \n \n " itemprop="discussionUrl">\n \n \n \n \n \n \n \n
\n \n \n \n " itemprop="discussionUrl">\n \n \n 0\n \n \n \n \n
\n\n \n \n \n\n \n \n
\n\n \n \n \n \n \n \n \n \n \n\n \n \n
\n \n \n \n \n ,'' children="0" break=", " trim>\n \n \n \n \n
\n\n \n \n \n \n\n', 'four-point-nine', NULL),
('search_results', 'article', '