# Installation

1. Drag and drop the resource into your `resources` folder

2. Ensure that it is started **after** lb-phone, ex:

   ```cfscript
   start lb-phone
   start devm-tea-app
   ```

3. The SQL should import automatically, however if it doesnt, run this: 

   ```sql
   CREATE TABLE IF NOT EXISTS `tea_comments` (
     `id` int(11) NOT NULL AUTO_INCREMENT,
     `post_id` int(11) NOT NULL,
     `author_identifier` varchar(64) NOT NULL,
     `message` text NOT NULL,
     `created_at` timestamp NULL DEFAULT current_timestamp(),
     PRIMARY KEY (`id`),
     KEY `post_id` (`post_id`),
     CONSTRAINT `tea_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `tea_posts` (`id`) ON DELETE CASCADE
   ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

   CREATE TABLE IF NOT EXISTS `tea_posts` (
     `id` int(11) NOT NULL AUTO_INCREMENT,
     `author_identifier` varchar(64) NOT NULL,
     `title` varchar(255) NOT NULL,
     `image_url` text DEFAULT NULL,
     `description` text DEFAULT NULL,
     `created_at` timestamp NULL DEFAULT current_timestamp(),
     `like_count` int(11) NOT NULL DEFAULT 0,
     `dislike_count` int(11) NOT NULL DEFAULT 0,
     PRIMARY KEY (`id`)
   ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

   CREATE TABLE IF NOT EXISTS `tea_post_reactions` (
     `id` int(11) NOT NULL AUTO_INCREMENT,
     `post_id` int(11) NOT NULL,
     `reactor_identifier` varchar(64) NOT NULL,
     `reaction` enum('like','dislike') NOT NULL,
     `created_at` timestamp NULL DEFAULT current_timestamp(),
     PRIMARY KEY (`id`),
     UNIQUE KEY `uniq_post_reactor` (`post_id`,`reactor_identifier`),
     CONSTRAINT `tea_post_reactions_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `tea_posts` (`id`) ON DELETE CASCADE
   ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

   CREATE TABLE IF NOT EXISTS `tea_profiles` (
     `identifier` varchar(64) NOT NULL,
     `username` varchar(64) NOT NULL DEFAULT '',
     `avatar` text DEFAULT NULL,
     PRIMARY KEY (`identifier`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

   ```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.devm.cc/tea-app/installation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.