USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_auctions]    Script Date: 07/01/2025 19:00:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_auctions](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[title] [varchar](60) NULL,
	[image] [varchar](255) NULL,
	[price] [int] NOT NULL,
	[table_coin] [varchar](50) NULL,
	[column_account] [varchar](50) NULL,
	[coin] [varchar](20) NULL,
	[coin_name] [varchar](20) NULL,
	[date] [datetime] NULL,
	[slug] [varchar](255) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_auctions] ADD  DEFAULT ((0)) FOR [price]
GO



USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_auctions_lance]    Script Date: 07/01/2025 19:00:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_auctions_lance](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[id_auction] [int] NOT NULL,
	[account] [varchar](10) NULL,
	[name] [varchar](10) NULL,
	[price] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_auctions_lance] ADD  DEFAULT ((0)) FOR [id_auction]
GO

ALTER TABLE [dbo].[amw_auctions_lance] ADD  DEFAULT ((0)) FOR [price]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_balance_logs]    Script Date: 07/01/2025 19:01:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_balance_logs](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[account] [varchar](10) NULL,
	[coin_name] [varchar](30) NULL,
	[previous_balance] [int] NOT NULL,
	[current_balance] [int] NOT NULL,
	[route] [varchar](32) NULL,
	[created_at] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_balance_logs] ADD  DEFAULT ((0)) FOR [previous_balance]
GO

ALTER TABLE [dbo].[amw_balance_logs] ADD  DEFAULT ((0)) FOR [current_balance]
GO

ALTER TABLE [dbo].[amw_balance_logs] ADD  CONSTRAINT [DF_amw_balance_logs_created_at]  DEFAULT (getdate()) FOR [created_at]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_buy_logs]    Script Date: 07/01/2025 19:01:19 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_buy_logs](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[buy_id] [int] NULL,
	[AccountID] [varchar](10) NULL,
	[Price] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_download]    Script Date: 07/01/2025 19:01:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_download](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[title] [varchar](255) NULL,
	[date] [datetime] NOT NULL,
	[link] [varchar](100) NULL,
	[description] [varchar](100) NULL,
	[size] [varchar](250) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_download] ADD  DEFAULT ((0)) FOR [date]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_indication]    Script Date: 07/01/2025 19:01:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_indication](
	[user_ref] [varchar](10) NULL,
	[account] [varchar](10) NULL,
	[ip] [varchar](30) NULL,
	[created_at] [varchar](50) NULL
) ON [PRIMARY]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_items]    Script Date: 07/01/2025 19:02:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_items](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [varchar](50) NULL,
	[image] [varchar](255) NULL,
	[section] [int] NOT NULL,
	[id_item] [int] NOT NULL,
	[level] [int] NOT NULL,
	[aditional] [int] NOT NULL,
	[luck] [int] NOT NULL,
	[skill] [int] NOT NULL,
	[durability] [int] NOT NULL,
	[excelent_1] [int] NOT NULL,
	[excelent_2] [int] NOT NULL,
	[excelent_3] [int] NOT NULL,
	[excelent_4] [int] NOT NULL,
	[excelent_5] [int] NOT NULL,
	[excelent_6] [int] NOT NULL,
	[ancient_1] [int] NOT NULL,
	[ancient_2] [int] NOT NULL,
	[harmony] [int] NOT NULL,
	[socket1] [int] NOT NULL,
	[socket2] [int] NOT NULL,
	[socket3] [int] NOT NULL,
	[socket4] [int] NOT NULL,
	[socket5] [int] NOT NULL,
	[coin_name] [varchar](20) NULL,
	[price] [int] NOT NULL,
	[limit_buy] [int] NULL,
	[total_buy] [int] NOT NULL,
	[x] [int] NOT NULL,
	[y] [int] NOT NULL,
	[active] [int] NOT NULL,
	[category_group] [varchar](50) NULL,
	[item_group] [varchar](50) NULL,
	[class] [varchar](5) NULL,
	[attackspeed] [int] NOT NULL,
	[damagemin] [int] NOT NULL,
	[damagemax] [int] NOT NULL,
	[reqstrength] [int] NOT NULL,
	[reqdexterity] [int] NOT NULL,
	[reqenergy] [int] NOT NULL,
	[reqvitality] [int] NOT NULL,
	[dw] [int] NOT NULL,
	[dk] [int] NOT NULL,
	[fe] [int] NOT NULL,
	[mg] [int] NOT NULL,
	[dl] [int] NOT NULL,
	[su] [int] NOT NULL,
	[rf] [int] NOT NULL,
	[magicdurability] [int] NOT NULL,
	[magicrate] [int] NOT NULL,
	[reqlevel] [int] NOT NULL,
	[defense] [int] NOT NULL,
	[defenserate] [int] NOT NULL,
	[magicdefense] [int] NOT NULL,
	[walkspeed] [int] NOT NULL,
	[reqleadership] [int] NOT NULL,
	[uselevel] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [section]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [id_item]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [level]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [aditional]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [luck]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [skill]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((255)) FOR [durability]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [excelent_1]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [excelent_2]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [excelent_3]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [excelent_4]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [excelent_5]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [excelent_6]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [ancient_1]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [ancient_2]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [harmony]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((255)) FOR [socket1]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((255)) FOR [socket2]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((255)) FOR [socket3]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((255)) FOR [socket4]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((255)) FOR [socket5]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [price]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [total_buy]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [x]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [y]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [active]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ('geral') FOR [class]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [attackspeed]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [damagemin]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [damagemax]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [reqstrength]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [reqdexterity]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [reqenergy]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [reqvitality]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [dw]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [dk]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [fe]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [mg]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [dl]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [su]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [rf]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [magicdurability]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [magicrate]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [reqlevel]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [defense]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [defenserate]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [magicdefense]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [walkspeed]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [reqleadership]
GO

ALTER TABLE [dbo].[amw_items] ADD  DEFAULT ((0)) FOR [uselevel]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_items_category]    Script Date: 07/01/2025 19:02:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_items_category](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[name] [varchar](255) NULL,
	[category] [varchar](50) NULL,
	[slug] [varchar](255) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_items_kit_category]    Script Date: 07/01/2025 19:02:19 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_items_kit_category](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[price] [int] NOT NULL,
	[image] [varchar](255) NULL,
	[name] [varchar](255) NULL,
	[coin] [varchar](50) NULL,
	[id_category] [varchar](50) NULL,
	[class] [varchar](5) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_items_kit_category] ADD  DEFAULT ((0)) FOR [price]
GO

ALTER TABLE [dbo].[amw_items_kit_category] ADD  DEFAULT ('geral') FOR [class]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_market_items]    Script Date: 07/01/2025 19:02:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_market_items](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [varchar](255) NULL,
	[account] [varchar](10) NULL,
	[hexa] [varchar](32) NULL,
	[price] [int] NOT NULL,
	[x] [int] NOT NULL,
	[y] [int] NOT NULL,
	[status] [int] NOT NULL,
	[section] [int] NOT NULL,
	[dw] [int] NOT NULL,
	[dk] [int] NOT NULL,
	[fe] [int] NOT NULL,
	[mg] [int] NOT NULL,
	[dl] [int] NOT NULL,
	[su] [int] NOT NULL,
	[rf] [int] NOT NULL,
	[tier] [varchar](50) NULL,
	[zen] [int] NOT NULL,
	[bless] [int] NOT NULL,
	[soul] [int] NOT NULL,
	[life] [int] NOT NULL,
	[chaos] [int] NOT NULL,
	[creation] [int] NOT NULL,
	[guardian] [int] NOT NULL,
	[harmony] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((1)) FOR [price]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [x]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [y]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [status]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [section]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [dw]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [dk]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [fe]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [mg]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [dl]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [su]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [rf]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [zen]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [bless]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [soul]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [life]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [chaos]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [creation]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [guardian]
GO

ALTER TABLE [dbo].[amw_market_items] ADD  DEFAULT ((0)) FOR [harmony]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_notice]    Script Date: 07/01/2025 19:02:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_notice](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[title] [varchar](255) NULL,
	[tag] [varchar](30) NULL,
	[message] [varchar](max) NULL,
	[account] [varchar](15) NULL,
	[date] [datetime] NOT NULL,
	[link] [varchar](100) NULL,
	[slug] [varchar](255) NULL,
	[description] [varchar](100) NULL,
	[comment] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_notice] ADD  DEFAULT ((0)) FOR [date]
GO

ALTER TABLE [dbo].[amw_notice] ADD  DEFAULT ((0)) FOR [comment]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_notice_comments]    Script Date: 07/01/2025 19:02:46 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_notice_comments](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[id_notice] [varchar](255) NULL,
	[message] [varchar](max) NULL,
	[account] [varchar](15) NULL,
	[date] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_notice_comments] ADD  DEFAULT ((0)) FOR [date]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_packages]    Script Date: 07/01/2025 19:02:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_packages](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[title] [varchar](60) NULL,
	[description] [varchar](255) NULL,
	[table_coin_demand] [varchar](50) NULL,
	[column_account_demand] [varchar](50) NULL,
	[coin_demand] [varchar](20) NULL,
	[coin_demand_name] [varchar](20) NULL,
	[price] [int] NOT NULL,
	[table_coin] [varchar](50) NULL,
	[column_account] [varchar](50) NULL,
	[coin] [varchar](20) NULL,
	[quantity] [int] NOT NULL,
	[coin_name] [varchar](20) NULL,
	[vip_type] [int] NOT NULL,
	[vip_time] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_packages] ADD  DEFAULT ((0)) FOR [price]
GO

ALTER TABLE [dbo].[amw_packages] ADD  DEFAULT ((0)) FOR [quantity]
GO

ALTER TABLE [dbo].[amw_packages] ADD  DEFAULT ((0)) FOR [vip_type]
GO

ALTER TABLE [dbo].[amw_packages] ADD  DEFAULT ((0)) FOR [vip_time]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_payment]    Script Date: 07/01/2025 19:03:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_payment](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[price] [int] NOT NULL,
	[order_id] [varchar](255) NULL,
	[transaction_id] [varchar](255) NULL,
	[account] [varchar](10) NULL,
	[due_date] [smalldatetime] NULL,
	[status] [varchar](30) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_payment] ADD  DEFAULT ((0)) FOR [price]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_payment_mp]    Script Date: 07/01/2025 19:03:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_payment_mp](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[price] [int] NOT NULL,
	[order_id] [varchar](255) NULL,
	[account] [varchar](10) NULL,
	[due_date] [smalldatetime] NULL,
	[status] [varchar](30) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_payment_mp] ADD  DEFAULT ((0)) FOR [price]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_payment_mpcardcredit]    Script Date: 07/01/2025 19:03:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_payment_mpcardcredit](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[price] [int] NOT NULL,
	[id_transiction] [varchar](20) NULL,
	[account] [varchar](10) NULL,
	[due_date] [smalldatetime] NULL,
	[status] [varchar](30) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_payment_mpcardcredit] ADD  DEFAULT ((0)) FOR [price]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_slider]    Script Date: 07/01/2025 19:03:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_slider](
	[id] [smallint] IDENTITY(1,1) NOT NULL,
	[title] [varchar](60) NULL,
	[image] [varchar](255) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_tickets]    Script Date: 07/01/2025 19:03:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_tickets](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[subject] [varchar](80) NULL,
	[account] [varchar](10) NULL,
	[name] [varchar](10) NULL,
	[message] [varchar](1000) NULL,
	[image] [varchar](80) NULL,
	[status] [int] NOT NULL,
	[date] [datetime] NULL,
	[slug] [varchar](160) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_tickets] ADD  DEFAULT ((0)) FOR [status]
GO


USE [MuOnline]
GO

/****** Object:  Table [dbo].[amw_tickets_answered]    Script Date: 07/01/2025 19:03:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[amw_tickets_answered](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[id_ticket] [int] NOT NULL,
	[account] [varchar](10) NULL,
	[name] [varchar](10) NULL,
	[message] [varchar](1000) NULL,
	[date] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[amw_tickets_answered] ADD  DEFAULT ((0)) FOR [id_ticket]
GO



