Mats,
There are at least three sorts of indexes: hash, ordered, and r-tree.
Do you need to include that?
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
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
