⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 spos_schema.sql

📁 幼儿园管理软件aspSPOS幼儿园办公管理系统2.00普及版安装说明： 一. 安装前提条件： 1. 在安装SPOS幼儿园办公管理系统2.00普及版之前
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 

/****** Object:  Login TIGER\Administrator    Script Date: 2003-4-2 11:36:07 ******/
exec sp_addsrvrolemember N'TIGER\Administrator', sysadmin
GO

/****** Object:  User dbo    Script Date: 2003-4-2 11:36:07 ******/
/****** Object:  Table [dbo].[StuZZ_His_Pay]    Script Date: 2003-4-2 11:36:12 ******/
CREATE TABLE [dbo].[StuZZ_His_Pay] (
	[id] [numeric](10, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CountDay] [int] NULL ,
	[HuoShiDan] [money] NULL ,
	[HuoShi] [money] NULL ,
	[BaoYu] [money] NULL ,
	[XingGuan] [money] NULL ,
	[Za] [money] NULL ,
	[DaiBan] [money] NULL ,
	[QiTa] [money] NULL ,
	[HeJi] [money] NULL ,
	[BanJi] [numeric](18, 0) NULL ,
	[Xdate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[StuZZ_params]    Script Date: 2003-4-2 11:36:14 ******/
CREATE TABLE [dbo].[StuZZ_params] (
	[id] [int] NOT NULL ,
	[hsf] [money] NULL ,
	[byf] [money] NULL ,
	[xgf] [money] NULL ,
	[zf] [money] NULL ,
	[dbf] [money] NULL ,
	[qt] [money] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Stu_Card_Money]    Script Date: 2003-4-2 11:36:14 ******/
CREATE TABLE [dbo].[Stu_Card_Money] (
	[CardNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FreeMoney] [money] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Stu_Money_Set]    Script Date: 2003-4-2 11:36:14 ******/
CREATE TABLE [dbo].[Stu_Money_Set] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[LeiXing] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TuoEr] [money] NULL ,
	[guanLi] [money] NULL ,
	[DaiBan] [money] NULL ,
	[BaoYu] [money] NULL ,
	[Za] [money] NULL ,
	[huoshi] [money] NULL ,
	[QiTa1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[QiTa1Fei] [money] NULL ,
	[QiTa2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[QiTa2Fei] [money] NULL ,
	[BeiZhu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[YueShu] [int] NULL ,
	[HuoShiYueshu] [int] NULL ,
	[HuoShiDanJia] [money] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[accident]    Script Date: 2003-4-2 11:36:14 ******/
CREATE TABLE [dbo].[accident] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[student_id] [numeric](18, 0) NOT NULL ,
	[place] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xtime] [datetime] NOT NULL ,
	[fxr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[message] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[clr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[result] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[parents_idea] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[zjfzr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[lead_idea] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[class] [numeric](18, 0) NOT NULL ,
	[teacher] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[book]    Script Date: 2003-4-2 11:36:14 ******/
CREATE TABLE [dbo].[book] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pf] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[gsr] [int] NOT NULL ,
	[kll] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dbz] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[zf] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ts] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[borrow_tools]    Script Date: 2003-4-2 11:36:14 ******/
CREATE TABLE [dbo].[borrow_tools] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[borrow_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[tools] [numeric](18, 0) NOT NULL ,
	[xtime] [datetime] NOT NULL ,
	[quantity] [int] NOT NULL ,
	[gh_time] [datetime] NOT NULL ,
	[gh] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[sp] [char] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[card_fee_info]    Script Date: 2003-4-2 11:36:15 ******/
CREATE TABLE [dbo].[card_fee_info] (
	[卡号] [int] NULL ,
	[卡余额] [float] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[card_fee_info_cancel]    Script Date: 2003-4-2 11:36:15 ******/
CREATE TABLE [dbo].[card_fee_info_cancel] (
	[卡号] [int] NULL ,
	[卡余额] [money] NULL 
) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[class]    Script Date: 2003-4-2 11:36:15 ******/
CREATE TABLE [dbo].[class] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[alia] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[class_header] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[photo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[class_assets]    Script Date: 2003-4-2 11:36:15 ******/
CREATE TABLE [dbo].[class_assets] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[xdate] [datetime] NOT NULL ,
	[class] [numeric](18, 0) NOT NULL ,
	[name] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sl] [int] NOT NULL ,
	[xvalue] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[fzr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[class_move]    Script Date: 2003-4-2 11:36:15 ******/
CREATE TABLE [dbo].[class_move] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[xtime] [datetime] NOT NULL ,
	[class] [numeric](18, 0) NOT NULL ,
	[week] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[teacher] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[education] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[live] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[environment] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[parents] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[morning] [varchar] (550) COLLATE Chinese_PRC_CI_AS NULL ,
	[zc] [varchar] (550) COLLATE Chinese_PRC_CI_AS NULL ,
	[edu] [varchar] (550) COLLATE Chinese_PRC_CI_AS NULL ,
	[hwhd] [varchar] (550) COLLATE Chinese_PRC_CI_AS NULL ,
	[snyx] [varchar] (550) COLLATE Chinese_PRC_CI_AS NULL ,
	[syyx] [varchar] (550) COLLATE Chinese_PRC_CI_AS NULL ,
	[lyhd] [varchar] (550) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[class_pic]    Script Date: 2003-4-2 11:36:16 ******/
CREATE TABLE [dbo].[class_pic] (
	[pic_id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[images] [image] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[cookbook]    Script Date: 2003-4-2 11:36:16 ******/
CREATE TABLE [dbo].[cookbook] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xfirst] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[xsecond] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[xthird] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[lunch] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[fruit] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[snack] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[xtime] [datetime] NOT NULL ,
	[carbs] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[protein] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[fat] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cals] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[delicatessen]    Script Date: 2003-4-2 11:36:16 ******/
CREATE TABLE [dbo].[delicatessen] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[foodname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[calories] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fat] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[protein] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[carbs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[foodtype] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[foodconsume]    Script Date: 2003-4-2 11:36:16 ******/
CREATE TABLE [dbo].[foodconsume] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[renshu] [float] NULL ,
	[datetime] [datetime] NOT NULL ,
	[rlkj] [float] NULL ,
	[rlkcal] [float] NULL ,
	[danbaizhi] [float] NULL ,
	[zhifang] [float] NULL ,
	[xianwei] [float] NULL ,
	[huawu] [float] NULL ,
	[huluobosu] [float] NULL ,
	[weishengsua] [float] NULL ,
	[liuansu] [float] NULL ,
	[hehuangsu] [float] NULL ,
	[nikesuan] [float] NULL ,
	[huaixiesuan] [float] NULL ,
	[weishengsue] [float] NULL ,
	[jia] [float] NULL ,
	[na] [float] NULL ,
	[gai] [float] NULL ,
	[mei] [float] NULL ,
	[tie] [float] NULL ,
	[meng] [float] NULL ,
	[xin] [float] NULL ,
	[tong] [float] NULL ,
	[lin] [float] NULL ,
	[xi] [float] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[gg_admin]    Script Date: 2003-4-2 11:36:16 ******/
CREATE TABLE [dbo].[gg_admin] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[adminame] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[adminpwd] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[gg_bbs]    Script Date: 2003-4-2 11:36:16 ******/
CREATE TABLE [dbo].[gg_bbs] (
	[AnnounceID] [int] IDENTITY (1, 1) NOT NULL ,
	[ParentID] [int] NULL ,
	[Child] [int] NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[boardID] [int] NULL ,
	[UserEmail] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Body] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DateAndTime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[hits] [int] NULL ,
	[length] [int] NULL ,
	[RootID] [int] NULL ,
	[layer] [int] NULL ,
	[orders] [int] NULL ,
	[ip] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Expression] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[gg_bbs_board]    Script Date: 2003-4-2 11:36:17 ******/
CREATE TABLE [dbo].[gg_bbs_board] (
	[boardID] [int] IDENTITY (1, 1) NOT NULL ,
	[BoardType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BoardName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BoardMaster] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MasterPwd] [nvarchar] (11) COLLATE Chinese_PRC_CI_AS NULL ,
	[MasterEmail] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[gg_bbs_user]    Script Date: 2003-4-2 11:36:17 ******/
CREATE TABLE [dbo].[gg_bbs_user] (
	[UserID] [float] NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserEmail] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Article] [int] NULL ,
	[UserPassword] [nvarchar] (11) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sex] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[comefrom] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[homepage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[gg_guestbook]    Script Date: 2003-4-2 11:36:17 ******/
CREATE TABLE [dbo].[gg_guestbook] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[NAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EMAIL] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MESSAGE] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[DATE_ENTERED] [datetime] NULL ,
	[URL] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IP_ADDRESS] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[gg_ybqh]    Script Date: 2003-4-2 11:36:17 ******/
CREATE TABLE [dbo].[gg_ybqh] (
	[dq] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[sm] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[yb] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[qh] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[gr_address]    Script Date: 2003-4-2 11:36:17 ******/
CREATE TABLE [dbo].[gr_address] (
	[id] [numeric](10, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dw] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[dz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[jtdh] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[gzdh] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[sjhm] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[addedby] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[gr_bq]    Script Date: 2003-4-2 11:36:17 ******/
CREATE TABLE [dbo].[gr_bq] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[sendto] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[fromwho] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[message] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[sendtime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[gr_calendar]    Script Date: 2003-4-2 11:36:17 ******/
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -