SS CreateMGTDbaseTables.sql

From Seamonster
Jump to: navigation, search
-- 
-- Created by SQL::Translator::Producer::SQLServer
-- Created on Thu Aug 30 15:19:21 2007
-- 

-- Rob added USE [MGT], x'd (10) on reals, 1_mgt -> one_mgt

USE [MGT]

--
-- Table: mgt_met
--

-- PostgreSQL database dump

-- TOC entry 4 (OID 2200)

-- Name: public; Type: ACL; Schema: -; Owner: postgres

-- TOC entry 5 (OID 338562)

-- Name: mgt_met; Type: TABLE; Schema: public; Owner: seamonster

CREATE TABLE mgt_met (
  timestamp timestamp NULL,
  percip real NULL,
  temp real NULL,
  humid real NULL,
  wind real NULL,
  winddir real NULL,
  time_epoch integer NULL,
  CONSTRAINT one_mgt_met UNIQUE (timestamp)
);