FilesExpand file tree

master

/

create_script_props_tables.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

15 lines (13 loc) · 478 Bytes

master

/

create_script_props_tables.sql

Copy path

Top

File metadata and controls

• Code
• Blame

15 lines (13 loc) · 478 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

CREATE TABLE `govwiki_production`.`script_parameters` (

`id` BIGINT NOT NULL AUTO_INCREMENT,

`category` VARCHAR(200) NOT NULL,

`key` VARCHAR(200) NOT NULL,

`value` VARCHAR(2000) NULL,

`description` LONGTEXT NOT NULL,

PRIMARY KEY (`id`));

CREATE TABLE `govwiki_production`.`script_mapping` (

`id` BIGINT NOT NULL AUTO_INCREMENT,

`name` VARCHAR(200) NOT NULL,

`executable` VARCHAR(1000) NOT NULL,

`param_categories` LONGTEXT NOT NULL,

PRIMARY KEY (`id`));