FinanceFerret/2.0/sql/Owners: Difference between revisions

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search
m (1 revision imported: stuff I missed the first time)
m (Woozle moved page FinanceFerret/tables/Owners to FinanceFerret/2.0/sql/Owners without leaving a redirect: renumbering - 1.0 is Access version)
 
(No difference)

Latest revision as of 13:49, 2 March 2020

History

  • 2018-05-12 documented schema, changed engine from MyISAM to InnoDB
    • At this point, I'm not actually sure this table makes sense. I seem to recall it was a late addition, and I only vaguely remember the problem it was trying to solve.

SQL

CREATE TABLE `Owners` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) DEFAULT NULL,
  `ID_Equity` int(4) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB;