main_mssql.sql

JA++的最新...很多ROSF都用这个 ] 是个不错的东西-3-

	[base_exp] bigint 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,
	[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,
	[status_point] int NOT NULL default 0,
	[skill_point] int NOT NULL default 0,
	[equip] int NOT NULL default 0,
	[intimate] int NOT NULL default 0,
	[hungry] int NOT NULL default 0,
	[rename_flag] tinyint NOT NULL default 0,
	[incubate] int NOT NULL default 0,
	primary key([homun_id])
);

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

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

/*==========================================
 * Create Table : [inventory]
 *------------------------------------------
 */
create table [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 : [ipbanlist]
 *------------------------------------------
 */
create table [ipbanlist] (
	[list] varchar(255) NOT NULL default '',
	[btime] datetime NOT NULL default GETDATE(),
	[rtime] datetime NOT NULL default GETDATE(),
	[reason] varchar(255) NOT NULL default ''
);

/*==========================================
 * Create Table : [login]
 *------------------------------------------
 */
create table [login] (
	[account_id] int IDENTITY(2000000,1) NOT NULL,
	[userid] varchar(255) NOT NULL default '',
	[user_pass] varchar(32) NOT NULL default '',
	[lastlogin] datetime NOT NULL default GETDATE(),
	[sex] char(1) NOT NULL default 'M',
	[logincount] int NOT NULL default 0,
	[email] varchar(60) NOT NULL default '',
	[level] smallint NOT NULL default 0,
	[error_message] int NOT NULL default 0,
	[connect_until] int NOT NULL default 0,
	[last_ip] varchar(100) NOT NULL default '',
	[memo] int NOT NULL default 0,
	[ban_until] int NOT NULL default 0,
	[state] int NOT NULL default 0,
	[reg_date] datetime NOT NULL default GETDATE(),
	[ask] varchar(255) default '',
	[answer] varchar(255) default '',
	primary key([account_id])
);
SET IDENTITY_INSERT [login] ON;
INSERT INTO [login] ([account_id], [userid], [user_pass], [sex], [email]) VALUES (1, 's1', 'p1', 'S','[e-mail]');
SET IDENTITY_INSERT [login] OFF;

/*==========================================
 * Create Table : [login_error]
 *------------------------------------------
 */
create table [login_error] (
	[err_id] int NOT NULL default 0,
	[reason] varchar(100) NOT NULL default 'Unknown',
	primary key([err_id])
);


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

/*==========================================
 * Create Table : [memo]
 *------------------------------------------
 */
create table [memo] (
	[memo_id] bigint IDENTITY(1,1) NOT NULL,
	[char_id] int NOT NULL default 0,
	[type] char(1) NOT NULL default '',
	[map] varchar(255) NOT NULL default '',
	[x] int NOT NULL default -1,
	[y] int NOT NULL default -1,
	primary key([memo_id])
);

/*==========================================
 * Create Table : [party]
 *------------------------------------------
 */
create table [party] (
	[party_id] int NOT NULL default 100,
	[name] varchar(100) NOT NULL default '',
	[exp] int NOT NULL default 0,
	[item] int NOT NULL default 0,
	[leader_id] int NOT NULL default 0,
	primary key([party_id])
);

/*==========================================
 * Create Table : [pet]
 *------------------------------------------
 */
create table [pet] (
	[pet_id] int 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,
	[level] tinyint NOT NULL default 0,
	[egg_id] int NOT NULL default 0,
	[equip] int NOT NULL default 0,
	[intimate] int NOT NULL default 0,
	[hungry] int NOT NULL default 0,
	[rename_flag] tinyint NOT NULL default 0,
	[incubate] int NOT NULL default 0,
	primary key([pet_id])
);

/*==========================================
 * Create Table : [ragsrvinfo]
 *------------------------------------------
 */
create table [ragsrvinfo] (
	[index] int NOT NULL default 0,
	[name] varchar(255) NOT NULL default '',
	[exp] int NOT NULL default 0,
	[jexp] int NOT NULL default 0,
	[drop] int NOT NULL default 0,
	[motd] varchar(255) NOT NULL default ''
);

/*==========================================
 * Create Table : [skill]
 *------------------------------------------
 */
create table [skill] (
	[char_id] int NOT NULL default 0,
	[id] int NOT NULL default 0,
	[lv] tinyint NOT NULL default 0,
	primary key([char_id],[id])
);

/*==========================================
 * Create Table : [sstatus]
 *------------------------------------------
 */
create table [sstatus] (
	[index] tinyint NOT NULL default 0,
	[name] varchar(255) NOT NULL default '',
	[user] int NOT NULL default 0,
	primary key([index])
);

/*==========================================
 * Create Table : [storage]
 *------------------------------------------
 */
create table [storage] (
	[id] bigint IDENTITY(1,1) NOT NULL,
	[account_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 : [status_change]
 *------------------------------------------
 */
create table [status_change] (
	[char_id] int NOT NULL default 0,
	[account_id] int NOT NULL default 0,
	[type] int NOT NULL default 0,
	[val1] int NOT NULL default 0,
	[val2] int NOT NULL default 0,
	[val3] int NOT NULL default 0,
	[val4] int NOT NULL default 0,
	[tick] int NOT NULL default 0
);

/*==========================================
 * Create Table : [hotkey]
 *------------------------------------------
 */
create table [hotkey] (
	[char_id] int NOT NULL default 0,
	[type] int NOT NULL default 0,
	[hotkey] int NOT NULL default 0,
	[id] int NOT NULL default 0,
	[skill_lv] int NOT NULL default 0
);

/*==========================================
 * Create Table : [mail]
 *------------------------------------------
 */
create table [mail] (
	[char_id] int NOT NULL default 0,
	[account_id] int NOT NULL default 0,
	[rates] int NOT NULL default 0,
	[store] int NOT NULL default 0,
	primary key([char_id],[account_id])
);

/*==========================================
 * Create Table : [mail_data]
 *------------------------------------------
 */
create table [mail_data] (
	[char_id] int NOT NULL default 0,
	[mail_num] int NOT NULL default 0,
	[read] int NOT NULL default 0,
	[char_name] varchar(24) NOT NULL default '',
	[receive_name] varchar(24) NOT NULL default '',
	[title] varchar(40) NOT NULL default '',
	[zeny] 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,
	[times] int NOT NULL default 0,
	[body_size] int NOT NULL default 0,
	[body] varchar(1024) NOT NULL default ''
);