Originally Posted by
gifer
USE MuOnline
GO
CREATE TABLE [dbo].[MUCore_Cron_Jobs] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[cron_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[next_cron] [int] NULL ,
[cron_time_set] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[MUCore_PayPal_Donate_Orders] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[donate_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[amount] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[currency] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[credits] [int] NULL ,
[memb___id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[hash] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MUCore_PayPal_Donate_Transactions] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[transaction_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[amount] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[currency] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[memb___id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[credits] [int] NULL ,
[order_date] [int] NULL ,
[status] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[payer_email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MUCore_Shop_Items](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS 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] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ancient_id] [int] NULL,
[i_stock] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[i_image] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[i_sell] [int] NULL,
[exc_anc] [int] NULL,
[i_stick_level] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[MUCore_Shop_Logs](
[id] [int] IDENTITY(1,1) NOT NULL,
[memb___id] [nvarchar](50) COLLATE Polish_CI_AS NULL,
[content] [text] COLLATE Polish_CI_AS NULL,
[date_time] [int] NULL,
[item_serial] [text] COLLATE Polish_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[MUCore_temp_passwords] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[memb_guid] [int] NULL ,
[expire] [int] NULL ,
[hash] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[memb___id] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
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] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ban_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ban_permanent] [int] NULL ,
[author] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[MUCore_Change_Passwords] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[password] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[email] [varchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[expire] [int] NULL ,
[memb___id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[hash] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MEMB_CREDITS] (
[memb___id] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[credits] [int] NOT NULL ,
[used] [int] NULL
) ON [PRIMARY]
GO
alter table Character add Grand_Resets int not null default 0
GO
alter table Character add mu_id int identity
GO
alter table Character add Resets int not null default 0
GO
alter table memb_info add confirmed int null
alter table memb_info add Country int null
alter table memb_info add Gender int null
alter table memb_info add SecretAnswer varchar(100) null
alter table memb_info add SecretQuestion int null
alter table memb_info add activation_id varchar(50) null
GO
INSERT INTO MUCore_Cron_Jobs (name,cron_id,next_cron,cron_time_set) VALUES ('Rankings All Characters','1','1','3600')
INSERT INTO MUCore_Cron_Jobs (name,cron_id,next_cron,cron_time_set) VALUES ('Rankings Class Filter','2','1','3600')
INSERT INTO MUCore_Cron_Jobs (name,cron_id,next_cron,cron_time_set) VALUES ('Guild Rankings','3','1','3600')
INSERT INTO MUCore_Cron_Jobs (name,cron_id,next_cron,cron_time_set) VALUES ('Clean Temporary Lost Passwords Requests','4','1','21600')
INSERT INTO MUCore_Cron_Jobs (name,cron_id,next_cron,cron_time_set) VALUES ('Clean Change Passwords Requests','5','1','21600')
GO