FinanceFerret/2.0/sql/Acct Types

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Revision as of 20:46, 12 May 2018 by htyp>Woozle (Created page with "==History== * '''2018-05-12''' documented schema, changed engine from MyISAM to InnoDB ==SQL== <syntaxhighlight lang=mysql> CREATE TABLE `Acct Types` ( `ID` int(4) NOT NULL...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;