Hello
Where can I find script(QA) to add MuCore tables in MuOnline db? I just can't install my web again, so if someone can give me a script I will really appreciate.
Printable View
Hello
Where can I find script(QA) to add MuCore tables in MuOnline db? I just can't install my web again, so if someone can give me a script I will really appreciate.
USE [MuOnline]Quote:
Originally Posted by Zitinho
GO
/****** Object: Table [dbo].[MUCore_Ban] Script Date: 03/23/2015 19:27:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MUCore_Ban](
[id] [int] IDENTITY(1,1) NOT NULL,
[ban_id] [int] NULL,
[type] [int] NULL,
[ban_date] [int] NULL,
[ban_expire] [int] NULL,
[reason] [text] NULL,
[ban_name] [varchar](50) NULL,
[ban_permanent] [int] NULL,
[author] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [MuOnline]
GO
/****** Object: Table [dbo].[MUCore_Change_Passwords] Script Date: 03/23/2015 19:28:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MUCore_Change_Passwords](
[id] [int] IDENTITY(1,1) NOT NULL,
[password] [varchar](50) NULL,
[email] [varchar](70) NULL,
[expire] [int] NULL,
[memb___id] [varchar](50) NULL,
[hash] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [MuOnline]
GO
/****** Object: Table [dbo].[MUCore_Cron_Jobs] Script Date: 03/23/2015 19:28:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MUCore_Cron_Jobs](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [text] NULL,
[cron_id] [varchar](50) NULL,
[next_cron] [int] NULL,
[cron_time_set] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [MuOnline]
GO
/****** Object: Table [dbo].[MUCore_PayPal_Donate_Orders] Script Date: 03/23/2015 19:29:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MUCore_PayPal_Donate_Orders](
[id] [int] IDENTITY(1,1) NOT NULL,
[donate_id] [varchar](50) NULL,
[amount] [varchar](50) NULL,
[currency] [varchar](50) NULL,
[credits] [int] NULL,
[memb___id] [varchar](50) NULL,
[hash] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [MuOnline]
GO
/****** Object: Table [dbo].[MUCore_PayPal_Donate_Transactions] Script Date: 03/23/2015 19:29:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MUCore_PayPal_Donate_Transactions](
[id] [int] IDENTITY(1,1) NOT NULL,
[transaction_id] [varchar](50) NULL,
[amount] [varchar](50) NULL,
[currency] [varchar](50) NULL,
[memb___id] [varchar](50) NULL,
[credits] [int] NULL,
[order_date] [int] NULL,
[status] [varchar](50) NULL,
[payer_email] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [MuOnline]
GO
/****** Object: Table [dbo].[MUCore_Shop_Items] Script Date: 03/23/2015 19:29:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MUCore_Shop_Items](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
[i_type] [int] NULL,
[i_id] [int] NULL,
[credits] [int] NULL,
[serial] [int] NULL,
[i_luck_option] [int] NULL,
[i_skill_option] [int] NULL,
[size_x] [int] NULL,
[size_y] [int] NULL,
[i_default_durability] [int] NULL,
[i_maximum_durability] [int] NULL,
[category] [int] NULL,
[i_max_excelent_option] [int] NULL,
[i_max_option] [int] NULL,
[i_max_level] [int] NULL,
[i_refined_option] [int] NULL,
[i_harmony_option] [int] NULL,
[i_socket_option] [int] NULL,
[i_option] [int] NULL,
[i_exc_option] [int] NULL,
[class_requirement] [text] NULL,
[ancient_id] [int] NULL,
[i_stock] [nvarchar](25) NULL,
[i_image] [nvarchar](50) NULL,
[i_sell] [int] NULL,
[exc_anc] [int] NULL,
[i_stick_level] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
USE [MuOnline]
GO
/****** Object: Table [dbo].[MUCore_Shop_Logs] Script Date: 03/23/2015 19:30:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MUCore_Shop_Logs](
[id] [int] IDENTITY(1,1) NOT NULL,
[memb___id] [nvarchar](50) NULL,
[content] [text] NULL,
[date_time] [int] NULL,
[item_serial] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
USE [MuOnline]
GO
/****** Object: Table [dbo].[MUCore_temp_passwords] Script Date: 03/23/2015 19:30:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MUCore_temp_passwords](
[id] [int] IDENTITY(1,1) NOT NULL,
[memb_guid] [int] NULL,
[expire] [int] NULL,
[hash] [char](50) NULL,
[memb___id] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [MuOnline]
GO
/****** Object: Table [dbo].[MUCore_VoteCredits] Script Date: 03/23/2015 19:31:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MUCore_VoteCredits](
[vote_id] [varchar](50) NULL,
[username] [varchar](10) NULL,
[vote_time] [bigint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [MuOnline]
GO
/****** Object: Table [dbo].[MUCore_VoteCreditsIp] Script Date: 03/23/2015 19:31:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MUCore_VoteCreditsIp](
[username] [varchar](50) NOT NULL,
[deletetime] [bigint] NULL,
[ip] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
@UP I've found my own in my db backups but thanks anyway :)