Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Capsule\Manager as Capsule;

class BusinessUnit extends Migration
{
    private $tableName = 'business_unit';
    private $tableNameV2 = 'business_unit_orig';

    public function up()
    {
        $capsule = new Capsule();
        $migrateData = false;

        if ($capsule::schema()->hasTable($this->tableNameV2)) {
            // Migration already failed before, but didnt finish
            throw new Exception("previous failed migration exists");
        }

        if ($capsule::schema()->hasTable($this->tableName)) {
            $capsule::schema()->rename($this->tableName, $this->tableNameV2);
            $migrateData = true;
        }

        $capsule::schema()->create($this->tableName, function (Blueprint $table) {
            $table->increments('id');
            $table->integer('unitid');
            $table->string('property');
            $table->string('value');
        });

        if ($migrateData) {
            $capsule::unprepared("INSERT INTO 
                $this->tableName
            SELECT
                id,
                unitid,
                property,
                value
            FROM
                $this->tableNameV2");
            $capsule::schema()->drop($this->tableNameV2);
        }

        // (Re)create indexes
        $capsule::schema()->table($this->tableName, function (Blueprint $table) {
            $table->index('property');
            $table->index('value');
        });
    }

    public function down()
    {
        $capsule = new Capsule();
        $capsule::schema()->dropIfExists($this->tableName);
        if ($capsule::schema()->hasTable($this->tableNameV2)) {
            $capsule::schema()->rename($this->tableNameV2, $this->tableName);
        }
    }
}
Cilantro Lime Dressing
READY IN: 30mins
Recipe by Lavender Lynn
Delicious for a quick summery dinner. Grilled boneless chicken breasts served over a hearty green salad, and this dressing, voila!"
Top Review by queenbeatrice
What a great tasting dressing this is, and so easy to put together. This will be seeing to many repeats here.
Ingredients Nutrition
- 1 jalapeno pepper, seeded and coarsely chopped
- 1 garlic clove
- 3⁄4 teaspoon gingerroot, minced fresh
- 1⁄4 cup lime juice
- 1⁄3 cup honey
- 2 teaspoons balsamic vinegar
- 1⁄2 teaspoon salt, to taste
- 1⁄4 cup cilantro leaf, packed
- 1⁄2 cup extra-virgin olive oil
Directions See How It's Made
-.
-
Cilantro Lime DressingVancouver time 6:30pm on September 1, 2022, and Beijing time 9:30am on September 2, 2022, “Canada-China Symposium on Hotspots in International Arbitration — The Enforcement of Arbitration Agreements and the Impact of Sanctions on International Arbitration”, sponsored by Vancouver Maritime Arbitrators Association (VMAA) and China International Economic and Trade Arbitration Commission (CIETAC) and co-organized by CIETAC North American Arbitration Center, was held online as scheduled.
The seminar was chaired by Ms. Catherine H. Liang, the Vice President of VMAA. Mr. Wang Chengjie, Vice Chairman of CIETAC, delivered the opening speech. Mr. Wang extended a warm welcome to the participants and expressed his gratitude to VMAA. He mentioned that this seminar focuses on the enforcement of arbitration agreements and the impact of sanctions on international arbitration, which is of practical significance. China and Canada enjoy a time-honored friendship with steady growth in bilateral trade and close exchanges in legal, cultural and other fields. He also pointed out that CIETAC is willing to work with the Canadian legal community to promote international arbitration.
Mr. Peter Swanson, the Founding Partner of Bernard LLP, spoke on the “Enforcement of Agreements to Arbitrate by Canadian Courts: the Curious case of s.46 of the Marine Liability Act”. Mr. Swanson shared how the enforcement of arbitration agreements by Canadian courts has evolved over the past 25 to 30 years, and how Section 46 of the Maritime Liability Act can affect the enforceability of arbitration agreements to some extent. On the whole, however, the spirit of the Model Law has been well implemented in the practice of the Canadian courts.
Dr. Jerry Zhang, Director of Beijing Linli Law Firm, shared the “Recognition and Enforcement of Arbitration Agreements in China”. Through cases analysis, Dr. Zhang discussed the application of law, the selection of institutions and jurisdictions. Using the BNA vs. BNB case analysis, he explores the question of whether Chinese or foreign law is applicable when the parties choose a foreign arbitration institution but the arbitration venue is in Shanghai, China. In the recent Brentwood case, which was arbitrated by the ICC in Guangzhou, China, the court ruled that the decision could be applied for enforcement by reference to the foreign-related arbitration award in China. He pointed out that this would open up new prospects for the market of international arbitration institutions to conduct arbitration in China. Download Dr. Zhang’s Presentation.
Mr. JJ Mclntyre, President of the VMAA, discussed the “Impact of Sanctions on International Arbitration”. In February, the European Union and many other countries announced sanctions against Russian states, Russian entities and individuals for affecting and disrupting global markets. Russian banks were removed from the SWIFT. All of these sanctions inevitably affect the performance of relevant contracts. He described a number of cases of sanctions where parties needed to know whether there was a termination or suspension clause in their contract that could deal with the sanction. When it comes to Force Majeure clauses, Mr. Mclntyre points out that Quebec is a civil law jurisdiction and its Civil Code has Force Majeure clause, while the relative law of the common law would be governed by an exemption of atrocity in cases of Frustration and Non-performance of a contract. For international arbitrators, the need to search for whether the company has been sanctioned is a new challenge.
Mr. David Gu, a partner of Junhe Law Firm, discussed the impact of sanctions on international arbitration from Chinese perspective. He noted that sanctions could lead to disruptions in international trade and the flow of goods. He referred to a number of legal problems arising from the sanctions affecting international trade and delivery by transport companies, as well as international payments and contract fulfilment. As a country of civil law, China has special clauses on Force Majeure and the Principle of Change of Circumstances. The parties concerned should first consider stating them in the contract, and pay attention to the issues of predictability and the application of the Principle of Fairness. Gu also discussed the arbitrators should consider issues related to sanctions that may affect arbitration, including related procedures, and the enforcement of arbitration awards. Chinese courts pay close attention to and prudently handle cases involving sanctions in practice, he added.
The seminar concluded with a closing address by Mr. Mclntyre, President of VMAA. He thanked all the speakers and participants, noting that in a world of increasingly frequent sanctions, it is important for peers in the international arbitration community to maintain communication, which promotes mutual understanding and helps us to make better decisions in the dispute resolution process. The symposium concluded successfully. Participants from different industries who are interested in the new issues of international arbitration expressed their concerns and exchange their observations.
The Vancouver Maritime Arbitrators Association invites you to attend the next Seminar on the “Arbitrator Bias – Differing Approaches Around the World” on April 14th at 12:15 pm PST on Zoom. We are honoured to have Murray L. Smith Q.C., Chartered Arbitrator, as our Guest Speaker. He received his Master of Laws, International Business Law, from the London School of Economics in 1989. He was called to the Bar of British Columbia in 1977 and qualified as a barrister in England and Wales in 1990. Currently practising in Vancouver, British Columbia, his arbitration practice includes domestic and international commercial cases. He has acted as an arbitrator in international commercial arbitrations under AAA (ICDR), ICC, BCICAC and UNCITRAL Rules. This Seminar is available for 1 hour of substantive credit for Ontario and is accredited for 1 hour of CPD credit in British Columbia.
On September 14 (Vancouver time), as part of China Arbitration Week 2021, the China-Canada Arbitration Law Seminar co-hosted by Vancouver Maritime Arbitrators Association (VMAA) and China International Economic and Trade Arbitration Commission (CIETAC), co-sponsored by the CIETAC North America Arbitration Center was held online.
The experienced legal professionals, Ms. Catherine H. Liang, JJ McIntyre, Jerry Zhang, Ms. Shelley Chapelski, Tim Meng, and Peter Swanson from the two jurisdictions, discussed some hot issues about “Choosing Vancouver As the Place of Arbitration”, “Historical context: Canada’s adoption federally and provincially of Model Law and the New York Convention”, “To Be a Model Law Country or