📄 help.asp
字号:
<!--#include file="sysconfig.asp"-->
<%
'黄华于2008年3月
%>
<html>
<head>
<title>主窗口</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Inc/bs.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {font-size: 12px; color: #000; font-family: 宋体}
td {font-size: 12px; color: #000; font-family: 宋体;}
.t1 {font:12px 宋体;color:#000000}
.t2 {font:12px 宋体;color:#ffffff}
.t3 {font:12px 宋体;color:#ffff00}
.t4 {font:12px 宋体;color:#800000}
.t5 {font:12px 宋体;color:#191970}
.font1 { font-family: "宋体"; font-size: 12px; color: #000000}
.font2 { font-family: "黑体"; font-size: 20px; font-weight: bold; color: #000000}
.font3 { font-family: "宋体"; font-size: 12px; color: #FFFFFF}
A.r1:link {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:visited {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:hover {font-size:12px;text-decoration:underline;color:#cc0000;}
-->
</style>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table cellpadding="2" cellspacing="1" border="0" width="95%" align="center" class="a2">
<tr>
<td class="a1" height="25" align="center"><b>数据库建表初始化脚本</b></td>
</tr>
<tr class="a4">
<td height="23">if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[admin]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)<br>
drop table [dbo].[admin]<br>
GO
<p>if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cost_detail]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)<br>
drop table [dbo].[cost_detail]<br>
GO</p>
<p>if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cost_jh]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)<br>
drop table [dbo].[cost_jh]<br>
GO</p>
<p>if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[danwei]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)<br>
drop table [dbo].[danwei]<br>
GO</p>
<p>if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[guikou]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)<br>
drop table [dbo].[guikou]<br>
GO</p>
<p>if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pinmu]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)<br>
drop table [dbo].[pinmu]<br>
GO</p>
<p>if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[xiangmu]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)<br>
drop table [dbo].[xiangmu]<br>
GO</p>
<p>CREATE TABLE [dbo].[admin] (<br>
[id] [int] IDENTITY (1, 1) NOT NULL ,<br>
[guikou_id] [int] NULL ,<br>
[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[realname] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[lastloginip] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[lastlogintime] [datetime] NULL ,<br>
[logintimes] [int] NULL ,<br>
[quanli] [int] NULL ,<br>
[disable] [bit] NULL <br>
) ON [PRIMARY]<br>
GO</p>
<p>CREATE TABLE [dbo].[cost_detail] (<br>
[id] [int] IDENTITY (1, 1) NOT NULL ,<br>
[guikou_id] [int] NULL ,<br>
[danwei_id] [int] NULL ,<br>
[xiangmu_id] [int] NULL ,<br>
[cost_no_j] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[cost_no_r] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[cost_number_j] [money] NULL ,<br>
[cost_number_r] [money] NULL ,<br>
[pinmu_j] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[pinmu_r] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[admin_j] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[admin_r] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[updatetime_j] [datetime] NULL ,<br>
[updatetime_r] [datetime] NULL ,<br>
[isok] [bit] NULL ,<br>
[cost_delete] [bit] NULL <br>
) ON [PRIMARY]<br>
GO</p>
<p>CREATE TABLE [dbo].[cost_jh] (<br>
[id] [int] IDENTITY (1, 1) NOT NULL ,<br>
[guikou_id] [int] NULL ,<br>
[danwei_id] [int] NULL ,<br>
[xiangmu_id] [int] NULL ,<br>
[cost_no] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[cost_number] [money] NULL ,<br>
[pinmu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[admin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[updatetime] [datetime] NULL ,<br>
[yearless] [bit] NULL ,<br>
[cost_delete] [bit] NULL <br>
) ON [PRIMARY]<br>
GO</p>
<p>CREATE TABLE [dbo].[danwei] (<br>
[id] [int] IDENTITY (1, 1) NOT NULL ,<br>
[guikou_id] [int] NULL ,<br>
[danwei_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[cost_delete] [bit] NULL <br>
) ON [PRIMARY]<br>
GO</p>
<p>CREATE TABLE [dbo].[guikou] (<br>
[id] [int] IDENTITY (1, 1) NOT NULL ,<br>
[guikou_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[cost_delete] [bit] NULL <br>
) ON [PRIMARY]<br>
GO</p>
<p>CREATE TABLE [dbo].[pinmu] (<br>
[id] [int] IDENTITY (1, 1) NOT NULL ,<br>
[goodsitemcode] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[goodsitemname] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[kind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL <br>
) ON [PRIMARY]<br>
GO</p>
<p>CREATE TABLE [dbo].[xiangmu] (<br>
[id] [int] IDENTITY (1, 1) NOT NULL ,<br>
[guikou_id] [int] NULL ,<br>
[danwei_id] [int] NULL ,<br>
[xiangmu_name] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,<br>
[cost_delete] [bit] NULL <br>
) ON [PRIMARY]<br>
GO</p>
<p>insert admin(username,realname,password,lastloginip,lastlogintime,logintimes,quanli,disable)
values('admin','admin','a0b923820dcc509a','127.0.0.1','2008-03-15 23:16:57.000',0,1,0)<br>
GO<br>
</p>
<p> </p>
</td>
</tr>
</table>
<p> </p>
<%htmlend%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -