1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36<?php
/*
CREATE TABLE `directus_bookmarks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user` int(11) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`section` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
*/
use Ruckusing\Migration\Base as Ruckusing_Migration_Base;
class CreateDirectusBookmarksTable extends Ruckusing_Migration_Base
{
public function up()
{
$t = $this->create_table('directus_bookmarks');
//columns
$t->column('user', 'integer', ['unsigned' => true, 'default' => NULL]);
$t->column('title', 'string', ['limit' => 255, 'default' => NULL]);
$t->column('url', 'string', ['limit' => 255, 'default' => NULL]);
$t->column('section', 'string', ['limit' => 255, 'default' => NULL]);
$t->finish();
}//up()
public function down()
{
$this->drop_table('directus_bookmarks');
}//down()
}