Creation of a table

To create a new table on the screen properties of the database, enter the name of your table and the number of fields expected.

You arrive on a screen allowing the seizure of properties of each field.

We take the fields from our table. Note that in 'SQLite' field type 'Integer' design as a primary key is a field with auto-increment. If you realize that you need only two made field! simply do not enter the field name.

And that's the result: It is possible to add 'No' or fields you want in the table!

To create 'index', you have a small summary in the table properties.

We want our field 'libel' is an 'Index' -> The result: We want to create another 'index': but just a column, then we wanted 3! Made add 2 columns: -> And voila the job