FinanceFerret/2.0/sql/Acct Types: Difference between revisions
< 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 (1 revision imported: stuff I missed the first time) |
(No difference)
|
Revision as of 13:45, 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;