Configuration

FILEPATH: /d:/Projects/1bytesoftware/sql/table-scripts/JFW.Configuration.Table.sql

This script creates a table named `[JFW]`.[Configuration] in the `[JFW_live]` database.

Table Structure:
- `[ID]`: bigint, `auto-incrementing primary key`
- `[Brand_ID]`: bigint, `nullable`
- `[User_ID]`: bigint, `nullable`
- `[Group_Code]`: varchar(100), `not null`
- `[Code]`: varchar(100), `not null`
- `[Name]`: varchar(100), `not null`
- `[Description]`: nvarchar(240), `nullable`
- `[Value]`: nvarchar(max), `nullable`
- `[Status]`: smallint, `not null`
- `[Is_System]`: bit, `not null`
- `[Modified_By]`: bigint, `nullable`
- `[Modified_Date]`: datetime, `not null`
- `[Created_By]`: bigint, `nullable`
- `[Created_Date]`: datetime, `not null`

Constraints:
- Primary Key: `[ID]`
- Default Constraint: `[Status]` (default value: 1)
- Default Constraint: `[Is_System]` (default value: 0)
- Default Constraint: `[Modified_Date]` (default value: current UTC date)
- Default Constraint: `[Created_Date]` (default value: current UTC date)

Note: This script assumes that the `[JFW_live]` database already exists.