تخطي للذهاب إلى المحتوى

Database Creation and Configuration

Complete guide for setting up the database for your application


Database: ivms (MySQL)

CREATE DATABASE IF NOT EXISTS ivms CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Table: attlog (MySQL)

CREATE TABLE attlog (...);

Insert Data (MySQL)

INSERT INTO attlog (...) VALUES (...);

Database: ivms (SQL Server)

CREATE DATABASE [ivms] ON PRIMARY (...)

Table: dbo.attlog (SQL Server)

CREATE TABLE [dbo].[attlog] (...);

Insert Data (SQL Server)

INSERT INTO [dbo].[attlog] (...) VALUES (...);