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 -- 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
