uuXEKBHk

1SET NAMES utf8;
2SET FOREIGN_KEY_CHECKS = 0;
3
4-- ----------------------------
5--  Table structure for `d_ah_configuration`
6-- ----------------------------
7DROP TABLE IF EXISTS d_ah_configuration;
8
9CREATE TABLE `d_ah_configuration` (
10  ID          INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
11  PARENT_ID   INT,
12  TITLE       VARCHAR(255),
13  CODE       VARCHAR(255)
14);
15
16DROP TABLE IF EXISTS d_ah_option;
17
18CREATE TABLE `d_ah_option` (
19  ID             INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
20  CONFIGURATION_ID    INT,
21  TITLE          VARCHAR(255),
22  CODE       VARCHAR(255),
23  TYPE       VARCHAR(255),
24  MULTIPLE char(1) not null DEFAULT 'N'
25);
26
27DROP TABLE IF EXISTS d_ah_option_value;
28
29CREATE TABLE `d_ah_option_value` (
30  ID           INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
31  OPTION_ID    INT,
32  VALUE        LONGTEXT
33);