# -*- coding: utf-8 -*-

mysqldata = 'root:1234@localhost:3306/dondefluir2'
myPort = 5000

report_folder = 'reports'

templates = {
'loggin_template':'login.html',
'home_template':'home.html'}

app_name = "Donde Fluir"
app_folder = '/home/ubuntu/envflask/flaskapp2'
app_folder = 'C:/Andes/Desarrollos/Python/dondefluir/dondefluir2'
images_url = '%s/static' % app_folder
images_folder = 'files'
SECRET_KEY = 'dondefluir_2017'

versions = {2: ["ALTER TABLE company ADD COLUMN City VARCHAR(100)", \
"ALTER TABLE company ADD COLUMN Address VARCHAR(100)"],
3: ["ALTER TABLE user ADD COLUMN ShowDays INTEGER ",\
"ALTER TABLE user ADD COLUMN Phone VARCHAR(40)", \
"ALTER TABLE user ADD COLUMN Address VARCHAR(100)", \
"ALTER TABLE user ADD COLUMN Comment MEDIUMTEXT", \
"ALTER TABLE user ADD COLUMN City VARCHAR(100)"],
4: ["ALTER TABLE user ADD COLUMN ImageProfile VARCHAR(100)"],
5: ["ALTER TABLE activity ADD COLUMN Image VARCHAR(100)"],
6: ["ALTER TABLE activity ADD COLUMN MaxPersons INTEGER", \
"ALTER TABLE activity ADD COLUMN Description MEDIUMTEXT", \
"ALTER TABLE activity ADD COLUMN Price DOUBLE"],
7: ["ALTER TABLE user ADD COLUMN NtfActivityNew INTEGER", \
"ALTER TABLE user ADD COLUMN NtfActivityCancel INTEGER", \
"ALTER TABLE user ADD COLUMN NtfActivityChange INTEGER", \
"ALTER TABLE user ADD COLUMN NtfActivityReminder INTEGER", \
"ALTER TABLE user ADD COLUMN NtfReminderDays INTEGER", \
"ALTER TABLE user ADD COLUMN NtfReminderHours INTEGER"], \
8: ["ALTER TABLE User ADD COLUMN ShowFromDays INTEGER"], \
9: [], \
10: ["ALTER TABLE activity ADD COLUMN Status INTEGER"],\
11: ["ALTER TABLE user MODIFY id VARCHAR(50)"],\
12: ["ALTER TABLE activity MODIFY CustId VARCHAR(50)", \
"ALTER TABLE activity MODIFY CustId VARCHAR(50)", \
"ALTER TABLE activity MODIFY ProfId VARCHAR(50)", \
"ALTER TABLE activityusers MODIFY CustId VARCHAR(50)", \
"ALTER TABLE userfavorite MODIFY UserId VARCHAR(50)", \
"ALTER TABLE userfavorite MODIFY FavoriteId VARCHAR(50)", \
],\
13: ["ALTER TABLE usernote MODIFY UserId VARCHAR(50)", \
"ALTER TABLE usernote MODIFY ProfId VARCHAR(50)", \
"ALTER TABLE userservice MODIFY UserId VARCHAR(50)", \
],\
14: ["ALTER TABLE notification MODIFY UserId VARCHAR(50)",
],\
15: ["ALTER TABLE service MODIFY Name VARCHAR(100)",
],\
16: ["ALTER TABLE notification ADD COLUMN Description MEDIUMTEXT",
],\
17: ["ALTER TABLE activity MODIFY CustId VARCHAR(50)", \
"ALTER TABLE activity MODIFY CustId VARCHAR(50)", \
"ALTER TABLE activity MODIFY ProfId VARCHAR(50)", \
],\
18: ["ALTER TABLE user ADD COLUMN NtfActivityConfirm INTEGER", \
"ALTER TABLE user ADD COLUMN NtfActivityNewCust INTEGER"], \
19: ["ALTER TABLE userschedule MODIFY user_id VARCHAR(50)", \
],\
23: ["ALTER TABLE company ADD COLUMN ImageProfile VARCHAR(100)", \
],\
24: ["ALTER TABLE company MODIFY Comment MEDIUMTEXT", \
],\
25: ["ALTER TABLE service ADD COLUMN OnlinePayment INTEGER", \
"ALTER TABLE activity ADD COLUMN OnlinePayment INTEGER", \
"ALTER TABLE company ADD COLUMN OnlinePayment INTEGER", \
"ALTER TABLE company ADD COLUMN KeyPayco VARCHAR(50)"\
],\
26: ["ALTER TABLE user ADD COLUMN Closed INTEGER", \
],\
27: ["UPDATE user SET Closed = 0", \
],\
28: ["ALTER TABLE company ADD COLUMN Closed INTEGER", \
],\
29: ["UPDATE company SET Closed = 0",
],\
30: ["ALTER TABLE service ADD COLUMN Price DOUBLE", \
],\
31: ["ALTER TABLE user ADD COLUMN CreatedDate DATE", \
],\
32: ["UPDATE user SET CreatedDate = '2017-07-01'", \
],\
}


AccountName = 'Donde Fluir'
Sender = 'info@dondefluir.com'
SMTPServer = 'smtp-relay.gmail.com'
SMTPPort = 25



e0239dc793c2e09608f4156ee6983f5f359e7883
<mask token>

mysqldata = 'root:1234@localhost:3306/dondefluir2'
myPort = 5000
report_folder = 'reports'
templates = {'loggin_template': 'login.html', 'home_template': 'home.html'}
app_name = 'Donde Fluir'
app_folder = '/home/ubuntu/envflask/flaskapp2'
app_folder = 'C:/Andes/Desarrollos/Python/dondefluir/dondefluir2'
images_url = '%s/static' % app_folder
images_folder = 'files'
SECRET_KEY = 'dondefluir_2017'
versions = {(2): ['ALTER TABLE company ADD COLUMN City VARCHAR(100)',
    'ALTER TABLE company ADD COLUMN Address VARCHAR(100)'], (3): [
    'ALTER TABLE user ADD COLUMN ShowDays INTEGER ',
    'ALTER TABLE user ADD COLUMN Phone VARCHAR(40)',
    'ALTER TABLE user ADD COLUMN Address VARCHAR(100)',
    'ALTER TABLE user ADD COLUMN Comment MEDIUMTEXT',
    'ALTER TABLE user ADD COLUMN City VARCHAR(100)'], (4): [
    'ALTER TABLE user ADD COLUMN ImageProfile VARCHAR(100)'], (5): [
    'ALTER TABLE activity ADD COLUMN Image VARCHAR(100)'], (6): [
    'ALTER TABLE activity ADD COLUMN MaxPersons INTEGER',
    'ALTER TABLE activity ADD COLUMN Description MEDIUMTEXT',
    'ALTER TABLE activity ADD COLUMN Price DOUBLE'], (7): [
    'ALTER TABLE user ADD COLUMN NtfActivityNew INTEGER',
    'ALTER TABLE user ADD COLUMN NtfActivityCancel INTEGER',
    'ALTER TABLE user ADD COLUMN NtfActivityChange INTEGER',
    'ALTER TABLE user ADD COLUMN NtfActivityReminder INTEGER',
    'ALTER TABLE user ADD COLUMN NtfReminderDays INTEGER',
    'ALTER TABLE user ADD COLUMN NtfReminderHours INTEGER'], (8): [
    'ALTER TABLE User ADD COLUMN ShowFromDays INTEGER'], (9): [], (10): [
    'ALTER TABLE activity ADD COLUMN Status INTEGER'], (11): [
    'ALTER TABLE user MODIFY id VARCHAR(50)'], (12): [
    'ALTER TABLE activity MODIFY CustId VARCHAR(50)',
    'ALTER TABLE activity MODIFY CustId VARCHAR(50)',
    'ALTER TABLE activity MODIFY ProfId VARCHAR(50)',
    'ALTER TABLE activityusers MODIFY CustId VARCHAR(50)',
    'ALTER TABLE userfavorite MODIFY UserId VARCHAR(50)',
    'ALTER TABLE userfavorite MODIFY FavoriteId VARCHAR(50)'], (13): [
    'ALTER TABLE usernote MODIFY UserId VARCHAR(50)',
    'ALTER TABLE usernote MODIFY ProfId VARCHAR(50)',
    'ALTER TABLE userservice MODIFY UserId VARCHAR(50)'], (14): [
    'ALTER TABLE notification MODIFY UserId VARCHAR(50)'], (15): [
    'ALTER TABLE service MODIFY Name VARCHAR(100)'], (16): [
    'ALTER TABLE notification ADD COLUMN Description MEDIUMTEXT'], (17): [
    'ALTER TABLE activity MODIFY CustId VARCHAR(50)',
    'ALTER TABLE activity MODIFY CustId VARCHAR(50)',
    'ALTER TABLE activity MODIFY ProfId VARCHAR(50)'], (18): [
    'ALTER TABLE user ADD COLUMN NtfActivityConfirm INTEGER',
    'ALTER TABLE user ADD COLUMN NtfActivityNewCust INTEGER'], (19): [
    'ALTER TABLE userschedule MODIFY user_id VARCHAR(50)'], (23): [
    'ALTER TABLE company ADD COLUMN ImageProfile VARCHAR(100)'], (24): [
    'ALTER TABLE company MODIFY Comment MEDIUMTEXT'], (25): [
    'ALTER TABLE service ADD COLUMN OnlinePayment INTEGER',
    'ALTER TABLE activity ADD COLUMN OnlinePayment INTEGER',
    'ALTER TABLE company ADD COLUMN OnlinePayment INTEGER',
    'ALTER TABLE company ADD COLUMN KeyPayco VARCHAR(50)'], (26): [
    'ALTER TABLE user ADD COLUMN Closed INTEGER'], (27): [
    'UPDATE user SET Closed = 0'], (28): [
    'ALTER TABLE company ADD COLUMN Closed INTEGER'], (29): [
    'UPDATE company SET Closed = 0'], (30): [
    'ALTER TABLE service ADD COLUMN Price DOUBLE'], (31): [
    'ALTER TABLE user ADD COLUMN CreatedDate DATE'], (32): [
    "UPDATE user SET CreatedDate = '2017-07-01'"]}
AccountName = 'Donde Fluir'
Sender = 'info@dondefluir.com'
SMTPServer = 'smtp-relay.gmail.com'
SMTPPort = 25

# -*- coding: utf-8 -*-

mysqldata = 'root:1234@localhost:3306/dondefluir2'
myPort = 5000

report_folder = 'reports'

templates = {
'loggin_template':'login.html',
'home_template':'home.html'}

app_name = "Donde Fluir"
app_folder = '/home/ubuntu/envflask/flaskapp2'
app_folder = 'C:/Andes/Desarrollos/Python/dondefluir/dondefluir2'
images_url = '%s/static' % app_folder
images_folder = 'files'
SECRET_KEY = 'dondefluir_2017'

versions = {2: ["ALTER TABLE company ADD COLUMN City VARCHAR(100)", \
"ALTER TABLE company ADD COLUMN Address VARCHAR(100)"],
3: ["ALTER TABLE user ADD COLUMN ShowDays INTEGER ",\
"ALTER TABLE user ADD COLUMN Phone VARCHAR(40)", \
"ALTER TABLE user ADD COLUMN Address VARCHAR(100)", \
"ALTER TABLE user ADD COLUMN Comment MEDIUMTEXT", \
"ALTER TABLE user ADD COLUMN City VARCHAR(100)"],
4: ["ALTER TABLE user ADD COLUMN ImageProfile VARCHAR(100)"],
5: ["ALTER TABLE activity ADD COLUMN Image VARCHAR(100)"],
6: ["ALTER TABLE activity ADD COLUMN MaxPersons INTEGER", \
"ALTER TABLE activity ADD COLUMN Description MEDIUMTEXT", \
"ALTER TABLE activity ADD COLUMN Price DOUBLE"],
7: ["ALTER TABLE user ADD COLUMN NtfActivityNew INTEGER", \
"ALTER TABLE user ADD COLUMN NtfActivityCancel INTEGER", \
"ALTER TABLE user ADD COLUMN NtfActivityChange INTEGER", \
"ALTER TABLE user ADD COLUMN NtfActivityReminder INTEGER", \
"ALTER TABLE user ADD COLUMN NtfReminderDays INTEGER", \
"ALTER TABLE user ADD COLUMN NtfReminderHours INTEGER"], \
8: ["ALTER TABLE User ADD COLUMN ShowFromDays INTEGER"], \
9: [], \
10: ["ALTER TABLE activity ADD COLUMN Status INTEGER"],\
11: ["ALTER TABLE user MODIFY id VARCHAR(50)"],\
12: ["ALTER TABLE activity MODIFY CustId VARCHAR(50)", \
"ALTER TABLE activity MODIFY CustId VARCHAR(50)", \
"ALTER TABLE activity MODIFY ProfId VARCHAR(50)", \
"ALTER TABLE activityusers MODIFY CustId VARCHAR(50)", \
"ALTER TABLE userfavorite MODIFY UserId VARCHAR(50)", \
"ALTER TABLE userfavorite MODIFY FavoriteId VARCHAR(50)", \
],\
13: ["ALTER TABLE usernote MODIFY UserId VARCHAR(50)", \
"ALTER TABLE usernote MODIFY ProfId VARCHAR(50)", \
"ALTER TABLE userservice MODIFY UserId VARCHAR(50)", \
],\
14: ["ALTER TABLE notification MODIFY UserId VARCHAR(50)",
],\
15: ["ALTER TABLE service MODIFY Name VARCHAR(100)",
],\
16: ["ALTER TABLE notification ADD COLUMN Description MEDIUMTEXT",
],\
17: ["ALTER TABLE activity MODIFY CustId VARCHAR(50)", \
"ALTER TABLE activity MODIFY CustId VARCHAR(50)", \
"ALTER TABLE activity MODIFY ProfId VARCHAR(50)", \
],\
18: ["ALTER TABLE user ADD COLUMN NtfActivityConfirm INTEGER", \
"ALTER TABLE user ADD COLUMN NtfActivityNewCust INTEGER"], \
19: ["ALTER TABLE userschedule MODIFY user_id VARCHAR(50)", \
],\
23: ["ALTER TABLE company ADD COLUMN ImageProfile VARCHAR(100)", \
],\
24: ["ALTER TABLE company MODIFY Comment MEDIUMTEXT", \
],\
25: ["ALTER TABLE service ADD COLUMN OnlinePayment INTEGER", \
"ALTER TABLE activity ADD COLUMN OnlinePayment INTEGER", \
"ALTER TABLE company ADD COLUMN OnlinePayment INTEGER", \
"ALTER TABLE company ADD COLUMN KeyPayco VARCHAR(50)"\
],\
26: ["ALTER TABLE user ADD COLUMN Closed INTEGER", \
],\
27: ["UPDATE user SET Closed = 0", \
],\
28: ["ALTER TABLE company ADD COLUMN Closed INTEGER", \
],\
29: ["UPDATE company SET Closed = 0",
],\
30: ["ALTER TABLE service ADD COLUMN Price DOUBLE", \
],\
31: ["ALTER TABLE user ADD COLUMN CreatedDate DATE", \
],\
32: ["UPDATE user SET CreatedDate = '2017-07-01'", \
],\
}


AccountName = 'Donde Fluir'
Sender = 'info@dondefluir.com'
SMTPServer = 'smtp-relay.gmail.com'
SMTPPort = 25


