[ljcom] r3607: proplist crap to own file
Committer: bradfitzproplist crap to own file
U trunk/bin/upgrading/base-data-local.sql
A trunk/bin/upgrading/proplists-local.dat
Modified: trunk/bin/upgrading/base-data-local.sql
===================================================================
--- trunk/bin/upgrading/base-data-local.sql 2006-10-05 21:14:48 UTC (rev 3606)
+++ trunk/bin/upgrading/base-data-local.sql 2006-10-05 22:25:38 UTC (rev 3607)
@@ -17,48 +17,3 @@
UPDATE priv_list SET des='Allows a user to see details about incoming money.',is_public='1',privname='Money - View Detailed Records',scope='local' WHERE privcode='moneyview';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to access shipping tools.', '1', 'shipping', 'Shipping Access', 'local');
UPDATE priv_list SET des='Allows a user to access shipping tools.',is_public='1',privname='Shipping Access',scope='local' WHERE privcode='shipping';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('0', 'char', 'Override some payment checks to allow a user to pay. Values are Y to allow payment, N to deny payment.', '0', '0', 'allow_pay', 'Allow/deny a user to pay', 'local');
-UPDATE userproplist SET cldversion='0',datatype='char',des='Override some payment checks to allow a user to pay. Values are Y to allow payment, N to deny payment.',indexed='0',multihomed='0',prettyname='Allow/deny a user to pay',scope='local' WHERE name='allow_pay';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'num', 'Unix timestamp of when we forced the control strip on for user', '0', '0', 'control_strip_forced', 'When control strip was forced on', 'local');
-UPDATE userproplist SET cldversion='4',datatype='num',des='Unix timestamp of when we forced the control strip on for user',indexed='0',multihomed='0',prettyname='When control strip was forced on',scope='local' WHERE name='control_strip_forced';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'char', 'Initial create.bml account type selection', '', '0', 'create_accttype', 'Created account type', 'local');
-UPDATE userproplist SET cldversion='4',datatype='char',des='Initial create.bml account type selection',indexed='',multihomed='0',prettyname='Created account type',scope='local' WHERE name='create_accttype';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'bool', 'Allow advertisiers to send email offers', '1', '0', 'email_offers', 'Send Advertiser Email Offers', 'local');
-UPDATE userproplist SET cldversion='4',datatype='bool',des='Allow advertisiers to send email offers',indexed='1',multihomed='0',prettyname='Send Advertiser Email Offers',scope='local' WHERE name='email_offers';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'bool', 'Boolean: 1 means mail Accounts about any payment activity for monitoring', '', '', 'fraud_watch', 'Fraud Watch', 'local');
-UPDATE userproplist SET cldversion='4',datatype='bool',des='Boolean: 1 means mail Accounts about any payment activity for monitoring',indexed='',multihomed='',prettyname='Fraud Watch',scope='local' WHERE name='fraud_watch';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'bool', 'Opt out of latest.bml, latest-rss.bml, and latest-img.bml if on.', '0', '0', 'latest_optout', 'Latest Updates Opt Out', 'local');
-UPDATE userproplist SET cldversion='4',datatype='bool',des='Opt out of latest.bml, latest-rss.bml, and latest-img.bml if on.',indexed='0',multihomed='0',prettyname='Latest Updates Opt Out',scope='local' WHERE name='latest_optout';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'bool', 'Assignment agreement necessary for bazaar payouts', '0', '0', 'legal_assignagree', 'Assignment Agreement Received', 'local');
-UPDATE userproplist SET cldversion='4',datatype='bool',des='Assignment agreement necessary for bazaar payouts',indexed='0',multihomed='0',prettyname='Assignment Agreement Received',scope='local' WHERE name='legal_assignagree';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'char', 'Y/N choice regarding whether lj-template tag embedded object should be hidden behind a placeholder.', '0', '0', 'opt_embedplaceholders', 'Use Placeholders for lj-template embedded objects', 'local');
-UPDATE userproplist SET cldversion='4',datatype='char',des='Y/N choice regarding whether lj-template tag embedded object should be hidden behind a placeholder.',indexed='0',multihomed='0',prettyname='Use Placeholders for lj-template embedded objects',scope='local' WHERE name='opt_embedplaceholders';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'bool', '1: don\'t include user when using offsite hit tracker', '0', '0', 'opt_exclude_stats', 'Exclude From Offsite Stats Tracking', 'local');
-UPDATE userproplist SET cldversion='4',datatype='bool',des='1: don\'t include user when using offsite hit tracker',indexed='0',multihomed='0',prettyname='Exclude From Offsite Stats Tracking',scope='local' WHERE name='opt_exclude_stats';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'num', 'User was paid before recbill went live, stores date of marking', '0', '0', 'paid_before_recbill', 'If paid before recbill went live', 'local');
-UPDATE userproplist SET cldversion='4',datatype='num',des='User was paid before recbill went live, stores date of marking',indexed='0',multihomed='0',prettyname='If paid before recbill went live',scope='local' WHERE name='paid_before_recbill';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'char', 'Email address of parent provided during age verification.', '0', '0', 'parent_email', 'Parent\'s Email Address', 'local');
-UPDATE userproplist SET cldversion='4',datatype='char',des='Email address of parent provided during age verification.',indexed='0',multihomed='0',prettyname='Parent\'s Email Address',scope='local' WHERE name='parent_email';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'blobchar', 'Packed POP3 deleted message id list', '0', '0', 'pop3_deletelist', 'POP3 Deletion List', 'local');
-UPDATE userproplist SET cldversion='4',datatype='blobchar',des='Packed POP3 deleted message id list',indexed='0',multihomed='0',prettyname='POP3 Deletion List',scope='local' WHERE name='pop3_deletelist';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'char', 'Post by phone stored blob format', '0', '0', 'pp_format', 'PhonePost File Format', 'local');
-UPDATE userproplist SET cldversion='4',datatype='char',des='Post by phone stored blob format',indexed='0',multihomed='0',prettyname='PhonePost File Format',scope='local' WHERE name='pp_format';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'num', 'Quickpost (hangup) action.', '0', '0', 'pp_quickpost', 'Voicepost hangup behavior.', 'local');
-UPDATE userproplist SET cldversion='4',datatype='num',des='Quickpost (hangup) action.',indexed='0',multihomed='0',prettyname='Voicepost hangup behavior.',scope='local' WHERE name='pp_quickpost';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'num', 'The friendgroup id for friends that may transcribe audio postings.', '0', '0', 'pp_transallow', 'Allowed phonepost transcribers', 'local');
-UPDATE userproplist SET cldversion='4',datatype='num',des='The friendgroup id for friends that may transcribe audio postings.',indexed='0',multihomed='0',prettyname='Allowed phonepost transcribers',scope='local' WHERE name='pp_transallow';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'num', 'The friendgroup i+d to post to if selected from the \'designated group\' menu option.', '0', '0', 'pp_vpgroup', 'Voicepost friends group', 'local');
-UPDATE userproplist SET cldversion='4',datatype='num',des='The friendgroup i+d to post to if selected from the \'designated group\' menu option.',indexed='0',multihomed='0',prettyname='Voicepost friends group',scope='local' WHERE name='pp_vpgroup';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('0', 'char', 'Keyword to show in singles search', '0', '0', 'single_pickw', 'Single Picture Keyword', 'local');
-UPDATE userproplist SET cldversion='0',datatype='char',des='Keyword to show in singles search',indexed='0',multihomed='0',prettyname='Single Picture Keyword',scope='local' WHERE name='single_pickw';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('0', 'char', 'Delimited by pipes: MF/MM/FF/FM, country, state, city, age', '1', '0', 'single_status', 'Single Status', 'local');
-UPDATE userproplist SET cldversion='0',datatype='char',des='Delimited by pipes: MF/MM/FF/FM, country, state, city, age',indexed='1',multihomed='0',prettyname='Single Status',scope='local' WHERE name='single_status';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'num', 'User has a WFG account already, stores date of creation', '0', '0', 'wfg_account_created', 'If WFG account exists', 'local');
-UPDATE userproplist SET cldversion='4',datatype='num',des='User has a WFG account already, stores date of creation',indexed='0',multihomed='0',prettyname='If WFG account exists',scope='local' WHERE name='wfg_account_created';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'num', 'Unix timestamp of when we forced the control strip on for user', '0', '0', 'control_strip_forced', 'When control strip was forced on', 'local');
-UPDATE userproplist SET cldversion='4',datatype='num',des='Unix timestamp of when we forced the control strip on for user',indexed='0',multihomed='0',prettyname='When control strip was forced on',scope='local' WHERE name='control_strip_forced';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'num', 'Notification limit per day by SMS', '0', '0', 'sms_perday_notif_limit', 'SMS notification limit per day', 'general');
-UPDATE userproplist SET cldversion='4',datatype='num',des='Notification limit per day by SMS',indexed='0',multihomed='0',prettyname='SMS notification limit per day',scope='general' WHERE name='sms_perday_notif_limit';
-INSERT IGNORE INTO userproplist (cldversion, datatype, des, indexed, multihomed, name, prettyname, scope) VALUES ('4', 'char', 'What a "yes" SMS message from the user means', '0', '0', 'sms_yes_means', 'What "yes" SMS message means', 'general');
-UPDATE userproplist SET cldversion='4',datatype='char',des='What a "yes" SMS message from the user means',indexed='0',multihomed='0',prettyname='What "yes" SMS message means',scope='general' WHERE name='sms_yes_means';
-
Added: trunk/bin/upgrading/proplists-local.dat
===================================================================
--- trunk/bin/upgrading/proplists-local.dat 2006-10-05 21:14:48 UTC (rev 3606)
+++ trunk/bin/upgrading/proplists-local.dat 2006-10-05 22:25:38 UTC (rev 3607)
@@ -0,0 +1,152 @@
+userproplist.allow_pay:
+ cldversion: 0
+ datatype: char
+ des: Override some payment checks to allow a user to pay. Values are Y to allow payment, N to deny payment.
+ indexed: 0
+ multihomed: 0
+ prettyname: Allow/deny a user to pay
+
+userproplist.control_strip_forced:
+ cldversion: 4
+ datatype: num
+ des: Unix timestamp of when we forced the control strip on for user
+ indexed: 0
+ multihomed: 0
+ prettyname: When control strip was forced on
+
+userproplist.create_accttype:
+ cldversion: 4
+ datatype: char
+ des: Initial create.bml account type selection
+ indexed:
+ multihomed: 0
+ prettyname: Created account type
+
+userproplist.email_offers:
+ cldversion: 4
+ datatype: bool
+ des: Allow advertisiers to send email offers
+ indexed: 1
+ multihomed: 0
+ prettyname: Send Advertiser Email Offers
+
+userproplist.fraud_watch:
+ cldversion: 4
+ datatype: bool
+ des: Boolean: 1 means mail Accounts about any payment activity for monitoring
+ indexed:
+ multihomed:
+ prettyname: Fraud Watch
+
+userproplist.latest_optout:
+ cldversion: 4
+ datatype: bool
+ des: Opt out of latest.bml, latest-rss.bml, and latest-img.bml if on.
+ indexed: 0
+ multihomed: 0
+ prettyname: Latest Updates Opt Out
+
+userproplist.legal_assignagree:
+ cldversion: 4
+ datatype: bool
+ des: Assignment agreement necessary for bazaar payouts
+ indexed: 0
+ multihomed: 0
+ prettyname: Assignment Agreement Received
+
+userproplist.opt_embedplaceholders:
+ cldversion: 4
+ datatype: char
+ des: Y/N choice regarding whether lj-template tag embedded object should be hidden behind a placeholder.
+ indexed: 0
+ multihomed: 0
+ prettyname: Use Placeholders for lj-template embedded objects
+
+userproplist.opt_exclude_stats:
+ cldversion: 4
+ datatype: bool
+ des: 1: don't include user when using offsite hit tracker
+ indexed: 0
+ multihomed: 0
+ prettyname: Exclude From Offsite Stats Tracking
+
+userproplist.paid_before_recbill:
+ cldversion: 4
+ datatype: num
+ des: User was paid before recbill went live, stores date of marking
+ indexed: 0
+ multihomed: 0
+ prettyname: If paid before recbill went live
+
+userproplist.parent_email:
+ cldversion: 4
+ datatype: char
+ des: Email address of parent provided during age verification.
+ indexed: 0
+ multihomed: 0
+ prettyname: Parent's Email Address
+
+userproplist.pop3_deletelist:
+ cldversion: 4
+ datatype: blobchar
+ des: Packed POP3 deleted message id list
+ indexed: 0
+ multihomed: 0
+ prettyname: POP3 Deletion List
+
+userproplist.pp_format:
+ cldversion: 4
+ datatype: char
+ des: Post by phone stored blob format
+ indexed: 0
+ multihomed: 0
+ prettyname: PhonePost File Format
+
+userproplist.pp_quickpost:
+ cldversion: 4
+ datatype: num
+ des: Quickpost (hangup) action.
+ indexed: 0
+ multihomed: 0
+ prettyname: Voicepost hangup behavior.
+
+userproplist.pp_transallow:
+ cldversion: 4
+ datatype: num
+ des: The friendgroup id for friends that may transcribe audio postings.
+ indexed: 0
+ multihomed: 0
+ prettyname: Allowed phonepost transcribers
+
+userproplist.pp_vpgroup:
+ cldversion: 4
+ datatype: num
+ des: The friendgroup i+d to post to if selected from the 'designated group' menu option.
+ indexed: 0
+ multihomed: 0
+ prettyname: Voicepost friends group
+
+userproplist.single_pickw:
+ cldversion: 0
+ datatype: char
+ des: Keyword to show in singles search
+ indexed: 0
+ multihomed: 0
+ prettyname: Single Picture Keyword
+
+userproplist.single_status:
+ cldversion: 0
+ datatype: char
+ des: Delimited by pipes: MF/MM/FF/FM, country, state, city, age
+ indexed: 1
+ multihomed: 0
+ prettyname: Single Status
+
+userproplist.wfg_account_created:
+ cldversion: 4
+ datatype: num
+ des: User has a WFG account already, stores date of creation
+ indexed: 0
+ multihomed: 0
+ prettyname: If WFG account exists
+