Procedura de inregistrare, eliberare bilete tratament balnear - cjp salaj

bossprettyingData Management

Nov 28, 2012 (4 years and 10 months ago)

268 views

--

--

The system tables of MySQL Server

--


set sql_mode='';

set storage_engine=myisam;


CREATE TABLE IF NOT EXISTS db ( Host char(60) binary DEFAULT '' NOT
NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary
DEFAULT '' NOT NULL, Select_pr
iv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Insert_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') COLLATE utf8_general_ci

DEFAULT 'N' NOT NULL, Create_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, References_priv enum
('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Create_tmp_table_priv enum('N','Y')
COLLATE utf8_general_c
i DEFAULT 'N' NOT NULL, Lock_tables_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT
NULL, Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N'
NOT NULL, Cre
ate_routine_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Alter_routine_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Execute_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Event_priv enum('N','Y') CO
LLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Trigger_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, PRIMARY KEY Host (Host,Db,User),
KEY User (User) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin
comment='Database privileges';


--

Rem
ember for later if db table already existed

set @had_db_table= @@warning_count != 0;


CREATE TABLE IF NOT EXISTS host ( Host char(60) binary DEFAULT '' NOT
NULL, Db char(64) binary DEFAULT '' NOT NULL, Select_priv enum('N','Y')
COLLATE utf8_general_ci DEF
AULT 'N' NOT NULL, Insert_priv enum('N','Y')
COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Update_priv enum('N','Y')
COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y')
COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_priv enum('N',
'Y')
COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y')
COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y')
COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, References_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N
' NOT NULL, Index_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Alter_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N'
NOT NULL, Lock_tables_priv enu
m('N','Y') COLLATE utf8_general_ci DEFAULT
'N' NOT NULL, Create_view_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Show_view_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Create_routine_priv enum('N','Y')
COLLATE utf8_
general_ci DEFAULT 'N' NOT NULL, Alter_routine_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Execute_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Trigger_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL
, PRIMARY KEY
Host (Host,Db) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin
comment='Host privileges; Merged with database privileges';



CREATE TABLE IF NOT EXISTS user ( Host char(60) binary DEFAULT '' NOT
NULL, User char(16) binary DEFAULT '' NO
T NULL, Password char(41)
character set latin1 collate latin1_bin DEFAULT '' NOT NULL, Select_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Insert_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Update_priv
enum('N','Y')

COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Delete_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Drop_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT N
ULL, Reload_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Shutdown_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Process_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, File_priv
enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Grant_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT
NULL, Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT
NULL,
Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT
NULL, Show_db_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT
NULL, Super_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT
NULL, Create_tmp_table_priv enum('N','Y') COLLA
TE utf8_general_ci DEFAULT
'N' NOT NULL, Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Execute_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Repl_slave_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N'

NOT NULL, Repl_client_priv enum('N','Y')
COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_view_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT
NULL, Create_routine_p
riv enum('N','Y') COLLATE utf8_general_ci DEFAULT
'N' NOT NULL, Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci
DEFAULT 'N' NOT NULL, Create_user_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Event_priv enum('N','Y') COLLATE
utf
8_general_ci DEFAULT 'N' NOT NULL, Trigger_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, ssl_type enum('','ANY','X509',
'SPECIFIED') COLLATE utf8_general_ci DEFAULT '' NOT NULL, ssl_cipher BLOB
NOT NULL, x509_issuer BLOB NOT NULL, x509_s
ubject BLOB NOT NULL,
max_questions int(11) unsigned DEFAULT 0 NOT NULL, max_updates int(11)
unsigned DEFAULT 0 NOT NULL, max_connections int(11) unsigned DEFAULT 0
NOT NULL, max_user_connections int(11) unsigned DEFAULT 0 NOT NULL,
PRIMARY KEY Host (H
ost,User) ) engine=MyISAM CHARACTER SET utf8 COLLATE
utf8_bin comment='Users and global privileges';


--

Remember for later if user table already existed

set @had_user_table= @@warning_count != 0;



CREATE TABLE IF NOT EXISTS func ( name char(64) binary D
EFAULT '' NOT
NULL, ret tinyint(1) DEFAULT '0' NOT NULL, dl char(128) DEFAULT '' NOT
NULL, type enum ('function','aggregate') COLLATE utf8_general_ci NOT
NULL, PRIMARY KEY (name) ) engine=MyISAM CHARACTER SET utf8 COLLATE
utf8_bin comment='User defined f
unctions';



CREATE TABLE IF NOT EXISTS plugin ( name char(64) binary DEFAULT '' NOT
NULL, dl char(128) DEFAULT '' NOT NULL, PRIMARY KEY (name) )
engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin comment='MySQL
plugins';



CREATE TABLE IF NOT EXISTS server
s ( Server_name char(64) NOT NULL
DEFAULT '', Host char(64) NOT NULL DEFAULT '', Db char(64) NOT NULL
DEFAULT '', Username char(64) NOT NULL DEFAULT '', Password char(64) NOT
NULL DEFAULT '', Port INT(4) NOT NULL DEFAULT '0', Socket char(64) NOT
NULL DEFAU
LT '', Wrapper char(64) NOT NULL DEFAULT '', Owner char(64) NOT
NULL DEFAULT '', PRIMARY KEY (Server_name)) CHARACTER SET utf8
comment='MySQL Foreign Servers table';



CREATE TABLE IF NOT EXISTS tables_priv ( Host char(60) binary DEFAULT ''
NOT NULL, Db ch
ar(64) binary DEFAULT '' NOT NULL, User char(16) binary
DEFAULT '' NOT NULL, Table_name char(64) binary DEFAULT '' NOT NULL,
Grantor char(77) DEFAULT '' NOT NULL, Timestamp timestamp(14), Table_priv
set('Select','Insert','Update','Delete','Create','Drop','
Grant','Referenc
es','Index','Alter','Create View','Show view','Trigger') COLLATE
utf8_general_ci DEFAULT '' NOT NULL, Column_priv
set('Select','Insert','Update','References') COLLATE utf8_general_ci
DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name
), KEY Grantor
(Grantor) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin
comment='Table privileges';


CREATE TABLE IF NOT EXISTS columns_priv ( Host char(60) binary DEFAULT ''
NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary
DEF
AULT '' NOT NULL, Table_name char(64) binary DEFAULT '' NOT NULL,
Column_name char(64) binary DEFAULT '' NOT NULL, Timestamp timestamp(14),
Column_priv set('Select','Insert','Update','References') COLLATE
utf8_general_ci DEFAULT '' NOT NULL, PRIMARY KEY
(H
ost,Db,User,Table_name,Column_name) ) engine=MyISAM CHARACTER SET utf8
COLLATE utf8_bin comment='Column privileges';



CREATE TABLE IF NOT EXISTS help_topic ( help_topic_id int unsigned not
null, name char(64) not null, help_category_id smallint unsigned

not
null, description text not null, example text not null, url char(128)
not null, primary key (help_topic_id), unique index (name) )
engine=MyISAM CHARACTER SET utf8 comment='help topics';



CREATE TABLE IF NOT EXISTS help_category ( help_category_id

smallint
unsigned not null, name char(64) not null, parent_category_id smallint
unsigned null, url char(128) not null, primary key (help_category_id),
unique index (name) ) engine=MyISAM CHARACTER SET utf8 comment='help
categories';



CREATE TABLE IF N
OT EXISTS help_relation ( help_topic_id int unsigned not
null references help_topic, help_keyword_id int unsigned not null
references help_keyword, primary key (help_keyword_id, help_topic_id) )
engine=MyISAM CHARACTER SET utf8 comment='keyword
-
topic rela
tion';



CREATE TABLE IF NOT EXISTS help_keyword ( help_keyword_id int unsigned
not null, name char(64) not null, primary key (help_keyword_id), unique
index (name) ) engine=MyISAM CHARACTER SET utf8 comment='help keywords';



CREATE TABLE IF NOT EXISTS

time_zone_name ( Name char(64) NOT NULL,
Time_zone_id int unsigned NOT NULL, PRIMARY KEY Name (Name) )
engine=MyISAM CHARACTER SET utf8 comment='Time zone names';



CREATE TABLE IF NOT EXISTS time_zone ( Time_zone_id int unsigned NOT
NULL auto_incre
ment, Use_leap_seconds enum('Y','N') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, PRIMARY KEY TzId (Time_zone_id) )
engine=MyISAM CHARACTER SET utf8 comment='Time zones';



CREATE TABLE IF NOT EXISTS time_zone_transition ( Time_zone_id int
unsigned NO
T NULL, Transition_time bigint signed NOT NULL,
Transition_type_id int unsigned NOT NULL, PRIMARY KEY TzIdTranTime
(Time_zone_id, Transition_time) ) engine=MyISAM CHARACTER SET utf8
comment='Time zone transitions';



CREATE TABLE IF NOT EXISTS time_zone_
transition_type ( Time_zone_id int
unsigned NOT NULL, Transition_type_id int unsigned NOT NULL, Offset int
signed DEFAULT 0 NOT NULL, Is_DST tinyint unsigned DEFAULT 0 NOT NULL,
Abbreviation char(8) DEFAULT '' NOT NULL, PRIMARY KEY TzIdTrTId
(Time_zone_i
d, Transition_type_id) ) engine=MyISAM CHARACTER SET utf8
comment='Time zone transition types';



CREATE TABLE IF NOT EXISTS time_zone_leap_second ( Transition_time
bigint signed NOT NULL, Correction int signed NOT NULL, PRIMARY KEY
TranTime (Transitio
n_time) ) engine=MyISAM CHARACTER SET utf8
comment='Leap seconds information for time zones';



CREATE TABLE IF NOT EXISTS proc (db char(64) collate utf8_bin DEFAULT ''
NOT NULL, name char(64) DEFAULT '' NOT NULL, type
enum('FUNCTION','PROCEDURE') NOT NU
LL, specific_name char(64) DEFAULT ''
NOT NULL, language enum('SQL') DEFAULT 'SQL' NOT NULL, sql_data_access
enum( 'CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')
DEFAULT 'CONTAINS_SQL' NOT NULL, is_deterministic enum('YES','NO')
DEFAULT '
NO' NOT NULL, security_type enum('INVOKER','DEFINER') DEFAULT
'DEFINER' NOT NULL, param_list blob NOT NULL, returns longblob DEFAULT ''
NOT NULL, body longblob NOT NULL, definer char(77) collate utf8_bin
DEFAULT '' NOT NULL, created timestamp, modified tim
estamp, sql_mode set(
'REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE',
'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION',
'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB',
'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS',

'NO_FIELD_OPTIONS', 'MYSQL323',
'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES',
'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE',
'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO',
'TRADITIONAL', 'NO_AUTO_CREAT
E_USER', 'HIGH_NOT_PRECEDENCE',
'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH') DEFAULT '' NOT NULL,
comment char(64) collate utf8_bin DEFAULT '' NOT NULL,
character_set_client char(32) collate utf8_bin, collation_connection
char(32) collate utf8_bin,

db_collation char(32) collate utf8_bin,
body_utf8 longblob, PRIMARY KEY (db,name,type)) engine=MyISAM character
set utf8 comment='Stored Procedures';


CREATE TABLE IF NOT EXISTS procs_priv ( Host char(60) binary DEFAULT ''
NOT NULL, Db char(64) binary DEF
AULT '' NOT NULL, User char(16) binary
DEFAULT '' NOT NULL, Routine_name char(64) binary DEFAULT '' NOT NULL,
Routine_type enum('FUNCTION','PROCEDURE') NOT NULL, Grantor char(77)
DEFAULT '' NOT NULL, Proc_priv set('Execute','Alter Routine','Grant')
COLLATE

utf8_general_ci DEFAULT '' NOT NULL, Timestamp timestamp(14),
PRIMARY KEY (Host,Db,User,Routine_name,Routine_type), KEY Grantor
(Grantor) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin
comment='Procedure privileges';


--

Create general_log if CSV i
s enabled.


SET @str = IF (@@have_csv = 'YES', 'CREATE TABLE IF NOT EXISTS
general_log (event_time TIMESTAMP NOT NULL, user_host MEDIUMTEXT NOT
NULL, thread_id INTEGER NOT NULL, server_id INTEGER UNSIGNED NOT NULL,
command_type VARCHAR(64) NOT NULL, argume
nt MEDIUMTEXT NOT NULL)
engine=CSV CHARACTER SET utf8 comment="General log"', 'SET @dummy = 0');


PREPARE stmt FROM @str;

EXECUTE stmt;

DROP PREPARE stmt;


--

Create slow_log if CSV is enabled.


SET @str = IF (@@have_csv = 'YES', 'CREATE TABLE IF NOT EXIST
S slow_log
(start_time TIMESTAMP NOT NULL, user_host MEDIUMTEXT NOT NULL, query_time
TIME NOT NULL, lock_time TIME NOT NULL, rows_sent INTEGER NOT NULL,
rows_examined INTEGER NOT NULL, db VARCHAR(512) NOT NULL, last_insert_id
INTEGER NOT NULL, insert_id IN
TEGER NOT NULL, server_id INTEGER UNSIGNED
NOT NULL, sql_text MEDIUMTEXT NOT NULL) engine=CSV CHARACTER SET utf8
comment="Slow log"', 'SET @dummy = 0');


PREPARE stmt FROM @str;

EXECUTE stmt;

DROP PREPARE stmt;


CREATE TABLE IF NOT EXISTS event ( db char(6
4) CHARACTER SET utf8 COLLATE
utf8_bin NOT NULL default '', name char(64) CHARACTER SET utf8 NOT NULL
default '', body longblob NOT NULL, definer char(77) CHARACTER SET utf8
COLLATE utf8_bin NOT NULL default '', execute_at DATETIME default NULL,
interval_v
alue int(11) default NULL, interval_field
ENUM('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICR
OSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE',
'HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','
MINUT
E_MICROSECOND','SECOND_MICROSECOND') default NULL, created TIMESTAMP NOT
NULL, modified TIMESTAMP NOT NULL, last_executed DATETIME default NULL,
starts DATETIME default NULL, ends DATETIME default NULL, status
ENUM('ENABLED','DISABLED','SLAVESIDE_DISA
BLED') NOT NULL default
'ENABLED', on_completion ENUM('DROP','PRESERVE') NOT NULL default 'DROP',
sql_mode
set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_U
SED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','P
OS
TGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTI
ONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZER
O','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_Z
ERO_IN_DATE','NO_ZERO_DATE','INVALID_DA
TES','ERROR_FOR_DIVISION_BY_ZERO',
'TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBS
TITUTION','PAD_CHAR_TO_FULL_LENGTH') DEFAULT '' NOT NULL, comment
char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
originator INTEGE
R UNSIGNED NOT NULL, time_zone char(64) CHARACTER SET
latin1 NOT NULL DEFAULT 'SYSTEM', character_set_client char(32) collate
utf8_bin, collation_connection char(32) collate utf8_bin, db_collation
char(32) collate utf8_bin, body_utf8 longblob, PRIMARY KEY
(db, name) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT 'Events';



CREATE TABLE IF NOT EXISTS ndb_binlog_index (Position BIGINT UNSIGNED NOT
NULL, File VARCHAR(255) NOT NULL, epoch BIGINT UNSIGNED NOT NULL, inserts
BIGINT UNSIGNED NOT NULL, updates BIGINT

UNSIGNED NOT NULL, deletes
BIGINT UNSIGNED NOT NULL, schemaops BIGINT UNSIGNED NOT NULL, PRIMARY
KEY(epoch)) ENGINE=MYISAM;