/usr/share/sympa/bin/create_db.SQLite is in sympa 6.1.7~dfsg-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 | CREATE TABLE user_table (
email_user text NOT NULL,
gecos_user text,
password_user text,
last_login_date_user integer,
last_login_host_user text,
wrong_login_count_user integer,
cookie_delay_user integer,
lang_user text,
attributes_user text,
data_user text,
PRIMARY KEY (email_user)
);
CREATE TABLE subscriber_table (
list_subscriber text NOT NULL,
user_subscriber text NOT NULL,
custom_attribute_subscriber text,
robot_subscriber text NOT NULL,
date_subscriber timestamp NOT NULL,
update_subscriber timestamp,
visibility_subscriber text,
reception_subscriber text,
topics_subscriber text,
bounce_subscriber text,
bounce_address_subscriber text,
comment_subscriber text,
subscribed_subscriber boolean,
included_subscriber boolean,
include_sources_subscriber text,
bounce_score_subscriber integer,
suspend_subscriber boolean,
suspend_start_date_subscriber integer,
suspend_end_date_subscriber integer,
PRIMARY KEY (robot_subscriber, list_subscriber, user_subscriber)
);
CREATE INDEX subscriber_idx ON subscriber_table (user_subscriber,list_subscriber,robot_subscriber);
CREATE TABLE admin_table (
list_admin text NOT NULL,
user_admin text NOT NULL,
robot_admin text NOT NULL,
role_admin text NOT NULL,
date_admin timestamp NOT NULL,
update_admin timestamp,
reception_admin text,
visibility_admin text,
comment_admin text,
subscribed_admin boolean,
included_admin boolean,
include_sources_admin text,
info_admin text,
profile_admin text,
PRIMARY KEY (robot_admin, list_admin, role_admin, user_admin)
);
CREATE INDEX admin_idx ON admin_table(list_admin, user_admin, robot_admin, role_admin);
CREATE TABLE exclusion_table (
list_exclusion text,
user_exclusion text,
date_exclusion integer,
PRIMARY KEY (list_exclusion, user_exclusion)
);
CREATE INDEX exclusion_idx ON exclusion_table(list_exclusion, user_exclusion);
CREATE TABLE netidmap_table (
netid_netidmap text NOT NULL,
serviceid_netidmap text NOT NULL,
robot_netidmap text NOT NULL,
email_netidmap text,
PRIMARY KEY (netid_netidmap, serviceid_netidmap, robot_netidmap)
);
CREATE INDEX netidmap_idx ON netidmap_table(netid_netidmap, serviceid_netidmap, robot_netidmap);
CREATE TABLE logs_table (
id_logs integer NOT NULL,
date_logs integer NOT NULL,
robot_logs text,
list_logs text,
action_logs text NOT NULL,
parameters_logs text,
target_email_logs text,
user_email_logs text,
msg_id_logs text,
status_logs text NOT NULL,
error_type_logs text,
client_logs text,
daemon_logs text NOT NULL,
PRIMARY KEY (id_logs)
);
CREATE INDEX logs_idx ON logs_table(id_logs);
CREATE TABLE session_table (
id_session text NOT NULL,
start_date_session integer NOT NULL,
date_session integer NOT NULL,
remote_addr_session text,
robot_session text,
email_session text,
hit_session integer,
data_session text,
PRIMARY KEY (id_session)
);
CREATE INDEX session_idx ON session_table(id_session);
CREATE TABLE one_time_ticket_table (
ticket_one_time_ticket text NOT NULL,
robot_one_time_ticket text,
email_one_time_ticket text,
date_one_time_ticket integer,
data_one_time_ticket text,
remote_addr_one_time_ticket text,
status_one_time_ticket text,
PRIMARY KEY (ticket_one_time_ticket)
);
CREATE INDEX one_time_ticket_idx ON one_time_ticket_table(ticket_one_time_ticket);
CREATE TABLE bulkmailer_table(
messagekey_bulkmailer varchar(80) NOT NULL,
packetid_bulkmailer varchar(33) NOT NULL,
messageid_bulkmailer varchar(100),
receipients_bulkmailer text,
returnpath_bulkmailer varchar(100),
robot_bulkmailer varchar(80),
listname_bulkmailer varchar(50),
verp_bulkmailer integer,
merge_bulkmailer integer,
priority_message_bulkmailer integer,
priority_packet_bulkmailer integer,
reception_date_bulkmailer integer,
delivery_date_bulkmailer integer,
lock_bulkmailer varchar(30),
PRIMARY KEY (messagekey_bulkmailer, packetid_bulkmailer)
);
CREATE INDEX bulkmailer_idx ON bulkmailer_table(messagekey_bulkmailer,packetid_bulkmailer);
CREATE TABLE bulkspool_table (
messagekey_bulkspool varchar(33) NOT NULL,
messageid_bulkspool varchar(100),
message_bulkspool text,
lock_bulkspool integer,
dkim_privatekey_bulkspool varchar(100),
dkim_selector_bulkspool varchar(50),
dkim_d_bulkspool varchar(50),
dkim_i_bulkspool varchar(50),
dkim_header_list_bulkspool varchar(500),
PRIMARY KEY (messagekey_bulkspool)
);
CREATE INDEX bulkspool_idx ON bulkspool_table(messagekey_bulkspool);
CREATE TABLE conf_table (
robot_conf text DEFAULT NULL,
label_conf text DEFAULT NULL,
value_conf text DEFAULT NULL,
PRIMARY KEY (robot_conf,label_conf)
);
CREATE INDEX conf_idx ON conf_table(robot_conf,label_conf);
|