I create database file from SQLite Expert Personal. I use this database in my app on Android, but autoincrement don't work.
This DDL of one table from this database -
CREATE TABLE [dn_events] (
[id] [INTEGER PRIMARY KEY AUTOINCREMENT],
[action_id] INTEGER,
[action_type_id] INTEGER,
[action_title] TEXT,
[action_run] INTEGER,
[action_date] INTEGER,
[action_rating] DOUBLE,
[action_public] INTEGER,
[action_node] TEXT,
[action_price_total] DOUBLE,
[car_id] INTEGER,
[action_remind_run] INTEGER,
[action_remind_date] INTEGER,
[updated_at] INTEGER,
[fuelling_type_id] INTEGER,
[fuelling_azs_id] INTEGER,
[fuelling_liters_amount] DOUBLE,
[fuelling_liters_price] DOUBLE,
[fuelling_is_full_tank] INTEGER,
[fuelling_is_forgot_prev] INTEGER,
[fuelling_azs_title] CHAR,
[event_type_id] INTEGER,
[event_issuer] TEXT,
[event_type_title] TEXT,
[remind_on] INTEGER,
[method] INTEGER,
[longitude] DOUBLE,
[latitude] DOUBLE,
[geo_id] INTEGER,
[repair_due_accident] INTEGER,
[action_price_total_rub] DOUBLE,
[repair_sto_name] TEXT,
[repair_job_price] DOUBLE);
When I insert one event to table if I dont set id in manual I get null in database
Aucun commentaire:
Enregistrer un commentaire