Displaying 1 result from an estimated 1 matches for "uttered_at".
2006 Nov 17
1
SQLite3 put a parse error in my schema.rb for timestamps
...by keeping a
file, db/create.sql, and if it upgrades, then my tests run it in the
database to create the schema. So the table contains goodies like
these:
drop table chats;
create table chats (
id integer primary key, -- auto_increment,
user_id integer not null,
panel_id integer not null,
uttered_at timestamp DEFAULT CURRENT_TIMESTAMP,
utterance varchar(255) not null
);
(Note, for example, that MySQL will [sometimes] require the
auto_increment, but SQLite can''t use it.)
Now note the timestamp DEFAULT CURRENT_TIMESTAMP. That''s because I''m
too lazy to write Time....