CREATE TABLE integrals ( id SERIAL PRIMARY KEY NOT NULL UNIQUE, name TEXT (32) NOT NULL, ip TEXT (32), posx REAL NOT NULL, posy REAL NOT NULL, port INTEGER, image INT, zones TEXT, pass TEXT );
This is my SQLite generated database, and I am trying to convert it, but I am very new to Postgres.