<commit_before><?php

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

class CreateProductsTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('products', function(Blueprint $table)
		{
			$table->increments('id');			// Autoincrement : ID
			$table->string('name', 75);			// VARCHAR(75)	 : Product name
			$table->integer('number')->unique(); 		// INTEGER 	 : Product number -> must be unique
			$table->integer('group');			// INTEGER	 : Product group
			$table->string('altNumber', 16);		// VARCHAR(16)	 : Alternative product number
			$table->string('stockCode', 3);			// VARCHAR(3)	 : Stock code for the product
			$table->string('registered_per', 5); 		// VARCHAR(5)	 : Product registered per. Example: piece, meter
			$table->string('packed_per', 5);		// VARCHAR(5)	 : Product sold per. Example: box, spool
			$table->string('price_per', 5);			// VARCHAR(5)	 : Price per piece/box/bag
			$table->string('refactor', 6);			// VARCHAR(6)	 : Price refactoring (example: product price is per meter but it's sold per piece)
			$table->string('supplier', 13)->nullable();	// VARCHAR(13)	 : Supplier of the product -> optional
			$table->string('ean', 16);			// VARCHAR(16)	 : EAN Code
			$table->string('image', 34);			// VARCHAR(34)	 : Name for the image file
			$table->string('length', 9)->nullable();	// VARCHAR(9)	 : Length of the product -> optional
			$table->decimal('price', 10, 2);		// DECIMAL(10,2) : Price
			$table->string('brand', 25);			// VARCHAR(25)	 : Brand
			$table->string('series', 25);			// VARCHAR(25)	 : Series
			$table->string('type', 25);			// VARCHAR(25)	 : Type
			$table->decimal('special_price', 10, 2);	// DECIMAL(10,2) : Static price, ignores discounts
			$table->string('action_type', 10);		// VARCHAR(10)	 : Type of action. Example: Temporary discount or clearing
			$table->string('keywords', 40);			// VARCHAR(40)	 : Extra search keywords
			$table->timestamps();
		});
	}

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

}
<commit_msg>Added VAT column to product table migration<commit_after><?php

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

class CreateProductsTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('products', function(Blueprint $table)
		{
			$table->increments('id');			// Autoincrement : ID
			$table->string('name', 75);			// VARCHAR(75)	 : Product name
			$table->integer('number')->unique(); 		// INTEGER 	 : Product number -> must be unique
			$table->integer('group');			// INTEGER	 : Product group
			$table->string('altNumber', 16);		// VARCHAR(16)	 : Alternative product number
			$table->string('stockCode', 3);			// VARCHAR(3)	 : Stock code for the product
			$table->string('registered_per', 5); 		// VARCHAR(5)	 : Product registered per. Example: piece, meter
			$table->string('packed_per', 5);		// VARCHAR(5)	 : Product sold per. Example: box, spool
			$table->string('price_per', 5);			// VARCHAR(5)	 : Price per piece/box/bag
			$table->string('refactor', 6);			// VARCHAR(6)	 : Price refactoring (example: product price is per meter but it's sold per piece)
			$table->string('supplier', 13)->nullable();	// VARCHAR(13)	 : Supplier of the product -> optional
			$table->string('ean', 16);			// VARCHAR(16)	 : EAN Code
			$table->string('image', 34);			// VARCHAR(34)	 : Name for the image file
			$table->string('length', 9)->nullable();	// VARCHAR(9)	 : Length of the product -> optional
			$table->decimal('price', 10, 2);		// DECIMAL(10,2) : Price
			$table->decimal('vat', 10, 5);			// DECIMAL(10,5) : VAT
			$table->string('brand', 25);			// VARCHAR(25)	 : Brand
			$table->string('series', 25);			// VARCHAR(25)	 : Series
			$table->string('type', 25);			// VARCHAR(25)	 : Type
			$table->decimal('special_price', 10, 2);	// DECIMAL(10,2) : Static price, ignores discounts
			$table->string('action_type', 10);		// VARCHAR(10)	 : Type of action. Example: Temporary discount or clearing
			$table->string('keywords', 40);			// VARCHAR(40)	 : Extra search keywords
			$table->timestamps();
		});
	}

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

}

{'fraction_non_alphanumeric': 0.18148737775756196, 'fraction_numerical': 0.03047532408460314, 'mean_word_length': 3.496932515337423, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 60, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '829274', 'n_tokens_mistral': 1723, 'n_tokens_neox': 1429, 'n_words': 359}