README
1MYSQL Database Schema(s) for SANCP data
2
3
4First: ABOUT SANCP OUTPUT FORMAT(S)
5===================================
6
7You can now use the 'format' option in the sancp configuration
8file to specify what information you wish to record for 'stats',
9'realtime', and 'stdout' (the latter is for 'console' use.)
10
11See docs/fields.LIST for the name and description of all available 'fields'
12See contrib/sancp.conf for an example 'format' configuration entry
13
14
15
16SANCP DB SCHEMAS
17================
18
19Now, with the above having been explained, you can have sancp
20create a basic mysql schema for each output format: stats and realtime.
21
22Running the following will generate schemas for sancp's default
23stats and realtime output formats.
24
25% sancp --schemas
26
27Sancp will exit after having created:
28
29 ./realtime.schema
30 ./stats.schema
31
32 in the current directory.
33
34
35
36And, this will create schemas for the stats and realtime output formats
37as specified in the configuration file 'sancp.conf'
38
39% sancp -c sancp.conf --schemas
40
41Again, the following files are created in the current directory
42
43 ./realtime.schema
44 ./stats.schema
45
46
47NOTE: The schemas generated by sancp DO require further modification; they are designed
48to help simplify the process of creating database tables.
49i.e You will need to, at least, identify a PRIMARY KEY field or INDEX(ES).
50
51