defuze.me
Client
|
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 }