Run the database seeds.
@return void
@throws \Exception
161021
public function run()
    {
        $ids = getRinvexCountryIDs();
        $continents = [];

        foreach ($ids as $id)
            $continents = array_merge($continents, country($id)->getGeodata()['continent']);

        $continents = array_unique($continents);

        DB::beginTransaction();

        try
        {
            foreach ($continents as $key => $value)
            {
                $record = HCContinents::find($key);

                if (!$record)
                    HCContinents::create(['id' => $key, 'translation_key' => 'HCRegions::regions_continents.continent.' . createTranslationKey($key)]);
            }
        } catch (\Exception $e)
        {
            DB::rollback();
            throw new \Exception($e);
        }

        DB::commit();
    }
730735
public function run(): void
    {
        foreach (self::SETTINGS as $setting_name => $setting_value) {
            DB::table('site_setting')->updateOrInsert([
                'setting_name'  => $setting_name,
            ], [
                'setting_value' => $setting_value,
            ]);
        }
    }
449487
public function run()
	{
		$context = $this->_getContext();

		$jobManager = MAdmin_Job_Manager_Factory::createManager( $context );
		$criteria = $jobManager->createSearch( true );

		$start = 0;

		do
		{
			$items = $jobManager->searchItems( $criteria );

			foreach( $items as $item )
			{
				try
				{
					$job = $item->getMethod();

					if( preg_match( '/^[a-zA-Z0-9\_]+\.[a-zA-Z0-9\_]+$/', $job ) !== 1 ) {
						throw new Controller_Jobs_Exception( sprintf( 'Invalid characters in job name "%1$s"', $job ) );
					}

					$parts = explode( '.', $job );

					if( count( $parts ) !== 2 ) {
						throw new Controller_Jobs_Exception( sprintf( 'Invalid job method "%1$s"', $job ) );
					}

					$name = "Controller_ExtJS_{$parts[0]}_Factory";
					$method = $parts[1];

					if( class_exists( $name ) === false ) {
						throw new Controller_Jobs_Exception( sprintf( 'Class "%1$s" not available', $name ) );
					}

					$name .= '::createController';

					if( ( $controller = call_user_func_array( $name, array( $context ) ) ) === false ) {
						throw new Controller_Jobs_Exception( sprintf( 'Unable to call factory method "%1$s"', $name ) );
					}

					if( method_exists( $controller, $method ) === false ) {
						throw new Controller_Jobs_Exception( sprintf( 'Method "%1$s" not available', $method ) );
					}

					$result = $controller->$method( (object) $item->getParameter() );

					$item->setResult( $result );
					$item->setStatus( -1 );
				}
				catch( Exception $e )
				{
					$str = 'Error while processing job "%1$s": %2$s';
					$context->getLogger()->log( sprintf( $str, $item->getMethod(), $e->getMessage() ) );
					$item->setStatus( 0 );
				}

				$jobManager->saveItem( $item );
			}

			$count = count( $items );
			$start += $count;
			$criteria->setSlice( $start );
		}
		while( $count > 0 );
	}
1091791
public function run()
    {
        $table = \Input::get('table');
        $field = \Input::get('field');
        $name  = \Input::get('name');
        $rowId = \Input::get('id');

        $dataContainer = $this->initializeDataContainer($table, $field);
        $this->loadRow($table, $rowId, $dataContainer);

        $template = $this->prepareTemplate();

        $template->table = $table;
        $template->field = $field;
        $template->name  = $name;
        $template->icon  = $dataContainer->activeRecord->$field;
        $template->icons = $this->generateIcons($field);

        $template->output();
    }
1322700
public function run()
    {
    	
	DB::table('SL_Databases')->insert([
			'DbID' => 3,
			'DbUser' => '0',
			'DbPrefix' => 'SL_',
			'DbName' => 'SurvLoop',
			'DbDesc' => 'All The Data Are Belong',
			'DbMission' => 'Empower you to design your complex databases, collect data with an easy user experience, and create an API to share the data with the world!',
			'DbTables' => '36',
			'DbFields' => '260'
		]);
	
	DB::table('SL_Tables')->insert([
			'TblID' => 3,
			'TblDatabase' => '3',
			'TblAbbr' => 'Tweak',
			'TblName' => 'DesignTweaks',
			'TblEng' => 'Design Tweaks',
			'TblDesc' => 'Represents one modification to the existing database and user experience designs in SurvLoop. Information stored here is important for tracking history of changes and success of A/B testing in the user experience. This is the Core Data Table of SurvLoop\'s naked installation.',
			'TblGroup' => 'Session Records',
			'TblOrd' => '18',
			'TblNumFields' => '7',
			'TblNumForeignKeys' => '2',
			'TblNumForeignIn' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 4,
			'TblDatabase' => '3',
			'TblAbbr' => 'Db',
			'TblName' => 'Databases',
			'TblEng' => 'Databases',
			'TblDesc' => 'Each record represents one Database being designed in SurvLoop, a collection of Tables, Fields, Definitions, and Business Rules often owned by a User. Information stored here can define core system settings.',
			'TblGroup' => 'Databases',
			'TblNumFields' => '8',
			'TblNumForeignKeys' => '1',
			'TblNumForeignIn' => '8'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 5,
			'TblDatabase' => '3',
			'TblAbbr' => 'Tree',
			'TblName' => 'Tree',
			'TblEng' => 'Trees',
			'TblDesc' => 'Each Tree represents one collection of Nodes which one specific survey  process, page of content, navigation menu, etc. Nodes are connected to each other to form a branching Tree which define all the details.',
			'TblGroup' => 'Trees',
			'TblOrd' => '5',
			'TblNumFields' => '11',
			'TblNumForeignKeys' => '6',
			'TblNumForeignIn' => '11'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 6,
			'TblDatabase' => '3',
			'TblAbbr' => 'Rule',
			'TblName' => 'BusRules',
			'TblEng' => 'Business Rules',
			'TblDesc' => 'Each record represents one Business Rule which specifies certain requirements to be maintained in the Database. Implementing the Rules defined here is important for maintaining data integrity.',
			'TblGroup' => 'Databases',
			'TblOrd' => '4',
			'TblNumFields' => '12',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 7,
			'TblDatabase' => '3',
			'TblAbbr' => 'Def',
			'TblName' => 'Definitions',
			'TblEng' => 'Definitions',
			'TblDesc' => 'Includes lists of possible ranges of values for various data Fields throughout the database, and other system settings. This is important for providing dynamic storage for key system terminology which may infrequently change.',
			'TblGroup' => 'Databases',
			'TblOrd' => '3',
			'TblNumFields' => '7',
			'TblNumForeignKeys' => '1',
			'TblNumForeignIn' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 9,
			'TblDatabase' => '3',
			'TblAbbr' => 'Tbl',
			'TblName' => 'Tables',
			'TblEng' => 'Database Tables',
			'TblDesc' => 'Each record represents one Table in the Database, which is a collection of any number of Fields.',
			'TblGroup' => 'Databases',
			'TblOrd' => '1',
			'TblNumFields' => '14',
			'TblNumForeignKeys' => '2',
			'TblNumForeignIn' => '7'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 10,
			'TblDatabase' => '3',
			'TblAbbr' => 'Fld',
			'TblName' => 'Fields',
			'TblEng' => 'Database Fields',
			'TblDesc' => 'Each record represents one data Field where specific information will be stored in the completed Database.',
			'TblNotes' => 'Notes assigned to these Field specifications are used as helpful tool-tip resources power users.',
			'TblGroup' => 'Databases',
			'TblOrd' => '2',
			'TblNumFields' => '39',
			'TblNumForeignKeys' => '4',
			'TblNumForeignIn' => '3'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 11,
			'TblDatabase' => '3',
			'TblAbbr' => 'Cond',
			'TblName' => 'Conditions',
			'TblEng' => 'Conditions',
			'TblDesc' => 'Each record represents one specific Condition used to filter Database submissions. These are important for determining which Nodes to include during a User\'s Experience, and which finished submissions to include in public queries.',
			'TblGroup' => 'Trees',
			'TblOrd' => '8',
			'TblNumFields' => '9',
			'TblNumForeignKeys' => '4',
			'TblNumForeignIn' => '2'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 12,
			'TblDatabase' => '3',
			'TblAbbr' => 'Article',
			'TblName' => 'ConditionsArticles',
			'TblEng' => 'Condition Articles',
			'TblDesc' => 'Each record represents one Article which provides more information regarding Experience submissions which meet a Condition\'s requirements. This is important for provident automated, educational information to Users and the public. ',
			'TblType' => 'Subset',
			'TblGroup' => 'Trees',
			'TblOrd' => '11',
			'TblNumFields' => '3',
			'TblNumForeignKeys' => '1',
			'TblNumForeignIn' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 13,
			'TblDatabase' => '3',
			'TblAbbr' => 'CondNode',
			'TblName' => 'ConditionsNodes',
			'TblEng' => 'Condition Nodes',
			'TblDesc' => 'Each record represents a linkage between one Node or one Data Loop within this Experience. ',
			'TblType' => 'Linking',
			'TblGroup' => 'Trees',
			'TblOrd' => '10',
			'TblNumFields' => '3',
			'TblNumForeignKeys' => '3',
			'TblNumForeignIn' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 14,
			'TblDatabase' => '3',
			'TblAbbr' => 'CondVal',
			'TblName' => 'ConditionsVals',
			'TblEng' => 'Condition Values',
			'TblDesc' => 'Each record represents one Value to be compared with a User\'s Response when testing a specific Condition. This is important for comparing among a range of values. ',
			'TblType' => 'Subset',
			'TblGroup' => 'Trees',
			'TblOrd' => '9',
			'TblNumFields' => '2',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 15,
			'TblDatabase' => '3',
			'TblAbbr' => 'Node',
			'TblName' => 'Node',
			'TblEng' => 'Tree Nodes',
			'TblDesc' => 'Each record represents one Node in the branching Tree, defining the critical details of each survey, page, etc. Each Node could represent the start of a new branch of the Tree, a new question asked of a User, or a new page which will ask multiple questions.',
			'TblGroup' => 'Trees',
			'TblOrd' => '6',
			'TblNumFields' => '17',
			'TblNumForeignKeys' => '2',
			'TblNumForeignIn' => '13'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 16,
			'TblDatabase' => '3',
			'TblAbbr' => 'NodeRes',
			'TblName' => 'NodeResponses',
			'TblEng' => 'Node Responses',
			'TblDesc' => 'Each record represents one Response presented to the User when prompted by a specific Node.',
			'TblType' => 'Subset',
			'TblGroup' => 'Trees',
			'TblOrd' => '7',
			'TblNumFields' => '6',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 17,
			'TblDatabase' => '3',
			'TblAbbr' => 'NodeSave',
			'TblName' => 'NodeSaves',
			'TblEng' => 'Node Saves',
			'TblDesc' => 'Each record represents one User\'s Response to a specific Node during a specific Session. Among other quality control, this is important for comparing the efficacy of various A/B testing in the user experience.',
			'TblGroup' => 'Session Records',
			'TblOrd' => '22',
			'TblNumFields' => '6',
			'TblNumForeignKeys' => '2'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 18,
			'TblDatabase' => '3',
			'TblAbbr' => 'PageSave',
			'TblName' => 'NodeSavesPage',
			'TblEng' => 'Page Saves',
			'TblDesc' => 'Each record represents one timestamp of a User\'s submission of a specific Page Node during a specific Session. This is important for quickly checking or reviewing the progress of Users through an Experience.',
			'TblGroup' => 'Session Records',
			'TblOrd' => '21',
			'TblNumFields' => '3',
			'TblNumForeignKeys' => '2'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 19,
			'TblDatabase' => '3',
			'TblAbbr' => 'Sess',
			'TblName' => 'Sess',
			'TblEng' => 'User Session',
			'TblDesc' => 'Each record represents one User\'s Session while going through an Experience. This is important for saving a User\'s progress if they have to complete an Experience over the course of multiple browser sessions.',
			'TblGroup' => 'Session Records',
			'TblOrd' => '19',
			'TblNumFields' => '10',
			'TblNumForeignKeys' => '6',
			'TblNumForeignIn' => '3'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 20,
			'TblDatabase' => '3',
			'TblAbbr' => 'SessLoop',
			'TblName' => 'SessLoops',
			'TblEng' => 'Session Loops',
			'TblDesc' => 'Each record represents one User\'s current Data Loop Item which they are editing, as related to their current Session. This is important for saving a User\'s progress if they have to complete an Experience over the course of multiple browser sessions.',
			'TblType' => 'Subset',
			'TblGroup' => 'Session Records',
			'TblOrd' => '20',
			'TblNumFields' => '3',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 21,
			'TblDatabase' => '3',
			'TblAbbr' => 'UserAct',
			'TblName' => 'UsersActivity',
			'TblEng' => 'User Activity',
			'TblDesc' => 'Each record represents one log entry of a User\'s Activity, important for tracking system usage.',
			'TblType' => 'Validation',
			'TblGroup' => 'Logs',
			'TblOrd' => '32',
			'TblNumFields' => '3',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 22,
			'TblDatabase' => '3',
			'TblAbbr' => 'RoleUser',
			'TblName' => 'UsersRoles',
			'TblEng' => 'User Roles',
			'TblDesc' => 'Each record represents one linkage between a Laravel system User and a User Role as defined by it\'s unique ID in the Definitions table. ',
			'TblType' => 'Linking',
			'TblGroup' => 'Users',
			'TblOrd' => '27',
			'TblNumFields' => '2',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 23,
			'TblDatabase' => '3',
			'TblAbbr' => 'Log',
			'TblName' => 'LogActions',
			'TblEng' => 'Log Actions',
			'TblDesc' => 'Each record represents one detailed Log entry of an Administrator\'s database design changes, important for keeping a history for undoing mistakes.',
			'TblType' => 'Validation',
			'TblGroup' => 'Logs',
			'TblOrd' => '33',
			'TblNumFields' => '7',
			'TblNumForeignKeys' => '4'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 24,
			'TblDatabase' => '3',
			'TblAbbr' => 'DataLoop',
			'TblName' => 'DataLoop',
			'TblEng' => 'Data Loops',
			'TblDesc' => 'Each record represents one Data Loop\'s full details. This is important for automating data relations for related Experiences.',
			'TblGroup' => 'Trees',
			'TblOrd' => '12',
			'TblNumFields' => '12',
			'TblNumForeignKeys' => '2',
			'TblNumForeignIn' => '2'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 25,
			'TblDatabase' => '3',
			'TblAbbr' => 'DataLink',
			'TblName' => 'DataLinks',
			'TblEng' => 'Data Linkage Tables',
			'TblDesc' => 'Each record represents one linkage between one Database Table and a second Table which don\'t require a hierarchical relationship. This is important for automating data relations for related Experiences.',
			'TblType' => 'Linking',
			'TblGroup' => 'Trees',
			'TblOrd' => '15',
			'TblNumFields' => '2',
			'TblNumForeignKeys' => '2'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 26,
			'TblDatabase' => '3',
			'TblAbbr' => 'DataSub',
			'TblName' => 'DataSubsets',
			'TblEng' => 'Data Subset Tables',
			'TblDesc' => 'Each record represents one linkage between one Database Table and a Subset Table which pulls in one related secondary record of detailed information. This is important for automating data relations for related Experiences.',
			'TblType' => 'Linking',
			'TblGroup' => 'Trees',
			'TblOrd' => '13',
			'TblNumFields' => '6',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 27,
			'TblDatabase' => '3',
			'TblAbbr' => 'DataHelp',
			'TblName' => 'DataHelpers',
			'TblEng' => 'Data Helper Tables',
			'TblDesc' => 'Each record represents one linkage between one Database Table and a Helper Table which can store multiple checkbox responses or relate many secondary records to the primary. This is important for automating data relations for related Experiences.',
			'TblType' => 'Linking',
			'TblGroup' => 'Trees',
			'TblOrd' => '14',
			'TblNumFields' => '5',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 28,
			'TblDatabase' => '3',
			'TblAbbr' => 'User',
			'TblName' => 'Users',
			'TblEng' => 'Users',
			'TblDesc' => 'This represents the Laravel Users table, but will not actually be implemented by SurvLoop as part of the database installation.',
			'TblGroup' => 'Users',
			'TblOrd' => '28',
			'TblNumForeignIn' => '12'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 31,
			'TblDatabase' => '3',
			'TblAbbr' => 'Cont',
			'TblName' => 'Contact',
			'TblEng' => 'Contact Form',
			'TblDesc' => 'Each record represents one complete submission of the default Contact Form.',
			'TblGroup' => 'Users',
			'TblOrd' => '29',
			'TblNumFields' => '5'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 32,
			'TblDatabase' => '3',
			'TblAbbr' => 'SchRecDmp',
			'TblName' => 'SearchRecDump',
			'TblEng' => 'Searchable Record Dump',
			'TblDesc' => 'Each record stores a cache of all data from a specific complex record, including English translations for Definition IDs, etc. This is very useful for running text searches across all Experience submissions.',
			'TblType' => 'Validation',
			'TblGroup' => 'Trees',
			'TblOrd' => '17',
			'TblNumFields' => '3',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 33,
			'TblDatabase' => '3',
			'TblAbbr' => 'SessEmo',
			'TblName' => 'SessEmojis',
			'TblEng' => 'Session Emojis',
			'TblDesc' => 'Each record stores one tag of one submission, by one user. This enables users to interact and provide feedback on completed Experience submissions, and to prevent users from tagging more than once.',
			'TblType' => 'Linking',
			'TblGroup' => 'Session Records',
			'TblOrd' => '23',
			'TblNumFields' => '4',
			'TblNumForeignKeys' => '3'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 34,
			'TblDatabase' => '3',
			'TblAbbr' => 'Tok',
			'TblName' => 'Tokens',
			'TblEng' => 'Tokens',
			'TblDesc' => 'Each record one security token, of various types, which can be sent to a user to confirms some action or grant some access with greater security.',
			'TblGroup' => 'Users',
			'TblOrd' => '26',
			'TblNumFields' => '5',
			'TblNumForeignKeys' => '2'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 35,
			'TblDatabase' => '3',
			'TblAbbr' => 'Emailed',
			'TblName' => 'Emailed',
			'TblEng' => 'Emailings',
			'TblDesc' => 'Each record represents one individual Email Template Mailing, including a copy of the auto-generated (then optionally customized) body of the sent email.',
			'TblGroup' => 'Users',
			'TblOrd' => '31',
			'TblNumFields' => '9',
			'TblNumForeignKeys' => '4'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 36,
			'TblDatabase' => '3',
			'TblAbbr' => 'Email',
			'TblName' => 'Emails',
			'TblEng' => 'Email Templates',
			'TblDesc' => 'Each record represents one Email Template which can be used throughout SurvLoop.',
			'TblGroup' => 'Users',
			'TblOrd' => '30',
			'TblNumFields' => '7',
			'TblNumForeignKeys' => '1',
			'TblNumForeignIn' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 37,
			'TblDatabase' => '3',
			'TblAbbr' => 'Img',
			'TblName' => 'Images',
			'TblEng' => 'Gallery Images',
			'TblDesc' => 'Each record represents one item in the Media Galleries managed by SurvLoop.',
			'TblGroup' => 'Trees',
			'TblOrd' => '16',
			'TblNumFields' => '13',
			'TblNumForeignKeys' => '3'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 38,
			'TblDatabase' => '3',
			'TblAbbr' => 'Zip',
			'TblName' => 'Zips',
			'TblEng' => 'Zip Codes',
			'TblDesc' => 'Each record represents one United States zip code to map it to state and counties. ',
			'TblType' => 'Linking',
			'TblGroup' => 'Lookups',
			'TblOrd' => '34',
			'TblNumFields' => '7'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 39,
			'TblDatabase' => '3',
			'TblAbbr' => 'AdyGeo',
			'TblName' => 'AddyGeo',
			'TblEng' => 'Address Geolocate',
			'TblDesc' => 'Each record represents one Address (all in one line) to map it to its latitude and longitude coordinates. This is important to reducing the number of geocoding requests sent to third parties.',
			'TblGroup' => 'Lookups',
			'TblOrd' => '35',
			'TblNumFields' => '3'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 41,
			'TblDatabase' => '3',
			'TblAbbr' => 'SessPage',
			'TblName' => 'SessPage',
			'TblEng' => 'Session Page Loads',
			'TblDesc' => 'Each record represents one page load, or server-side redirect, as related to their current Session. This is important for saving a User\'s path through the entire website.',
			'TblGroup' => 'Session Records',
			'TblOrd' => '25',
			'TblNumFields' => '2',
			'TblNumForeignKeys' => '1'
		]);
		DB::table('SL_Tables')->insert([
			'TblID' => 42,
			'TblDatabase' => '3',
			'TblAbbr' => 'SiteSess',
			'TblName' => 'SessSite',
			'TblEng' => 'Site Session',
			'TblDesc' => 'Each record represents one User\'s Site Session while browsing through the whole website, not just surveys. This is important for identifying any problems in the website use flow.',
			'TblGroup' => 'Session Records',
			'TblOrd' => '24',
			'TblNumFields' => '5',
			'TblNumForeignIn' => '1'
		]);
	
	DB::table('SL_Fields')->insert([
			'FldID' => 10001,
			'FldDatabase' => '3',
			'FldTable' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'User',
			'FldEng' => 'Database Owner User ID',
			'FldDesc' => 'Indicates the unique User ID number belonging to the owner of this Database.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10002,
			'FldDatabase' => '3',
			'FldTable' => '4',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Prefix',
			'FldEng' => 'Database Prefix',
			'FldDesc' => 'Indicates the short abbreviation which is used to start each Table Name within this Database. This is important for successfully creating and accessing all Database Tables.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDataLength' => '25',
			'FldCharSupport' => ',Letters,Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10003,
			'FldDatabase' => '3',
			'FldTable' => '4',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Name',
			'FldEng' => 'Database Name',
			'FldDesc' => 'Indicates the main, casual, name of the Database in English.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDataLength' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10004,
			'FldDatabase' => '3',
			'FldTable' => '4',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Desc',
			'FldEng' => 'Database Description',
			'FldDesc' => 'Indicates the short tagline which is used to describe this Database. This is generally related to Search Engine Optimization.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldType' => 'TEXT',
			'FldDataLength' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10005,
			'FldDatabase' => '3',
			'FldTable' => '4',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'Mission',
			'FldEng' => 'Database Mission',
			'FldDesc' => 'Indicates the desired goals to be accomplished with this Database. This is important for reminding Users why they are using this system.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldType' => 'TEXT',
			'FldDataLength' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10006,
			'FldDatabase' => '3',
			'FldTable' => '4',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Tables',
			'FldEng' => 'Total Tables',
			'FldDesc' => 'Indicates the cached total number of Tables which make up this Database.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10007,
			'FldDatabase' => '3',
			'FldTable' => '4',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'Fields',
			'FldEng' => 'Total Fields',
			'FldDesc' => 'Indicates the cached total number of Fields which make up this Database.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10008,
			'FldDatabase' => '3',
			'FldTable' => '4',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'Opts',
			'FldEng' => 'Database Options',
			'FldDesc' => 'Indicates the multiple of various prime numbers which mark specific qualities of this Database.',
			'FldNotes' => '%3 Simple Field Specifications',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldNullSupport' => '0',
			'FldOperateSame' => '52'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10009,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldSpecSource' => '0',
			'FldName' => 'Database',
			'FldEng' => 'Table Database ID',
			'FldDesc' => 'Indicates the unique Database ID number which this Table belongs to.',
			'FldForeignTable' => '4',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10010,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Eng',
			'FldEng' => 'Table Name (in English)',
			'FldDesc' => 'Indicates the main, casual, name of the Database Table in English.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10011,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Name',
			'FldEng' => 'Table Name (in Database)',
			'FldDesc' => 'Indicates the shorter Table Name without spaces or special characters which is used to technically identify this Table when accessing its records in the Database. During system use, the Database\'s Prefix will be added to the start of the Table Name in this record.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10012,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Abbr',
			'FldEng' => 'Table Prefix',
			'FldDesc' => 'Indicates the short abbreviation which is used to start each Field Name within this Table. This is important for successfully creating and accessing all Table Fields.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10013,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'Desc',
			'FldEng' => 'Table Description',
			'FldDesc' => 'Indicates the full description of this Database Table. This should generally be a sentence or two describing what information is stored in a Table, why it is important, and perhaps why this information is being organized in the form of this Table. ',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10014,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'Notes',
			'FldEng' => 'Table Internal Notes',
			'FldDesc' => 'Indicates the any important Notes related to this Database Table. This can be important for providing documentation or other internal comments about how or why this Table was designed in this way.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldType' => 'TEXT',
			'FldDataLength' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10015,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'Group',
			'FldEng' => 'Table Group',
			'FldDesc' => 'Indicates which Group of Table this record belongs to. This can be important for visually organizing Tables, and works best if Tables in the same Table Group are all adjacent in the Table Order within the Database.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10016,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Type',
			'FldEng' => 'Table Type',
			'FldDesc' => 'Indicates whether this Database Table stores Data, Subset data, data Linkages, or data Validation. This is important for internal organization and documentation of the Database Design.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldValues' => 'Data;Subset;Linking;Validation',
			'FldDefault' => 'Data',
			'FldDataLength' => '25',
			'FldCharSupport' => ',Letters,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10017,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'Ord',
			'FldEng' => 'Table Sorting Order',
			'FldDesc' => 'Indicates the indexed order of this Table, relative to other Tables in the Database. This is only important for presenting the list of Tables to a Database Designer, and additional value can be added by using Table Groups.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10018,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '9',
			'FldSpecSource' => '0',
			'FldName' => 'Opts',
			'FldEng' => 'Table Options',
			'FldDesc' => 'Indicates the multiple of various prime numbers which mark specific qualities of this Table.',
			'FldNotes' => '%3 Table Has User-Defined Primary Key',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800',
			'FldOperateSame' => '52'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10019,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '10',
			'FldSpecSource' => '0',
			'FldName' => 'Extend',
			'FldEng' => 'Extension of Table',
			'FldDesc' => 'Indicates whether or not this Database Table is an extension of another Table. This means it inherits all of the other Table\'s fields, plus whatever you add here.',
			'FldForeignTable' => '9',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10020,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '11',
			'FldSpecSource' => '0',
			'FldName' => 'NumFields',
			'FldEng' => 'Total Fields',
			'FldDesc' => 'Indicates the cached total number of Fields which make up this Table.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10021,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '12',
			'FldSpecSource' => '0',
			'FldName' => 'NumForeignKeys',
			'FldEng' => 'Total Foreign Keys Outgoing',
			'FldDesc' => 'Indicates the cached total number of Foreign Fields in this Table which point to other Database Tables.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10022,
			'FldDatabase' => '3',
			'FldTable' => '9',
			'FldOrd' => '13',
			'FldSpecSource' => '0',
			'FldName' => 'NumForeignIn',
			'FldEng' => 'Total Foreign Keys Incoming',
			'FldDesc' => 'Indicates the cached total number of Foreign Fields in other Tables which point to this Database Table.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10023,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldSpecSource' => '0',
			'FldName' => 'Database',
			'FldEng' => 'Field Database ID',
			'FldDesc' => 'Indicates the unique Database ID number which this Field belongs to. This is important to track for generic fields which are not related to a specific Database Table.',
			'FldForeignTable' => '4',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10024,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Table',
			'FldEng' => 'Field Table ID',
			'FldDesc' => 'Indicates the unique Table ID number which this Field belongs to.',
			'FldNotes' => 'The parent table where this field is used. Only Generic fields have no table assigned. (Hernandez p.279)',
			'FldForeignTable' => '9',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10025,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Ord',
			'FldEng' => 'Field Sorting Order in Table',
			'FldDesc' => 'Indicates the indexed order of this Field, relative to other Fields within their Database Table. This is only important for presenting the list of Fields to a Database Designer.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10026,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Eng',
			'FldEng' => 'Field Name (in English)',
			'FldDesc' => 'Indicates the main, casual, name of the Database Field in English.',
			'FldNotes' => 'This label is an alternate name by which you can identify the field within an end-user application interface. Something readable. (Hernandez p.279)',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDataLength' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10027,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'Name',
			'FldEng' => 'Field Name (in Database)',
			'FldDesc' => 'Indicates the shorter Field Name without spaces or special characters which is used to technically identify this Field when accessing its stored values in the Database. During system use, the Table\'s Prefix will be added to the start of the Field Name in this record.',
			'FldNotes' => 'Absolute minimal words that uniquely identifies this field, following database requirements (like probably no spaces). The table abbreviation name will be tacked on to the beginning. (Hernandez p.277)',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10028,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'Desc',
			'FldEng' => 'Field Description',
			'FldDesc' => 'Indicates the full description of this Database Field. This should generally be a sentence or two describing what information is stored in this Field, and why it is important.',
			'FldNotes' => 'A complete interpretation of the field. Write a clear and succinct statement that accurately identifies the field and clearly states its purpose within the table. Avoid technical jargon, acronyms, abbreviations, and implementation-specific information. (Hernandez p.283)',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldType' => 'TEXT',
			'FldDataLength' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10029,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '9',
			'FldSpecSource' => '0',
			'FldName' => 'Notes',
			'FldEng' => 'Field Internal Notes',
			'FldDesc' => 'Indicates the any important Notes related to this Database Field. This can be important for providing documentation or other internal comments about how or why this Field was designed in this way, or where a list of potentially stored values came from.',
			'FldNotes' => 'Extra space for internal notes, often reserved for implementation-specific information, or planning in progress.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldType' => 'TEXT',
			'FldDataLength' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10030,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '18',
			'FldSpecSource' => '0',
			'FldName' => 'Type',
			'FldEng' => 'MySQL Data Type',
			'FldDesc' => 'Indicates which basic MySQL type of data will be stored with this Database Field. This is important for determining how to export the database or otherwise install it to MySQL-based environments.',
			'FldNotes' => 'MySQL implementation-specific field type, needed for one-click database structure export. <i>(NOT Hernandez approved planning.)</i>',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => 'VARCHAR',
			'FldDataLength' => '25',
			'FldCharSupport' => ',Letters,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10031,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '10',
			'FldSpecSource' => '0',
			'FldName' => 'ForeignTable',
			'FldEng' => 'Foreign Key Table ID',
			'FldDesc' => 'If this Field is a Foreign Key pointing to another Database Table, then this is where that unique Table ID is stored. This is important for tracking data linkages through the Database Design.',
			'FldForeignTable' => '9',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '11',
			'FldDefault' => '-3',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10032,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '14',
			'FldSpecSource' => '0',
			'FldName' => 'Foreign2Max',
			'FldEng' => 'Degree of Participation: Incoming Max',
			'FldDesc' => 'If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the maximum number of a Foreign Table\'s records which can be related to a single record of this Table. This is important for documenting and enforcing logical limitations designed with the Database.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '1',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '11',
			'FldCharSupport' => ',Numbers,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10033,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '11',
			'FldSpecSource' => '0',
			'FldName' => 'ForeignMin',
			'FldEng' => 'Degree of Participation: Outgoing Min',
			'FldDesc' => 'If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the minimum number of this Table\'s records which can be related to a single record of the Foreign Table. This is important for documenting and enforcing logical limitations designed with the Database.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '1',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '11',
			'FldCharSupport' => ',Numbers,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10034,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '12',
			'FldSpecSource' => '0',
			'FldName' => 'ForeignMax',
			'FldEng' => 'Degree of Participation: Outgoing Max',
			'FldDesc' => 'If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the maximum number of this Table\'s records which can be related to a single record of the Foreign Table. This is important for documenting and enforcing logical limitations designed with the Database.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '1',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '11',
			'FldCharSupport' => ',Numbers,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10035,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '13',
			'FldSpecSource' => '0',
			'FldName' => 'Foreign2Min',
			'FldEng' => 'Degree of Participation: Incoming Min',
			'FldDesc' => 'If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the minimum number of a Foreign Table\'s records which can be related to a single record of this Table. This is important for documenting and enforcing logical limitations designed with the Database.',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '1',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '11',
			'FldCharSupport' => ',Numbers,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10036,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '15',
			'FldSpecSource' => '0',
			'FldName' => 'Values',
			'FldEng' => 'Field Values',
			'FldDesc' => 'Storing information here indicates that this Database Field can only be set to a specified range of values, separated by semi-colons. (* This field needs to be replaced by a helper table which stores each value as its own record, or perhaps preferably using the Definitions table. *)',
			'FldNotes' => 'Specifies every possible valid value for a field. You can optionally select a pre-definined value set which is common among various fields. (Hernandez p.294)',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10037,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '17',
			'FldSpecSource' => '0',
			'FldName' => 'IsIndex',
			'FldEng' => 'Is Indexed',
			'FldDesc' => 'Indicates whether or not this Field is to be indexed by the Database for faster searching of this specific field. This is important for ideal Database creation.',
			'FldNotes' => 'When this project is finished, will this field be searched or sorted very very often? A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. <i>(NOT Hernandez approved planning.)</i>',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldValues' => '0;1',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10038,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '16',
			'FldSpecSource' => '0',
			'FldName' => 'Default',
			'FldEng' => 'Default Value',
			'FldDesc' => 'Indicates the default value for this specific Field, when a new Table record is first created.',
			'FldNotes' => 'A value that a user can into a field when a more appropriate value is not yet available, nulls not allowed. Use a default value ONLY if it is meaningful. (Hernandez p.294)',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDataLength' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10039,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'SpecType',
			'FldEng' => 'Field Specification Type',
			'FldDesc' => 'Indicates whether this Database Field specification is Unique Field to this Table\'s instance, or is a Replica Field of a Generic Field shared by multiple Tables, or is itself a Generic Field. This can be important for documenting which Fields might need to maintain parallel changes in their specifications.',
			'FldNotes' => 'Unique - any kind of field that will appear only once within the entire database or a primary key; Generic - a field that serves as a template for other fields within the database; Replica - a field that you base on a given generic field or a foreign key; (Hernandez p.279)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Unique;Generic;Replica',
			'FldDefault' => 'Unique',
			'FldDataLength' => '10',
			'FldCharSupport' => ',Letters,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10040,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'SpecSource',
			'FldEng' => 'Field Spec Generic Source',
			'FldDesc' => 'If this record specification type indicates that it stores a Replica Field, then this information represents the unique Field ID of related the Generic Field.',
			'FldNotes' => 'If this field is a Replica, the Specification Source is set to the Generic field which it mimics. To turn this field into a Replica, select a Generic field from the dropdown and click the Load link. To save a copy of this field as a Generic for future reuse, click the Save As Generic link. (Hernandez p.281)',
			'FldForeignTable' => '10',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldDefault' => '-3',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10041,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'Alias',
			'FldEng' => 'Field Alias(es)',
			'FldDesc' => 'Indicates any other names this specific Field might be known as.',
			'FldNotes' => 'A name (or set of names) that you use for the field in very rare circumstances. This must be used if there are two occurrences of this field in the same table. (Hernandez p.281)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10042,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '19',
			'FldSpecSource' => '0',
			'FldName' => 'DataType',
			'FldEng' => 'Basic Data Type',
			'FldDesc' => 'Indicates the most basic nature of the data being stored by this Field, whether .',
			'FldNotes' => 'The most basic nature of the data that this field stores (not implementation-specific). (Hernandez p.286)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Alphanumeric;Numeric;DateTime',
			'FldDefault' => 'Alphanumeric',
			'FldDataLength' => '20',
			'FldCharSupport' => ',Letters,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10043,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '20',
			'FldSpecSource' => '0',
			'FldName' => 'DataLength',
			'FldEng' => 'Data Length',
			'FldDesc' => 'Indicates the total number of characters or digits that a user can enter for any stored value in this Database Field. This is important for ideal Database creation.',
			'FldNotes' => 'The total number of characters or digits that a user can enter for any given value of this field. If otherwise unimportant, this can be set to the maximum length for the best implementation-specific data type. (Hernandez p.289)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10044,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '21',
			'FldSpecSource' => '0',
			'FldName' => 'DataDecimals',
			'FldEng' => 'Data Decimal Places',
			'FldDesc' => 'If this Field\'s basic data type is numeric, then this denotes the number of digits to the right of the decimal point in real numbers which can be stored in this Database Field.',
			'FldNotes' => 'If this field is Numeric, this denotes the number of digits to the right of the decimal point in a real number (eg. MySQL DOUBLE). (Hernandez p.289)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10045,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '22',
			'FldSpecSource' => '0',
			'FldName' => 'CharSupport',
			'FldEng' => 'Character Support',
			'FldDesc' => 'Indicates the type of characters that a user can enter as a value for this Database Field. (* Multiple character types are currently stored as comma separated strings, but this should probably be some cleaner method. *)',
			'FldNotes' => 'The type of characters that a user can enter as a value for this field. Setting and enforcing this helps you ensure that the user cannot introduce meaningless data into the field, enhancing field-level integrity. Letters include foreign language letters. (Hernandez p.289)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Letters;Numbers;Keyboard;Special',
			'FldDefault' => ',Letters,Numbers,Keyboard,Special,',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Keyboard,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10046,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '23',
			'FldSpecSource' => '0',
			'FldName' => 'InputMask',
			'FldEng' => 'Input Mask',
			'FldDesc' => 'Specifies the manner in which a user should enter data into this field. eg. YYYY-MM-DD',
			'FldNotes' => 'Specifies the manner in which a user should enter data into this field. eg. YYYY-MM-DD (Hernandez p.290)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10047,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '24',
			'FldSpecSource' => '0',
			'FldName' => 'DisplayFormat',
			'FldEng' => 'Display Format',
			'FldDesc' => 'Indicates the appearance of this Database Field\'s value when it is displayed on a screen or printed within a document.',
			'FldNotes' => 'The appearance of this field\'s value when it is displayed on a screen or printed within a document. (Hernandez p.291)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10048,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '25',
			'FldSpecSource' => '0',
			'FldName' => 'KeyType',
			'FldEng' => 'Key Type',
			'FldDesc' => 'Indicates whether or not this Field is some kind of Key in its parent Database Table, including Foreign Keys, Primary Keys, or Alternate Keys. By default, all SurvLoop Tables will automatically generate a Unique, Primary Key if no such Field is specified by the Database Designer. (* Multiple key types are currently stored as comma separated strings, but this should probably be some cleaner method. *)',
			'FldNotes' => 'Designates this field\'s role within a table. (Hernandez p.292)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Non;Foreign;Primary;Alternate',
			'FldDefault' => ',Non,',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Keyboard,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10049,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '26',
			'FldSpecSource' => '0',
			'FldName' => 'KeyStruct',
			'FldEng' => 'Key Structure',
			'FldDesc' => 'If this Database Field is a Primary Key, then this indicates whether it is acting as a simple (single-field) primary key or as part of a composite (multi-field) primary key.',
			'FldNotes' => 'Denotes whether this field designated as a primary key is acting as a simple (single-field) primary key or as part of a composite (multi-field) primary key. (Hernandez p.292)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Simple;Composite',
			'FldDataLength' => '10',
			'FldCharSupport' => ',Letters,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10050,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '27',
			'FldSpecSource' => '0',
			'FldName' => 'EditRule',
			'FldEng' => 'Edit Rule',
			'FldDesc' => 'Indicates whether or not a Field\'s data can or must be store at the Table record\'s creation, and whether or not it can it be edited by Users later.',
			'FldNotes' => 'Enter Now - user must enter a value when creating a new table record; Enter Later - user has the option of entering value when creating table record; Edits Allowed - user can edit the value at any time; Edits Not Allowed - after entering a value, user cannot edit it at any time; (Hernandez p.295)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'NowAllowed;LateAllow;NowNot;LateNot;NotDeterm',
			'FldDefault' => 'LateAllow',
			'FldDataLength' => '10',
			'FldCharSupport' => ',Letters,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10051,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '28',
			'FldSpecSource' => '0',
			'FldName' => 'Unique',
			'FldEng' => 'Has Unique Value',
			'FldDesc' => 'Indicates whether this Database Field\'s values are unique across all Table records.',
			'FldNotes' => 'Indicates whether this field\'s values are unique (always for primary keys, rarely for everything else). (Hernandez p.292)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10052,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '29',
			'FldSpecSource' => '0',
			'FldName' => 'NullSupport',
			'FldEng' => 'Has NULL Support',
			'FldDesc' => 'Indicates whether or not this Database Field accepts NULL values to be stored, which should represent missing or unknown information.',
			'FldNotes' => 'Whether this field accepts null values (not allowed for primary keys). Null values should represent missing or unknown values. (Hernandez p.293)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10053,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '30',
			'FldSpecSource' => '0',
			'FldName' => 'ValuesEnteredBy',
			'FldEng' => 'Values Entered By',
			'FldDesc' => 'Indicates whether a User or the System enter information into this Database Field.',
			'FldNotes' => 'The source of this field\'s value. Either a user will enter values into the field manually or a database application program will enter them automatically. (Hernandez p.293)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'User;System',
			'FldDefault' => 'User',
			'FldDataLength' => '10',
			'FldCharSupport' => ',Letters,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10054,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '31',
			'FldSpecSource' => '0',
			'FldName' => 'Required',
			'FldEng' => 'Is Required',
			'FldDesc' => 'Indicates whether or not a User is required to enter a value for this Database Field.',
			'FldNotes' => 'Whether a user is required to enter a value for this field. No for most non-primary-key fields. (Hernandez p.294)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10055,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '33',
			'FldSpecSource' => '0',
			'FldName' => 'CompareOther',
			'FldEng' => 'Compare Other Field Value',
			'FldDesc' => 'Indicates the types of comparisons can be applied to a given field value when retrieving information from the other Fields in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.',
			'FldNotes' => 'The types of comparisons a user/system can apply to a given field value when retrieving information from the field. (Hernandez p.296)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10056,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '32',
			'FldSpecSource' => '0',
			'FldName' => 'CompareSame',
			'FldEng' => 'Compare Same Field Value',
			'FldDesc' => 'Indicates the types of comparisons can be applied to a given field value when retrieving information from the same Field in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.',
			'FldNotes' => 'The types of comparisons a user/system can apply to a given field value when retrieving information from the field. (Hernandez p.296)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '878800',
			'FldOperateSame' => '52'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10057,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '34',
			'FldSpecSource' => '0',
			'FldName' => 'CompareValue',
			'FldEng' => 'Compare Other Values',
			'FldDesc' => 'Indicates the types of comparisons can be applied to a given field value when retrieving information from the other values generally. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.',
			'FldNotes' => 'The types of comparisons a user/system can apply to a given field value when retrieving information from the field. (Hernandez p.296)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10058,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '35',
			'FldSpecSource' => '0',
			'FldName' => 'OperateSame',
			'FldEng' => 'Operate with Same Field Value',
			'FldDesc' => 'Indicates the types of operations which can be applied to a given Field value with the same Field in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.',
			'FldNotes' => 'Specifies the types of operations that a user can perform on the values. (Hernandez p.298)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10059,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '36',
			'FldSpecSource' => '0',
			'FldName' => 'OperateOther',
			'FldEng' => 'Operate with Other Field Value',
			'FldDesc' => 'Indicates the types of operations which can be applied to a given Field value with the other Fields in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.',
			'FldNotes' => 'Specifies the types of operations that a user can perform on the values. (Hernandez p.298)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10060,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '37',
			'FldSpecSource' => '0',
			'FldName' => 'OperateValue',
			'FldEng' => 'Operate with Other Value',
			'FldDesc' => 'Indicates the types of operations which can be applied to a given Field value with the other values generally. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed.',
			'FldNotes' => 'Specifies the types of operations that a user can perform on the values. (Hernandez p.298)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10061,
			'FldDatabase' => '3',
			'FldTable' => '10',
			'FldOrd' => '38',
			'FldSpecSource' => '0',
			'FldName' => 'Opts',
			'FldEng' => 'Field Options',
			'FldDesc' => 'Indicates the multiple of various prime numbers which mark other specific qualities of this Field.',
			'FldNotes' => '%3 Field Is Auto-Managed by SurvLoop; | %1 XML Public Data; %7 XML Private Data; %11 XML Sensitive Data; %13 XML Internal Use Data;',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10062,
			'FldDatabase' => '3',
			'FldTable' => '7',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Set',
			'FldEng' => 'Set',
			'FldDesc' => 'This is a label for a set of system information which may need to be periodically changed by a system Administrator without the technical assistance of a programmer. Important for categorizing these dynamically stored system definitions.',
			'FldNotes' => 'Potential for multiple languages in the future?',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Def::SurvLoop Definition Types',
			'FldDefault' => 'Value Ranges',
			'FldDataLength' => '20',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10063,
			'FldDatabase' => '3',
			'FldTable' => '7',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Subset',
			'FldEng' => 'Subset',
			'FldDesc' => 'This is a label for a subset of system information which may need to be periodically changed by a system Administrator without the technical assistance of a programmer. Important for categorizing these dynamically stored system Definitions.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10064,
			'FldDatabase' => '3',
			'FldTable' => '7',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'IsActive',
			'FldEng' => 'Is Active',
			'FldDesc' => 'Indicates whether or not this Database Definition is currently active in the system. This is important for disabling Definitions from the system without deleting them, either temporarily or permanently.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10065,
			'FldDatabase' => '3',
			'FldTable' => '7',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Order',
			'FldEng' => 'Sorting Order in Subset',
			'FldDesc' => 'Indicates the indexed order of this Definition, relative to other Definitions within their Set and Subset of categorization. This is particularly important for providing order to the range of potential response values presented to Users.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10066,
			'FldDatabase' => '3',
			'FldTable' => '7',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'Value',
			'FldEng' => 'Value',
			'FldDesc' => 'The dynamically stored text or value which Administrators can manage with a programmer. In the case of Value Ranges, this value is what a User will see, but the unique Definition ID will be stored as the User\'s response.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10067,
			'FldDatabase' => '3',
			'FldTable' => '7',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Description',
			'FldEng' => 'Description',
			'FldDesc' => 'The optional descriptive notes providing a deeper explanation of this specific Definition. For Value Ranges, this could also provide references and sources regarding the decision to include this Definition. Important for internal documentation and possibly User education.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10068,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Database',
			'FldEng' => 'Rule Database ID',
			'FldDesc' => 'Indicates the unique Database ID number which this Business Rule belongs to.',
			'FldForeignTable' => '4',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10069,
			'FldDatabase' => '3',
			'FldTable' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'Database',
			'FldEng' => 'Definition Database ID',
			'FldDesc' => 'Indicates the unique Database ID number which this Definition belongs to.',
			'FldForeignTable' => '4',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10070,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Statement',
			'FldEng' => 'Rule Statement',
			'FldDesc' => 'Indicates the text of the business rule itself, clear, succinct, and convey the required constraints in simple English.',
			'FldNotes' => 'The text of the business rule itself, clear, succinct, and convey the required constraints. (Hernandez p.409)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10071,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Constraint',
			'FldEng' => 'Rule Constraint',
			'FldDesc' => 'Indicates how the constraint specifically applies to the Database Tables and Fields, intended for a more technical audience.',
			'FldNotes' => 'A brief explanation of how the constraint applies to the tables and fields. (Hernandez p.409)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10072,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'IsAppOrient',
			'FldEng' => 'Is Implemented In Application',
			'FldDesc' => 'Indicates whether or not this Business Rule can be directly implemented within the logical design of the database (Database-Oriented). Application-Oriented Rules will have to be implemented with custom coding, outside the scope of SurvLoop\'s automation.',
			'FldNotes' => 'Database-Oriented: impose constraints that you can establish within the logical design of the database; Application-Oriented: impose constraints that you cannot establish within the logical design of the database. (Hernandez p.397)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10073,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'IsRelation',
			'FldEng' => 'Is Relationship-Specific',
			'FldDesc' => 'Indicates whether or not this Business Rule provides additional specifications to a Database Field in isolation, or to a Relationship multiple Fields or Tables.',
			'FldNotes' => 'Field-Specific and Relationship-Specific rules can be established in field specifications, but more details may be provided here if needed. (Hernandez p.399)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10074,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'TestOn',
			'FldEng' => 'Test Rule On',
			'FldDesc' => 'Indicates when the imposed Rule should be tested, whether upon inserting a new Table record, deleting a record, or updating a Field\'s value.',
			'FldNotes' => 'The constraint imposed should be tested when you attempt to perform: Inserting a record into the table or an entry into a field, Deleting a record from the table or a value within a field, or Updating a field\'s value. (Hernandez p.408)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Insert;Update;Delete',
			'FldDefault' => 'Insert',
			'FldDataLength' => '10',
			'FldCharSupport' => ',Letters,',
			'FldKeyType' => ',',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10075,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Tables',
			'FldEng' => 'Rule Tables',
			'FldDesc' => 'Indicates a comma-separated list of unique Table IDs which this Rule will affect. (* This should be moved to a different data structure. *)',
			'FldNotes' => 'Designate the name of the field(s) and table(s) the rule will affect. (Hernandez p.410)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => ',',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10076,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'Fields',
			'FldEng' => 'Rule Fields',
			'FldDesc' => 'Indicates a comma-separated list of unique Table IDs which this Rule will affect. (* This should be moved to a different data structure. *)',
			'FldNotes' => 'Designate the name of the field(s) and table(s) the rule will affect. (Hernandez p.410)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => ',',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10077,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'Phys',
			'FldEng' => 'Physical Elements Affected',
			'FldDesc' => 'Indicates the multiple of various prime numbers which represent physical data specifications related to this Rule, including Data Type, Length, Decimal Places, Character Support, Input Mask, and Display Format.
    ',
			'FldNotes' => '%2 Data Type, %3 Length, %5 Decimal Places, %7 Character Support, %11 Input Mask, %13 Display Format',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10078,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '9',
			'FldSpecSource' => '0',
			'FldName' => 'Logic',
			'FldEng' => 'Logical Elements Affected',
			'FldDesc' => 'Indicates the multiple of various prime numbers which represent logical data specifications related to this Rule, including Key Type, Key Structure, Uniqueness, Null Support, Values Entered By, Required Value, Default Value, Range of Values, Comparisons Allowed, Operations Allowed, and Edit Rule.',
			'FldNotes' => '%2 Key Type, %3 Key Structure, %5 Uniqueness, %7 Null Support, %11 Values Entered By, %13 Required Value, %17 Default Value, %19 Range of Values, %23 Comparisons Allowed, %29 Operations Allowed, %31 Edit Rule',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldOperateSame' => '52'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10079,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '10',
			'FldSpecSource' => '0',
			'FldName' => 'Rel',
			'FldEng' => 'Relationship Characteristics Affected',
			'FldDesc' => 'Indicates the multiple of various prime numbers which represent data relation specifications related to this Rule, including Deletion Rule, Type of Participation, Degree of Participation.',
			'FldNotes' => '%2 Deletion Rule, %3 Type of Participation, %5 Degree of Participation',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10080,
			'FldDatabase' => '3',
			'FldTable' => '6',
			'FldOrd' => '11',
			'FldSpecSource' => '0',
			'FldName' => 'Action',
			'FldEng' => 'Action Taken',
			'FldDesc' => 'Indicates what actions have been taken, or need to be taken, to implement and enforce this Business Rule.',
			'FldNotes' => 'Indicate the modifications made to field specifications, etc, as clearly as possible. (Hernandez p.)',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10081,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'Database',
			'FldEng' => 'Primary Database ID',
			'FldDesc' => 'Indicates the unique Database ID number which this User Experience primarily belongs to.',
			'FldForeignTable' => '4',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10082,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'User',
			'FldEng' => 'Tree Owner User ID',
			'FldDesc' => 'Indicates the unique User ID number belonging to the owner of this User Experience or Tree.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10083,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Type',
			'FldEng' => 'Tree Type',
			'FldDesc' => 'Indicates whether this Tree (collection of Nodes) indeed maps out a User Experience, or if it provides a map of the Database Design for the creating XML documents automatically-generated by SurvLoop.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Primary Public;Primary Public XML',
			'FldDefault' => 'Primary Public',
			'FldDataLength' => '30',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10084,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Name',
			'FldEng' => 'Tree Name',
			'FldDesc' => 'Indicates the most succinct and clear name internally used to refer to this specific Tree.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10085,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'Desc',
			'FldEng' => 'Tree Description',
			'FldDesc' => 'Documents a longer description of the purpose, use, and importance of this specific Tree.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10086,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'Slug',
			'FldEng' => 'Tree URL',
			'FldDesc' => 'Indicates the URL for the starting page of this Tree.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10087,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Root',
			'FldEng' => 'Root Node ID',
			'FldDesc' => 'Indicates the unique Experience Node ID of the first, Root Node of this entire User Experience. All other Nodes within this Tree are descendants of the Root Node.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10088,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'FirstPage',
			'FldEng' => 'First Page Node ID',
			'FldDesc' => 'Stores a cache of the unique Experience Node ID of this Tree\'s first Node which is a Page. This helps to quickly identify the URL of the first Page the user will experience.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10089,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'LastPage',
			'FldEng' => 'Last Page Node ID',
			'FldDesc' => 'Stores a cache of the unique Experience Node ID of this Tree\'s last Node which is a Page. This helps to quickly identify the URL of the final Page the user will experience.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10090,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '9',
			'FldSpecSource' => '0',
			'FldName' => 'CoreTable',
			'FldEng' => 'Tree Core Data Table',
			'FldDesc' => 'Indicates the unique Table ID which acts as the backbone for all data collected throughout this entire Tree.',
			'FldForeignTable' => '9',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10091,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldSpecSource' => '0',
			'FldName' => 'Tree',
			'FldEng' => 'Node Tree ID',
			'FldDesc' => 'Indicates the unique Tree ID number which this Tree Node belongs to.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10092,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'ParentID',
			'FldEng' => 'Parent Node ID',
			'FldDesc' => 'Indicates the unique Experience Node ID of this Node\'s parent Node. This linkage is the thread which connect all Nodes as branches of the entire Experience Tree.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldDefault' => '-3',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10093,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'ParentOrder',
			'FldEng' => 'Sibling Node Sorting Order',
			'FldDesc' => 'Indicates the indexed order of this Experience Node, relative to sibling Nodes which share the same Parent Node. This is how the branches of the entire Experience Tree stay sorted.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10094,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Type',
			'FldEng' => 'Node Type',
			'FldDesc' => 'Indicates whether this Experience Node represents either a branch (for navigation), a specific question to the User, a collection of questions as one page, a loop of many pages, or a specific manipulation of previously stored data. Question Nodes include Instructions, Radio, Checkbox, Drop Down, Text, Long Text, Text:Number, Email, Password, Date, Date Picker, Date Time, Time, Gender, Gender Not Sure, Feet Inches, U.S. States, Hidden Field, Spambot Honey Pot, Uploads, and Other/Custom. Nodes which are part of Trees which map XML output are of a separate XML Type.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Page;Branch Title;Loop Root;Data Manip: New;Data Manip: Update;Data Manip: Wrap;Instructions;Radio;Checkbox;Drop Down;Text;Long Text;Text:Number;Email;Password;Date;Date Picker;Date Time;Time;Gender;Gender Not Sure;Feet Inches;U.S. States;Hidden Field;Spambot Honey Pot;Uploads;Other/Custom;XML',
			'FldDataLength' => '25',
			'FldKeyType' => ',',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10095,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'PromptText',
			'FldEng' => 'Node Question/Prompt To User',
			'FldDesc' => 'Indicates the language used to prompt a User Response. For special Node Types like branches, pages, and loop roots, this field stores a title or name. For XML Nodes, this fields stores the name of the Database Table included in the mapped.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10096,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'PromptNotes',
			'FldEng' => 'Node Side-Notes To User',
			'FldDesc' => 'Indicates the language used to prompt a User Response. For special Node Types like branches, pages, and loop roots, this field stores the Node\'s URL slug. For XML Nodes, this fields stores the unique Table ID of the Database Table included in the mapped.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10097,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'PromptAfter',
			'FldEng' => 'Extra HTML After Node Response',
			'FldDesc' => 'Stores any extra HTML, CSS, or JavaScript which a Database Designer wants to appear directly after the User\'s opportunity to Respond to a Node\'s Prompt.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10098,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'InternalNotes',
			'FldEng' => 'Internal Notes',
			'FldDesc' => 'Stores any internal notes which Experience Designers want to share.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10099,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'ResponseSet',
			'FldEng' => 'User Response Set',
			'FldDesc' => 'Indicates the range of options the User will be provided for Node which ask some kind of multiple-choice question. This includes "Definition::{DefSubset}", "LoopItems::{LoopName}", or "[Set:{TableName};;HideIf:1]", but most Question Nodes have Response Options stored in the Node Responses table.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10100,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '9',
			'FldSpecSource' => '0',
			'FldName' => 'Default',
			'FldEng' => 'Default Response Value',
			'FldDesc' => 'Indicates if any of the Response options should be pre-selected when this Node loads for the User.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10101,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '10',
			'FldSpecSource' => '0',
			'FldName' => 'DataBranch',
			'FldEng' => 'Node Data Branch',
			'FldDesc' => 'Indicates the name of the Database Table as a point of reference for this Node\'s data interactions, and all of its descendants.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Table ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10102,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '11',
			'FldSpecSource' => '0',
			'FldName' => 'DataStore',
			'FldEng' => 'Node Data Field',
			'FldDesc' => 'Indicates the Database Table and Field where the User\'s Response will actually be stored.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Field ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldInputMask' => '{TableName}:{TableAbbr}{FieldName}',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10103,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '12',
			'FldSpecSource' => '0',
			'FldName' => 'TextSuggest',
			'FldEng' => 'Response Text Suggest',
			'FldDesc' => 'Indicates an optional setting to suggest a response or instruction within this Node\'s open-ended form field.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10104,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '13',
			'FldSpecSource' => '0',
			'FldName' => 'CharLimit',
			'FldEng' => 'Response Character Limit',
			'FldDesc' => 'Indicates the maximum number of characters a User may enter in Response to this Node\'s prompt.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10105,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '16',
			'FldSpecSource' => '0',
			'FldName' => 'Opts',
			'FldEng' => 'Node Options',
			'FldDesc' => 'Indicates the multiple of various prime numbers which mark specific other qualities of this Node.',
			'FldNotes' => 'For XML Nodes... %5 Include members with parent, without table wrap; %7 Min 1 Record; %11 Max 1 Record; | For Other Nodes... %2 Customize Layout; %13 \'Required\' Displayed On Separate Line; %29 Exit Page; %31 Show Word Count; %37 Wrap In Jumbotron Style; %41 Echo Response Edits To Div; %43 Toggle Child Nodes On Click; %47 Limit Word Count; %53 Dropdown Tagger; %59 Hide Progress Bar; %61 Responses In Columns; %67 Skinny Content Width; %71 Content Block Background; %73 Leave Existing Rows\' Records; %79 After Response Selected, Hide Other Options; %83 Show After Pressing Info Button; %89 Wrap in Card Element; %97 Defer Loading of Node Contents',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldOperateSame' => '52'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10106,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '15',
			'FldSpecSource' => '0',
			'FldName' => 'Dislikes',
			'FldEng' => 'Node Dislikes',
			'FldDesc' => 'For some systems, this indicates how many Users responded to this Node with "a dislike".',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10107,
			'FldDatabase' => '3',
			'FldTable' => '15',
			'FldOrd' => '14',
			'FldSpecSource' => '0',
			'FldName' => 'Likes',
			'FldEng' => 'Node Likes',
			'FldDesc' => 'For some systems, this indicates how many Users responded to this Node with "a like".',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10108,
			'FldDatabase' => '3',
			'FldTable' => '16',
			'FldSpecSource' => '0',
			'FldName' => 'Node',
			'FldEng' => 'Response Node ID',
			'FldDesc' => 'Indicates the unique Experience Node ID number which this Node Response belongs to.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10109,
			'FldDatabase' => '3',
			'FldTable' => '16',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Ord',
			'FldEng' => 'Response Sorting Order',
			'FldDesc' => 'Indicates the indexed order of this Node Response, relative to other Response options for this Experience Node.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10110,
			'FldDatabase' => '3',
			'FldTable' => '16',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Eng',
			'FldEng' => 'Response Description',
			'FldDesc' => 'Describes this Node Response option clearly in English for the User.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10111,
			'FldDatabase' => '3',
			'FldTable' => '16',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Value',
			'FldEng' => 'Response Stored Value',
			'FldDesc' => 'Indicates how a User selection of this Node Response option should be stored in the Database.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10112,
			'FldDatabase' => '3',
			'FldTable' => '16',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'ShowKids',
			'FldEng' => 'Show Child Node If Selected',
			'FldDesc' => 'Indicates whether or not child Nodes should be revealed to the User upon selecting this specific Node Response option.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '11',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10113,
			'FldDatabase' => '3',
			'FldTable' => '11',
			'FldSpecSource' => '0',
			'FldName' => 'Database',
			'FldEng' => 'Condition Database ID',
			'FldDesc' => 'Indicates the unique Database ID number which this Condition can be applied to.',
			'FldForeignTable' => '4',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10114,
			'FldDatabase' => '3',
			'FldTable' => '11',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Tag',
			'FldEng' => 'Condition Tag/Name',
			'FldDesc' => 'Indicates the short name, like a hashtag on social media, which is used both internally and publicly to easily identify this Condition/Filter.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldInputMask' => '#AAAAAAAAA',
			'FldDisplayFormat' => '#AAAAAAAAA',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10115,
			'FldDatabase' => '3',
			'FldTable' => '11',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Desc',
			'FldEng' => 'Condition Description',
			'FldDesc' => 'Describes this Condition/Filter in English, as accurately and succinctly as possible, for both internal and public use.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10116,
			'FldDatabase' => '3',
			'FldTable' => '11',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Operator',
			'FldEng' => 'Condition Operator',
			'FldDesc' => 'Indicates what type of testing to do as part of applying this Data Condition. This includes checking for User Responses within a specified range of values ( "{" ), outside a specified range of values ( "}" ), checking the number of records a Database Table has ( "EXISTS>" ), or "CUSTOM".',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '{',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10117,
			'FldDatabase' => '3',
			'FldTable' => '11',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'OperDeet',
			'FldEng' => 'Condition Operator Details',
			'FldDesc' => 'Indicates qualifying details to further specify this operator\'s requirements for this Condition. For "EXISTS>" Conditions, this stores the maximum number of Table records which can exist while passing this Condition as FALSE.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10118,
			'FldDatabase' => '3',
			'FldTable' => '11',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'Field',
			'FldEng' => 'Database Field ID',
			'FldDesc' => 'Indicates the unique Field ID number for the data being tested in this Database Condition.',
			'FldForeignTable' => '10',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10119,
			'FldDatabase' => '3',
			'FldTable' => '11',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Table',
			'FldEng' => 'Database Table ID',
			'FldDesc' => 'Indicates the unique Table ID number for the data being tested in this Database Condition.',
			'FldForeignTable' => '9',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10120,
			'FldDatabase' => '3',
			'FldTable' => '11',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'Loop',
			'FldEng' => 'Data Loop ID',
			'FldDesc' => 'Indicates the unique Data Loop ID number for the data being tested in this Database Condition.',
			'FldForeignTable' => '24',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10121,
			'FldDatabase' => '3',
			'FldTable' => '11',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'Opts',
			'FldEng' => 'Condition Options',
			'FldDesc' => 'Indicates the multiple of various prime numbers which mark any other specific qualities of this Condition.',
			'FldNotes' => '%2 For Public Use In Filter Defaults; %3 Is Linked With Article(s);',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldOperateSame' => '52'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10122,
			'FldDatabase' => '3',
			'FldTable' => '14',
			'FldSpecSource' => '0',
			'FldName' => 'CondID',
			'FldEng' => 'Value Condition ID',
			'FldDesc' => 'Indicates the unique Condition ID number which this Value option relates to.',
			'FldForeignTable' => '11',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10123,
			'FldDatabase' => '3',
			'FldTable' => '14',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Value',
			'FldEng' => 'Value Description',
			'FldDesc' => 'Indicates the actual User Response Value, which would be stored in the Database, associated with the  Condition related to this record.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10124,
			'FldDatabase' => '3',
			'FldTable' => '13',
			'FldSpecSource' => '0',
			'FldName' => 'CondID',
			'FldEng' => 'Condition ID',
			'FldDesc' => 'Indicates the unique Condition ID number of the Condition being applied to an Experience Node or a Data Loop.',
			'FldForeignTable' => '11',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10125,
			'FldDatabase' => '3',
			'FldTable' => '13',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'NodeID',
			'FldEng' => 'Experience Node ID',
			'FldDesc' => 'Indicates the unique Experience Node ID number which this Condition has been applied to.',
			'FldForeignTable' => '13',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10126,
			'FldDatabase' => '3',
			'FldTable' => '13',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'LoopID',
			'FldEng' => 'Data Loop ID',
			'FldDesc' => 'Indicates the unique Data Loop ID number which this Condition has been applied to.',
			'FldForeignTable' => '24',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10127,
			'FldDatabase' => '3',
			'FldTable' => '12',
			'FldSpecSource' => '0',
			'FldName' => 'CondID',
			'FldEng' => 'Article Condition ID',
			'FldDesc' => 'Indicates the unique Condition ID number of the Condition being associated with complementary information.',
			'FldForeignTable' => '12',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10128,
			'FldDatabase' => '3',
			'FldTable' => '12',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'URL',
			'FldEng' => 'Article URL',
			'FldDesc' => 'Indicates the URL of an Article which provides more information for Users with completed submissions meeting this related Condition/Filter.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10129,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldSpecSource' => '0',
			'FldName' => 'Tree',
			'FldEng' => 'Data Loop Experience ID',
			'FldDesc' => 'Indicates the unique Experience ID number of the User Experience for which this Data Loop is required.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10130,
			'FldDatabase' => '3',
			'FldTable' => '26',
			'FldSpecSource' => '0',
			'FldName' => 'Tree',
			'FldEng' => 'Data Link Experience ID',
			'FldDesc' => 'Indicates the unique Experience ID number of the User Experience for which this Data Subset is required.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10131,
			'FldDatabase' => '3',
			'FldTable' => '27',
			'FldSpecSource' => '0',
			'FldName' => 'Tree',
			'FldEng' => 'Data Link Experience ID',
			'FldDesc' => 'Indicates the unique Experience ID number of the User Experience for which this Data Helper is required.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10132,
			'FldDatabase' => '3',
			'FldTable' => '25',
			'FldSpecSource' => '0',
			'FldName' => 'Tree',
			'FldEng' => 'Data Link Experience ID',
			'FldDesc' => 'Indicates the unique Experience ID number of the User Experience for which this Data Link is required.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10133,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Root',
			'FldEng' => 'Root Node ID',
			'FldDesc' => 'Indicates the unique Node ID number of this Data Loop\'s Root Node. All of the descendants of this Data Loop\'s Root will be repeated until the User wants to continue past it, or Loop\'s constraints are exceeded.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10134,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Plural',
			'FldEng' => 'Plural Name For Items In Loop',
			'FldDesc' => 'Indicates the way to describe multiple Items in this Data Loop (eg. "Witnesses"). This is also the primary name for this Data Loop, so its value should be unique within each Database.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10135,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Singular',
			'FldEng' => 'Singular Name For Items In Loop',
			'FldDesc' => 'Indicates the way to describe multiple Items in this Data Loop (eg. "Witness").',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10136,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'Table',
			'FldEng' => 'Data Loop Core Table',
			'FldDesc' => 'Indicates the name of the Database Table whose records will either be looped through, or created during this Data Loop.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Table ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10137,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'SortFld',
			'FldEng' => 'Data Sort Field',
			'FldDesc' => 'Indicates the full Database Field name ( "{TableAbbr}{FldName}" ) to be used for sorting Table records as Data Loop Items.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Field ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10138,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'DoneFld',
			'FldEng' => 'Loop Completed Field',
			'FldDesc' => 'Indicates the full Database Table and Field address ( "{TableName}:{TableAbbr}{FldName}" ) to be checked signifying that the User has successfully completed the Data Loop for a given Item.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Field ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10139,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'MaxLimit',
			'FldEng' => 'Maximum Loop Items',
			'FldDesc' => 'Indicates how many Data Loop Items/Records the User is allowed add.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10140,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'WarnLimit',
			'FldEng' => 'Warn Item Maximum',
			'FldDesc' => 'Indicates how many Data Loop Items/Records will trigger a warning to the User that they are approaching the maximum limit.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10141,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '9',
			'FldSpecSource' => '0',
			'FldName' => 'MinLimit',
			'FldEng' => 'Minimum Loop Items',
			'FldDesc' => 'Indicates how many Data Loop Items/Records the User must add.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10142,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '10',
			'FldSpecSource' => '0',
			'FldName' => 'IsStep',
			'FldEng' => 'Is Step-Loop',
			'FldDesc' => 'Indicates whether or not this Data Loop operates as a Step-Loop, meaning Table records are added to the Database before this Data Loops steps the User through adding information for one preexisting Loop Item at a time. Otherwise, Data Loops behave so that Users to can add Loop Items until the specified limits are reached.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10143,
			'FldDatabase' => '3',
			'FldTable' => '24',
			'FldOrd' => '11',
			'FldSpecSource' => '0',
			'FldName' => 'AutoGen',
			'FldEng' => 'Data Auto-Generates',
			'FldDesc' => 'If this is not a Step-Loop, this indicates whether or not this Data Loop should automatically create new Database Table records (and child data structures) when a User clicks to add another Loop Item.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10144,
			'FldDatabase' => '3',
			'FldTable' => '26',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Tbl',
			'FldEng' => 'Primary Table',
			'FldDesc' => 'Indicates the name of the primary Database Table in this Data Subset relationship, included in this User Experience. This Table is upstream of the secondary Table when loading User Data.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Table ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10145,
			'FldDatabase' => '3',
			'FldTable' => '26',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'TblLnk',
			'FldEng' => 'Primary Table Linking Field',
			'FldDesc' => 'When appropriate, this indicates the full name ( "{TableAbbr}{FldName}" ) of the primary Table\'s Field to find related secondary Table records in the User\'s Data. This Field must be a Foreign Key pointing to the secondary Table.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Field ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10146,
			'FldDatabase' => '3',
			'FldTable' => '26',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'SubTbl',
			'FldEng' => 'Secondary Table',
			'FldDesc' => 'Indicates the name of the secondary Database Table in this Data Subset relationship, included in this User Experience. This Table is downstream of the primary Table when loading User Data.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Table ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10147,
			'FldDatabase' => '3',
			'FldTable' => '26',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'SubLnk',
			'FldEng' => 'Secondary Table Linking Field',
			'FldDesc' => 'When appropriate, this indicates the full name ( "{TableAbbr}{FldName}" ) of the secondary Table\'s Field to find related secondary Table records in the User\'s Data. This Field must be a Foreign Key pointing to the primary Table.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Field ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10148,
			'FldDatabase' => '3',
			'FldTable' => '26',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'AutoGen',
			'FldEng' => 'Secondary Records Auto-Generated',
			'FldDesc' => 'Indicates whether or not this Data Subset should enforce the auto-creation of secondary Table records, whenever the related primary Table record exists.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10149,
			'FldDatabase' => '3',
			'FldTable' => '27',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'ParentTable',
			'FldEng' => 'Primary Table',
			'FldDesc' => 'Indicates the name of the primary Database Table in this Data Helper relationship, included in this User Experience. This Table is upstream of the secondary Table when loading User Data.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Table ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10150,
			'FldDatabase' => '3',
			'FldTable' => '27',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Table',
			'FldEng' => 'Secondary Table',
			'FldDesc' => 'Indicates the name of the primary Database Table in this Data Helper relationship, included in this User Experience. This Table is downstream of the primary Table when loading User Data.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Table ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10151,
			'FldDatabase' => '3',
			'FldTable' => '27',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'KeyField',
			'FldEng' => 'Secondary Foreign Key',
			'FldDesc' => 'Indicates the full name ( "{TableAbbr}{FldName}" ) of the secondary Table\'s Field to find related secondary Table records in the User\'s Data. This Field must be a Foreign Key pointing to the secondary Table.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Field ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10152,
			'FldDatabase' => '3',
			'FldTable' => '27',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'ValueField',
			'FldEng' => 'Secondary Storage Field',
			'FldDesc' => 'When appropriate, this indicates the full name ( "{TableAbbr}{FldName}" ) of the secondary Table\'s Field which stores multiple checkbox Response Values from the User and associates them with the primary Database Table.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Field ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10153,
			'FldDatabase' => '3',
			'FldTable' => '25',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Table',
			'FldEng' => 'Database Linkage Table',
			'FldDesc' => 'Indicates the unique Table ID number for the many-to-many linkage table to be included when a User\'s Data is loaded for this User Experience.',
			'FldForeignTable' => '9',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10154,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'CoreID',
			'FldEng' => 'User\'s Core Table Record ID',
			'FldDesc' => 'Indicates the unique Table ID number for the User\'s record in this Experience\'s Core Data Table. This is important for saving update\'s in the User\'s progress.',
			'FldForeignTable' => '3',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10155,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldSpecSource' => '0',
			'FldName' => 'UserID',
			'FldEng' => 'Session User ID',
			'FldDesc' => 'Indicates the unique User ID for the Database User logged in and using this Session record.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10156,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Tree',
			'FldEng' => 'Session Experience ID',
			'FldDesc' => 'Indicates the unique Experience ID number of the User Experience which this Session record is tracking.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10157,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'CurrNode',
			'FldEng' => 'Session Current Node ID',
			'FldDesc' => 'Indicates the unique Node ID number of the last Experience Node this User loaded.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10158,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'LoopRootJustLeft',
			'FldEng' => 'Just Left Loop Root ID',
			'FldDesc' => 'When appropriate, this Session data stores the unique Root Node ID for a Data Loop which has just been exited by the User.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10159,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'AfterJumpTo',
			'FldEng' => 'Jump From Node ID',
			'FldDesc' => 'When appropriate, this Session data stores the unique Node ID for an Experience Node the User has just used custom navigation to jump away from.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10160,
			'FldDatabase' => '3',
			'FldTable' => '42',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'ZoomPref',
			'FldEng' => 'Zoom Preference',
			'FldDesc' => 'Indicates the User\'s current preference of visual zoom of the page.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10161,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'IsMobile',
			'FldEng' => 'Using Mobile Device',
			'FldDesc' => 'Indicates whether or not the User is currently using a mobile device (1 if yes).',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldCompareSame' => '6',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10162,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldOrd' => '9',
			'FldSpecSource' => '0',
			'FldName' => 'Browser',
			'FldEng' => 'Session Browser',
			'FldDesc' => 'Indicates the web browser used during this Session.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '255',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10163,
			'FldDatabase' => '3',
			'FldTable' => '20',
			'FldSpecSource' => '0',
			'FldName' => 'SessID',
			'FldEng' => 'User Session ID',
			'FldDesc' => 'Indicates the unique Session ID for the User Session whose Data Loop progress is stored in this record.',
			'FldForeignTable' => '19',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10164,
			'FldDatabase' => '3',
			'FldTable' => '20',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Name',
			'FldEng' => 'Data Loop Name',
			'FldDesc' => 'Indicates the name of the Data Loop with User progress to store in this record.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Data Loop ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '50',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ','
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10165,
			'FldDatabase' => '3',
			'FldTable' => '20',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'ItemID',
			'FldEng' => 'Data Loop Item ID',
			'FldDesc' => 'Indicates the unique ID number of the Data Loop Item which the User was last working on.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10166,
			'FldDatabase' => '3',
			'FldTable' => '17',
			'FldSpecSource' => '0',
			'FldName' => 'Session',
			'FldEng' => 'User Session ID',
			'FldDesc' => 'Indicates the unique Session ID for the User Session whose Node response is stored in this record.',
			'FldForeignTable' => '19',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10167,
			'FldDatabase' => '3',
			'FldTable' => '17',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Node',
			'FldEng' => 'Save Node ID',
			'FldDesc' => 'Indicates the unique Node ID for the Experience Node whose User response is stored in this record.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10168,
			'FldDatabase' => '3',
			'FldTable' => '17',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'VersionAB',
			'FldEng' => 'A/B Testing Version',
			'FldDesc' => 'Stores a complex string reflecting all A/B Testing variations in effect at the time of this User\'s Experience of this Node.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Keyboard,',
			'FldKeyType' => ',',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10169,
			'FldDatabase' => '3',
			'FldTable' => '17',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'TblFld',
			'FldEng' => 'Storage Data Field',
			'FldDesc' => 'Indicates the full Database Table and Field address ( "{TableName}:{TableAbbr}{FldName}" ) where this Node has decided to store the User\'s Response.',
			'FldNotes' => 'Yes, this should be changed to a Foreign Key to the Field ID.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10170,
			'FldDatabase' => '3',
			'FldTable' => '17',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'LoopItemID',
			'FldEng' => 'Data Loop Item ID',
			'FldDesc' => 'Indicates the unique ID number of the Data Loop Item which the User was working on for this Node Response.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10171,
			'FldDatabase' => '3',
			'FldTable' => '17',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'NewVal',
			'FldEng' => 'User Response',
			'FldDesc' => 'Indicates the stored User\'s Response Value, or a dump of related information.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10172,
			'FldDatabase' => '3',
			'FldTable' => '18',
			'FldSpecSource' => '0',
			'FldName' => 'Session',
			'FldEng' => 'User Session ID',
			'FldDesc' => 'Indicates the unique Session ID for the User Session whose Page Node progress is stored in this record.',
			'FldForeignTable' => '19',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10173,
			'FldDatabase' => '3',
			'FldTable' => '18',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Node',
			'FldEng' => 'Page Node ID',
			'FldDesc' => 'Indicates the unique Node ID for the Experience Page Node this Session has loaded.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10174,
			'FldDatabase' => '3',
			'FldTable' => '18',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'LoopItemID',
			'FldEng' => 'Data Loop Item ID',
			'FldDesc' => 'Indicates the unique ID number of the Data Loop Item which the User was working on for this Page Node.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10175,
			'FldDatabase' => '3',
			'FldTable' => '22',
			'FldSpecSource' => '0',
			'FldName' => 'UID',
			'FldEng' => 'User ID',
			'FldDesc' => 'Indicates the unique User ID related to the User being granted permissions in this record.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10176,
			'FldDatabase' => '3',
			'FldTable' => '22',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'RID',
			'FldEng' => 'Role ID',
			'FldDesc' => 'Indicates the unique Definition ID related to a User Role being granted in this record.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10177,
			'FldDatabase' => '3',
			'FldTable' => '21',
			'FldSpecSource' => '0',
			'FldName' => 'User',
			'FldEng' => 'User ID',
			'FldDesc' => 'Indicates the unique User ID related to the User whose actions are being logged in this record.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10178,
			'FldDatabase' => '3',
			'FldTable' => '21',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'CurrPage',
			'FldEng' => 'Current URL',
			'FldDesc' => 'Indicates the URL of the system page where the User is taking the logged action.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10179,
			'FldDatabase' => '3',
			'FldTable' => '21',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Val',
			'FldEng' => 'Action Value',
			'FldDesc' => 'Indicates any other value or dump of values which may need to be logged alongside the URL for adequate documentation.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10180,
			'FldDatabase' => '3',
			'FldTable' => '23',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Database',
			'FldEng' => 'Log Database ID',
			'FldDesc' => 'Indicates the unique Database ID number which this Logged Action was taken on.',
			'FldForeignTable' => '4',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10181,
			'FldDatabase' => '3',
			'FldTable' => '23',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Table',
			'FldEng' => 'Log Table ID',
			'FldDesc' => 'Indicates the unique Table ID number which this Logged Action was taken on.',
			'FldForeignTable' => '9',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10182,
			'FldDatabase' => '3',
			'FldTable' => '23',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Field',
			'FldEng' => 'Log Field ID',
			'FldDesc' => 'Indicates the unique Field ID number which this Logged Action was taken on.',
			'FldForeignTable' => '10',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10183,
			'FldDatabase' => '3',
			'FldTable' => '23',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'Action',
			'FldEng' => 'Type Of Action',
			'FldDesc' => 'Indicates what type of Action on the Database Design is being Logged.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'New;Edit',
			'FldDataLength' => '20',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldCompareSame' => '878800',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10184,
			'FldDatabase' => '3',
			'FldTable' => '23',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'OldName',
			'FldEng' => 'Old Name',
			'FldDesc' => 'Indicates the old name of this Database Table or Field, to maintain a history of such important changes.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10185,
			'FldDatabase' => '3',
			'FldTable' => '23',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'NewName',
			'FldEng' => 'New Name',
			'FldDesc' => 'Indicates the new name of this Database Table or Field, to maintain a history of such important changes.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10186,
			'FldDatabase' => '3',
			'FldTable' => '23',
			'FldSpecSource' => '0',
			'FldName' => 'User',
			'FldEng' => 'User ID',
			'FldDesc' => 'Indicates the unique User ID related to the User whose actions are being logged in this record.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '13'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10187,
			'FldDatabase' => '3',
			'FldTable' => '3',
			'FldName' => 'UserID',
			'FldEng' => 'User ID',
			'FldDesc' => 'Indicates the unique User ID number of the User owning the data stored in this record for this Experience.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '11',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldKeyStruct' => 'Simple',
			'FldNullSupport' => '0',
			'FldOpts' => '39'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10188,
			'FldDatabase' => '3',
			'FldTable' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'SubmissionProgress',
			'FldEng' => 'Experience Node Progress',
			'FldDesc' => 'Indicates the unique Node ID number of the last Experience Node loaded during this User\'s Experience.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '11',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldType' => 'INT',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldOpts' => '39'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10189,
			'FldDatabase' => '3',
			'FldTable' => '3',
			'FldName' => 'VersionAB',
			'FldEng' => 'A/B Testing Version',
			'FldDesc' => 'Stores a complex string reflecting all A/B Testing variations in effect at the time of this User\'s Experience of this Node.',
			'FldForeignMin' => '11',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldKeyStruct' => 'Simple',
			'FldNullSupport' => '0',
			'FldOpts' => '39'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10196,
			'FldDatabase' => '3',
			'FldTable' => '3',
			'FldSpecType' => 'Replica',
			'FldName' => 'IPaddy',
			'FldEng' => 'IP Address',
			'FldDesc' => 'Encrypted IP address of the current user.',
			'FldForeignMin' => '11',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldOpts' => '39'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10197,
			'FldDatabase' => '3',
			'FldTable' => '3',
			'FldSpecType' => 'Replica',
			'FldName' => 'TreeVersion',
			'FldEng' => 'Tree Version Number',
			'FldDesc' => 'Stores the current version number of this User Experience, important for tracking bugs.',
			'FldForeignMin' => '11',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldOpts' => '39'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10198,
			'FldDatabase' => '3',
			'FldTable' => '3',
			'FldSpecType' => 'Replica',
			'FldName' => 'UniqueStr',
			'FldEng' => 'Unique String For Record',
			'FldDesc' => 'This unique string is for cases when including the record ID number is not appropriate.',
			'FldForeignMin' => '11',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldOpts' => '39'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10199,
			'FldDatabase' => '3',
			'FldTable' => '3',
			'FldSpecType' => 'Replica',
			'FldName' => 'IsMobile',
			'FldEng' => 'Using Mobile Device',
			'FldDesc' => 'Indicates whether or not the current user is interacting via a mobile deviced.',
			'FldForeignMin' => '11',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldOpts' => '39'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10200,
			'FldDatabase' => '3',
			'FldTable' => '5',
			'FldOrd' => '10',
			'FldSpecSource' => '0',
			'FldName' => 'Opts',
			'FldEng' => 'Tree Options',
			'FldDesc' => 'Indicates the multiple of various prime numbers which mark specific other qualities of this Node.',
			'FldNotes' => '%3 Admin-Only; %5 Tree That Is One Big SurvLoop; %7 Area Home Page (for Public, Admin, or Volun); %11 Record Edits Not Allowed (except by Admins); %13 Report for Survey (linked and shares core table); %17 Volunteers Access (& Admin); %19 Contact Form (Auto Page); %23 Page Is Skinny; %29 Page Not [Yet] Simple Enough To Be Cached; %31 Search Bar Results Page (for Public, Admin, or Volun); %37 Survey Navigation Menu Bottom; %41 Partners Member Access; %43 Staff Access; %47 Uses Public ID#; %53 Has Page Form; %59 Survey Navigation Menu Top; %61 Survey Progress Line',
			'FldForeignMin' => '0',
			'FldForeignMax' => '0',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800',
			'FldOperateSame' => '52'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10201,
			'FldDatabase' => '3',
			'FldTable' => '42',
			'FldSpecType' => 'Replica',
			'FldName' => 'IPaddy',
			'FldEng' => 'IP Address',
			'FldDesc' => 'Encrypted IP address of the current user.',
			'FldForeignMin' => '11',
			'FldForeignMax' => '11',
			'FldForeign2Min' => '11',
			'FldForeign2Max' => '11',
			'FldOpts' => '39'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10202,
			'FldDatabase' => '3',
			'FldTable' => '12',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Title',
			'FldEng' => 'Article Title',
			'FldDesc' => 'Indicates an appropriate title for an Article which provides more information for Users with completed submissions meeting this related Condition/Filter.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10203,
			'FldDatabase' => '3',
			'FldTable' => '31',
			'FldSpecSource' => '0',
			'FldName' => 'Type',
			'FldEng' => 'Contact Type',
			'FldDesc' => 'Indicates which type of contact the site visitor is making with us.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10204,
			'FldDatabase' => '3',
			'FldTable' => '31',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Flag',
			'FldEng' => 'Flag',
			'FldDesc' => 'Indicates the current internal status of this Contact submission, important for organizing contact records which need attention by system administrators.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Unread;Read;Trash',
			'FldDefault' => 'Unread',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10205,
			'FldDatabase' => '3',
			'FldTable' => '31',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Email',
			'FldEng' => 'Email Address',
			'FldDesc' => 'Indicates the email address of the site visitor who completed the Contact Form, important for responding to them.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6',
			'FldCompareOther' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10206,
			'FldDatabase' => '3',
			'FldTable' => '31',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Subject',
			'FldEng' => 'Message Subject Line',
			'FldDesc' => 'Indicates the subject line (or title) of the site visitor\'s Contact Form submission. This is important for more quickly identifying and classifying the nature of the request.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10207,
			'FldDatabase' => '3',
			'FldTable' => '31',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'Body',
			'FldEng' => 'Message Body',
			'FldDesc' => 'Indicates the main body of the site visitor\'s Contact Form submission, providing all the rest of the details of their request. This also includes a dump of any other fields which may have been built into the Contact Form.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10208,
			'FldDatabase' => '3',
			'FldTable' => '32',
			'FldSpecSource' => '0',
			'FldName' => 'TreeID',
			'FldEng' => 'Tree ID',
			'FldDesc' => 'Indicates the unique Tree ID number which this record belongs to.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeign2Min' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10209,
			'FldDatabase' => '3',
			'FldTable' => '32',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'RecID',
			'FldEng' => 'Submission Record ID',
			'FldDesc' => 'Indicates the unique record ID number whose data is being cached here.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10210,
			'FldDatabase' => '3',
			'FldTable' => '32',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Dump',
			'FldEng' => 'Full Record Dump',
			'FldDesc' => 'Stores a cache of all raw data from a specific submission record, including English translations for Definition IDs, etc.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10211,
			'FldDatabase' => '3',
			'FldTable' => '33',
			'FldSpecSource' => '0',
			'FldName' => 'UserID',
			'FldEng' => 'User ID',
			'FldDesc' => 'Indicates the unique User ID number whose interactions are being logged here. Important for ensuring that one User cannot tag someone\'s completed submission more than once.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10212,
			'FldDatabase' => '3',
			'FldTable' => '33',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'TreeID',
			'FldEng' => 'Tree ID',
			'FldDesc' => 'Indicates the unique Tree ID number that the record being tagged belongs to. Vital for knowing which table the record ID refers to.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10213,
			'FldDatabase' => '3',
			'FldTable' => '33',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'RecID',
			'FldEng' => 'Submission Record ID',
			'FldDesc' => 'Indicates the unique record ID number which is being tagged with this row.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10214,
			'FldDatabase' => '3',
			'FldTable' => '33',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'DefID',
			'FldEng' => 'Tag Definition ID',
			'FldDesc' => 'Indicates the unique Definition ID number belonging to the specific tag or interaction being logged in this row.',
			'FldForeignTable' => '7',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10215,
			'FldDatabase' => '3',
			'FldTable' => '34',
			'FldSpecSource' => '0',
			'FldName' => 'Type',
			'FldEng' => 'Token Type',
			'FldDesc' => 'Indicates which type of Token has been created and stored here. ',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'Confirm Email;Sensitive;MFA',
			'FldDataLength' => '20',
			'FldCharSupport' => ',Letters,Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10216,
			'FldDatabase' => '3',
			'FldTable' => '34',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'UserID',
			'FldEng' => 'User ID',
			'FldDesc' => 'Indicates the unique User ID number whose token is logged in this row.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10217,
			'FldDatabase' => '3',
			'FldTable' => '34',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'TreeID',
			'FldEng' => 'Tree ID',
			'FldDesc' => 'Indicates the unique Tree ID number to which this token relates.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10218,
			'FldDatabase' => '3',
			'FldTable' => '34',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'CoreID',
			'FldEng' => 'Submission Record ID',
			'FldDesc' => 'Indicates the unique record ID number of the completed submission to which this Token relates.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10219,
			'FldDatabase' => '3',
			'FldTable' => '34',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'TokToken',
			'FldEng' => 'Generated Token',
			'FldDesc' => 'Indicates the randomly generated string which is stored as a Token for a User\'s specific interaction with the database.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '255',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10220,
			'FldDatabase' => '3',
			'FldTable' => '35',
			'FldSpecSource' => '0',
			'FldName' => 'Tree',
			'FldEng' => 'Tree ID',
			'FldDesc' => 'Indicates the unique Tree ID which sent this email.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10221,
			'FldDatabase' => '3',
			'FldTable' => '35',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'RecID',
			'FldEng' => 'Core Record ID',
			'FldDesc' => 'Indicates the unique Record ID of the core table of the Tree sending this email.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10222,
			'FldDatabase' => '3',
			'FldTable' => '35',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'EmailID',
			'FldEng' => 'Email Template ID',
			'FldDesc' => 'Indicates the unique Email Template ID which is being sent.',
			'FldForeignTable' => '36',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10223,
			'FldDatabase' => '3',
			'FldTable' => '35',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'To',
			'FldEng' => 'Recipient Email Address',
			'FldDesc' => 'The email address this message is being sent to.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10224,
			'FldDatabase' => '3',
			'FldTable' => '35',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'ToUser',
			'FldEng' => 'Recipient User ID',
			'FldDesc' => 'Indicates the unique User ID of the User this email is being sent to.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldForeign2Max' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '20',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10225,
			'FldDatabase' => '3',
			'FldTable' => '35',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'FromUser',
			'FldEng' => 'Sender User ID',
			'FldDesc' => 'Indicates the unique User ID of the User initiating this emailing.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10226,
			'FldDatabase' => '3',
			'FldTable' => '35',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Subject',
			'FldEng' => 'Subject Line',
			'FldDesc' => 'Indicates the subject line of this specific email, even if it is different than the default, auto-generated version from the Email Template.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10227,
			'FldDatabase' => '3',
			'FldTable' => '35',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'Body',
			'FldEng' => 'Email Body',
			'FldDesc' => 'Indicates the body of this specific email, even if it is different than the default, auto-generated version from the Email Template.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldCharSupport' => ',',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10228,
			'FldDatabase' => '3',
			'FldTable' => '35',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'Opts',
			'FldEng' => 'Options',
			'FldDesc' => 'Indicates the options or flags stored with this emailing.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800',
			'FldOperateSame' => '52'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10229,
			'FldDatabase' => '3',
			'FldTable' => '36',
			'FldSpecSource' => '0',
			'FldName' => 'Tree',
			'FldEng' => 'Tree ID',
			'FldDesc' => 'Indicates the unique Tree ID related to the home Tree of this Email Template.',
			'FldForeignTable' => '5',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10230,
			'FldDatabase' => '3',
			'FldTable' => '36',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Type',
			'FldEng' => 'Type',
			'FldDesc' => 'Indicates the general type of Email Template being stored here.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10231,
			'FldDatabase' => '3',
			'FldTable' => '36',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Name',
			'FldEng' => 'Template Name',
			'FldDesc' => 'Indicates the name of this Email Template, as it will be referred to internally within the system.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10232,
			'FldDatabase' => '3',
			'FldTable' => '36',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'Subject',
			'FldEng' => 'Default Subject Line',
			'FldDesc' => 'Indicates the default subject line of emails sent out using this template.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10233,
			'FldDatabase' => '3',
			'FldTable' => '36',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'Body',
			'FldEng' => 'Default Email Body',
			'FldDesc' => 'Indicates the default main content of emails sent out using this template.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10234,
			'FldDatabase' => '3',
			'FldTable' => '36',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'Opts',
			'FldEng' => 'Options',
			'FldDesc' => 'Indicates any options necessary to accurately define the properties of this Email Template.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10235,
			'FldDatabase' => '3',
			'FldTable' => '36',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'TotSent',
			'FldEng' => 'Total Emails Sent',
			'FldDesc' => 'Indicates the total number of individual Emails sent using this Email Template.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10236,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldSpecSource' => '0',
			'FldName' => 'DatabaseID',
			'FldEng' => 'Database ID',
			'FldDesc' => 'Indicates the unique Database ID number which owns this media item.',
			'FldForeignTable' => '4',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10237,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'UserID',
			'FldEng' => 'User ID',
			'FldDesc' => 'Indicates the unique User ID number who uploaded or owns this media item.',
			'FldForeignTable' => '28',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10238,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'FileOrig',
			'FldEng' => 'Original Filename',
			'FldDesc' => 'Indicates the original filename, as it was uploaded.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10239,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'FileLoc',
			'FldEng' => 'Stored Filename',
			'FldDesc' => 'Indicates the filename as it was actually stored here on the server.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10240,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'FullFilename',
			'FldEng' => 'Full File Location',
			'FldDesc' => 'Indicates the full path where this media file is actually stored here on the server (relative to the system app\'s root).',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10241,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'Title',
			'FldEng' => 'Media Title',
			'FldDesc' => 'Indicates the title of this uploaded media, or a concise description of it. This is important as a label used internally throughout the system.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10242,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Credit',
			'FldEng' => 'Media Credit (Legal)',
			'FldDesc' => 'Indicates any attribution required or appropriate to be shared alongside this media item.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10243,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '7',
			'FldSpecSource' => '0',
			'FldName' => 'CreditUrl',
			'FldEng' => 'Media Credit URL (Legal)',
			'FldDesc' => 'Indicates an optional URL link for any attribution required or appropriate to be shared alongside this media item.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10244,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '8',
			'FldSpecSource' => '0',
			'FldName' => 'NodeID',
			'FldEng' => 'Node ID',
			'FldDesc' => 'Indicates the unique Node ID number used to upload this media item.',
			'FldForeignTable' => '15',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10245,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '9',
			'FldSpecSource' => '0',
			'FldName' => 'Type',
			'FldEng' => 'Media Type',
			'FldDesc' => 'Indicates which allowed type of media upload this record tracks.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => 'jpg;png;gif',
			'FldDataLength' => '10',
			'FldCharSupport' => ',Letters,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10246,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '10',
			'FldSpecSource' => '0',
			'FldName' => 'FileSize',
			'FldEng' => 'Media File Size',
			'FldDesc' => 'Indicates this media file\'s size in bytes here on the server.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10247,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '11',
			'FldSpecSource' => '0',
			'FldName' => 'Width',
			'FldEng' => 'Media Width',
			'FldDesc' => 'Indicates the default width of this media item.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10248,
			'FldDatabase' => '3',
			'FldTable' => '37',
			'FldOrd' => '12',
			'FldSpecSource' => '0',
			'FldName' => 'Height',
			'FldEng' => 'Media Height',
			'FldDesc' => 'Indicates the default height of this media item.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10249,
			'FldDatabase' => '3',
			'FldTable' => '16',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'MutEx',
			'FldEng' => 'Response Is Mutually Exclusive',
			'FldDesc' => 'Indicates whether or not this response option is mutually exclusive with all the other responses to this question (Node).',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDefault' => '0',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10250,
			'FldDatabase' => '3',
			'FldTable' => '38',
			'FldSpecSource' => '0',
			'FldName' => 'Zip',
			'FldEng' => 'Zip Code',
			'FldDesc' => 'Indicates the zip code (postal code) being mapped in this record.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '10',
			'FldCharSupport' => ',Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10251,
			'FldDatabase' => '3',
			'FldTable' => '38',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Lat',
			'FldEng' => 'Latitude',
			'FldDesc' => 'Indicates the Zip Code\'s latitude is a geographic coordinate that specifies the north–south position of a point on the Earth\'s surface.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10252,
			'FldDatabase' => '3',
			'FldTable' => '38',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Long',
			'FldEng' => 'Longitude',
			'FldDesc' => 'Indicates the Zip Code\'s longitude is a geographic coordinate that specifies the east-west position of a point on the Earth\'s surface.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10253,
			'FldDatabase' => '3',
			'FldTable' => '38',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'City',
			'FldEng' => 'City',
			'FldDesc' => 'Indicates the city where this Zip Code is located.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10254,
			'FldDatabase' => '3',
			'FldTable' => '38',
			'FldOrd' => '4',
			'FldSpecSource' => '0',
			'FldName' => 'State',
			'FldEng' => 'State',
			'FldDesc' => 'Indicates the state where this Zip Code is located.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10255,
			'FldDatabase' => '3',
			'FldTable' => '38',
			'FldOrd' => '5',
			'FldSpecSource' => '0',
			'FldName' => 'County',
			'FldEng' => 'County',
			'FldDesc' => 'Indicates the county where this Zip Code is located.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10256,
			'FldDatabase' => '3',
			'FldTable' => '38',
			'FldOrd' => '6',
			'FldSpecSource' => '0',
			'FldName' => 'Country',
			'FldEng' => 'Country',
			'FldDesc' => 'Indicates the country where this Zip Code is located.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '100',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10257,
			'FldDatabase' => '3',
			'FldTable' => '39',
			'FldSpecSource' => '0',
			'FldName' => 'Address',
			'FldEng' => 'Full Address',
			'FldDesc' => 'Indicates the full address, in one line, which is being linked with latitude and longitude coordinates.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10258,
			'FldDatabase' => '3',
			'FldTable' => '39',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'Lat',
			'FldEng' => 'Latitude',
			'FldDesc' => 'Indicates the Address\'s latitude is a geographic coordinate that specifies the north–south position of a point on the Earth\'s surface.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10259,
			'FldDatabase' => '3',
			'FldTable' => '39',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Long',
			'FldEng' => 'Longitude',
			'FldDesc' => 'Indicates the Address\'s longitude is a geographic coordinate that specifies the east-west position of a point on the Earth\'s surface.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10260,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldOrd' => '3',
			'FldSpecSource' => '0',
			'FldName' => 'IsActive',
			'FldEng' => 'Is Active',
			'FldDesc' => 'Indicates whether or not this session is currently active, or editable. This allows us to avoid permanently deleting these records valuable for audits.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10261,
			'FldDatabase' => '3',
			'FldTable' => '41',
			'FldSpecSource' => '0',
			'FldName' => 'SessID',
			'FldEng' => 'Session ID',
			'FldDesc' => 'Indicates the unique Session ID for the User Session who loaded this page.',
			'FldForeignTable' => '42',
			'FldForeignMin' => '0',
			'FldForeignMax' => 'N',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10262,
			'FldDatabase' => '3',
			'FldTable' => '41',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'URL',
			'FldEng' => 'URL Loaded',
			'FldDesc' => 'Indicates the URL which is currently being loaded, or redirected through on the server-side.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6',
			'FldCompareOther' => '6',
			'FldCompareValue' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10263,
			'FldDatabase' => '3',
			'FldTable' => '42',
			'FldSpecSource' => '0',
			'FldName' => 'UserID',
			'FldEng' => 'Session User ID',
			'FldDesc' => 'Indicates the unique User ID for the Database User logged in and using this Site Session record.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldType' => 'TEXT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',Foreign,',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10264,
			'FldDatabase' => '3',
			'FldTable' => '42',
			'FldOrd' => '2',
			'FldSpecSource' => '0',
			'FldName' => 'Browser',
			'FldEng' => 'Session Browser',
			'FldDesc' => 'Indicates the web browser used during this Session.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '255',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '6'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10265,
			'FldDatabase' => '3',
			'FldTable' => '42',
			'FldOrd' => '1',
			'FldSpecSource' => '0',
			'FldName' => 'IsMobile',
			'FldEng' => 'Using Mobile Device',
			'FldDesc' => 'Indicates whether or not the User is currently using a mobile device (1 if yes).
',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldValues' => '0;1',
			'FldType' => 'INT',
			'FldDataType' => 'Numeric',
			'FldDataLength' => '1',
			'FldCharSupport' => ',Numbers,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
		DB::table('SL_Fields')->insert([
			'FldID' => 10266,
			'FldDatabase' => '3',
			'FldTable' => '19',
			'FldOrd' => '10',
			'FldSpecSource' => '0',
			'FldName' => 'IP',
			'FldEng' => 'IP Address',
			'FldDesc' => 'Encrypted IP address of the current user.',
			'FldForeignMin' => 'N',
			'FldForeignMax' => 'N',
			'FldForeign2Min' => 'N',
			'FldForeign2Max' => 'N',
			'FldDataLength' => '0',
			'FldCharSupport' => ',Letters,Numbers,Keyboard,',
			'FldKeyType' => ',',
			'FldNullSupport' => '0',
			'FldCompareSame' => '878800'
		]);
	
	DB::table('SL_Tree')->insert([
			'TreeID' => 3,
			'TreeDatabase' => '3',
			'TreeUser' => '0',
			'TreeType' => 'Survey',
			'TreeName' => 'SurvLoop Database Designer',
			'TreeDesc' => 'SurvLoop users can add a new field to the database and/or user experience.',
			'TreeSlug' => 'data-design',
			'TreeRoot' => '7',
			'TreeFirstPage' => '8',
			'TreeLastPage' => '8',
			'TreeCoreTable' => '3'
		]);
		DB::table('SL_Tree')->insert([
			'TreeID' => 4,
			'TreeDatabase' => '3',
			'TreeUser' => '0',
			'TreeType' => 'Survey XML',
			'TreeName' => 'SurvLoop Database Designer',
			'TreeSlug' => 'data-design',
			'TreeRoot' => '14',
			'TreeCoreTable' => '3'
		]);
	
 }
1145031
public function run()
    {
        $this->generateModel();
        $this->generateMigration();
        $this->generateSeed();
        $this->generateRequest();
        $this->generateController();
        $this->runMigration();
        $this->generateViews();
        $this->appendRoute();
    }
764850
public function run()
    {
        foreach($this->dumpFiles() as $dumpPart) {

            $query = "LOAD DATA LOCAL INFILE '"
                    . str_replace('\\', '/', $dumpPart) . "'
                    INTO TABLE `" . Config::citiesTableName() . "` 
                        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
                        LINES TERMINATED BY '\n' IGNORE 1 LINES
                        (country,
                        city_ascii,
                        city,
                        region,
                        population,
                        latitude,
                        longitude
                    )";

            DB::connection()->getpdo()->exec($query);

        }
    }
1060896
public function run()
    {
        $pagination = (new PageList())->getPagination();
        $app = Application::getFacadeApplication();
        $tracker = $app->make('statistics/tracker');

        do {
            if ($results = $pagination->getCurrentPageResults()) {
                /** @var \Concrete\Core\Page\Page $page */
                foreach ($results as $page) {
                    try {
                        $tracker->track($page);
                    } catch (\Exception $e) {
                        dd($e->getMessage(), $e->getTraceAsString());
                    }
                }
            }
        } while ($pagination->hasNextPage() && $pagination->setCurrentPage($pagination->getNextPage()));
    }
649417
public function run()
    {
        Model::unguard();

        $this->call(RolesTableSeeder::class);
        $this->call(UserTableSeeder::class);

        Model::reguard();
    }
141995
public function run()
    {
        $data = $this->getData();

        // If blade is enabled, initialize it
        if ($this->isBladeEnabled())
        {
            $bladeConfig = $data['blade'];

            // Setup blade and paths
            $viewsPath = $bladeConfig['paths']['views'];
            $cachePath = $bladeConfig['paths']['cache'];
            $blade = new Blade($viewsPath, $cachePath);

            // Extend blade
            /** @var \Illuminate\View\Compilers\BladeCompiler $compiler */
            $compiler = $blade->getCompiler();
            $extensions = array(
                new WordPressLoopExtension(),
                new WordPressQueryExtension(),
                new WordPressShortcodeExtension()
            );

            /** @var Extension $ext */
            foreach ($extensions as $ext)
            {
                $ext->register($compiler);
            }

            // Set the blade engine in the facade
            Baobab::setBlade($blade);
        }
    }
1136977
public function run()
    {
        $topdir = $this->getBasePath();

        foreach (scandir($topdir) as $filename) {

            // Skip directory link files
            if (($filename == '.') || ($filename == '..')) {
                continue;
            }

            if (is_dir($topdir . DIRECTORY_SEPARATOR . $filename)) {
                // Recurse into lower level directory, providing the namespace
                $this->loadFiles($filename, $filename);
            }
        }
    }
775410
final protected function runDatabaseMigrationsAndSeeders()
    {
        // Ask to migrate the database,
        // if we've copied any migration files to the application.
        if (!empty($this->migrations) && $this->getCommand()->confirm('Do you wish to migrate your database?', true)) {
            try {
                $this->getCommand()->call('migrate');
            } catch (Exception $e) {
                $this->getCommand()->error(sprintf('Could not migrate your database. Reason: %s', $e->getMessage()));
            }
        }

        // Before we ask user to seed the database
        // we need to have look in the $seeders array
        // to remove folders from the array
        $seeders = [];
        foreach ($this->seeders as $seeder) {
            if (is_dir(base_path($seeder))) {
                continue;
            }
            $seeders[] = $seeder;
        }

        // Ask to seed the database,
        // if we've copied any migration files to the application.
        if (!empty($seeders) && $this->getCommand()->confirm('Do you wish to seed your database?', true)) {
            // Load seeders directory so new seeders are available
            load_directory($this->getInstaller()->getBasePath('database/seeds/'));

            // Run package seeders
            foreach ($seeders as $seeder) {
                try {
                    $seederFilename = substr($seeder, strrpos($seeder, '/') + 1);
                    $this->getCommand()->call('db:seed', [
                        '--class' => substr($seederFilename, 0, strrpos($seederFilename, '.')),
                    ]);
                } catch (Exception $e) {
                    $this->getCommand()->error(sprintf('Could not seed database. Reason: %s', $e->getMessage()));
                }
            }
        }
    }
1334707
public function run()
    {
        session_start();
        self::$_app = $this;
        if (empty($this->_runtimePath)) {
            $this->_runtimePath = $this->_basePath . '/runtime';
        }
        $application = $this->getComponent('application');
        $application->runController();
    }
274956
public function run()
	{
		$this->call(UsersTableSeeder::class);
		$this->call(ConfTableSeeder::class);
		$this->call(LangTableSeeder::class);
		
		$this->call(MediaCategoryTableSeeder::class);
		$this->call(MediaTypeTableSeeder::class);
		
		$this->call(PageTableSeeder::class);
		$this->call(PageLangTableSeeder::class);
		$this->call(NavigationGroupTableSeeder::class);
	}
699522
public function run()
    {
        $this->seed([
            [
                'group'       => [
                    'name'        => 'Auth',
                    'slug'        => 'auth',
                    'description' => 'Auth permissions group',
                ],
                'permissions' => array_merge(
                    $this->getDashboardPermissions(),
                    $this->getUsersPermissions(),
                    $this->getRolesPermissions(),
                    $this->getPermissionsPermissions(),
                    $this->getPasswordResetsPermissions()
                ),
            ],
        ]);
    }
615832
public function run()
    {
        $this->command->info('Venues seeding!');
        DB::table('venue')->truncate();
        factory(Venue::class, 5)->create();
    }
1248868
public function run()
    {
        $this->Script->startup();

        $this->Options = $this->Script->getOptions(
            "[db-host:][db-user:][db-password:][db-database:][db-type:|db-driver:][sql][clean][clean-all][conc:][php-exec:][commit-within:]",
            "",
            array(
                'db-host' => "Database host",
                'db-user' => "Database user",
                'db-password' => "Database password",
                'db-database' => "Database name",
                'db-driver' => "Database driver",
                'db-type' => "Database driver, alias for --db-driver",
                'sql' => "Display sql queries",
                'clean' =>  "Remove all search data of the current installation id before beginning indexing",
                'clean-all' => "Remove all search data for all installations",
                'conc' => 'Parallelization, number of concurent processes to use',
                'php-exec' => 'Full path to PHP executable',
                'commit-within' => 'Commit to Solr within this time in seconds (default '
                    . self::DEFAULT_COMMIT_WITHIN . ' seconds)',
            )
        );
        $this->Script->initialize();

        // check if ezfind is enabled and exit if not
        if ( ! in_array( 'ezfind', eZExtension::activeExtensions() ) )
        {
            $this->CLI->error( 'eZ Find extension is not enabled and because of that index process will fail. Please enable it and run this script again.' );
            $this->Script->shutdown( 0 );
        }

        // Fix siteaccess
        $siteAccess = $this->Options['siteaccess'] ? $this->Options['siteaccess'] : false;
        if ( $siteAccess )
        {
            $this->changeSiteAccessSetting( $siteAccess );
        }
        else
        {
            $this->CLI->warning( 'You did not specify a siteaccess. The admin siteaccess is a required option in most cases.' );
            $input = readline( 'Are you sure the default siteaccess has all available languages defined? ([y] or [q] to quit )' );
            if ( $input === 'q' )
            {
                $this->Script->shutdown( 0 );
            }
        }

        // Check that Solr server is up and running
        if ( !$this->checkSolrRunning() )
        {
            $this->Script->shutdown( 1 );
            exit();
        }

        $this->initializeDB();

        // call clean up routines which will deal with the CLI arguments themselves
        $this->cleanUp();
        $this->cleanUpAll();

        if ( isset( $this->Options['commit-within'] )
                && is_numeric( $this->Options['commit-within'] ) )
        {
            $this->commitWithin = (int)$this->Options['commit-within'];
        }


        $this->CLI->output( 'Starting object re-indexing' );

        // Get PHP executable from user.
        $this->getPHPExecutable();

        $this->runMain();
    }