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