FYI, there is an IRC server on cvs.working-dogs.com:6667 and we do Turbine
discussion in #turbine. Today, Rafal and I had a quick discussion about
autoincrement being turned on on Turbine's .sql files...here is the
conclusion of that discussion for archival purposes. :-)
2:43:12 PM: <Rafal> hmm, the mapbuilder specifes
primaryKeyMetod(ID_BROKER) so I think we *should* remove those
auto_increments
2:43:12 PM: <Rafal> otherwise it probably work funny :)
2:43:39 PM: <jon> yep...totally
2:43:52 PM: <jon> it is funny though...mysql will ignore autoincrement if
you specify the id
2:44:24 PM: <Rafal> will it? I thaught that it would use auto for insert
anyway
2:44:39 PM: <Rafal> you can overwirte it with update only, but I might be
wrong
2:45:34 PM: <jon> not my experience so far...
2:46:06 PM: <Rafal> I can run a quick test from the command line
client...
2:48:11 PM: <jon> i just did a test...
2:48:13 PM: <jon> it worked
2:48:40 PM: <Rafal> me too, and it worked too! :))
2:49:01 PM: <Rafal> ok, I removed them already to avoid confusion...
2:58:10 PM: <jon> cool
3:03:17 PM: <jon> ok, i just read the mysql documentation...
3:03:35 PM: <jon>
http://www.mysql.com/documentation/mysql/commented/manual.php?section=CREATE
_TABLE
3:03:43 PM: <jon> it details the behavior pretty well...
3:03:51 PM: <jon> you need to do an insert with null or 0 on that column
3:04:05 PM: <jon> having it be autoincrement in the .sql files is needed if
people don't want to use the idbroker
3:04:07 PM: <jon> so put it back
3:04:08 PM: <jon> :-)
-jon
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
