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: refactoring and bug fixes
refactoring and bug fixes
Date: 15 days ago
Size: 2,114 bytes
 

Contents

Class file image Download
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;