<commit_before>--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: MeterData; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 
--

CREATE TABLE "MeterData" (
    meter_id integer NOT NULL,
    time_utc timestamp without time zone NOT NULL,
    error integer,
    lowalarm text,
    highalarm text,
    "Accumulated Real Energy Net (kWh)" real,
    "Real Energy Quadrants 1 & 4, Import (kWh)" real,
    "Real Energy Quadrants 2 & 3, Export (kWh)" real,
    "Reactive Energy Quadrant 1 (VARh)" real,
    "Reactive Energy Quadrant 2 (VARh)" real,
    "Reactive Energy Quadrant 3 (VARh)" real,
    "Reactive Energy Quadrant 4 (VARh)" real,
    "Apparent Energy Net (VAh)" real,
    "Apparent Energy Quadrants 1 & 4 (VAh)" real,
    "Apparent Energy Quadrants 2 & 3 (VAh)" real,
    "Total Net Instantaneous Real Power (kW)" real,
    "Total Net Instantaneous Reactive Power (kVAR)" real,
    "Total Net Instantaneous Apparent Power (kVA)" real,
    "Total Power Factor" real,
    "Voltage, L-L, 3p Ave (Volts)" real,<commit_msg>adding insert timestamp<commit_after>--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: MeterData; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 
--

CREATE TABLE "MeterData" (
    inserted timestamp without time zone DEFAULT now(),
    meter_id integer NOT NULL,
    time_utc timestamp without time zone NOT NULL,
    error integer,
    lowalarm text,
    highalarm text,
    "Accumulated Real Energy Net (kWh)" real,
    "Real Energy Quadrants 1 & 4, Import (kWh)" real,
    "Real Energy Quadrants 2 & 3, Export (kWh)" real,
    "Reactive Energy Quadrant 1 (VARh)" real,
    "Reactive Energy Quadrant 2 (VARh)" real,
    "Reactive Energy Quadrant 3 (VARh)" real,
    "Reactive Energy Quadrant 4 (VARh)" real,
    "Apparent Energy Net (VAh)" real,
    "Apparent Energy Quadrants 1 & 4 (VAh)" real,
    "Apparent Energy Quadrants 2 & 3 (VAh)" real,
    "Total Net Instantaneous Real Power (kW)" real,
    "Total Net Instantaneous Reactive Power (kVAR)" real,
    "Total Net Instantaneous Apparent Power (kVA)" real,
    "Total Power Factor" real,
    "Voltage, L-L, 3p Ave (Volts)" real,
{'fraction_non_alphanumeric': 0.10660377358490566, 'fraction_numerical': 0.009433962264150943, 'mean_word_length': 3.691740412979351, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6762442', 'n_tokens_mistral': 1123, 'n_tokens_neox': 1053, 'n_words': 374}