[Asp.net] Calendar + JqueryUi implement Calendar management (right-click menu, add, edit, delete, source code)
1 USE [Wolfy. schedule] 2 GO 3 4/****** Object: Table [dbo]. [TB_Schedule] Script Date: 2014/7/5 16:30:00 *****/5 SET ANSI_NULLS ON 6 GO 7 8 SET QUOTED_IDENTIFIER ON 9 GO10 11 SET ANSI_PADDING ON12 GO13 14 create table [dbo]. [TB_Schedule] (15 [scheduleId] [int] IDENTITY (320) not null, 16 [scheduleDescription] [nvarchar] () NULL, 17 [scheduleCreateDate] [datetime] NULL, 18 [scheduleColor] [varchar] (32) NULL, 19 [scheduleTitle] [nvarchar] (160) NULL, 20 [userId] [int] not null, 21 [schedulePlanDate] [datetime] NULL, 22 CONSTRAINT [PK_TB_Schedule] primary key clustered 23 (24 [scheduleId] ASC25) WITH (PAD_INDEX = OFF, expiration = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 26) ON [PRIMARY] 27 28 GO29 30 SET ANSI_PADDING OFF31 GO 1 USE [Wolfy. schedule] 2 GO 3 4/****** Object: Table [dbo]. [TB_UserInfo] Script Date: 2014/7/5 16:30:22 *****/5 SET ANSI_NULLS ON 6 GO 7 8 SET QUOTED_IDENTIFIER ON 9 GO10 11 SET ANSI_PADDING ON12 GO13 14 create table [dbo]. [TB_UserInfo] (15 [userId] [int] IDENTITY (1,1) not null, 16 [userName] [nvarchar] (20) NULL, 17 [userGender] [bit] NULL, 18 [userLoginName] [varchar] (32) NULL, 19 [userPwd] [varchar] (32) NULL, 20 [userCreateDate] [datetime] NULL, 21 [userIsDelete] [bit] NULL, 22 [userBirthday] [datetime] NULL, 23 [userLoginCount] [int] NULL, 24 [userAge] [int] NULL, 25 CONSTRAINT [PK_TB_UserInfo] primary key clustered 26 (27 [userId] ASC28) WITH (PAD_INDEX = OFF, rows = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 29) ON [PRIMARY] 30 31 GO32 33 SET ANSI_PADDING OFF34 GO