Completed
Push — develop ( 8dee05 )
by Dmytro
20:08
created
stubs/migrations/2018_06_29_182342_create_site_tmplvar_access_table.php 1 patch
Indentation   +23 added lines, -23 removed lines patch added patch discarded remove patch
@@ -5,30 +5,30 @@
 block discarded – undo
5 5
 
6 6
 class CreateSiteTmplvarAccessTable extends Migration {
7 7
 
8
-	/**
9
-	 * Run the migrations.
10
-	 *
11
-	 * @return void
12
-	 */
13
-	public function up()
14
-	{
15
-		Schema::create('site_tmplvar_access', function(Blueprint $table)
16
-		{
17
-			$table->integer('id', true);
18
-			$table->integer('tmplvarid')->default(0);
19
-			$table->integer('documentgroup')->default(0);
20
-		});
21
-	}
8
+    /**
9
+     * Run the migrations.
10
+     *
11
+     * @return void
12
+     */
13
+    public function up()
14
+    {
15
+        Schema::create('site_tmplvar_access', function(Blueprint $table)
16
+        {
17
+            $table->integer('id', true);
18
+            $table->integer('tmplvarid')->default(0);
19
+            $table->integer('documentgroup')->default(0);
20
+        });
21
+    }
22 22
 
23 23
 
24
-	/**
25
-	 * Reverse the migrations.
26
-	 *
27
-	 * @return void
28
-	 */
29
-	public function down()
30
-	{
31
-		Schema::drop('site_tmplvar_access');
32
-	}
24
+    /**
25
+     * Reverse the migrations.
26
+     *
27
+     * @return void
28
+     */
29
+    public function down()
30
+    {
31
+        Schema::drop('site_tmplvar_access');
32
+    }
33 33
 
34 34
 }
Please login to merge, or discard this patch.
stubs/migrations/2018_06_29_182342_create_site_htmlsnippets_table.php 1 patch
Indentation   +32 added lines, -32 removed lines patch added patch discarded remove patch
@@ -5,39 +5,39 @@
 block discarded – undo
5 5
 
6 6
 class CreateSiteHtmlsnippetsTable extends Migration {
7 7
 
8
-	/**
9
-	 * Run the migrations.
10
-	 *
11
-	 * @return void
12
-	 */
13
-	public function up()
14
-	{
15
-		Schema::create('site_htmlsnippets', function(Blueprint $table)
16
-		{
17
-			$table->integer('id', true);
18
-			$table->string('name', 100)->default('');
19
-			$table->string('description')->default('Chunk');
20
-			$table->integer('editor_type')->default(0)->comment('0-plain text,1-rich text,2-code editor');
21
-			$table->string('editor_name', 50)->default('none');
22
-			$table->integer('category')->default(0)->comment('category id');
23
-			$table->boolean('cache_type')->default(0)->comment('Cache option');
24
-			$table->text('snippet', 16777215)->nullable();
25
-			$table->boolean('locked')->default(0);
26
-			$table->integer('createdon')->default(0);
27
-			$table->integer('editedon')->default(0);
28
-			$table->boolean('disabled')->default(0)->comment('Disables the snippet');
29
-		});
30
-	}
8
+    /**
9
+     * Run the migrations.
10
+     *
11
+     * @return void
12
+     */
13
+    public function up()
14
+    {
15
+        Schema::create('site_htmlsnippets', function(Blueprint $table)
16
+        {
17
+            $table->integer('id', true);
18
+            $table->string('name', 100)->default('');
19
+            $table->string('description')->default('Chunk');
20
+            $table->integer('editor_type')->default(0)->comment('0-plain text,1-rich text,2-code editor');
21
+            $table->string('editor_name', 50)->default('none');
22
+            $table->integer('category')->default(0)->comment('category id');
23
+            $table->boolean('cache_type')->default(0)->comment('Cache option');
24
+            $table->text('snippet', 16777215)->nullable();
25
+            $table->boolean('locked')->default(0);
26
+            $table->integer('createdon')->default(0);
27
+            $table->integer('editedon')->default(0);
28
+            $table->boolean('disabled')->default(0)->comment('Disables the snippet');
29
+        });
30
+    }
31 31
 
32 32
 
33
-	/**
34
-	 * Reverse the migrations.
35
-	 *
36
-	 * @return void
37
-	 */
38
-	public function down()
39
-	{
40
-		Schema::drop('site_htmlsnippets');
41
-	}
33
+    /**
34
+     * Reverse the migrations.
35
+     *
36
+     * @return void
37
+     */
38
+    public function down()
39
+    {
40
+        Schema::drop('site_htmlsnippets');
41
+    }
42 42
 
43 43
 }
Please login to merge, or discard this patch.
install/stubs/migrations/2018_06_29_182342_create_site_modules_table.php 1 patch
Indentation   +37 added lines, -37 removed lines patch added patch discarded remove patch
@@ -5,44 +5,44 @@
 block discarded – undo
5 5
 
6 6
 class CreateSiteModulesTable extends Migration {
7 7
 
8
-	/**
9
-	 * Run the migrations.
10
-	 *
11
-	 * @return void
12
-	 */
13
-	public function up()
14
-	{
15
-		Schema::create('site_modules', function(Blueprint $table)
16
-		{
17
-			$table->integer('id', true);
18
-			$table->string('name', 50)->default('');
19
-			$table->string('description')->default('0');
20
-			$table->integer('editor_type')->default(0)->comment('0-plain text,1-rich text,2-code editor');
21
-			$table->boolean('disabled')->default(0);
22
-			$table->integer('category')->default(0)->comment('category id');
23
-			$table->boolean('wrap')->default(0);
24
-			$table->boolean('locked')->default(0);
25
-			$table->string('icon')->default('')->comment('url to module icon');
26
-			$table->boolean('enable_resource')->default(0)->comment('enables the resource file feature');
27
-			$table->string('resourcefile')->default('')->comment('a physical link to a resource file');
28
-			$table->integer('createdon')->default(0);
29
-			$table->integer('editedon')->default(0);
30
-			$table->string('guid', 32)->default('')->comment('globally unique identifier');
31
-			$table->boolean('enable_sharedparams')->default(0);
32
-			$table->text('properties', 65535)->nullable();
33
-			$table->text('modulecode', 16777215)->nullable()->comment('module boot up code');
34
-		});
35
-	}
8
+    /**
9
+     * Run the migrations.
10
+     *
11
+     * @return void
12
+     */
13
+    public function up()
14
+    {
15
+        Schema::create('site_modules', function(Blueprint $table)
16
+        {
17
+            $table->integer('id', true);
18
+            $table->string('name', 50)->default('');
19
+            $table->string('description')->default('0');
20
+            $table->integer('editor_type')->default(0)->comment('0-plain text,1-rich text,2-code editor');
21
+            $table->boolean('disabled')->default(0);
22
+            $table->integer('category')->default(0)->comment('category id');
23
+            $table->boolean('wrap')->default(0);
24
+            $table->boolean('locked')->default(0);
25
+            $table->string('icon')->default('')->comment('url to module icon');
26
+            $table->boolean('enable_resource')->default(0)->comment('enables the resource file feature');
27
+            $table->string('resourcefile')->default('')->comment('a physical link to a resource file');
28
+            $table->integer('createdon')->default(0);
29
+            $table->integer('editedon')->default(0);
30
+            $table->string('guid', 32)->default('')->comment('globally unique identifier');
31
+            $table->boolean('enable_sharedparams')->default(0);
32
+            $table->text('properties', 65535)->nullable();
33
+            $table->text('modulecode', 16777215)->nullable()->comment('module boot up code');
34
+        });
35
+    }
36 36
 
37 37
 
38
-	/**
39
-	 * Reverse the migrations.
40
-	 *
41
-	 * @return void
42
-	 */
43
-	public function down()
44
-	{
45
-		Schema::drop('site_modules');
46
-	}
38
+    /**
39
+     * Reverse the migrations.
40
+     *
41
+     * @return void
42
+     */
43
+    public function down()
44
+    {
45
+        Schema::drop('site_modules');
46
+    }
47 47
 
48 48
 }
Please login to merge, or discard this patch.
install/stubs/migrations/2018_06_29_182342_create_web_users_table.php 1 patch
Indentation   +24 added lines, -24 removed lines patch added patch discarded remove patch
@@ -5,31 +5,31 @@
 block discarded – undo
5 5
 
6 6
 class CreateWebUsersTable extends Migration {
7 7
 
8
-	/**
9
-	 * Run the migrations.
10
-	 *
11
-	 * @return void
12
-	 */
13
-	public function up()
14
-	{
15
-		Schema::create('web_users', function(Blueprint $table)
16
-		{
17
-			$table->integer('id', true);
18
-			$table->string('username', 100)->default('')->unique('username');
19
-			$table->string('password', 100)->default('');
20
-			$table->string('cachepwd', 100)->default('')->comment('Store new unconfirmed password');
21
-		});
22
-	}
8
+    /**
9
+     * Run the migrations.
10
+     *
11
+     * @return void
12
+     */
13
+    public function up()
14
+    {
15
+        Schema::create('web_users', function(Blueprint $table)
16
+        {
17
+            $table->integer('id', true);
18
+            $table->string('username', 100)->default('')->unique('username');
19
+            $table->string('password', 100)->default('');
20
+            $table->string('cachepwd', 100)->default('')->comment('Store new unconfirmed password');
21
+        });
22
+    }
23 23
 
24 24
 
25
-	/**
26
-	 * Reverse the migrations.
27
-	 *
28
-	 * @return void
29
-	 */
30
-	public function down()
31
-	{
32
-		Schema::drop('web_users');
33
-	}
25
+    /**
26
+     * Reverse the migrations.
27
+     *
28
+     * @return void
29
+     */
30
+    public function down()
31
+    {
32
+        Schema::drop('web_users');
33
+    }
34 34
 
35 35
 }
Please login to merge, or discard this patch.
install/stubs/migrations/2018_06_29_182342_create_user_attributes_table.php 1 patch
Indentation   +47 added lines, -47 removed lines patch added patch discarded remove patch
@@ -5,54 +5,54 @@
 block discarded – undo
5 5
 
6 6
 class CreateUserAttributesTable extends Migration {
7 7
 
8
-	/**
9
-	 * Run the migrations.
10
-	 *
11
-	 * @return void
12
-	 */
13
-	public function up()
14
-	{
15
-		Schema::create('user_attributes', function(Blueprint $table)
16
-		{
17
-			$table->integer('id', true);
18
-			$table->integer('internalKey')->default(0)->index('userid');
19
-			$table->string('fullname', 100)->default('');
20
-			$table->integer('role')->default(0);
21
-			$table->string('email', 100)->default('');
22
-			$table->string('phone', 100)->default('');
23
-			$table->string('mobilephone', 100)->default('');
24
-			$table->integer('blocked')->default(0);
25
-			$table->integer('blockeduntil')->default(0);
26
-			$table->integer('blockedafter')->default(0);
27
-			$table->integer('logincount')->default(0);
28
-			$table->integer('lastlogin')->default(0);
29
-			$table->integer('thislogin')->default(0);
30
-			$table->integer('failedlogincount')->default(0);
31
-			$table->string('sessionid', 100)->default('');
32
-			$table->integer('dob')->default(0);
33
-			$table->integer('gender')->default(0)->comment('0 - unknown, 1 - Male 2 - female');
34
-			$table->string('country', 5)->default('');
35
-			$table->string('street')->default('');
36
-			$table->string('city')->default('');
37
-			$table->string('state', 25)->default('');
38
-			$table->string('zip', 25)->default('');
39
-			$table->string('fax', 100)->default('');
40
-			$table->string('photo')->default('')->comment('link to photo');
41
-			$table->text('comment', 65535)->nullable();
42
-			$table->integer('createdon')->default(0);
43
-			$table->integer('editedon')->default(0);
44
-		});
45
-	}
8
+    /**
9
+     * Run the migrations.
10
+     *
11
+     * @return void
12
+     */
13
+    public function up()
14
+    {
15
+        Schema::create('user_attributes', function(Blueprint $table)
16
+        {
17
+            $table->integer('id', true);
18
+            $table->integer('internalKey')->default(0)->index('userid');
19
+            $table->string('fullname', 100)->default('');
20
+            $table->integer('role')->default(0);
21
+            $table->string('email', 100)->default('');
22
+            $table->string('phone', 100)->default('');
23
+            $table->string('mobilephone', 100)->default('');
24
+            $table->integer('blocked')->default(0);
25
+            $table->integer('blockeduntil')->default(0);
26
+            $table->integer('blockedafter')->default(0);
27
+            $table->integer('logincount')->default(0);
28
+            $table->integer('lastlogin')->default(0);
29
+            $table->integer('thislogin')->default(0);
30
+            $table->integer('failedlogincount')->default(0);
31
+            $table->string('sessionid', 100)->default('');
32
+            $table->integer('dob')->default(0);
33
+            $table->integer('gender')->default(0)->comment('0 - unknown, 1 - Male 2 - female');
34
+            $table->string('country', 5)->default('');
35
+            $table->string('street')->default('');
36
+            $table->string('city')->default('');
37
+            $table->string('state', 25)->default('');
38
+            $table->string('zip', 25)->default('');
39
+            $table->string('fax', 100)->default('');
40
+            $table->string('photo')->default('')->comment('link to photo');
41
+            $table->text('comment', 65535)->nullable();
42
+            $table->integer('createdon')->default(0);
43
+            $table->integer('editedon')->default(0);
44
+        });
45
+    }
46 46
 
47 47
 
48
-	/**
49
-	 * Reverse the migrations.
50
-	 *
51
-	 * @return void
52
-	 */
53
-	public function down()
54
-	{
55
-		Schema::drop('user_attributes');
56
-	}
48
+    /**
49
+     * Reverse the migrations.
50
+     *
51
+     * @return void
52
+     */
53
+    public function down()
54
+    {
55
+        Schema::drop('user_attributes');
56
+    }
57 57
 
58 58
 }
Please login to merge, or discard this patch.
install/stubs/migrations/2018_06_29_182342_create_site_tmplvars_table.php 1 patch
Indentation   +35 added lines, -35 removed lines patch added patch discarded remove patch
@@ -5,42 +5,42 @@
 block discarded – undo
5 5
 
6 6
 class CreateSiteTmplvarsTable extends Migration {
7 7
 
8
-	/**
9
-	 * Run the migrations.
10
-	 *
11
-	 * @return void
12
-	 */
13
-	public function up()
14
-	{
15
-		Schema::create('site_tmplvars', function(Blueprint $table)
16
-		{
17
-			$table->integer('id', true);
18
-			$table->string('type', 50)->default('');
19
-			$table->string('name', 50)->default('');
20
-			$table->string('caption', 80)->default('');
21
-			$table->string('description')->default('');
22
-			$table->integer('editor_type')->default(0)->comment('0-plain text,1-rich text,2-code editor');
23
-			$table->integer('category')->default(0)->comment('category id');
24
-			$table->boolean('locked')->default(0);
25
-			$table->text('elements', 65535)->nullable();
26
-			$table->integer('rank')->default(0)->index('indx_rank');
27
-			$table->string('display', 20)->default('')->comment('Display Control');
28
-			$table->text('display_params', 65535)->nullable()->comment('Display Control Properties');
29
-			$table->text('default_text', 65535)->nullable();
30
-			$table->integer('createdon')->default(0);
31
-			$table->integer('editedon')->default(0);
32
-		});
33
-	}
8
+    /**
9
+     * Run the migrations.
10
+     *
11
+     * @return void
12
+     */
13
+    public function up()
14
+    {
15
+        Schema::create('site_tmplvars', function(Blueprint $table)
16
+        {
17
+            $table->integer('id', true);
18
+            $table->string('type', 50)->default('');
19
+            $table->string('name', 50)->default('');
20
+            $table->string('caption', 80)->default('');
21
+            $table->string('description')->default('');
22
+            $table->integer('editor_type')->default(0)->comment('0-plain text,1-rich text,2-code editor');
23
+            $table->integer('category')->default(0)->comment('category id');
24
+            $table->boolean('locked')->default(0);
25
+            $table->text('elements', 65535)->nullable();
26
+            $table->integer('rank')->default(0)->index('indx_rank');
27
+            $table->string('display', 20)->default('')->comment('Display Control');
28
+            $table->text('display_params', 65535)->nullable()->comment('Display Control Properties');
29
+            $table->text('default_text', 65535)->nullable();
30
+            $table->integer('createdon')->default(0);
31
+            $table->integer('editedon')->default(0);
32
+        });
33
+    }
34 34
 
35 35
 
36
-	/**
37
-	 * Reverse the migrations.
38
-	 *
39
-	 * @return void
40
-	 */
41
-	public function down()
42
-	{
43
-		Schema::drop('site_tmplvars');
44
-	}
36
+    /**
37
+     * Reverse the migrations.
38
+     *
39
+     * @return void
40
+     */
41
+    public function down()
42
+    {
43
+        Schema::drop('site_tmplvars');
44
+    }
45 45
 
46 46
 }
Please login to merge, or discard this patch.
migrations/2018_06_29_182342_create_site_tmplvar_contentvalues_table.php 1 patch
Indentation   +25 added lines, -25 removed lines patch added patch discarded remove patch
@@ -5,32 +5,32 @@
 block discarded – undo
5 5
 
6 6
 class CreateSiteTmplvarContentvaluesTable extends Migration {
7 7
 
8
-	/**
9
-	 * Run the migrations.
10
-	 *
11
-	 * @return void
12
-	 */
13
-	public function up()
14
-	{
15
-		Schema::create('site_tmplvar_contentvalues', function(Blueprint $table)
16
-		{
17
-			$table->integer('id', true);
18
-			$table->integer('tmplvarid')->default(0)->index('idx_tmplvarid')->comment('Template Variable id');
19
-			$table->integer('contentid')->default(0)->index('idx_id')->comment('Site Content Id');
20
-			$table->text('value', 16777215)->nullable()->index('value_ft_idx');
21
-			$table->unique(['tmplvarid','contentid'], 'ix_tvid_contentid');
22
-		});
23
-	}
8
+    /**
9
+     * Run the migrations.
10
+     *
11
+     * @return void
12
+     */
13
+    public function up()
14
+    {
15
+        Schema::create('site_tmplvar_contentvalues', function(Blueprint $table)
16
+        {
17
+            $table->integer('id', true);
18
+            $table->integer('tmplvarid')->default(0)->index('idx_tmplvarid')->comment('Template Variable id');
19
+            $table->integer('contentid')->default(0)->index('idx_id')->comment('Site Content Id');
20
+            $table->text('value', 16777215)->nullable()->index('value_ft_idx');
21
+            $table->unique(['tmplvarid','contentid'], 'ix_tvid_contentid');
22
+        });
23
+    }
24 24
 
25 25
 
26
-	/**
27
-	 * Reverse the migrations.
28
-	 *
29
-	 * @return void
30
-	 */
31
-	public function down()
32
-	{
33
-		Schema::drop('site_tmplvar_contentvalues');
34
-	}
26
+    /**
27
+     * Reverse the migrations.
28
+     *
29
+     * @return void
30
+     */
31
+    public function down()
32
+    {
33
+        Schema::drop('site_tmplvar_contentvalues');
34
+    }
35 35
 
36 36
 }
Please login to merge, or discard this patch.
stubs/migrations/2018_06_29_182342_create_documentgroup_names_table.php 1 patch
Indentation   +24 added lines, -24 removed lines patch added patch discarded remove patch
@@ -5,31 +5,31 @@
 block discarded – undo
5 5
 
6 6
 class CreateDocumentgroupNamesTable extends Migration {
7 7
 
8
-	/**
9
-	 * Run the migrations.
10
-	 *
11
-	 * @return void
12
-	 */
13
-	public function up()
14
-	{
15
-		Schema::create('documentgroup_names', function(Blueprint $table)
16
-		{
17
-			$table->integer('id', true);
18
-			$table->string('name', 245)->default('')->unique('name');
19
-			$table->boolean('private_memgroup')->nullable()->default(0)->comment('determine whether the document group is private to manager users');
20
-			$table->boolean('private_webgroup')->nullable()->default(0)->comment('determines whether the document is private to web users');
21
-		});
22
-	}
8
+    /**
9
+     * Run the migrations.
10
+     *
11
+     * @return void
12
+     */
13
+    public function up()
14
+    {
15
+        Schema::create('documentgroup_names', function(Blueprint $table)
16
+        {
17
+            $table->integer('id', true);
18
+            $table->string('name', 245)->default('')->unique('name');
19
+            $table->boolean('private_memgroup')->nullable()->default(0)->comment('determine whether the document group is private to manager users');
20
+            $table->boolean('private_webgroup')->nullable()->default(0)->comment('determines whether the document is private to web users');
21
+        });
22
+    }
23 23
 
24 24
 
25
-	/**
26
-	 * Reverse the migrations.
27
-	 *
28
-	 * @return void
29
-	 */
30
-	public function down()
31
-	{
32
-		Schema::drop('documentgroup_names');
33
-	}
25
+    /**
26
+     * Reverse the migrations.
27
+     *
28
+     * @return void
29
+     */
30
+    public function down()
31
+    {
32
+        Schema::drop('documentgroup_names');
33
+    }
34 34
 
35 35
 }
Please login to merge, or discard this patch.
install/stubs/migrations/2018_06_29_182342_create_site_plugins_table.php 1 patch
Indentation   +33 added lines, -33 removed lines patch added patch discarded remove patch
@@ -5,40 +5,40 @@
 block discarded – undo
5 5
 
6 6
 class CreateSitePluginsTable extends Migration {
7 7
 
8
-	/**
9
-	 * Run the migrations.
10
-	 *
11
-	 * @return void
12
-	 */
13
-	public function up()
14
-	{
15
-		Schema::create('site_plugins', function(Blueprint $table)
16
-		{
17
-			$table->integer('id', true);
18
-			$table->string('name', 50)->default('');
19
-			$table->string('description')->default('Plugin');
20
-			$table->integer('editor_type')->default(0)->comment('0-plain text,1-rich text,2-code editor');
21
-			$table->integer('category')->default(0)->comment('category id');
22
-			$table->boolean('cache_type')->default(0)->comment('Cache option');
23
-			$table->text('plugincode', 16777215)->nullable();
24
-			$table->boolean('locked')->default(0);
25
-			$table->text('properties', 65535)->nullable()->comment('Default Properties');
26
-			$table->boolean('disabled')->default(0)->comment('Disables the plugin');
27
-			$table->string('moduleguid', 32)->default('')->comment('GUID of module from which to import shared parameters');
28
-			$table->integer('createdon')->default(0);
29
-			$table->integer('editedon')->default(0);
30
-		});
31
-	}
8
+    /**
9
+     * Run the migrations.
10
+     *
11
+     * @return void
12
+     */
13
+    public function up()
14
+    {
15
+        Schema::create('site_plugins', function(Blueprint $table)
16
+        {
17
+            $table->integer('id', true);
18
+            $table->string('name', 50)->default('');
19
+            $table->string('description')->default('Plugin');
20
+            $table->integer('editor_type')->default(0)->comment('0-plain text,1-rich text,2-code editor');
21
+            $table->integer('category')->default(0)->comment('category id');
22
+            $table->boolean('cache_type')->default(0)->comment('Cache option');
23
+            $table->text('plugincode', 16777215)->nullable();
24
+            $table->boolean('locked')->default(0);
25
+            $table->text('properties', 65535)->nullable()->comment('Default Properties');
26
+            $table->boolean('disabled')->default(0)->comment('Disables the plugin');
27
+            $table->string('moduleguid', 32)->default('')->comment('GUID of module from which to import shared parameters');
28
+            $table->integer('createdon')->default(0);
29
+            $table->integer('editedon')->default(0);
30
+        });
31
+    }
32 32
 
33 33
 
34
-	/**
35
-	 * Reverse the migrations.
36
-	 *
37
-	 * @return void
38
-	 */
39
-	public function down()
40
-	{
41
-		Schema::drop('site_plugins');
42
-	}
34
+    /**
35
+     * Reverse the migrations.
36
+     *
37
+     * @return void
38
+     */
39
+    public function down()
40
+    {
41
+        Schema::drop('site_plugins');
42
+    }
43 43
 
44 44
 }
Please login to merge, or discard this patch.