Configuration

SQL script to create database

CREATE DATABASE saasapp;

USE saasapp;

DROP TABLE IF EXISTS Account;

CREATE TABLE Account ( Name varchar(32) NOT NULL, FriendlyName varchar(32) DEFAULT NULL, IsActive tinyint(1) DEFAULT NULL, PlanType int(11) DEFAULT NULL, PRIMARY KEY (Name) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS User;

CREATE TABLE User ( Username varchar(32) NOT NULL, Account varchar(32) NOT NULL, Password varchar(96) DEFAULT NULL, Salt varchar(48) DEFAULT NULL, IsActive tinyint(1) DEFAULT NULL, IsAdmin tinyint(1) DEFAULT NULL, Email varchar(64) DEFAULT NULL, Phone varchar(16) DEFAULT NULL, PRIMARY KEY (Username,Account) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

web.config configuration

<add name="SaasApp" connectionString="Server=localhost;Database=saasapp;Uid=saasapp;Pwd=saasapp;" providerName="MySql.Data.MySqlClient"/>

connection string for the mysql database backend

<add key="AppName" value="SaasApp"/>

name of the app

<add key="CopyrightText" value="SaasApp Company 2011"/>

copyright text

<add key="BaseUrl" value="localhost:3203"/>

base url used for parsing subdomain

<add key="FromEmail" value="test@somedomain.com"/>

from email address used in email communication

<add key="SMTPServer" value="smtp.somedomain.com"/>

smtp server to be used for email communication

<add key="SMTPPort" value="587"/>

smtp server port to be used for email communication

<add key="SMTPUser" value="test@somedomain.com"/>

smtp username used for sending emails

<add key="SMTPPassword" value="password"/>

smtp username password to be used for email communication

<add key="ForgotPasswordEmailSubject" value="SaasApp - password reset"/>

email subject to be used in forgot password email

<add key="ForgotPasswordEmailBody" value="New password - *password*"/>

email body to be used in forgot password email

<add key="UserExistsErrorMessage" value="Username already exists. Please enter another username."/>

New url routes

For creating new url routes instead of modifying Global.asax, modify DomainRoute.cs