Wednesday, December 08, 2010

ioannis cherouvim » Blog Archive » A table that should exist in all projects with a database

ioannis cherouvim » Blog Archive » A table that should exist in all projects with a database: "create table schema_version (
`when` timestamp not null default CURRENT_TIMESTAMP,
`key` varchar(256) not null,
`extra` varchar(256),
primary key (`key`)
) ENGINE=InnoDB;

insert into schema_version(`key`, `extra`) values ('001', 'schema version');"