CREATE DATABASE  IF NOT EXISTS `onlinebalancedb` DEFAULT CHARACTER SET utf8 ;
USE `onlinebalancedb`;
  
  
  
  CREATE TABLE `movimiento` (
  `idMovimiento` int(16) NOT NULL AUTO_INCREMENT,
  `idTarjeta` bigint(16) NOT NULL,
  `movimiento` varchar(450) NOT NULL,
  `cantidad` double NOT NULL,
  PRIMARY KEY (`idMovimiento`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
  
  INSERT INTO `movimiento` VALUES (1,1234567890123456,'Abono tarjeta',25000),
  (2,1234567890123456,'Compra en osso',100.5),
  (3,1234567890123456,'Pago gasolina pemez',300),
  (4,1234567890123456,'Compra de boleto ticket monster',15000),
  (5,1234567890123456,'Retiro de cajero',5000),
  (6,1234123456785678,'Abono tarjeta',21000),
  (7,1234123456785678,'Compra comercial valle dorado',5500),
  (8,1234123456785678,'Abono tarjeta',10000),
  (9,1111222233334444,'Abono tarjeta',40000),
  (10,1111222233334444,'retiro cajero',5000),
  (11,1111222233334444,'retiro tarjeta',3000);
  
  CREATE TABLE `saldo` (
  `IDTARJETA` bigint(16) NOT NULL,
  `SALDO` double DEFAULT NULL,
  PRIMARY KEY (`IDTARJETA`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  INSERT INTO `saldo` VALUES (1234567890123456,19199.5),
  (1234123456785678,29500),
  (1111222233334444,32000);
  
  

 
 APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:BVuN7fY5ZydcsR+9LA16JysHwrQtEKpFZDZe6aAgKcA=
APP_DEBUG=true
APP_LOG_LEVEL=debug
APP_URL=http://localhost
  
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=onlinebalancedb
DB_USERNAME=admin
DB_PASSWORD=adminlara

BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
SESSION_LIFETIME=120
QUEUE_DRIVER=sync

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_DRIVER=smtp
MAIL_HOST=smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
PUSHER_APP_CLUSTER=mt1
 
 
 

  <?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateMovimientosTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('movimientos', function (Blueprint $table) {
            $table->increments('idMovimiento');
            $table->bigInteger('idTarjeta');
            $table->string('movimiento');
            $table->double('cantidad');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('movimientos');
    }
}
  
  
  

  <?php

use Illuminate\Database\Seeder;

class MovimientosTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        //
        factory(App\Movimiento::class,50)->create();
    }
}
  
   

  <?php

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        // $this->call(UsersTableSeeder::class);
    	$this->call(MovimientosTableSeeder::class);
    }
}