1 CREATE DATABASE "marketplaceDB";
5 DROP TABLE IF EXISTS CSAR_PACKAGE_TABLE;
7 CREATE TABLE CSAR_PACKAGE_TABLE (
8 CSARID VARCHAR(200) NOT NULL,
9 DOWNLOADURI VARCHAR(200) NULL,
10 REPORT VARCHAR(200) NULL,
11 SIZE VARCHAR(100) NULL,
12 FORMAT VARCHAR(100) NULL,
13 CREATETIME VARCHAR(100) NULL,
14 DELETIONPENDING VARCHAR(100) NULL,
15 MODIFYTIME VARCHAR(100) NULL,
17 NAME VARCHAR(100) NULL,
18 VERSION VARCHAR(20) NULL,
19 PROVIDER VARCHAR(300) NULL,
20 TYPE VARCHAR(300) NULL,
23 DOWNLOADCOUNT INT NULL,
24 CONSTRAINT csar_package_table_pkey PRIMARY KEY (CSARID)