/*Meta database for all clients*/

use schoolms_meta;

/*drop table ut_domain_requests;*/
drop table ut_domain_based;
drop table ut_system;
drop database schoolms_meta;

create database schoolms_meta;
use schoolms_meta;

/*System wide settings*/
create table ut_system (
    id INT NOT NULL AUTO_INCREMENT,
    support_num VARCHAR(128),
    PRIMARY KEY(id)
);

insert into ut_system values(NULL, '+92 336 2358945');

/*Domain look up*/
create table ut_domain_based (
    id  INT NOT NULL AUTO_INCREMENT,
    domain VARCHAR(1024),
    static_domain VARCHAR(1024),
    logo_path VARCHAR(255),
    contact_num VARCHAR(128),
    address VARCHAR(1024),
    PRIMARY KEY(id)
);

insert into ut_domain_based values(NULL,'schoolms','http://static.schoolms/','schoolms-default-logo.gif','0334 3810 318','68/127 K-Area Korangi-5 Karachi');
insert into ut_domain_based values(NULL,'www.ailyaschool.edu.pk','http://static.ailyaschool.edu.pk/','ailya-school-logo.gif','0334 3810 318','68/127 K-Area Korangi-5 Karachi');

create table ut_gmap (
	fk_id INT NOT NULL,
	g_key VARCHAR(255),
	lat float,
	lng float,
	FOREIGN KEY(fk_id) REFERENCES ut_domain_based(id) ON DELETE CASCADE
); 

insert into ut_gmap values(2, 'AIzaSyDKale_XXJ7HmMWsDF4jmoOauj0z57hGbY', 24.867413, 67.032624);

/*Request logging*/
/* not required drupal does the logging */
/*create table ut_domain_requests (
    id INT NOT NULL AUTO_INCREMENT,
    domain_id INT NOT NULL,
    ts DATETIME,
    client_ip VARCHAR(32),
    user_agent_str VARCHAR(128),
    resource VARCHAR(255),
    query_str VARCHAR(255),
    PRIMARY KEY (id),
    FOREIGN KEY (domain_id) REFERENCES ut_domain_based(id)
        ON DELETE CASCADE
    );*/