File: scmhook-init.sql

package info (click to toggle)
fusionforge 5.3.2%2B20141104-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie-kfreebsd
  • size: 60,472 kB
  • sloc: php: 271,846; sql: 36,817; python: 14,575; perl: 6,406; sh: 5,980; xml: 4,294; pascal: 1,411; makefile: 911; cpp: 52; awk: 27
file content (24 lines) | stat: -rw-r--r-- 625 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
CREATE TABLE plugin_scmhook (
	id		serial PRIMARY KEY,
	id_group	integer NOT NULL,
	need_update	integer DEFAULT 0,
	hooks		text
);

CREATE TABLE plugin_scmhook_scmsvn_committracker_data_artifact (
	id			serial PRIMARY KEY,
	kind			integer DEFAULT '0' NOT NULL,
	group_artifact_id	integer,
	project_task_id		integer
);

CREATE TABLE plugin_scmhook_scmsvn_committracker_data_master (
	id		serial PRIMARY KEY,
	holder_id	integer NOT NULL,
	svn_date	integer NOT NULL,
	log_text	text DEFAULT '',
	file		text DEFAULT '' NOT NULL,
	prev_version	text DEFAULT '',
	actual_version	text DEFAULT '',
	author		text DEFAULT '' NOT NULL
);