File: sql_states.h

package info (click to toggle)
kraft 2.0.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 10,112 kB
  • sloc: cpp: 28,535; sql: 1,248; perl: 396; xml: 330; python: 101; sh: 92; makefile: 10
file content (25 lines) | stat: -rw-r--r-- 650 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

#ifndef T_SQLDEFS
#define T_SQLDEFS

#define CREATE_ATTRIBUTES "CREATE TABLE attributes ( \
  hostObject            VARCHAR(64), \
  hostId                INT NOT NULL, \
  name                  VARCHAR(64),  \
  value                 MEDIUMTEXT,   \
  valueIsList           tinyint default 0, \
  relationTable         VARCHAR(64) default NULL, \
  relationIDColumn      VARCHAR(64) default NULL, \
  relationStringColumn  VARCHAR(64) default NULL, \
  PRIMARY KEY( hostObject, hostId, name ) \
);"

#define CREATE_DOCTYPES "CREATE TABLE DocTypes ( \
  docTypeID INTEGER PRIMARY KEY ASC autoincrement, \
  name      VARCHAR(255) \
  );"



#endif