I believe there is a missing right parenthesis after the 11.  has_children is a third Boolean column.

On Apr 17, 2017 2:29 PM, "David Karr" <davidmichaelkarr@gmail.com> wrote:

I've used Mariadb for a couple of small projects.  I prefer to
automate as much of the initial creation and config as possible, using
SQL scripts executed from JDBC.  I can at least do this for the table
creation and population.

I'm taking over an existing small project that is organized somewhat
funky. There are some scripts that are apparently intended to
initialize the database, but I'm seeing one line in one of those
scripts that I don't understand, and I don't think is valid.

I would appreciate some help explaining what you think this line MIGHT
be intending to do:
-----------------
ALTER TABLE `project` add column (proj_typ_id TINYINT(2) NOT NULL
DEFAULT 1, parent_proj_id int(11, has_children BOOLEAN);
-----------------

The first problem is that first paren. There's no matching right
paren, so I can't imagine this can succeed.

Second, I don't understand much past that first comma.  Is this
intending to add TWO columns, the second being "parent_proj_id"?
Assuming that's the case, what exactly does "int(11, has_children
BOOLEAN)" mean?  I can see that it's declaring an 11-digit int, but I
don't understand the "has_children" part.

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp