-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathappstore.sql
More file actions
117 lines (98 loc) · 5.2 KB
/
appstore.sql
File metadata and controls
117 lines (98 loc) · 5.2 KB
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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 03, 2014 at 05:10 AM
-- Server version: 5.1.33
-- PHP Version: 5.2.9
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 utf8 */;
--
-- Database: `appstore`
--
-- --------------------------------------------------------
--
-- Table structure for table `apps`
--
CREATE TABLE IF NOT EXISTS `apps` (
`app_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`app_name` varchar(32) NOT NULL,
`image` varchar(32) NOT NULL,
`rating` float NOT NULL,
`upload_date` datetime NOT NULL,
`userid` int(10) unsigned NOT NULL,
`total_downloads` int(10) unsigned NOT NULL DEFAULT '0',
`description` text NOT NULL,
`file` varchar(255) NOT NULL,
`Approved` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`app_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `apps`
--
INSERT INTO `apps` (`app_id`, `app_name`, `image`, `rating`, `upload_date`, `userid`, `total_downloads`, `description`, `file`, `Approved`) VALUES
(1, 'Fruit Ninja', 'fruitn.jpg', 4.1, '2013-11-02 00:10:30', 2, 7, 'Test your slicing skills..', 'fruit ninja.apk', 1),
(2, 'Temple Run', 'tampler.jpg', 4.8, '2013-01-22 00:00:00', 2, 5, '', '', 1),
(3, 'Deadly Transformer', 'transform.jpg', 3, '2013-11-14 00:05:00', 1, 0, '', '', 1),
(4, 'Town Race', 'race.jpg', 3.8, '2014-01-01 00:00:00', 11, 325, 'race with friends', 'Town Race.apk', 1),
(12, 'Metal gear', '1393304859_death.jpg', 3.5, '2014-02-25 11:07:39', 4, 5, 'Shoot or die', '1393304859_plantvszombie.apk', 1),
(5, 'Black Fag', 'Black Fag.jpg', 5, '2014-02-06 20:01:39', 6, 863, 'Play As an assassin', 'Black Fag.apk', 1),
(6, 'Diablo', 'Diablo.jpg', 4.7, '2014-02-04 20:09:31', 7, 1, 'A journey has been started', 'diablo.apk', 1),
(13, 'Plant vs zombie', '1393482641_plant vs zombie.jpg', 0, '2014-02-27 12:30:41', 15, 0, 'zombie are here', '1393482641_plantvszombie.apk', 1);
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE IF NOT EXISTS `comments` (
`comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`app_id` int(10) unsigned NOT NULL,
`userid` int(10) unsigned NOT NULL,
`comment` text NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `comments`
--
INSERT INTO `comments` (`comment_id`, `app_id`, `userid`, `comment`, `date`) VALUES
(1, 1, 7, 'Just finished playing this game. awesome.', '2014-03-02 23:19:22'),
(2, 1, 10, 'I''ve also download this game.Do you know any extension?or any version?', '2014-03-03 23:20:31'),
(3, 5, 1, 'Awsome graphics 5* for me', '2014-03-05 08:57:01'),
(4, 4, 10, 'Took me 10 hours to complete', '2014-03-06 08:57:58');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(16) NOT NULL,
`password` varchar(40) NOT NULL,
`email` varchar(30) NOT NULL,
`userpic` varchar(128) DEFAULT NULL,
`join_date` datetime NOT NULL,
PRIMARY KEY (`userid`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`userid`, `username`, `password`, `email`, `userpic`, `join_date`) VALUES
(1, 'rahi', '7b52009b64fd0a2a49e6d8a939753077792b0554', '', '1392207018_quad.jpg', '2014-02-12 18:10:18'),
(2, 'shib', '7b52009b64fd0a2a49e6d8a939753077792b0554', '', '1392207458_class routine.jpg', '2014-02-12 18:17:38'),
(3, 'a', 'e9d71f5ee7c92d6dc9e92ffdad17b8bd49418f98', '', '1392208522_', '2014-02-12 18:35:22'),
(4, '1', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', '', '1392209031_', '2014-02-12 18:43:51'),
(5, '3', '1b6453892473a467d07372d45eb05abc2031647a', '', '1393243699_', '2014-02-24 18:08:19'),
(6, 'Gameloft', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'gameloft@ymail.com', 'gameloft.jpg', '2014-02-03 20:04:44'),
(7, 'tanvir', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'tanvir@gmail.com', 'tanvir.jpg', '2013-12-26 20:07:09'),
(8, 'boo', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'gjhgj@gjh.ck', '1393435994_', '2014-02-26 23:33:14'),
(9, 'ss', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'rwr@df.co', '1393436492_', '2014-02-26 23:41:32'),
(10, 'hemel', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'sad@sayd.csa', '1393436703_', '2014-02-26 23:45:03'),
(11, 'murad', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'sadsa@dasd.com', '1393436851_', '2014-02-26 23:47:31'),
(12, 'murada', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'sadsa@dasd.com', '1393436894_', '2014-02-26 23:48:14'),
(13, 'robin', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'df@ad.co', '1393436949_', '2014-02-26 23:49:09'),
(14, 'shourav', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'df@ad.co', '1393438254_', '2014-02-27 00:10:54'),
(15, 'raj', 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 'raj@emain.com', '1393482531_', '2014-02-27 12:28:51');