pet_lg1.sql

来自「电子宠物狗」· SQL 代码 · 共 28 行

use [epet_lg1]
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PetInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PetInfo]
GO

CREATE TABLE [dbo].[PetInfo] (
	[pet_id] [int] IDENTITY (1, 1) NOT NULL ,
	[pet_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pet_sex] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[pet_strength] [int] NULL ,
	[pet_cute] [int] NULL ,
	[pet_love] [int] NULL ,
	[pet_intro] [varchar] (7000) COLLATE Chinese_PRC_CI_AS NULL ,
	[pet_owner_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pet_owner_email] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[pet_password] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pet_pic] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[pet_type] [int] NULL 
) ON [PRIMARY]
GO

INSERT INTO [epet_lg1].[dbo].[PetInfo]([pet_name], [pet_sex], [pet_strength], [pet_cute], [pet_love], [pet_intro], [pet_owner_name], [pet_owner_email], [pet_password], [pet_pic], [pet_type])
VALUES('小猪', '小', 170, 145, 139, '懒猪！', 'Harry Potter', '[e-mail]', 'pwd', 'images/pet/pig.jpg', 1);

SELECT * FROM petinfo;