-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 14, 2017 at 03:32 PM
-- Server version: 10.1.24-MariaDB
-- PHP Version: 5.6.30

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


/*!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 utf8mb4 */;

--
-- Database: `j364`
--

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

--
-- Table structure for table `z5wrt_comprofiler_fields`
--

CREATE TABLE `z5wrt_comprofiler_fields` (
  `fieldid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `tablecolumns` text NOT NULL,
  `table` varchar(50) NOT NULL DEFAULT '#__comprofiler',
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` mediumtext NOT NULL,
  `type` varchar(50) NOT NULL DEFAULT '',
  `maxlength` int(11) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `required` tinyint(4) DEFAULT '0',
  `tabid` int(11) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `cols` int(11) DEFAULT NULL,
  `rows` int(11) DEFAULT NULL,
  `value` varchar(50) DEFAULT NULL,
  `default` mediumtext,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `registration` tinyint(1) NOT NULL DEFAULT '0',
  `edit` tinyint(1) NOT NULL DEFAULT '1',
  `profile` tinyint(1) NOT NULL DEFAULT '1',
  `readonly` tinyint(1) NOT NULL DEFAULT '0',
  `searchable` tinyint(1) NOT NULL DEFAULT '0',
  `calculated` tinyint(1) NOT NULL DEFAULT '0',
  `sys` tinyint(4) NOT NULL DEFAULT '0',
  `pluginid` int(11) NOT NULL DEFAULT '0',
  `cssclass` varchar(255) DEFAULT NULL,
  `params` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `z5wrt_comprofiler_fields`
--

INSERT INTO `z5wrt_comprofiler_fields` (`fieldid`, `name`, `tablecolumns`, `table`, `title`, `description`, `type`, `maxlength`, `size`, `required`, `tabid`, `ordering`, `cols`, `rows`, `value`, `default`, `published`, `registration`, `edit`, `profile`, `readonly`, `searchable`, `calculated`, `sys`, `pluginid`, `cssclass`, `params`) VALUES
(71, 'cb_vehicle_01_type', 'cb_vehicle_01_type', '#__comprofiler', 'Vehicle #1 Type', '', 'queryselect', NULL, 0, 0, 25, 1, NULL, NULL, NULL, '', 1, 1, 1, 1, 0, 1, 0, 0, 23, '', '{\"fieldLayout\":\"\",\"fieldLayoutEdit\":\"\",\"fieldLayoutList\":\"\",\"fieldLayoutSearch\":\"\",\"fieldLayoutRegister\":\"\",\"fieldLayoutContentPlugins\":\"0\",\"fieldLayoutIcons\":\"\",\"qry_query\":\"SELECT DISTINCT `model` FROM `#__aaa_jaguar_cars` ORDER BY `model`\",\"qry_mode\":\"0\",\"qry_host\":\"\",\"qry_username\":\"\",\"qry_password\":\"\",\"qry_database\":\"\",\"qry_charset\":\"\",\"qry_prefix\":\"\",\"qry_update\":\"\",\"qry_col_value\":\"\",\"qry_col_label\":\"\",\"qry_col_optgrp\":\"\",\"qry_validate\":\"0\",\"qry_validate_query\":\"\",\"qry_validate_mode\":\"0\",\"qry_validate_host\":\"\",\"qry_validate_username\":\"\",\"qry_validate_password\":\"\",\"qry_validate_database\":\"\",\"qry_validate_charset\":\"\",\"qry_validate_prefix\":\"\",\"qry_validate_on\":\"0\",\"qry_validate_success\":\"\",\"qry_validate_error\":\"Not a valid input.\",\"qry_validate_ajax\":\"0\"}'),
(85, 'cb_vehicle_01_register', 'cb_vehicle_01_register', '#__comprofiler', 'Vehicle #1 Register', '', 'queryselect', 0, 0, 0, 25, 2, NULL, NULL, NULL, '', 1, 1, 1, 1, 0, 0, 0, 0, 23, 'autoset', '{\"fieldLayout\":\"\",\"fieldLayoutEdit\":\"\",\"fieldLayoutList\":\"\",\"fieldLayoutSearch\":\"\",\"fieldLayoutRegister\":\"\",\"fieldLayoutContentPlugins\":\"0\",\"fieldLayoutIcons\":\"0\",\"qry_query\":\"SELECT `register` FROM `#__aaa_jaguar_cars` WHERE `model` = \\\"[cb_vehicle_01_type]\\\"\",\"qry_mode\":\"0\",\"qry_host\":\"\",\"qry_username\":\"\",\"qry_password\":\"\",\"qry_database\":\"\",\"qry_charset\":\"\",\"qry_prefix\":\"\",\"qry_update\":\"71\",\"qry_col_value\":\"\",\"qry_col_label\":\"\",\"qry_col_optgrp\":\"\",\"qry_validate\":\"0\",\"qry_validate_query\":\"\",\"qry_validate_mode\":\"0\",\"qry_validate_host\":\"\",\"qry_validate_username\":\"\",\"qry_validate_password\":\"\",\"qry_validate_database\":\"\",\"qry_validate_charset\":\"\",\"qry_validate_prefix\":\"\",\"qry_validate_on\":\"0\",\"qry_validate_success\":\"\",\"qry_validate_error\":\"Not a valid input.\",\"qry_validate_ajax\":\"0\"}');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `z5wrt_comprofiler_fields`
--
ALTER TABLE `z5wrt_comprofiler_fields`
  ADD PRIMARY KEY (`fieldid`),
  ADD KEY `tabid_pub_prof_order` (`tabid`,`published`,`profile`,`ordering`),
  ADD KEY `readonly_published_tabid` (`readonly`,`published`,`tabid`),
  ADD KEY `registration_published_order` (`registration`,`published`,`ordering`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `z5wrt_comprofiler_fields`
--
ALTER TABLE `z5wrt_comprofiler_fields`
  MODIFY `fieldid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;