diff options
| author | unknown <reggie@linux.site> | 2006-01-30 11:47:56 -0600 |
|---|---|---|
| committer | unknown <reggie@linux.site> | 2006-01-30 11:47:56 -0600 |
| commit | aa7dbd028944b66178efd919f876d14ff54c4407 (patch) | |
| tree | b67f5951e2d9208b1682c685d435ad424fe962b9 /sql/event.h | |
| parent | a0b5fe13e05eae5f780fa6b3c659c4170302ee03 (diff) | |
| parent | 6330e075267ffe52c34fa7860d9fc243841d56e3 (diff) | |
| download | mariadb-git-aa7dbd028944b66178efd919f876d14ff54c4407.tar.gz | |
Merge rburnett@bk-internal.mysql.com:/home/bk/mysql-5.1-new
into linux.site:/home/reggie/work/mysql-5.1
Diffstat (limited to 'sql/event.h')
| -rw-r--r-- | sql/event.h | 33 |
1 files changed, 29 insertions, 4 deletions
diff --git a/sql/event.h b/sql/event.h index 80629fa0a70..6ee9cea25ac 100644 --- a/sql/event.h +++ b/sql/event.h @@ -54,6 +54,25 @@ enum enum_event_status MYSQL_EVENT_DISABLED }; +enum evex_table_field +{ + EVEX_FIELD_DB = 0, + EVEX_FIELD_NAME, + EVEX_FIELD_BODY, + EVEX_FIELD_DEFINER, + EVEX_FIELD_EXECUTE_AT, + EVEX_FIELD_INTERVAL_EXPR, + EVEX_FIELD_TRANSIENT_INTERVAL, + EVEX_FIELD_CREATED, + EVEX_FIELD_MODIFIED, + EVEX_FIELD_LAST_EXECUTED, + EVEX_FIELD_STARTS, + EVEX_FIELD_ENDS, + EVEX_FIELD_STATUS, + EVEX_FIELD_ON_COMPLETION, + EVEX_FIELD_COMMENT, + EVEX_FIELD_COUNT /* a cool trick to count the number of fields :) */ +} ; class event_timed { @@ -64,9 +83,10 @@ class event_timed bool status_changed; bool last_executed_changed; - TIME last_executed; public: + TIME last_executed; + LEX_STRING dbname; LEX_STRING name; LEX_STRING body; @@ -83,8 +103,8 @@ public: longlong expression; interval_type interval; - longlong created; - longlong modified; + ulonglong created; + ulonglong modified; enum enum_event_on_completion on_completion; enum enum_event_status status; sp_head *sphead; @@ -197,6 +217,10 @@ int evex_drop_event(THD *thd, event_timed *et, bool drop_if_exists, uint *rows_affected); +int +evex_open_event_table(THD *thd, enum thr_lock_type lock_type, TABLE **table); + +int sortcmp_lex_string(LEX_STRING s, LEX_STRING t, CHARSET_INFO *cs); int init_events(); @@ -210,6 +234,7 @@ int event_timed_compare(event_timed **a, event_timed **b); + /* CREATE TABLE event ( db char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '', @@ -233,7 +258,7 @@ CREATE TABLE event ( status ENUM('ENABLED','DISABLED') NOT NULL default 'ENABLED', on_completion ENUM('DROP','PRESERVE') NOT NULL default 'DROP', comment varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '', - PRIMARY KEY (db,name) + PRIMARY KEY (definer,db,name) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT 'Events'; */ |