Untitled

mail@pastecode.io avatar
unknown
sqlserver
16 days ago
2.7 kB
5
Indexable
Never
CREATE TABLE [dbo].[DmN_Partner_Access_Ips](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [varchar](50) NULL,
	[ip] [varchar](100) NULL,
 CONSTRAINT [PK_DmN_Partner_Access_Ips] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[DmN_Partner_Coupons](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[coupon] [varchar](50) NULL,
	[amount] [int] NOT NULL DEFAULT 0,
	[type] [int] NOT NULL DEFAULT 0,
	[username] [varchar](50) NULL,
	[server] [varchar](50) NULL,
	[status] [int] NOT NULL DEFAULT 0,
	[date_generated] [datetime] NULL,
	[code_count] [int] NOT NULL DEFAULT 1,
 CONSTRAINT [PK_DmN_Partner_Coupons] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[DmN_Partner_Credits_Limit](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [varchar](50) NULL,
	[server] [varchar](50) NULL,
	[date] [datetime] NULL,
	[limit_left] [int] NOT NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[DmN_Partner_Share_Log](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [partner] [VARCHAR](50) NULL,
    [amount] [FLOAT] NULL,
    [fullAmount] [FLOAT] NULL,
    [username] [VARCHAR](50) NULL,
    [server] [VARCHAR](50) NULL,
    [purchaseDate] [datetime] NULL,
 CONSTRAINT [PK_DmN_Partner_Share_Log] PRIMARY KEY CLUSTERED 
(
    [id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[DmN_Partner_Stream_Log](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [username] [VARCHAR](50) NULL,
    [stream_time] [INT] NULL,
    [DAY] [DATE] NULL,
    [last_stream_started] [INT] NULL,
	[last_checked] [INT] NULL,
	[platform] [VARCHAR](50) NULL,
 CONSTRAINT [PK_DmN_Partner_Stream_Log] PRIMARY KEY CLUSTERED 
(
    [id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[DmN_Partner_Used_Coupons](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[coupon] [varchar](50) NULL,
	[username] [varchar](50) NULL,
	[server] [varchar](50) NULL,
	[date_used] [datetime] NULL,
	[generated_by] [varchar](50) NULL,
	[ip] [varchar](100) NULL,
 CONSTRAINT [PK_DmN_Partner_Used_Coupons] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Leave a Comment