My code is below.
Schema::create('tblsubcategory', function (Blueprint $table) {
    $table->increments('SubCategoryID');
    $table->integer('CategoryID');
    $table->string('SubCategory', 40);
    $table->timestamps();
});
In the above schema, CategoryID and SubCategory combination should be unique.
So far, I found about setting unique only single column. Can you suggest to do the same for multiple columns ?
My query is below.
ALTER TABLE tblsubcategory 
ADD CONSTRAINT UK_tblsubcategory_SubCategory_categoryID 
UNIQUE KEY (SubCategory, categoryID)
via Chebli Mohamed
 
Aucun commentaire:
Enregistrer un commentaire