API tools faq
paste
Gh05t666nero

https://svdvachanajyothi.com/ got leaked

Gh05t666nero
Jul 23rd, 2020
108
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 28.96 KB | None | 0 0
raw download clone embed print report
  1. https://svdvachanajyothi.com/
  2.  
  3. By Indoghostsec
  4.  
  5. #AntiSec
  6.  
  7. Greetz to : Anonymous Indonesia ,Gh05t666include,4pexHaxor,Cyberware_,Ghostsec_, LulZRaft,Anon1337,JtSec13, Sin1pecrew, AnonPL, AnonIr,
  8. Userware,Litemods,Xsec crew, LulzRooT,Nyusec,0xR1zk,Ferdysimo,LulzJ03,Spydata and all members of indoghostsec & Inahacks
  9.  
  10.  
  11. DROP TABLE activity_log;
  12. CREATE TABLE `activity_log` (
  13. `activity_log_id` int(11) NOT NULL AUTO_INCREMENT,
  14. `username` varchar(50) NOT NULL,
  15. `date` varchar(25) NOT NULL,
  16. `action` varchar(50) NOT NULL,
  17. PRIMARY KEY (`activity_log_id`)
  18. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
  19.  
  20. INSERT INTO activity_log VALUES("1","evansvd","2020-03-11 05:15:30","Updated 1 banner details with image");
  21. INSERT INTO activity_log VALUES("2","evansvd","2020-03-11 05:16:00","Updated 1 banner details with image");
  22. INSERT INTO activity_log VALUES("3","evansvd","2020-03-11 05:16:09","Updated 1 banner details with image");
  23. INSERT INTO activity_log VALUES("4","evansvd","2020-03-11 05:20:31","Deleted 2 banner ");
  24. INSERT INTO activity_log VALUES("5","evansvd","2020-03-11 05:20:33","Deleted 1 banner ");
  25. INSERT INTO activity_log VALUES("6","evansvd","2020-03-11 05:52:31","Deleted 1 team ");
  26. INSERT INTO activity_log VALUES("7","evansvd","2020-03-11 12:27:36","Deleted 3 event ");
  27. INSERT INTO activity_log VALUES("8","evansvd","2020-03-11 12:33:22","Updated Anniversary event details with image");
  28. INSERT INTO activity_log VALUES("9","evansvd","2020-03-11 12:45:09","Updated Anniversary event details with image");
  29.  
  30.  
  31.  
  32. DROP TABLE admin;
  33.  
  34. CREATE TABLE `admin` (
  35. `id` int(11) NOT NULL AUTO_INCREMENT,
  36. `username` text NOT NULL,
  37. `name` varchar(20) NOT NULL,
  38. `password` text NOT NULL,
  39. `phone` varchar(13) NOT NULL,
  40. `email` varchar(100) NOT NULL,
  41. `psalt` text NOT NULL,
  42. `admin_image` varchar(100) NOT NULL,
  43. `admin_added` timestamp NOT NULL DEFAULT current_timestamp(),
  44. `usertype` varchar(100) NOT NULL,
  45. `status` varchar(10) NOT NULL,
  46. `parish` int(11) NOT NULL,
  47. `loginuser` varchar(200) NOT NULL,
  48. PRIMARY KEY (`id`)
  49. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  50.  
  51. INSERT INTO admin VALUES("1","evansvd","Evan","890ff19504dfefd74943d22cdd547bef5d92e73fa1cfbc12fad3dcd5c57b38bb","9482185327","[email protected]","9uqirlf1ezEnrlsXTYYJ","alfa-team.php","2019-09-06 09:50:30","admin","Active","0","evansvd");
  52. INSERT INTO admin VALUES("2","michael","Fr. Michael","ec8d2b5fd3d73133c0373d1a374cde3ccea771f2de043a527d87df79ff914b42","7353447130","[email protected]","6isOsiUblMkQrFV0b261","logo.png","2019-09-06 10:48:07","admin","Active","0","evansvd");
  53.  
  54.  
  55.  
  56. DROP TABLE album;
  57.  
  58. CREATE TABLE `album` (
  59. `id` int(11) NOT NULL AUTO_INCREMENT,
  60. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  61. `author` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  62. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  63. `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  64. `active` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  65. PRIMARY KEY (`id`)
  66. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  67.  
  68.  
  69.  
  70.  
  71. DROP TABLE audio;
  72.  
  73. CREATE TABLE `audio` (
  74. `id` int(11) NOT NULL AUTO_INCREMENT,
  75. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  76. `album_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  77. `album_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  78. `path` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  79. `active` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  80. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  81. PRIMARY KEY (`id`)
  82. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  83.  
  84.  
  85.  
  86.  
  87. DROP TABLE audio_publication;
  88.  
  89. CREATE TABLE `audio_publication` (
  90. `id` int(11) NOT NULL AUTO_INCREMENT,
  91. `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  92. `description` varchar(2000) COLLATE utf8_unicode_ci NOT NULL,
  93. PRIMARY KEY (`id`)
  94. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  95.  
  96.  
  97.  
  98.  
  99. DROP TABLE banner;
  100.  
  101. CREATE TABLE `banner` (
  102. `id` int(11) NOT NULL AUTO_INCREMENT,
  103. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  104. `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  105. `image` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  106. `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  107. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  108. PRIMARY KEY (`id`)
  109. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  110.  
  111. INSERT INTO banner VALUES("3","1","asdf","b1.jpg","Yes","2020-03-11 05:20:51");
  112. INSERT INTO banner VALUES("4","2","2","b2.jpg","Yes","2020-03-11 05:21:10");
  113. INSERT INTO banner VALUES("5","3","3","b3.jpg","Yes","2020-03-11 05:21:25");
  114. INSERT INTO banner VALUES("6","4","4","b4.jpg","Yes","2020-03-11 05:21:42");
  115. INSERT INTO banner VALUES("7","5","5","b5.jpg","Yes","2020-03-11 05:22:00");
  116. INSERT INTO banner VALUES("8","6","6","b6.jpg","Yes","2020-03-11 05:22:16");
  117. INSERT INTO banner VALUES("9","7","7","banner_1.jpg","Yes","2020-03-11 05:22:40");
  118.  
  119.  
  120.  
  121. DROP TABLE bible;
  122.  
  123. CREATE TABLE `bible` (
  124. `id` int(11) NOT NULL AUTO_INCREMENT,
  125. `verse` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  126. `quote` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  127. `prayer` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  128. `bible_date` date NOT NULL,
  129. `active` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  130. PRIMARY KEY (`id`)
  131. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  132.  
  133. INSERT INTO bible VALUES("1"," But you will receive power when the Holy Spirit comes on you; and you will be my witnesses in Jerusalem, and in all Judea and Samaria, and to the ends of the earth.","Acts 1:8 ","Prayer:","2020-07-03","YES");
  134. INSERT INTO bible VALUES("2","And Jesus went throughout all the cities and villages, teaching in their synagogues and proclaiming the gospel of the kingdom and healing every disease and every affliction.","Matthew 9:35-36","Prayer:","2018-07-21","YES");
  135. INSERT INTO bible VALUES("3","Go therefore and make disciples of all nations, baptizing them in the name of the Father and of the Son and of the Holy Spirit…","Matthew 28:19","Prayer:","2018-07-21","YES");
  136. INSERT INTO bible VALUES("4","And he called the twelve and began to send them out two by two, and gave them authority over the unclean spirits.","Mark 6:7","","0000-00-00","YES");
  137. INSERT INTO bible VALUES("5","And he said to them, “Go into all the world and proclaim the gospel to the whole creation.","Mark 16:15","","0000-00-00","YES");
  138.  
  139.  
  140.  
  141. DROP TABLE category;
  142.  
  143. CREATE TABLE `category` (
  144. `id` int(11) NOT NULL,
  145. `title` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  146. `timestamp` timestamp NOT NULL DEFAULT current_timestamp()
  147. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  148.  
  149.  
  150.  
  151.  
  152. DROP TABLE dashboard;
  153.  
  154. CREATE TABLE `dashboard` (
  155. `id` int(11) NOT NULL AUTO_INCREMENT,
  156. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  157. `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  158. `image` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  159. `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  160. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  161. PRIMARY KEY (`id`)
  162. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  163.  
  164.  
  165.  
  166.  
  167. DROP TABLE event;
  168.  
  169. CREATE TABLE `event` (
  170. `id` int(11) NOT NULL AUTO_INCREMENT,
  171. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  172. `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  173. `event_date` date NOT NULL,
  174. `image` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  175. `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  176. `txnid` text COLLATE utf8_unicode_ci NOT NULL,
  177. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  178. PRIMARY KEY (`id`)
  179. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  180.  
  181. INSERT INTO event VALUES("1","Anniversary","<p>Vachanajyothi celebrated its fourth anniversary on 2nd October. Thanks for everyone who contributed to make this celebration a great one.</p>
  182. \n","0000-00-00","","Yes","eb6925cdcc71d7510c45018ebd4391cbd8a90c41","2020-03-11 12:31:32");
  183.  
  184.  
  185.  
  186. DROP TABLE event_image;
  187.  
  188. CREATE TABLE `event_image` (
  189. `id` int(11) NOT NULL AUTO_INCREMENT,
  190. `event_id` text COLLATE utf8_unicode_ci NOT NULL,
  191. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  192. `image` text COLLATE utf8_unicode_ci NOT NULL,
  193. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  194. PRIMARY KEY (`id`)
  195. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  196.  
  197. INSERT INTO event_image VALUES("1","1","Anniversary","1516719814.jpg","2020-03-11 12:31:32");
  198. INSERT INTO event_image VALUES("2","1","Anniversary","2128824441.jpg","2020-03-11 12:33:22");
  199. INSERT INTO event_image VALUES("3","1","Anniversary","329544946.jpg","2020-03-11 12:33:22");
  200.  
  201.  
  202.  
  203. DROP TABLE gallery;
  204.  
  205. CREATE TABLE `gallery` (
  206. `id` int(11) NOT NULL AUTO_INCREMENT,
  207. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  208. `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  209. `image` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  210. `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  211. `txnid` text COLLATE utf8_unicode_ci NOT NULL,
  212. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  213. PRIMARY KEY (`id`)
  214. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  215.  
  216. INSERT INTO gallery VALUES("1","House Images","<p>Here are few House images</p>
  217. \n","","Yes","2a3f1cccd539ec457341f5b17b03f7a276399c1f","2020-03-11 13:22:24");
  218.  
  219.  
  220.  
  221. DROP TABLE gallery_image;
  222.  
  223. CREATE TABLE `gallery_image` (
  224. `id` int(11) NOT NULL AUTO_INCREMENT,
  225. `gallery_id` text COLLATE utf8_unicode_ci NOT NULL,
  226. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  227. `image` text COLLATE utf8_unicode_ci NOT NULL,
  228. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  229. PRIMARY KEY (`id`)
  230. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  231.  
  232. INSERT INTO gallery_image VALUES("1","1","House Images","178348094.jpg","2020-03-11 13:22:24");
  233. INSERT INTO gallery_image VALUES("2","1","House Images","336836312.jpg","2020-03-11 13:22:24");
  234. INSERT INTO gallery_image VALUES("3","1","House Images","759859765.jpg","2020-03-11 13:22:24");
  235. INSERT INTO gallery_image VALUES("4","1","House Images","614492886.jpg","2020-03-11 13:22:24");
  236. INSERT INTO gallery_image VALUES("5","1","House Images","467217353.jpg","2020-03-11 13:22:24");
  237. INSERT INTO gallery_image VALUES("6","1","House Images","733646118.jpg","2020-03-11 13:22:24");
  238. INSERT INTO gallery_image VALUES("7","1","House Images","953638721.jpg","2020-03-11 13:22:24");
  239. INSERT INTO gallery_image VALUES("8","1","House Images","1856944114.jpg","2020-03-11 13:22:24");
  240. INSERT INTO gallery_image VALUES("9","1","House Images","1804575862.jpg","2020-03-11 13:22:24");
  241.  
  242.  
  243.  
  244. DROP TABLE newsletter;
  245.  
  246. CREATE TABLE `newsletter` (
  247. `id` int(11) NOT NULL AUTO_INCREMENT,
  248. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  249. `path` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  250. `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  251. `active` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  252. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  253. PRIMARY KEY (`id`)
  254. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  255.  
  256.  
  257.  
  258.  
  259. DROP TABLE notification;
  260.  
  261. CREATE TABLE `notification` (
  262. `id` int(11) NOT NULL,
  263. `title` int(11) NOT NULL,
  264. `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp()
  265. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  266.  
  267.  
  268.  
  269.  
  270. DROP TABLE publication;
  271.  
  272. CREATE TABLE `publication` (
  273. `id` int(11) NOT NULL AUTO_INCREMENT,
  274. `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  275. `author` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  276. `year` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  277. PRIMARY KEY (`id`)
  278. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  279.  
  280.  
  281.  
  282.  
  283. DROP TABLE retreat;
  284.  
  285. CREATE TABLE `retreat` (
  286. `id` int(11) NOT NULL AUTO_INCREMENT,
  287. `retreat` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  288. `description` text COLLATE utf8_unicode_ci NOT NULL,
  289. `date_from` date NOT NULL,
  290. `date_to` date NOT NULL,
  291. PRIMARY KEY (`id`)
  292. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  293.  
  294. INSERT INTO retreat VALUES("1","Treatment Programme","Treatment Programme","2020-03-11","2020-04-16");
  295. INSERT INTO retreat VALUES("2","Treatment Programme New","Treatment Programme","2020-03-14","2020-04-24");
  296.  
  297.  
  298.  
  299. DROP TABLE retreat_registration;
  300.  
  301. CREATE TABLE `retreat_registration` (
  302. `id` int(11) NOT NULL AUTO_INCREMENT,
  303. `retreat` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  304. `retreat_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  305. `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  306. `email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  307. `contact` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  308. `address` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  309. `request` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  310. `diocese` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  311. `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  312. `dob` date NOT NULL,
  313. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  314. `ip` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  315. PRIMARY KEY (`id`)
  316. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  317.  
  318.  
  319.  
  320.  
  321. DROP TABLE staff;
  322.  
  323. CREATE TABLE `staff` (
  324. `id` int(11) NOT NULL AUTO_INCREMENT,
  325. `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  326. `year` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  327. `designation` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  328. `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  329. `image` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  330. `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  331. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  332. PRIMARY KEY (`id`)
  333. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  334.  
  335.  
  336.  
  337.  
  338. DROP TABLE team;
  339.  
  340. CREATE TABLE `team` (
  341. `id` int(11) NOT NULL AUTO_INCREMENT,
  342. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  343. `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  344. `image` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  345. `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  346. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  347. PRIMARY KEY (`id`)
  348. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  349.  
  350. INSERT INTO team VALUES("2","Fr. Antony Puthumana, SVD","Director","logo_1.png","Yes","2020-03-11 05:53:46");
  351. INSERT INTO team VALUES("3","Fr. Money Xavier, SVD","Administrator","logo_1.png","Yes","2020-03-11 05:54:22");
  352. INSERT INTO team VALUES("4","Fr. Michael Vettumanickal, SVD","Programme Co-ordinator","logo_1.png","Yes","2020-03-11 05:55:02");
  353.  
  354.  
  355.  
  356. DROP TABLE testimony;
  357.  
  358. CREATE TABLE `testimony` (
  359. `id` int(11) NOT NULL AUTO_INCREMENT,
  360. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  361. `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  362. `image` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  363. `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  364. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  365. PRIMARY KEY (`id`)
  366. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  367.  
  368.  
  369.  
  370.  
  371. DROP TABLE user_log;
  372.  
  373. CREATE TABLE `user_log` (
  374. `user_log_id` int(11) NOT NULL AUTO_INCREMENT,
  375. `name` varchar(100) NOT NULL,
  376. `username` varchar(50) NOT NULL,
  377. `login_date` varchar(50) NOT NULL,
  378. `logout_date` varchar(50) NOT NULL,
  379. `user_id` int(11) NOT NULL,
  380. `ip` varchar(100) NOT NULL,
  381. `txn` varchar(200) NOT NULL,
  382. PRIMARY KEY (`user_log_id`)
  383. ) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
  384.  
  385. INSERT INTO user_log VALUES("1","","evansvd","2018-07-28 12:26:23","","0","117.247.19.240","00dd5bc64cfb4f4c49f981df6a2a1cc1e4e38a95");
  386. INSERT INTO user_log VALUES("2","","evansvd","2018-07-28 12:28:10","","0","117.247.19.240","81e1725ec25243b85f923608770881bc2dc17840");
  387. INSERT INTO user_log VALUES("3","","evansvd","2018-07-28 12:31:36","","0","117.247.19.240","2d7d3e1aec72b6cc1795f5e5828b6850a8a88288");
  388. INSERT INTO user_log VALUES("4","","evansvd","2018-07-28 12:33:26","","0","117.247.19.240","37f7f7bcbd2bf4cc31e7347bb1eb5e9c52f3902f");
  389. INSERT INTO user_log VALUES("5","","evansvd","2018-07-28 12:35:37","","0","117.247.19.240","5e47bbebd18d933fcd69f5f185f8244388dda6a1");
  390. INSERT INTO user_log VALUES("6","","evansvd","2018-07-28 12:35:56","","0","117.247.19.240","c61d60801ac194d9f415e7d3e0955892cc3858e2");
  391. INSERT INTO user_log VALUES("7","","evansvd","2018-07-28 12:44:19","","0","117.247.19.240","3776fd4dbd2282f84e41113b86c792e37a708633");
  392. INSERT INTO user_log VALUES("8","","evansvd","2018-07-28 12:59:05","","0","117.247.19.240","b8a315a3a5d9a5c8bc078d222128be90a4395ac8");
  393. INSERT INTO user_log VALUES("9","","evan","2018-07-28 12:59:56","","0","117.247.19.240","1f481714be5eb07b2fb6e3bb3e3e62479018a51d");
  394. INSERT INTO user_log VALUES("10","","evansvd","2018-07-28 14:28:57","","0","117.247.19.240","3e099fd6b2562a5592fbbdda35888d8a2bd47861");
  395. INSERT INTO user_log VALUES("11","","evansvd","2018-07-29 03:29:02","","0","117.247.19.240","265acd3557a0edf23ba3f58e6470036aed657b16");
  396. INSERT INTO user_log VALUES("12","","evansvd","2018-07-29 05:04:02","","0","117.247.19.240","0a6a296828b2b869a466da0e5750142b8b829fd5");
  397. INSERT INTO user_log VALUES("13","","evansvd","2018-07-29 06:13:37","","0","117.247.19.240","ee9d35ee72435bba1e7af1f24ebfbec1a6cbaa8a");
  398. INSERT INTO user_log VALUES("14","","evansvd","2018-07-29 11:24:51","","0","117.247.19.240","76734c034aa7d802b36adec84950177c19adb92a");
  399. INSERT INTO user_log VALUES("15","","evansvd","2018-07-29 12:17:41","","0","117.247.19.240","9207a5c75612815f62e471ac16152e673ca66843");
  400. INSERT INTO user_log VALUES("16","","evansvd","2018-07-29 12:19:57","","0","117.247.19.240","b12b50abe3e5056008b7ae407dfd3e45d0251212");
  401. INSERT INTO user_log VALUES("17","","evansvd","2018-09-06 04:32:27","","0","117.247.16.176","68acfed6f6f3501bb86b144f30beaa65013be6f6");
  402. INSERT INTO user_log VALUES("18","","evansvd","2018-09-06 04:44:33","","0","117.247.16.176","1d3c11e8827231522fe26f2930ee274cd129c2f2");
  403. INSERT INTO user_log VALUES("19","","evansvd","2018-09-07 02:59:22","","0","117.247.16.176","12ba9af5a427a4df2312abcb9538b75b4b260d90");
  404. INSERT INTO user_log VALUES("20","","evansvd","2018-09-07 06:24:06","","0","117.192.118.246","8789c0b668e99b885b9ba1a7363122460c2c3002");
  405. INSERT INTO user_log VALUES("21","","evansvd","2018-09-07 06:45:21","","0","117.192.118.246","9904e9ec2e5d8a987c34cd887799078f1c030c75");
  406. INSERT INTO user_log VALUES("22","","evansvd","2018-09-08 09:44:39","","0","117.192.117.179","ba253592260c6e58bffea8aff8cd77849b782002");
  407. INSERT INTO user_log VALUES("23","","evansvd","2018-09-08 16:05:27","","0","117.192.117.179","c26e018bcde948f42ce3fc9c09a222d9ad59a9d0");
  408. INSERT INTO user_log VALUES("24","","evansvd","2018-09-09 05:40:33","","0","117.192.115.73","6b3a35b6da6c84e87596e5574b890fa1882e65a3");
  409. INSERT INTO user_log VALUES("25","","evansvd","2018-09-09 09:12:25","","0","117.192.115.73","bd140104952f6abc48b04b192d3b174f7fb88f4d");
  410. INSERT INTO user_log VALUES("26","","evansvd","2018-09-09 09:20:25","","0","117.192.115.73","ffce210559491a6f98ccccf09dbc48164c65df6f");
  411. INSERT INTO user_log VALUES("27","","evansvd","2018-09-09 09:27:59","","0","117.192.115.73","063f78fb5b8a55ea2f4dfd20ce4c69fa31877399");
  412. INSERT INTO user_log VALUES("28","","edwin","2018-09-09 12:47:51","","0","117.192.115.73","14f44eb507244d98f772df18122db89285924554");
  413. INSERT INTO user_log VALUES("29","","evansvd","2018-09-13 04:10:22","","0","117.202.237.134","5e09d6bdb745a04d0f38eb6d3d8b724b5d75088c");
  414. INSERT INTO user_log VALUES("30","","evansvd","2018-10-07 13:11:35","","0","103.35.233.15","97457b613ff69bf3f39e09933f366546206c5f9d");
  415. INSERT INTO user_log VALUES("31","","evansvd","2018-10-25 22:51:23","","0","91.163.154.67","e24777739f8bdf82a8e8bc646fe2ae0ea1b64a36");
  416. INSERT INTO user_log VALUES("32","","evansvd","2018-11-01 06:36:56","","0","103.35.232.155","c8b9bee4b960d4e5212c14dd3c413f7bbb529a6e");
  417. INSERT INTO user_log VALUES("33","","evansvd","2018-11-01 13:38:04","","0","103.35.233.219","8faeaba766305803ed7132f78ac08de14eb5c030");
  418. INSERT INTO user_log VALUES("34","","evansvd","2018-11-01 13:50:37","","0","103.35.233.219","6e443a55a9e0e2df1d2a64790fe91ac95f0ceef3");
  419. INSERT INTO user_log VALUES("35","","evansvd","2018-11-13 11:54:17","","0","117.192.112.137","bb0ed794111160f25ed66ac2de743405b54ea880");
  420. INSERT INTO user_log VALUES("36","","evansvd","2018-12-11 08:32:31","","0","103.51.94.253","02dc29630adb1ed82eb72f3b4f215c820966086c");
  421. INSERT INTO user_log VALUES("37","","victorsvd","2018-12-11 08:52:50","","0","103.51.94.253","7428d547bba437c2e3dabcb258b61b54a8be9e39");
  422. INSERT INTO user_log VALUES("38","","evansvd","2018-12-16 16:58:21","","0","117.192.114.187","f4fe356ef9d51f7ec5a202abb069d5b651e6f391");
  423. INSERT INTO user_log VALUES("39","","evansvd","2018-12-16 17:03:33","","0","117.192.114.187","4143a96299e65b0daadcdd57d5a4eb23f4d34842");
  424. INSERT INTO user_log VALUES("40","","evansvd","2018-12-17 04:31:13","","0","117.192.114.187","f41175b639a59b1a27bbc7e6500053a0850dc28c");
  425. INSERT INTO user_log VALUES("41","","evansvd","2019-02-21 06:26:22","","0","117.230.164.17","66e4d0efd6670db31b976df427c16ae117588871");
  426. INSERT INTO user_log VALUES("42","","evansvd","2019-02-21 06:59:29","","0","117.230.164.17","8c8fb0354dbf1fe45a3afa5f71f3c03badb5a78c");
  427. INSERT INTO user_log VALUES("43","","evansvd","2019-02-21 07:38:14","","0","117.230.164.17","402665b486752048c609870949ce9dca7369dd83");
  428. INSERT INTO user_log VALUES("44","","evansvd","2019-03-01 04:19:40","","0","157.49.247.3","aa0cd559bb3836437eac0523ca5ace6e51ebf52c");
  429. INSERT INTO user_log VALUES("45","","victorsvd","2019-06-18 18:13:45","","0","103.51.94.34","275ab91b905543971679dc7d0953e3301714f829");
  430. INSERT INTO user_log VALUES("46","","evansvd","2019-07-12 03:42:08","","0","117.247.16.224","5f92b2c3322a88c750cb8e5a4851161336d751b6");
  431. INSERT INTO user_log VALUES("47","","george","2019-07-12 03:43:35","","0","103.51.94.172","d8dc044ecdcbc2a66c4ca2f797e77dcec2d3eff7");
  432. INSERT INTO user_log VALUES("48","","victorsvd","2019-09-08 07:56:35","","0","103.51.94.69","b600dbb3ad650f94d8b55952a216cde0d197c376");
  433. INSERT INTO user_log VALUES("49","","mkavukatt","2019-09-08 08:09:24","","0","103.51.94.69","8de83ad34efcd55493e820d6612897a223a6fcd2");
  434. INSERT INTO user_log VALUES("50","","mkavukatt","2019-09-08 08:14:26","","0","103.51.94.69","b230e1e63b859ba86c2858a2ccb726d08b2a2e46");
  435. INSERT INTO user_log VALUES("51","","mkavukatt","2019-09-08 08:55:55","","0","103.51.94.69","557ea20565695ad280c504dc21b114b9a18dae7b");
  436. INSERT INTO user_log VALUES("52","","mkavukatt","2019-09-08 09:27:38","","0","103.51.94.69","1877e5ca95030a4cea48f131b358d6092e58404a");
  437. INSERT INTO user_log VALUES("53","","evansvd","2019-09-11 06:46:09","","0","117.192.117.128","a3c22eef031c6fa18491edf34fcdd09c6617195d");
  438. INSERT INTO user_log VALUES("54","","mkavukatt","2019-09-11 06:47:14","","0","103.51.94.69","39d991533848eca6141bfe5c6054f1fa455c3fc6");
  439. INSERT INTO user_log VALUES("55","","victorsvd","2019-09-16 07:05:55","","0","103.51.94.69","c60d202c0b28d5c4f9dd009ddfbde9d892b31872");
  440. INSERT INTO user_log VALUES("56","","victorsvd","2019-09-16 07:07:12","","0","103.51.94.69","6b4ed774e3e048145d60e687450c47bb1baa23ab");
  441. INSERT INTO user_log VALUES("57","","mkavukatt","2019-09-17 06:59:45","","0","103.51.94.69","60848a025a4133f2f4225de8f83a57d69db03863");
  442. INSERT INTO user_log VALUES("58","","mkavukatt","2019-10-22 06:50:47","","0","103.51.94.69","0af593ea643254cb82c63cc0faad5653aa48dc1f");
  443. INSERT INTO user_log VALUES("59","","mkavukatt","2019-10-22 07:44:13","","0","103.51.94.69","b3a66d5ba51e5a8ae950c532c5f28007625c5dba");
  444. INSERT INTO user_log VALUES("60","","mkavukatt","2019-10-24 11:19:07","","0","103.51.94.69","a5d73ba8fb4408d56f3a8b513a8795c6ea2e460b");
  445. INSERT INTO user_log VALUES("61","","evansvd","2019-11-17 12:19:55","","0","68.227.69.126","97f304314fdf02afb47f1cacd031d01b9ae3544b");
  446. INSERT INTO user_log VALUES("62","","mkavukatt","2019-11-22 03:42:46","","0","103.51.94.202","32a40b31fe6b15261601c4100b2932694aaac5f7");
  447. INSERT INTO user_log VALUES("63","","evansvd","2020-01-02 07:01:13","","0","117.192.113.35","1fbeb5e2feded961425491cec6fa7e92727b4f7a");
  448. INSERT INTO user_log VALUES("64","","evansvd","2020-01-02 08:47:41","","0","117.192.113.35","b423809fcea8593aa93e76503e0e2907a28b8c58");
  449. INSERT INTO user_log VALUES("65","","evansvd","2020-01-05 16:06:50","","0","117.213.249.130","2ff090cdb3e3bafab11c9886648e16f2abbe2019");
  450. INSERT INTO user_log VALUES("66","","evansvd","2020-01-05 16:19:09","","0","117.213.249.130","50aeb68600713551be9a516c4b958c4112a3df43");
  451. INSERT INTO user_log VALUES("67","","evansvd","2020-01-05 16:19:09","","0","117.213.249.130","50aeb68600713551be9a516c4b958c4112a3df43");
  452. INSERT INTO user_log VALUES("68","","evansvd","2020-01-05 18:03:31","","0","117.213.249.130","ba8833458a9c6383ddb406ec3fdfa4ade04f9aa4");
  453. INSERT INTO user_log VALUES("69","","evansvd","2020-01-05 18:05:24","","0","117.213.249.130","e4f3f4348c275e6c632a02970e37e94f65af272b");
  454. INSERT INTO user_log VALUES("70","","evansvd","2020-01-06 15:55:26","","0","117.213.249.130","8e7bb289bdacfaffaaafc17ce79e4c315e50128c");
  455. INSERT INTO user_log VALUES("71","","evansvd","2020-01-13 13:10:54","","0","117.192.112.202","b69be5f8856bb3bfbf4b756029db6b084da9a518");
  456. INSERT INTO user_log VALUES("72","","evansvd","2020-01-29 05:02:39","","0","157.45.195.20","ef5700f094e21072720ee1d30ce6072a66d49657");
  457. INSERT INTO user_log VALUES("73","","evansvd","2020-01-31 12:01:10","","0","117.202.121.39","4ff60d5562059accad0b3c408e123487275d84da");
  458. INSERT INTO user_log VALUES("74","","evansvd","2020-02-14 14:43:01","","0","157.45.47.21","b92a201443932f5c652de054d76e4dd57b47e592");
  459. INSERT INTO user_log VALUES("75","","evansvd","2020-02-22 09:40:28","","0","117.247.17.81","fa4861a5ff2c1b713f87e95a7b7089ff6edcf2d2");
  460. INSERT INTO user_log VALUES("76","","evansvd","2020-02-22 09:42:48","","0","117.247.17.81","b4acb919a8650622ac8970ce7c3e88d1e1c1a9ae");
  461. INSERT INTO user_log VALUES("77","","evansvd","2020-02-25 05:00:53","","0","117.192.112.186","58ac0304876c39a35a96163371b33ec2ad8bd24e");
  462. INSERT INTO user_log VALUES("78","","evansvd","2020-02-28 11:15:51","","0","117.192.117.78","43182f62dd5ef990469367845f7e660446a6502e");
  463. INSERT INTO user_log VALUES("79","","evansvd","2020-03-01 12:22:12","","0","117.202.123.192","6f8e3ead7d1647ffa9001c3c30b77a1d8dace11f");
  464. INSERT INTO user_log VALUES("80","","evansvd","2020-03-10 07:14:17","","0","117.230.10.139","532deb8bbd1cc45536830033466e451f56e5ed7f");
  465. INSERT INTO user_log VALUES("81","","evansvd","2020-03-11 04:58:03","","0","117.230.184.74","9dab89e9e990a47225e4f5fc3237815079fd9009");
  466. INSERT INTO user_log VALUES("82","","evansvd","2020-03-11 11:54:55","","0","117.230.143.237","b78f3b0dd5d127e1553f6876ddcc0ef2e4f2e108");
  467. INSERT INTO user_log VALUES("83","","michael","2020-03-11 13:06:52","","0","117.230.143.237","7b60aa4aadefaae9fa890e29951e6ae58e56dbcc");
  468. INSERT INTO user_log VALUES("84","","michael","2020-03-12 11:16:16","","0","49.15.139.173","74a2df7e1dcb71da9e0bc750d389fb002c1c6aff");
  469. INSERT INTO user_log VALUES("85","","michael","2020-03-14 15:33:57","","0","59.93.156.99","f18428de72cc1fb60c20eeb1c82eff95888a5d31");
  470. INSERT INTO user_log VALUES("86","","evansvd","2020-03-30 13:21:29","","0","117.202.121.92","32919f69a00d98b0d5c00c11d67f51c7dd235a1c");
  471. INSERT INTO user_log VALUES("87","","michael","2020-05-16 07:42:17","","0","27.97.216.231","d53e2b81563bf731ffd5873b0d5c8a87efb75764");
  472. INSERT INTO user_log VALUES("88","","evansvd","2020-07-10 07:02:58","","0","5.122.64.232","dfd12e9f4333ea34030d9c0eefca257429779139");
  473.  
  474.  
  475.  
  476. DROP TABLE user_notification;
  477.  
  478. CREATE TABLE `user_notification` (
  479. `id` int(11) NOT NULL,
  480. `user_id` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  481. `status` int(11) NOT NULL,
  482. `timestamp` timestamp NOT NULL DEFAULT current_timestamp()
  483. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  484.  
  485.  
  486.  
  487.  
  488. DROP TABLE users;
  489.  
  490. CREATE TABLE `users` (
  491. `id` int(11) NOT NULL AUTO_INCREMENT,
  492. `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  493. `mobile` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  494. `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  495. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  496. PRIMARY KEY (`id`)
  497. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  498.  
  499.  
  500.  
  501.  
  502. DROP TABLE video;
  503.  
  504. CREATE TABLE `video` (
  505. `id` int(11) NOT NULL AUTO_INCREMENT,
  506. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  507. `path` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  508. `category_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  509. `status` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  510. PRIMARY KEY (`id`)
  511. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  512.  
  513.  
  514.  
  515.  
  516. DROP TABLE youtube;
  517.  
  518. CREATE TABLE `youtube` (
  519. `id` int(11) NOT NULL AUTO_INCREMENT,
  520. `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  521. `path` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  522. `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  523. `active` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  524. `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  525. PRIMARY KEY (`id`)
  526. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!