什么 夏在别人的数据库有30m 自己的只有1m
我来给大家解释下, 30m和1m数据库的区别
1m 的数据库我想大家都是 看了那段录像,在sql里面创建了一个 数据库然后把那个mdb文件倒入进去就完事了爸,其实那样是不标准的做法! copyright dedecms
30m的 是用sql脚本生成的数据库, 和前者比前来 多了主健 索引 等。。。
如果有人实在不会 使用sql脚本的话,我等会可以提供一个 生成好的 数据库备份!
以下是sql脚本,现在D盘下面创建 data 目录,然后用sql 事件查询器 运行!
use master copyright dedecms
CREATE DATABASE [MuOnline] ON
(
NAME = N'MuOnline_dat',
FILENAME = N'D:\Data\MuOnline.mdf' , ------(可能需要修改)
SIZE = 30,
FILEGROWTH = 10%
)
LOG ON (
NAME = N'MuOnline_log',
FILENAME = N'D:\Data\MuOnline.ldf' , ------(可能需要修改)
SIZE = 30,
FILEGROWTH = 10%
)
GO
织梦内容管理系统
use MuOnline 织梦内容管理系统
CREATE TABLE AccountCharacter (
Number INT IDENTITY ( 1, 1 ) NOT NULL
, Id <I>var</I>CHAR( 10 ) NOT NULL PRIMARY KEY
, GameID1 <I>var</I>CHAR( 10 ) NULL
, GameID2 <I>var</I>CHAR( 10 ) NULL
, GameID3 <I>var</I>CHAR( 10 ) NULL
, GameID4 <I>var</I>CHAR( 10 ) NULL
, GameID5 <I>var</I>CHAR( 10 ) NULL
, GameIDC <I>var</I>CHAR( 10 ) NULL
)
织梦内容管理系统
CREATE TABLE [Character] (
[AccountID] [<I>var</I>char] (10) NOT NULL ,
[Name] [<I>var</I>char] (10) NOT NULL ,
[cLevel] [smallint] NULL ,
[LevelUpPoint] [int] NULL ,
[Class] [tinyint] NULL ,
[Experience] [int] NULL ,
[Strength] [smallint] NULL ,
[Dexterity] [smallint] NULL ,
[Vitality] [smallint] NULL ,
[Energy] [smallint] NULL ,
[Inventory] [<I>var</I>binary] (532) NULL ,
[MagicList] [<I>var</I>binary] (60) NULL ,
[MONEY=] [int] NULL ,
[Life] [real] NULL ,
[MaxLife] [real] NULL ,
[Mana] [real] NULL ,
[MaxMana] [real] NULL ,
内容来自dedecms
ALTER TABLE [dbo].[Character] WITH NOCHECK ADD
CONSTRAINT [DF_Character_cLevel] DEFAULT (1) FOR [cLevel],
CONSTRAINT [DF_Character_LevelUpPoint] DEFAULT (0) FOR [LevelUpPoint],
CONSTRAINT [DF_Character_Experience] DEFAULT (0) FOR [Experience],
CONSTRAINT [DF_Character_Money] DEFAULT (0) FOR [MONEY=],
CONSTRAINT [DF__Character__MapDi__0AD2A005] DEFAULT (0) FOR [MapDir],
CONSTRAINT [DF__Character__PkCou__0BC6C43E] DEFAULT (0) FOR [PkCount],
CONSTRAINT [DF__Character__PkLev__0CBAE877] DEFAULT (3) FOR [PkLevel],
CONSTRAINT [DF__Character__PkTim__0DAF0CB0] DEFAULT (0) FOR [PkTime],
CONSTRAINT [PK__Character__09DE7BCC] PRIMARY KEY CLUSTERED
(
[Name] 本文来自织梦
) ON [PRIMARY]
GO 内容来自dedecms
CREATE VIEW vCharacterPreview
AS SELECT Name, cLevel, Class, Inventory FROM Character
CREATE TABLE [dbo].[GameServerInfo] (
[Number] [int] NOT NULL ,
[ItemCount] [int] NULL ,
[ZenCount] [int] NULL
) ON [PRIMARY]
GO 内容来自dedecms
ALTER TABLE [dbo].[GameServerInfo] WITH NOCHECK ADD
CONSTRAINT [DF_GameServerInfo_Number] DEFAULT (0) FOR [Number],
CONSTRAINT [DF__GameServe__ItemC__0F975522] DEFAULT (0) FOR [ItemCount],
CONSTRAINT [DF_GameServerInfo_ZenCount] DEFAULT (0) FOR [ZenCount],
CONSTRAINT [PK_GameServerInfo] PRIMARY KEY NONCLUSTERED
(
[Number]
) ON [PRIMARY]
GO 内容来自dedecms
insert GameServerInfo valueS(0,0,0)
内容来自dedecms
CREATE TABLE [Guild] (
[G_Name] [<I>var</I>char] (8) NOT NULL ,
[G_Mark] [<I>var</I>binary] (32) NULL ,
[G_Score] [int] NULL ,
[G_Master] [<I>var</I>char] (10) NULL ,
[G_Count] [int] NULL ,
[G_Notice] [<I>var</I>char] (60) NULL ,
[Number] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO
织梦好,好织梦
CREATE TABLE [GuildMember] (
[Name] [<I>var</I>char] (10) NOT NULL ,
[G_Name] [<I>var</I>char] (8) NOT NULL ,
[G_Level] [tinyint] NULL
) ON [PRIMARY]
GO 织梦好,好织梦
CREATE TABLE [warehouse] (
[AccountID] [<I>var</I>char] (10) NOT NULL ,
[Items] [binary] (840) NULL ,
[MONEY=] [int] NULL ,
[EndUseDate] [smalldatetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[warehouse] WITH NOCHECK ADD
CONSTRAINT [PK_warehouse] PRIMARY KEY CLUSTERED
(
[AccountID]
) ON [PRIMARY]
GO
copyright dedecms
ALTER TABLE [dbo].[Guild] WITH NOCHECK ADD
CONSTRAINT [PK_Guild] PRIMARY KEY NONCLUSTERED
(
[G_Name]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GuildMember] WITH NOCHECK ADD
CONSTRAINT [PK_GuildMember] PRIMARY KEY NONCLUSTERED
(
[Name]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[warehouse] WITH NOCHECK ADD
CONSTRAINT [DF_warehouse_Money] DEFAULT (0) FOR [MONEY=]
GO
ALTER TABLE [dbo].[GuildMember] ADD
CONSTRAINT [FK_GuildMember_Guild] FOREIGN KEY
(
[G_Name]
) REFERENCES [dbo].[Guild] (
[G_Name]
)
GO copyright dedecms
1.76精品传奇_1.76天下毁灭_1.76复古传奇_英雄合击_中变靓装传奇_无忧传奇
传奇花屏补丁,花屏补丁,土城花屏补丁,盟重土城花屏补丁下载,土城花屏补丁下载,沙巴克花屏补丁,传奇土城花屏补丁下载
网站每天发布最新、最好的传奇版本下载和与传奇服务端配套开区传奇模版,网游技术教程全部免费下载!
无忧网络是目前唯一家所有的传奇服务端,传奇私服花屏补丁,盟重花屏补丁和传奇客户端下载都经过站长亲自测试并配有真实测试图!
所有的工具软件和传奇版本在发布之前,都会经过站长亲自测试,保证chuanqisf可以进入游戏,所有软件都无毒无插件!
本站声明:本站所有技术资料与下载资源均为网络搜集整理,并不代表本站的观点与立场,如有侵犯您的权益,请来信指出,本站将立即改正Copyright © 2002-2014 无忧网络 版权所有蜀ICP备09041899号