Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.8.4
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1
- -- Generation Time: Feb 05, 2019 at 09:18 PM
- -- Server version: 10.1.37-MariaDB
- -- PHP Version: 7.3.1
- 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: `test`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `tbl_coffee_strength`
- --
- CREATE TABLE `tbl_coffee_strength` (
- `Id` int(11) NOT NULL,
- `Strength` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `tbl_coffee_strength`
- --
- INSERT INTO `tbl_coffee_strength` (`Id`, `Strength`) VALUES
- (2, 'Light Roast'),
- (4, 'Dark Roast');
- -- --------------------------------------------------------
- --
- -- Table structure for table `tbl_item`
- --
- CREATE TABLE `tbl_item` (
- `ID` int(11) NOT NULL,
- `Name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `Cost_Price` decimal(15,2) NOT NULL,
- `Quantity` int(11) NOT NULL,
- `Sell_Price` decimal(15,2) NOT NULL,
- `Coffee_Strength_Id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `tbl_item`
- --
- INSERT INTO `tbl_item` (`ID`, `Name`, `Cost_Price`, `Quantity`, `Sell_Price`, `Coffee_Strength_Id`) VALUES
- (3, 'Bella Donovan', '80.00', 200, '100.00', 2),
- (4, 'Giant Steps', '80.00', 50, '100.00', 2),
- (5, 'Three Africas', '80.00', 50, '100.00', 2),
- (6, 'Beta Blend', '80.00', 50, '100.00', 2),
- (7, 'New Orleans Iced Kit', '80.00', 50, '100.00', 2),
- (8, 'Uganda Sipi Falls', '80.00', 50, '100.00', 2),
- (9, 'Honduras Santa Elena', '80.00', 50, '100.00', 2),
- (10, 'Ecuador Pichincha', '80.00', 50, '100.00', 4),
- (11, 'Kenya Kiambu Handege', '80.00', 50, '100.00', 4),
- (12, 'Costa Rica Lourdes de Naranjo', '80.00', 50, '100.00', 4),
- (13, 'Opascope Espresso', '80.00', 50, '100.00', 4),
- (14, 'Ethiopia Gera Abana Estate', '80.00', 50, '100.00', 4),
- (15, 'Honduras Santa Elena', '80.00', 50, '100.00', 4);
- -- --------------------------------------------------------
- --
- -- Table structure for table `tbl_user`
- --
- CREATE TABLE `tbl_user` (
- `ID` int(11) NOT NULL,
- `FName` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `LName` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `Email` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `Password` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `tbl_user`
- --
- INSERT INTO `tbl_user` (`ID`, `FName`, `LName`, `Email`, `Password`) VALUES
- (1, 'Wesley', 'Holligan', 'wholligan0@cnbc.com', '51d3c20e675bde5a9f4e108bf381e54e9dc5ff5b'),
- (2, 'Charlotta', 'Tremolieres', 'ctremolieres1@sina.com.cn', '07a1f7089eae19fa1c364a54a775d2f246a8dc0d'),
- (3, 'Carmine', 'Buten', 'cbuten2@tripod.com', 'd8463650a49c56008c28cbea7e929e2b89221c09'),
- (4, 'Katine', 'Burghill', 'kburghill3@pcworld.com', 'd0234e4dceef542cc51cbf74e4edea44dc645f21'),
- (5, 'Alejoa', 'Croote', 'acroote4@state.tx.us', '221f1ed9a44dab2ced5ee51939d38e369d0b6ba0'),
- (6, 'Kaitlyn', 'Jacson', 'kjacson5@google.de', 'ab6b28fd98c6991bf60e947469f728cd5e7e272a'),
- (7, 'Staford', 'Empleton', 'sempleton6@ovh.net', 'a2c3c63475d14f6a6619a283578ccace6396cb5b'),
- (8, 'Nisse', 'Demoge', 'ndemoge7@alibaba.com', '3035331fd97d628d2838f9b66b48c23042b507d0'),
- (9, 'Del', 'Armes', 'darmes8@ycombinator.com', '83febb2e64d6e446b23ef91074de75583dbd060a'),
- (10, 'Mae', 'Klewi', 'mklewi9@bloglines.com', '56bd83de461e56262453f0fd4d871e8934dd718d'),
- (11, 'Daune', 'Stood', 'dstooda@who.int', '705e4f8c3641d564b580e5b5181b505d6267d937'),
- (12, 'Dedie', 'Risby', 'drisbyb@cam.ac.uk', '0f23a3743321a02a931b01a3f0957544dc02f178'),
- (13, 'Klarrisa', 'Bradlaugh', 'kbradlaughc@google.cn', 'f4c788735a8408f67e8faeaa23e482c3ee0ec946'),
- (14, 'Karalynn', 'Croyser', 'kcroyserd@godaddy.com', '8e6434ac1fed2b3a86783c0fb587d50d568d2947'),
- (15, 'William', 'Rainey', 'wraineye@jigsy.com', '3254c39e947193e8a155d61b76148eb61b95ba2f'),
- (16, 'Davidson', 'Drain', 'ddrainf@yahoo.co.jp', '363db33cf6cdd73c52c0126d5838d3c7c572ff35'),
- (17, 'Sharity', 'Murr', 'smurrg@businessweek.com', 'ddce5b498e915f28ff6a81cb8b335d0f566a555f'),
- (18, 'Weylin', 'Dow', 'wdowh@csmonitor.com', 'c8a215e0d86f0cf68c18ffc619046024f6074d8f'),
- (19, 'Bette-ann', 'Ebbotts', 'bebbottsi@multiply.com', '626a4532783b33b03a27e5e44404d315ee4167b3'),
- (20, 'Henderson', 'Izkoveski', 'hizkoveskij@sogou.com', '911dcdea529e33987271c0a0f73be714e06d2682'),
- (21, 'Eugenia', 'Wicklen', 'ewicklenk@theglobeandmail.com', 'ce710341e1e4d39dd7cf4810038dc212f56da135'),
- (22, 'Bernie', 'Lannin', 'blanninl@g.co', '12fd21bfe8f2d19a90a3f9914d2e20d82769d2f9'),
- (23, 'Jobi', 'Ruggiero', 'jdiruggierom@aol.com', 'e85271318a76b1602cf6c4b2e51da06d63ab86b7'),
- (24, 'Rem', 'Orviss', 'rorvissn@mozilla.org', '8f759da7c137197c9fdbef206a4573dae5bb4af0'),
- (25, 'Tersina', 'Peller', 'tpellero@illinois.edu', '338c927de99626e52a0837f0a6ce594c83cabe13'),
- (26, 'Hobart', 'Banner', 'hbannerp@timesonline.co.uk', '50ccb2a7990d6fb22247c54d9493080604eab8a8'),
- (27, 'Beverly', 'Beedom', 'bbeedomq@adobe.com', 'e80d62f52695e44b11b502ebb437dd725b6e066f'),
- (28, 'Melicent', 'Simonsen', 'msimonsenr@harvard.edu', '22d153737f9f8ba4ca3d2ea9680999c4b487aa47'),
- (29, 'Ainslee', 'Cancellor', 'acancellors@tamu.edu', '409c607b024861b981064a17c3b572f7ec037454'),
- (30, 'Bartel', 'Mears', 'bmearst@google.ca', '7ac704408c103f65c1229ca0d4e46d7b5363f5b7'),
- (31, 'Kurtis', 'Kighly', 'kkighlyu@blogger.com', '922eeb48d6c980892b910a2903f50b8cb980705c'),
- (32, 'Urson', 'Hansed', 'uhansedv@live.com', 'ee5569c3499083c81860c20cefafc0b5cb8b3518'),
- (33, 'Christine', 'Corkitt', 'ccorkittw@washingtonpost.com', '25e59869fbdbf7b9d8b4497e080048fce4168282'),
- (34, 'Marianna', 'Carnie', 'mcarniex@bizjournals.com', '09c136a7c32997b7a720fe54a45567230d1cb445'),
- (35, 'Kirk', 'Whapple', 'kwhappley@e-recht24.de', '78dd9d4bfb280bffa6e83876a1525fd7ac82a43c'),
- (36, 'Alisun', 'Bollam', 'abollamz@jiathis.com', '286f27c895682c2781c97dd9ac8d19f183a04036'),
- (37, 'Roch', 'Buckle', 'rbuckle10@infoseek.co.jp', '90069d76854709003139b1db46051ac35f77a0e8'),
- (38, 'Alvira', 'Geyton', 'ageyton11@bravesites.com', '6e4d868c9953acb025d60f9f2a3b79fa517a75ed'),
- (39, 'Kyla', 'McCabe', 'kmccabe12@xing.com', 'b975e4c1d3b7aa9c2250111d12141f5c7ea8797c'),
- (40, 'Bernadene', 'Lillyman', 'blillyman13@yahoo.com', '823a1e6add24da650e6f3255b5d4c327299fe369'),
- (41, 'Gregoire', 'Haking', 'ghaking14@clickbank.net', 'e4a4d009e498e20164c9eea4f4c46a0462e3df87'),
- (42, 'Berne', 'Sweetman', 'bsweetman15@hp.com', 'c5a7afdb9205aca0e761ae01f7ff2f7c6aa88ce0'),
- (43, 'Bobby', 'Sehorsch', 'bsehorsch16@ibm.com', 'd1146172805e18f08ab536ea64e98e8b4c5c57b9'),
- (44, 'Garreth', 'Firminger', 'gfirminger17@bizjournals.com', 'ef489e1c289fa8b9c0b36ba3c097b445838734b5'),
- (45, 'Lonnard', 'Bibey', 'lbibey18@psu.edu', '725deb74b8d2db55b2c421a4c6c767303cf81b09'),
- (46, 'Cosette', 'McElhinney', 'cmcelhinney19@flavors.me', '13a91775423a2b7352dc0e381a7ccb264cad7fb6'),
- (47, 'Dennie', 'Faunch', 'dfaunch1a@elegantthemes.com', 'bfb5e95adba967ee905c10dd79155fc4af5fc6c2'),
- (48, 'Ailina', 'Edgcumbe', 'aedgcumbe1b@bloomberg.com', 'd1d84ec3a1d08a9a5a3895e22efe7429990e1808'),
- (49, 'Margie', 'Hirtz', 'mhirtz1c@a8.net', '1228c335edd393d8f341883c7f38dadb020519af'),
- (50, 'Sallyann', 'Enever', 'senever1d@comsenz.com', '72df9e7423103bddcf07178d8fe6f973a01fc305'),
- (51, 'Odey', 'Letteresse', 'oletteresse1e@nasa.gov', 'a49b2d9550ab58eb41cd1129daa399ab2944f977'),
- (52, 'Arte', 'Altamirano', 'aaltamirano1f@vinaora.com', 'c3cb29cb9d6e4a582a2bba45154683f9e196f106'),
- (53, 'Guillaume', 'Peniman', 'gpeniman1g@bbc.co.uk', '01011b5b97a0c3930c11bce9d7ab73b96ce9378f'),
- (54, 'Fairlie', 'Beatson', 'fbeatson1h@geocities.jp', '669ee689ce4d578059589d864eb0074abeb3060d'),
- (55, 'Carroll', 'Theobalds', 'ctheobalds1i@taobao.com', 'e9b40947ac5a3ca957fd3e6dd66b5c092ff0483c'),
- (56, 'Rosanna', 'Cloake', 'rcloake1j@aol.com', '5725de513e28353c2c04369c789e299d77c4fe04'),
- (57, 'Ailyn', 'Mytton', 'amytton1k@pinterest.com', '280d8e1d20fca591d649f295562f8371c169788d'),
- (58, 'Misha', 'Shoppee', 'mshoppee1l@squidoo.com', 'e7fba2bae4285f35afea69ff0f3d858d5f118def'),
- (59, 'Sergei', 'Weyman', 'sweyman1m@timesonline.co.uk', 'f6057d7d9d79ec4b53f0cb7a3c03e2307242a199'),
- (60, 'Norbie', 'Sivill', 'nsivill1n@cornell.edu', '9a4ec1637dc4dbecbd868bff10506a89506a5862');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `tbl_coffee_strength`
- --
- ALTER TABLE `tbl_coffee_strength`
- ADD PRIMARY KEY (`Id`);
- --
- -- Indexes for table `tbl_item`
- --
- ALTER TABLE `tbl_item`
- ADD PRIMARY KEY (`ID`),
- ADD KEY `coffee_strength_id_constraint` (`Coffee_Strength_Id`);
- --
- -- Indexes for table `tbl_user`
- --
- ALTER TABLE `tbl_user`
- ADD PRIMARY KEY (`ID`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `tbl_coffee_strength`
- --
- ALTER TABLE `tbl_coffee_strength`
- MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `tbl_item`
- --
- ALTER TABLE `tbl_item`
- MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
- --
- -- AUTO_INCREMENT for table `tbl_user`
- --
- ALTER TABLE `tbl_user`
- MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `tbl_item`
- --
- ALTER TABLE `tbl_item`
- ADD CONSTRAINT `coffee_strength_id_constraint` FOREIGN KEY (`coffee_strength_id`) REFERENCES `tbl_coffee_strength` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE;
- 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement