When you have installed SQL Server or if you already had a SQL Server running, it is now time to prepare the database for CardExchange® Visitor. The creation of the database is very basic as we only have create the database and 1 (one) table, the Migrations table. As soon as this table is available and you start CardExchange® Visitor for the first time, it will then create the complete database needed for the application.
Below is the script to create the database and the migrations table:
CREATE DATABASE `cegateway`;
USE cegateway
GO
CREATE TABLE "tblSystem_Migrations"(
[ID] INT PRIMARY KEY IDENTITY(1,1),
[Version] INT NOT NULL,
[MigrationDate] DATETIME NOT NULL
)
