Code: Alles auswählen
SELECT id, fid, catid, ftable, fcolumn, texttype, clang, filename, fileext FROM rex_587_searchindex WHERE texttype = 'file'
Code: Alles auswählen
-- phpMyAdmin SQL Dump
-- version 2.11.9.2
-- http://www.phpmyadmin.net
--
-- Host: **************
-- Erstellungszeit: 27. Juli 2011 um 16:01
-- Server Version: 5.0.67
-- PHP-Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Datenbank: `***********`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `rex_587_searchindex`
--
CREATE TABLE IF NOT EXISTS `rex_587_searchindex` (
`id` int(11) NOT NULL auto_increment,
`fid` varchar(255) default NULL,
`catid` int(11) default NULL,
`ftable` varchar(255) default NULL,
`fcolumn` varchar(255) default NULL,
`texttype` varchar(255) NOT NULL,
`clang` int(11) default NULL,
`filename` varchar(255) default NULL,
`fileext` varchar(255) default NULL,
`plaintext` text NOT NULL,
`unchangedtext` text NOT NULL,
`teaser` text NOT NULL,
`values` text NOT NULL,
PRIMARY KEY (`id`),
KEY `fid` (`fid`),
FULLTEXT KEY `plaintext` (`plaintext`),
FULLTEXT KEY `unchangedtext` (`unchangedtext`),
FULLTEXT KEY `plaintext_2` (`plaintext`,`unchangedtext`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6381 ;
--
-- Daten für Tabelle `rex_587_searchindex`
--
INSERT INTO `rex_587_searchindex` (`id`, `fid`, `catid`, `ftable`, `fcolumn`, `texttype`, `clang`, `filename`, `fileext`) VALUES
(6366, '-3', NULL, NULL, NULL, 'file', NULL, '/files/textdatei_sonderzeichen__________.pdf', 'pdf'),
(6365, '-2', NULL, NULL, NULL, 'file', NULL, '/files/test.pdf', 'pdf'),
(6364, '-1', NULL, NULL, NULL, 'file', NULL, '/files/neues_test-pdf.pdf', 'pdf');