createUsersTable top-level constant

Implementation

const String createUsersTable = '''
  CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    uuid_firebase TEXT,
    email TEXT NOT NULL UNIQUE,
    document_type TEXT NOT NULL,
    document_number TEXT NOT NULL UNIQUE,
    first_name TEXT NOT NULL,
    last_name TEXT NOT NULL,
    cellphone TEXT NOT NULL,
    department_id INTEGER NOT NULL,
    department_name TEXT NOT NULL,
    city_id INTEGER NOT NULL,
    city_name TEXT NOT NULL,
    rol_id INTEGER NOT NULL,
    rol_name TEXT NOT NULL,
    state TEXT NOT NULL,
    verificated INTEGER NOT NULL DEFAULT 0, -- 1 para verificado, 0 para no verificado
    is_active INTEGER NOT NULL DEFAULT 1, -- 1 para activo, 0 para inactivo
    date_joined TEXT NOT NULL
  );
''';