1 | <?php |
||||
2 | |||||
3 | use Ffcms\Core\Migrations\MigrationInterface; |
||||
4 | use Ffcms\Core\Migrations\Migration; |
||||
5 | |||||
6 | /** |
||||
7 | * Class update_cms_310 |
||||
8 | */ |
||||
9 | class update_cms_310 extends Migration implements MigrationInterface |
||||
10 | { |
||||
11 | const UPDATE_EXTENSIONS = ['User', 'Profile', 'Content', 'Feedback', 'Search', 'Sitemap', 'Comments', 'Newcontent', 'Contenttag', 'Newcomment']; |
||||
12 | |||||
13 | /** |
||||
14 | * Implement new update changes |
||||
15 | * @return void |
||||
16 | */ |
||||
17 | public function up() |
||||
18 | { |
||||
19 | // set nullable varchar type for token column |
||||
20 | $this->getSchema()->table('users', function($table){ |
||||
21 | $table->string('approve_token', 128)->nullable()->default(null)->change(); |
||||
22 | }); |
||||
23 | // set approve_token = null where it like '0' str or '' |
||||
24 | \Apps\ActiveRecord\User::where('approve_token', '=', '0') |
||||
25 | ->update('approve_token', null); |
||||
0 ignored issues
–
show
Bug
introduced
by
Loading history...
null of type null is incompatible with the type array expected by parameter $options of Illuminate\Database\Eloquent\Model::update() .
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
Loading history...
|
|||||
26 | |||||
27 | // update comment posts architecture: add app_name and app_id relationship |
||||
28 | if (!$this->getSchema()->hasColumn('comment_posts', 'app_name')) { |
||||
29 | $this->getSchema()->table('comment_posts', function($table) { |
||||
30 | $table->string('app_name')->after('id'); |
||||
31 | }); |
||||
32 | } |
||||
33 | if (!$this->getSchema()->hasColumn('comment_answers', 'app_relation_id')) { |
||||
34 | $this->getSchema()->table('comment_answers', function ($table){ |
||||
35 | $table->integer('app_relation_id')->unsigned()->default(0)->after('app_name'); |
||||
36 | }); |
||||
37 | } |
||||
38 | |||||
39 | \Apps\ActiveRecord\App::whereIn('sys_name', static::UPDATE_EXTENSIONS) |
||||
40 | ->update(['version' => '1.0.1']); |
||||
41 | |||||
42 | // @todo: add algo to find app_name & app_id for oldest comments |
||||
43 | if ($this->getSchema()->hasColumn('comment_posts', 'pathway')) { |
||||
44 | $this->getSchema()->table('comment_posts', function ($table){ |
||||
45 | $table->dropColumn('pathway'); |
||||
46 | }); |
||||
47 | } |
||||
48 | // remove comment_hash column from content |
||||
49 | if ($this->getSchema()->hasColumn('contents', 'comment_hash')) { |
||||
50 | $this->getSchema()->table('contents', function ($table){ |
||||
51 | $table->dropColumn('comment_hash'); |
||||
52 | }); |
||||
53 | } |
||||
54 | } |
||||
55 | |||||
56 | /** |
||||
57 | * @return void |
||||
58 | */ |
||||
59 | public function down() |
||||
60 | { |
||||
61 | parent::down(); // TODO: Change the autogenerated stub |
||||
62 | } |
||||
63 | |||||
64 | /** |
||||
65 | * Seed created table via up() method with some data |
||||
66 | * @return void |
||||
67 | */ |
||||
68 | public function seed() |
||||
69 | { |
||||
70 | // TODO: Implement seed() method. |
||||
71 | } |
||||
72 | } |