Can you tell what type of SQL DB this .sql file is for?

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

Your email address will not be published. Required fields are marked *