projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
2352c58
)
upgrade id
author
Alan
<alan@roojs.com>
Mon, 15 Apr 2024 07:46:23 +0000
(15:46 +0800)
committer
Alan
<alan@roojs.com>
Mon, 15 Apr 2024 07:46:23 +0000
(15:46 +0800)
sql/events.sql
patch
|
blob
|
history
diff --git
a/sql/events.sql
b/sql/events.sql
index
7998e17
..
b81c281
100644
(file)
--- a/
sql/events.sql
+++ b/
sql/events.sql
@@
-1,6
+1,6
@@
CREATE TABLE Events (
CREATE TABLE Events (
- id
int(11)
NOT NULL auto_increment,
+ id
bigint
NOT NULL auto_increment,
PRIMARY KEY (id)
) ;
PRIMARY KEY (id)
) ;
@@
-36,6
+36,11
@@
ALTER TABLE Events CHANGE COLUMN Container on_table VARCHAR(64);
-- make action larger..
ALTER TABLE Events CHANGE COLUMN action action varchar(64) default NULL;
-- make action larger..
ALTER TABLE Events CHANGE COLUMN action action varchar(64) default NULL;
+-- id needs more space..
+ALTER TABLE Events change COLUMN id id bigint NOT NULL AUTO_INCREMENT;
+
+
+
ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_when, person_table);
ALTER TABLE Events ADD INDEX lookup_person_id (person_id);
ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_when, person_table);
ALTER TABLE Events ADD INDEX lookup_person_id (person_id);