-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `hybrid_fooyou`
--

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

--
-- Table structure for table `cust`
--

CREATE TABLE `cust` (
  `lookupname` varchar(38) NOT NULL DEFAULT '',
  `cust_num` int(10) NOT NULL,
  `lname` varchar(45) NOT NULL,
  `fname` varchar(45) NOT NULL,
  `telephone1` varchar(15) NOT NULL DEFAULT '',
  `email` varchar(60) NOT NULL,
  `emailkitchen` varchar(60) NOT NULL,
  `email_code` varchar(50) NOT NULL,
  `driver` varchar(60) NOT NULL,
  `street` varchar(50) NOT NULL,
  `destination` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(25) NOT NULL,
  `zipcode` varchar(20) NOT NULL,
  `blast` varchar(45) NOT NULL,
  `bfirst` varchar(45) NOT NULL,
  `bstreet` varchar(50) NOT NULL,
  `bapt` varchar(25) NOT NULL,
  `bcity` varchar(30) NOT NULL,
  `bstate` varchar(2) NOT NULL,
  `bzip` varchar(10) NOT NULL,
  `mi` varchar(1) NOT NULL,
  `Credit Card Num` varchar(20) NOT NULL,
  `Credit card type` varchar(20) NOT NULL,
  `expiration` varchar(10) NOT NULL,
  `cellphone` varchar(25) NOT NULL,
  `website` varchar(65) NOT NULL,
  `dob` datetime NOT NULL,
  `pob` varchar(50) NOT NULL,
  `username` varchar(25) NOT NULL,
  `password` varchar(25) NOT NULL,
  `verified` tinyint(1) NOT NULL,
  `kounter` int(4) NOT NULL,
  `id` varchar(55) NOT NULL,
  `comments` text NOT NULL,
  `pass1` varchar(20) NOT NULL DEFAULT '0',
  `pass2` varchar(20) NOT NULL DEFAULT '0',
  `category3` tinyint(4) NOT NULL DEFAULT '0',
  `category4` tinyint(4) NOT NULL DEFAULT '0',
  `category5` tinyint(4) NOT NULL DEFAULT '0',
  `category6` tinyint(4) NOT NULL DEFAULT '0',
  `category7` tinyint(4) NOT NULL DEFAULT '0',
  `category8` tinyint(4) NOT NULL DEFAULT '0',
  `category9` tinyint(4) NOT NULL DEFAULT '0',
  `category10` tinyint(4) NOT NULL DEFAULT '0',
  `county` varchar(50) NOT NULL,
  `occupation` varchar(100) NOT NULL,
  `telephone2` varchar(15) NOT NULL,
  `quest1` varchar(65) NOT NULL,
  `use1` varchar(4) NOT NULL,
  `use2` varchar(4) NOT NULL,
  `use3` varchar(4) NOT NULL,
  `use4` varchar(4) NOT NULL,
  `use5` varchar(4) NOT NULL,
  `use6` varchar(4) NOT NULL,
  `quest2` varchar(65) NOT NULL,
  `quest3` varchar(65) NOT NULL,
  `quest4` varchar(65) NOT NULL,
  `quest5` varchar(65) NOT NULL,
  `quest6` varchar(65) NOT NULL,
  `subdir` varchar(30) NOT NULL,
  `pdfdir` varchar(30) NOT NULL,
  `menudir` varchar(30) NOT NULL,
  `slidecat1` varchar(30) NOT NULL,
  `slidecat2` varchar(30) NOT NULL,
  `slidecat3` varchar(30) NOT NULL,
  `slidecat4` varchar(30) NOT NULL,
  `slidecat5` varchar(30) NOT NULL,
  `slidecat6` varchar(30) NOT NULL,
  `slidecat7` varchar(30) NOT NULL,
  `slidecat8` varchar(30) NOT NULL,
  `slidecat9` varchar(30) NOT NULL,
  `slidecat10` varchar(30) NOT NULL,
  `slidecat11` varchar(30) NOT NULL,
  `slidecat12` varchar(30) NOT NULL,
  `slidecat13` varchar(30) NOT NULL,
  `slidecat14` varchar(30) NOT NULL,
  `slidecat15` varchar(30) NOT NULL,
  `slidecat16` varchar(30) NOT NULL,
  `slidecat17` varchar(30) NOT NULL,
  `slidecat18` varchar(30) NOT NULL,
  `slidecat19` varchar(30) NOT NULL,
  `slidecat20` varchar(30) NOT NULL,
  `emenu1cat` varchar(200) NOT NULL,
  `emenu2cat` varchar(200) NOT NULL,
  `emenu3cat` varchar(200) NOT NULL,
  `emenu4cat` varchar(200) NOT NULL,
  `emenu5cat` varchar(200) NOT NULL,
  `emenu6cat` varchar(200) NOT NULL,
  `emenu7cat` varchar(200) NOT NULL,
  `emenucat8` varchar(200) NOT NULL,
  `emenucat9` varchar(200) NOT NULL,
  `emenucat10` varchar(200) NOT NULL,
  `logo` varchar(35) NOT NULL,
  `width` int(5) NOT NULL,
  `height` int(5) NOT NULL,
  `def_time` decimal(10,2) NOT NULL,
  `def_time_new` varchar(25) NOT NULL,
  `act_time` decimal(10,2) NOT NULL,
  `def_time_d` decimal(10,2) NOT NULL,
  `act_time_d` decimal(10,2) NOT NULL,
  `reopen_time` varchar(20) NOT NULL,
  `note1` varchar(160) NOT NULL,
  `note2` varchar(160) NOT NULL,
  `note3` varchar(160) NOT NULL,
  `masterpass` varchar(25) NOT NULL,
  `orderflag` tinyint(2) NOT NULL,
  `salestax` decimal(10,5) NOT NULL,
  `samenum` tinyint(3) NOT NULL,
  `sales_day` decimal(10,2) NOT NULL,
  `sales_wk` decimal(10,2) NOT NULL,
  `sales_mo` decimal(10,2) NOT NULL,
  `psales_day` decimal(10,2) NOT NULL,
  `psales_wk` decimal(10,2) NOT NULL,
  `psales_mo` decimal(10,2) NOT NULL,
  `tax_day` decimal(10,2) NOT NULL,
  `tax_wk` decimal(10,2) NOT NULL,
  `tax_mo` decimal(10,2) NOT NULL,
  `drinks_day` decimal(10,2) NOT NULL,
  `drinks_wk` decimal(10,2) NOT NULL,
  `drinks_mo` decimal(10,2) NOT NULL,
  `custnum` int(20) NOT NULL,
  `mon_open` varchar(10) NOT NULL,
  `mon_close` varchar(10) NOT NULL,
  `tue_open` varchar(10) NOT NULL,
  `tue_close` varchar(10) NOT NULL,
  `wed_open` varchar(10) NOT NULL,
  `wed_close` varchar(10) NOT NULL,
  `thur_open` varchar(10) NOT NULL,
  `thur_close` varchar(10) NOT NULL,
  `fri_open` varchar(10) NOT NULL,
  `fri_close` varchar(10) NOT NULL,
  `sat_open` varchar(10) NOT NULL,
  `sat_close` varchar(10) NOT NULL,
  `sun_open` varchar(10) NOT NULL,
  `sun_close` varchar(10) NOT NULL,
  `mon_open_d` varchar(10) NOT NULL,
  `mon_close_d` varchar(10) NOT NULL,
  `tue_open_d` varchar(10) NOT NULL,
  `tue_close_d` varchar(10) NOT NULL,
  `wed_open_d` varchar(10) NOT NULL,
  `wed_close_d` varchar(10) NOT NULL,
  `thur_open_d` varchar(10) NOT NULL,
  `thur_close_d` varchar(10) NOT NULL,
  `fri_open_d` varchar(10) NOT NULL,
  `fri_close_d` varchar(10) NOT NULL,
  `sat_open_d` varchar(10) NOT NULL,
  `sat_close_d` varchar(10) NOT NULL,
  `sun_open_d` varchar(10) NOT NULL,
  `sun_close_d` varchar(10) NOT NULL,
  `food_order_key` tinyint(2) NOT NULL,
  `pick_up_key` tinyint(2) NOT NULL,
  `delivery_key` tinyint(2) NOT NULL,
  `rule1` tinyint(2) NOT NULL,
  `rule2` tinyint(2) NOT NULL,
  `rule3` tinyint(2) NOT NULL,
  `rule4` tinyint(2) NOT NULL,
  `catercount1` int(3) NOT NULL,
  `catercount2` int(3) NOT NULL,
  `catercount3` int(3) NOT NULL,
  `catercount4` int(3) NOT NULL,
  `catercount5` int(3) NOT NULL,
  `catercount6` int(3) NOT NULL,
  `catercount7` int(3) NOT NULL,
  `catercount8` int(3) NOT NULL,
  `catercount9` int(3) NOT NULL,
  `catercount10` int(3) NOT NULL,
  `catercount11` int(3) NOT NULL,
  `catercount12` int(3) NOT NULL,
  `catercount13` int(3) NOT NULL,
  `cateramnt1` decimal(6,2) NOT NULL,
  `cateramnt2` decimal(6,2) NOT NULL,
  `cateramnt3` decimal(6,2) NOT NULL,
  `cateramnt4` decimal(6,2) NOT NULL,
  `cateramnt5` decimal(6,2) NOT NULL,
  `cateramnt6` decimal(6,2) NOT NULL,
  `cateramnt7` decimal(6,2) NOT NULL,
  `cateramnt8` decimal(6,2) NOT NULL,
  `cateramnt9` decimal(6,2) NOT NULL,
  `cateramnt10` decimal(6,2) NOT NULL,
  `cateramnt11` decimal(6,2) NOT NULL,
  `cateramnt12` decimal(6,2) NOT NULL,
  `cateramnt13` decimal(6,2) NOT NULL,
  `addon_sm` decimal(4,2) NOT NULL,
  `addon_med` decimal(4,2) NOT NULL,
  `addon_lg` decimal(4,2) NOT NULL,
  `mt_ex_sm` decimal(4,2) NOT NULL,
  `mt_ex_med` decimal(4,2) NOT NULL,
  `mt_ex_lg` decimal(4,2) NOT NULL,
  `mt_ex_par` decimal(10,2) NOT NULL,
  `vg_ex_sm` decimal(4,2) NOT NULL,
  `vg_ex_med` decimal(4,2) NOT NULL,
  `vg_ex_lg` decimal(4,2) NOT NULL,
  `gm_addon_sm` decimal(4,2) NOT NULL,
  `gm_addon_med` decimal(4,2) NOT NULL,
  `gm_addon_lg` decimal(4,2) NOT NULL,
  `slideshowwidth` int(6) NOT NULL,
  `slideshowheight` int(6) NOT NULL,
  `zip1` varchar(5) NOT NULL,
  `zip2` varchar(5) NOT NULL,
  `zip3` varchar(5) NOT NULL,
  `zip4` varchar(5) NOT NULL,
  `zip5` varchar(5) NOT NULL,
  `zip6` varchar(5) NOT NULL,
  `zip7` varchar(5) NOT NULL,
  `zip8` varchar(5) NOT NULL,
  `zip9` varchar(10) NOT NULL,
  `zip10` varchar(10) NOT NULL,
  `zip11` varchar(10) NOT NULL,
  `zip12` varchar(10) NOT NULL,
  `custnm` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cust`
--

INSERT INTO `cust` (`lookupname`, `cust_num`, `lname`, `fname`, `telephone1`, `email`, `emailkitchen`, `email_code`, `driver`, `street`, `destination`, `city`, `state`, `zipcode`, `blast`, `bfirst`, `bstreet`, `bapt`, `bcity`, `bstate`, `bzip`, `mi`, `Credit Card Num`, `Credit card type`, `expiration`, `cellphone`, `website`, `dob`, `pob`, `username`, `password`, `verified`, `kounter`, `id`, `comments`, `pass1`, `pass2`, `category3`, `category4`, `category5`, `category6`, `category7`, `category8`, `category9`, `category10`, `county`, `occupation`, `telephone2`, `quest1`, `use1`, `use2`, `use3`, `use4`, `use5`, `use6`, `quest2`, `quest3`, `quest4`, `quest5`, `quest6`, `subdir`, `pdfdir`, `menudir`, `slidecat1`, `slidecat2`, `slidecat3`, `slidecat4`, `slidecat5`, `slidecat6`, `slidecat7`, `slidecat8`, `slidecat9`, `slidecat10`, `slidecat11`, `slidecat12`, `slidecat13`, `slidecat14`, `slidecat15`, `slidecat16`, `slidecat17`, `slidecat18`, `slidecat19`, `slidecat20`, `emenu1cat`, `emenu2cat`, `emenu3cat`, `emenu4cat`, `emenu5cat`, `emenu6cat`, `emenu7cat`, `emenucat8`, `emenucat9`, `emenucat10`, `logo`, `width`, `height`, `def_time`, `def_time_new`, `act_time`, `def_time_d`, `act_time_d`, `reopen_time`, `note1`, `note2`, `note3`, `masterpass`, `orderflag`, `salestax`, `samenum`, `sales_day`, `sales_wk`, `sales_mo`, `psales_day`, `psales_wk`, `psales_mo`, `tax_day`, `tax_wk`, `tax_mo`, `drinks_day`, `drinks_wk`, `drinks_mo`, `custnum`, `mon_open`, `mon_close`, `tue_open`, `tue_close`, `wed_open`, `wed_close`, `thur_open`, `thur_close`, `fri_open`, `fri_close`, `sat_open`, `sat_close`, `sun_open`, `sun_close`, `mon_open_d`, `mon_close_d`, `tue_open_d`, `tue_close_d`, `wed_open_d`, `wed_close_d`, `thur_open_d`, `thur_close_d`, `fri_open_d`, `fri_close_d`, `sat_open_d`, `sat_close_d`, `sun_open_d`, `sun_close_d`, `food_order_key`, `pick_up_key`, `delivery_key`, `rule1`, `rule2`, `rule3`, `rule4`, `catercount1`, `catercount2`, `catercount3`, `catercount4`, `catercount5`, `catercount6`, `catercount7`, `catercount8`, `catercount9`, `catercount10`, `catercount11`, `catercount12`, `catercount13`, `cateramnt1`, `cateramnt2`, `cateramnt3`, `cateramnt4`, `cateramnt5`, `cateramnt6`, `cateramnt7`, `cateramnt8`, `cateramnt9`, `cateramnt10`, `cateramnt11`, `cateramnt12`, `cateramnt13`, `addon_sm`, `addon_med`, `addon_lg`, `mt_ex_sm`, `mt_ex_med`, `mt_ex_lg`, `mt_ex_par`, `vg_ex_sm`, `vg_ex_med`, `vg_ex_lg`, `gm_addon_sm`, `gm_addon_med`, `gm_addon_lg`, `slideshowwidth`, `slideshowheight`, `zip1`, `zip2`, `zip3`, `zip4`, `zip5`, `zip6`, `zip7`, `zip8`, `zip9`, `zip10`, `zip11`, `zip12`, `custnm`) VALUES
(', ', 0, '', '', '', '', '', '', 'Charley', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2024-03-20 12:04:12', '', 'bus1', 'hac31', 0, 0, '', '', '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'bus1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0.00, '+0 hour +0 minutes', 0.00, 0.00, 0.00, '', '', '', '', '', 0, 0.00000, 0, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cust`
--
ALTER TABLE `cust`
  ADD PRIMARY KEY (`custnm`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cust`
--
ALTER TABLE `cust`
  MODIFY `custnm` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

