Migrate database.
191491
def migrate(name=None, database=None, directory=None, verbose=None, fake=False):
    """"""
    router = get_router(directory, database, verbose)
    migrations = router.run(name, fake=fake)
    if migrations:
        click.echo('Migrations completed: %s' % ', '.join(migrations))
394212
public function up()
	{
		$table_name = $this->getTableName();
		Schema::create($table_name, function($table)
		{
			$table->increments('id');
		});
		DB::statement('ALTER TABLE  `'.$table_name.'` ADD  `file_object` LONGBLOB NOT NULL');
	}
1165943
public function up()
    {
      //remove anahita from nodes and edges table names
      if (!dbexists('SHOW TABLES LIKE "#__nodes"')) {
          dbexec('RENAME TABLE #__anahita_nodes TO #__nodes');
      }

      if (!dbexists('SHOW TABLES LIKE "#__edges"')) {
          dbexec('RENAME TABLE #__anahita_edges TO #__edges');
      }

        //migrate users usertype
       dbexec('UPDATE `#__users` SET `usertype`=\'registered\' WHERE `usertype` NOT LIKE \'%admin%\' ');
        dbexec('UPDATE `#__users` SET `usertype`=\'administrator\' WHERE `usertype`=\'Administrator\' ');
        dbexec('UPDATE `#__users` SET `usertype`=\'super-administrator\' WHERE `usertype`=\'Super Administrator\' ');
        dbexec('ALTER TABLE `#__users` DROP COLUMN `gid` ');
        dbexec('ALTER TABLE `#__users` DROP COLUMN `sendEmail` ');

       //migrate people usertype
       dbexec('UPDATE `#__nodes` SET `person_usertype`=\'registered\' WHERE `person_usertype` NOT LIKE \'%admin%\' ');
        dbexec('UPDATE `#__nodes` SET `person_usertype`=\'administrator\' WHERE `person_usertype`=\'Administrator\' ');
        dbexec('UPDATE `#__nodes` SET `person_usertype`=\'super-administrator\' WHERE `person_usertype`=\'Super Administrator\' ');

       //migrate session table
       dbexec('ALTER TABLE `#__session` DROP COLUMN `gid` ');

       //drop legacy tables
       dbexec('DROP TABLE #__core_acl_aro');
        dbexec('DROP TABLE #__core_acl_aro_groups');
        dbexec('DROP TABLE #__core_acl_aro_map');
        dbexec('DROP TABLE #__core_acl_aro_sections');
        dbexec('DROP TABLE #__core_acl_groups_aro_map');
        dbexec('DROP TABLE #__groups');

       //legacy component cleanup
       dbexec('DELETE FROM `#__components` WHERE `option` IN (\'com_users\', \'com_user\') ');
        dbexec('UPDATE `#__components` SET `admin_menu_link`=\'option=com_people\', `admin_menu_alt`=\'People\', `admin_menu_img`=\'js/ThemeOffice/component.png\' WHERE `option`=\'com_people\' ');

        dbexec('ALTER TABLE `#__nodes` MODIFY `enabled` tinyint(1) NOT NULL DEFAULT 0');
        dbexec('ALTER TABLE `#__nodes` MODIFY `is_default` tinyint(1) NOT NULL DEFAULT 0');
        dbexec('UPDATE `#__nodes` SET `story_subject_id` = `created_by` WHERE `story_subject_id` = `story_target_id` AND `name` = \'actor_follow\'');
        dbexec('UPDATE `#__nodes` SET `enabled`=1, `access` = \'admins\' WHERE `type` LIKE \'%com:people.domain.entity.person\' AND `enabled` = 0');
    }
478543
public function up()
    {
        $tableOptions = null;
        if ($this->db->driverName === 'mysql') {
            $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB';
        }

        $this->createTable('{{%gr_lang}}', [
            'id' => Schema::TYPE_PK,
            'url' => Schema::TYPE_STRING . '(255) NOT NULL',
            'local' => Schema::TYPE_STRING . '(255) NOT NULL',
            'name' => Schema::TYPE_STRING . '(255) NOT NULL',
            'default' => Schema::TYPE_SMALLINT . ' NOT NULL DEFAULT 0',
            'date_update' => Schema::TYPE_INTEGER . ' NOT NULL',
            'date_create' => Schema::TYPE_INTEGER . ' NOT NULL',
        ], $tableOptions);

        $this->batchInsert('gr_lang', ['url', 'local', 'name', 'default', 'date_update', 'date_create'], [
            ['en', 'en-EN', 'English', 0, time(), time()],
            ['ru', 'ru-RU', 'Русский', 1, time(), time()],
        ]);
    }
473068
public function up()
    {
        $file = dirname($this->getIdentifier()->filepath).'/'.$this->getVersion().'.sql';
        if (file_exists($file)) {
            dbexecfile($file);
        }
    }
682410
public function up()
    {
        Schema::create('objects', function (Blueprint $table) {
            $table->engine = 'InnoDB';
            $table->increments('id');
            $table->integer('image_id')->unsigned()->nullable();
            $table->json('status');
            $table->json('title');
            $table->json('slug');
            $table->json('summary');
            $table->json('body');
            $table->timestamps();
        });
    }
1346601
public function migrate()
	{
		$schema = $this->getSchema( 'db-customer' );
		$sql = 'SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = \'users\' AND COLUMN_NAME = \'id\'';

		try {
			$type = $this->getValue( $sql, 'COLUMN_TYPE', 'db-customer' );
		} catch( \Aimeos\MW\Setup\Exception $e ) {
			$type = null;
		}

		if( in_array( $type, ['int(10)', 'int(11)'] ) )
		{
			$this->msg( sprintf( 'Remove signed constraints in users related tables' ), 0 );
			$this->status( '' );


			$this->msg( 'Checking constraint in "users_address"', 1 );

			if( $schema->constraintExists( 'users_address', 'fk_lvuad_pid' ) )
			{
				$this->execute( 'ALTER TABLE "users_address" DROP FOREIGN KEY "fk_lvuad_pid"', 'db-customer' );
				$this->status( 'done' );
			}
			else
			{
				$this->status( 'OK' );
			}


			$this->msg( 'Checking constraint in "users_list"', 1 );

			if( $schema->constraintExists( 'users_list', 'fk_lvuli_pid' ) )
			{
				$this->execute( 'ALTER TABLE "users_list" DROP FOREIGN KEY "fk_lvuli_pid"', 'db-customer' );
				$this->status( 'done' );
			}
			else
			{
				$this->status( 'OK' );
			}


			$this->msg( 'Checking constraint in "users_property"', 1 );

			if( $schema->constraintExists( 'users_property', 'fk_lvupr_pid' ) )
			{
				$this->execute( 'ALTER TABLE "users_property" DROP FOREIGN KEY "fk_lvupr_pid"', 'db-customer' );
				$this->status( 'done' );
			}
			else
			{
				$this->status( 'OK' );
			}
		}
	}
256231
public function migrateUp()
    {
        Schema::table('tddd_suites', function (Blueprint $table) {
            $table->string('coverage_enabled')->boolean(false);

            $table->string('coverage_index')->nullable();
        });
    }
530522
def migrate(self, conn):
        
        while self.should_migrate(conn):
            current_version = get_user_version(conn)
            migration = self._get_migration(current_version)
            assert migration.from_ver == current_version
            logger.info(f'Migrating database from {migration.from_ver}'
                        f' to {migration.to_ver}')
            self._migrate_single(conn, migration)
            set_user_version(conn, migration.to_ver)
            logger.info(f'Migrated database to {migration.to_ver}')
277444
public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->engine = 'InnoDB';

            $table->increments('id');
            $table->string('username');
            $table->string('password');
            $table->rememberToken();
            $table->string('email');
            $table->string('api_key');
            $table->boolean('active')->default(1);
            $table->tinyInteger('level')->default(2);
            $table->timestamps();

            $table->index('remember_token');
            $table->index('active');
            $table->unique('username');
            $table->unique('api_key');
            $table->unique('email');
        });
    }
416719
def setup_migrate(app):
    """"""
    directory = path.join(path.dirname(__file__), 'migrations')
    migrate.init_app(app, db, directory=directory)
1060081
public function up() {
		$db = Database::get();
		$result = $db->get_row('show table status where NAME="file"', []);

		if (isset($result['engine']) and $result['engine'] == 'InnoDB') {
			return;
		}
	
		if (isset($result['Engine']) and $result['Engine'] == 'InnoDB') {
            		return;
        	}

		$db->query("
			ALTER TABLE `file` ENGINE='InnoDB';
		", []);
	}
1335057
public function migrateUp()
    {
        $this->builder->create(
            $this->table,
            function ($table) {
                $table->bigIncrements('id');

                $table->string('sha1', 40)->index();
                $table->text('statement');
                $table->double('time')->index();
                $table->integer('connection_id')->unsigned();

                $table->timestamps();
                $table->index('created_at');
                $table->index('updated_at');
            }
        );
    }
439111
public function up()
    {
    	Schema::create('SL_Databases', function(Blueprint $table)
		{
			$table->increments('DbID');
			$table->integer('DbUser')->unsigned()->nullable();
			$table->string('DbPrefix', 25)->nullable();
			$table->string('DbName')->nullable();
			$table->longText('DbDesc')->nullable();
			$table->longText('DbMission')->nullable();
			$table->integer('DbOpts')->default('1')->nullable();
			$table->integer('DbTables')->default('0')->nullable();
			$table->integer('DbFields')->default('0')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Tables', function(Blueprint $table)
		{
			$table->increments('TblID');
			$table->integer('TblDatabase')->unsigned()->nullable();
			$table->string('TblAbbr')->nullable();
			$table->string('TblName')->nullable();
			$table->string('TblEng')->nullable();
			$table->longText('TblDesc')->nullable();
			$table->longText('TblNotes')->nullable();
			$table->string('TblType', 25)->default('Data')->nullable();
			$table->string('TblGroup', 50)->nullable();
			$table->integer('TblOrd')->default('0')->nullable();
			$table->integer('TblOpts')->default('1')->nullable();
			$table->integer('TblExtend')->unsigned()->default('0')->nullable();
			$table->integer('TblNumFields')->default('0')->nullable();
			$table->integer('TblNumForeignKeys')->default('0')->nullable();
			$table->integer('TblNumForeignIn')->default('0')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Fields', function(Blueprint $table)
		{
			$table->increments('FldID');
			$table->integer('FldDatabase')->unsigned()->nullable();
			$table->integer('FldTable')->unsigned()->nullable();
			$table->integer('FldOrd')->default('0')->nullable();
			$table->string('FldSpecType', 10)->default('Unique')->nullable();
			$table->integer('FldSpecSource')->default('-3')->nullable();
			$table->string('FldName')->nullable();
			$table->string('FldEng')->nullable();
			$table->string('FldAlias')->nullable();
			$table->longText('FldDesc')->nullable();
			$table->longText('FldNotes')->nullable();
			$table->integer('FldForeignTable')->default('-3')->nullable();
			$table->string('FldForeignMin', 11)->default('1')->nullable();
			$table->string('FldForeignMax', 11)->default('1')->nullable();
			$table->string('FldForeign2Min', 11)->default('1')->nullable();
			$table->string('FldForeign2Max', 11)->default('1')->nullable();
			$table->longText('FldValues')->nullable();
			$table->string('FldDefault')->nullable();
			$table->boolean('FldIsIndex')->default('0')->nullable();
			$table->string('FldType', 25)->default('VARCHAR')->nullable();
			$table->string('FldDataType', 20)->default('Alphanumeric')->nullable();
			$table->integer('FldDataLength')->nullable();
			$table->integer('FldDataDecimals')->default('0')->nullable();
			$table->string('FldCharSupport')->default(',Letters,Numbers,Keyboard,Special,')->nullable();
			$table->string('FldInputMask')->nullable();
			$table->string('FldDisplayFormat')->nullable();
			$table->string('FldKeyType')->default(',Non,')->nullable();
			$table->string('FldKeyStruct', 10)->nullable();
			$table->string('FldEditRule', 10)->default('LateAllow')->nullable();
			$table->boolean('FldUnique')->default('0')->nullable();
			$table->boolean('FldNullSupport')->default('1')->nullable();
			$table->string('FldValuesEnteredBy', 10)->default('User')->nullable();
			$table->boolean('FldRequired')->default('0')->nullable();
			$table->integer('FldCompareSame')->default('1')->nullable();
			$table->integer('FldCompareOther')->default('1')->nullable();
			$table->integer('FldCompareValue')->default('1')->nullable();
			$table->integer('FldOperateSame')->default('1')->nullable();
			$table->integer('FldOperateOther')->default('1')->nullable();
			$table->integer('FldOperateValue')->default('1')->nullable();
			$table->integer('FldOpts')->default('1')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Definitions', function(Blueprint $table)
		{
			$table->increments('DefID');
			$table->integer('DefDatabase')->unsigned()->nullable();
			$table->string('DefSet', 20)->default('Value Ranges')->nullable();
			$table->string('DefSubset', 50)->nullable();
			$table->integer('DefOrder')->default('0')->nullable();
			$table->boolean('DefIsActive')->default('1')->nullable();
			$table->string('DefValue')->nullable();
			$table->longText('DefDescription')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_BusRules', function(Blueprint $table)
		{
			$table->increments('RuleID');
			$table->integer('RuleDatabase')->unsigned()->nullable();
			$table->longText('RuleStatement')->nullable();
			$table->longText('RuleConstraint')->nullable();
			$table->string('RuleTables')->default(',')->nullable();
			$table->string('RuleFields')->default(',')->nullable();
			$table->boolean('RuleIsAppOrient')->default('1')->nullable();
			$table->boolean('RuleIsRelation')->default('1')->nullable();
			$table->string('RuleTestOn', 10)->default('Insert')->nullable();
			$table->integer('RulePhys')->default('1')->nullable();
			$table->integer('RuleLogic')->default('1')->nullable();
			$table->integer('RuleRel')->default('1')->nullable();
			$table->longText('RuleAction')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Tree', function(Blueprint $table)
		{
			$table->increments('TreeID');
			$table->integer('TreeDatabase')->unsigned()->nullable();
			$table->integer('TreeUser')->unsigned()->nullable();
			$table->string('TreeType', 30)->default('Primary Public')->nullable();
			$table->string('TreeName')->nullable();
			$table->longText('TreeDesc')->nullable();
			$table->string('TreeSlug')->nullable();
			$table->integer('TreeRoot')->unsigned()->nullable();
			$table->integer('TreeFirstPage')->unsigned()->nullable();
			$table->integer('TreeLastPage')->unsigned()->nullable();
			$table->integer('TreeCoreTable')->unsigned()->nullable();
			$table->integer('TreeOpts')->default('1')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Node', function(Blueprint $table)
		{
			$table->increments('NodeID');
			$table->integer('NodeTree')->unsigned()->nullable();
			$table->integer('NodeParentID')->default('-3')->nullable();
			$table->integer('NodeParentOrder')->default('0')->nullable();
			$table->string('NodeType', 25)->nullable();
			$table->longText('NodePromptText')->nullable();
			$table->longText('NodePromptNotes')->nullable();
			$table->longText('NodePromptAfter')->nullable();
			$table->longText('NodeInternalNotes')->nullable();
			$table->string('NodeResponseSet', 50)->nullable();
			$table->string('NodeDefault')->nullable();
			$table->string('NodeDataBranch', 100)->nullable();
			$table->string('NodeDataStore', 100)->nullable();
			$table->string('NodeTextSuggest', 100)->nullable();
			$table->integer('NodeCharLimit')->default('0')->nullable();
			$table->integer('NodeLikes')->default('0')->nullable();
			$table->integer('NodeDislikes')->default('0')->nullable();
			$table->integer('NodeOpts')->default('1')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_NodeResponses', function(Blueprint $table)
		{
			$table->increments('NodeResID');
			$table->integer('NodeResNode')->unsigned()->nullable();
			$table->integer('NodeResOrd')->default('0')->nullable();
			$table->longText('NodeResEng')->nullable();
			$table->string('NodeResValue')->nullable();
			$table->integer('NodeResShowKids')->default('0')->nullable();
			$table->integer('NodeResMutEx')->default('0')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Conditions', function(Blueprint $table)
		{
			$table->increments('CondID');
			$table->integer('CondDatabase')->unsigned()->nullable();
			$table->string('CondTag', 100)->nullable();
			$table->longText('CondDesc')->nullable();
			$table->string('CondOperator', 50)->default('{')->nullable();
			$table->string('CondOperDeet', 100)->nullable();
			$table->integer('CondField')->unsigned()->nullable();
			$table->integer('CondTable')->unsigned()->nullable();
			$table->integer('CondLoop')->unsigned()->nullable();
			$table->integer('CondOpts')->default('1')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_ConditionsVals', function(Blueprint $table)
		{
			$table->increments('CondValID');
			$table->integer('CondValCondID')->unsigned()->nullable();
			$table->string('CondValValue')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_ConditionsNodes', function(Blueprint $table)
		{
			$table->increments('CondNodeID');
			$table->integer('CondNodeCondID')->unsigned()->nullable();
			$table->integer('CondNodeNodeID')->nullable();
			$table->integer('CondNodeLoopID')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_ConditionsArticles', function(Blueprint $table)
		{
			$table->increments('ArticleID');
			$table->integer('ArticleCondID')->unsigned()->nullable();
			$table->string('ArticleURL')->nullable();
			$table->string('ArticleTitle')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_DataLoop', function(Blueprint $table)
		{
			$table->increments('DataLoopID');
			$table->integer('DataLoopTree')->unsigned()->nullable();
			$table->integer('DataLoopRoot')->unsigned()->nullable();
			$table->string('DataLoopPlural', 50)->nullable();
			$table->string('DataLoopSingular', 50)->nullable();
			$table->string('DataLoopTable', 100)->nullable();
			$table->string('DataLoopSortFld', 100)->nullable();
			$table->string('DataLoopDoneFld', 100)->nullable();
			$table->integer('DataLoopMaxLimit')->default('0')->nullable();
			$table->integer('DataLoopWarnLimit')->default('0')->nullable();
			$table->integer('DataLoopMinLimit')->default('0')->nullable();
			$table->boolean('DataLoopIsStep')->default('0')->nullable();
			$table->boolean('DataLoopAutoGen')->default('1')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_DataSubsets', function(Blueprint $table)
		{
			$table->increments('DataSubID');
			$table->integer('DataSubTree')->unsigned()->nullable();
			$table->string('DataSubTbl', 100)->nullable();
			$table->string('DataSubTblLnk', 100)->nullable();
			$table->string('DataSubSubTbl', 50)->nullable();
			$table->string('DataSubSubLnk', 100)->nullable();
			$table->boolean('DataSubAutoGen')->default('0')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_DataHelpers', function(Blueprint $table)
		{
			$table->increments('DataHelpID');
			$table->integer('DataHelpTree')->unsigned()->nullable();
			$table->string('DataHelpParentTable', 50)->nullable();
			$table->string('DataHelpTable', 50)->nullable();
			$table->string('DataHelpKeyField', 50)->nullable();
			$table->string('DataHelpValueField', 50)->nullable();
			$table->timestamps();
		});
		Schema::create('SL_DataLinks', function(Blueprint $table)
		{
			$table->increments('DataLinkID');
			$table->integer('DataLinkTree')->unsigned()->nullable();
			$table->integer('DataLinkTable')->unsigned()->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Images', function(Blueprint $table)
		{
			$table->increments('ImgID');
			$table->integer('ImgDatabaseID')->unsigned()->nullable();
			$table->integer('ImgUserID')->unsigned()->nullable();
			$table->string('ImgFileOrig')->nullable();
			$table->string('ImgFileLoc')->nullable();
			$table->string('ImgFullFilename')->nullable();
			$table->string('ImgTitle')->nullable();
			$table->string('ImgCredit')->nullable();
			$table->string('ImgCreditUrl')->nullable();
			$table->integer('ImgNodeID')->unsigned()->nullable();
			$table->string('ImgType', 10)->nullable();
			$table->integer('ImgFileSize')->nullable();
			$table->integer('ImgWidth')->nullable();
			$table->integer('ImgHeight')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_SearchRecDump', function(Blueprint $table)
		{
			$table->increments('SchRecDmpID');
			$table->integer('SchRecDmpTreeID')->unsigned()->nullable();
			$table->integer('SchRecDmpRecID')->nullable();
			$table->longText('SchRecDmpDump')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_DesignTweaks', function(Blueprint $table)
		{
			$table->increments('TweakID');
			$table->string('TweakVersionAB')->nullable();
			$table->integer('TweakSubmissionProgress')->unsigned()->nullable();
			$table->string('TweakIPaddy')->nullable();
			$table->string('TweakTreeVersion')->nullable();
			$table->string('TweakUniqueStr')->nullable();
			$table->integer('TweakUserID')->unsigned()->nullable();
			$table->string('TweakIsMobile')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Sess', function(Blueprint $table)
		{
			$table->increments('SessID');
			$table->integer('SessUserID')->unsigned()->nullable();
			$table->integer('SessTree')->unsigned()->nullable();
			$table->integer('SessCoreID')->unsigned()->nullable();
			$table->boolean('SessIsActive')->nullable();
			$table->integer('SessCurrNode')->unsigned()->nullable();
			$table->integer('SessLoopRootJustLeft')->unsigned()->nullable();
			$table->integer('SessAfterJumpTo')->unsigned()->nullable();
			$table->boolean('SessIsMobile')->nullable();
			$table->string('SessBrowser', 255)->nullable();
			$table->string('SessIP')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_SessLoops', function(Blueprint $table)
		{
			$table->increments('SessLoopID');
			$table->integer('SessLoopSessID')->unsigned()->nullable();
			$table->string('SessLoopName', 50)->nullable();
			$table->integer('SessLoopItemID')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_NodeSavesPage', function(Blueprint $table)
		{
			$table->increments('PageSaveID');
			$table->integer('PageSaveSession')->unsigned()->nullable();
			$table->integer('PageSaveNode')->unsigned()->nullable();
			$table->integer('PageSaveLoopItemID')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_NodeSaves', function(Blueprint $table)
		{
			$table->increments('NodeSaveID');
			$table->integer('NodeSaveSession')->unsigned()->nullable();
			$table->integer('NodeSaveLoopItemID')->nullable();
			$table->integer('NodeSaveNode')->unsigned()->nullable();
			$table->string('NodeSaveVersionAB')->nullable();
			$table->string('NodeSaveTblFld', 100)->nullable();
			$table->longText('NodeSaveNewVal')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_SessEmojis', function(Blueprint $table)
		{
			$table->increments('SessEmoID');
			$table->integer('SessEmoUserID')->unsigned()->nullable();
			$table->integer('SessEmoTreeID')->unsigned()->nullable();
			$table->integer('SessEmoRecID')->nullable();
			$table->integer('SessEmoDefID')->unsigned()->nullable();
			$table->timestamps();
		});
		Schema::create('SL_SessSite', function(Blueprint $table)
		{
			$table->increments('SiteSessID');
			$table->string('SiteSessIPaddy')->nullable();
			$table->longText('SiteSessUserID')->nullable();
			$table->boolean('SiteSessIsMobile')->nullable();
			$table->string('SiteSessBrowser', 255)->nullable();
			$table->integer('SiteSessZoomPref')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_SessPage', function(Blueprint $table)
		{
			$table->increments('SessPageID');
			$table->integer('SessPageSessID')->unsigned()->nullable();
			$table->string('SessPageURL')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Tokens', function(Blueprint $table)
		{
			$table->increments('TokID');
			$table->string('TokType', 20)->nullable();
			$table->integer('TokUserID')->unsigned()->nullable();
			$table->integer('TokTreeID')->unsigned()->nullable();
			$table->integer('TokCoreID')->nullable();
			$table->string('TokTokToken', 255)->nullable();
			$table->timestamps();
		});
		Schema::create('SL_UsersRoles', function(Blueprint $table)
		{
			$table->increments('RoleUserID');
			$table->integer('RoleUserUID')->unsigned()->nullable();
			$table->integer('RoleUserRID')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Contact', function(Blueprint $table)
		{
			$table->increments('ContID');
			$table->string('ContType')->nullable();
			$table->string('ContFlag')->default('Unread')->nullable();
			$table->string('ContEmail')->nullable();
			$table->string('ContSubject')->nullable();
			$table->longText('ContBody')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Emails', function(Blueprint $table)
		{
			$table->increments('EmailID');
			$table->integer('EmailTree')->unsigned()->nullable();
			$table->string('EmailType')->nullable();
			$table->string('EmailName')->nullable();
			$table->longText('EmailSubject')->nullable();
			$table->longText('EmailBody')->nullable();
			$table->integer('EmailOpts')->default('1')->nullable();
			$table->integer('EmailTotSent')->default('0')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Emailed', function(Blueprint $table)
		{
			$table->increments('EmailedID');
			$table->integer('EmailedTree')->unsigned()->nullable();
			$table->integer('EmailedRecID')->nullable();
			$table->integer('EmailedEmailID')->unsigned()->nullable();
			$table->string('EmailedTo')->nullable();
			$table->integer('EmailedToUser')->unsigned()->nullable();
			$table->integer('EmailedFromUser')->unsigned()->nullable();
			$table->string('EmailedSubject')->nullable();
			$table->longText('EmailedBody')->nullable();
			$table->integer('EmailedOpts')->default('1')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_UsersActivity', function(Blueprint $table)
		{
			$table->increments('UserActID');
			$table->integer('UserActUser')->unsigned()->nullable();
			$table->string('UserActCurrPage')->nullable();
			$table->longText('UserActVal')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_LogActions', function(Blueprint $table)
		{
			$table->increments('LogID');
			$table->integer('LogUser')->unsigned()->nullable();
			$table->integer('LogDatabase')->unsigned()->nullable();
			$table->integer('LogTable')->unsigned()->nullable();
			$table->integer('LogField')->unsigned()->nullable();
			$table->string('LogAction', 20)->nullable();
			$table->string('LogOldName')->nullable();
			$table->string('LogNewName')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Zips', function(Blueprint $table)
		{
			$table->increments('ZipID');
			$table->string('ZipZip', 10)->nullable();
			$table->string('ZipLat')->nullable();
			$table->string('ZipLong')->nullable();
			$table->string('ZipCity', 100)->nullable();
			$table->string('ZipState')->nullable();
			$table->string('ZipCounty')->nullable();
			$table->string('ZipCountry', 100)->nullable();
			$table->timestamps();
		});
		Schema::create('SL_AddyGeo', function(Blueprint $table)
		{
			$table->increments('AdyGeoID');
			$table->string('AdyGeoAddress')->nullable();
			$table->string('AdyGeoLat')->nullable();
			$table->string('AdyGeoLong')->nullable();
			$table->timestamps();
		});
		Schema::create('SL_Uploads', function(Blueprint $table)
		{
			$table->increments('UpID');
			$table->integer('UpTreeID')->nullable();
			$table->integer('UpCoreID')->nullable();
			$table->integer('UpType')->nullable();
			$table->string('UpPrivacy', 10)->nullable();
			$table->string('UpTitle')->nullable();
			$table->longText('UpDesc')->nullable();
			$table->string('UpUploadFile')->nullable();
			$table->string('UpStoredFile')->nullable();
			$table->string('UpVideoLink')->nullable();
			$table->integer('UpNodeID')->nullable();
			$table->integer('UpLinkFldID')->nullable();
			$table->integer('UpLinkRecID')->nullable();
			$table->timestamps();
		});
    }
1074204
public function migrate()
	{
		$this->msg( 'Update charset and collation for Laravel tables', 0 );
		$this->status( '' );

		foreach( $this->tables as $rname => $list ) {
			$this->checkTables( $list, $rname );
		}
	}
191146
public function up()
    {
        $this->create('migrations', function ($table) {
            // Place table rows here
            $table->increments('id');
            $table->string('migration');
            $table->integer('migrated');
            $table->timestamps();
        });
    }
1326380
public function up()
    {
        Schema::create('jobs', function (Blueprint $table) {
            $table->engine = 'InnoDB';

            $table->bigIncrements('id');
            $table->string('queue');
            $table->text('payload');
            $table->tinyInteger('attempts')->unsigned();
            $table->tinyInteger('reserved')->unsigned();
            $table->unsignedInteger('reserved_at')->nullable();
            $table->unsignedInteger('available_at');
            $table->unsignedInteger('created_at');
        });
    }