Purpose

This page is to provide pre-made SQL that will generate the appropriate Table with types in accordance to

You can use this tool to convert SQL into other query languages.

Oracle

CREATE TABLE pandora_rules (
	name clob,
	score number(9,2),
	measure clob,
	passed_measure clob,
	failed_measure clob,
	rule_category clob,
	description clob,
	included clob,
	filter clob,
	rows_passed number(9,2),
	rows_failed number(9,2),
	table_name clob,
	table_version clob,
	versions_offset clob,
	column_name clob,
	schema_name clob,
	function clob,
	version clob,
	parameters clob,
	type clob,
	rows_considered number(9,2),
	rows_ignored number(9,2),
	passed number(9,2),
	failed number(9,2),
	considered number(9,2),
	ignored number(9,2),
	category clob,
	table_created timestamp,
	last_validated timestamp,
        connection_string clob,
        external_column_name clob,
        external_database clob,
        external_schema clob,
        external_server clob,
        external_table_name clob,
        failed_score number(9, 2),
        latest_table_version number(9, 2),
        result clob,
        rule_category_id number(9,2),       
	PRIMARY KEY( name)
);

CREATE TABLE pandora_alerts (
	id clob,
	created_on number(9, 2),
	created_by clob,
	last_modified_on number(9, 2),
	last_modified_by clob,
	name clob,
	domain_id clob,
	domain_name clob,
	PRIMARY KEY( id )
);

PostgreSQL

-- 
-- Editor SQL for DB table pandora_rules
-- 

CREATE TABLE IF NOT EXISTS pandora_rules (
	name text,
	score numeric(9,2),
	measure text,
	passed_measure text,
	failed_measure text,
	rule_category text,
	description text,
	included text,
	filter text,
	rows_passed numeric(9,2),
	rows_failed numeric(9,2),
	table_name text,
	table_version text,
	versions_offset text,
	column_name text,
	schema_name text,
	function text,
	version text,
	parameters text,
	type text,
	rows_considered numeric(9,2),
	rows_ignored numeric(9,2),
	passed numeric(9,2),
	failed numeric(9,2),
	considered numeric(9,2),
	ignored numeric(9,2),
	category text,
	table_created timestamp,
	last_validated timestamp,
        connection_string text,
        external_column_name text,
        external_database text,
        external_schema text,
        external_server text,
        external_table_name text,
        failed_score numeric(9, 2),
        latest_table_version numeric(9, 2),
        result text,
        rule_category_id numeric(9,2),       
	PRIMARY KEY( name)
);

-- 
-- Editor SQL for DB table pandora_alerts
-- 

CREATE TABLE IF NOT EXISTS pandora_alerts (
	id text,
	created_on bigint,
	created_by text,
	last_modified_on bigint,
	last_modified_by text,
	name text,
	domain_id text,
	domain_name text,
	PRIMARY KEY( id )
);

SQL Server

-- 
-- Editor SQL for DB table PANDORA_RULES
-- 

IF object_id('PANDORA_RULES', 'U') is null
	CREATE TABLE PANDORA_RULES (
		[name] nvarchar(255),
		[score] numeric(9,2),
		[measure] nvarchar(255),
		[passed_measure] nvarchar(255),
		[failed_measure] nvarchar(255),
		[rule_category] nvarchar(255),
		[description] nvarchar(255),
		[included] nvarchar(255),
		[filter] nvarchar(255),
		[rows_passed] numeric(9,2),
		[rows_failed] numeric(9,2),
		[table_name] nvarchar(255),
		[table_version] nvarchar(255),
		[versions_offset] nvarchar(255),
		[column_name] nvarchar(255),
		[schema] nvarchar(255),
		[function] nvarchar(255),
		[version] nvarchar(255),
		[parameters] nvarchar(255),
		[type] nvarchar(255),
		[rows_considered] numeric(9,2),
		[rows_ignored] nvarchar(255),
		[passed] numeric(9,2),
		[failed] numeric(9,2),
		[considered] numeric(9,2),
		[ignored] numeric(9,2),
		[category] nvarchar(255),
		[table_created] datetime,
		[last_validated] datetime,
                [connection_string] nvarchar(255),
                [external_column_name] nvarchar(255),
                [external_database nvarchar(255),,
                [external_schema nvarchar(255),,
                [external_server nvarchar(255),,
                [external_table_name] nvarchar(255),,
                [failed_score] numeric(9, 2),
                [latest_table_version] numeric(9, 2),
                [result] nvarchar(255),
                [rule_category_id] numeric(9,2),       
		PRIMARY KEY( [name] )
	);

-- 
-- Editor SQL for DB table pandora_alerts
-- Created by http://editor.datatables.net/generator
-- 

IF object_id('pandora_alerts', 'U') is null
	CREATE TABLE pandora_alerts (
		[id] nvarchar(255) not null identity,
		[created_on] nvarchar(255),
		[created_by] nvarchar(255),
		[last_modified_on] nvarchar(255),
		[last_modified_by] nvarchar(255),
		[name] nvarchar(255),
		[domain_id] nvarchar(255),
		[domain_name] nvarchar(255),
		PRIMARY KEY( [id] )
	);

MySQL

-- 
-- Editor SQL for DB table PANDORA_RULES
-- Created by http://editor.datatables.net/generator
-- 

```sql
CREATE TABLE IF NOT EXISTS `PANDORA_RULES` (
	`name` varchar(255),
	`score` numeric(9,2),
	`measure` varchar(255),
	`passed_measure` varchar(255),
	`failed_measure` varchar(255),
	`rule_category` varchar(255),
	`description` varchar(255),
	`included` varchar(255),
	`filter` varchar(255),
	`rows_passed` numeric(9,2),
	`rows_failed` numeric(9,2),
	`table_name` varchar(255),
	`table_version` varchar(255),
	`versions_offset` varchar(255),
	`column_name` varchar(255),
	`schema` varchar(255),
	`function` varchar(255),
	`version` varchar(255),
	`parameters` varchar(255),
	`type` varchar(255),
	`rows_considered` numeric(9,2),
	`rows_ignored` numeric(9,2),
	`passed` numeric(9,2),
	`failed` numeric(9,2),
	`considered` numeric(9,2),
	`ignored` numeric(9,2),
	`category` varchar(255),
	`table_created` datetime,
	`last_validated` datetime,
        `connection_string` varchar(255),
        `external_column_name` varchar(255),
        `external_database` varchar(255),
        `external_schema` varchar(255),
        `external_server` varchar(255),
        `external_table_name` varchar(255),
        `failed_score` numeric(9, 2),
        `latest_table_version` numeric(9, 2),
        `result` varchar(255),
        `rule_category_id` numeric(9,2),       
	PRIMARY KEY( `name` )
);

-- 
-- Editor SQL for DB table pandora_alerts
-- Created by http://editor.datatables.net/generator
-- 

CREATE TABLE IF NOT EXISTS `pandora_alerts` (
	`id` varchar(255) NOT NULL auto_increment,
	`created_on` numeric(9, 2),
	`created_by` varchar(255),
	`last_modified_on` numeric(9, 2),
	`last_modified_by` varchar(255),
	`name` varchar(255),
	`domain_id` varchar(255),
	`domain_name` varchar(255),
	PRIMARY KEY( `id` )
);