defuze.me  Client
settings_migration.cpp
00001 /**************************************************************************
00002 ** defuze.me Epitech Innovative Project
00003 **
00004 ** Copyright 2010
00005 **   Athena Calmettes - Jocelyn De La Rosa - Francois Gaillard
00006 **   Adrien Jarthon - Alexandre Moore - Luc Peres - Arnaud Sellier
00007 **
00008 ** All rights reserved.
00009 **************************************************************************/
00010 
00011 #include "migration_list.hpp"
00012 
00013 using namespace DB;
00014 
00015 void    SettingsMigration::up()
00016 {
00017     createTable("settings", "key varchar(50), configuration_id integer, value varchar(255)");
00018     exec("CREATE UNIQUE INDEX settings_key ON settings(key)");
00019     exec("CREATE UNIQUE INDEX settings_config_key ON settings(configuration_id, key)");
00020 
00021     exec("INSERT INTO settings (key, value) VALUES ('migration', 1)");
00022 }
00023 
00024 void    SettingsMigration::down()
00025 {
00026     dropTable("settings");
00027 }