1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
| create extension if not exists postgis cascade;
|
| create extension if not exists "uuid-ossp";
|
| create schema if not exists bs;
|
| create table bs.simu (
| id serial primary key,
| pid integer,
| num integer,
| name varchar(200),
| service_name varchar(200),
| data varchar(8000),
| status smallint default 0,
| result varchar(2000),
| create_time timestamp(6) without time zone default now(),
| update_time timestamp(6) without time zone,
| sem_url varchar(2000),
| point_url varchar(2000),
| link_url varchar(2000),
| bak varchar(2000)
| );
|
| select * from bs.simu;
|
|
