odoo-mobile/www/database.sql

CREATE TABLE IF NOT EXISTS 'user' (
'id' INTEGER NOT NULL  PRIMARY KEY AUTOINCREMENT,
'username' VARCHAR(35) DEFAULT NULL,
'password' VARCHAR(35) DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS 'log' (
'id' INTEGER NOT NULL  PRIMARY KEY AUTOINCREMENT,
'description' VARCHAR(160) DEFAULT NULL,
'id_user' INTEGER DEFAULT NULL REFERENCES 'user' ('id')
);