Haven't coded in ~8 years. What language should I pick? : learnprogramming. Ioannis cherouvim » Blog Archive » A table that should exist in all projects with a database. It’s called schema_version (or migrations, or whatever suits you) and its purpose is to keep track of structural or data changes to the database.
A possible structure (example in MySQL) is: 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'); Whether you add this table from the beggining of the project or just after you’ve deployed the first version to a staging or production server is up to you. Whenever you need to execute an SQL script to change the database structure or perform a data migration you should be adding a row in that table as well. Fomvi.jpg (JPEG Image, 528x1630 pixels) How to Crack a Wi-Fi Network's WEP Password with BackTrack - Lifehacker. How to Make Your PC as Fast as the Day You Bought It.
Top Linux commands every linux user should know. : linux. Learn typing at the speed of thought! Typing lessons that work. The Home Row Keys.