-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Sep 05, 2018 at 05:12 PM
-- Server version: 10.1.29-MariaDB
-- PHP Version: 7.2.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `plantasticdb`
--

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

--
-- Table structure for table `tblaccounts`
--

CREATE TABLE `tblaccounts` (
  `accountEmail` varchar(45) DEFAULT NULL,
  `accountUser` varchar(45) NOT NULL,
  `accountFN` varchar(45) DEFAULT NULL,
  `accountLN` varchar(45) DEFAULT NULL,
  `accountPhone` varchar(45) DEFAULT NULL,
  `accountAddress` varchar(45) DEFAULT NULL,
  `accountPassword` varchar(256) NOT NULL,
  `accountType` int(11) NOT NULL,
  `accountLastLogin` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblaccounts`
--

INSERT INTO `tblaccounts` (`accountEmail`, `accountUser`, `accountFN`, `accountLN`, `accountPhone`, `accountAddress`, `accountPassword`, `accountType`, `accountLastLogin`) VALUES
('asd@gmail.com', 'asd', 'asd', 'asd', '4787', 'asd', '$2y$10$2a392UqXZsgjKRXefOm6Ve48cpbUQjFOsd4daP5hktv.Y5DgCz2Oy', 2, '2018-09-02'),
('Neptune@neptunia.com', 'nepnep', 'nep', 'nep', '8548484', 'nepnep', '$2y$10$0ExsueMWcXTZL4JyE9Ie7ehwelbLgTFaPTSJ.1t1aIQ1spuBCrUA2', 2, '2018-09-04'),
('NewUser@gmail.com', 'NewUser', 'New', 'User', '09205292676', 'Kanto lang Kya', '$2y$10$P/5XSWox12V0NwgCD.ejx.s47JNZYFpCwkjXs/fbBem4G9NIOuiAi', 2, '2018-08-28'),
('AdminRpg@plantastic.com.ph', 'Pladmin', 'Kiel', 'Nocito', '09205292676', 'Unit C, 431 Arenas St, Sampaloc Manila, Metro', '$2y$10$aU4uub2SI9yfbXEQSgzQOuFWX1mLHGt3Qc99vX18iFG43n/4bmPAS', 1, '2018-09-05'),
('qwe143@gmail.com', 'qwe', 'Juan', 'Dela Cruz', '054189', 'Bahay Kubo Kublot', '$2y$10$OeaAe0eKq9us02fsadIRFewmz8EnWocJOJRnUTBTRIxOrorLrk3sq', 2, '2018-08-27'),
('kristineadlaon97@gmail.com', 'qwerty', 'qwer', 'ty', '15487', 'asdasd', '$2y$10$dbyVcm9hJKjqekKeDeiuoecCchUj0QvZeTGiHm89oUpKX3di7v5Fi', 2, '2018-08-19');

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

--
-- Table structure for table `tblproducts`
--

CREATE TABLE `tblproducts` (
  `productID` int(20) NOT NULL,
  `productName` varchar(45) NOT NULL,
  `productDesc` text NOT NULL,
  `productPrice` double NOT NULL,
  `productStock` int(11) NOT NULL,
  `productImage` varchar(256) NOT NULL,
  `productType` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblproducts`
--

INSERT INTO `tblproducts` (`productID`, `productName`, `productDesc`, `productPrice`, `productStock`, `productImage`, `productType`) VALUES
(1, 'AloeVera', 'Aloe Vera is a herb that grows in warm climates and is widely distributed in Philippines, India, and Africa. Aloe vera was historically used to heal wounds and treat various skin conditions, Aloe was also taken orally as a laxative.', 110, 70, 'res/products/md/AloeVera.jpg', 'plants'),
(2, 'Avocado', 'Avocado can grow to heights of 40 to 80 feet and is well branched forming a broad tree. Avocado is highly valued for its fruit and oil. ', 415, 53, 'res/products/md/Avocado.jpg', 'plants'),
(3, 'Akapulko', 'Akapulko is used as herbal medicine to treat bronchitis and asthma. Because of Akapulkos anti-fungal properties, it is a common ingredient in soaps, shampoos, and lotions in the Philippines.', 160, 62, 'res/products/md/Akapulko.jpg', 'plants'),
(4, 'Ampalaya', 'Ampalaya or bitter melon also known as bitter gourd as the name implies has a bitter taste due to the presence of momordicin, and is believed to be among the most bitter of all vegetables. ', 150, 31, 'res/products/md/Ampalaya.jpg', 'plants'),
(5, 'Banaba', 'The Banaba leaves and flowers contain corrosolic acid, a substance being studied for its insulin like effect of lowering the glucose in the body.  Banaba is widely used in the Philippines  in traditional medicine as herbal treatment for diabetes.', 220, 65, 'res/products/md/Banaba.jpg', 'plants'),
(6, 'Banana', 'The banana is one of the most nutritious fruits that provides valuable health benefits to the body.Comparatively speaking, bananas are more nutritious than apples. It is rich in potassium, have five times more vitamin A and iron and have two times more carbohydrates and three times as much phosphorous.', 190, 38, 'res/products/md/Banana.jpg', 'plants'),
(7, 'Bayabas', 'Bayabas produce a round globular bayabas fruit that starts as a flower. The bayabas fruit is green and turns yellowish-green and soft when ripe. Bayabas fruit has many small hard seeds contained in a yellowish pulp.', 220, 35, 'res/products/md/Bayabas.jpg', 'plants'),
(8, 'Celery', 'Celery has leaf stalks that are conical in shape growing from a common base and are topped with leaves that are pinnate to bipinnate with rhombic leaflets about 3 to 6 cm long and 2 to 5 cm broad.', 20, 59, 'res/products/md/Celery.jpg', 'plants'),
(9, 'Buko', 'The Coconut / Buko tree has erect graceful gray colored trunk, swollen at the base and grows slightly curved. The truck is ringed due to old leaf scars and is smooth.', 410, 67, 'res/products/md/Coco.jpg', 'plants'),
(10, 'Caterpillar Fungus', 'The fruiting body which is composed the remains of the caterpillar and the fungus are then hand collected, dried and preserved to be used as an herbal medicine.', 510, 46, 'res/products/md/Caterpillar.jpg', 'plants'),
(11, 'Lagundi', 'Lagundi leaves appear palmately, in the form of five pointed leaves which splay out like the fingers of a hand. Lagundi leaves are 5-foliate, rarely with 3 leaflets only. Lagundi leaves are 4-10 cm long, slightly hairy beneath. ', 150, 76, 'res/products/md/Lagundi.jpg', 'plants'),
(12, 'Lemon Grass', 'Lemon grass (Cymbopogon citratus), a native herb from temperate and warm regions such as India, Philippines and Malaysia, is widely used in Asian cooking and is an ingredient in many Thai and Vietnamese foods. ', 510, 47, 'res/products/md/Lemongrass.jpg', 'plants'),
(13, 'Malunggay', 'Malunggay is a popular plant known for high nutritional value as well as an herbal medicine. Malunggay is a plant that grows in the tropical climates such as the Philippines, India and Africa. Malunggay is widely used as vegetable ingredient in cooking, as herbal medicine for a number of illness and other practical uses.', 90, 78, 'res/products/md/Malunggay.jpg', 'plants'),
(14, 'Niyog-niyogan', 'Niyog-niyogan or Rangoon creeper shrub has fragrant and colorful flowers. Niyog-niyogan flowers exhibit varying colors, from white, red, reddish purple, pink red to orange that sprouts into clusters. Niyog-niyogan has edible fruit that is ellipsoidal in shape with five lengthwise wings. ', 290, 83, 'res/products/md/NiyogNiyogan.jpg', 'plants'),
(15, 'Oregano', 'Oregano is more popularly known for its aromatic and balsamic flavor and is commonly used as mint flavoring in Mediterranean and Mexican foods.  ', 220, 78, 'res/products/md/Oregano.jpg', 'plants'),
(16, 'Saluyot', 'Saluyot (Corchorus olitorius) is an edible leafy vegetable that is a member of the  genus Corchorus, classified under the subfamily Grewioideae of the family Malvaceae. Saluyot is widely found in tropical and subtropical areas from Asia to Africa valued as food and for its strong fiber.', 30, 60, 'res/products/md/Saluyot.jpg', 'plants'),
(17, 'Sambong', 'Sambong is used as herbal medicine and is a shrub that grows wild in the tropical climate countries such as Philippines, India, Africa and found even in eastern Himalayas. Sambong is widely used in the Philippines as herbal medicine. ', 60, 57, 'res/products/md/Sambong.jpg', 'plants'),
(18, 'Tongkat Ali', 'Tongkat ali   is a flowering plant that is native in Southeast Asian countries such as Malaysia, Indonesia, Vietnam and the Philippines. Tongkat ali is a treelet that takes about 20 years to mature and grows up to 15 meters in height. ', 270, 46, 'res/products/md/TongkatAli.jpg', 'plants'),
(19, 'Bawang', 'Bawang or garlic, is a specie in the onion family Alliaceae. Bawang is a close relative of onion (sibuyas), the shallot, the leek and the chive. Bawang has been used throughout recorded history for both culinary and medicinal purposes. ', 170, 97, 'res/products/md/Garlic.jpg', 'plants');

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

--
-- Table structure for table `tbltransact`
--

CREATE TABLE `tbltransact` (
  `transactID` varchar(255) NOT NULL,
  `transactUser` varchar(255) NOT NULL,
  `transactDate` date NOT NULL,
  `transactProducts` text NOT NULL,
  `transactTotal` double NOT NULL,
  `transactStatus` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbltransact`
--

INSERT INTO `tbltransact` (`transactID`, `transactUser`, `transactDate`, `transactProducts`, `transactTotal`, `transactStatus`) VALUES
('20180831054342', 'qwe', '2018-08-30', 'AloeVera-1, Avocado-1, Akapulko-1, ', 685, 'Complete'),
('20180831060921', 'qwe', '2018-08-31', 'AloeVera-1, Avocado-1, Akapulko-1, Ampalaya-1, Buko-1, ', 1245, 'Complete'),
('20180831061933', 'asd', '2018-09-01', 'AloeVera-1, Avocado-1, Akapulko-1, Lemon Grass-1, Sambong-1, ', 1255, 'Complete'),
('20180831065615', 'qwe', '2018-09-01', 'Avocado-1, Akapulko-1, Bawang-1, ', 745, 'Canceled'),
('20180831065626', 'qwe', '2018-09-02', 'AloeVera-1, Lagundi-1, Lemon Grass-1, Sambong-1, ', 830, 'Complete'),
('20180831065637', 'qwe', '2018-09-02', 'Buko-1, Lagundi-1, Saluyot-1, ', 590, 'Complete'),
('20180903022749', 'asd', '2018-09-03', 'Bayabas-1, Lemon Grass-1, ', 730, 'Pending'),
('20180903112059', 'nepnep', '2018-09-03', 'Banana-1, Buko-1, Malunggay-1, Niyog-niyogan-3, ', 1560, 'Complete'),
('20180903115252', 'nepnep', '2018-09-03', 'Banana-1, Celery-1, Buko-1, ', 620, 'Complete'),
('20180904010319', 'nepnep', '2018-09-04', 'Akapulko-1, Niyog-niyogan-1, Tongkat Ali-1, Bawang-1, ', 890, 'Complete'),
('20180904113451', 'nepnep', '2018-09-04', 'AloeVera-1, ', 110, 'Pending');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tblaccounts`
--
ALTER TABLE `tblaccounts`
  ADD PRIMARY KEY (`accountUser`);

--
-- Indexes for table `tblproducts`
--
ALTER TABLE `tblproducts`
  ADD PRIMARY KEY (`productID`);

--
-- Indexes for table `tbltransact`
--
ALTER TABLE `tbltransact`
  ADD PRIMARY KEY (`transactID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tblproducts`
--
ALTER TABLE `tblproducts`
  MODIFY `productID` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;