Re: SQL inserts

[Jason Pincin <jpincin@ashtech.net>]

> Jason, where is the latest DB schema at?  Perhaps you should put it at a
> consistent URL as soon as it's updated!

Sorry... I haven't updated the schematics... that's next on my list of
documentation updates... That and the diagram.  Once they're updated, I'll
post them on devel where they will live forever after along with the
growing DB Documentation, which is you haven't seen is at
http://devel.linuxkb.org/dbdoc.html

Also, if you want to get an up-to-the-second detail on the DB's, you can
hit http://admin.linuxkb.org/sqladmin/ and login with your user & passwd
account for the DB, and then bring up the linuxkb database, and click on
'Properties' for whichever table your curious about.

> insert into Users set EmailAddr='lyoder@cyberis.net', FakeEmailAddr='',
> Passwd=PASSWORD('passwd'), CookieMethod=0, Fname='Bozo', Lname='the
> Clown', MI='', Handle='bozo', UserDesc='', RoleID=1, QperDay=NULL,
> Href='http://', InceptTime=NOW(), Expiration='1999-22-3 21:22:53'

Shouldn't the 'set' operative only be used with an UPDATE statement?  I
would try re-phrasing that statement as something like this:

insert into Users
values(NULL,'lyoder@cyberis.net','',PASSWORD('passwd'),0,'Bozo','the
Clown', '', 'bozo', '', 1, 0, 0, 'http://', NOW(), '1999-22-3 21:22:53',
NULL)

That last NULL is important as it triggers mysql to timestamp the entry
properly.

Jason