On Fri, 2009-07-17 at 17:34 +0200, Johan Euphrosine wrote: > On Fri, 2009-07-17 at 17:07 +0200, Loic Dachary wrote: > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > Johan Euphrosine wrote: > > > On Fri, 2009-07-17 at 14:49 +0200, Loic Dachary wrote: > > >> +CREATE TABLE chat_messages ( + serial INT UNSIGNED NOT NULL > > >> AUTO_INCREMENT, > > >> > > >> there is no need for a serial for each message. > > > > > > How would you be able to select individual message then, what would > > be the primary key ? > > The timestamp would be the primary key. > > We settled this decision on IRC: > (05:07:44 PM) dachary: the timestamp is the primary key proppy > (05:07:51 PM) dachary: do you think it makes sense ? > (05:07:55 PM) proppy: dachary: timestamp is in seconds > (05:08:02 PM) proppy: there can be 2 simultaneous message > (05:08:06 PM) proppy: on different table > (05:08:17 PM) dachary: then it's a key but not unique > (05:08:21 PM) proppy: dachary: say you wants to refer to a particular > message > (05:08:27 PM) proppy: it is nice to have an id for that > (05:08:59 PM) dachary: ok, if you insist I don't mind
I commited it to trunk: http://svn.gna.org/viewcvs/pokersource?rev=6100&view=rev -- Johan Euphrosine <[email protected]>
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Pokersource-users mailing list [email protected] https://mail.gna.org/listinfo/pokersource-users
