# WEB-INF

**Repository Path**: sharkseven/XVDZ-deploy

## Basic Information

- **Project Name**: WEB-INF
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2016-07-25
- **Last Updated**: 2021-11-03

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#XVDZ-deploy
/*==============================================================*/
/* Table: gospel_applications                                   */
/*==============================================================*/
create table gospel_applications (
   id                   VARCHAR(32)          not null,
   name                 VARCHAR(100)         null,
   port                 VARCHAR(6)           null,
   ssh_port             VARCHAR(6)           null,
   source               VARCHAR(255)         null,
   domain               VARCHAR(100)         null,
   members              text                 null,
   team                 VARCHAR(32)          null,
   creator              VARCHAR(32)          null,
   createat             TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   updateat             TIME WITHOUT TIME ZONE null,
   constraint PK_GOSPEL_APPLICATIONS primary key (id)
);

/*==============================================================*/
/* Table: gospel_company                                        */
/*==============================================================*/
create table gospel_company (
   id                   VARCHAR(32)          not null,
   name                 VARCHAR(100)         null,
   owner                VARCHAR(32)          null,
   licence_photo        VARCHAR(255)         null,
   status               TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   updateat             TIME WITHOUT TIME ZONE null,
   createat             TIME WITHOUT TIME ZONE null,
   constraint PK_GOSPEL_COMPANY primary key (id)
);

/*==============================================================*/
/* Table: gospel_groups                                         */
/*==============================================================*/
create table gospel_groups (
   id                   VARCHAR(32)          not null,
   name                 VARCHAR(20)          null,
   type                 VARCHAR(32)          null,
   privileges           text                 null,
   createat             TIME WITHOUT TIME ZONE null,
   updateat             TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   constraint PK_GOSPEL_GROUPS primary key (id)
);

/*==============================================================*/
/* Table: gospel_notice_read                                    */
/*==============================================================*/
create table gospel_notice_read (
   id                   VARCHAR(32)          not null,
   user_id              VARCHAR(100)         null,
   notice_id            VARCHAR(32)          null,
   createat             TIME WITHOUT TIME ZONE null,
   read                 INT2                 null,
   constraint PK_GOSPEL_NOTICE_READ primary key (id)
);

/*==============================================================*/
/* Table: gospel_notices                                        */
/*==============================================================*/
create table gospel_notices (
   id                   VARCHAR(32)          not null,
   title                VARCHAR(100)         null,
   content              VARCHAR(6)           null,
   receiver             VARCHAR(6)           null,
   type                 VARCHAR(255)         null,
   sender               VARCHAR(32)          null,
   teams                text                 null,
   user_type            VARCHAR(32)          null,
   createat             TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   updateat             TIME WITHOUT TIME ZONE null,
   constraint PK_GOSPEL_NOTICES primary key (id)
);

/*==============================================================*/
/* Table: gospel_orders                                         */
/*==============================================================*/
create table gospel_orders (
   id                   VARCHAR(32)          not null,
   products             VARCHAR(32)          null,
   price                double precision     null,
   expiredat            TIME WITHOUT TIME ZONE null,
   creater              VARCHAR(32)          null,
   status               INT2                 null,
   buy_time_length      INT4                 null,
   value_added          VARCHAR(32)          null,
   createat             TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   updateat             TIME WITHOUT TIME ZONE null,
   constraint PK_GOSPEL_ORDERS primary key (id)
);

/*==============================================================*/
/* Table: gospel_privileges                                     */
/*==============================================================*/
create table gospel_privileges (
   id                   VARCHAR(32)          not null,
   name                 VARCHAR(100)         null,
   router               VARCHAR(32)          null,
   createat             TIME WITHOUT TIME ZONE null,
   updateat             TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   constraint PK_GOSPEL_PRIVILEGES primary key (id)
);

/*==============================================================*/
/* Table: gospel_products                                       */
/*==============================================================*/
create table gospel_products (
   id                   VARCHAR(32)          not null,
   name                 VARCHAR(100)         null,
   price                double precision     null,
   parent               VARCHAR(32)          null,
   people_limit         INT4                 null,
   format               VARCHAR(100)         null,
   createat             TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   updateat             TIME WITHOUT TIME ZONE null,
   constraint PK_GOSPEL_PRODUCTS primary key (id)
);

/*==============================================================*/
/* Table: gospel_team                                           */
/*==============================================================*/
create table gospel_team (
   id                   VARCHAR(32)          not null,
   name                 VARCHAR(100)         null,
   members              text                 null,
   applications         text                 null,
   expiredat            TIME WITHOUT TIME ZONE null,
   creator              VARCHAR(32)          null,
   createat             TIME WITHOUT TIME ZONE null,
   updateat             TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   constraint PK_GOSPEL_TEAM primary key (id)
);

/*==============================================================*/
/* Table: gospel_types                                          */
/*==============================================================*/
create table gospel_types (
   id                   VARCHAR(32)          not null,
   name                 VARCHAR(100)         null,
   parent               VARCHAR(32)          null,
   description          VARCHAR(255)         null,
   createat             TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   updateat             TIME WITHOUT TIME ZONE null,
   constraint PK_GOSPEL_TYPES primary key (id)
);

/*==============================================================*/
/* Table: gospel_user_groups                                    */
/*==============================================================*/
create table gospel_user_groups (
   id                   VARCHAR(32)          not null,
   user_id              VARCHAR(100)         null,
   group_id             VARCHAR(32)          null,
   createat             TIME WITHOUT TIME ZONE null,
   constraint PK_GOSPEL_USER_GROUPS primary key (id)
);

/*==============================================================*/
/* Table: gospel_users                                          */
/*==============================================================*/
create table gospel_users (
   id                   VARCHAR(32)          not null,
   name                 VARCHAR(20)          null,
   type                 VARCHAR(32)          null,
   team                 VARCHAR(32)          null,
   "group"              VARCHAR(32)          null,
   company              VARCHAR(32)          null,
   qq                   VARCHAR(20)          null,
   photo                text                 null,
   wechat               VARCHAR(20)          null,
   isdeleted            INT2                 null,
   workspace            VARCHAR(255)         null,
   isblocked            INT2                 null,
   createat             TIME WITHOUT TIME ZONE null,
   updateat             TIME WITHOUT TIME ZONE null,
   constraint PK_GOSPEL_USERS primary key (id)
);

/*==============================================================*/
/* Table: gospel_value_addeds                                   */
/*==============================================================*/
create table gospel_value_addeds (
   id                   VARCHAR(32)          not null,
   name                 VARCHAR(100)         null,
   disk_size            double precision     null,
   price                double precision     null,
   unit                 VARCHAR(6)           null,
   time_length          VARCHAR(6)           null,
   createat             TIME WITHOUT TIME ZONE null,
   isdeleted            INT2                 null,
   updateat             TIME WITHOUT TIME ZONE null,
   constraint PK_GOSPEL_VALUE_ADDEDS primary key (id)
);