aS4y1eqg

1USE `meta`;
2
3DROP TABLE IF EXISTS `dbs`;
4CREATE TABLE `dbs` (
5  `id` INT NOT NULL AUTO_INCREMENT,
6  
7  `name` VARCHAR(50) NOT NULL,
8  `parallelism` INT NOT NULL DEFAULT 32,
9  `status` BIT(1) NOT NULL DEFAULT b'1',
10
11  UNIQUE(`name`),
12  PRIMARY KEY (`id`)
13);
14
15DROP TABLE IF EXISTS `tables`;
16CREATE TABLE `tables` (
17  `id` INT NOT NULL AUTO_INCREMENT,
18  `db_id` INT NOT NULL,
19  
20  `name` VARCHAR(50) NOT NULL,
21  `format` VARCHAR(50) NOT NULL DEFAULT 'parquet',
22  `status` BIT(1) NOT NULL DEFAULT b'1',
23  
24  `distribution_column` VARCHAR(50),
25  `last_updated` DATETIME,
26
27  PRIMARY KEY (`id`)
28);
29
30DROP TABLE IF EXISTS `columns`;
31CREATE TABLE `columns` (
32  `id` INT NOT NULL AUTO_INCREMENT,
33  `table_id` INT NOT NULL,
34  
35  `name` VARCHAR(50) NOT NULL,
36  `status` BIT(1) NOT NULL DEFAULT b'1',
37
38  `data_type` VARCHAR(50),
39  `default_value` VARCHAR(50),
40
41  PRIMARY KEY (`id`)
42);
43
44DROP TABLE IF EXISTS `transforms`;
45CREATE TABLE `transforms` (
46  `id` INT NOT NULL AUTO_INCREMENT,
47  `table_id` INT NOT NULL,
48  
49  `column` VARCHAR(50) NOT NULL,
50  `partition` BIT(1) NOT NULL DEFAULT b'1',
51  `status` BIT(1) NOT NULL DEFAULT b'1',
52  
53  `function` VARCHAR(50),
54  `derived_column` VARCHAR(50),
55  `level` INT,
56
57  PRIMARY KEY (`id`)
58);
59
60
61
62===========================
63
64
65GRANT
66SELECT, INSERT, UPDATE, DELETE,
67CREATE, ALTER, DROP
68ON meta.*
69TO 'meta-write'@'localhost';
70
71GRANT
72SELECT
73ON meta.*
74TO 'meta-read'@'localhost';