From 127e9c707f0cbd41826b7b8850273f7e5eb0f0a0 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Mon, 15 Feb 2016 17:00:44 -0500
Subject: [PATCH] Adding a new table file

---
 new-event-tables.md | 65 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 65 insertions(+)
 create mode 100644 new-event-tables.md

diff --git a/new-event-tables.md b/new-event-tables.md
new file mode 100644
index 0000000..4f8b2ce
--- /dev/null
+++ b/new-event-tables.md
@@ -0,0 +1,65 @@
+#Event Tables
+
+## Categories
+id            INT
+name          TEXT
+description   TEXT
+
+## Events
+id            INT
+created       DATE
+updated       DATE
+approved      DATE
+starting      DATE
+ending        DATE
+starting_hour TIME
+ending_hour   TIME
+title         TEXT
+description   TEXT
+intro         TEXT
+website       TEXT
+ticket_url    TEXT
+cost          TEXT
+venue         TEXT
+contact       INT
+admin_contact INT
+all_day       BOOLEAN
+repeat        BOOLEAN
+dow           INT
+dayom         INT
+weekom        INT
+
+## Event Times
+id            INT
+event         INT
+starting      DATE
+ending        DATE
+starting_hour TIME
+ending_hour   TIME
+
+## Category to Events
+id            INT
+category      TEXT
+event         TEXT
+
+## Contacts
+id            INT
+name          TEXT
+email         TEXT
+phone         TEXT
+organization  TEXT
+
+## Venue
+id            INT
+place         TEXT
+address       TEXT
+city          TEXT
+state         INT
+zip           TEXT
+lat           FLOAT
+lon           FLOAT
+
+## State
+id            INT
+name          TEXT
+abbr          TEXT
-- 
2.17.1