Project

General

Profile

« Previous | Next » 

Revision 10738

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: client_version: added table, column comments with info on how to retrieve each value

View differences:

inputs/.TNRS/schema.sql
1 1 
CREATE TABLE client_version
2 2 
(
3 3 
  id text NOT NULL,
4 
  global_rev integer NOT NULL,
5 
  "/lib/tnrs.py rev" integer,
6 
  "/bin/tnrs_db rev" integer,
4 
  global_rev integer NOT NULL, -- from `svn info .` > Last Changed Rev
5 
  "/lib/tnrs.py rev" integer, -- from `svn info lib/tnrs.py` > Last Changed Rev
6 
  "/bin/tnrs_db rev" integer, -- from `svn info bin/tnrs_db` > Last Changed Rev
7 7 
  CONSTRAINT client_version_pkey PRIMARY KEY (id )
8 8 
)
9 9 
WITH (
10 10 
  OIDS=FALSE
11 11 
);
12 
COMMENT ON TABLE client_version
13 
  IS 'contains svn revisions';
14 
COMMENT ON COLUMN client_version.global_rev IS 'from `svn info .` > Last Changed Rev';
15 
COMMENT ON COLUMN client_version."/lib/tnrs.py rev" IS 'from `svn info lib/tnrs.py` > Last Changed Rev';
16 
COMMENT ON COLUMN client_version."/bin/tnrs_db rev" IS 'from `svn info bin/tnrs_db` > Last Changed Rev';
12 17 

  		




  13
  18
  
    
--


  		




  14
  19
  
    

  		












Also available in:  Unified diff