/*
 * This file contains example SQL queries to help development of the DBC module.
 */

/* Table creation */
CREATE TABLE `someTable` (
  `Frame` int(4) PRIMARY KEY,
  `Scalar` float,
  `Vector` varchar(32),
  `String` char(255)
);

/* Retrieve a list tables in the database */
SHOW TABLES;							 /* MySQL */
SELECT * FROM INFORMATION_SCHEMA.TABLES; /* SQL Server, Oracle */

/* Retrieve a list of columns for the specified table */
DESC sometable;

/* Inserting a record */
INSERT INTO `someTable` (`Frame`, `Scalar`, `Vector`, `String`) VALUES ('5', '3.14159', '0.5 0.6 0.7', 'This is a test string');

/* Retrieving records */
SELECT * FROM `someTable`;

/* Deletion of a table */
DROP TABLE IF EXISTS `someTable`;