sql.initial-mysql.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of platform Show documentation

A standard set of utilities that makes it easy to build systems that need users, billing, etc giving the usefulness of a PaaS with the control of a local application

There is a newer version: 0.5.11

Show newest version

create table profound_session (
	session_key INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
    user_key INTEGER NOT NULL,
    token CHAR(64) NOT NULL,
    INDEX p_sessions_token_idx(token),
    INDEX p_sessions_user_idx(user_key)
) ENGINE = innodb CHARACTER SET utf8 COLLATE utf8_general_ci;


create table profound_user_email (
    user_key INTEGER NOT NULL,
    email_address VARCHAR(255) NOT NULL,
    validated_on DATETIME,
    PRIMARY KEY (user_key, email_address),
	INDEX p_user_email_email_idx(email_address)
) ENGINE = innodb CHARACTER SET utf8 COLLATE utf8_general_ci;


create table profound_user_role (
    user_key INTEGER NOT NULL,
    role VARCHAR(255) NOT NULL,
    PRIMARY KEY (user_key, role)
) ENGINE = innodb CHARACTER SET utf8 COLLATE utf8_general_ci;


create table profound_user (
	user_key INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
    created_on DATETIME,
    first_name VARCHAR(255),
    last_name VARCHAR(255),
    name VARCHAR(255),
    organization VARCHAR(255),
    correspondence_email_address VARCHAR(255),
    facebook_id VARCHAR(255),
    google_id VARCHAR(255),
    twitter_id INTEGER,
    linkedin_id VARCHAR(255),
    intercom_id VARCHAR(255),
    encrypted_password VARCHAR(255),
    last_seen DATETIME,
    INDEX p_user_facebook(facebook_id),
    INDEX p_user_google(google_id),
    INDEX p_user_twitter(twitter_id),
    INDEX p_user_intercom(intercom_id),
    INDEX p_user_linkedin(linkedin_id)
) ENGINE = innodb CHARACTER SET utf8 COLLATE utf8_general_ci;

INSERT INTO profound_user VALUES ( 1, CURRENT_TIMESTAMP, 'Protea', 'Administration', NULL, 'Protea Corporate Consulting', '[email protected]', NULL, NULL, NULL, NULL, NULL, 'BNElL75Z/m9w34q+rVCqpEye4KciRhSB', null);
insert into template_user values ( 1, null, true );
INSERT INTO profound_user_role VALUES ( 1, 'ADMIN' );