Can you tell what sql database this sql snippet is for?
CREATE TABLE attachment (
type text, id text, filename text, size integer, time integer, description text, author text, ipnr text, UNIQUE (type,id,filename) ); INSERT INTO "attachment" VALUES('wiki','CrazyTown','mysql-ds.xml',1146, 1149200303854610,'','master','192.168.1.1');
Answer is
SQLite. You can tell by the 16 digit number for a column that is labeled as Integer. SQLite just has an integer datatype and no BIGINT, TINYINT, or SMALLINT, like MySQL or Postgres may have you use. This would have required BIGINT in the DDL.
Leave a Reply