John David Duncan wrote: > Mats, > > There are at least three sorts of indexes: hash, ordered, and r-tree. > Do you need to include that?
I didn't add that immediately since I didn't know how significant it was. As I understand it, it's optional, and not all engines support it. However, I added that to the definition on the Wiki page. /Matz > > JD > > > On Aug 12, 2008, at 4:51 AM, Mats Kindahl wrote: > >> Hi Brian! >> >> Here's a diff for a tentative definition of indexes for a table. >> >> If you have no objections, I'll update the wiki... >> >> /Matz >> >> Brian Aker wrote: >>> Hi! >>> >>> My roadblock in getting I_S, FRM, etc done is coming up with a new >>> serialized form of a table definition. I've found that I really like >>> what Google has done with Protobuffers. >>> >>> This is the definition I have thus far: >>> http://drizzle.wikia.com/wiki/Table_Proto_Definition#Current_Definition >>> >>> Foreign Keys have not been defined yet, and the index definition is >>> weak. I've put it up on Wikia so that others can take a look at it/offer >>> up edits. Right now I have defined out all of the types, but it would be >>> possible to shrink these (aka put a bit in for signed/unsigned... use >>> collation to define binary or not). >>> >>> Thoughts? Suggestions? Additions from engine folks? >> >> [EMAIL PROTECTED]:~/lang/proto/tests$ diff -u table.proto.orig table.proto >> --- table.proto.orig 2008-08-12 13:47:07.965551968 +0200 >> +++ table.proto 2008-08-12 13:46:27.649580687 +0200 >> @@ -37,8 +37,20 @@ >> optional string custom_name = 10; >> } >> >> + enum IndexType { >> + UNDEFINED = 0; >> + UNIQUE = 1; >> + PRIMARY = 2; >> + } >> + >> + message Index { >> + repeated string name = 1; >> + optional IndexType type = 2 [default = UNDEFINED]; >> + optional int32 key_block_size = 3; >> + } >> + >> repeated Field field = 4; >> - optional string primary = 5; >> + repeated Index index = 5; >> optional int32 auto_increment = 6; >> optional int32 avg_row_length = 7; >> optional string character_set = 8; >> @@ -49,7 +61,6 @@ >> optional string data_directory = 13; >> optional string index_directory = 14; >> optional bool delay_key_write = 15; >> - optional int32 key_block_size = 16; >> optional int32 max_rows = 17; >> optional int32 min_rows = 18; >> optional bool pack_keys = 19; >> >>> >>> Cheers, >>> -Brian >>> >>> -- >>> _______________________________________________________ >>> Brian "Krow" Aker, brian at tangent.org >>> Seattle, Washington >>> http://krow.net/ <-- Me >>> http://tangent.org/ <-- Software >>> _______________________________________________________ >>> You can't grep a dead tree. >>> >>> >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~drizzle-discuss >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~drizzle-discuss >>> More help : https://help.launchpad.net/ListHelp >> >> >> -- >> Mats Kindahl >> Lead Software Developer >> Replication Team >> MySQL AB, www.mysql.com >> <mats.vcf>_______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp > -- Mats Kindahl Lead Software Developer Replication Team MySQL AB, www.mysql.com
begin:vcard fn:Mats Kindahl n:Kindahl;Mats org:Sun Microsystems adr;quoted-printable:;;Tegv=C3=A4gen 3;Storvreta;SE;74334;Sweden email;internet:[EMAIL PROTECTED] title:Lead Replication Software Developer x-mozilla-html:FALSE version:2.1 end:vcard
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
