VbzCart/tables/data procs

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: List of stored procedures which update one table from others

[edit] SQL

DROP TABLE IF EXISTS `data_procs`;
 
CREATE TABLE `data_procs` (
    `ID` INT NOT NULL AUTO_INCREMENT COMMENT "procedure ID",
    `Name` VARCHAR(127) NOT NULL COMMENT "name of SQL stored procedure",
    `isActive` BOOL COMMENT "FALSE = skip this record",
    `doesClear` BOOL COMMENT "TRUE = clears all data from table before starting",
    `Notes` VARCHAR(255) DEFAULT NULL COMMENT "explanatory notes",
    PRIMARY KEY (`ID`)
 ) ENGINE = MYISAM;