Stewart Smith wrote:
On Sat, Nov 07, 2009 at 05:00:47PM -0800, Brian Aker wrote:
Should we have a unique key on tables, and if so... does it belong
in the proto?
Database, Table Name, is_temporary_table and session_id
I don't see why is_temporary_table and session_id would be in the proto
at all. Reason: the proto isn't written to disk for temporary tables,
and therefore there isn't a need to distinguish temporary tables from
each other in a serialized on-disk format.
For replication, temporary tables aren't replicated, so that takes care
of that...
The natural primary key for a "set of tables" is:
(schema_name, table_name)
I see no reason to have anything additional in the proto. This means
that the only change needed to the table proto definition (IMHO) is the
addition of the schema_name.
Cheers,
Jay
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
