22.11.2016, 20:35
Puedes hacerla asi:
Database = db_open("database.db");
db_query(Database,"CREATE TABLE IF NOT EXIST (`Nombre` VARCHAR (24) COLLATE NOCASE, `Pass` VARCHAR(12, `Edad` INTEGER DEFAULT 0 NOT NULL, `Genero` INTEGER DEFAULT 0 NOT NULL, `DNI` INTEGER DEFAULT 0 NOT NULL)");
Database = db_open("database.db");
db_query(Database,"CREATE TABLE IF NOT EXIST (`Nombre` VARCHAR (24) COLLATE NOCASE, `Pass` VARCHAR(12, `Edad` INTEGER DEFAULT 0 NOT NULL, `Genero` INTEGER DEFAULT 0 NOT NULL, `DNI` INTEGER DEFAULT 0 NOT NULL)");