00001 -- Database for P-CSCF and S-CSCF persistency
00002
00003 CREATE DATABASE IF NOT EXISTS pscscf;
00004
00005 USE pscscf;
00006
00007 DROP TABLE IF EXISTS snapshot;
00008 CREATE TABLE snapshot (
00009 id INT NOT NULL AUTO_INCREMENT,
00010 node_id VARCHAR(64) NOT NULL,
00011 data_type INT NOT NULL,
00012 snapshot_version INT NOT NULL,
00013 step_version INT NOT NULL,
00014 record_id_1 VARCHAR(256),
00015 record_id_2 VARCHAR(256),
00016 record_id_3 VARCHAR(256),
00017 record_id_4 VARCHAR(256),
00018 data BLOB NOT NULL,
00019 PRIMARY KEY(id)
00020 );
00021
00022 grant delete,insert,select,update on pscscf.* to pscscf@localhost identified by 'pscscf';
