北大青鸟 Y2 SSH 上机项目电子宠物

/****** Object: Database epet Script Date: 2007-7-4 14:46:37 ******/ IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'epet') DROP DATABASE [epet] GO CREATE DATABASE [epet] ON (NAME = N'epet_Data', FILENAME = N'd:\work\database\MSSQL\data\epet_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'epet_Log', FILENAME = N'd:\work\database\MSSQL\data\epet_Log.LDF' , SIZE = 1, FILEGROWTH = 10%) COLLATE Chinese_PRC_CI_AS GO exec sp_dboption N'epet', N'autoclose', N'false' GO exec sp_dboption N'epet', N'bulkcopy', N'false' GO exec sp_dboption N'epet', N'trunc. log', N'false' GO exec sp_dboption N'epet', N'torn page detection', N'true' GO exec sp_dboption N'epet', N'read only', N'false' GO exec sp_dboption N'epet', N'dbo use', N'false' GO exec sp_dboption N'epet', N'single', N'false' GO exec sp_dboption N'epet', N'autoshrink', N'false' GO exec sp_dboption N'epet', N'ANSI null default', N'false' GO exec sp_dboption N'epet', N'recursive triggers', N'false' GO exec sp_dboption N'epet', N'ANSI nulls', N'false' GO exec sp_dboption N'epet', N'concat null yields null', N'false' GO exec sp_dboption N'epet', N'cursor close on commit', N'false' GO exec sp_dboption N'epet', N'default to local cursor', N'false' GO exec sp_dboption N'epet', N'quoted identifier', N'false' GO exec sp_dboption N'epet', N'ANSI warnings', N'false' GO exec sp_dboption N'epet', N'auto create statistics', N'true' GO exec sp_dboption N'epet', N'auto update statistics', N'true' GO if( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) ) exec sp_dboption N'epet', N'db chaining', N'false' GO use [epet] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_PetDiary_PetInfo]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[PetDiary] DROP CONSTRAINT FK_PetDiary_PetInfo GO /****** Object: Table [dbo].[PetDiary] Script Date: 2007-7-4 14:46:37 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PetDiary]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[PetDiary] GO /****** Object: Table [dbo].[PetInfo] Script Date: 2007-7-4 14:46:37 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PetInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[PetInfo] GO /****** Object: Table [dbo].[PetDiary] Script Date: 2007-7-4 14:46:38 ******/ CREATE TABLE [dbo].[PetDiary] ( [diary_id] [int] IDENTITY (1, 1) NOT NULL , [diary_pet_id] [int] NULL , [diary_date] [datetime] NULL , [diary_title] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL , [diary_weather] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [diary_context] [varchar] (7000) COLLATE Chinese_PRC_CI_AS NULL , [diary_is_public] [bit] NULL , [diary_last_modify] [datetime] NULL , [diary_author] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [diary_author_email] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[PetInfo] Script Date: 2007-7-4 14:46:40 ******/ 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 ALTER TABLE [dbo].[PetDiary] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [diary_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PetInfo] WITH NOCHECK ADD CONSTRAIN�