File: 7014.sql

package info (click to toggle)
ocsinventory-server 2.5%2Bdfsg1-1
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 7,088 kB
  • sloc: php: 27,462; perl: 8,241; sh: 1,680; sql: 1,355; xml: 1,041; makefile: 34
file content (13 lines) | stat: -rw-r--r-- 466 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
-- Create assets_categories table
CREATE TABLE IF NOT EXISTS `assets_categories` (
    `ID` INTEGER NOT NULL AUTO_INCREMENT,
    `CATEGORY_NAME` VARCHAR(255) NOT NULL,
    `CATEGORY_DESC` VARCHAR(255) NOT NULL,
    `SQL_QUERY` TEXT NOT NULL,
    `SQL_ARGS` TEXT NOT NULL,
    PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=UTF8;

-- Add CATEGORY column to hardware table
UNLOCK TABLES;
ALTER TABLE `hardware` ADD `CATEGORY_ID` int(11) default NULL AFTER `ARCH`;