:mod:`ocelot.utils.create_db`
=============================

.. py:module:: ocelot.utils.create_db


Module Contents
---------------

.. data:: db
   

   

.. data:: cursor
   

   

.. data:: sql
   :annotation: = CREATE TABLE TUNINGS (
         TIME  DATETIME NOT NULL,
         ID  INTEGER PRIMARY KEY,
         WL FLOAT,
         CHARGE FLOAT,
         COMMENT  CHAR(20))

   

.. data:: sql
   :annotation: = CREATE TABLE ACTIONS (
         TUNING_ID INTEGER,
         ACTION_ID INTEGER PRIMARY KEY,
         SASE_START FLOAT,
         SASE_END FLOAT)

   

.. data:: sql
   :annotation: = CREATE TABLE PARAMETERS (
         TUNING_ID INTEGER,
         ACTION_ID INTEGER,
         PAR_NAME CHAR(20),
         PAR_START_VALUE FLOAT,
         PAR_END_VALUE FLOAT,
         PRIMARY KEY(TUNING_ID, ACTION_ID, PAR_NAME) )

   

.. data:: sql
   :annotation: = CREATE TABLE MACHINE_STATE (
         TUNING_ID INTEGER,
         PAR_NAME CHAR(20),
         PAR_VALUE FLOAT)