← Back to branch summary

~raj-abhilash1/mailman/sqlalchemy

« back to all changes in this revision

Viewing changes to src/mailman/database/tests/data/migration_sqlite_1.sql

  • Committer: Barry Warsaw
  • Date: 2014-09-22 23:32:58 UTC
  • mto: This revision was merged to the branch mainline in revision 7267.
  • Revision ID: barry@list.org-20140922233258-fvg9e3j3equ2y915
Migrations will be replaced with Alchemy.

We don't need the raw SQL schema stuff any more.

We don't need the Version table any more.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/mailman/database/tests/data/migration_sqlite_1.sql
1
 
INSERT INTO "acceptablealias" VALUES(1,'foo@example.com',1);
2
 
INSERT INTO "acceptablealias" VALUES(2,'bar@example.com',1);
3
 
 
4
 
INSERT INTO "address" VALUES(
5
 
    1,'anne@example.com',NULL,'Anne Person',
6
 
    '2012-04-19 00:52:24.826432','2012-04-19 00:49:42.373769',1,2);
7
 
INSERT INTO "address" VALUES(
8
 
    2,'bart@example.com',NULL,'Bart Person',
9
 
    '2012-04-19 00:53:25.878800','2012-04-19 00:49:52.882050',2,4);
10
 
 
11
 
INSERT INTO "domain" VALUES(
12
 
    1,'example.com','http://example.com',NULL,'postmaster@example.com');
13
 
 
14
 
INSERT INTO "mailinglist" VALUES(
15
 
    -- id,list_name,mail_host,include_list_post_header,include_rfc2369_headers
16
 
    1,'test','example.com',1,1,
17
 
    -- created_at,admin_member_chunksize,next_request_id,next_digest_number
18
 
    '2012-04-19 00:46:13.173844',30,1,1,
19
 
    -- digest_last_sent_at,volume,last_post_at,accept_these_nonmembers
20
 
    NULL,1,NULL,X'80025D71012E',
21
 
    -- acceptable_aliases_id,admin_immed_notify,admin_notify_mchanges
22
 
    NULL,1,0,
23
 
    -- administrivia,advertised,anonymous_list,archive,archive_private
24
 
    1,1,0,1,0,
25
 
    -- archive_volume_frequency
26
 
    1,
27
 
    --autorespond_owner,autoresponse_owner_text
28
 
    0,'',
29
 
    -- autorespond_postings,autoresponse_postings_text
30
 
    0,'',
31
 
    -- autorespond_requests,authoresponse_requests_text
32
 
    0,'',
33
 
    -- autoresponse_grace_period
34
 
    '90 days, 0:00:00',
35
 
    -- forward_unrecognized_bounces_to,process_bounces
36
 
    1,1,
37
 
    -- bounce_info_stale_after,bounce_matching_headers
38
 
    '7 days, 0:00:00','
39
 
# Lines that *start* with a ''#'' are comments.
40
 
to: friend@public.com
41
 
message-id: relay.comanche.denmark.eu
42
 
from: list@listme.com
43
 
from: .*@uplinkpro.com
44
 
',
45
 
    -- bounce_notify_owner_on_disable,bounce_notify_owner_on_removal
46
 
    1,1,
47
 
    -- bounce_score_threshold,bounce_you_are_disabled_warnings
48
 
    5,3,
49
 
    -- bounce_you_are_disabled_warnings_interval
50
 
    '7 days, 0:00:00',
51
 
    -- filter_action,filter_content,collapse_alternatives
52
 
    2,0,1,
53
 
    -- convert_html_to_plaintext,default_member_action,default_nonmember_action
54
 
    0,4,0,
55
 
    -- description
56
 
    '',
57
 
    -- digest_footer_uri
58
 
    'mailman:///$listname/$language/footer-generic.txt',
59
 
    -- digest_header_uri
60
 
    NULL,
61
 
    -- digest_is_default,digest_send_periodic,digest_size_threshold
62
 
    0,1,30.0,
63
 
    -- digest_volume_frequency,digestable,discard_these_nonmembers
64
 
    1,1,X'80025D71012E',
65
 
    -- emergency,encode_ascii_prefixes,first_strip_reply_to
66
 
    0,0,0,
67
 
    -- footer_uri
68
 
    'mailman:///$listname/$language/footer-generic.txt',
69
 
    -- forward_auto_discards,gateway_to_mail,gateway_to_news
70
 
    1,0,0,
71
 
    -- generic_nonmember_action,goodby_message_uri
72
 
    1,'',
73
 
    -- header_matches,header_uri,hold_these_nonmembers,info,linked_newsgroup
74
 
    X'80025D71012E',NULL,X'80025D71012E','','',
75
 
    -- max_days_to_hold,max_message_size,max_num_recipients
76
 
    0,40,10,
77
 
    -- member_moderation_notice,mime_is_default_digest,moderator_password
78
 
    '',0,NULL,
79
 
    -- new_member_options,news_moderation,news_prefix_subject_too
80
 
    256,0,1,
81
 
    -- nntp_host,nondigestable,nonmember_rejection_notice,obscure_addresses
82
 
    '',1,'',1,
83
 
    -- owner_chain,owner_pipeline,personalize,post_id
84
 
    'default-owner-chain','default-owner-pipeline',0,1,
85
 
    -- posting_chain,posting_pipeline,preferred_language,private_roster
86
 
    'default-posting-chain','default-posting-pipeline','en',1,
87
 
    -- display_name,reject_these_nonmembers
88
 
    'Test',X'80025D71012E',
89
 
    -- reply_goes_to_list,reply_to_address
90
 
    0,'',
91
 
    -- require_explicit_destination,respond_to_post_requests
92
 
    1,1,
93
 
    -- scrub_nondigest,send_goodbye_message,send_reminders,send_welcome_message
94
 
    0,1,1,1,
95
 
    -- subject_prefix,subscribe_auto_approval
96
 
    '[Test] ',X'80025D71012E',
97
 
    -- subscribe_policy,topics,topics_bodylines_limit,topics_enabled
98
 
    1,X'80025D71012E',5,0,
99
 
    -- unsubscribe_policy,welcome_message_uri
100
 
    0,'mailman:///welcome.txt');
101
 
 
102
 
INSERT INTO "member" VALUES(
103
 
    1,'d1243f4d-e604-4f6b-af52-98d0a7bce0f1',1,'test@example.com',4,NULL,5,1);
104
 
INSERT INTO "member" VALUES(
105
 
    2,'dccc3851-fdfb-4afa-90cf-bdcbf80ad0fd',2,'test@example.com',3,NULL,6,1);
106
 
INSERT INTO "member" VALUES(
107
 
    3,'479be431-45f2-473d-bc3c-7eac614030ac',3,'test@example.com',3,NULL,7,2);
108
 
INSERT INTO "member" VALUES(
109
 
    4,'e2dc604c-d93a-4b91-b5a8-749e3caade36',1,'test@example.com',4,NULL,8,2);
110
 
 
111
 
INSERT INTO "preferences" VALUES(1,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
112
 
INSERT INTO "preferences" VALUES(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
113
 
INSERT INTO "preferences" VALUES(3,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
114
 
INSERT INTO "preferences" VALUES(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
115
 
INSERT INTO "preferences" VALUES(5,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
116
 
INSERT INTO "preferences" VALUES(6,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
117
 
INSERT INTO "preferences" VALUES(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
118
 
INSERT INTO "preferences" VALUES(8,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
119
 
 
120
 
INSERT INTO "user" VALUES(
121
 
    1,'Anne Person',NULL,'0adf3caa-6f26-46f8-a11d-5256c8148592',
122
 
    '2012-04-19 00:49:42.370493',1,1);
123
 
INSERT INTO "user" VALUES(
124
 
    2,'Bart Person',NULL,'63f5d1a2-e533-4055-afe4-475dec3b1163',
125
 
    '2012-04-19 00:49:52.868746',2,3);
126
 
 
127
 
INSERT INTO "uid" VALUES(1,'8bf9a615-f23e-4980-b7d1-90ac0203c66f');
128
 
INSERT INTO "uid" VALUES(2,'0adf3caa-6f26-46f8-a11d-5256c8148592');
129
 
INSERT INTO "uid" VALUES(3,'63f5d1a2-e533-4055-afe4-475dec3b1163');
130
 
INSERT INTO "uid" VALUES(4,'d1243f4d-e604-4f6b-af52-98d0a7bce0f1');
131
 
INSERT INTO "uid" VALUES(5,'dccc3851-fdfb-4afa-90cf-bdcbf80ad0fd');
132
 
INSERT INTO "uid" VALUES(6,'479be431-45f2-473d-bc3c-7eac614030ac');
133
 
INSERT INTO "uid" VALUES(7,'e2dc604c-d93a-4b91-b5a8-749e3caade36');