defuze.me  Client
sources_migration.cpp
00001 /**************************************************************************
00002 ** defuze.me Epitech Innovative Project
00003 **
00004 ** Copyright 2010-2011
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    SourcesMigration::up()
00016 {
00017     createTable("sources", "id integer primary key, type int, port int, "
00018                 "host varchar(253), path varchar(1000), username varchar(100), "
00019                 "password varchar(100), filename varchar(100), "
00020                 "updatedAt datetime, status int, recursive bool");
00021     exec("CREATE UNIQUE INDEX source_id ON sources(id)");
00022 }
00023 
00024 void    SourcesMigration::down()
00025 {
00026     dropTable("sources");
00027 }