PHP Classes

File: client_master.sql

Recommend this page to a friend!
  Classes of Ramesh Narayan Jangid   PHP Microservices Framework   client_master.sql   Download  
File: client_master.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Microservices Framework
Setup microservices apps with configuration arrays
Author: By
Last change: domain config
Date: 27 days ago
Size: 3,533 bytes
 

Contents

Class file image Download
DROP TABLE IF EXISTS `master_users`; CREATE TABLE `master_users` ( `user_id` int NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `password_hash` varchar(255) NOT NULL, `group_id` int NOT NULL, `token` varchar(255) NOT NULL, `token_ts` int UNSIGNED DEFAULT 0, `comments` varchar(255) DEFAULT NULL, `created_by` int DEFAULT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `approved_by` int DEFAULT NULL, `approved_on` timestamp NULL DEFAULT NULL, `updated_by` int DEFAULT NULL, `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `is_approved` enum('Yes','No') NOT NULL DEFAULT 'No', `is_disabled` enum('Yes','No') NOT NULL DEFAULT 'No', `is_deleted` enum('Yes','No') NOT NULL DEFAULT 'No', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; DROP TABLE IF EXISTS `registration`; CREATE TABLE `registration` ( `id` int NOT NULL AUTO_INCREMENT, `firstname` varchar(255) NOT NULL, `lastname` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `created_by` int DEFAULT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `approved_by` int DEFAULT NULL, `approved_on` timestamp NULL DEFAULT NULL, `updated_by` int DEFAULT NULL, `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `is_approved` enum('Yes','No') NOT NULL DEFAULT 'No', `is_disabled` enum('Yes','No') NOT NULL DEFAULT 'No', `is_deleted` enum('Yes','No') NOT NULL DEFAULT 'No', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `id` int NOT NULL AUTO_INCREMENT, `registration_id` int NOT NULL DEFAULT 0, `address` varchar(255) NOT NULL, `created_by` int DEFAULT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `approved_by` int DEFAULT NULL, `approved_on` timestamp NULL DEFAULT NULL, `updated_by` int DEFAULT NULL, `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `is_approved` enum('Yes','No') NOT NULL DEFAULT 'No', `is_disabled` enum('Yes','No') NOT NULL DEFAULT 'No', `is_deleted` enum('Yes','No') NOT NULL DEFAULT 'No', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `category`; CREATE TABLE `category` ( `id` int NOT NULL AUTO_INCREMENT, `parent_id` int NOT NULL DEFAULT 0, `name` varchar(255) NOT NULL, `created_by` int DEFAULT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `approved_by` int DEFAULT NULL, `approved_on` timestamp NULL DEFAULT NULL, `updated_by` int DEFAULT NULL, `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `is_approved` enum('Yes','No') NOT NULL DEFAULT 'No', `is_disabled` enum('Yes','No') NOT NULL DEFAULT 'No', `is_deleted` enum('Yes','No') NOT NULL DEFAULT 'No', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; LOCK TABLES `master_users` WRITE; /*!40000 ALTER TABLE `master_users` DISABLE KEYS */; INSERT INTO `master_users` VALUES (1,'client_1_group_1_user_1','$2y$10$o8hFTjBIXQS.fOED2Ut1ZOCSdDjTnS3lyELI4rWyFEnu4GUyJr3O6',1,'',0,NULL,0,'2023-02-22 04:12:50',NULL,NULL,0,'2023-04-20 16:53:57','Yes','No','No'), (2,'client_1_group_2_user_1','$2y$10$o8hFTjBIXQS.fOED2Ut1ZOCSdDjTnS3lyELI4rWyFEnu4GUyJr3O6',2,'',0,NULL,0,'2023-02-22 04:12:50',NULL,NULL,0,'2023-04-20 16:53:57','Yes','No','No'); /*!40000 ALTER TABLE `master_users` ENABLE KEYS */; UNLOCK TABLES;