Attachment 138039 Details for Bug 114089 – Example SQL script

Example SQL script

persons.sql (text/plain), 1.18 KB, created by Georgi D. Sotirov on 2017-11-28 13:05:00 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Georgi D. Sotirov

Created: 2017-11-28 13:05:00 UTC

Size: 1.18 KB

patch

obsolete

>CREATE SCHEMA hr;
>USE hr;
>
>CREATE TABLE `persons` (
>  `id` int(11) NOT NULL AUTO_INCREMENT,
>  `first_name` varchar(64) NOT NULL,
>  `middle_name` varchar(64) DEFAULT NULL,
>  `maiden_name` varchar(32) DEFAULT NULL,
>  `last_name` varchar(64) NOT NULL,
>  `sex` enum('Male','Female') NOT NULL,
>  `birth_date` date DEFAULT NULL,
>  `death_date` date DEFAULT NULL,
>  `picture` blob,
>  `martial_status` enum('Single','Married','Cohabitation','Divorced','Widowed','Separated') DEFAULT NULL,
>  `children` decimal(2,0) DEFAULT NULL,
>  `personal_id` varchar(32) DEFAULT NULL,
>  `linkedin_profile` varchar(256) DEFAULT NULL COMMENT 'URL to LinkedIn profile',
>  `short_bio` text,
>  `cv_doc` longblob,
>  PRIMARY KEY (`id`),
>  UNIQUE KEY `idx_person_names` (`first_name`,`middle_name`,`last_name`)
>) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
>
>INSERT INTO persons (first_name, last_name, sex, birth_date, martial_status) VALUES ('John', 'Doe', 'Male'  , '1970-01-01', 'Single');
>INSERT INTO persons (first_name, last_name, sex, birth_date, martial_status) VALUES ('Jane', 'Doe', 'Female', '1970-01-01', 'Single');
>
>CREATE USER 'hr_user'@'%' IDENTIFIED BY 'hr_password';
>GRANT SELECT, INSERT, UPDATE, DELETE ON hr.* TO 'hr_user'@'%';
>

Actions: View

Attachments on bug 114089: 138039 | 138040