@riddik200890
permitions (
id int(11) NOT NULL AUTO_INCREMENT,
user_id int(11) DEFAULT NULL,
commune_id int(11) DEFAULT NULL,
sponsor_id int(11) DEFAULT NULL,
cluster_id int(11) DEFAULT NULL,
role_id int(11) DEFAULT NULL,
PRIMARY KEY (id),
CREATE TABLE .news (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(255) NOT NULL,
body text DEFAULT NULL,
owner_id int(11) DEFAULT NULL,
permition_id int(11) DEFAULT NULL,
created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id),
CONSTRAINT foreign-key-owner
FOREIGN KEY (owner_id)
REFERENCES i-trust
.User (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT foreign-key-permition
FOREIGN KEY (permition_id)
REFERENCES i-trust
.permitions (id) ON DELETE RESTRICT ON UPDATE RESTRICT
)
CREATE TABLE comment (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(255) NOT NULL,
body text DEFAULT NULL,
owner_id int(11) DEFAULT NULL,
permition_id int(11) DEFAULT NULL,
created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id),
CONSTRAINT foreign-key-owner
FOREIGN KEY (owner_id)
REFERENCES i-trust
.User (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT foreign-key-permition
FOREIGN KEY (permition_id)
REFERENCES i-trust
.permitions (id) ON DELETE RESTRICT ON UPDATE RESTRICT
)
CREATE TABLE permitions_test (
id int(11) NOT NULL AUTO_INCREMENT,
type_model varchar(255) NOT NULL,
relations_id text DEFAULT NULL,
permition_id int(11) DEFAULT NULL,
created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id),
REFERENCES i-trust
.User (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT foreign-key-permition
FOREIGN KEY (permition_id)
REFERENCES i-trust
.permitions (id) ON DELETE RESTRICT ON UPDATE RESTRICT
)
сори)) немогу найти на sql online
sudo -u www-data php bin/console и т.д.
Can any one help me with this algorithm to identify the failing case? I have passed almost 10 out 14 test cases though there are 4 still failing.
Question: A start-up owner is looking to meet new investors to get some funds for his company. Each investor has a tight schedule that the owner has to respect. Given the schedules of the days investors are available, determine how many meetings the owner can schedule. Note that the owner can only have one meeting per day.The schedules consists of two integer arrays, firstDay and lastDay. Each element in the array firstDay represents the first day an investor is available, and each element in lastDay represents the last day an investor is available, both inclusive.
Example Input:
STDIN Function ------ -------- 5 firstDay[] size n = 5 1 → firstDay = [1, 2, 1, 2, 2] 2 1 2 2 5 → lastDay[] size n = 5 3 → lastDay = [3, 2, 1, 3, 3]
Output
3