Most visitors online was 10387 , on 26 Apr 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!
- USE [SDXPanel]
- GO
- /****** Object: Table [dbo].[Votes] Script Date: 05/23/2017 21:46:38 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[Votes](
- [id] [int] IDENTITY(1,1) NOT NULL,
- [title] [varchar](100) NULL,
- [link] [varchar](100) NULL,
- [image] [varchar](100) NULL,
- [callback] [varchar](100) NULL,
- [points] [int] NULL,
- [status] [int] NULL,
- [created_at] [datetime] NULL,
- [updated_at] [datetime] NULL
- ) ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- /****** Object: Table [dbo].[UserPoints] Script Date: 05/23/2017 21:46:38 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[UserPoints](
- [id] [int] IDENTITY(1,1) NOT NULL,
- [UserNum] [int] NULL,
- [EPoints] [nvarchar](max) NULL,
- [VPoints] [nvarchar](max) NULL
- ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
- GO
- /****** Object: Table [dbo].[UserLogs] Script Date: 05/23/2017 21:46:38 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[UserLogs](
- [id] [int] IDENTITY(1,1) NOT NULL,
- [UserNum] [int] NULL,
- [type] [int] NULL,
- [identifier] [varchar](max) NULL,
- [text] [varchar](max) NULL,
- [ip] [varchar](50) NULL,
- [created_at] [datetime] NULL
- ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- /****** Object: Table [dbo].[TopupCodes] Script Date: 05/23/2017 21:46:38 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[TopupCodes](
- [id] [int] IDENTITY(1,1) NOT NULL,
Code:[varchar](100) NULL,[/COLOR] [*][COLOR=#333333] [secret_code] [varchar](50) NULL,[/COLOR] [*][COLOR=#333333] [points] [int] NULL,[/COLOR] [*][COLOR=#333333] [type] [int] NULL,[/COLOR] [*][COLOR=#333333] [status] [int] NULL,[/COLOR] [*][COLOR=#333333] [created_at] [datetime] NULL,[/COLOR] [*][COLOR=#333333] [claimed_at] [datetime] NULL[/COLOR] [*][COLOR=#333333]) ON [PRIMARY][/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING OFF[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]/****** Object: Table [dbo].[Tickets] Script Date: 05/23/2017 21:46:38 ******/[/COLOR] [*][COLOR=#333333]SET ANSI_NULLS ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET QUOTED_IDENTIFIER ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]CREATE TABLE [dbo].[Tickets]([/COLOR] [*][COLOR=#333333] [id] [int] IDENTITY(1,1) NOT NULL,[/COLOR] [*][COLOR=#333333] [UserNum] [int] NULL,[/COLOR] [*][COLOR=#333333] [subject] [varchar](50) NULL,[/COLOR] [*][COLOR=#333333] [content] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [status] [int] NULL,[/COLOR] [*][COLOR=#333333] [category_id] [int] NULL,[/COLOR] [*][COLOR=#333333] [created_at] [datetime] NULL,[/COLOR] [*][COLOR=#333333] [updated_at] [datetime] NULL[/COLOR] [*][COLOR=#333333]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY][/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING OFF[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]/****** Object: Table [dbo].[ticket_comments] Script Date: 05/23/2017 21:46:38 ******/[/COLOR] [*][COLOR=#333333]SET ANSI_NULLS ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET QUOTED_IDENTIFIER ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]CREATE TABLE [dbo].[ticket_comments]([/COLOR] [*][COLOR=#333333] [id] [int] IDENTITY(1,1) NOT NULL,[/COLOR] [*][COLOR=#333333] [ticket_id] [int] NULL,[/COLOR] [*][COLOR=#333333] [content] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [UserNum] [int] NULL,[/COLOR] [*][COLOR=#333333] [created_at] [datetime] NULL,[/COLOR] [*][COLOR=#333333] [updated_at] [datetime] NULL[/COLOR] [*][COLOR=#333333]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY][/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING OFF[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]/****** Object: Table [dbo].[ShopCtg] Script Date: 05/23/2017 21:46:38 ******/[/COLOR] [*][COLOR=#333333]SET ANSI_NULLS ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET QUOTED_IDENTIFIER ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]CREATE TABLE [dbo].[ShopCtg]([/COLOR] [*][COLOR=#333333] [id] [int] IDENTITY(1,1) NOT NULL,[/COLOR] [*][COLOR=#333333] [name] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [description] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [created_at] [datetime] NULL,[/COLOR] [*][COLOR=#333333] [updated_at] [datetime] NULL[/COLOR] [*][COLOR=#333333]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY][/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING OFF[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]/****** Object: Table [dbo].[News] Script Date: 05/23/2017 21:46:38 ******/[/COLOR] [*][COLOR=#333333]SET ANSI_NULLS ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET QUOTED_IDENTIFIER ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]CREATE TABLE [dbo].[News]([/COLOR] [*][COLOR=#333333] [id] [int] IDENTITY(1,1) NOT NULL,[/COLOR] [*][COLOR=#333333] [UserNum] [int] NULL,[/COLOR] [*][COLOR=#333333] [title] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [body] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [description] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [type] [int] NULL,[/COLOR] [*][COLOR=#333333] [status] [int] NULL,[/COLOR] [*][COLOR=#333333] [created_at] [datetime] NULL,[/COLOR] [*][COLOR=#333333] [updated_at] [datetime] NULL[/COLOR] [*][COLOR=#333333]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY][/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING OFF[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]/****** Object: Table [dbo].[migrations] Script Date: 05/23/2017 21:46:38 ******/[/COLOR] [*][COLOR=#333333]SET ANSI_NULLS ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET QUOTED_IDENTIFIER ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]CREATE TABLE [dbo].[migrations]([/COLOR] [*][COLOR=#333333] [id] [int] IDENTITY(1,1) NOT NULL,[/COLOR] [*][COLOR=#333333] [migration] [nvarchar](255) NOT NULL,[/COLOR] [*][COLOR=#333333] [batch] [int] NOT NULL,[/COLOR] [*][COLOR=#333333]PRIMARY KEY CLUSTERED[/COLOR] [*][COLOR=#333333]([/COLOR] [*][COLOR=#333333] [id] ASC[/COLOR] [*][COLOR=#333333])WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY][/COLOR] [*][COLOR=#333333]) ON [PRIMARY][/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]/****** Object: Table [dbo].[Downloads] Script Date: 05/23/2017 21:46:38 ******/[/COLOR] [*][COLOR=#333333]SET ANSI_NULLS ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET QUOTED_IDENTIFIER ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]CREATE TABLE [dbo].[Downloads]([/COLOR] [*][COLOR=#333333] [id] [int] IDENTITY(1,1) NOT NULL,[/COLOR] [*][COLOR=#333333] [title] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [link] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [type] [int] NULL,[/COLOR] [*][COLOR=#333333] [status] [int] NULL,[/COLOR] [*][COLOR=#333333] [created_at] [datetime] NULL,[/COLOR] [*][COLOR=#333333] [updated_at] [datetime] NULL[/COLOR] [*][COLOR=#333333]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY][/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING OFF[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]/****** Object: Table [dbo].[AdminLogs] Script Date: 05/23/2017 21:46:38 ******/[/COLOR] [*][COLOR=#333333]SET ANSI_NULLS ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET QUOTED_IDENTIFIER ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING ON[/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]CREATE TABLE [dbo].[AdminLogs]([/COLOR] [*][COLOR=#333333] [id] [int] IDENTITY(1,1) NOT NULL,[/COLOR] [*][COLOR=#333333] [UserNum] [int] NULL,[/COLOR] [*][COLOR=#333333] [type] [int] NULL,[/COLOR] [*][COLOR=#333333] [identifier] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [text] [varchar](max) NULL,[/COLOR] [*][COLOR=#333333] [ip] [varchar](50) NULL,[/COLOR] [*][COLOR=#333333] [created_at] [datetime] NULL[/COLOR] [*][COLOR=#333333]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY][/COLOR] [*][COLOR=#333333]GO[/COLOR] [*][COLOR=#333333]SET ANSI_PADDING OFF[/COLOR] [*][COLOR=#333333]GO[/COLOR] [/LIST] [/QUOTE]