×
We value your feedback! Please click here to access our 2024 Client Survey.
The survey will remain open until November 1st. Your perspective will help guide our product/service planning and goals for the upcoming year and beyond!

Custom tables for a module/web part

LabKey Support Forum
Custom tables for a module/web part Leo Dashevskiy  2012-07-27 14:23
Status: Closed
 
So when I try to generate this xml schema file I get a file with just one line:

<ns:tables xmlns:ns="http://labkey.org/data/xml"/>


and under <labkey>/server/customModules/<web part name>/src/schmeas/dbscripts/postgresql I have the file named: <schema name>-0.00-0.01.sql

The version of my web part as specified in the config file is 0.01

Here is an example of what the sql file contains:

CREATE SCHEMA QUALIFIER;

CREATE TABLE QUALIFIER.qaTaskList
(
    qaId SERIAL NOT NULL,
    qaName VARCHAR(45) NOT NULL,
    description VARCHAR(45) NOT NULL,
    qaLevel VARCHAR(45) NOT NULL,
    pop VARCHAR(45) NOT NULL,
    formula VARCHAR(45) NOT NULL,
    plotType VARCHAR(45) NOT NULL,

    CONSTRAINT PK_qaTaskList PRIMARY KEY (qaId)
);

So if I understand correctly, the schema description generator does not pick up the sql file and so I do not see anything in the schema browser pertaining to my new schema.

Please, advise, how do I create some custom tables?

Thanks.
-Leo