· 5 years ago · Feb 24, 2020, 12:50 PM
1$db = new SQLite3('/usr/local/cwp/.conf/backup_config.sqlite', SQLITE3_OPEN_CREATE | SQLITE3_OPEN_READWRITE);
2 $table ='CREATE TABLE IF NOT EXISTS "backups" (
3 "ACCOUNTS_SERVER" TEXT,
4 "ACCOUNTS_SERVER_ID" TEXT,
5 "ADMIN_USERS" TEXT,
6 "APACHE_INCLUDE_CONFI" TEXT,
7 "APACHE_WEBSERVER_CONF" TEXT,
8 "BACKUP_RETENTION_DAILY" TEXT,
9 "BACKUP_RETENTION_MONTHLY" TEXT,
10 "BACKUP_RETENTION_WEEKLY" TEXT,
11 "BACKUP_STATUS" TEXT,
12 "BY_ACCOUNTS" TEXT,
13 "CONF_APACHE_SSL" TEXT,
14 "CRON_HOUR" TEXT,
15 "CRON_MINUTES" TEXT,
16 "CWP_CONFIG_BACKUP" TEXT,
17 "DAILY_BACKUP" TEXT,
18 "DATABASE_MYSQL" TEXT,
19 "DEFAULUSERBACKUP" TEXT,
20 "DNS_ZONE_TEMPLATE" TEXT,
21 "FREQUENCY_DETAILS" TEXT,
22 "FREQUENCY_DETAILS_DAILY" TEXT,
23 "FREQUENCY_DETAILS_MONTHLY" TEXT,
24 "FREQUENCY_DETAILS_WEEKLY" TEXT,
25 "FTP_ACCOUNTS_BACKUP" TEXT,
26 "FTP_FILE_SERVER" TEXT,
27 "FTP_LOCATION" TEXT,
28 "FTP_LOGIN_USER" TEXT,
29 "FTP_PASS" TEXT,
30 "FTP_SERVER" TEXT,
31 "FTP_SERVERNAME" TEXT,
32 "FTP_SERVER_PORT" TEXT,
33 "FTP_TYPE" TEXT,
34 "FULL" TEXT,
35 "HOME_SERVER" TEXT,
36 "INCREMENTAL" TEXT,
37 "LASTEXEC" TEXT,
38 "LOCAL_FILE" TEXT,
39 "LOCATION_LOCAL_FILE" TEXT,
40 "MAIL_SERVER_SETTINGS" TEXT,
41 "MONTHLY_BACKUP" TEXT,
42 "NAME_RSA" TEXT,
43 "NOT_ADMIN" TEXT,
44 "NOT_END" TEXT,
45 "NOT_ERROR" TEXT,
46 "NOT_OTHER" TEXT,
47 "NOT_OTHER_EMAIL" TEXT,
48 "NOT_OWNER" TEXT,
49 "NOT_START" TEXT,
50 "NOT_START_END" TEXT,
51 "PER_PACKAGE" TEXT,
52 "RECORDS_DNS_DOMAIN" TEXT,
53 "SETTINGS_MYSQL_SSL_PHP" TEXT,
54 "SSH_FILE" TEXT,
55 "SSH_PORT" TEXT,
56 "SSH_SERVER" TEXT,
57 "SSH_SERVERNAME" TEXT,
58 "SSH_USER" TEXT,
59 "STRUN" TEXT,
60 "USERS_MAIL_ALIAS" TEXT,
61 "ID" INTEGER PRIMARY KEY AUTOINCREMENT,
62 "BACKUP_FORCE" TEXT,
63 "AGGRESSIVENESS" TEXT,
64 "WEEKLY_BACKUP" TEXT,
65 "SSL_DOMAINS" TEXT,
66 "ACCOUNT_FTP" TEXT);';
67 $db->exec($table);