Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Making Stick Notes working with SQLite
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  1 message - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
admin gnucash  
View profile  
 More options Nov 18 2010, 5:11 pm
From: admin gnucash <admin.gnuc...@gmail.com>
Date: Thu, 18 Nov 2010 14:11:51 -0800 (PST)
Local: Thurs, Nov 18 2010 5:11 pm
Subject: Making Stick Notes working with SQLite
Hello.

At the moment "sticky_notes" works only with MySQL installation of
Roundcube.

People Like me that use however Roundcube with SQLIte will face the
Problem that Sticky Notes dont save any Notes as the SQLite Database
stuff is Missing.

So for thos that have Roundcube running with SQLite and want also have
Sticky Notes all you need to do is openning a shell a do the following

cd  /to/your/SQLite.DataBase
sudo sqlite SQLite.DataBase

sqlite>  CREATE TABLE "notes" ("id" INTEGER PRIMARY KEY NOT NULL,
"nid" INTEGER NOT NULL, "width" INTEGER DEFAULT '0', "height" INTEGER
DEFAULT '0', "pos_x" INTEGER DEFAULT '0', "pos_y" INTEGER DEFAULT '0',
"text" TEXT, "user_id" INTEGER unsigned NOT NULL, "timestamp"
TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', FOREIGN KEY(user_id)
REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE );

sqlite> CREATE INDEX idx_notes_userid ON notes (user_id);

sqlite> .quit;

After this Your Sticky Notes will works the same Way as with MySQL.

Enjoy it.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »