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 |
||