/*
SQLyog Ultimate v12.4.3 (64 bit)
MySQL - 10.1.31-MariaDB : Database - pdam
*********************************************************************
*/



/*Table structure for table `users` */


CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `built_in` tinyint(1) NOT NULL DEFAULT '0',
  `firebase_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_username_unique` (`username`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_phone_number_unique` (`phone_number`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `users` */

insert  into `users`(`id`,`username`,`full_name`,`email`,`address`,`phone_number`,`password`,`photo`,`active`,`built_in`,`firebase_token`,`remember_token`,`created_at`,`updated_at`) values 
(1,'admin','Administrator','admin@artcak.com',NULL,NULL,'$2y$12$biwFNpvC7MBcMST.kNJnbus4OQVMRpVSQbGaFWA8k3Mast6PLNDVG',NULL,1,1,NULL,'3LGIEfxwX13EvQE1rAB1gKbu2R6dKp9RJkwCCmdxJEBFIhKHgNerC73GVxEg','2018-05-03 07:12:31','2018-05-03 07:12:31'),
(2,'ownser','Owner','owner@artcak.com',NULL,NULL,'$2y$10$R3nZweofhkR2wE876Icqpeqs6MYPd4a/kJ4bRsF9ayxbLXnI6cLJm',NULL,1,0,NULL,NULL,'2018-05-03 07:12:31','2018-05-03 07:12:31'),
(3,'contributor1','Contributor 1','contributor1@artcak.com',NULL,NULL,'$2y$10$5SRcfVQw0vgZZm9WZTV9Mu9fJBF640KyFtXUjcQ/0Fi6Q2nA/K9QO',NULL,1,0,NULL,NULL,'2018-05-03 07:12:32','2018-05-03 07:12:32');

