VULAB-153: Convert Datase Outline to SQL

Metadata

Source
VULAB-153
Type
Task
Priority
Major
Status
Closed
Resolution
Fixed
Assignee
Blake E
Reporter
Blake E
Created
2009-01-22T15:18:53.000-0500
Updated
2014-03-03T14:45:15.966-0500
Versions
  1. 0.6
Fixed Versions
  1. 0.6
Component
  1. Web

Description

Take the google document at http://spreadsheets.google.com/ccc?key=pc-kQ_3BYJoieI6TJKzvLUQ and convert it to an actual sql file for database import essentially creating the base for the initial VULab bootstrap

Attachments

Comments

  • Blake E commented 2009-01-22T15:19:01.000-0500

    vulab13

  • Blake E commented 2009-01-22T16:01:16.000-0500

    I have created the boostrap .sql file minus the user tables (users, roles, groups) as they will be dictated by the Active User Library that I use.

  • Blake E commented 2009-01-22T16:04:19.000-0500

    Note: that some table names and fields have changed to follow the CakePHP conventions and take use of the automagic functions that CakePHP offers.

    ex. project_id becomes id, and question_types becomes qtypes.

    you can read up on them here: http://book.cakephp.org/view/24/Model-and-Database-Conventions