https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Ftables%2F_depts 2026-07-07T20:07:21Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/tables/_depts&diff=11487&oldid=prev 2009-03-08T19:29:02Z

<p>New page: ==About== * &#039;&#039;&#039;Purpose&#039;&#039;&#039;: Calculated information about departments ==SQL== &lt;section begin=sql /&gt;&lt;mysql&gt; DROP TABLE IF EXISTS `_depts`; CREATE TABLE `_depts` ( `ID` int(11) unsigned NO...</p> <p><b>New page</b></p><div>==About==<br /> * &#039;&#039;&#039;Purpose&#039;&#039;&#039;: Calculated information about departments<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt; DROP TABLE IF EXISTS `_depts`;<br /> CREATE TABLE `_depts` (<br /> `ID` int(11) unsigned NOT NULL auto_increment,<br /> `ID_Supp` int(11) unsigned NOT NULL COMMENT &#039;needed to simplify calculation of _titles&#039;,<br /> `CatNum` varchar(63) NOT NULL,<br /> `CatKey` varchar(7),<br /> `CatWeb_Dept` varchar(63) NOT NULL,<br /> `CatWeb_Title` varchar(63) NOT NULL,<br /> `cntForSale` int DEFAULT NULL,<br /> `cntInPrint` int DEFAULT NULL,<br /> `qtyInStock` int DEFAULT NULL,<br /> PRIMARY KEY (`ID`)<br /> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div>

Woozle