example
=======

This is an example table spec.

Platform support
----------------
Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. **Running a query against an unsupported platform will result in the following error:** ``no such table: example``

- Windows
- Linux
- Mac OSX
- Free BSD

Table schema
------------

======  =======  =====================================
Name    Type     Description                          
======  =======  =====================================
name    TEXT     Description for name column          
points  INTEGER  This is a signed SQLite int column   
size    BIGINT   This is a signed SQLite bigint column
action  TEXT     Action performed in generation       
id      INTEGER  An index of some sort                
path    TEXT     Path of example                      
======  =======  =====================================

Query examples
--------------

.. code-block:: sql

   select * from example where id = 1


.. code-block:: sql

   select name from example where action = 'new'


.. code-block:: sql

   select e.* from example e, example_environments ee where e.id = ee.id