File: csync2-postgres.sql

package info (click to toggle)
csync2 2.0-42-g83b3644-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 868 kB
  • sloc: ansic: 6,878; sh: 849; yacc: 458; perl: 277; lex: 92; makefile: 92; cs: 73; sql: 42
file content (56 lines) | stat: -rw-r--r-- 1,008 bytes parent folder | download | duplicates (5)
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
--
-- Table structure for table action
--

DROP TABLE IF EXISTS action;
CREATE TABLE action (
  filename varchar(255) DEFAULT NULL,
  command text,
  logfile text,
  UNIQUE (filename,command)
);

--
-- Table structure for table dirty
--

DROP TABLE IF EXISTS dirty;
CREATE TABLE dirty (
  filename varchar(200) DEFAULT NULL,
  forced int DEFAULT NULL,
  myname varchar(100) DEFAULT NULL,
  peername varchar(100) DEFAULT NULL,
  UNIQUE (filename,peername)
);

--
-- Table structure for table file
--

DROP TABLE IF EXISTS file;
CREATE TABLE file (
  filename varchar(200) DEFAULT NULL,
  checktxt varchar(200) DEFAULT NULL,
  UNIQUE (filename)
);

--
-- Table structure for table hint
--

DROP TABLE IF EXISTS hint;
CREATE TABLE hint (
  filename varchar(255) DEFAULT NULL,
  recursive int DEFAULT NULL
);

--
-- Table structure for table x509_cert
--

DROP TABLE IF EXISTS x509_cert;
CREATE TABLE x509_cert (
  peername varchar(255) DEFAULT NULL,
  certdata varchar(255) DEFAULT NULL,
  UNIQUE (peername)
);