Clean up db columns

[wilbertom]

Set lengths on Unicode columns, make sure all columns which can't be null, can't be null. Replace SQLite3 and apply the database migration.

[wilbertom]

Paging @nwinklareth @bepetersn, what is a ChargesDescription's description column? Is it what we called a charges

[nwinklareth]

"Driving with a suspended license"

That is an example of a description.

As to the length, run this query on the database:

select charges from countyapi_chargeshistory
where length(charges ) =
( select max(length(charges )) from countyapi_chargeshistory)

then sun up to the next power of 2 and use that as the length of field, I
would use varchar or the unicode equivalent, fixed length field will waste
a lot of space

On Mon, May 12, 2014 at 5:36 PM, Wilberto Morales
[email protected]:

Paging @nwinklareth https://github.com/nwinklareth @bepetersnhttps://github.com/bepetersn,
what is a ChargesDescription's description column?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/366#issuecomment-42897333
.

Regards

Norbert

Norbert Winklareth

[bepetersn]

@wilbertom, does this still need work?

[wilbertom]

Yup still needs a lot with columns sizes, and stuff.