PHP Classes

File: tests/json/1.json

Recommend this page to a friend!
  Classes of Samuel Adeshina   Scripd   tests/json/1.json   Download  
File: tests/json/1.json
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Scripd
Generate database creation SQL queries from JSON
Author: By
Last change: Merge branch 'master' of https://github.com/Samshal/Scripd
Date: 7 years ago
Size: 1,354 bytes
 

Contents

Class file image Download
{ ":database":{ ":crud-action":"create", "name":"another_unify_schools", ":table-group":[ { ":crud-action":"create", "name":"students", "columns":[ { "name":"id", "data-type":"int", "primary-key":true }, { "name":"first_name", "data-type":"varchar(20)", "default":"'samuel'" }, { "name":"last_name", "data-type":"varchar(20)" }, { "name":"class", "data-type":"varchar(10)" } ] }, { ":crud-action":"create", "name":"faculty", "columns":[ { "name":"fac_id", "data-type":"int", "auto_increment":true, "primary-key":true }, { "name":"first_name", "data-type":"varchar(20)" }, { "name":"last_name", "data-type":"varchar(20)" } ] }, { ":crud-action":"create", "name":"subjects", "columns":[ { "name":"subject_id", "data-type":"int", "auto_increment":true, "primary-key":true }, { "name":"subject_name", "data-type":"varchar(30)" }, { "name":"subject_faculty", "data-type":"int", "foreign-key":"(subject_faculty)", "references":"faculty(fac_id)", "on-update":"cascade", "on-delete":"set null" } ] } ] } }