"Fossies" - the Fresh Open Source Software Archive

Member "OCSNG_UNIX_SERVER_2.6/ocsreports/files/update/7013.sql" (17 Apr 2019, 562 Bytes) of package /linux/privat/OCSNG_UNIX_SERVER_2.6.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 -- Create software_categories table
    2 CREATE TABLE IF NOT EXISTS `software_categories` (
    3     `ID` INTEGER NOT NULL AUTO_INCREMENT,
    4     `CATEGORY_NAME` VARCHAR(255) NOT NULL,
    5     PRIMARY KEY (`ID`)
    6 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
    7 
    8 -- Create software_category_exp table
    9 CREATE TABLE IF NOT EXISTS `software_category_exp` (
   10     `CATEGORY_ID` INT(6) NOT NULL,
   11     `SOFTWARE_EXP` varchar(255) NOT NULL
   12 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
   13 
   14 -- Add CATEGORY column to software table
   15 UNLOCK TABLES;
   16 ALTER TABLE `softwares` ADD `CATEGORY` varchar(255) default NULL;