33 lines
1.3 KiB
Transact-SQL
33 lines
1.3 KiB
Transact-SQL
|
|
|
|
CREATE TABLE [dbo].[MainData_Project](
|
|
[project_id] [nvarchar](50) NOT NULL,
|
|
[project_name] [nvarchar](100) NULL,
|
|
[project_code] [nvarchar](50) NULL,
|
|
[project_short_name] [nvarchar](50) NULL,
|
|
[project_category_code] [nvarchar](50) NULL,
|
|
[project_category] [nvarchar](50) NULL,
|
|
[project_type] [nvarchar](50) NULL,
|
|
[project_state_code] [nvarchar](50) NULL,
|
|
[project_state] [nvarchar](50) NULL,
|
|
[configuration_project_manager] [nvarchar](50) NULL,
|
|
[project_planned_start_time] [datetime] NULL,
|
|
[project_planned_complete_time] [datetime] NULL,
|
|
[sysdataid] [nvarchar](50) NULL,
|
|
[createtime] [datetime] NULL,
|
|
[modifytime] [datetime] NULL,
|
|
[version] [nvarchar](50) NULL,
|
|
[isusedcode] [nvarchar](50) NULL,
|
|
[sourceappcode] [nvarchar](50) NULL,
|
|
[state] [nvarchar](5) NULL,
|
|
CONSTRAINT [PK_Main_Project] PRIMARY KEY CLUSTERED
|
|
(
|
|
[project_id] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
|
|
INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'749B2E04-E4C2-4CBC-849E-FD2041135A43', N'Ö÷Êý¾ÝÏîÄ¿Áбí', NULL, N'ProjectData/MainDataProjectList.aspx', '11', N'0', N'Menu_Project', '1', '1', '1');
|