590
edits
Firefox/Projects/IndexedDB/SQL Schema: Difference between revisions
Jump to navigation
Jump to search
Firefox/Projects/IndexedDB/SQL Schema (view source)
Revision as of 22:16, 29 April 2010
, 29 April 2010Update for using a sqlite database per origin
Comrade693 (talk | contribs) (Account for autoincrement object stores) |
Comrade693 (talk | contribs) (Update for using a sqlite database per origin) |
||
| Line 62: | Line 62: | ||
</group> | </group> | ||
</datatypes><table x=" | </datatypes><table x="63" y="52" name="database"> | ||
<row name="name" null="0" autoincrement="0"> | <row name="name" null="0" autoincrement="0"> | ||
<datatype>MEDIUMTEXT</datatype> | <datatype>MEDIUMTEXT</datatype> | ||
| Line 78: | Line 72: | ||
<datatype>MEDIUMTEXT</datatype> | <datatype>MEDIUMTEXT</datatype> | ||
<default>NULL</default></row> | <default>NULL</default></row> | ||
<key type="UNIQUE" name="unique_name"> | |||
<key type="UNIQUE" name=" | |||
<part>name</part> | <part>name</part> | ||
</key> | </key> | ||
| Line 90: | Line 80: | ||
<row name="id" null="1" autoincrement="0"> | <row name="id" null="1" autoincrement="0"> | ||
<datatype>INTEGER</datatype> | <datatype>INTEGER</datatype> | ||
< | <default>NULL</default></row> | ||
< | |||
</row> | |||
<row name="name" null="0" autoincrement="0"> | <row name="name" null="0" autoincrement="0"> | ||
<datatype>MEDIUMTEXT</datatype> | <datatype>MEDIUMTEXT</datatype> | ||
| Line 102: | Line 88: | ||
<default>NULL</default></row> | <default>NULL</default></row> | ||
<row name="autoincrement" null="0" autoincrement="0"> | <row name="autoincrement" null="0" autoincrement="0"> | ||
<datatype>INTEGER</datatype> | |||
<default>0</default></row> | |||
<row name="readers" null="0" autoincrement="0"> | |||
<datatype>INTEGER</datatype> | |||
<default>0</default></row> | |||
<row name="isWriting" null="0" autoincrement="0"> | |||
<datatype>INTEGER</datatype> | <datatype>INTEGER</datatype> | ||
<default>0</default></row> | <default>0</default></row> | ||
| Line 112: | Line 104: | ||
<row name="id" null="0" autoincrement="0"> | <row name="id" null="0" autoincrement="0"> | ||
<datatype>INTEGER</datatype> | <datatype>INTEGER</datatype> | ||
</row> | </row> | ||
<row name="object_store_id" null="0" autoincrement="0"> | <row name="object_store_id" null="0" autoincrement="0"> | ||
| Line 138: | Line 126: | ||
</key> | </key> | ||
<key type="UNIQUE" name="unique_index_name"> | <key type="UNIQUE" name="unique_index_name"> | ||
<part>name</part> | <part>name</part> | ||
</key> | </key> | ||
| Line 220: | Line 207: | ||
<row name="id" null="1" autoincrement="1"> | <row name="id" null="1" autoincrement="1"> | ||
<datatype>INTEGER</datatype> | <datatype>INTEGER</datatype> | ||
</row> | <default>NULL</default></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> | ||