Created
November 6, 2013 03:28
-
-
Save rubo77/7330422 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE action_recorder ( | |
id int NOT NULL auto_increment, | |
module varchar(255) NOT NULL, | |
user_id int , | |
user_name varchar(255), | |
identifier varchar(255) NOT NULL, | |
success char (1), | |
date_added datetime NOT NULL, | |
PRIMARY KEY (id), | |
KEY idx_action_recorder_module (module), | |
KEY idx_action_recorder_user_id (user_id), | |
KEY idx_action_recorder_identifier (identifier), | |
KEY idx_action_recorder_date_added (date_added) | |
); | |
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, | |
configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Installed | |
Modules', 'MODULE_ACTION_RECORDER_INSTALLED', | |
'ar_admin_login.php;ar_contact_us.php;ar_tell_a_friend.php', 'List of action recorder module | |
filenames separated by a semi-colon. This is automatically updated. No need to edit.', '6', '0', | |
now()); | |
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, | |
configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Minimum | |
Minutes Per E-Mail', 'MODULE_ACTION_RECORDER_CONTACT_US_EMAIL_MINUTES', '15', 'Minimum number of | |
minutes to allow 1 e-mail to be sent (eg, 15 for 1 e-mail every 15 minutes)', '6', '0', now()); | |
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, | |
configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Minimum | |
Minutes Per E-Mail', 'MODULE_ACTION_RECORDER_TELL_A_FRIEND_EMAIL_MINUTES', '15', 'Minimum number | |
of minutes to allow 1 e-mail to be sent (eg, 15 for 1 e-mail every 15 minutes)', '6', '0', now()); | |
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, | |
configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Allowed | |
Minutes', 'MODULE_ACTION_RECORDER_ADMIN_LOGIN_MINUTES', '5', ' Number of minutes to allow login | |
attempts to occur.', '6', '0', now()); | |
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, | |
configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Allowed | |
Attempts', 'MODULE_ACTION_RECORDER_ADMIN_LOGIN_ATTEMPTS', '3', ' Number of login attempts to allow | |
within the specified period.', '6', '0', now()); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment