token|i:124756;dbs|a:1:{s:6:"server";a:1:{s:0:"";a:3:{s:0:"";N;s:8:"winadmin";N;s:4:"ogop";a:18:{i:0;s:18:"information_schema";i:1;s:5:"bcokg";i:2;s:5:"mysql";i:3;s:5:"nshal";i:4;s:4:"ogop";i:5;s:5:"onkcn";i:6;s:5:"onkna";i:7;s:5:"onmsg";i:8;s:5:"onoos";i:9;s:5:"onorl";i:10;s:5:"onosh";i:11;s:5:"onott";i:12;s:5:"onscr";i:13;s:5:"onvgn";i:14;s:5:"onwin";i:15;s:18:"performance_schema";i:16;s:5:"skrgn";i:17;s:5:"skssk";}}}}pwds|a:1:{s:6:"server";a:1:{s:0:"";a:2:{s:8:"winadmin";N;s:4:"ogop";s:16:"aFxJWZmStXMqqP.K";}}}queries|a:1:{s:6:"server";a:1:{s:0:"";a:1:{s:4:"ogop";a:2:{s:0:"";a:1:{i:0;a:2:{i:0;s:24:"CREATE DATABASE `onoos`;";i:1;i:1589821284;}}s:5:"onoos";a:1:{i:0;a:2:{i:0;s:3304:"-- Adminer 4.0.0 MySQL dump

SET NAMES utf8;
SET foreign_key_checks = 0;
SET time_zone = '-07:00';
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `inventory_prices`;
CREATE TABLE `inventory_prices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemID` mediumint(8) unsigned zerofill NOT NULL,
  `price` decimal(5,2) NOT NULL,
  `mod_userID` mediumint(9) NOT NULL,
  `mod_date` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `itemID` (`itemID`),
  KEY `price` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `payment_options`;
CREATE TABLE `payment_options` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `pay_how` varchar(15) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pay_how` (`pay_how`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `payment_options` (`id`, `pay_how`) VALUES
(1,	'Cash'),
(3,	'Debit'),
(6,	'Gift Cert'),
(4,	'Mastercard'),
(5,	'Visa');

DROP TABLE IF EXISTS `pos_items`;
CREATE TABLE `pos_items` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `itemID` mediumint(8) unsigned zerofill NOT NULL,
  `transaction` int(8) NOT NULL,
  `itemPrice` decimal(10,2) NOT NULL,
  `itemTax` decimal(10,2) NOT NULL,
  `itemTotal` decimal(10,2) NOT NULL,
  `itemUserID` smallint(5) unsigned zerofill NOT NULL,
  `status` tinyint(1) unsigned zerofill NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `transaction` (`transaction`),
  KEY `itemID` (`itemID`),
  KEY `itemUserID` (`itemUserID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `pos_payments`;
CREATE TABLE `pos_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction` int(11) NOT NULL,
  `paymentType` tinyint(4) NOT NULL,
  `paymentAmount` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `transaction` (`transaction`),
  KEY `paymentType` (`paymentType`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `pos_sales`;
CREATE TABLE `pos_sales` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `soldWhen` datetime NOT NULL,
  `soldBy` smallint(6) NOT NULL,
  `subTotal` decimal(10,2) NOT NULL,
  `grandTotal` decimal(10,2) NOT NULL,
  `itemCount` int(11) NOT NULL,
  `status` tinyint(4) unsigned NOT NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `soldWhen` (`soldWhen`),
  KEY `soldBy` (`soldBy`),
  KEY `subtotal` (`subTotal`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `user_inventory`;
CREATE TABLE `user_inventory` (
  `id` mediumint(8) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `userID` int(11) NOT NULL,
  `eventID` smallint(6) NOT NULL,
  `description` text,
  `discount` tinyint(4) DEFAULT NULL,
  `donate_after` enum('Y','N') DEFAULT 'Y',
  `category` smallint(4) NOT NULL,
  `event_type` tinyint(4) NOT NULL DEFAULT '1',
  `size` smallint(4) DEFAULT NULL,
  `tax` enum('Y','N','E') NOT NULL DEFAULT 'Y',
  `reconciliationID` mediumint(9) NOT NULL DEFAULT '0',
  `date_added` date NOT NULL,
  `mod_userID` mediumint(9) NOT NULL,
  `mod_date` datetime NOT NULL,
  `status` char(1) NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `userID` (`userID`),
  KEY `reconciliationID` (`reconciliationID`),
  KEY `eventID` (`eventID`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Consignors manage their inventories here';


-- 2017-10-04 18:53:35
;";i:1;i:1589821318;}}}}}}messages|a:0:{}