Skip to content

sharing note database notes not exist #1

@rzroth

Description

@rzroth

Table notes_app.shared_notes for note sharing not in config/schema.sql

Looks to be:
models/Note.php:147 $query = "INSERT INTO
shared_notes (note_id, user_id, share_token) VALUES (:note_id, :user_id, :share_token)";

Creating that table (below) , causes entries to be added BUT still gets errors
Does not popup sharing url like web site does.
Also Have not tried with 2nd user trying to get note yet,

Might be:
CREATE TABLE IF NOT EXISTS shared_notes (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
note_id INT NOT NULL,
share_token TEXT NOT NULL.

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE

);

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions