persist_my.sql File Reference

Go to the source code of this file.

Functions
CREATE TABLE	snapshot (id INT NOT NULL AUTO_INCREMENT, node_id VARCHAR(64) NOT NULL, data_type INT NOT NULL, snapshot_version INT NOT NULL, step_version INT NOT NULL, record_id_1 VARCHAR(256), record_id_2 VARCHAR(256), record_id_3 VARCHAR(256), record_id_4 VARCHAR(256), data BLOB NOT NULL, PRIMARY KEY(id))
Variables
Database for P CSCF and S CSCF persistency CREATE DATABASE IF NOT EXISTS	pscscf
USE	pscscf
DROP TABLE IF EXISTS	snapshot
grant	delete
grant	insert
grant	select
grant update on pscscf *to pscscf localhost identified by	pscscf

---

Function Documentation

CREATE TABLE snapshot	(	id INT NOT NULL	AUTO_INCREMENT,
		node_id VARCHAR(64) NOT	NULL,
		data_type INT NOT	NULL,
		snapshot_version INT NOT	NULL,
		step_version INT NOT	NULL,
		record_id_1	VARCHAR(256),
		record_id_2	VARCHAR(256),
		record_id_3	VARCHAR(256),
		record_id_4	VARCHAR(256),
		data BLOB NOT	NULL,
		PRIMARY	KEY(id)
	)

---

Variable Documentation

Database for P CSCF and S CSCF persistency CREATE DATABASE IF NOT EXISTS pscscf

Definition at line 3 of file persist_my.sql.

USE pscscf

Definition at line 5 of file persist_my.sql.

DROP TABLE IF EXISTS snapshot

Definition at line 7 of file persist_my.sql.

grant delete

Definition at line 22 of file persist_my.sql.

grant insert

Definition at line 22 of file persist_my.sql.

grant select

Definition at line 22 of file persist_my.sql.

grant update on pscscf* to pscscf localhost identified by pscscf

Definition at line 22 of file persist_my.sql.

---