Skip to content
This repository has been archived by the owner on Feb 8, 2018. It is now read-only.

update schema to disallow NULL in some columns #35

Closed
chadwhitacre opened this issue Jun 8, 2012 · 4 comments
Closed

update schema to disallow NULL in some columns #35

chadwhitacre opened this issue Jun 8, 2012 · 4 comments

Comments

@chadwhitacre
Copy link
Contributor

Statement in particular, check for others.
This was referenced Jul 20, 2012
Closed
Closed
chadwhitacre added a commit that referenced this issue Aug 4, 2012
@chadwhitacre
Constrain statement column to NOT NULL (#35)
fcc7993
@chadwhitacre
Copy link
Contributor Author

Deployed to prod.

@chadwhitacre chadwhitacre reopened this Aug 20, 2012
@chadwhitacre
Copy link
Contributor Author

I believe balance should also be NOT NULL.

chadwhitacre added a commit that referenced this issue Oct 3, 2012
@chadwhitacre
Add NOT NULL constraint to balance (#35, #170)
cc6dd6b
@chadwhitacre
Copy link
Contributor Author

I backed up the production database, verified the backup, and applied this change.

@chadwhitacre
Copy link
Contributor Author

Tip: In most database designs the majority of columns should be marked not null.

http://www.postgresql.org/docs/current/static/ddl-constraints.html

FYI

chadwhitacre added a commit that referenced this issue Dec 13, 2012
@chadwhitacre
Accounts elsewhere need a participant (#406, #35)
9028af9
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@chadwhitacre