Guest User

Untitled

a guest
Mar 20th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. Schema::create('campaign', function (Blueprint $table) {
  2. $table->engine='InnoDB';
  3. $table->increments('id');
  4. $table->integer('users_id')->unsigned();
  5. $table->foreign('users_id')->references('id')->on('users')->onDelete('cascade')->onUpdate('cascade');
  6. $table->string('campaign_name');
  7. $table->float('campaign_goal',8,2);
  8. $table->string('discription',400);
  9. $table->string('image');
  10. $table->string('category');
  11. $table->date('start_date');
  12. $table->date('end_date');
  13. $table->float('total_fund',8,2);
  14. });
  15.  
  16. Schema::create('campaign_product', function (Blueprint $table) {
  17. $table->engine='InnoDB';
  18.  
  19. $table->increments('id');
  20. $table->integer('campaign_id')->unsigned();
  21. $table->foreign('campaign_id')->references('id')->on('campaign')->onDelete('cascade')->onUpdate('cascade');
  22.  
  23. $table->integer('product_id')->unsigned();
  24. $table->foreign('product_id')->references('id')->on('product')->onDelete('cascade')->onUpdate('cascade');
  25. });
Add Comment
Please, Sign In to add comment