FinanceFerret/2.0/sql/Acct Types: Difference between revisions

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search
(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...")
 
m (Woozle moved page FinanceFerret/tables/Acct Types to FinanceFerret/2.0/sql/Acct Types without leaving a redirect: renumbering - 1.0 is Access version)
 
(One intermediate revision by the same user not shown)
(No difference)

Latest revision as of 13:49, 2 March 2020

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;