 -- Table structure for table `phoenix_globals`
 --
 
-DROP TABLE IF EXISTS `phoenix_globals`;
 CREATE TABLE `phoenix_globals` (
   `Variable` varchar(256) NOT NULL,
   `Value` varchar(256) NOT NULL

-- Table structure for table `phoenix_students`
--

DROP TABLE IF EXISTS `phoenix_students`;
CREATE TABLE `phoenix_students` (
  `PUID` varchar(9) NOT NULL,
  `FirstName` varchar(40) NOT NULL,
  `LastName` varchar(60) NOT NULL,
  `Floor` varchar(3) NOT NULL,
  `Year` int(11) NOT NULL,
  `IsRA` int(11) NOT NULL DEFAULT '0',
  `DateCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `IsCurrent` tinyint(1) NOT NULL DEFAULT '1',
  `DateArchived` datetime DEFAULT NULL,
  `TotalEvents` int(11) NOT NULL DEFAULT '0',
  `TotalPoints` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Table structure for table `phoenix_events`
--

CREATE TABLE `phoenix_events` (
  `Id` int(11) NOT NULL,
  `Title` varchar(200) NOT NULL,
