Lines Matching refs:table
41 DB::schema()->create('media_file', static function (Blueprint $table): void {
42 $table->integer('id', true);
43 $table->string('m_id', 20);
44 $table->integer('m_file');
45 $table->string('multimedia_file_refn', 248); // GEDCOM only allows 30 characters
46 $table->string('multimedia_format', 4);
47 $table->string('source_media_type', 15);
48 $table->string('descriptive_title', 248);
50 $table->index(['m_id', 'm_file']);
51 $table->index(['m_file', 'm_id']);
52 $table->index(['m_file', 'multimedia_file_refn']);
53 $table->index(['m_file', 'multimedia_format']);
54 $table->index(['m_file', 'source_media_type']);
55 $table->index(['m_file', 'descriptive_title']);
59 … if (DB::table('media_file')->count() === 0 && DB::schema()->hasColumn('media', 'm_filename')) {
82 DB::schema()->table('media', static function (Blueprint $table): void {
83 $table->dropColumn('m_filename');
85 DB::schema()->table('media', static function (Blueprint $table): void {
86 $table->dropColumn('m_ext');
88 DB::schema()->table('media', static function (Blueprint $table): void {
89 $table->dropColumn('m_type');
91 DB::schema()->table('media', static function (Blueprint $table): void {
92 $table->dropColumn('m_titl');