Clean up SQL

[rebelsky]

The id should be the first column.

We need defaults and autogen for ids.

We need autogen for other fields, too.

[alexthemitchell]

The autogen for ids should be type INT(11) AUTO_INCREMENT PRIMARY KEY

[rebelsky]

I know that. But that's not how it was set in a many of the tables. The ids were also not the first column. So it's something that needs to be done.

-- SamR

On Jun 25, 2014, at 3:19 PM, Alex Mitchell notifications@github.com
wrote:

The autogen for ids should be type INT(11) AUTO_INCREMENT PRIMARY KEY

—
Reply to this email directly or view it on GitHub.