DROP TABLE group\g
CREATE TABLE group (
   gid		int,
   gname	char(100),
   gdesc	char(200)
)\g
CREATE SEQUENCE ON group STEP 1 VALUE 1\g

DROP TABLE subgroup\g
CREATE TABLE subgroup (
   gid		int,
   sgid		int,
   sgname	char(100),
   sgdesc	char(200)
)\g
CREATE SEQUENCE ON subgroup STEP 1 VALUE 1\g

DROP TABLE message\g
CREATE TABLE message (
   gid		int,
   sgid		int,
   article	int,
   follow	int,
   nick		char(20),
   subj		char(100),
   type		char(1),
   icon		int,
   messg	char(2000),
   vreme	int
)\g
CREATE SEQUENCE ON message STEP 1 VALUE 1\g
