zadam
7335844ae3
updated DB schmea
2020-08-18 22:37:23 +07:00
zadam
53b39e2e82
many changes related to #1192 :
...
- use CSS contain wherever possible to reduce subtrees of forced reflows
- reduced dependency between note and note_contents updates which will reduce number of updates to components
- optimization of "many rows" querying
2020-08-16 22:57:48 +07:00
zadam
c2789bf355
use relative paths for fonts in steel blue in demo document, closes #1187
2020-08-14 21:04:18 +07:00
zadam
e663d7da1b
updated schema for entity_changes table
2020-08-09 22:44:53 +07:00
zadam
864271d5ef
refactored "sync" table to "entity_changes"
2020-08-02 23:27:48 +07:00
zadam
5ca3e9a0bc
fixed db migrations after merge from stable
2020-08-02 20:44:46 +07:00
zadam
f4a4e746bf
Merge remote-tracking branch 'origin/stable'
...
# Conflicts:
# libraries/ckeditor/ckeditor.js.map
# package.json
# src/routes/api/login.js
# src/routes/api/sync.js
# src/routes/index.js
# src/services/app_info.js
# src/services/sync.js
2020-08-02 20:41:22 +07:00
zadam
3582013a33
import of initial demo document sets sync.isSynced incorrectly to always 0, #1163
2020-07-31 00:07:38 +07:00
zadam
df69b1d8dd
attr detail handles label/relation definition updates
2020-07-18 23:45:28 +07:00
zadam
18749092ff
sql_init/migration fixes
2020-07-02 22:57:17 +07:00
zadam
3e189d5c10
fixes
2020-07-01 23:50:33 +07:00
zadam
5e18e7dc67
html sanitize imported notes, #1137
2020-06-30 23:37:06 +07:00
zadam
22302e8200
attrs WIP
2020-06-21 23:41:51 +07:00
zadam
6ba2e5cf73
add word count widget to the demo document (plus cleanup of external links)
2020-06-14 16:29:29 +07:00
zadam
44d641617e
fix relation map in demo document
2020-04-08 22:09:32 +07:00
zadam
c063f75f48
fix ZIP import of notes with included note
2020-04-06 22:46:11 +07:00
zadam
f8bd6183bf
fix default document
2020-03-29 18:53:32 +07:00
zadam
c4bc53da59
updates to the demo document
2020-03-26 22:22:18 +07:00
zadam
c4e5b35187
changed demo.tar to demo.zip
2020-03-26 17:05:17 +07:00
zadam
f5e27278ab
fix migration script to preserve sync IDs
2020-03-15 11:19:30 +07:00
zadam
da53c1eaa8
updated schema.sql
2020-03-09 21:23:11 +07:00
zadam
73bf2dcb02
added isSynced to sync table to allow forward compatibility with 0.41
2020-03-09 20:56:43 +07:00
zadam
1690248e24
migration script to fix contentLength = -1 in new notes
2020-01-19 09:08:33 +07:00
zadam
1cd2711097
Merge branch 'stable'
2020-01-05 20:02:19 +07:00
zadam
f377a84fa1
hide/show button z-index tweak
2020-01-04 09:21:42 +07:00
zadam
c1d0a1e07b
undelete note WIP
2020-01-03 10:48:36 +07:00
zadam
f3a29b55ba
remove @child 🧒 sorted label from calendar root in demo document since currently @sorted is added automatically in the code, closes #799
2020-01-01 20:58:59 +07:00
zadam
9c4a976342
added some statistic scripts to demo document
2019-12-28 21:52:35 +07:00
zadam
73c8d145fa
tar export fixes + added code block example to the demo document
2019-12-25 11:56:55 +07:00
zadam
a37b9cfc7b
steel blue tweaks in demo document
2019-12-21 15:48:36 +07:00
zadam
76f5736255
update demo document
2019-12-10 23:08:50 +07:00
zadam
7ef2e7769f
added index to source_ids
2019-12-01 14:39:24 +07:00
zadam
d57caee0d3
drop unnecessary indexes
2019-12-01 12:38:07 +07:00
zadam
420be6d8c6
fix demo document relation map and shortcuts before db initialization
2019-11-24 22:42:54 +07:00
zadam
540f9f933a
update demo.tar with correct system links
2019-11-24 14:10:11 +07:00
zadam
ff3f0ee0a0
Merge branch 'stable'
2019-11-23 23:07:07 +07:00
zadam
e4bec265c1
system links (internal, image, relation map) should follow camelCase convention used for other attributes
2019-11-23 20:54:49 +07:00
zadam
c8ba07a4ae
fix migration script in case of not fully consistent database (missing note_contents for note). closes #717
2019-11-23 11:13:57 +07:00
zadam
c5e040c4a4
updated demo document with icon classes
2019-11-16 09:57:19 +07:00
zadam
c49c69f824
fix migration script
2019-11-12 21:32:35 +07:00
zadam
7bd1d8feb4
fix setting isErased after note migration
2019-11-11 23:37:46 +07:00
zadam
4ba7e74b58
fix note revision's isErased initial value after migration
2019-11-11 23:26:46 +07:00
zadam
4cda661c1b
add move to dialog
2019-11-11 22:57:51 +07:00
zadam
9b24ae0600
erasing note revisions
2019-11-09 15:21:14 +07:00
zadam
7c7beb5502
added contentLength to note entity
2019-11-09 09:36:08 +07:00
zadam
894c888d87
including ckeditor mentions plugin for easy linking
2019-11-06 22:58:32 +07:00
zadam
2af86927b0
added flag for the erased notes
2019-11-01 22:09:51 +07:00
zadam
2e58e32112
note revision sync and other fixes
2019-11-01 20:00:56 +07:00
zadam
4e5e3e4675
note revisions changes WIP
2019-11-01 19:21:48 +07:00
zadam
cf53cbf1dd
moving out note revision content into separate table, refactoring, WIP
2019-10-31 21:58:34 +07:00
zadam
b16c2d19b6
duplicate (single) note
2019-10-19 12:36:16 +07:00
zadam
157bd3816d
add hideTabRowForOneTab if missing, fixes #660
2019-10-18 21:04:20 +07:00
zadam
80a6361cf1
update to demo db
2019-10-14 12:11:27 +07:00
zadam
1923bf7dda
added some basic book examples to demo document
2019-10-14 11:15:38 +07:00
zadam
c1e8a4b384
spell check support + small options tabs reorganization
2019-10-06 21:35:26 +07:00
zadam
8d14a0d687
fix incorrect import of relations from tar
2019-10-02 23:22:58 +07:00
zadam
76f3e87790
small fixes
2019-09-09 20:29:07 +07:00
zadam
d3f2b71803
calendar widget setup
2019-09-08 13:08:01 +07:00
zadam
b069436039
added "edited notes on date" widget
2019-09-07 10:11:59 +07:00
zadam
5d80df398b
removed event log
2019-09-02 20:30:28 +07:00
zadam
ae8a2bfb1b
updated demo document based on changes in tar format
2019-09-01 22:43:16 +07:00
zadam
c8a5c71ec2
tweaks to similar notes + missing options init
2019-09-01 11:37:43 +07:00
zadam
7c60080772
basic implementation of "similar notes" widget
2019-09-01 08:58:13 +07:00
zadam
a81b00e130
fix link map zoom after reload and some tweaks to springy
2019-08-30 22:01:49 +07:00
zadam
d4e27c1b76
fixed CSS lazy loading (same file could be loaded multiple times)
2019-08-30 21:22:52 +07:00
zadam
89ed9027da
updated export + image link parsing fix
2019-08-29 23:11:59 +07:00
zadam
10d089240a
updated DB schema and initial options
2019-08-29 22:32:53 +07:00
zadam
c8f59ea547
options UI for selecting support code note MIME types
2019-08-29 21:08:53 +07:00
zadam
f9abea83f3
refactoring of access to options in frontend
2019-08-22 23:31:02 +07:00
zadam
8ab2c924c4
widget ordering WIP
2019-08-22 20:58:43 +07:00
zadam
4b9415a619
widget config WIP
2019-08-21 23:16:13 +07:00
zadam
b818f020a7
option to configure if sidebar should be enabled in new tab
2019-08-19 23:29:42 +07:00
zadam
9888850c22
resizing sidebar in options
2019-08-19 23:02:19 +07:00
zadam
3cb421143f
Link entity migrated to Attribute, WIP
2019-08-19 20:12:00 +07:00
zadam
40cec31099
schema update
2019-05-27 19:34:18 +07:00
zadam
29828f8e8f
fix recent notes (db & sync version increase)
2019-05-21 21:47:28 +07:00
zadam
dd1fc23fe8
work on hash & history
2019-05-14 22:29:47 +07:00
zadam
fab8b77794
configurable hiding of tab row for one tab
2019-05-12 21:45:30 +07:00
zadam
be68391c37
store "openTabs" session
2019-05-10 21:43:40 +07:00
zadam
6aa30a4c74
steel blue theme updated with link color
2019-04-28 21:43:56 +07:00
zadam
1990c9399e
removed FTS5 completely
2019-04-21 12:03:13 +07:00
zadam
1bd769827d
faster opening of the date notes (no animation)
2019-04-14 18:16:15 +07:00
zadam
7e374e795b
fill sync rows to fix sync issues
2019-04-13 10:30:16 +07:00
zadam
925dc258a6
fix menu text color in dark themes
2019-04-01 21:38:21 +07:00
zadam
67553cb40e
fix ordering of note migrations
2019-03-30 22:20:18 +07:00
zadam
7cafbda7cd
migration for inconsistent isProtected status across notes and note_contents
2019-03-30 22:12:18 +07:00
zadam
9a5a085103
Merge branch 'stable'
...
# Conflicts:
# package-lock.json
# src/public/javascripts/services/server.js
# src/services/app_info.js
# src/services/notes.js
2019-03-30 22:11:03 +07:00
zadam
c240fb9896
migration for inconsistent isProtected status across notes and note_contents
2019-03-30 20:09:38 +07:00
zadam
07e9013152
content migration fixes
2019-03-27 21:04:25 +07:00
zadam
29c60581a6
yet another refactoring of working with note's payload/content
2019-03-26 22:24:04 +07:00
zadam
f6413d095c
update schema -> fix creating new database from scratch
2019-03-24 21:06:38 +07:00
zadam
0d0464549f
notes are now created with correct local dates
2019-03-13 22:43:59 +07:00
zadam
f65fefe7b1
migration utc dates
2019-03-11 22:58:44 +07:00
zadam
0a906b5663
updated db schema
2019-03-11 20:36:19 +07:00
zadam
d25a1e3ed9
initial work on note fulltext (schema changes, updating...)
2019-03-10 17:02:23 +07:00
zadam
64974d75d5
added sync fill for note_contents
2019-03-02 19:59:32 +07:00
zadam
3533160bef
fix initial document setup
2019-02-20 23:07:57 +07:00
zadam
f140b77e7c
fix migration script
2019-02-15 21:10:00 +07:00
zadam
22228de63b
sync changes for note content
2019-02-15 00:15:09 +07:00
zadam
4a093000be
note content refactoring, WIP
2019-02-08 21:01:26 +07:00
zadam
c487a95bc7
note content refactoring, WIP
2019-02-06 21:29:23 +07:00
zadam
8884177d9f
split out note's content into separate entity, WIP
2019-02-06 20:19:25 +07:00
zadam
afd5f4823f
added Steel Blue theme to demo document
2019-02-03 15:39:27 +07:00
azivner
0ff250fe15
font sizes were not created for new documents - fix plus migration for existing ones
2019-01-22 20:34:45 +07:00
azivner
24d02d9cf5
fix in task manager script to not error out so much on deletion
2019-01-21 22:05:37 +07:00
azivner
f1c3278874
store font size in options #326
2019-01-13 21:27:32 +07:00
azivner
b607857409
fix weight tracker demo to use relations instead of hardcoded noteId, fixes #329
2019-01-13 12:21:17 +07:00
azivner
cc27f16088
store iv directly in the respective columns
2019-01-11 23:04:51 +07:00
azivner
6fbf28b30d
hoisting notes WIP
2018-12-11 21:53:56 +07:00
azivner
ba7c8e77e5
add support for number precision in promoted attributes, closes #245
2018-11-30 17:36:41 +07:00
azivner
2fbd16a0e3
updated demo export according to latest format changes
2018-11-26 23:50:43 +07:00
azivner
551e1255ff
export WIP + some unrelated changes
2018-11-25 10:26:45 +07:00
azivner
3608857f25
small fix to demo export
2018-11-19 21:09:59 +07:00
azivner
30249a353e
renamed "mirror" relation to "inverse" relation
2018-11-19 12:07:33 +07:00
azivner
eb9bae9010
updated relation map in demo document
2018-11-19 11:47:40 +07:00
azivner
3db2f6784d
fix DB migration and consistency issues
2018-11-18 10:20:06 +07:00
azivner
90eb1b53fb
update of demo document, using relation map for "family tree" demo
2018-11-16 23:29:38 +07:00
azivner
94565e3ec0
now using .tar export to initialize DB instead of direct DB dumps
2018-11-16 14:36:50 +07:00
azivner
46c7901e1f
fix migration script
2018-11-15 22:24:30 +07:00
azivner
39b3c91abf
image notes can't be updated + minor visual tweaks
2018-11-15 14:33:02 +07:00
azivner
cfce744338
method name refactoring
2018-11-14 17:26:07 +07:00
azivner
afcbfcfa03
cleanup obsolete image code
2018-11-08 11:14:13 +07:00
azivner
d7afbe4059
saving image
2018-11-08 11:08:16 +07:00
azivner
d0d2a7fe47
store images in notes, basic structure
2018-11-08 10:11:00 +07:00
azivner
0c007566ad
fixes for invalid operations on root note
2018-10-21 22:42:20 +07:00
azivner
947e875b6c
added today script into demo document
2018-09-11 00:02:25 +07:00
azivner
c76329e671
increased default min pane width to 350px
2018-09-06 12:02:42 +07:00
azivner
ff086569f2
saving options for left pane sizing
2018-09-06 11:17:30 +07:00
azivner
f2712e92bb
minor demo db updates after change to paragraph layout
2018-09-03 20:14:45 +07:00
azivner
10ff504528
demo document update
2018-09-01 13:57:03 +07:00
azivner
cfa4cc4931
fix undefined Sync section in the config file
2018-08-30 23:28:38 +07:00
azivner
be22d3cb4c
new server package build without using pkg (fixes images stuff)
2018-08-30 21:57:14 +07:00
azivner
a2d7be445f
demo db update
2018-08-30 00:42:02 +07:00
azivner
561b514b84
refactored promoted attribute change handler
2018-08-29 22:28:58 +07:00
azivner
bc61f17a3a
changes in initial document
2018-08-29 21:36:42 +07:00
azivner
7c3d46d22a
added jsdocs generated pages
2018-08-29 20:44:35 +07:00
azivner
b65a6c97a1
added missing attributes dump
2018-08-28 23:39:12 +07:00
azivner
dbca7bfb43
dump script + updated SQL dumps
2018-08-28 23:36:28 +07:00
azivner
71e687ad8e
child: prefix now copies attributes on new note creation
2018-08-21 13:49:45 +07:00
azivner
35ef3c8470
fix migration
2018-08-14 16:09:30 +07:00
azivner
36dc802d16
updated schema.sql
2018-08-13 07:57:23 +07:00
azivner
f1240c26bf
more cleanup of labels and relations from backend, dropping tables from db
2018-08-07 13:44:51 +07:00
azivner
61987e46f7
work in progress on attributes UI - unification of labels and relations now mostly works
2018-08-03 13:06:56 +07:00
azivner
097114c0f2
basic entities for attributes (unification of labels and relations)
2018-08-02 22:48:21 +07:00
azivner
d3d49923b1
changed backup to simple scheme with one daily, one weekly and one monthly backup, fixes #15
2018-07-30 16:40:50 +07:00
azivner
2eb1a9705f
it's now possible to mark relation as inheritable (previously this was hardcoded for specific relation names)
2018-07-29 20:33:42 +07:00
azivner
986eace1be
schema update with relations
2018-07-29 11:47:46 +07:00
azivner
8a95afd756
#126 , added skeleton of note relations, copied from similar concept of labels
2018-07-27 10:52:48 +07:00
azivner
7e4d70259f
soft-deleting note will delete its content and all the revisions content, fixes #132
2018-07-26 09:08:51 +07:00
azivner
37ab7b4641
#98 , sync to server now works as well + a lot of related changes
2018-07-24 20:35:03 +07:00
azivner
013714cb5c
#98 , new option "initialized" which indicates if setup has been finished
2018-07-24 08:12:36 +07:00
azivner
1fe7c62f5a
#98 , sync setup now doesn't copy the whole DB file, but sets up minimal database and starts off sync
2018-07-23 21:15:32 +07:00
azivner
e7460ca3a9
#98 , sync is now configured in the options
2018-07-22 22:21:16 +07:00
azivner
3d2ef6be01
remove optionId, closes #117
2018-06-13 19:10:28 +07:00
azivner
89a5cab98f
added too options new tab appearance with possibility to change theme (white, black, dark) and zoom factor
2018-06-08 23:18:53 +07:00
azivner
385144451b
renamed hideInAutocomplete label to archived
2018-06-07 19:26:28 +07:00
azivner
0f8f707acd
persisting zoom setting in electron, fixes #112
2018-06-02 13:02:20 +07:00
azivner
fc6669d254
initialization and schema fixes, closes #111
2018-06-01 22:26:37 +07:00
azivner
cab54a458f
unifying surrogate keys for event log and options, fixes #103
2018-05-26 23:25:09 +07:00
azivner
40a32e6826
render notes can be edited and can contain HTML markup
2018-05-26 19:27:47 +07:00
azivner
03bf33630e
unify audit fields, fixes #102
2018-05-26 12:38:25 +07:00
azivner
49a53f7a45
added hash columns for faster sync check calculation
2018-05-22 00:15:54 +07:00
azivner
9fa6c0918c
add index for note's type + some fixes
2018-05-21 20:12:46 +07:00
azivner
1687ed7e0b
load only expanded tree with the rest being lazy loaded, WIP
2018-04-16 16:26:47 +07:00
azivner
a4eafb934f
non null note title and content in the DB schema, allow saving non-valid JSON notes, children overview style changes
2018-04-11 00:10:11 +07:00
azivner
9720868f5a
added type and mime to note revisions
2018-04-08 11:57:14 +07:00
azivner
2cdcb3af12
camel casing and fixes
2018-04-04 23:04:31 +07:00
azivner
cf7a336ac2
camel case for reddit labels and run values
2018-04-04 22:29:11 +07:00
azivner
a4e64350e9
fixed schema, initial setup
2018-04-02 22:33:54 +07:00
azivner
6f567e3e10
camelCase builtin labels
2018-04-02 21:56:55 +07:00
azivner
c6c76ba360
option names now follow camelCase
2018-04-02 21:47:46 +07:00
azivner
47eb1e3e02
refactored all mentions of "history" to "revision"
2018-03-25 20:52:38 +07:00
azivner
95bb2cf0bb
renaming attributes to labels, fixes #79
2018-03-24 22:02:26 +07:00
azivner
4c472ce78b
renaming note_tree to branch
2018-03-24 21:39:15 +07:00
azivner
b3209a9bbf
split javascript mime type into frontend and backend
2018-03-05 22:08:45 +07:00
azivner
3033f7cc08
attribute value is now non-null, fixes #52
2018-02-16 19:07:59 +07:00
azivner
2e8eeda5ab
new attribute "hide_in_autocomplete", fixes #16
2018-02-13 22:30:33 +07:00
azivner
9910aebf45
fix schema.sql
2018-02-11 22:06:12 +07:00
azivner
7b77e40514
added support for trilium-sender
2018-02-11 00:18:59 +07:00
azivner
c76e4faf5d
added attributes sorting
2018-02-10 08:37:14 +07:00
azivner
e011b9ae63
deleting attributes, closes #34
2018-02-06 23:09:19 +07:00
azivner
7c74c77a2c
allow duplicated attribute per note (in effect attributes can be multi-valued). Closes #33
2018-02-06 21:18:09 +07:00
azivner
31c32ff42c
fixes when generating new DB
2018-01-31 23:36:39 +07:00
azivner
3f7b54425d
sync fixes
2018-01-30 23:23:19 +07:00
azivner
b44412bc32
renaming of sql methods to fit getRows/getEntities model
2018-01-29 17:41:59 +07:00
azivner
9a0c2b6bcd
moved migration directory to db, fix sync records
2018-01-28 21:00:54 +07:00
azivner
75878c80a8
migration script to camel case
2018-01-28 20:52:05 +07:00
azivner
11e173aeac
small changes to table names (notes_image => note_images etc.)
2018-01-28 19:38:05 +07:00
azivner
3b1f928fbc
renamed db columns to camelCase
2018-01-28 19:30:14 +07:00
azivner
9760eb71d3
updated schema
2018-01-21 23:44:42 +07:00
azivner
d30a57d388
delete now works with multi-select
2018-01-14 21:39:21 +07:00
azivner
0575924cf1
added is_synced to options to better differentiate between synced and not synced options
2018-01-11 22:45:25 +07:00
azivner
8fe6a9353a
added dialog and read only view of attributes
2018-01-11 00:01:16 +07:00
azivner
77278fe09e
added small image to demo document
2018-01-07 23:52:32 +07:00
azivner
31b4186e17
optional cleanup of unused images
2018-01-07 14:07:59 +07:00
azivner
0e8285a7e4
updated schema with image tables
2018-01-07 10:35:24 +07:00
azivner
244a4562b1
not unique key between parent_note_id and note_id in schema
2018-01-03 22:15:06 +07:00
azivner
548ecd4171
removed unique index again - from now on the invariant is that there's unique undeleted relationship between note and parent note
2018-01-03 21:29:13 +07:00
azivner
96a44a9a0c
added some showcase formatting to the welcome page in the demo database
2018-01-02 22:14:53 +07:00
azivner
53ee1fa5ed
note_id - parent_note_id index needs to be unique
2018-01-02 19:20:42 +07:00
azivner
5acf84aece
Calling project "Trilium Notes" in some places as it is more self explanatory
2017-12-26 12:55:40 +07:00
azivner
cf8334607e
added demo document SQL scripts
2017-12-23 13:16:18 +07:00