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