590
edits
Firefox/Projects/IndexedDB/SQL Schema: Difference between revisions
Firefox/Projects/IndexedDB/SQL Schema (view source)
Revision as of 20:38, 5 April 2010
, 5 April 2010Tweak object store bits of the schema
Comrade693 (talk | contribs) (Add index on object_data.key_value) |
Comrade693 (talk | contribs) (Tweak object store bits of the schema) |
||
| Line 62: | Line 62: | ||
</group> | </group> | ||
</datatypes><table x=" | </datatypes><table x="64" y="52" name="database"> | ||
<row name="id" null=" | <row name="id" null="0" autoincrement="1"> | ||
<datatype>INTEGER</datatype> | <datatype>INTEGER</datatype> | ||
</row> | |||
<row name="origin" null="0" autoincrement="0"> | <row name="origin" null="0" autoincrement="0"> | ||
<datatype>MEDIUMTEXT</datatype> | <datatype>MEDIUMTEXT</datatype> | ||
| Line 87: | Line 87: | ||
<comment>List of databases stored.</comment> | <comment>List of databases stored.</comment> | ||
</table> | </table> | ||
<table x=" | <table x="248" y="125" name="object_store"> | ||
<row name="id" null=" | <row name="id" null="0" autoincrement="1"> | ||
<datatype>INTEGER</datatype> | <datatype>INTEGER</datatype> | ||
</row> | |||
<row name="database_id" null="0" autoincrement="0"> | <row name="database_id" null="0" autoincrement="0"> | ||
<datatype>INTEGER</datatype> | <datatype>INTEGER</datatype> | ||
<relation table="database" row="id" /> | <relation table="database" row="id" /> | ||
</row> | |||
<row name="name" null="0" autoincrement="0"> | |||
<datatype>MEDIUMTEXT</datatype> | |||
</row> | </row> | ||
<row name="key_path" null="1" autoincrement="0"> | <row name="key_path" null="1" autoincrement="0"> | ||
| Line 100: | Line 103: | ||
<key type="PRIMARY" name=""> | <key type="PRIMARY" name=""> | ||
<part>id</part> | <part>id</part> | ||
<part>database_id</part> | |||
</key> | </key> | ||
<comment>Stores object stores.</comment> | <comment>Stores object stores.</comment> | ||
| Line 133: | Line 137: | ||
<comment>Stores the indexes for object stores</comment> | <comment>Stores the indexes for object stores</comment> | ||
</table> | </table> | ||
<table x="282" y=" | <table x="282" y="280" name="object_data"> | ||
<row name="id" null=" | <row name="id" null="0" autoincrement="1"> | ||
<datatype>INTEGER</datatype> | <datatype>INTEGER</datatype> | ||
</row> | |||
<row name="object_store_id" null="0" autoincrement="0"> | <row name="object_store_id" null="0" autoincrement="0"> | ||
<datatype>INTEGER</datatype> | <datatype>INTEGER</datatype> | ||
| Line 150: | Line 154: | ||
<key type="PRIMARY" name=""> | <key type="PRIMARY" name=""> | ||
<part>id</part> | <part>id</part> | ||
<part>object_store_id</part> | |||
</key> | </key> | ||
<key type="INDEX" name="key_index"> | <key type="INDEX" name="key_index"> | ||
<part>key_value</part> | <part>key_value</part> | ||
<part>object_store_id</part> | |||
</key> | </key> | ||
<comment>Stores objects for an object store.</comment> | <comment>Stores objects for an object store.</comment> | ||