添加对应时间LOGINLOG表的SQL语句！
自己改一下日期就行了

//nageboard
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050501]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050501]
GO
CREATE TABLE [dbo].[itemtrade050501] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050502]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050502]
GO
CREATE TABLE [dbo].[itemtrade050502] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050503]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050503]
GO
CREATE TABLE [dbo].[itemtrade050503] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050504]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050504]
GO
CREATE TABLE [dbo].[itemtrade050504] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050505]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050505]
GO
CREATE TABLE [dbo].[itemtrade050505] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050506]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050506]
GO
CREATE TABLE [dbo].[itemtrade050506] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050507]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050507]
GO
CREATE TABLE [dbo].[itemtrade050507] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050508]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050508]
GO
CREATE TABLE [dbo].[itemtrade050508] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade050509]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade050509]
GO
CREATE TABLE [dbo].[itemtrade050509] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade0505010]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemtrade0505010]
GO
CREATE TABLE [dbo].[itemtrade0505010] (
[ii] [int] IDENTITY (1, 1) NOT NULL ,
[logTime] [datetime] NOT NULL ,
[logCode] [int] NOT NULL ,
[nameChar] [char] (16) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[propCharID] [int] NOT NULL ,
[recvCharID] [int] NOT NULL ,
[itemid] [int] NOT NULL ,
[prodid] [int] NOT NULL ,
[nMoney] [int] NOT NULL ,
[map] [int] NOT NULL
) ON [PRIMARY]
GO

//nagemember
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200551]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200551]
GO
CREATE TABLE [dbo].[Loginlog_200551] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200552]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200552]
GO
CREATE TABLE [dbo].[Loginlog_200552] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200553]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200553]
GO
CREATE TABLE [dbo].[Loginlog_200553] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200554]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200554]
GO
CREATE TABLE [dbo].[Loginlog_200554] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200555]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200555]
GO
CREATE TABLE [dbo].[Loginlog_200555] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200556]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200556]
GO
CREATE TABLE [dbo].[Loginlog_200556] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200557]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200557]
GO
CREATE TABLE [dbo].[Loginlog_200557] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200558]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200558]
GO
CREATE TABLE [dbo].[Loginlog_200558] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_200559]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_200559]
GO
CREATE TABLE [dbo].[Loginlog_200559] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Loginlog_2005510]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Loginlog_2005510]
GO
CREATE TABLE [dbo].[Loginlog_2005510] (
[login_id] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[type] [int] NULL ,
[status] [int] NULL ,
[time] [datetime] NULL ,
[ip] [varchar] (20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL ,
[propid] [int] NOT NULL ,
[kind] [tinyint] NULL
) ON [PRIMARY]
GO
两个数据库的，不要一起执行！

清空数据的

还有一些自己添加吧，很简单照抄就行，看哪个没用添加进来

use nage
DELETE FROM [dbo].[CharInfo]
DELETE FROM [dbo].[charname_1]
DELETE FROM [dbo].[friend]
DELETE FROM [dbo].[giveItem4event]
DELETE FROM [dbo].[RoundRank_1]
DELETE FROM [dbo].[RoundRank_3]
DELETE FROM [dbo].[RoundRank_4]
DELETE FROM [dbo].[RoundRank_5]

use NageBoard
DELETE FROM [dbo].[EventBoard]
DELETE FROM [dbo].[FreeBoard]
DELETE FROM [dbo].[NotiBoard]

use NageManager
DELETE FROM [dbo].[ManagerTable]

use NageMember
DELETE FROM [dbo].[charname]
DELETE FROM [dbo].[charname_1]
DELETE FROM [dbo].[charname_2]
DELETE FROM [dbo].[charname_3]
DELETE FROM [dbo].[charname_4]
DELETE FROM [dbo].[chr_log_info]
DELETE FROM [dbo].[chr_log_info_plus]
DELETE FROM [dbo].[Chr_Log_Info_static]
DELETE FROM [dbo].[Item_to_Game]
DELETE FROM [dbo].[Itemlog_test]
DELETE FROM [dbo].[Itemlog_to_Game]
DELETE FROM [dbo].[login_log]
DELETE FROM [dbo].[nage_admin_log]
DELETE FROM [dbo].[OGB_TB_LOGIN_LOG]
DELETE FROM [dbo].[OGB_TB_USER_EXCEPTION]

本站声明:本站文章资源均来自网上转载或机器人自动搜索采集,如果本站文章资源有版权问题请联系管理员，我们尽快予以更正。所有文章只限用于个人测试学习使用,不得用于非法商业用途,请勿非法复制传播。特此声明！--[5uwl.net]

五年游戏制作经验; 金牌服务品质保障 游戏开区一条龙 第一品牌无忧网络[5uwl.net]