📄 main_mssql.sql

📁 JA++的最新...很多ROSF都用这个 ] 是个不错的东西-3-
💻 SQL
📖 第 1 页 / 共 2 页
字号:
12 下一页
/* Jathena++ Full Install SQL-Script(MSSQL2000/2005 version) */

create database [ragnarok];
go
use [ragnarok];

/*==========================================
 * Create Table : [cart_inventory]
 *------------------------------------------
 */
create table [cart_inventory] (
	[id] bigint IDENTITY(1,1) NOT NULL,
	[char_id] int NOT NULL DEFAULT 0,
	[nameid] int NOT NULL DEFAULT 0,
	[amount] int NOT NULL DEFAULT 0,
	[equip] int NOT NULL DEFAULT 0,
	[identify] smallint NOT NULL DEFAULT 0,
	[refine] tinyint NOT NULL DEFAULT 0,
	[attribute] tinyint NOT NULL DEFAULT 0,
	[card0] int NOT NULL DEFAULT 0,
	[card1] int NOT NULL DEFAULT 0,
	[card2] int NOT NULL DEFAULT 0,
	[card3] int NOT NULL DEFAULT 0,
	[broken] bigint NOT NULL DEFAULT 0,
	[lockid] int NOT NULL DEFAULT 0,
	[exp] int NOT NULL DEFAULT 0,
	[endurance] int NOT NULL DEFAULT 0,
	[max_endurance] int NOT NULL DEFAULT 0,
	[sp_lv] int NOT NULL DEFAULT 0,
	primary key([id])
);

/*==========================================
 * Create Table : [char]
 *------------------------------------------
 */
create table [char] (
	[char_id] int IDENTITY(15000,1) NOT NULL,
	[account_id] int NOT NULL default 0,
	[char_num] tinyint NOT NULL default 0,
	[name] varchar(255) NOT NULL default '',
	[class] int NOT NULL default 0,
	[base_level] tinyint NOT NULL default 1,
	[job_level] tinyint NOT NULL default 1,
	[base_exp] bigint NOT NULL default 0,
	[job_exp] bigint NOT NULL default 0,
	[zeny] int NOT NULL default 500,
	[str] int NOT NULL default 0,
	[agi] int NOT NULL default 0,
	[vit] int NOT NULL default 0,
	[int] int NOT NULL default 0,
	[dex] int NOT NULL default 0,
	[luk] int NOT NULL default 0,
	[max_hp] int NOT NULL default 0,
	[hp] int NOT NULL default 0,
	[max_sp] int NOT NULL default 0,
	[sp] int NOT NULL default 0,
	[status_point] int NOT NULL default 0,
	[skill_point] int NOT NULL default 0,
	[option] int NOT NULL default 0,
	[karma] int NOT NULL default 0,
	[manner] int NOT NULL default 0,
	[party_id] int NOT NULL default 0,
	[guild_id] int NOT NULL default 0,
	[pet_id] int NOT NULL default 0,
	[hair] tinyint NOT NULL default 0,
	[hair_color] int NOT NULL default 0,
	[clothes_color] tinyint NOT NULL default 0,
	[weapon] int NOT NULL default 1,
	[shield] int NOT NULL default 0,
	[head_top] int NOT NULL default 0,
	[head_mid] int NOT NULL default 0,
	[head_bottom] int NOT NULL default 0,
	[last_map] varchar(20) NOT NULL default 'new_1-1.gat',
	[last_x] int NOT NULL default 53,
	[last_y] int NOT NULL default 111,
	[save_map] varchar(20) NOT NULL default 'new_1-1.gat',
	[save_x] int NOT NULL default 53,
	[save_y] int NOT NULL default 111,
	[partner_id] int NOT NULL default 0,
	[parent_id] int NOT NULL default 0,
	[parent_id2] int NOT NULL default 0,
	[baby_id] int NOT NULL default 0,
	[online] tinyint NOT NULL default 0,
	[homun_id] int NOT NULL default 0,
	primary key([char_id])
);

/*==========================================
 * Create Table : [charlog]
 *------------------------------------------
 */
create table [charlog] (
	[id] bigint IDENTITY(1,1) NOT NULL,
	[time] datetime NOT NULL default GETDATE(),
	[log] TEXT NOT NULL default '',
	primary key([id])
);

/*==========================================
 * Create Table : [friend]
 *------------------------------------------
 */
create table [friend] (
	[char_id] int NOT NULL default 0,
	[id1] int NOT NULL default 0,
	[id2] int NOT NULL default 0,
	[name] varchar(24) NOT NULL default ''
);

/*==========================================
 * Create Table : [global_reg_value]
 *------------------------------------------
 */
create table [global_reg_value] (
	[char_id] int NOT NULL default 0,
	[str] varchar(255) NOT NULL default '',
	[value] int NOT NULL default 0,
	[type] int NOT NULL default 3,
	[account_id] int NOT NULL default 0,
	primary key([char_id],[str],[account_id])
);

/*==========================================
 * Create Table : [guild]
 *------------------------------------------
 */
create table [guild] (
	[guild_id] int NOT NULL default 10000,
	[name] varchar(24) NOT NULL default '',
	[master] varchar(24) NOT NULL default '',
	[guild_lv] smallint NOT NULL default 0,
	[connect_member] smallint NOT NULL default 0,
	[max_member] smallint NOT NULL default 0,
	[average_lv] smallint NOT NULL default 0,
	[exp] int NOT NULL default 0,
	[next_exp] int NOT NULL default 0,
	[skill_point] int NOT NULL default 0,
	[castle_id] int NOT NULL default -1,
	[mes1] varchar(60) NOT NULL default '',
	[mes2] varchar(120) NOT NULL default '',
	[emblem_len] int NOT NULL default 0,
	[emblem_id] int NOT NULL default 0,
	/*[emblem_data] varchar(MAX) NOT NULL default '',*/	/* SQL2000 ERROR */
	[emblem_data] varchar(6000) NOT NULL default '',
	primary key([guild_id])
);

/*==========================================
 * Create Table : [guild_alliance]
 *------------------------------------------
 */
create table [guild_alliance] (
	[guild_id] int NOT NULL default 0,
	[opposition] int NOT NULL default 0,
	[alliance_id] int NOT NULL default 0,
	[name] varchar(24) NOT NULL default ''
);

/*==========================================
 * Create Table : [guild_castle]
 *------------------------------------------
 */
create table [guild_castle] (
	[castle_id] int NOT NULL default 0,
	[guild_id] int NOT NULL default 0,
	[economy] int NOT NULL default 0,
	[defense] int NOT NULL default 0,
	[triggerE] int NOT NULL default 0,
	[triggerD] int NOT NULL default 0,
	[nextTime] int NOT NULL default 0,
	[payTime] int NOT NULL default 0,
	[createTime] int NOT NULL default 0,
	[visibleC] int NOT NULL default 0,
	[visibleG0] int NOT NULL default 0,
	[visibleG1] int NOT NULL default 0,
	[visibleG2] int NOT NULL default 0,
	[visibleG3] int NOT NULL default 0,
	[visibleG4] int NOT NULL default 0,
	[visibleG5] int NOT NULL default 0,
	[visibleG6] int NOT NULL default 0,
	[visibleG7] int NOT NULL default 0,
	[gHP0] int NOT NULL default 0,
	[gHP1] int NOT NULL default 0,
	[gHP2] int NOT NULL default 0,
	[gHP3] int NOT NULL default 0,
	[gHP4] int NOT NULL default 0,
	[gHP5] int NOT NULL default 0,
	[gHP6] int NOT NULL default 0,
	[gHP7] int NOT NULL default 0,
	PRIMARY KEY ([castle_id])
);
INSERT INTO [guild_castle] ([castle_id]) VALUES (0);
INSERT INTO [guild_castle] ([castle_id]) VALUES (1);
INSERT INTO [guild_castle] ([castle_id]) VALUES (2);
INSERT INTO [guild_castle] ([castle_id]) VALUES (3);
INSERT INTO [guild_castle] ([castle_id]) VALUES (4);
INSERT INTO [guild_castle] ([castle_id]) VALUES (5);
INSERT INTO [guild_castle] ([castle_id]) VALUES (6);
INSERT INTO [guild_castle] ([castle_id]) VALUES (7);
INSERT INTO [guild_castle] ([castle_id]) VALUES (8);
INSERT INTO [guild_castle] ([castle_id]) VALUES (9);
INSERT INTO [guild_castle] ([castle_id]) VALUES (10);
INSERT INTO [guild_castle] ([castle_id]) VALUES (11);
INSERT INTO [guild_castle] ([castle_id]) VALUES (12);
INSERT INTO [guild_castle] ([castle_id]) VALUES (13);
INSERT INTO [guild_castle] ([castle_id]) VALUES (14);
INSERT INTO [guild_castle] ([castle_id]) VALUES (15);
INSERT INTO [guild_castle] ([castle_id]) VALUES (16);
INSERT INTO [guild_castle] ([castle_id]) VALUES (17);
INSERT INTO [guild_castle] ([castle_id]) VALUES (18);
INSERT INTO [guild_castle] ([castle_id]) VALUES (19);

/*==========================================
 * Create Table : [guild_expulsion]
 *------------------------------------------
 */
create table [guild_expulsion] (
	[guild_id] int NOT NULL default 0,
	[name] varchar(24) NOT NULL default '',
	[mes] varchar(40) NOT NULL default '',
	[acc] varchar(40) NOT NULL default '',
	[account_id] int NOT NULL default 0,
	[rsv1] int NOT NULL default 0,
	[rsv2] int NOT NULL default 0,
	[rsv3] int NOT NULL default 0
);

/*==========================================
 * Create Table : [guild_member]
 *------------------------------------------
 */
create table [guild_member] (
	[guild_id] int NOT NULL default 0,
	[account_id] int NOT NULL default 0,
	[char_id] int NOT NULL default 0,
	[hair] smallint NOT NULL default 0,
	[hair_color] smallint NOT NULL default 0,
	[gender] smallint NOT NULL default 0,
	[class] smallint NOT NULL default 0,
	[lv] smallint NOT NULL default 0,
	[exp] bigint NOT NULL default 0,
	[exp_payper] int NOT NULL default 0,
	[online] tinyint NOT NULL default 0,
	[position] smallint NOT NULL default 0,
	[rsv1] int NOT NULL default 0,
	[rsv2] int NOT NULL default 0,
	[name] varchar(24) NOT NULL default ''
);

/*==========================================
 * Create Table : [guild_position]
 *------------------------------------------
 */
create table [guild_position] (
	[guild_id] int NOT NULL default 0,
	[position] smallint NOT NULL default 0,
	[name] varchar(24) NOT NULL default '',
	[mode] int NOT NULL default 0,
	[exp_mode] int NOT NULL default 0
);

/*==========================================
 * Create Table : [guild_skill]
 *------------------------------------------
 */
create table [guild_skill] (
	[guild_id] int NOT NULL default 0,
	[id] int NOT NULL default 0,
	[lv] int NOT NULL default 0
);

/*==========================================
 * Create Table : [guild_storage]
 *------------------------------------------
 */
create table [guild_storage] (
	[id] bigint IDENTITY(1,1) NOT NULL,
	[guild_id] int NOT NULL DEFAULT 0,
	[nameid] int NOT NULL DEFAULT 0,
	[amount] int NOT NULL DEFAULT 0,
	[equip] int NOT NULL DEFAULT 0,
	[identify] smallint NOT NULL DEFAULT 0,
	[refine] tinyint NOT NULL DEFAULT 0,
	[attribute] tinyint NOT NULL DEFAULT 0,
	[card0] int NOT NULL DEFAULT 0,
	[card1] int NOT NULL DEFAULT 0,
	[card2] int NOT NULL DEFAULT 0,
	[card3] int NOT NULL DEFAULT 0,
	[broken] bigint NOT NULL DEFAULT 0,
	[lockid] int NOT NULL DEFAULT 0,
	[exp] int NOT NULL DEFAULT 0,
	[endurance] int NOT NULL DEFAULT 0,
	[max_endurance] int NOT NULL DEFAULT 0,
	[sp_lv] int NOT NULL DEFAULT 0,
	primary key([id])
);

/*==========================================
 * Create Table : [homunculus]
 *------------------------------------------
 */
create table [homunculus] (
	[homun_id] bigint IDENTITY(1,1) NOT NULL,
	[class] int NOT NULL default 0,
	[name] varchar(24) NOT NULL default '',
	[account_id] int NOT NULL default 0,
	[char_id] int NOT NULL default 0,
	[base_level] tinyint NOT NULL default 0,
12 下一页
💿 文件大小 7557 K
👤 上传用户 johni
📂 所属分类文章/文档
🏷️ 相关标签

#ROSF #JA
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -