IMPORTANT! Since SQLite 3 does not have a native type for date/time storage, the type DATE is used to set the default value of a DATETIME column to the current timestamp whenever a new row is inserted. In order to insert a specific date chose type TEXT.