Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Determine proper database schema #1

Open
DeftNerd opened this issue Oct 9, 2014 · 1 comment
Open

Determine proper database schema #1

DeftNerd opened this issue Oct 9, 2014 · 1 comment

Comments

@DeftNerd
Copy link
Member

DeftNerd commented Oct 9, 2014

No description provided.

@DeftNerd
Copy link
Member Author

DeftNerd commented Oct 9, 2014

Other CDN providers will eventually be added, as well as other possible actions to take when servers go down, so the schema should be a little flexible to start with. I need to refresh my laravel db best practices, so the table names and column names are subject to change to find the best way of doing it

#users
id increments
email string(100)
password string(100)
salt string(30)
token string(100)
timestamps

#cdn_providers
id increments
name string(100)
api_endpoint string(100)

#user_cdn
id increments
user_id (foreign key to users.id)
cdn_providers_id (foreign key to cdn_providers.id)
api_key string(100)
timestamps

#user_zones
id increments
user_cdn_id (foreign key to user_cdn.id)
zone_name string(100)

(more to come)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant