VbzCart/docs/tables/ depts: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Purpose''': Calculated information about departments ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_depts`; CREATE TABLE `_depts` ( `ID` int(11) unsigned NO...) |
m (Woozle moved page VbzCart/VbzCart/tables/ depts to VbzCart/docs/tables/ depts without leaving a redirect: part 3/5) |
(No difference)
|
Latest revision as of 01:56, 25 February 2024
About
- Purpose: Calculated information about departments
SQL
<section begin=sql /><mysql> DROP TABLE IF EXISTS `_depts`;
CREATE TABLE `_depts` ( `ID` int(11) unsigned NOT NULL auto_increment, `ID_Supp` int(11) unsigned NOT NULL COMMENT 'needed to simplify calculation of _titles', `CatNum` varchar(63) NOT NULL, `CatKey` varchar(7), `CatWeb_Dept` varchar(63) NOT NULL, `CatWeb_Title` varchar(63) NOT NULL, `cntForSale` int DEFAULT NULL, `cntInPrint` int DEFAULT NULL, `qtyInStock` int DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>
<section end=sql />