define("TYPE_USER"     , 1);
define("TYPE_GROUP"    , 2)

TABLE Accounts (
    id           SERIAL,
    entityType   TINYINT UNSIGNED NOT NULL,
    entityID     BIGINT UNSIGNED NOT NULL,
    accData      .....
)

//Описание внешних счетов
Account_Ext (
    id        SERIAL,
    accType   TINYINT UNSIGNED NOT NULL, /*константа тип: ЯД, WM, SMS и т.д.*/
    accKey    CHAR(64) UNIQUE, /* идентификатор счёта, т.е. номер кошелька в ЯД или номер телефона в SMS */
    accData1 ...
    accData2 ...
    .....
)

/* Таблица транзакций */
Pay_Transactions (
    id       SERIAL,
    .........
)

/* Собственно учёт внешних движений средств */
Ext_Pays (
     id         SERIAL,
     PT_ID      BIGINT UNSIGNED, /* Транзакция */
     extAcc_ID  BIGINT UNSIGNED NOT NULL, /* Внешний счёт */
     intAcc_ID  BIGINT UNSIGNED NOT NULL, /* Внутренний счёт */
     extAmount  DECIMAL(...), /* Объём транзакции на внешнем счёте. + или - */
     intAmount  DECIMAL(...), /* ....... на внутреннем */ 
)

/* Учёт внутренних передвижений средств */
Ext_Pays (
     id         SERIAL,
     PT_ID      BIGINT UNSIGNED, /* Транзакция */
     intAcc1_ID BIGINT UNSIGNED NOT NULL, /* 1 счёт */
     intAcc2_ID BIGINT UNSIGNED NOT NULL, /* 2 счёт */
     acc1Amount DECIMAL(...), /* Объём транзакции на1 счёте. + или - */
     acc2Amount DECIMAL(...), /* ....... на 2-м */ 
)

		case 'tab.pay_account.create':		//Таблица со счетами в системе
			$sql	= 'CREATE TABLE IF NOT EXISTS `pay_account` ('.
					'	id		BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, '.
					'	cDate		DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP(), '.
					'	sessID		BIGINT UNSIGNED NOT NULL, '.
					'	accType		TINYINT UNSIGNED NOT NULL, '.
					'	accObjID	BIGINT UNSIGNED NOT NULL, '.
					'	UNIQUE KEY	accKey (accType, accObjID) '.
					') ENGINE=InnoDB CHARSET="utf8" COMMENT="Счета в системе"';
			break;

		case 'tab.pay_accountState.create':	//Состояние счетов
			$sql	= 'CREATE TABLE IF NOT EXISTS `pay_accountState` ('.
					'	id		BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, '.
					'	payAccID	BIGINT UNSIGNED NOT NULL, '.
					'	currID		SMALLINT UNSIGNED NOT NULL, '.
					'	accAmount	DECIMAL(30,20), '.
					'	UNIQUE KEY	accCurr (payAccID, currID), '.
					' FOREIGN KEY	payAccID REFERENCES pay_account(id) ON DELETE RESTRICT ON UPDATE RESTRICT, '.
					' FOREIGN KEY	currID REFERENCES sys_currInfo(id) ON DELETE RESTRICT ON UPDATE RESTRICT '.
					') ENGINE=InnoDB CHARSET="utf8" COMMENT="Состояние счетов в системе в разных валютах"';
			break;

		case 'tab.pay_actions.create':		//Таблица с записью движений средств между счетами
			$sql	= 'CREATE TABLE IF NOT EXISTS `pay_accountActions` ('.
					'	id		BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, '.
					'	cDate		DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP(), '.
					'	sessID		BIGINT UNSIGNED NOT NULL, '.
					'	actType		TINYINT UNSIGNED NOT NULL, '.
					'	payAcc1_ID	BIGINT UNSIGNED NOT NULL, '.
					'	curr1_ID	SMALLINT UNSIGNED NOT NULL, '.
					'	pay1_Amount	DECIMAL(30,20) NOT NULL, '.
					'	payAcc2_ID	BIGINT UNSIGNED NOT NULL, '.
					'	curr2_ID	SMALLINT UNSIGNED NOT NULL, '.
					'	pay2_Amount	DECIMAL(30,20) NOT NULL, '.
					' FOREIGN KEY	payAcc1_ID REFERENCES pay_account(id) ON DELETE RESTRICT ON UPDATE RESTRICT, '.
					' FOREIGN KEY	curr1_ID REFERENCES sys_currInfo(id) ON DELETE RESTRICT ON UPDATE RESTRICT, '.
					' FOREIGN KEY	payAcc2_ID REFERENCES pay_account(id) ON DELETE RESTRICT ON UPDATE RESTRICT, '.
					' FOREIGN KEY	curr2_ID REFERENCES sys_currInfo(id) ON DELETE RESTRICT ON UPDATE RESTRICT '.
					') ENGINE=InnoDB CHARSET="utf8" COMMENT="Движения на счетах в разных валютах"';
			break;

		case 'tab.pay_transaction.create':	//Транзакции в системе
			$sql	= 'CREATE TABLE IF NOT EXISTS `pay_transaction` ('.
					'	id		BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, '.
					'	cDate		DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP(), '.
					'	sessID		BIGINT UNSIGNED NOT NULL, '.
					'	tDescr		CHAR(255) '.
					') ENGINE=InnoDB CHARSET="utf8" COMMENT="Транзакции в системе"';
			break;

		case 'tab.pay_account.create':		//Таблица со счетами в системе
			$sql	= 'CREATE TABLE IF NOT EXISTS `pay_account` ('.
					'	id		BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, '.
					'	cDate		DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP(), '.
					'	sessID		BIGINT UNSIGNED NOT NULL, '.
					'	accType		TINYINT UNSIGNED NOT NULL, '.
					'	accObjID	BIGINT UNSIGNED NOT NULL, '.
					'	UNIQUE KEY	accKey (accType, accObjID) '.
					') ENGINE=InnoDB CHARSET="utf8" COMMENT="Счета в системе"';
			break;

		case 'tab.pay_accountState.create':	//Состояние счетов
			$sql	= 'CREATE TABLE IF NOT EXISTS `pay_accountState` ('.
					'	id		BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, '.
					'	payAccID	BIGINT UNSIGNED NOT NULL, '.
					'	currID		SMALLINT UNSIGNED NOT NULL, '.
					'	accAmount	DECIMAL(30,20), '.
					'	UNIQUE KEY	accCurr (payAccID, currID), '.
					' FOREIGN KEY	payAccID REFERENCES pay_account(id) ON DELETE RESTRICT ON UPDATE RESTRICT, '.
					' FOREIGN KEY	currID REFERENCES sys_currInfo(id) ON DELETE RESTRICT ON UPDATE RESTRICT '.
					') ENGINE=InnoDB CHARSET="utf8" COMMENT="Состояние счетов в системе в разных валютах"';
			break;

		case 'tab.pay_actions.create':		//Таблица с записью движений средств между счетами
			$sql	= 'CREATE TABLE IF NOT EXISTS `pay_accountActions` ('.
					'	id		BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, '.
					'	cDate		DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP(), '.
					'	sessID		BIGINT UNSIGNED NOT NULL, '.
					'	PT_ID		BIGINT UNSIGNED NOT NULL, '.
					'	actType		TINYINT UNSIGNED NOT NULL, '.
					'	currID		SMALLINT UNSIGNED NOT NULL, '.
					'	debetAccID	BIGINT UNSIGNED NOT NULL, '.
					'	debetAmount	DECIMAL(30,20) NOT NULL, '.
					'	creditAccID	BIGINT UNSIGNED NOT NULL, '.
					'	creditAmount DECIMAL(30,20) NOT NULL, '.
					' FOREIGN KEY	PT_ID REFERENCES pay_transaction(id) ON DELETE RESTRICT ON UPDATE RESTRICT, '.
					' FOREIGN KEY	currID REFERENCES sys_currInfo(id) ON DELETE RESTRICT ON UPDATE RESTRICT, '.
					' FOREIGN KEY	debetAccID REFERENCES pay_account(id) ON DELETE RESTRICT ON UPDATE RESTRICT, '.
					' FOREIGN KEY	creditAccID REFERENCES pay_account(id) ON DELETE RESTRICT ON UPDATE RESTRICT '.
					') ENGINE=InnoDB CHARSET="utf8" COMMENT="Движения на счетах."';
			break;