yuesu/Install/tables.sql
(开头部分) 31KB这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。
/****** Object: Table [dbo].[ipdata] Script Date: 2020-04-18 18:01:02 ******/
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ipdata]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [dbo].[ipdata](
[ip1] [float] NULL,
[ip2] [float] NULL,
[cityname] [nvarchar](255) NULL,
[address] [nvarchar](255) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[log_adminlogin] Script Date: 2020-04-18 18:01:02 ******/
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[log_adminlogin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [dbo].[log_adminlogin](
[id] [int] IDENTITY(1,1) NOT NULL,
[adminuser] [nvarchar](50) NULL,
[adminjbname] [nvarchar](50) NULL,
[logmsg] [nvarchar](200) NULL,
[loginip] [varchar](50) NULL,
[logtime] [datetime] NULL
) ON [PRIMARY]
GO
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mvc_log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [dbo].[mvc_log] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[logtype] [tinyint] NULL ,
[logjb] [tinyint] NULL ,
[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[cururl] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[fromurl] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[logcon] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[logip] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL
) ON [PRIMARY]
GO
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mvc_forbidip]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [dbo].[mvc_forbidip] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[ip1] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ip2] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[isusing] [bit] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[mvc_ad] Script Date: 2020-04-18 18:01:02 ******/
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mvc_ad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [dbo].[mvc_ad](
[id] [int] IDENTITY(1,1) NOT NULL,
[typeid] [int] NULL,
[subid] [int] NULL,
[adtitle] [nvarchar](120) NULL,
[adfile] [varchar](80) NULL,
[adlink] [varchar](80) NULL,
[adwidth] [int] NULL,
[adheight] [int] NULL,
[addes] [nvarchar](500) NULL,
[isshow] [tinyint] NULL,
[hits] [int] NULL,
[addtime] [datetime] NULL,
CONSTRAINT [PK_mvc_ad] PRIMARY KEY CLUSTERED
(
后面还有 918 行代码,解锁后查看完整代码
24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明
AI 解读 AI
登录后可用,每次 10 算力,解读结果公开显示在下面。
还没有人解读过这个文件。
