createwebedutables.sql

采用Eclispe开发平台

/*==============================================================*/
/* Database name:  Physical                                     */
/* DBMS name:      Microsoft SQL Server 2000                    */
/* Created on:     11/2/2003 2:04:02 PM                         */
/*==============================================================*/


if exists (select 1
            from  sysindexes
           where  id    = object_id('t_user')
            and   name  = 'LoginName_AK'
            and   indid > 0
            and   indid < 255)
   drop index t_user.LoginName_AK
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_administrator')
            and   type = 'U')
   drop table t_administrator
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_bbs_announce')
            and   type = 'U')
   drop table t_bbs_announce
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_bbs_board')
            and   type = 'U')
   drop table t_bbs_board
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_class')
            and   type = 'U')
   drop table t_class
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_class_course')
            and   type = 'U')
   drop table t_class_course
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_course')
            and   type = 'U')
   drop table t_course
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_course_developer')
            and   type = 'U')
   drop table t_course_developer
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_course_history')
            and   type = 'U')
   drop table t_course_history
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_exam')
            and   type = 'U')
   drop table t_exam
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_exam_assigned')
            and   type = 'U')
   drop table t_exam_assigned
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_exam_assigned_paper')
            and   type = 'U')
   drop table t_exam_assigned_paper
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_exam_assigned_student')
            and   type = 'U')
   drop table t_exam_assigned_student
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_exam_question')
            and   type = 'U')
   drop table t_exam_question
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_exam_question_submit')
            and   type = 'U')
   drop table t_exam_question_submit
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_exam_question_upload')
            and   type = 'U')
   drop table t_exam_question_upload
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_exam_submit')
            and   type = 'U')
   drop table t_exam_submit
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_login_log')
            and   type = 'U')
   drop table t_login_log
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_messages')
            and   type = 'U')
   drop table t_messages
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_new_student')
            and   type = 'U')
   drop table t_new_student
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_question')
            and   type = 'U')
   drop table t_question
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_question_choice')
            and   type = 'U')
   drop table t_question_choice
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_question_file')
            and   type = 'U')
   drop table t_question_file
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_question_point')
            and   type = 'U')
   drop table t_question_point
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_school')
            and   type = 'U')
   drop table t_school
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_student')
            and   type = 'U')
   drop table t_student
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_student_course')
            and   type = 'U')
   drop table t_student_course
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_teacher')
            and   type = 'U')
   drop table t_teacher
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_teacher_award')
            and   type = 'U')
   drop table t_teacher_award
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_teacher_evaluation')
            and   type = 'U')
   drop table t_teacher_evaluation
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_teacher_exam')
            and   type = 'U')
   drop table t_teacher_exam
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_teacher_log')
            and   type = 'U')
   drop table t_teacher_log
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_teacher_training')
            and   type = 'U')
   drop table t_teacher_training
go


if exists (select 1
            from  sysobjects
           where  id = object_id('t_user')
            and   type = 'U')
   drop table t_user
go


/*==============================================================*/
/* Table: t_administrator                                       */
/*==============================================================*/
create table t_administrator (
   UserId               int                  null
)
go


/*==============================================================*/
/* Table: t_bbs_announce                                        */
/*==============================================================*/
create table t_bbs_announce (