### MIGRATIONS ###
### http://daylerees.com/codebright/migrations ###


# Criar o banco de dados
CREATE DATABASE ordersys
  WITH OWNER = postgres
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'Portuguese_Brazil.1252'
       LC_CTYPE = 'Portuguese_Brazil.1252'
       CONNECTION LIMIT = -1;


# Path do projeto
cd C:\Users\Jonas\workspace_laborati\ordersys

# Criar a tabela de controle de migrations
php artisan migrate:install  

# Criar uma migration
php artisan migrate:make db

# Rodar todas migrations novas
php artisan migrate

# Reverte todas as migrations e roda as mesmas novamente
php migrate:refresh

# Reverte a última migration executada
php artisan migrate:rollback

# Reverte todas as migrations
php artisan migrate:reset


#Atualizar para funcionar rollback de migrations
C:\Users\Jonas\workspace_laborati\ordersys>php C:\php-5.5\composer.phar update
C:\Users\Jonas\workspace_laborati\ordersys>php C:\php-5.5\composer.phar dump-autoload


## SEED DATABASE ##
C:\Users\Jonas\workspace_laborati\ordersys> php artisan db:seed


## Restore via script ##
\i /nome_do_arquivo.backup