-- phpMyAdmin SQL Dump
-- version 4.5.4.1deb2ubuntu2.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 28. Apr 2019 um 10:14
-- Server-Version: 5.7.25-0ubuntu0.16.04.2
-- PHP-Version: 7.0.33-0ubuntu0.16.04.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Datenbank: `CUCKOO_cms`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur fr Tabelle `con_fullsearch`
--

CREATE TABLE `con_fullsearch` (
  `idfullsearch` int(10) NOT NULL,
  `source` varchar(50) NOT NULL,
  `url` text NOT NULL,
  `id_client` int(10) NOT NULL,
  `id_lang` int(10) NOT NULL,
  `id_cat` int(10) NOT NULL,
  `id_art` int(10) NOT NULL,
  `id_cat_lang` int(10) NOT NULL,
  `id_art_lang` int(10) NOT NULL,
  `cat_public` int(1) NOT NULL,
  `cat_visible` int(1) NOT NULL,
  `art_online` int(1) NOT NULL,
  `art_searchable` int(1) NOT NULL,
  `sortID` text NOT NULL,
  `articleInclude` int(1) NOT NULL,
  `accessGroups` text NOT NULL,
  `images` text NOT NULL,
  `renderedContent` longtext NOT NULL,
  `strippedContent` longtext NOT NULL,
  `taggingCategories` int(11) NOT NULL,
  `testIndex` int(11) NOT NULL,
  `CMS_RAW` text NOT NULL,
  `CMS_HTMLHEAD` text NOT NULL,
  `CMS_HTML` longtext NOT NULL,
  `CMS_TEXT` longtext NOT NULL,
  `CMS_IMGDESCR` text NOT NULL,
  `CMS_LINKDESCR` text NOT NULL,
  `CMS_HEAD` text NOT NULL,
  `CMS_LINKTITLE` text NOT NULL,
  `CMS_LINKEDIT` text NOT NULL,
  `CMS_RAWLINK` text NOT NULL,
  `CMS_IMGEDIT` text NOT NULL,
  `CMS_IMGTITLE` text NOT NULL,
  `CMS_SIMPLELINKEDIT` text NOT NULL,
  `CMS_HTMLTEXT` text NOT NULL,
  `CMS_EASYIMGEDIT` text NOT NULL,
  `CMS_DATE` text NOT NULL,
  `CMS_TEASER` text NOT NULL,
  `CMS_FILELIST` text NOT NULL,
  `CMS_IMGEDITOR` text NOT NULL,
  `CMS_LINKEDITOR` text NOT NULL,
  `CMS_PIFAFORM` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes fr die Tabelle `con_fullsearch`
--
ALTER TABLE `con_fullsearch`
  ADD PRIMARY KEY (`idfullsearch`);
