-
Notifications
You must be signed in to change notification settings - Fork 18
/
sqlitraining.sql
75 lines (63 loc) · 2.9 KB
/
sqlitraining.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
-- Host: 127.0.0.1
-- Generation Time: Oct 15, 2013 at 08:52 PM
-- Server version: 5.5.32
-- PHP Version: 5.4.19
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `sqlitraining`
--
CREATE DATABASE IF NOT EXISTS `sqlitraining` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `sqlitraining`;
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
DROP TABLE IF EXISTS `products`;
CREATE TABLE IF NOT EXISTS `products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_name` varchar(30) NOT NULL,
`product_type` varchar(30) NOT NULL,
`description` varchar(200) NOT NULL,
`price` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`id`, `product_name`, `product_type`, `description`, `price`) VALUES
(1, 'pillows', 'bedroom linen', 'soft fluffy pillows', 4000),
(5, 'book shelf', 'furniture', 'hard balsa wood furniture', 3200),
(6, 'pressure cooker', 'kitchen', '5 ltr. pressure cooker for the entire family', 12000),
(7, 'shampoo', 'healthcare', 'anti dandruff shampoo for oily hair', 2300),
(8, 'tubelight', 'lighting', 'bright light for the entire house', 1200),
(9, 'headphones', 'computers', 'high quality Bose standard china made headphones', 200),
(10, 'ADSL2 router', 'wireless devices', 'long range wireless router for the entire locality', 9090),
(11, 'buffalo', 'animal', 'endless supply of authentic milk', 23000),
(12, 'bicycle', 'vehicles', 'the best in the market, now ride to office!', 10000);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(200) NOT NULL,
`password` varchar(33) NOT NULL,
`fname` varchar(30) NOT NULL,
`description` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=66 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `fname`, `description`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin', 'All hail the admin!!'),
(2, 'bob', '5f4dcc3b5aa765d61d8327deb882cf99', 'bobby', 'Sup! I love swimming!'),
(3, 'ramesh', '9aeaed51f2b0f6680c4ed4b07fb1a83c', 'ramesh', 'I love 5 star!'),
(4, 'suresh', '9aeaed51f2b0f6680c4ed4b07fb1a83c', 'suresh', 'I love 5 star toooo!'),
(5, 'alice', 'c93239cae450631e9f55d71aed99e918', 'alice', 'In wonderland right now :O'),
(6, 'voldemort', '856936b417f82c06139c74fa73b1abbe', 'voldemort', 'How dare you! Avada kedavra!'),
(7, 'frodo', 'f0f8820ee817181d9c6852a097d70d8d', 'frodo', 'Need to go to Mordor. Like right now!'),
(8, 'hodor', 'a55287e9d0b40429e5a944d10132c93e', 'hodor', 'Hodor'),
(65, 'rhombus', 'e52848c0eb863d96bc124737116f23a4', 'rambo', 'Im the rambo!! Bwahahaha!');