Make a MySQL script for a Organization Users Table that does the following
Table name: orgs
Columns:
orgid (unique; autoincremented when inserted to database; is a number)
name (string)
description (string)
head (string)
website (string)
location (string)
emailaddress (string)
passord (string)
All column names are lowercase.
Document the table details in the database wiki page.
Document the dummy accounts in the wiki page as well.
append the sql script inside the sql folder in backend->src->main->resources->setup_db
Make a MySQL script for a Organization Users Table that does the following
Table name: orgs
Columns:
orgid (unique; autoincremented when inserted to database; is a number) name (string) description (string) head (string) website (string) location (string) emailaddress (string) passord (string)
All column names are lowercase.
Document the table details in the database wiki page. Document the dummy accounts in the wiki page as well.
append the sql script inside the sql folder in backend->src->main->resources->setup_db