infobase.sql

duiwenjiandechuli fangbianguanli.

/*==============================================================*/
/* Database name:  Database                                     */
/* DBMS name:      Microsoft Access 2000                        */
/* Created on:     2003-6-30 23:00:31                           */
/*==============================================================*/


drop table tmp_InfoContent
 ;


/*==============================================================*/
/* Table: tmp_InfoContent                                       */
/*==============================================================*/
create table tmp_InfoContent
(
    AutoID               INTEGER,
    InfoContent          Memo,
    PostTime             DATETIME,
    clsID                INTEGER
)
 ;


insert into tmp_InfoContent (AutoID, InfoContent, PostTime, clsID)
select AutoID, InfoContent, PostTime, clsID
from InfoContent
 ;


drop table InfoContent
 ;


drop table tmp_InfoFile
 ;


/*==============================================================*/
/* Table: tmp_InfoFile                                          */
/*==============================================================*/
create table tmp_InfoFile
(
    AutoID               INTEGER,
    FileBin              BINARY(510),
    FileName             Text(255),
    FileSize             Text(50),
    InfoID               INTEGER
)
 ;


insert into tmp_InfoFile (AutoID, FileBin, FileName, FileSize, InfoID)
select AutoID, FileBin, FileName, FileSize, InfoID
from InfoFile
 ;


drop table InfoFile
 ;


drop table tmp_InfoType
 ;


/*==============================================================*/
/* Table: tmp_InfoType                                          */
/*==============================================================*/
create table tmp_InfoType
(
    AutoID               INTEGER,
    InfoTypeName         Text(50),
    ParentID             INTEGER
)
 ;


insert into tmp_InfoType (AutoID, InfoTypeName, ParentID)
select AutoID, InfoTypeName, ParentID
from InfoType
 ;


drop table InfoType
 ;


/*==============================================================*/
/* Table: InfoContent                                           */
/*==============================================================*/
create table InfoContent
(
    AutoID               int             not null,
    InfoContent          MEMO,
    PostTime             DATETIME,
    clsID                int             not null
)
 ;


insert into InfoContent (AutoID, InfoContent, PostTime, clsID)
select AutoID, InfoContent, PostTime, clsID
from tmp_InfoContent
 ;


drop table tmp_InfoContent
 ;


/*==============================================================*/
/* Table: InfoFile                                              */
/*==============================================================*/
create table InfoFile
(
    AutoID               int             not null,
    FileBin              BINARY,
    FileName             text(255),
    FileSize             text(50),
    InfoID               int
)
 ;


insert into InfoFile (AutoID, FileBin, FileName, FileSize, InfoID)
select AutoID, FileBin, FileName, FileSize, InfoID
from tmp_InfoFile
 ;


drop table tmp_InfoFile
 ;


/*==============================================================*/
/* Table: InfoType                                              */
/*==============================================================*/
create table InfoType
(
    AutoID               int             not null,
    InfoTypeName         TEXT(50),
    ParentID             int
)
 ;


insert into InfoType (AutoID, InfoTypeName, ParentID)
select AutoID, InfoTypeName, ParentID
from tmp_InfoType
 ;


drop table tmp_InfoType
 ;


alter table InfoContent
   add constraint FK_INFOCONT_FK_INFOCO_INFOTYPE foreign key (clsID)
      references InfoType (AutoID)
 ;


alter table InfoFile
   add constraint FK_INFOFILE_FK_INFOFI_INFOCONT foreign key (InfoID)
      references InfoContent (AutoID)
 ;