Dreams Database Setup

Adding indexes...

Table Structure:

TABLE: DREAM_EXPLANATIONS
--------------------------------------------------
explanation_id       integer         NOT NULL
dream_id             integer         NULL
interpreter_name     character varying NULL
interpreter_country  character varying NULL
interpreter_username character varying NULL
explanation          text            NULL
spiritual_basis      text            NULL
timestamp            timestamp without time zone NULL

TABLE: DREAMS
--------------------------------------------------
dream_id             integer         NOT NULL
device_id            character varying NOT NULL
dream_title          character varying NOT NULL
dream_content        text            NOT NULL
dream_date           date            NOT NULL
timestamp            timestamp without time zone NULL

Testing Database Operations:

Next steps:

• Delete this setup.php file from your server for security
• Test your Android app
• Visit dream.php?action=get_dreams to test the API