Your .db or .sqlite files compatible with Mobincube must have a specific structure. Otherwise, you won’t be able to import your database from Mobincube.
Nevertheless there’s a faster and easier way to make your .db or .sqlite files compatible by creating a database with Mobincube, filling some data and exporting it as .sqLite file.
Specifications:
The database structure must have 2 tables: fields and items.
The ‘fields’ table must have 3 fields and another one optional: fieldID, name, type and orderField (optional).
| Fields | Comments |
| fieldID | Auto- Can be increased |
| name | Name for the database fields |
| type | 0 = number 1 = text 6 = remote |
| orderField | Optional. Indicates the fields order |
Example of a fields table:
| fieldID | name | type | orderField |
| 1 | field 1 | 0 | 1 |
| 2 | field 2 | 1 | 2 |
| 3 | field 3 | 1 | 3 |
| 4 | field 4 | 1 | 4 |
| 5 | field 5 | 0 | 5 |
| ... | ... | ... | ... |
The 'items' table will have as many columns as registers in the fields table, plus a key-field called 'capoID'.
Here is an example of an items table:
| capoID | field1 | field2 | field3 | ... |
| 1 | 1560 | John | Android | |
| 2 | 5313 | James | Android | |
| 3 | 2131 | David | WPhone | |
| 4 | 213 | Homer | iOS | |
| 5 | 5784 | Peter | RIM | |
| ... | ... | ... | ... |