https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Ftables%2Fstk_whse VbzCart/tables/stk whse - Revision history 2026-06-25T23:01:55Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/tables/stk_whse&diff=21445&oldid=prev Woozle: Created page with "==About== * '''Purpose''': tracks {{l/vc/term|warehouse}} locations * '''Future''': we'll probably want contact information, eventually. * '''History''': ** '''2016-01-08''' c..." 2016-01-09T02:12:23Z <p>Created page with &quot;==About== * &#039;&#039;&#039;Purpose&#039;&#039;&#039;: tracks {{l/vc/term|warehouse}} locations * &#039;&#039;&#039;Future&#039;&#039;&#039;: we&#039;ll probably want contact information, eventually. * &#039;&#039;&#039;History&#039;&#039;&#039;: ** &#039;&#039;&#039;2016-01-08&#039;&#039;&#039; c...&quot;</p> <p><b>New page</b></p><div>==About==<br /> * &#039;&#039;&#039;Purpose&#039;&#039;&#039;: tracks {{l/vc/term|warehouse}} locations<br /> * &#039;&#039;&#039;Future&#039;&#039;&#039;: we&#039;ll probably want contact information, eventually.<br /> * &#039;&#039;&#039;History&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;2016-01-08&#039;&#039;&#039; created because it really doesn&#039;t make sense to have warehouses in the suppliers table, but we do (or will) need a way to track them.<br /> ==SQL==<br /> &lt;mysql&gt;CREATE TABLE `stk_whse` (<br /> `ID` INT NOT NULL AUTO_INCREMENT,<br /> `Name` VARCHAR(64) COMMENT &#039;name of supplier as displayed&#039;,<br /> `isActive` BOOL COMMENT &#039;if FALSE, hide from casual listings&#039;,<br /> `Notes` TEXT COMMENT &quot;Human-entered notes about this supplier, for quick reference&quot;,<br /> PRIMARY KEY(`ID`)<br /> ) ENGINE = MYISAM;&lt;/mysql&gt;</div> Woozle