From a463aaa612a4bd32d2122ca1071ff552cb98c310 Mon Sep 17 00:00:00 2001 From: Banana Date: Thu, 5 Jan 2017 09:17:11 +0100 Subject: [PATCH] prepare for release 2.0alpha --- AUTHORS | 2 +- documentation/features.txt | 8 ++++++ .../{installation => }/insipid-edit-me.sql | 4 ++- documentation/installation.txt | 27 ++++++++++++++++++- documentation/installation/README | 8 ------ documentation/requirements.txt | 3 +++ 6 files changed, 41 insertions(+), 11 deletions(-) create mode 100644 documentation/features.txt rename documentation/{installation => }/insipid-edit-me.sql (97%) delete mode 100644 documentation/installation/README create mode 100644 documentation/requirements.txt diff --git a/AUTHORS b/AUTHORS index f3417de..07cd851 100755 --- a/AUTHORS +++ b/AUTHORS @@ -8,7 +8,7 @@ creator: Luke Reeves Contributors: -jumpin.banana https://github.com/jumpin-banana +jumpin.banana https://www.bananas-playground.net Manuel de la Torre Artur Marques Danny Miles diff --git a/documentation/features.txt b/documentation/features.txt new file mode 100644 index 0000000..f82acf7 --- /dev/null +++ b/documentation/features.txt @@ -0,0 +1,8 @@ +Insipid is a web-based bookmark manager similar to the Delicious service. + +It lets you manage and host your own bookmarks. No talking to other servervices or agencies. +Your data is your data. + +Bookmarks are put into categories and should have tags. + +New links will be checked and tried to get as much as possible information automatically. \ No newline at end of file diff --git a/documentation/installation/insipid-edit-me.sql b/documentation/insipid-edit-me.sql similarity index 97% rename from documentation/installation/insipid-edit-me.sql rename to documentation/insipid-edit-me.sql index 3c156c8..ce567e4 100644 --- a/documentation/installation/insipid-edit-me.sql +++ b/documentation/insipid-edit-me.sql @@ -67,7 +67,8 @@ CREATE TABLE `#REPLACEME#_link` ( `description` varchar(255) COLLATE utf8mb4_bin NOT NULL, `title` varchar(255) COLLATE utf8mb4_bin NOT NULL, `image` varchar(255) COLLATE utf8mb4_bin NOT NULL, - `hash` char(32) COLLATE utf8mb4_bin NOT NULL + `hash` char(32) COLLATE utf8mb4_bin NOT NULL, + `search` text COLLATE utf8mb4_bin NOT NULL, ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT; -- -------------------------------------------------------- @@ -124,6 +125,7 @@ ALTER TABLE `#REPLACEME#_categoryrelation` -- ALTER TABLE `#REPLACEME#_link` ADD PRIMARY KEY (`id`), + FULLTEXT KEY `search` (`search`), ADD UNIQUE KEY `hash` (`hash`); -- diff --git a/documentation/installation.txt b/documentation/installation.txt index 360ff49..b0d480a 100644 --- a/documentation/installation.txt +++ b/documentation/installation.txt @@ -1 +1,26 @@ -See the installation folder. \ No newline at end of file +1. +Check the requirements first. + +2. +Read this first!! + +3. +Unpack the archive + +4. +Modify webroot/config.php + +5. +Copy and modify documentation/insipid-edit-me.sql and replace the placeholder. +Open the file and make a search and replace: + +search for: `#REPLACEME# +replace with: `tableprefix + +The value tableprefix has to match with the value for DB_PREFIX in config.php + +6. +Import the sql file into your MySQL database + +7. +Copy the content of the webroot folder into your webserver folder \ No newline at end of file diff --git a/documentation/installation/README b/documentation/installation/README deleted file mode 100644 index c78ac88..0000000 --- a/documentation/installation/README +++ /dev/null @@ -1,8 +0,0 @@ -The inspid-edit-me.sql NEEDS to be edited. -Open the file and make a search and replace: - -search for: `#REPLACEME# -replace with: `tableprefix - -The value tableprefix has to match with the value for DB_PREFIX in config.php - diff --git a/documentation/requirements.txt b/documentation/requirements.txt new file mode 100644 index 0000000..7476b11 --- /dev/null +++ b/documentation/requirements.txt @@ -0,0 +1,3 @@ +Apache (2 and up) with PHP extension +PHP (5 and up) with MySQL extension -> mysqli; curl enabled +MySQL database 5.6.x and up \ No newline at end of file -- 2.39.5