AddCrossAccountsTable Class Reference

Inheritance diagram for AddCrossAccountsTable:

Public Member Functions
	up ()

Detailed Description

Definition at line 9 of file 2017121800_addcrossaccountstable.php.

Member Function Documentation

up()

AddCrossAccountsTable::up

(

)

Check for existence of file name

Table does not exist – CREATE

Definition at line 15 of file 2017121800_addcrossaccountstable.php.

                       {

    // ** Add the new 'CrossAccounts' table for each CU that exists in the current database
    // get the list of credit unions
    $cuList = $this->fetchAll('SELECT cu FROM cuadmin');

    for ( $i = 0; $i < count( $cuList ); $i++ ) {
      $cu = strtolower( trim( $cuList[$i]["cu"] ) );

      /**
       * Check for existence of file name
       */
      $tableName = "{$cu}crossaccounts";

      $exists = $this->hasTable($tableName);

      if (!$exists) {
        /**
         * Table does not exist --
         * CREATE
         */

        $sql = "
          CREATE TABLE {$tableName} (
            accountnumber character (12) NOT NULL,
            tomember character(12) NOT NULL,
            accounttype character(12) NOT NULL,
            deposittype character (1) NOT NULL,
            description character varying (255),
            misc1 character varying (255)
          );";
        $sqlRs = $this->query($sql);

        /* ADD PRIMARY KEY */
        $sql = "ALTER TABLE ONLY {$tableName} ADD CONSTRAINT {$tableName}_pkey PRIMARY KEY (accountnumber, tomember, accounttype, deposittype);";
        $sqlRs = $this->query($sql);

      }
    }
  }

---

The documentation for this class was generated from the following file:

• tools/cumanage/db/migrations/2017121800_addcrossaccountstable.php