Skip to content

CS2102 Database Systems PHP (MINI framework) + Postgres web app

Notifications You must be signed in to change notification settings

cs2012-vdxn/vdxn

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Set up

Run vagrant up in same directory as this README file.

Phpmyadmin is available at 192.168.33.66/phpmyadmin

Site is available at 192.168.33.66

Seed the database manually.

Instructions

File Structure for important files

.
├── /application/Controller    # Contains main app logic that retrieves data from the Model
├── /application/Model         # Contains .SQL files that implement our Model methods. You may find all of our SQL queries here
├── /application/view          # UI template files and implementation
├── /public                    # Contains public image assets, and necessary CSS and JS files
└── seed.sql                   # Database seeds

Database Seeding

When you pull any changes off the repo, be sure to update your database with what is defined in seed.sql

seed.sql should contain the following:

  1. Dropping existing tables
  2. Adding tables
  3. Seeding tables with values

As we are currently creating new components and assembling them together, the schema is incomplete. A TODO will be to add the foreign key requirements and updates to the schema so that it concisely represents our requirements.

UI CSS Styling

You can use some of these in-built HTML elements / CSS classes to style your components. Documentation located in the HTML files at /public/flat-ui-bootstrap-template/docs.

Credits to Flat-UI - made by Designmodo.

Workflow

Work off your own branch, and merge to master as you see fit.

About

CS2102 Database Systems PHP (MINI framework) + Postgres web app

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •