-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathusers.sql
134 lines (98 loc) · 13.9 KB
/
users.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
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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
/*
SQLyog Professional v12.09 (64 bit)
MySQL - 10.3.16-MariaDB : Database - video
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`video` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `video`;
/*Table structure for table `movies` */
DROP TABLE IF EXISTS `movies`;
CREATE TABLE `movies` (
`id` int(121) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`cost` float DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
`banner_image` varchar(255) DEFAULT NULL,
`video` varchar(255) DEFAULT NULL,
`type` int(255) DEFAULT NULL,
`rating` float DEFAULT NULL,
`length` time DEFAULT NULL,
`director` varchar(255) DEFAULT NULL,
`brief_content` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
/*Data for the table `movies` */
insert into `movies`(`id`,`title`,`cost`,`image`,`banner_image`,`video`,`type`,`rating`,`length`,`director`,`brief_content`) values (1,'The Wild Things Are',NULL,'11.jpg','1.jpg',NULL,NULL,9.6,NULL,NULL,NULL),(2,'Central Intelligence',NULL,'9.jpg','1.jpg',NULL,NULL,6,NULL,NULL,NULL),(3,'Zoolander No. 2',NULL,'4.jpg','1.jpg',NULL,NULL,8.6,NULL,NULL,NULL),(4,'Bad Neighbors 2',NULL,'5.jpg','1.jpg',NULL,NULL,7.2,NULL,NULL,NULL),(5,'Star Wars',NULL,'7.jpg','1.jpg',NULL,NULL,8.6,NULL,NULL,NULL),(6,'The Imitation Game',NULL,'8.jpg','1.jpg',NULL,NULL,6,NULL,NULL,NULL),(7,'Fantastic Beasts',NULL,'6.jpg','1.jpg',NULL,NULL,8.6,NULL,NULL,NULL),(8,'Edge of Tomorrow',NULL,'2.jpg','1.jpg',NULL,NULL,7.2,NULL,NULL,NULL),(9,'Allegiant',NULL,'12.jpg','1.jpg',NULL,NULL,8.6,NULL,NULL,NULL),(10,'Lo and Behold',NULL,'1.jpg','1.jpg',NULL,NULL,6,NULL,NULL,NULL),(11,'Drive',NULL,'10.jpg','1.jpg',NULL,NULL,8.6,NULL,NULL,NULL),(12,'Nightcrawler',NULL,'3.jpg','1.jpg',NULL,NULL,7.2,NULL,NULL,NULL);
/*Table structure for table `permission` */
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
`id` int(122) unsigned NOT NULL AUTO_INCREMENT,
`user_type` varchar(250) DEFAULT NULL,
`data` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*Data for the table `permission` */
insert into `permission`(`id`,`user_type`,`data`) values (1,'Member','{\"users\":{\"own_create\":\"1\",\"own_read\":\"1\",\"own_update\":\"1\",\"own_delete\":\"1\"}}'),(2,'admin','{\"users\":{\"own_create\":\"1\",\"own_read\":\"1\",\"own_update\":\"1\",\"own_delete\":\"1\",\"all_create\":\"1\",\"all_read\":\"1\",\"all_update\":\"1\",\"all_delete\":\"1\"}}');
/*Table structure for table `reviews` */
DROP TABLE IF EXISTS `reviews`;
CREATE TABLE `reviews` (
`id` int(121) NOT NULL AUTO_INCREMENT,
`movie_id` int(121) DEFAULT NULL,
`comments` varchar(255) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`created_at` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*Data for the table `reviews` */
insert into `reviews`(`id`,`movie_id`,`comments`,`author`,`created_at`) values (9,1,'<p>This is a fantastic film.</p>\r\n','Suzie Smith','2019-11-22'),(10,1,'<p>Another good experience..</p>\r\n','Suzie Smith','2019-11-22'),(11,2,'<p>The best film ever.</p>\r\n','Suzie Smith','2019-11-23');
/*Table structure for table `setting` */
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
`id` int(122) unsigned NOT NULL AUTO_INCREMENT,
`keys` varchar(255) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
/*Data for the table `setting` */
insert into `setting`(`id`,`keys`,`value`) values (1,'website','Video'),(2,'logo','Untitled.png'),(3,'favicon','favicon.ico'),(4,'SMTP_EMAIL',''),(5,'HOST',''),(6,'PORT',''),(7,'SMTP_SECURE',''),(8,'SMTP_PASSWORD',''),(9,'mail_setting','simple_mail'),(10,'company_name','Company Name'),(11,'crud_list','users,User'),(12,'EMAIL',''),(13,'UserModules','yes'),(14,'register_allowed','1'),(15,'email_invitation','1'),(16,'admin_approval','0'),(17,'user_type','[\"Member\"]');
/*Table structure for table `templates` */
DROP TABLE IF EXISTS `templates`;
CREATE TABLE `templates` (
`id` int(121) unsigned NOT NULL AUTO_INCREMENT,
`module` varchar(255) DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`template_name` varchar(255) DEFAULT NULL,
`html` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*Data for the table `templates` */
insert into `templates`(`id`,`module`,`code`,`template_name`,`html`) values (1,'forgot_pass','forgot_password','Forgot password','<html xmlns=\"http://www.w3.org/1999/xhtml\"><head>\r\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n <style type=\"text/css\" rel=\"stylesheet\" media=\"all\">\r\n /* Base ------------------------------ */\r\n *:not(br):not(tr):not(html) {\r\n font-family: Arial, \'Helvetica Neue\', Helvetica, sans-serif;\r\n -webkit-box-sizing: border-box;\r\n box-sizing: border-box;\r\n }\r\n body {\r\n \r\n }\r\n a {\r\n color: #3869D4;\r\n }\r\n\r\n\r\n /* Masthead ----------------------- */\r\n .email-masthead {\r\n padding: 25px 0;\r\n text-align: center;\r\n }\r\n .email-masthead_logo {\r\n max-width: 400px;\r\n border: 0;\r\n }\r\n .email-footer {\r\n width: 570px;\r\n margin: 0 auto;\r\n padding: 0;\r\n text-align: center;\r\n }\r\n .email-footer p {\r\n color: #AEAEAE;\r\n }\r\n \r\n .content-cell {\r\n padding: 35px;\r\n }\r\n .align-right {\r\n text-align: right;\r\n }\r\n\r\n /* Type ------------------------------ */\r\n h1 {\r\n margin-top: 0;\r\n color: #2F3133;\r\n font-size: 19px;\r\n font-weight: bold;\r\n text-align: left;\r\n }\r\n h2 {\r\n margin-top: 0;\r\n color: #2F3133;\r\n font-size: 16px;\r\n font-weight: bold;\r\n text-align: left;\r\n }\r\n h3 {\r\n margin-top: 0;\r\n color: #2F3133;\r\n font-size: 14px;\r\n font-weight: bold;\r\n text-align: left;\r\n }\r\n p {\r\n margin-top: 0;\r\n color: #74787E;\r\n font-size: 16px;\r\n line-height: 1.5em;\r\n text-align: left;\r\n }\r\n p.sub {\r\n font-size: 12px;\r\n }\r\n p.center {\r\n text-align: center;\r\n }\r\n\r\n /* Buttons ------------------------------ */\r\n .button {\r\n display: inline-block;\r\n width: 200px;\r\n background-color: #3869D4;\r\n border-radius: 3px;\r\n color: #ffffff;\r\n font-size: 15px;\r\n line-height: 45px;\r\n text-align: center;\r\n text-decoration: none;\r\n -webkit-text-size-adjust: none;\r\n mso-hide: all;\r\n }\r\n .button--green {\r\n background-color: #22BC66;\r\n }\r\n .button--red {\r\n background-color: #dc4d2f;\r\n }\r\n .button--blue {\r\n background-color: #3869D4;\r\n }\r\n </style>\r\n</head>\r\n<body style=\"width: 100% !important;\r\n height: 100%;\r\n margin: 0;\r\n line-height: 1.4;\r\n background-color: #F2F4F6;\r\n color: #74787E;\r\n -webkit-text-size-adjust: none;\">\r\n <table class=\"email-wrapper\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"\r\n width: 100%;\r\n margin: 0;\r\n padding: 0;\">\r\n <tbody><tr>\r\n <td align=\"center\">\r\n <table class=\"email-content\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"width: 100%;\r\n margin: 0;\r\n padding: 0;\">\r\n <!-- Logo -->\r\n\r\n <tbody>\r\n <!-- Email Body -->\r\n <tr>\r\n <td class=\"email-body\" width=\"100%\" style=\"width: 100%;\r\n margin: 0;\r\n padding: 0;\r\n border-top: 1px solid #edeef2;\r\n border-bottom: 1px solid #edeef2;\r\n background-color: #edeef2;\">\r\n <table class=\"email-body_inner\" align=\"center\" width=\"570\" cellpadding=\"0\" cellspacing=\"0\" style=\" width: 570px;\r\n margin: 14px auto;\r\n background: #fff;\r\n padding: 0;\r\n border: 1px outset rgba(136, 131, 131, 0.26);\r\n box-shadow: 0px 6px 38px rgb(0, 0, 0);\r\n \">\r\n <!-- Body content -->\r\n <thead style=\"background: #3869d4;\"><tr><th><div align=\"center\" style=\"padding: 15px; color: #000;\"><a href=\"{var_action_url}\" class=\"email-masthead_name\" style=\"font-size: 16px;\r\n font-weight: bold;\r\n color: #bbbfc3;\r\n text-decoration: none;\r\n text-shadow: 0 1px 0 white;\">{var_sender_name}</a></div></th></tr>\r\n </thead>\r\n <tbody><tr>\r\n <td class=\"content-cell\" style=\"padding: 35px;\">\r\n <h1>Hi {var_user_name},</h1>\r\n <p>You recently requested to reset your password for your {var_website_name} account. Click the button below to reset it.</p>\r\n <!-- Action -->\r\n <table class=\"body-action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"\r\n width: 100%;\r\n margin: 30px auto;\r\n padding: 0;\r\n text-align: center;\">\r\n <tbody><tr>\r\n <td align=\"center\">\r\n <div>\r\n <!--[if mso]><v:roundrect xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:w=\"urn:schemas-microsoft-com:office:word\" href=\"{{var_action_url}}\" style=\"height:45px;v-text-anchor:middle;width:200px;\" arcsize=\"7%\" stroke=\"f\" fill=\"t\">\r\n <v:fill type=\"tile\" color=\"#dc4d2f\" />\r\n <w:anchorlock/>\r\n <center style=\"color:#ffffff;font-family:sans-serif;font-size:15px;\">Reset your password</center>\r\n </v:roundrect><![endif]-->\r\n <a href=\"{var_varification_link}\" class=\"button button--red\" style=\"background-color: #dc4d2f;display: inline-block;\r\n width: 200px;\r\n background-color: #3869D4;\r\n border-radius: 3px;\r\n color: #ffffff;\r\n font-size: 15px;\r\n line-height: 45px;\r\n text-align: center;\r\n text-decoration: none;\r\n -webkit-text-size-adjust: none;\r\n mso-hide: all;\">Reset your password</a>\r\n </div>\r\n </td>\r\n </tr>\r\n </tbody></table>\r\n <p>If you did not request a password reset, please ignore this email or reply to let us know.</p>\r\n <p>Thanks,<br>{var_sender_name} and the {var_website_name} Team</p>\r\n <!-- Sub copy -->\r\n <table class=\"body-sub\" style=\"margin-top: 25px;\r\n padding-top: 25px;\r\n border-top: 1px solid #EDEFF2;\">\r\n <tbody><tr>\r\n <td> \r\n <p class=\"sub\" style=\"font-size:12px;\">If you are having trouble clicking the password reset button, copy and paste the URL below into your web browser.</p>\r\n <p class=\"sub\" style=\"font-size:12px;\"><a href=\"{var_varification_link}\">{var_varification_link}</a></p>\r\n </td>\r\n </tr>\r\n </tbody></table>\r\n </td>\r\n </tr>\r\n </tbody></table>\r\n </td>\r\n </tr>\r\n </tbody></table>\r\n </td>\r\n </tr>\r\n </tbody></table>\r\n\r\n\r\n</body></html>'),(3,'users','invitation','Invitation','<p>Hello <strong>{var_user_email}</strong></p>\r\n\r\n<p>Click below link to register <br />\r\n{var_inviation_link}</p>\r\n\r\n<p>Thanks </p>\r\n');
/*Table structure for table `users` */
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`users_id` int(121) NOT NULL AUTO_INCREMENT,
`user_id` varchar(255) DEFAULT NULL,
`var_key` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`is_deleted` varchar(255) DEFAULT '0',
`name` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`phone_number` varchar(20) DEFAULT NULL,
`profile_pic` varchar(255) DEFAULT 'download.png',
`user_type` varchar(255) DEFAULT 'Member',
`country` varchar(255) DEFAULT NULL,
PRIMARY KEY (`users_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*Data for the table `users` */
insert into `users`(`users_id`,`user_id`,`var_key`,`status`,`is_deleted`,`name`,`password`,`email`,`phone_number`,`profile_pic`,`user_type`,`country`) values (1,'1','','active','0','Admin','$2y$10$M3balQeXT7vqj/Do8.xMieVvK1JjJ0RzeDel51E5rgMNuLdzsf8/a','[email protected]','18359741075','account-profile.jpg','admin','Malaysia'),(8,'2','','active','0','Suzie Smith','$2y$10$M3balQeXT7vqj/Do8.xMieVvK1JjJ0RzeDel51E5rgMNuLdzsf8/a','[email protected]','18359741075','account-profile.jpg','Member','Malaysia'),(12,NULL,NULL,'active','0','bory','$2y$10$RyKhyRuNzugG/JXgQBZgsOxlsgm1r3WRQmgBGuYCKrb4zIfS7hYZm','[email protected]','','chuang2.jpg','Member',NULL),(13,NULL,NULL,'active','0','111','$2y$10$mP3IuZuNin4vO.tQHLGjMe1drqPDjHYAwmgkTE8b8RRfqiIVwCyP2','[email protected]','100222222','5d9c5b415568f_thumb900.jpg','Member','None');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;