Lines Matching refs:table
52 $data = DB::table('module_privacy')->get();
56 DB::schema()->create('module_privacy', static function (Blueprint $table): void {
57 $table->increments('id');
58 $table->string('module_name', 32);
59 $table->integer('gedcom_id');
60 $table->string('interface');
61 $table->tinyInteger('access_level');
64 $key1 = DB::prefix($table->getTable() . '_ix1');
65 $key2 = DB::prefix($table->getTable() . '_ix2');
67 $table->unique(['gedcom_id', 'module_name', 'interface'], $key1);
68 $table->unique(['module_name', 'gedcom_id', 'interface'], $key2);
70 … $table->foreign('module_name')->references('module_name')->on('module')->onDelete('cascade');
71 … $table->foreign('gedcom_id')->references('gedcom_id')->on('gedcom')->onDelete('cascade');
75 DB::table('module_privacy')->insert([