BEGIN;

CREATE TABLE "tb_appointments" (
  "ID" SERIAL, 
  "ItemID" VARCHAR(15), 
  "EntryID" TEXT, 
  "Start" TIMESTAMP WITHOUT TIME ZONE, 
  "End" TIMESTAMP WITHOUT TIME ZONE, 
  "Subject" VARCHAR(255), 
  "Body" TEXT, 
  "Owner" VARCHAR(255), 
  "Item" VARCHAR(255), 
  "Actions" INTEGER, 
  "AllDayEvent" INTEGER NOT NULL, 
  "BillingInformation" VARCHAR(255), 
  "BusyStatus" INTEGER, 
  "Categories" TEXT, 
  "Companies" VARCHAR(255), 
  "ConferenceServerAllowExternal" INTEGER NOT NULL, 
  "ConferenceServerPassword" VARCHAR(255), 
  "ConversationIndex" TEXT, 
  "ConversationTopic" VARCHAR(255), 
  "Importance" INTEGER, 
  "IsOnlineMeeting" INTEGER NOT NULL, 
  "IsRecurring" INTEGER NOT NULL, 
  "Links" INTEGER, 
  "LinkIDS" TEXT, 
  "Location" VARCHAR(255), 
  "MeetingStatus" VARCHAR(255), 
  "MessageClass" VARCHAR(255), 
  "Mileage" VARCHAR(255), 
  "NetMeetingAutoStart" INTEGER NOT NULL, 
  "NetMeetingDocPathName" VARCHAR(255), 
  "NetMeetingOrganizerAlias" VARCHAR(255), 
  "NetMeetingServer" VARCHAR(255), 
  "NetMeetingType" INTEGER, 
  "NetShowURL" VARCHAR(255), 
  "NoAging" INTEGER NOT NULL, 
  "OptionalAttendees" TEXT, 
  "Organizer" VARCHAR(255), 
  "Recipients" INTEGER, 
  "RecipientsMailAddress" TEXT, 
  "RecurrenceState" INTEGER, 
  "ReminderMinutesBeforeStart" INTEGER, 
  "ReminderOverrideDefault" INTEGER NOT NULL, 
  "ReminderPlaySound" INTEGER NOT NULL, 
  "ReminderSet" INTEGER NOT NULL, 
  "ReminderSoundFile" VARCHAR(255), 
  "ReplyTime" TIMESTAMP WITHOUT TIME ZONE, 
  "RequiredAttendees" TEXT, 
  "Resources" VARCHAR(255), 
  "ResponseRequested" INTEGER NOT NULL, 
  "ResponseStatus" INTEGER, 
  "Sensitivity" INTEGER, 
  "Unread" INTEGER NOT NULL, 
  "DayOfMonth" INTEGER, 
  "DayOfWeekMask" INTEGER, 
  "Duration" INTEGER, 
  "StartTime" TIMESTAMP WITHOUT TIME ZONE, 
  "EndTime" TIMESTAMP WITHOUT TIME ZONE, 
  "Exceptions" INTEGER, 
  "Instance" INTEGER, 
  "Interval" INTEGER, 
  "MonthOfYear" INTEGER, 
  "NoEndDate" INTEGER NOT NULL, 
  "Occurrences" INTEGER, 
  "PatternEndDate" TIMESTAMP WITHOUT TIME ZONE, 
  "PatternStartDate" TIMESTAMP WITHOUT TIME ZONE, 
  "RecurrenceType" INTEGER, 
  "Regenerate" INTEGER NOT NULL, 
  "Deleted" INTEGER NOT NULL, 
  "OriginalDate" TIMESTAMP WITHOUT TIME ZONE, 
  "Department" VARCHAR(255), 
  CONSTRAINT "tb_appointments_pkey" PRIMARY KEY("ID")
) WITH OIDS;

CREATE INDEX "tb_appointments_entryid_idx" ON "tb_appointments"
  USING btree ("EntryID");

CREATE INDEX "tb_appointments_itemid_idx" ON "tb_appointments"
  USING btree ("ItemID");

CREATE INDEX "tb_appointments_nmdpn_idx" ON "tb_appointments"
  USING btree ("NetMeetingDocPathName");

CREATE INDEX "tb_appointments_item_idx" ON "tb_appointments"
  USING btree ("Item");

COMMIT;