d2WMpYqQ

1DROP TABLE IF EXISTS [wps_pagesettings_codes];
2CREATE TABLE wps_pagesettings_codes (
3  [id] int check ([id] > 0) NOT NULL IDENTITY,
4  [code] varchar(max) NOT NULL,
5  [use_limit] int NOT NULL DEFAULT '1',
6  [created_at] datetime2(0) NULL DEFAULT NULL,
7  [updated_at] datetime2(0) NULL DEFAULT NULL,
8  [deleted_at] datetime2(0) NULL DEFAULT NULL,
9  [is_active] smallint NOT NULL,
10  PRIMARY KEY ([id])
11)  ;
12
13
14DROP TABLE IF EXISTS [wps_pagesettings_code_affiliate];
15CREATE TABLE wps_pagesettings_code_affiliate (
16  [id_code] int NOT NULL,
17  [id_affiliate] int NOT NULL,
18  PRIMARY KEY ([id_code],[id_affiliate])
19)  ;