Database

Manage your SQL Server database for the cannabis content network.

Quick Fix: Domains Table

Fix common issues with the Domains table structure.

If you're having issues with the domain editing page, you may need to add the HeroImage column to the Domains table.

Add the HomepageContent column to the Domains table to enable custom homepage content for each domain.

Database Schema Updater

Ensure your database has all required columns and tables

Database Size

245 MB

24.5% of 1 GB allocation

Total Records

12,458

35%

+1,234 records this month

Query Performance

124 ms

Average query response time

Backup Status

12h ago

Last backup: Oct 15, 2023 at 3:45 AM

Database Schema

SQL Server database schema for the cannabis content network.

CREATE TABLE Domains (
  DomainID INT PRIMARY KEY IDENTITY(1,1),
  DomainName NVARCHAR(255) NOT NULL,
  SiteName NVARCHAR(255) NOT NULL,
  Description NVARCHAR(MAX),
  Status NVARCHAR(50) DEFAULT 'active',
  SEOTitle NVARCHAR(255),
  SEODescription NVARCHAR(MAX),
  AnalyticsID NVARCHAR(100),
  CreatedAt DATETIME DEFAULT GETDATE(),
  UpdatedAt DATETIME DEFAULT GETDATE()
);