FinanceFerret/2.0/sql/Acct Types

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search

History

  • 2018-05-12 documented schema, changed engine from MyISAM to InnoDB

SQL

CREATE TABLE `Acct Types` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) DEFAULT NULL,
  `Descr` varchar(50) DEFAULT NULL,
  `doIndirect` tinyint(1) DEFAULT NULL,
  `hasTrxacts` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB;