# TLCI Backend Commands

## Database Setup and Management

```bash
# Initialize the database (create tables and run migrations)
npm run setup:db

# Check database setup status
npm run check

# Initialize Sequelize (if needed)
npm run sequelize:init
```

## Migrations

```bash
# Run all pending migrations
npm run migrate:up

# Undo all migrations
npm run migrate:undo

# Create a new migration
npm run make:migration <migration-name>
```

## Seeders

```bash
# Run all seeders
npm run seeder:up

# Undo all seeders
npm run seeder:undo

# Run a specific seeder
npm run seeder:seed 20250730090000-privacy-policy-page.cjs

# Run a specific seeder
npm run seeder:seed 20250730090001-about-us-page.cjs

# Run both migrations and seeders
npm run database:up

# Undo both seeders and migrations
npm run database:undo

# Create a new seeder
npm run make:seeder <seeder-name>
```

## Available Seeders

1. `20250730083959-demo-user.cjs` - Creates demo user accounts
2. `20250730090000-privacy-policy-page.cjs` - Creates privacy policy page content
3. `20250730090001-about-us-page.cjs` - Creates about us page content

## Development

```bash
# Start the server
npm start

# Start the server in development mode with auto-reload
npm run dev
```