-- phpMyAdmin SQL Dump
-- version 3.2.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 22, 2009 at 05:46 PM
-- Server version: 5.0.84
-- PHP Version: 5.2.11
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 */;
--
-- Database: `vode_configurator_2`
--
-- --------------------------------------------------------
--
-- Table structure for table `vode_info`
--
DROP TABLE IF EXISTS `vode_info`;
CREATE TABLE `vode_info` (
`series` varchar(20) NOT NULL,
`stepNo` int(10) NOT NULL default '0',
`railtype` varchar(100) NOT NULL default '',
`info` text,
`recno` mediumint(6) unsigned NOT NULL auto_increment,
PRIMARY KEY (`recno`),
KEY `idx` (`series`,`stepNo`,`railtype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
--
-- Dumping data for table `vode_info`
--
INSERT INTO `vode_info` (`series`, `stepNo`, `railtype`, `info`, `recno`) VALUES
('105', 1, '', '
', 1),
('105', 1, 'hh', '', 2),
('105', 2, '', 'Default image for step 2', 3),
('105', 2, 'BX', 'BX image for step 2', 4),
('105', 2, 'RR', 'RR image for step 2', 5),
('105', 3, '', 'Default image for step 3', 6),
('105', 4, '', 'Default image for step 4', 7),
('105', 5, '', 'Default image for Step 5', 8),
('105', 6, '', '
', 9),
('105', 7, '', 'Default image for Step 7', 10),
('105', 8, '', 'Default image for Step 8', 11),
('105', 9, '', 'Default image for Step 9', 12),
('105', 10, '', 'Default image for Step 10', 13),
('105', 11, '', 'Default image for step 11', 14),
('105', 11, 'BX', 'BX image for step 11', 15),
('105', 11, 'RR', 'RR image for step 11', 16),
('105', 11, 'WG', '
', 17),
('105', 12, '', 'Default image for step 12', 18);
-- --------------------------------------------------------
--
-- Table structure for table `vode_steps`
--
DROP TABLE IF EXISTS `vode_steps`;
CREATE TABLE `vode_steps` (
`series` varchar(20) NOT NULL,
`stepNo` int(10) NOT NULL default '0',
`stepName` varchar(30) NOT NULL default '',
`buttonTitle` varchar(100) NOT NULL default '',
`pageTitle` varchar(255) NOT NULL default '',
`startText` varchar(255) NOT NULL default '',
`systemCode` varchar(255) NOT NULL default '',
`imageFlag` tinyint(4) NOT NULL default '0',
`imageNodeDefault` varchar(10) NOT NULL default '',
`specsheetCatHead` varchar(50) NOT NULL default '',
`specsheetCat` smallint(6) NOT NULL default '0',
`specsheetSubcat` smallint(6) NOT NULL default '0',
`specsheetTerm` smallint(6) NOT NULL default '0',
`techsheetName` varchar(50) NOT NULL default '',
`default` varchar(255) default NULL,
`omitFlag` tinyint(4) NOT NULL default '0',
`recno` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`recno`),
KEY `idx` (`omitFlag`,`series`,`stepNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Vode Lighting Configurator steps' AUTO_INCREMENT=53 ;
--
-- Dumping data for table `vode_steps`
--
INSERT INTO `vode_steps` (`series`, `stepNo`, `stepName`, `buttonTitle`, `pageTitle`, `startText`, `systemCode`, `imageFlag`, `imageNodeDefault`, `specsheetCatHead`, `specsheetCat`, `specsheetSubcat`, `specsheetTerm`, `techsheetName`, `default`, `omitFlag`, `recno`) VALUES
('105', 7, 'ballast', 'Voltage/Ballast Type', 'Voltage/Ballast Type', 'Select Ballast Type and Voltage. See Vode Ballast Chart here.', '[ballast_a_optionValue] [ballast_b_voltage]', 1, '', 'Electrical', 6, 4, 1, '', 'ballast_b_voltage=0', 0, 7),
('105', 6, 'canopy', 'Canopy/Ballast Location', 'Canopy/Ballast Location', 'Select either an integral or remote Ballast Location & Canopy.', '[canopy_a_optionValue]', 1, '_', '', 4, 0, 3, '', NULL, 0, 6),
('105', 8, 'emergency', 'Emergency Ballast', 'Emergency Ballast', 'Would you like emergency ballasts? Please select a standard or custom configuration. If not, please select None.', '[emergency_a_optionValue]', 0, '', '', 6, 6, 1, '', NULL, 0, 8),
('105', 10, 'finish', 'Finish', 'Finish', 'Select finish. Standard Vode finish is Brushed Aluminum.', '[finish_a_optionValue]', 1, '', '', 0, 0, 0, '', NULL, 0, 10),
('105', 9, 'lamp', 'Lamp', 'Lamp', 'Select a Standard (High Efficiency) or High Output Lamp Type.', '[lamp_a_optionValue]', 1, '', '', 6, 1, 1, '', NULL, 0, 9),
('105', 3, 'layout', 'Length/Layout', 'Length/Layout', 'First, enter System Length (max 100 feet). Then preview and select a layout.', '[layout_a_optionValue]', 0, '1', 'Layout:', 3, 0, 1, '', NULL, 0, 3),
('105', 11, 'lenslouver', 'Lens/Baffle', 'Lens/Baffle', 'Options are partially determined by rail type.
Please select rail type in step 1.', '[lenslouver_a_optionValue]', 1, '', '', 0, 0, 0, '', NULL, 0, 11),
('105', 11, 'lenslouverORIG', 'Lens', 'Lens', 'Select Lens, if desired. Choose Rail type in step 1.', '[lenslouver_a_optionValue]', 0, '', '', 0, 0, 0, '', NULL, 1, 13),
('105', 4, 'mounting', 'Mounting', 'Mounting', 'Preview then select a Mounting.', '[mounting_a_optionValue]', 1, '_', 'Mounting:', 4, 0, 1, '', NULL, 0, 4),
('105', 1, 'railtype', 'Rail', 'Rail', 'Preview one of the 11 Rail Type options by clicking on the buttons to the left.', '[railtype_a_optionValue]', 1, 'WG', 'Rail Type:', 1, 0, 1, '', NULL, 0, 1),
('105', 2, 'railwidth', 'Single/Double', 'Single/Double', 'Preview then select either a Single, Double or Custom Double Rail.', '[railwidth_a_optionValue]', 1, '1', '', 1, 0, 2, '', NULL, 0, 2),
('105', 5, 'suspension', 'Suspension/Projection', 'Suspension/Projection', 'Preview then select a Projection/Suspension arm length.', '[suspension_a_optionValue]', 1, '', '', 4, 0, 2, '', NULL, 0, 5),
('105', 12, 'switches', 'Options', 'Options', 'Please select one or more of the options below.', '[switches_a_sensors][switches_a_cp][switches_a_otherOptions][switches_a_epf][switches_a_optionDLS][switches_a_optionOS]', 1, '', '', 0, 0, 0, '', 'switches_a_sensors_1=0', 0, 12),
('107', 7, 'ballast', 'Voltage/Ballast Type', 'Voltage/Ballast Type', 'Select Ballast Type and Voltage. See Vode Ballast Chart here.', '[ballast_a_optionValue] [ballast_b_voltage]', 1, '', 'Electrical', 6, 4, 1, '', 'ballast_b_voltage=0', 0, 14),
('107', 6, 'canopy', 'Canopy/Ballast Location', 'Canopy/Ballast Location', 'Select either an integral or remote Ballast Location & Canopy.', '[canopy_a_optionValue]', 1, '_', '', 4, 0, 3, '', NULL, 0, 15),
('107', 8, 'emergency', 'Emergency Ballast', 'Emergency Ballast', 'Would you like emergency ballasts? Please select a standard or custom configuration. If not, please select None.', '[emergency_a_optionValue]', 0, '', '', 6, 6, 1, '', NULL, 0, 16),
('107', 10, 'finish', 'Finish', 'Finish', 'Select finish. Standard Vode finish is Brushed Aluminum.', '[finish_a_optionValue]', 1, '', '', 0, 0, 0, '', NULL, 0, 17),
('107', 9, 'lamp', 'Lamp', 'Lamp', 'Select a Standard (High Efficiency) or High Output Lamp Type.', '[lamp_a_optionValue]', 1, '', '', 6, 1, 1, '', NULL, 0, 18),
('107', 3, 'layout', 'Length/Layout', 'Length/Layout', 'First, enter System Length (max 100 feet). Then preview and select a layout.', '[layout_a_optionValue]', 0, '1', 'Layout:', 3, 0, 1, '', NULL, 0, 19),
('107', 11, 'lenslouver', 'Lens/Baffle', 'Lens/Baffle', 'Options are partially determined by rail type.
Please select rail type in step 1.', '[lenslouver_a_optionValue]', 1, '', '', 0, 0, 0, '', NULL, 0, 20),
('107', 11, 'lenslouverORIG', 'Lens', 'Lens', 'Select Lens, if desired. Choose Rail type in step 1.', '[lenslouver_a_optionValue]', 0, '', '', 0, 0, 0, '', NULL, 1, 21),
('107', 4, 'mounting', 'Mounting', 'Mounting', 'Preview then select a Mounting.', '[mounting_a_optionValue]', 1, '_', 'Mounting:', 4, 0, 1, '', NULL, 0, 22),
('107', 1, 'railtype', 'Rail', 'Rail', 'Preview one of the 11 Rail Type options by clicking on the buttons to the left.', '[railtype_a_optionValue]', 1, 'WG', 'Rail Type:', 1, 0, 1, '', NULL, 0, 23),
('107', 2, 'railwidth', 'Single/Double', 'Single/Double', 'Preview then select either a Single, Double or Custom Double Rail.', '[railwidth_a_optionValue]', 1, '1', '', 1, 0, 2, '', NULL, 0, 24),
('107', 5, 'suspension', 'Suspension/Projection', 'Suspension/Projection', 'Preview then select a Projection/Suspension arm length.', '[suspension_a_optionValue]', 1, '', '', 4, 0, 2, '', NULL, 0, 25),
('107', 12, 'switches', 'Options', 'Options', 'Please select one or more of the options below.', '[switches_a_sensors][switches_a_cp][switches_a_otherOptions][switches_a_epf][switches_a_optionDLS][switches_a_optionOS]', 1, '', '', 0, 0, 0, '', 'switches_a_sensors_1=0', 0, 26),
('115', 7, 'ballast', 'Voltage/Ballast Type', 'Voltage/Ballast Type', 'Select Ballast Type and Voltage. See Vode Ballast Chart here.', '[ballast_a_optionValue] [ballast_b_voltage]', 1, '', 'Electrical', 6, 4, 1, '', 'ballast_b_voltage=0', 0, 27),
('115', 6, 'canopy', 'Ballast Location', 'Ballast Location', '', '[canopy_a_optionValue]', 1, '_', '', 4, 0, 3, '', 'canopy_a_optionNo=1^^canopy_a_optionValue=IB', 0, 28),
('115', 8, 'emergency', 'Emergency Ballast', 'Emergency Ballast', 'Would you like emergency ballasts? Please select a standard or custom configuration. If not, please select None.', '[emergency_a_optionValue]', 0, '', '', 6, 6, 1, '', NULL, 0, 29),
('115', 10, 'finish', 'Finish', 'Finish', 'Select finish. Standard Vode finish is Brushed Aluminum.', '[finish_a_optionValue]', 1, '', '', 0, 0, 0, '', NULL, 0, 30),
('115', 9, 'lamp', 'Lamp', 'Lamp', 'Select a Standard (High Efficiency) or High Output Lamp Type.', '[lamp_a_optionValue]', 1, '', '', 6, 1, 1, '', NULL, 0, 31),
('115', 3, 'layout', 'Length/Layout', 'Length/Layout', 'First, enter System Length (max 100 feet). Then preview and select a layout.', '[layout_a_optionValue]', 0, '1', 'Layout:', 3, 0, 1, '', NULL, 0, 32),
('115', 11, 'lenslouver', 'Lens/Baffle', 'Lens/Baffle', 'Options are partially determined by rail type.
Please select rail type in step 1.', '[lenslouver_a_optionValue]', 1, '', '', 0, 0, 0, '', NULL, 0, 33),
('115', 11, 'lenslouverORIG', 'Lens', 'Lens', 'Select Lens, if desired. Choose Rail type in step 1.', '[lenslouver_a_optionValue]', 0, '', '', 0, 0, 0, '', NULL, 1, 34),
('115', 4, 'mounting', 'Mounting', 'Mounting', 'Preview then select a Mounting.', '[mounting_a_optionValue]', 1, '_', 'Mounting:', 4, 0, 1, '', NULL, 0, 35),
('115', 1, 'railtype', 'Rail', 'Rail', 'Preview one of the 11 Rail Type options by clicking on the buttons to the left.', '[railtype_a_optionValue]', 1, 'WG', 'Rail Type:', 1, 0, 1, '', NULL, 0, 36),
('115', 2, 'railwidth', 'Single/Double', 'Single/Double', 'Preview then select either a Single, Double or Custom Double Rail.', '[railwidth_a_optionValue]', 1, '1', '', 1, 0, 2, '', NULL, 0, 37),
('115', 5, 'suspension', 'Suspension/Projection', 'Suspension/Projection', 'Preview then select a Projection/Suspension arm length.', '[suspension_a_optionValue]', 1, '', '', 4, 0, 2, '', NULL, 0, 38),
('115', 12, 'switches', 'Options', 'Options', 'Please select one or more of the options below.', '[switches_a_sensors][switches_a_cp][switches_a_otherOptions][switches_a_epf][switches_a_optionDLS][switches_a_optionOS]', 1, '', '', 0, 0, 0, '', 'switches_a_sensors_1=0', 0, 39),
('117', 7, 'power', 'Voltage/Power', 'Voltage/Power', 'Select Ballast Power and Voltage.', '[power_a_optionValue] [power_b_voltage]', 1, '', '', 6, 4, 1, '', 'power_b_voltage=0', 0, 40),
('117', 6, 'powerlocation', 'Power Location', 'Power Location', '', '[powerlocation_a_optionValue]', 1, '_', '', 4, 0, 3, '', '', 0, 41),
('117', 8, 'diode', 'Diode Type', 'Diode Type', 'Please select a diode type', '[diode_a_optionValue]', 0, '', '', 6, 6, 1, '', NULL, 0, 42),
('117', 10, 'finish', 'Finish', 'Finish', 'Select finish. Standard Vode finish is Brushed Aluminum.', '[finish_a_optionValue]', 1, '', '', 0, 0, 0, '', NULL, 0, 43),
('117', 9, 'colortemp', 'Color Temperature', 'Color Temperature', 'Select a Color Temperature.', '[colortemp_a_optionValue]', 1, '', '', 6, 1, 1, '', NULL, 0, 44),
('117', 3, 'layout', 'Length/Layout', 'Length/Layout', 'First, enter System Length (max 100 feet). Then preview and select a layout.', '[layout_a_optionValue]', 0, '1', 'Layout:', 3, 0, 1, '', NULL, 0, 45),
('117', 11, 'optics', 'Optics', 'Optics', 'Please select from the options below.', '[optics_a_optionValue]', 1, '', '', 0, 0, 0, '', NULL, 0, 46),
('117', 11, 'lenslouverORIG', 'Lens', 'Lens', 'Select Lens, if desired. Choose Rail type in step 1.', '[lenslouver_a_optionValue]', 0, '', '', 0, 0, 0, '', NULL, 1, 47),
('117', 4, 'mounting', 'Mounting', 'Mounting', 'Preview then select a Mounting.', '[mounting_a_optionValue]', 1, '_', 'Mounting:', 4, 0, 1, '', NULL, 0, 48),
('117', 1, 'railtype', 'Rail', 'Rail', 'Preview one of the 11 Rail Type options by clicking on the buttons to the left.', '[railtype_a_optionValue]', 1, 'WG', 'Rail Type:', 1, 0, 1, '', NULL, 0, 49),
('117', 2, 'railwidth', 'Single/Double', 'Single/Double', 'Preview then select either a Single, Double or Custom Double Rail.', '[railwidth_a_optionValue]', 1, '1', '', 1, 0, 2, '', NULL, 0, 50),
('117', 5, 'suspension', 'Suspension/Projection', 'Suspension/Projection', 'Preview then select a Projection/Suspension arm length.', '[suspension_a_optionValue]', 1, '', '', 4, 0, 2, '', NULL, 0, 51),
('117', 12, 'switches', 'Options', 'Options', 'Please select one or more of the options below.', '[switches_a_sensors][switches_a_cp][switches_a_otherOptions][switches_a_epf][switches_a_optionDLS][switches_a_optionOS]', 1, '', '', 0, 0, 0, '', 'switches_a_sensors_1=0', 0, 52);