2 -- purpose: stuff for project database and vhost maintanance
4 CREATE TABLE prdb_dbs (
5 dbid SERIAL PRIMARY KEY,
8 dbusername TEXT NOT NULL,
9 dbuserpass TEXT NOT NULL,
10 requestdate INT NOT NULL,
12 created_by INT NOT NULL,
16 CREATE TABLE prdb_states (
22 CREATE UNIQUE INDEX idx_prdb_dbname ON prdb_dbs (dbname);
24 INSERT INTO prdb_states VALUES ('1', 'Active');
25 INSERT INTO prdb_states VALUES ('2', 'Pending Create');
26 INSERT INTO prdb_states VALUES ('3', 'Pending Delete');
27 INSERT INTO prdb_states VALUES ('4', 'Pending Update');
28 INSERT INTO prdb_states VALUES ('5', 'Failed Create');
29 INSERT INTO prdb_states VALUES ('6', 'Failed Delete');
30 INSERT INTO prdb_states VALUES ('7', 'Failed Update');
32 CREATE TABLE prdb_types (
33 dbtypeid INT PRIMARY KEY,
34 dbservername TEXT NOT NULL,
35 dbsoftware TEXT NOT NULL
38 INSERT INTO prdb_types VALUES ('1','pr-db1','mysql');
40 CREATE TABLE prweb_vhost (
41 vhostid SERIAL PRIMARY KEY,
48 CREATE INDEX idx_vhost_groups ON prweb_vhost (group_id);
50 CREATE UNIQUE INDEX idx_vhost_hostnames ON prweb_vhost(vhost_name);