PHP Classes

File: familytree/sql/familytree.sql

Recommend this page to a friend!
  Classes of Ssaurz Acharya   FedUni PHP Family Tree App   familytree/sql/familytree.sql   Download  
File: familytree/sql/familytree.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: FedUni PHP Family Tree App
Manage and display a tree of family people
Author: By
Last change:
Date: 1 year ago
Size: 1,267 bytes
 

Contents

Class file image Download
DROP DATABASE IF EXISTS familyapp; CREATE DATABASE familyapp CHARACTER SET utf8 COLLATE utf8_general_ci; USE familyapp; CREATE TABLE person ( id INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL, date_of_birth DATE NOT NULL ); CREATE TABLE parent ( parent_id INT(11) NOT NULL, child_id INT(11) NOT NULL, FOREIGN KEY (parent_id) REFERENCES person(id), FOREIGN KEY (child_id) REFERENCES person(id) ); CREATE TABLE users ( user_id INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, username VARCHAR(100) NOT NULL, password VARCHAR(100) NOT NULL, is_admin TINYINT(1) NOT NULL DEFAULT '0' ); INSERT INTO person (id, name, date_of_birth) VALUES (1, 'Rujal Shakya', '1965-04-14'), (2, 'Govinda Thapa', '1985-10-15'), (3, 'Srijana Gurung', '2005-07-03'), (4, 'Ayushma Koirala', '1968-08-22'), (6, 'Saurya Dhwoj Acharya', '1970-12-22'), (7, 'Barsha Subedi', '1995-12-23'); INSERT INTO parent (parent_id, child_id) VALUES (1, 2), (2, 3), (4, 2), (6, 7); INSERT INTO users (user_id, username, password, is_admin) VALUES (1, 'admin', '$2y$12$AZrfhguwbc/xSxqGnw5YQOviOkvLt5wAZ2V5vgMRFZYv5Eu5c35kC', 1), (2, 'phill', '$2y$12$KLUVPAcynyfPVKLcl8mLIO4QllsvMT2LfWS4yNoZvYR0Qq5/WW7Ii', 0);