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

START TRANSACTION;



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

--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `id_attendance` int(5) NOT NULL,
  `date` date NOT NULL,
  `hour` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `latitude` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `longitude` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `device` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `staff` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `user` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `name_attendance` varchar(200) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id_category` int(5) NOT NULL,
  `name_category` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `type_category` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `user` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `color`
--

CREATE TABLE `color` (
  `id_color` int(5) NOT NULL,
  `name_color` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `code_color` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `status` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `color`
--

INSERT INTO `color` (`id_color`, `name_color`, `code_color`, `status`) VALUES
(9, 'Red', 'red', 0),
(10, 'Green', 'green', 0),
(11, 'Purple', 'purple', 0),
(12, 'Black', 'black', 0),
(13, 'Orange', 'orange', 0),
(14, 'Blue', 'blue', 0),
(15, 'Brown', 'brown', 0),
(16, 'Coral', 'coral', 0),
(17, 'Cadetblue', 'cadetblue', 0),
(18, 'Darkblue', 'darkblue', 0),
(19, 'DarkGrenn', 'darkgreen', 0),
(20, 'Pink', 'deeppink', 0),
(21, 'SkyBlue', 'deepskyblue', 0);

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

--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `id_customer` int(5) NOT NULL,
  `name_customer` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `address` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `telephone` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `status` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `user` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `debt` int(5) NOT NULL DEFAULT '0',
  `img` varchar(20) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `discount`
--

CREATE TABLE `discount` (
  `id_discount` int(5) NOT NULL,
  `name_discount` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `note` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `type` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `nominal` int(10) NOT NULL,
  `user` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `active` int(5) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `link`
--

CREATE TABLE `link` (
  `id_link` int(5) NOT NULL,
  `name_link` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `link`
--

INSERT INTO `link` (`id_link`, `name_link`, `status`) VALUES
(9, 'Credit Card', 0),
(10, 'Debit Card', 0),
(11, 'E-Money', 0);

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

--
-- Table structure for table `logscustomerdebtpayments`
--

CREATE TABLE `logscustomerdebtpayments` (
  `id_logscustomerdebtpayments` int(5) NOT NULL,
  `id_customer` int(200) NOT NULL,
  `user` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `no_invoice` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `nominal` int(250) NOT NULL,
  `date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id_news` int(5) NOT NULL,
  `title` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `detail` text COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id_news`, `title`, `detail`) VALUES
(2, 'News title 1', '<p>this is news 1, please change or add from backend page</p>\r\n'),
(3, 'News title 2', '<p>this is news 2, please change or add from backend page</p>\r\n\r\n<p>Je susi de retour</p>\r\n'),
(4, 'Premium upgrade promo', '<p>upgrade today get 50% discount from normal upgrade fee</p>\r\n'),
(5, 'One step to business success', '<p>start using digital technology to make your business easier, Use this application for more advanced businesses</p>\r\n');

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

--
-- Table structure for table `online_store`
--

CREATE TABLE `online_store` (
  `id_online_store` int(5) NOT NULL,
  `user` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `address_store` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `color_store` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `linkfb` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `linkinstagram` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `nowa` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `operational_hour` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `status` int(200) NOT NULL,
  `subdomain` varchar(50) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id_packages` int(5) NOT NULL,
  `name_packages` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id_packages`, `name_packages`, `status`) VALUES
(0, 'Basic Member (Free)', 0),
(1, 'Premium Member', 0);

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

--
-- Table structure for table `page`
--

CREATE TABLE `page` (
  `id_page` int(5) NOT NULL,
  `title` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `detail` text COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `page`
--

INSERT INTO `page` (`id_page`, `title`, `detail`) VALUES
(1, 'Privacy Policy', 'fill the content of the backend page\r\n'),
(2, 'term and conditions', 'fill the content of the backend page'),
(3, 'About Us', 'fill the content of the backend page');

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id_product` int(5) NOT NULL,
  `id_category` int(50) NOT NULL,
  `user` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `name_product` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `codeproduct` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `type` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `purchase_price` int(10) NOT NULL,
  `selling_price` int(10) NOT NULL,
  `stock` int(10) NOT NULL,
  `minimalstock` int(250) NOT NULL,
  `discount` int(10) NOT NULL,
  `description` text COLLATE latin1_general_ci NOT NULL,
  `img` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `folder` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `online` int(11) NOT NULL,
  `wholesale_price` int(250) NOT NULL,
  `preorder` int(10) NOT NULL,
  `minimum_purchase` int(10) NOT NULL,
  `have_stock` int(200) NOT NULL,
  `showing` int(5) NOT NULL DEFAULT '0',
  `session` varchar(250) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `purchase`
--

CREATE TABLE `purchase` (
  `id_purchase` int(5) NOT NULL,
  `id_supplier` int(10) NOT NULL,
  `id_product` int(10) NOT NULL,
  `id_store` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `user` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `no_invoice` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `amount` int(10) NOT NULL,
  `price` int(10) NOT NULL,
  `totalprice` int(10) NOT NULL,
  `date` date NOT NULL,
  `status` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `note` varchar(50) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `purchasing_data`
--

CREATE TABLE `purchasing_data` (
  `id_purchasing_data` int(5) NOT NULL,
  `user` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `id_supplier` int(10) NOT NULL,
  `id_store` int(10) NOT NULL,
  `no_invoice` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `date` date NOT NULL,
  `note` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `totalorder` int(10) NOT NULL,
  `changepay` int(10) NOT NULL,
  `status` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `due_date` date NOT NULL,
  `operator` varchar(20) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id_sales` int(5) NOT NULL,
  `id_customer` int(10) NOT NULL,
  `id_store` int(10) NOT NULL,
  `user` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `no_invoice` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `amount` int(10) NOT NULL,
  `price` int(10) NOT NULL,
  `date` date NOT NULL,
  `status` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `note` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `rest_stock` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `sales_data`
--

CREATE TABLE `sales_data` (
  `id_sales_data` int(5) NOT NULL,
  `user` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `id_customer` int(5) NOT NULL,
  `id_store` int(5) NOT NULL,
  `no_invoice` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `date` date NOT NULL,
  `payment` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `totalorder` int(255) NOT NULL,
  `totalprice` int(10) NOT NULL,
  `changepay` int(10) NOT NULL,
  `due_date` date NOT NULL,
  `tax` int(10) NOT NULL,
  `discount` int(10) NOT NULL,
  `service_charge` int(200) NOT NULL,
  `operator` varchar(20) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id_setting` int(5) NOT NULL,
  `name_program` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `info_premium` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `url_program` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `email` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `phone_number` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id_setting`, `name_program`, `info_premium`, `url_program`, `email`, `phone_number`) VALUES
(1, 'My Store', '<ul>\r\n	<li>\r\n	<p>no ads for premium</p>\r\n	</li>\r\n	<li>\r\n	<p>No App branding on receipt, on the transaction history page and on the pay slips.</p>\r\n	</li>\r\n	<li>\r\n	<p>Multi outlet (branch)</p>\r\n	</li>\r\n	<li>\r\n	<p>Unlimited Employees (Maximum 2 employees for basic account)</p>\r\n	</li>\r\n	<li>\r\n	<p>you can add premium features with a little touch in the app</p>\r\n	</li>\r\n</ul>\r\n', 'http://139.180.141.42', 'support@mystore.com', '6281234567890');

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

--
-- Table structure for table `spending`
--

CREATE TABLE `spending` (
  `id_spending` int(5) NOT NULL,
  `name_spending` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `user` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `no_invoice` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `nominal` int(10) NOT NULL,
  `date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `spending_data`
--

CREATE TABLE `spending_data` (
  `id_spending_data` int(5) NOT NULL,
  `user` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `id_store` int(10) NOT NULL,
  `no_invoice` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `totalnominal` int(10) NOT NULL,
  `operator` varchar(20) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `stock`
--

CREATE TABLE `stock` (
  `id_stock` int(5) NOT NULL,
  `id_product` int(250) NOT NULL,
  `id_store` int(250) NOT NULL,
  `stock` int(250) NOT NULL,
  `user` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `session` varchar(200) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `store`
--

CREATE TABLE `store` (
  `id_store` int(5) NOT NULL,
  `name_store` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `number_store` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `nohp` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `address` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `tax` int(10) NOT NULL,
  `service_charge` int(10) NOT NULL,
  `type` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `id_supplier` int(5) NOT NULL,
  `user` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `name_supplier` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `address` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `telephone` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `debt` int(10) NOT NULL DEFAULT '0',
  `img` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `active` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Indexes for table `attendance`
--
ALTER TABLE `attendance`
  ADD PRIMARY KEY (`id_attendance`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id_category`);

--
-- Indexes for table `color`
--
ALTER TABLE `color`
  ADD PRIMARY KEY (`id_color`);

--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`id_customer`);

--
-- Indexes for table `discount`
--
ALTER TABLE `discount`
  ADD PRIMARY KEY (`id_discount`);

--
-- Indexes for table `link`
--
ALTER TABLE `link`
  ADD PRIMARY KEY (`id_link`);

--
-- Indexes for table `logscustomerdebtpayments`
--
ALTER TABLE `logscustomerdebtpayments`
  ADD PRIMARY KEY (`id_logscustomerdebtpayments`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id_news`);

--
-- Indexes for table `online_store`
--
ALTER TABLE `online_store`
  ADD PRIMARY KEY (`id_online_store`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id_packages`);

--
-- Indexes for table `page`
--
ALTER TABLE `page`
  ADD PRIMARY KEY (`id_page`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`id_product`);

--
-- Indexes for table `purchase`
--
ALTER TABLE `purchase`
  ADD PRIMARY KEY (`id_purchase`);

--
-- Indexes for table `purchasing_data`
--
ALTER TABLE `purchasing_data`
  ADD PRIMARY KEY (`id_purchasing_data`);

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`id_sales`);

--
-- Indexes for table `sales_data`
--
ALTER TABLE `sales_data`
  ADD PRIMARY KEY (`id_sales_data`);

--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`id_setting`);

--
-- Indexes for table `spending`
--
ALTER TABLE `spending`
  ADD PRIMARY KEY (`id_spending`);

--
-- Indexes for table `spending_data`
--
ALTER TABLE `spending_data`
  ADD PRIMARY KEY (`id_spending_data`);

--
-- Indexes for table `stock`
--
ALTER TABLE `stock`
  ADD PRIMARY KEY (`id_stock`);

--
-- Indexes for table `store`
--
ALTER TABLE `store`
  ADD PRIMARY KEY (`id_store`);

--
-- Indexes for table `supplier`
--
ALTER TABLE `supplier`
  ADD PRIMARY KEY (`id_supplier`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `attendance`
--
ALTER TABLE `attendance`
  MODIFY `id_attendance` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id_category` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `color`
--
ALTER TABLE `color`
  MODIFY `id_color` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `id_customer` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `discount`
--
ALTER TABLE `discount`
  MODIFY `id_discount` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `link`
--
ALTER TABLE `link`
  MODIFY `id_link` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `logscustomerdebtpayments`
--
ALTER TABLE `logscustomerdebtpayments`
  MODIFY `id_logscustomerdebtpayments` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id_news` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `online_store`
--
ALTER TABLE `online_store`
  MODIFY `id_online_store` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id_packages` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `page`
--
ALTER TABLE `page`
  MODIFY `id_page` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id_product` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase`
--
ALTER TABLE `purchase`
  MODIFY `id_purchase` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchasing_data`
--
ALTER TABLE `purchasing_data`
  MODIFY `id_purchasing_data` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `id_sales` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales_data`
--
ALTER TABLE `sales_data`
  MODIFY `id_sales_data` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `id_setting` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `spending`
--
ALTER TABLE `spending`
  MODIFY `id_spending` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `spending_data`
--
ALTER TABLE `spending_data`
  MODIFY `id_spending_data` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock`
--
ALTER TABLE `stock`
  MODIFY `id_stock` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `store`
--
ALTER TABLE `store`
  MODIFY `id_store` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `id_supplier` int(5) NOT NULL AUTO_INCREMENT;
COMMIT;

