CREATE TABLE BBSINDEX ( [ID] CHAR(2) NULL, [NAME] CHAR(16) NULL)

CREATE TABLE BBS ( TOPICID CHAR(6), SUBJECT CHAR(64), DESTRIBUTE NTEXT, POSTDATETIME CHAR(14), POSTERID CHAR(10), 
                   POSTERNAME CHAR(16), POSTEREMAIL CHAR(36), BBSID CHAR(2), SUBID CHAR(3), IMGID CHAR(2), CLICKED INTEGER,
                   REPLYS INTEGER, BYTES INTEGER)

CREATE TABLE DEPARTMENTS ( [ID] CHAR(8) NULL, [NAME] CHAR(16) NULL)

CREATE TABLE FORMS ( FORMID NVARCHAR(8) NULL, FORMNAME NVARCHAR(32) NULL, METHOD NVARCHAR(4), [ACTION] NVARCHAR(80), 
                     [LANGUAGE] NVARCHAR(1), VOCATIONID NVARCHAR(2), ITEMS NTEXT, FORMTYPE NVARCHAR(1))

CREATE TABLE INEWSINDEX ( [ID] CHAR(2) NULL, [NAME] CHAR(16) NULL)

CREATE TABLE INNEWS ( SUBJECT NVARCHAR(128) NULL, POSTDATETIME NVARCHAR(14) NULL, DESTRIBUTE NTEXT, POSTERID NVARCHAR(10), POSTERNAME NVARCHAR(24), POSTEREMAIL NVARCHAR(36), PARENTID NVARCHAR(2))

CREATE TABLE NEWSKEYWORDS ( KID CHAR(2), KEYWORD CHAR(12), FETCHDATETIME CHAR(14), PARENTID CHAR(2))

CREATE TABLE OADOCUMENTS ( SUBJECT NVARCHAR(64), DESTRIBUTE NTEXT, SUGGEST NTEXT, DOCFILENAME NVARCHAR(64), POSTDATETIME NVARCHAR(14), POSTERID NVARCHAR(10),
                           POSTERNAME NVARCHAR(16), POSTEREMAIL NVARCHAR(36), DIDLIST NTEXT, UIDLIST NTEXT, PARENTID CHAR(2))

CREATE TABLE OAINDEX ( [ID] CHAR(2), [NAME] CHAR(16))

CREATE TABLE OFFERINDEX ( [ID] CHAR(2), [NAME] CHAR(16))

CREATE TABLE OFFERKEYWORDS ( KID CHAR(2), KEYWORD CHAR(12), FETCHDATETIME CHAR(14), PARENTID CHAR(2))

CREATE TABLE OFFERS ( OFFERTYPE CHAR(1), SUBJECT NVARCHAR(64), DESTRIBUTE NTEXT, POSTDATETIME CHAR(14), POSTERIDDOMAIN NVARCHAR(22), POSTERNAME NVARCHAR(32), POSTEREMAIL NVARCHAR(36), 
                      POSTERTELEPHONE NVARCHAR(24), FROMSITEURL NVARCHAR(128), PARENTID CHAR(2))

CREATE TABLE ONEWSINDEX ( [ID] CHAR(2) NULL, [NAME] CHAR(16) NULL)

CREATE TABLE OUTENTERPRISES ( USERIDDOMAIN NVARCHAR(22), USERNAME NVARCHAR(48), TELEPHONE NVARCHAR(24), FAX NVARCHAR(24), ADDRESS NVARCHAR(48), ZIP NVARCHAR(6), EMAIL NVARCHAR(36), 
                              HOMEPAGE NVARCHAR(96), DESTRIBUTE NTEXT, LOGDATETIME CHAR(14))

CREATE TABLE OUTNEWS ( SUBJECT NVARCHAR(128), POSTDATETIME NVARCHAR(14), DESTRIBUTE NTEXT, FROMSITENAME NVARCHAR(32), FROMSITEURL NVARCHAR(128), PARENTID CHAR(2))

CREATE TABLE RECEIVEGBOOK ( [ID] CHAR(4), SUBJECT NVARCHAR(64), DESTRIBUTE NTEXT, POSTDATETIME CHAR(14), USERIDDOMAIN NVARCHAR(22), USERNAME NVARCHAR(48), TELEPHONE NVARCHAR(24), FAX NVARCHAR(24), ADDRESS NVARCHAR(48), ZIP NVARCHAR(6), EMAIL NVARCHAR(36), HOMEPAGE NVARCHAR(96))

CREATE TABLE RESINDEX ( [ID] CHAR(2) NULL, [NAME] CHAR(16) NULL)

CREATE TABLE RESOURCE ( SUBJECT NVARCHAR(64), RESFILENAME NVARCHAR(64), DESTRIBUTE NTEXT, POSTDATETIME NVARCHAR(14), POSTERID NVARCHAR(10),
                           POSTERNAME NVARCHAR(16), POSTEREMAIL NVARCHAR(36), PARENTID CHAR(2), FILESIZE FLOAT)

CREATE TABLE SENDGBOOK ( [ID] CHAR(4), SUBJECT NVARCHAR(64), DESTRIBUTE NTEXT, POSTDATETIME CHAR(14), TARGETUSERIDDOMAIN NVARCHAR(22), TARGETUSERNAME NVARCHAR(32), 
                         TARGETUSEREMAIL NVARCHAR(36), SENDERID NVARCHAR(10), SENDERNAME NVARCHAR(16))

CREATE TABLE USERS ( [ID] CHAR(4), USERID NVARCHAR(10), [NAME] NVARCHAR(16), [PASSWORD] NVARCHAR(10), EMAIL NVARCHAR(36), TELEPHONE NVARCHAR(24), HOMEPAGE NVARCHAR(96), DEPARTID CHAR(8), RIGHTS CHAR(10), USERTYPE CHAR(1), LASTCHECKDATETIME CHAR(14))

CREATE TABLE WZIN ( WZID CHAR(4), WZNAME NVARCHAR(24), WZGG NVARCHAR(16), NOTE NVARCHAR(128), POSTDATETIME CHAR(14), PARENTID CHAR(2), [NUMBER] FLOAT, PRICE FLOAT, MONEY FLOAT, USERID NVARCHAR(10), USERNAME NVARCHAR(16), PRICE1 FLOAT, MONEY1 FLOAT, PZHM NVARCHAR(10))

CREATE TABLE WZINDEX ( [ID] CHAR(2) NULL, [NAME] CHAR(16) NULL)

CREATE TABLE WZKC ( WZID CHAR(4), WZNAME NVARCHAR(24), WZGG NVARCHAR(16), POSTDATETIME CHAR(14), PARENTID CHAR(2), PRICE FLOAT, [NUMBER] FLOAT, [MONEY] FLOAT, USERID NVARCHAR(10))

CREATE TABLE WZOUT ( WZID CHAR(4), WZNAME NVARCHAR(24), WZGG NVARCHAR(16), NOTE NVARCHAR(128), POSTDATETIME CHAR(14), PARENTID CHAR(2), [NUMBER] FLOAT, PRICE FLOAT, MONEY FLOAT, USERID NVARCHAR(10), USERNAME NVARCHAR(16), PRICE1 FLOAT, MONEY1 FLOAT, PZHM NVARCHAR(10))

CREATE TABLE WZRIGHTS ( USERID NVARCHAR(10), USERNAME NVARCHAR(16), PARENTID CHAR(2), RIGHTS CHAR(4))

CREATE TABLE MYGBOOK ( ID NVARCHAR(6), SUBJECT NVARCHAR(64), DESTRIBUTE NTEXT, POSTDATETIME CHAR(14), TARGETUSERID NVARCHAR(10), TARGETUSERNAME NVARCHAR(16), SENDERUSERID NVARCHAR(10), SENDERUSERNAME NVARCHAR(16), SUBID CHAR(3))

