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

START TRANSACTION;



--
-- Database: `mymarket`
--

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

--
-- Table structure for table `alte_options`
--

CREATE TABLE `alte_options` (
  `option_id` bigint(20) UNSIGNED NOT NULL,
  `option_name` varchar(191) NOT NULL,
  `option_value` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `alte_options`
--

INSERT INTO `alte_options` (`option_id`, `option_name`, `option_value`) VALUES
(1, 'composer', '{\n    \"require\": {\n        \"google/apiclient\": \"2.15.0\"\n    }\n}\n'),
(11, 'env', '{\"plugin\":\"AdminLTE For Appgini\",\"version\":\"24.04.01\",\"AppginiBuildVersion\":\"24.11\"}'),
(21, 'tables_config', '{\"browser_window_id\":\"9a8ad582f781\",\"inventory_color\":\"success\",\"inventory_icon\":\"fa\",\"inventory_hidden_hp\":\"\",\"inventory_hidden_nm\":\"\",\"inventory_fa\":\"fa-solid fa-warehouse\",\"inventory_card_style\":\"homeLinkInfoBox_1\",\"inventory_card_size\":\"col-md-3 col-sm-6 col-12\",\"inventory_history_color\":\"primary\",\"inventory_history_icon\":\"fa\",\"inventory_history_hidden_hp\":\"\",\"inventory_history_hidden_nm\":\"\",\"inventory_history_fa\":\"fa-solid fa-drumstick-bite\",\"inventory_history_card_style\":\"homeLinkInfoBox_1\",\"inventory_history_card_size\":\"col-md-3 col-sm-6 col-12\",\"meat_color\":\"primary\",\"meat_icon\":\"default\",\"meat_hidden_hp\":\"\",\"meat_hidden_nm\":\"\",\"meat_fa\":\"fa fa-trophy\",\"meat_card_style\":\"homeLinkInfoBox_1\",\"meat_card_size\":\"col-md-3 col-sm-6 col-12\",\"cuts_color\":\"primary\",\"cuts_icon\":\"default\",\"cuts_hidden_hp\":\"\",\"cuts_hidden_nm\":\"\",\"cuts_fa\":\"fa fa-trophy\",\"cuts_card_style\":\"homeLinkInfoBox_1\",\"cuts_card_size\":\"col-md-3 col-sm-6 col-12\",\"sub_cut_color\":\"primary\",\"sub_cut_icon\":\"default\",\"sub_cut_hidden_hp\":\"\",\"sub_cut_hidden_nm\":\"\",\"sub_cut_fa\":\"fa fa-trophy\",\"sub_cut_card_style\":\"homeLinkInfoBox_1\",\"sub_cut_card_size\":\"col-md-3 col-sm-6 col-12\",\"cooked_type_color\":\"primary\",\"cooked_type_icon\":\"default\",\"cooked_type_hidden_hp\":\"\",\"cooked_type_hidden_nm\":\"\",\"cooked_type_fa\":\"fa fa-trophy\",\"cooked_type_card_style\":\"homeLinkInfoBox_1\",\"cooked_type_card_size\":\"col-md-3 col-sm-6 col-12\",\"inventory2_color\":\"primary\",\"inventory2_icon\":\"default\",\"inventory2_hidden_hp\":\"\",\"inventory2_hidden_nm\":\"\",\"inventory2_fa\":\"fa fa-trophy\",\"inventory2_card_style\":\"homeLinkInfoBox_1\",\"inventory2_card_size\":\"col-md-3 col-sm-6 col-12\",\"tbls\":\"\"}'),
(31, 'generalsettings_config', '{\"browser_window_id\":\"61d784c1953a\",\"appName\":\"Freezer App\",\"footerText\":\"© 2025 AppGiniLTE\",\"enablesweetalert\":\"0\",\"sessionExpiry\":\"60\",\"enablecustompages\":\"0\",\"disableadmintwitterfeed\":\"0\",\"dashboardWelcomeMessage\":\"\",\"siteLoader\":\"https://hackernoon.com/images/0*4Gzjgh9Y7Gu8KEtZ.gif\",\"enablethemeswitcherAppgini\":\"0\",\"enableRTL\":\"0\",\"enablestyledtable\":\"0\",\"tableColor\":\"#3772ff\",\"tableTextColor\":\"#ffffff\",\"alte_profile_name\":\"\",\"generalsetts\":\"\",\"appIcon\":\"../../appginilte/dist/img/AdminLTELogo.png\"}');

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

--
-- Table structure for table `appgini_csv_import_jobs`
--

CREATE TABLE `appgini_csv_import_jobs` (
  `id` varchar(40) NOT NULL,
  `memberID` varchar(100) NOT NULL,
  `config` text DEFAULT NULL,
  `insert_ts` int(11) DEFAULT NULL,
  `last_update_ts` int(11) DEFAULT NULL,
  `total` int(11) DEFAULT 99999999,
  `done` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `appgini_query_log`
--

CREATE TABLE `appgini_query_log` (
  `datetime` timestamp NOT NULL DEFAULT current_timestamp(),
  `statement` longtext DEFAULT NULL,
  `duration` decimal(10,2) UNSIGNED DEFAULT 0.00,
  `error` text DEFAULT NULL,
  `memberID` varchar(200) DEFAULT NULL,
  `uri` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cooked_type`
--

CREATE TABLE `cooked_type` (
  `cookedid` int(11) NOT NULL,
  `cookedname` varchar(40) DEFAULT NULL,
  `field1` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cooked_type`
--

INSERT INTO `cooked_type` (`cookedid`, `cookedname`, `field1`) VALUES
(1, 'Grilled', NULL),
(11, 'Smoked', NULL),
(21, 'Fried', NULL),
(31, 'Roasted', NULL),
(41, 'Pressured', NULL),
(51, 'Jerk', NULL),
(61, 'Curry', NULL),
(71, 'Soup', NULL),
(81, 'Chili', NULL),
(91, 'Lasagna', NULL),
(101, 'Shepard\'s Pie', NULL),
(111, 'Spaghetti Sauce', NULL);

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

--
-- Table structure for table `cuts`
--

CREATE TABLE `cuts` (
  `cutId` int(11) NOT NULL,
  `meatId` int(11) DEFAULT NULL,
  `cutname` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cuts`
--

INSERT INTO `cuts` (`cutId`, `meatId`, `cutname`) VALUES
(1, 1001, 'Steak'),
(11, 1001, 'Ground Beef'),
(21, 1001, 'Roast'),
(31, 1001, 'Brisket'),
(41, 1001, 'Stew Meat'),
(51, 1001, 'Oxtails'),
(61, 1001, 'Ribs'),
(71, 1001, 'Hamburgers'),
(81, 1001, 'Sauasge'),
(91, 1001, 'Jamaican Patties'),
(101, 1011, 'Legs'),
(111, 1011, 'Thighs'),
(121, 1011, 'Breasts'),
(131, 1011, 'Wings'),
(141, 1011, 'Combo'),
(151, 1011, 'Hens'),
(181, 1021, 'Ribs'),
(191, 1021, 'Chops'),
(201, 1021, 'Steaks'),
(211, 1021, 'Roast'),
(221, 1021, 'Loin'),
(231, 1021, 'Ham'),
(241, 1021, 'Pigtails'),
(251, 1021, 'Sauasge'),
(261, 1031, 'Salmon'),
(271, 1031, 'Tilapia'),
(281, 1031, 'Cod'),
(291, 1031, 'Snapper'),
(301, 1031, 'Catfish'),
(311, 1031, 'Bass'),
(321, 1031, 'Sunfisih'),
(331, 1031, 'Blue Gill'),
(341, 1031, 'Shrimp'),
(351, 1031, 'Crab Legs'),
(361, 1031, 'Caught'),
(371, 1041, 'Whole'),
(381, 1041, 'Legs'),
(391, 1041, 'Wings'),
(401, 1041, 'Breast'),
(411, 1051, 'Chops'),
(421, 1051, 'Leg of Lamb'),
(431, 1071, 'Whole'),
(441, 1071, 'Breast');

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

--
-- Table structure for table `inventory`
--

CREATE TABLE `inventory` (
  `meatid` int(11) DEFAULT NULL,
  `cutid` int(11) DEFAULT NULL,
  `subcutid` int(11) DEFAULT NULL,
  `cookstatus` char(40) DEFAULT 'No',
  `loc` varchar(40) DEFAULT '3',
  `indate` datetime DEFAULT NULL,
  `InventoryId` int(11) NOT NULL,
  `barcode` varchar(40) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `weight` varchar(40) DEFAULT NULL,
  `cookedid` int(11) DEFAULT NULL,
  `status` char(40) DEFAULT 'in-stock'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inventory`
--

INSERT INTO `inventory` (`meatid`, `cutid`, `subcutid`, `cookstatus`, `loc`, `indate`, `InventoryId`, `barcode`, `count`, `weight`, `cookedid`, `status`) VALUES
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 51, '1011-141-1', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 52, '1011-142-2', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 53, '1011-143-3', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 54, '1011-144-4', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 55, '1011-145-5', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 56, '1011-146-6', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 57, '1011-147-7', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 58, '1011-148-8', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 59, '1011-149-9', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 60, '1011-150-10', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 61, '1011-151-11', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 62, '1011-152-12', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 63, '1011-153-13', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 64, '1011-154-14', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 65, '1011-155-15', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 66, '1011-156-16', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 67, '1011-157-17', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 68, '1011-158-18', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 69, '1011-159-19', 6, '3', NULL, 'in-stock'),
(1011, 141, NULL, 'No', '3-GarageChest', '2025-01-15 00:00:00', 70, '1011-160-20', 6, '3', NULL, 'in-stock');

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

--
-- Table structure for table `inventory2`
--

CREATE TABLE `inventory2` (
  `InventoryId` int(11) NOT NULL,
  `meatid` int(11) DEFAULT NULL,
  `cutid` int(11) DEFAULT NULL,
  `subcutid` int(11) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `weight` varchar(40) DEFAULT NULL,
  `cookstatus` char(40) DEFAULT 'No',
  `cookedid` int(11) DEFAULT NULL,
  `loc` varchar(40) DEFAULT '3',
  `indate` datetime DEFAULT NULL,
  `barcode` varchar(40) DEFAULT NULL,
  `status` char(40) DEFAULT 'in-stock'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `inventory_history`
--

CREATE TABLE `inventory_history` (
  `InventoryId` int(11) DEFAULT NULL,
  `meatid` int(11) DEFAULT NULL,
  `cutid` int(11) DEFAULT NULL,
  `subcutid` int(11) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `weight` varchar(40) DEFAULT NULL,
  `cookedstatus` char(40) DEFAULT 'UnCooked',
  `cookedid` int(11) DEFAULT NULL,
  `loc` varchar(40) DEFAULT '3',
  `indate` datetime DEFAULT NULL,
  `date_removed` timestamp NULL DEFAULT NULL,
  `barcode` varchar(40) DEFAULT NULL,
  `hisrotyid` int(11) NOT NULL,
  `field1` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inventory_history`
--

INSERT INTO `inventory_history` (`InventoryId`, `meatid`, `cutid`, `subcutid`, `count`, `weight`, `cookedstatus`, `cookedid`, `loc`, `indate`, `date_removed`, `barcode`, `hisrotyid`, `field1`) VALUES
(41, 1031, 271, 0, 6, '1.5', 'No', 0, '1-Kitchen', '2025-03-13 00:00:00', '2025-03-17 14:58:27', 'B-1010-1-1-01', 11, NULL),
(51, 1011, 141, 0, 6, '3', 'No', 0, '3-GarageChest', '2025-03-21 00:00:00', '2025-03-21 15:27:28', '1011-141', 12, NULL);

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

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `locid` int(11) NOT NULL,
  `locname` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`locid`, `locname`) VALUES
(1, 'Kitchen'),
(11, 'Garage-Standup'),
(21, 'Garage-Chest');

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

--
-- Table structure for table `meat`
--

CREATE TABLE `meat` (
  `_dummy_deletable_field` tinyint(4) DEFAULT NULL,
  `meatid` int(11) NOT NULL,
  `meatname` char(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `meat`
--

INSERT INTO `meat` (`_dummy_deletable_field`, `meatid`, `meatname`) VALUES
(NULL, 1001, 'Beef'),
(NULL, 1011, 'Chicken'),
(NULL, 1021, 'Pork'),
(NULL, 1031, 'Fish'),
(NULL, 1041, 'Turkey'),
(NULL, 1051, 'Lamb'),
(NULL, 1061, 'Goat'),
(NULL, 1071, 'Duck');

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

--
-- Table structure for table `membership_cache`
--

CREATE TABLE `membership_cache` (
  `request` varchar(100) NOT NULL,
  `request_ts` int(11) DEFAULT NULL,
  `response` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `membership_grouppermissions`
--

CREATE TABLE `membership_grouppermissions` (
  `permissionID` int(10) UNSIGNED NOT NULL,
  `groupID` int(10) UNSIGNED DEFAULT NULL,
  `tableName` varchar(100) DEFAULT NULL,
  `allowInsert` tinyint(4) NOT NULL DEFAULT 0,
  `allowView` tinyint(4) NOT NULL DEFAULT 0,
  `allowEdit` tinyint(4) NOT NULL DEFAULT 0,
  `allowDelete` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `membership_grouppermissions`
--

INSERT INTO `membership_grouppermissions` (`permissionID`, `groupID`, `tableName`, `allowInsert`, `allowView`, `allowEdit`, `allowDelete`) VALUES
(1681, 2, 'location', 1, 3, 3, 3),
(2561, 2, 'meat', 1, 3, 3, 3),
(2571, 2, 'cuts', 1, 3, 3, 3),
(2581, 2, 'sub_cut', 1, 3, 3, 3),
(2591, 2, 'inventory', 1, 3, 3, 3),
(2601, 2, 'cooked_type', 1, 3, 3, 3),
(2611, 2, 'inventory_history', 1, 3, 3, 3),
(2621, 2, 'inventory2', 1, 3, 3, 3);

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

--
-- Table structure for table `membership_groups`
--

CREATE TABLE `membership_groups` (
  `groupID` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `allowSignup` tinyint(4) DEFAULT NULL,
  `needsApproval` tinyint(4) DEFAULT NULL,
  `allowCSVImport` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `membership_groups`
--

INSERT INTO `membership_groups` (`groupID`, `name`, `description`, `allowSignup`, `needsApproval`, `allowCSVImport`) VALUES
(1, 'anonymous', 'Anonymous group created automatically on 2025-03-08', 0, 0, 0),
(2, 'Admins', 'Admin group created automatically on 2025-03-08', 0, 1, 1);

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

--
-- Table structure for table `membership_userpermissions`
--

CREATE TABLE `membership_userpermissions` (
  `permissionID` int(10) UNSIGNED NOT NULL,
  `memberID` varchar(100) NOT NULL,
  `tableName` varchar(100) DEFAULT NULL,
  `allowInsert` tinyint(4) NOT NULL DEFAULT 0,
  `allowView` tinyint(4) NOT NULL DEFAULT 0,
  `allowEdit` tinyint(4) NOT NULL DEFAULT 0,
  `allowDelete` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `membership_userrecords`
--

CREATE TABLE `membership_userrecords` (
  `recID` bigint(20) UNSIGNED NOT NULL,
  `tableName` varchar(100) DEFAULT NULL,
  `pkValue` varchar(255) DEFAULT NULL,
  `memberID` varchar(100) DEFAULT NULL,
  `dateAdded` bigint(20) UNSIGNED DEFAULT NULL,
  `dateUpdated` bigint(20) UNSIGNED DEFAULT NULL,
  `groupID` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `membership_userrecords`
--

INSERT INTO `membership_userrecords` (`recID`, `tableName`, `pkValue`, `memberID`, `dateAdded`, `dateUpdated`, `groupID`) VALUES
(21, 'meat', '1001', 'amunoz', 1741793955, 1741793955, 2),
(31, 'meat', '1011', 'amunoz', 1741793978, 1741793978, 2),
(41, 'meat', '1021', 'amunoz', 1741794044, 1741794044, 2),
(51, 'meat', '1031', 'amunoz', 1741794052, 1741794052, 2),
(61, 'meat', '1041', 'amunoz', 1741794061, 1741794061, 2),
(71, 'meat', '1051', 'amunoz', 1741794069, 1741794069, 2),
(81, 'meat', '1061', 'amunoz', 1741794077, 1741794077, 2),
(91, 'meat', '1071', 'amunoz', 1741794109, 1741794109, 2),
(101, 'cuts', '1', 'amunoz', 1741794537, 1741794537, 2),
(111, 'cuts', '11', 'amunoz', 1741794537, 1741794537, 2),
(121, 'cuts', '21', 'amunoz', 1741794537, 1741794537, 2),
(131, 'cuts', '31', 'amunoz', 1741794537, 1741794537, 2),
(141, 'cuts', '41', 'amunoz', 1741794537, 1741794537, 2),
(151, 'cuts', '51', 'amunoz', 1741794537, 1741794537, 2),
(161, 'cuts', '61', 'amunoz', 1741794537, 1741794537, 2),
(171, 'cuts', '71', 'amunoz', 1741794537, 1741794537, 2),
(181, 'cuts', '81', 'amunoz', 1741794537, 1741794537, 2),
(191, 'cuts', '91', 'amunoz', 1741794537, 1741794537, 2),
(201, 'sub_cut', '1', 'amunoz', 1741795212, 1741795212, 2),
(211, 'sub_cut', '11', 'amunoz', 1741795212, 1741795212, 2),
(221, 'sub_cut', '21', 'amunoz', 1741795212, 1741795212, 2),
(231, 'sub_cut', '31', 'amunoz', 1741795212, 1741795212, 2),
(241, 'sub_cut', '41', 'amunoz', 1741795212, 1741795212, 2),
(251, 'sub_cut', '51', 'amunoz', 1741795212, 1741795212, 2),
(261, 'sub_cut', '61', 'amunoz', 1741795212, 1741795212, 2),
(271, 'sub_cut', '71', 'amunoz', 1741795212, 1741795212, 2),
(281, 'sub_cut', '81', 'amunoz', 1741795212, 1741795212, 2),
(291, 'sub_cut', '91', 'amunoz', 1741795212, 1741795212, 2),
(301, 'sub_cut', '101', 'amunoz', 1741795212, 1741795212, 2),
(311, 'sub_cut', '111', 'amunoz', 1741795212, 1741795212, 2),
(321, 'sub_cut', '121', 'amunoz', 1741795212, 1741795212, 2),
(331, 'sub_cut', '131', 'amunoz', 1741795212, 1741795212, 2),
(341, 'sub_cut', '141', 'amunoz', 1741795212, 1741795212, 2),
(351, 'sub_cut', '151', 'amunoz', 1741795212, 1741795212, 2),
(361, 'sub_cut', '161', 'amunoz', 1741795212, 1741795212, 2),
(371, 'sub_cut', '171', 'amunoz', 1741795212, 1741795212, 2),
(381, 'inventory', '0', 'amunoz', 1741795364, 1741795364, 2),
(391, 'inventory', '11', 'svassell', 1741796061, 1741796061, 2),
(401, 'inventory', '1', NULL, 1741796212, 1741796212, NULL),
(411, 'cuts', '101', 'amunoz', 1741796252, 1741796252, 2),
(421, 'cuts', '111', 'amunoz', 1741796252, 1741796252, 2),
(431, 'cuts', '121', 'amunoz', 1741796252, 1741796252, 2),
(441, 'cuts', '131', 'amunoz', 1741796252, 1741796252, 2),
(451, 'cuts', '141', 'amunoz', 1741796252, 1741796252, 2),
(461, 'cuts', '151', 'amunoz', 1741796252, 1741796252, 2),
(491, 'cuts', '181', 'amunoz', 1741796359, 1741796359, 2),
(501, 'cuts', '191', 'amunoz', 1741796359, 1741796359, 2),
(511, 'cuts', '201', 'amunoz', 1741796359, 1741796359, 2),
(521, 'cuts', '211', 'amunoz', 1741796359, 1741796359, 2),
(531, 'cuts', '221', 'amunoz', 1741796359, 1741796359, 2),
(541, 'cuts', '231', 'amunoz', 1741796359, 1741796359, 2),
(551, 'cuts', '241', 'amunoz', 1741796359, 1741796359, 2),
(561, 'cuts', '251', 'amunoz', 1741796359, 1741796359, 2),
(571, 'inventory', '21', 'amunoz', 1741796440, 1741796440, 2),
(581, 'sub_cut', '181', 'amunoz', 1741798719, 1741798719, 2),
(591, 'sub_cut', '191', 'amunoz', 1741798719, 1741798719, 2),
(601, 'sub_cut', '201', 'amunoz', 1741798719, 1741798719, 2),
(611, 'sub_cut', '211', 'amunoz', 1741798719, 1741798719, 2),
(621, 'sub_cut', '221', 'amunoz', 1741798719, 1741798719, 2),
(631, 'sub_cut', '231', 'amunoz', 1741798719, 1741798719, 2),
(641, 'sub_cut', '241', 'amunoz', 1741798719, 1741798719, 2),
(651, 'sub_cut', '251', 'amunoz', 1741798719, 1741798719, 2),
(661, 'sub_cut', '261', 'amunoz', 1741798719, 1741798719, 2),
(671, 'sub_cut', '271', 'amunoz', 1741798719, 1741798719, 2),
(681, 'sub_cut', '281', 'amunoz', 1741798719, 1741798719, 2),
(691, 'sub_cut', '291', 'amunoz', 1741798719, 1741798719, 2),
(701, 'sub_cut', '301', 'amunoz', 1741798719, 1741798719, 2),
(711, 'sub_cut', '311', 'amunoz', 1741798720, 1741798720, 2),
(721, 'sub_cut', '321', 'amunoz', 1741798720, 1741798720, 2),
(731, 'sub_cut', '331', 'amunoz', 1741798720, 1741798720, 2),
(741, 'sub_cut', '341', 'amunoz', 1741798720, 1741798720, 2),
(751, 'sub_cut', '351', 'amunoz', 1741798720, 1741798720, 2),
(761, 'cuts', '261', 'amunoz', 1741798937, 1741798937, 2),
(771, 'cuts', '271', 'amunoz', 1741798937, 1741798937, 2),
(781, 'cuts', '281', 'amunoz', 1741798937, 1741798937, 2),
(791, 'cuts', '291', 'amunoz', 1741798937, 1741798937, 2),
(801, 'cuts', '301', 'amunoz', 1741798937, 1741798937, 2),
(811, 'cuts', '311', 'amunoz', 1741798937, 1741798937, 2),
(821, 'cuts', '321', 'amunoz', 1741798937, 1741798937, 2),
(831, 'cuts', '331', 'amunoz', 1741798937, 1741798937, 2),
(841, 'cuts', '341', 'amunoz', 1741798937, 1741798937, 2),
(851, 'cuts', '351', 'amunoz', 1741798937, 1741798937, 2),
(861, 'cuts', '361', 'amunoz', 1741798937, 1741798937, 2),
(871, 'sub_cut', '361', 'amunoz', 1741799248, 1741799248, 2),
(881, 'sub_cut', '371', 'amunoz', 1741799248, 1741799248, 2),
(891, 'sub_cut', '381', 'amunoz', 1741799248, 1741799248, 2),
(901, 'sub_cut', '391', 'amunoz', 1741799248, 1741799248, 2),
(911, 'sub_cut', '401', 'amunoz', 1741799248, 1741799248, 2),
(921, 'sub_cut', '411', 'amunoz', 1741799248, 1741799248, 2),
(931, 'sub_cut', '421', 'amunoz', 1741799248, 1741799248, 2),
(941, 'cuts', '371', 'amunoz', 1741799405, 1741799405, 2),
(951, 'cuts', '381', 'amunoz', 1741799405, 1741799405, 2),
(961, 'cuts', '391', 'amunoz', 1741799405, 1741799405, 2),
(971, 'cuts', '401', 'amunoz', 1741799405, 1741799405, 2),
(981, 'sub_cut', '431', 'amunoz', 1741799521, 1741799521, 2),
(991, 'sub_cut', '441', 'amunoz', 1741799521, 1741799521, 2),
(1001, 'cuts', '411', 'amunoz', 1741799657, 1741799657, 2),
(1011, 'cuts', '421', 'amunoz', 1741799657, 1741799657, 2),
(1021, 'cuts', '431', 'amunoz', 1741799835, 1741799835, 2),
(1031, 'cuts', '441', 'amunoz', 1741799835, 1741799835, 2),
(1041, 'sub_cut', '451', 'amunoz', 1741799917, 1741799917, 2),
(1051, 'sub_cut', '461', 'amunoz', 1741799917, 1741799917, 2),
(1061, 'cooked_type', '1', 'amunoz', 1741800181, 1741800181, 2),
(1071, 'cooked_type', '11', 'amunoz', 1741800196, 1741800196, 2),
(1081, 'cooked_type', '21', 'amunoz', 1741800203, 1741800203, 2),
(1091, 'cooked_type', '31', 'amunoz', 1741800208, 1741800208, 2),
(1101, 'cooked_type', '41', 'amunoz', 1741800216, 1741800216, 2),
(1111, 'cooked_type', '51', 'amunoz', 1741800220, 1741800220, 2),
(1121, 'cooked_type', '61', 'amunoz', 1741800224, 1741800224, 2),
(1131, 'cooked_type', '71', 'amunoz', 1741800229, 1741800229, 2),
(1141, 'cooked_type', '81', 'amunoz', 1741800234, 1741800234, 2),
(1151, 'cooked_type', '91', 'amunoz', 1741800239, 1741800239, 2),
(1161, 'cooked_type', '101', 'amunoz', 1741800245, 1741800245, 2),
(1171, 'cooked_type', '111', 'amunoz', 1741800249, 1741800249, 2),
(1201, 'location', '1', 'svassell', 1741963969, 1741963969, 2),
(1211, 'location', '11', 'svassell', 1741963988, 1741963988, 2),
(1221, 'location', '21', 'svassell', 1741964000, 1741964000, 2),
(1232, 'inventory', '51', 'svassell', 1742571063, 1742571062, 2),
(1233, 'inventory', '52', 'svassell', 1742571064, 1742571064, 2),
(1234, 'inventory', '53', 'svassell', 1742571064, 1742571064, 2),
(1235, 'inventory', '54', 'svassell', 1742571064, 1742571064, 2),
(1236, 'inventory', '55', 'svassell', 1742571064, 1742571064, 2),
(1237, 'inventory', '56', 'svassell', 1742571064, 1742571064, 2),
(1238, 'inventory', '57', 'svassell', 1742571064, 1742571064, 2),
(1239, 'inventory', '58', 'svassell', 1742571064, 1742571064, 2),
(1240, 'inventory', '59', 'svassell', 1742571064, 1742571064, 2),
(1241, 'inventory', '60', 'svassell', 1742571064, 1742571064, 2),
(1242, 'inventory', '61', 'svassell', 1742571064, 1742571064, 2),
(1243, 'inventory', '62', 'svassell', 1742571064, 1742571064, 2),
(1244, 'inventory', '63', 'svassell', 1742571064, 1742571064, 2),
(1245, 'inventory', '64', 'svassell', 1742571064, 1742571064, 2),
(1246, 'inventory', '65', 'svassell', 1742571064, 1742571064, 2),
(1247, 'inventory', '66', 'svassell', 1742571065, 1742571065, 2),
(1248, 'inventory', '67', 'svassell', 1742571065, 1742571065, 2),
(1249, 'inventory', '68', 'svassell', 1742571065, 1742571065, 2),
(1250, 'inventory', '69', 'svassell', 1742571065, 1742571065, 2),
(1251, 'inventory', '70', 'svassell', 1742571065, 1742571065, 2);

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

--
-- Table structure for table `sub_cut`
--

CREATE TABLE `sub_cut` (
  `subcutid` int(11) NOT NULL,
  `cutid` int(11) DEFAULT NULL,
  `subcutname` char(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sub_cut`
--

INSERT INTO `sub_cut` (`subcutid`, `cutid`, `subcutname`) VALUES
(1, 1, 'T-Bone'),
(11, 1, 'Ribeye'),
(21, 1, 'Strip'),
(31, 1, 'NY Sirloin'),
(41, 11, '93/7'),
(51, 11, '90/10'),
(61, 11, '80/20'),
(71, 21, 'Pot Roast'),
(81, 21, 'Rump Roast'),
(91, 21, 'Top Round'),
(101, 31, 'Whole'),
(111, 31, 'Sliced'),
(121, 31, 'Ground'),
(131, 61, 'Rack'),
(141, 61, 'Short'),
(151, 71, 'Homemade'),
(161, 71, 'Store Bought'),
(171, 81, 'Pecan Smoked'),
(181, 181, 'Spare'),
(191, 181, 'Spare Seasoned'),
(201, 181, 'Baby Back'),
(211, 181, 'St. Louis'),
(221, 181, 'Short'),
(231, 211, 'Butt'),
(241, 211, 'Shoulder'),
(251, 231, 'Whole'),
(261, 231, 'Sliced'),
(271, 241, 'Salted'),
(281, 241, 'Fresh'),
(291, 251, 'Italian Hot'),
(301, 251, 'Italian Sweet'),
(311, 251, 'Hot Dogs'),
(321, 251, 'Hot Links'),
(331, 251, 'Andouille'),
(341, 251, 'Breakfast'),
(351, 251, 'Eckridge'),
(361, 261, 'Filets'),
(371, 261, 'Patties'),
(381, 281, 'Salted'),
(391, 281, 'Fresh'),
(401, 301, 'Filets'),
(411, 301, 'Nuggets'),
(421, 361, 'Fresh'),
(431, 401, 'Whole'),
(441, 401, 'Sliced'),
(451, 441, 'Whole'),
(461, 441, 'Sliced');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `alte_options`
--
ALTER TABLE `alte_options`
  ADD PRIMARY KEY (`option_id`),
  ADD UNIQUE KEY `option_name` (`option_name`);

--
-- Indexes for table `appgini_csv_import_jobs`
--
ALTER TABLE `appgini_csv_import_jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `memberID` (`memberID`);

--
-- Indexes for table `cooked_type`
--
ALTER TABLE `cooked_type`
  ADD PRIMARY KEY (`cookedid`);

--
-- Indexes for table `cuts`
--
ALTER TABLE `cuts`
  ADD PRIMARY KEY (`cutId`),
  ADD KEY `meatId` (`meatId`);

--
-- Indexes for table `inventory`
--
ALTER TABLE `inventory`
  ADD PRIMARY KEY (`InventoryId`),
  ADD KEY `meatid` (`meatid`),
  ADD KEY `cutid` (`cutid`),
  ADD KEY `subcutid` (`subcutid`),
  ADD KEY `cookedid` (`cookedid`),
  ADD KEY `loc` (`loc`);

--
-- Indexes for table `inventory2`
--
ALTER TABLE `inventory2`
  ADD PRIMARY KEY (`InventoryId`),
  ADD KEY `meatid` (`meatid`),
  ADD KEY `cutid` (`cutid`),
  ADD KEY `subcutid` (`subcutid`),
  ADD KEY `cookedid` (`cookedid`);

--
-- Indexes for table `inventory_history`
--
ALTER TABLE `inventory_history`
  ADD PRIMARY KEY (`hisrotyid`),
  ADD KEY `InventoryId` (`InventoryId`),
  ADD KEY `meatid` (`meatid`),
  ADD KEY `cutid` (`cutid`),
  ADD KEY `subcutid` (`subcutid`),
  ADD KEY `cookedid` (`cookedid`),
  ADD KEY `InventoryId_2` (`InventoryId`),
  ADD KEY `InventoryId_3` (`InventoryId`),
  ADD KEY `InventoryId_4` (`InventoryId`),
  ADD KEY `InventoryId_5` (`InventoryId`);

--
-- Indexes for table `location`
--
ALTER TABLE `location`
  ADD PRIMARY KEY (`locid`);

--
-- Indexes for table `meat`
--
ALTER TABLE `meat`
  ADD PRIMARY KEY (`meatid`);

--
-- Indexes for table `membership_cache`
--
ALTER TABLE `membership_cache`
  ADD PRIMARY KEY (`request`);

--
-- Indexes for table `membership_grouppermissions`
--
ALTER TABLE `membership_grouppermissions`
  ADD PRIMARY KEY (`permissionID`),
  ADD UNIQUE KEY `groupID_tableName` (`groupID`,`tableName`);

--
-- Indexes for table `membership_groups`
--
ALTER TABLE `membership_groups`
  ADD PRIMARY KEY (`groupID`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `membership_userpermissions`
--
ALTER TABLE `membership_userpermissions`
  ADD PRIMARY KEY (`permissionID`),
  ADD UNIQUE KEY `memberID_tableName` (`memberID`,`tableName`);

--
-- Indexes for table `membership_userrecords`
--
ALTER TABLE `membership_userrecords`
  ADD PRIMARY KEY (`recID`),
  ADD UNIQUE KEY `tableName_pkValue` (`tableName`,`pkValue`(100)),
  ADD KEY `pkValue` (`pkValue`),
  ADD KEY `tableName` (`tableName`),
  ADD KEY `memberID` (`memberID`),
  ADD KEY `groupID` (`groupID`);

--
-- Indexes for table `sub_cut`
--
ALTER TABLE `sub_cut`
  ADD PRIMARY KEY (`subcutid`),
  ADD KEY `cutid` (`cutid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `alte_options`
--
ALTER TABLE `alte_options`
  MODIFY `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `cooked_type`
--
ALTER TABLE `cooked_type`
  MODIFY `cookedid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- AUTO_INCREMENT for table `cuts`
--
ALTER TABLE `cuts`
  MODIFY `cutId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=442;

--
-- AUTO_INCREMENT for table `inventory`
--
ALTER TABLE `inventory`
  MODIFY `InventoryId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `inventory2`
--
ALTER TABLE `inventory2`
  MODIFY `InventoryId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventory_history`
--
ALTER TABLE `inventory_history`
  MODIFY `hisrotyid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `location`
--
ALTER TABLE `location`
  MODIFY `locid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `meat`
--
ALTER TABLE `meat`
  MODIFY `meatid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1072;

--
-- AUTO_INCREMENT for table `membership_grouppermissions`
--
ALTER TABLE `membership_grouppermissions`
  MODIFY `permissionID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2657;

--
-- AUTO_INCREMENT for table `membership_groups`
--
ALTER TABLE `membership_groups`
  MODIFY `groupID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=872;

--
-- AUTO_INCREMENT for table `membership_userpermissions`
--
ALTER TABLE `membership_userpermissions`
  MODIFY `permissionID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `membership_userrecords`
--
ALTER TABLE `membership_userrecords`
  MODIFY `recID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1252;

--
-- AUTO_INCREMENT for table `sub_cut`
--
ALTER TABLE `sub_cut`
  MODIFY `subcutid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=462;
COMMIT;

