9TNTSe9p

1Falha ao criar a tabela va_atiradores:  QSqlError("42601", "QPSQL: Unable to create query", "ERROR:  syntax error at or near "("nLINE 4: cpf integer(11) NOT NULL UNIQUE,n                   ^n(42601)")
2	
3bool Atirador::insert(QStringList &data)
4{
5
6    QSqlDatabase db = QSqlDatabase::database();
7
8    const QString sqlTable = "CREATE TABLE IF NOT EXISTS sch_tg.va_atiradores(n"
9                       "id SERIAL PRIMARY KEY,n"
10                       "nome varchar(1000) NOT NULL UNIQUE,n"
11                       "cpf integer(11) NOT NULL UNIQUE,n"
12                       "rg integer(20) NOT NULL UNIQUE,n"
13                       "ra integer(30) UNIQUE,n"
14                       "nPai varchar(1000) NOT NULL UNIQUE,n"
15                       "nMae varchar(1000) NOT NULL UNIQUE,n"
16                       "dataNasc date NOT NULL,n"
17                       "estdCvl integer NOT NULL,n"
18                       "cidade varchar(250) NOT NULL,n"
19                       "cep integer(10) NOT NULL,n"
20                       "estado varchar(250) NOT NULL,n"
21                       "uf varchar(2) NOT NULL,n"
22                       "rua varchar(500) NOT NULL,n"
23                       "nCasa integer,n"
24                       "bairro varchar(500) NOT NULL,n"
25                       "cel integer(30) UNIQUE,n"
26                       "tel integer(30) UNIQUE,n"
27                       "tipoAtr integer NOT NULL,n"
28                       "status integer NOT NULL,n"
29                       "cadPor varchar(250) NOT NULL,n"
30                       "ultServ date,n"
31                       "pontos integer,n"
32                       "servicos integer)";
33
34    QSqlQuery createTableQuery(db);
35
36    if(!createTableQuery.exec(sqlTable)){
37
38        qCritical() << "Falha ao criar a tabela va_atiradores: " << createTableQuery.lastError();
39
40        createTableQuery.finish();
41
42        return true;
43    }
44
45    createTableQuery.finish();
46
47    db.close();
48
49    return true;
50}
51	
52ERROR:  syntax error at or near "("
53LINE 4:                        cpf integer(11) NOT NULL UNIQUE,
54                                          ^
55SQL state: 42601
56Character: 189