SS CreateCAMPUSDbaseTables.sql

From Seamonster

-- 
-- Created by SQL::Translator::Producer::SQLServer
-- Created on Thu Aug 30 15:19:08 2007
-- 

-- Rob added USE [CAMPUS]
-- Rob deleted (10) after each real
-- Rob changed 1_campus_met to one_campus_met on the CONSTRAINT line

--
-- Table: campus_met
--

-- PostgreSQL database dump

-- TOC entry 4 (OID 2200)

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

-- TOC entry 5 (OID 349120)

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

USE [CAMPUS]

CREATE TABLE campus_met (
  timestamp timestamp NULL,
  temperaturef real NULL,
  dewpointf real NULL,
  pressurein real NULL,
  winddirection text NULL,
  winddirectiondegrees real NULL,
  windspeedmph real NULL,
  windspeedgustmph real NULL,
  humidity real NULL,
  hourlyprecipin real NULL,
  conditions text NULL,
  clouds text NULL,
  dailyrainin real NULL,
  time_epoch integer NULL,
  CONSTRAINT one_campus_met UNIQUE (timestamp)
);