Commit Graph

411 Commits

Author SHA1 Message Date
Uwe Steinmann
3379a2510c take out reconnect code
not needed anymore
2018-04-05 12:04:07 +02:00
Uwe Steinmann
9ba070da7c Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2018-04-05 12:02:20 +02:00
Uwe Steinmann
887bcba49d Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2018-04-05 12:02:07 +02:00
Uwe Steinmann
bde55c9875 Merge branch 'seeddms-4.3.x' into seeddms-5.0.x 2018-04-05 12:01:54 +02:00
Uwe Steinmann
1652d9a237 fetch all records from tblVersion
if not, the database will be locked when e.g. droping a table
2018-04-05 11:58:25 +02:00
Uwe Steinmann
d47f4c5ca9 reopen database after COMMIT 2018-04-05 11:24:23 +02:00
Uwe Steinmann
52f58727ca add sql statements for scheduler 2018-04-04 15:29:32 +02:00
Uwe Steinmann
6211014896 new version 6.0.6 2018-03-20 10:09:23 +01:00
Uwe Steinmann
dffdc46568 Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2018-03-20 07:22:23 +01:00
Uwe Steinmann
4666112389 set _backupDir to _contentDir/backup 2018-03-14 10:15:48 +01:00
Uwe Steinmann
e3664780e9 started new version 6.0.5 2018-02-27 07:42:11 +01:00
Uwe Steinmann
03b3bfa4e4 use upper case for sql keywords 2018-02-14 21:50:59 +01:00
Uwe Steinmann
ffbc685752 add missing indexes 2018-02-14 21:49:37 +01:00
Uwe Steinmann
91b163a825 fix typo in index name 2018-02-14 10:45:31 +01:00
Uwe Steinmann
aa4804cf56 add missing keys 2018-02-14 10:45:14 +01:00
Uwe Steinmann
5d51f18c5b Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2018-02-08 14:26:36 +01:00
Uwe Steinmann
fe8e6f5a24 remove various spaces 2018-02-08 14:09:51 +01:00
Uwe Steinmann
7e0b1b6907 start new version 6.0.4 2018-02-05 15:19:59 +01:00
Uwe Steinmann
18191000ea add indexes on Log tables 2018-01-31 20:04:14 +01:00
Uwe Steinmann
3244f20dcc Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2018-01-03 09:41:03 +01:00
Uwe Steinmann
5ee7110597 started new version 5.1.6 2018-01-03 09:29:34 +01:00
Uwe Steinmann
ac09ee3773 new version 6.0.2 2017-12-18 14:43:22 +01:00
Uwe Steinmann
10cb3e1cb3 add various indexes 2017-12-18 08:57:38 +01:00
Uwe Steinmann
4410868874 started new version 5.1.5 2017-11-07 06:43:25 +01:00
Uwe Steinmann
4c5dc52fa0 Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2017-09-05 09:35:23 +02:00
Uwe Steinmann
4ba5db88e9 Merge branch 'seeddms-4.3.x' into seeddms-5.0.x 2017-09-05 09:32:03 +02:00
Uwe Steinmann
45d0c2618f start new version 4.3.37 2017-09-05 09:27:55 +02:00
Uwe Steinmann
2e26504ae7 Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2017-08-22 06:22:28 +02:00
Uwe Steinmann
c68c8b5e52 Merge branch 'seeddms-4.3.x' into seeddms-5.0.x 2017-08-22 06:22:16 +02:00
Uwe Steinmann
79869ff0cf minor fix when dropping a key 2017-08-22 06:22:05 +02:00
Uwe Steinmann
0b8666629b minor fix when dropping a key 2017-08-22 06:20:38 +02:00
Uwe Steinmann
9fe0a39321 Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2017-08-01 11:33:35 +02:00
Uwe Steinmann
00a91b621c Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2017-08-01 10:30:22 +02:00
Uwe Steinmann
5e640ad42b Merge branch 'seeddms-4.3.x' into seeddms-5.0.x 2017-08-01 10:30:09 +02:00
Uwe Steinmann
64e75e8064 correct rootDir if not set propperly, set contentDir below rootDir 2017-08-01 10:22:42 +02:00
Uwe Steinmann
a0651239dd Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2017-07-13 18:03:15 +02:00
Uwe Steinmann
e029e8e55a Merge branch 'seeddms-4.3.x' into seeddms-5.0.x 2017-07-13 17:56:31 +02:00
Uwe Steinmann
b43200703b start new version 4.3.36 2017-07-11 18:12:31 +02:00
Uwe Steinmann
3cc572a1cd Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2017-05-02 06:47:42 +02:00
Uwe Steinmann
b57e91e675 add warning for sqlite which cannot put table mods into transaction 2017-04-28 13:10:25 +02:00
Uwe Steinmann
6a7e23375c Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2017-03-23 18:08:23 +01:00
Uwe Steinmann
a001d32854 Merge branch 'seeddms-4.3.x' into seeddms-5.0.x 2017-03-23 17:43:39 +01:00
Uwe Steinmann
6bb6662de4 start new version 4.3.35 2017-03-23 15:39:18 +01:00
Uwe Steinmann
c18f09d344 start new version 6.0.1 2017-03-23 15:22:55 +01:00
Uwe Steinmann
470e946ec2 Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2017-03-23 15:19:53 +01:00
Uwe Steinmann
a799e091fb drop tables which has been created temporarily
if they are not droped, there foreign key constraints are still
effective
2017-03-23 08:29:43 +01:00
Uwe Steinmann
509921d6d8 remove duplicate adding of new fields 2017-03-22 20:53:25 +01:00
Uwe Steinmann
3ac9bcafc7 Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2017-03-09 07:16:24 +01:00
Uwe Steinmann
3b00db6058 add missing files to tblDocumentFiles 2017-03-09 07:15:27 +01:00
Uwe Steinmann
99f0503a65 use upper case for sql reservered words 2017-03-09 07:14:54 +01:00
Uwe Steinmann
6e9b840e45 Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2017-02-28 17:06:58 +01:00
Uwe Steinmann
5bbce8ffee Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2017-02-28 07:31:26 +01:00
Uwe Steinmann
c73dc49a59 Merge branch 'seeddms-4.3.x' into seeddms-5.0.x 2017-02-28 07:15:01 +01:00
Uwe Steinmann
9f042ad037 fix output of errors 2017-02-28 07:14:46 +01:00
Uwe Steinmann
5bca4770d1 start new version 5.0.11 2017-02-28 07:09:30 +01:00
Uwe Steinmann
35071d40bc fix check for existing tables for pgsql 2017-02-28 07:04:29 +01:00
Uwe Steinmann
c3fea8b8bf new version 4.3.34 2017-02-28 06:39:32 +01:00
Uwe Steinmann
eab6552788 start new version 5.1.1 2017-02-28 06:35:36 +01:00
Uwe Steinmann
f67483a9a7 use unsigned for version 2017-02-27 18:16:27 +01:00
Uwe Steinmann
fbf800d0ee use tinyint and smallint for public and version tblDocumentFiles 2017-02-27 18:13:17 +01:00
Uwe Steinmann
2acee8d335 change sequence of field in tblDocumentFiles 2017-02-27 18:12:43 +01:00
Uwe Steinmann
6b16ac5411 Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2017-02-27 18:08:50 +01:00
Uwe Steinmann
72e45f3320 make 'default' to 'DEFAULT' 2017-02-27 18:07:30 +01:00
Uwe Steinmann
35594e23f9 Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2017-02-27 18:04:04 +01:00
Uwe Steinmann
d36c982634 Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2017-02-27 17:52:09 +01:00
Uwe Steinmann
1ff7367f8b Merge branch 'seeddms-4.3.x' into seeddms-5.0.x 2017-02-27 17:46:41 +01:00
Uwe Steinmann
9550a60891 lots of minor formating and explicitly setting default values
makes it easier to compare a dump with the desired schema
2017-02-27 17:44:36 +01:00
Uwe Steinmann
aaa5b4ace3 remove spaces at end of line 2017-02-27 17:06:52 +01:00
Uwe Steinmann
473118b7bb new version 4.3.33 2017-02-22 11:31:59 +01:00
Uwe Steinmann
f6786406ef Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2017-02-21 07:31:33 +01:00
Uwe Steinmann
4a86288c66 add support for postgresql 2017-02-21 07:30:14 +01:00
Uwe Steinmann
6006dd3944 fix all sql errors 2017-02-21 07:23:02 +01:00
Uwe Steinmann
9aadb7f471 fix merge errors 2017-02-21 07:04:49 +01:00
Uwe Steinmann
4b1b702fc5 add update for postgresql 2017-02-21 06:54:53 +01:00
Uwe Steinmann
63920fdce8 set ENGINE for tblUserSubstitutes 2017-02-21 06:54:06 +01:00
Uwe Steinmann
08e9f14e9d fix merge error 2017-02-21 06:53:43 +01:00
Uwe Steinmann
6b8b099339 set propper version in tblVersion 2017-02-21 06:34:22 +01:00
Uwe Steinmann
f440f7b0ab set initial version in database to 5.1.0 2017-02-20 20:10:19 +01:00
Uwe Steinmann
09ef3a86ba new version 5.0.10 2017-02-20 17:43:51 +01:00
Uwe Steinmann
fa5721c2cb Merge branch 'seeddms-6.0.x-postgres' into seeddms-6.0.x 2017-02-20 17:38:35 +01:00
Uwe Steinmann
4c794381e6 Merge branch 'seeddms-5.1.x' into seeddms-6.0.x 2017-02-20 17:34:43 +01:00
Uwe Steinmann
d7403d3745 set sequence after insert 2017-02-20 17:11:37 +01:00
Uwe Steinmann
8988bc0098 make mimeType varchar(100) in tblDocumentContents and tblDocumentFiles 2017-02-20 17:11:37 +01:00
Uwe Steinmann
b1bd666386 update to 5.1.x 2017-02-20 17:11:37 +01:00
Uwe Steinmann
e0f7c16a10 add database layout for postgres 2017-02-20 17:11:37 +01:00
Uwe Steinmann
e1fdfdbef6 set version to 6.0.0 2017-02-20 17:10:47 +01:00
Uwe Steinmann
97c967cc9a add new columns public and version to tblDocumentFiles 2017-02-20 15:49:57 +01:00
Uwe Steinmann
ef46f612cb add columns version and public to tblDocumentFiles 2017-02-20 15:41:44 +01:00
Uwe Steinmann
52deebbf6e Merge branch 'seeddms-5.0.x-attachment' into seeddms-5.1.x 2017-02-20 15:37:44 +01:00
Uwe Steinmann
675648ef20 add changeѕ to database tables 2017-02-20 15:33:15 +01:00
Uwe Steinmann
8996c14a12 sync with innodb 2017-02-20 14:56:25 +01:00
Uwe Steinmann
3d97644dbf change order of operation to prevent 'table locked' error 2017-02-20 14:52:07 +01:00
Uwe Steinmann
24f63bb40d add notes on update 2017-02-20 14:51:43 +01:00
Uwe Steinmann
fad327a8ea Merge branch 'seeddms-5.0.x' into seeddms-5.1.x 2017-02-20 14:06:21 +01:00
Uwe Steinmann
67c7d83a72 use bootstrap theme 2017-02-20 14:06:04 +01:00
Uwe Steinmann
8665826211 update version 2017-02-20 12:57:54 +01:00
Uwe Steinmann
f3d00db04d add update script for sqlite3 2017-02-20 11:56:01 +01:00
Uwe Steinmann
ec94cdde55 use bigint for filesize 2017-02-20 11:55:26 +01:00
Uwe Steinmann
f24b627817 fix more dates and mimetypes 2017-02-20 11:55:09 +01:00
Uwe Steinmann
f3aea6f842 fix all datetime fields, enlarge mimeType fields 2017-02-20 11:51:59 +01:00