<commit_before>
CREATE TABLE autopayment_aut (
  aut_ID mediumint(9) unsigned NOT NULL auto_increment,
  aut_FamID mediumint(9) unsigned NOT NULL default '0',
  aut_EnableBankDraft tinyint(1) unsigned NOT NULL default '0',
  aut_EnableCreditCard tinyint(1) unsigned NOT NULL default '0',
  aut_NextPayDate date default NULL,
  aut_FYID mediumint(9) NOT NULL default '9',
  aut_Amount decimal(6,2) NOT NULL default '0.00',
  aut_Interval tinyint(3) NOT NULL default '1',
  aut_Fund mediumint(6) NOT NULL default '0',

  aut_FirstName varchar(50) default NULL,
  aut_LastName varchar(50) default NULL,
  aut_Address1 varchar(255) default NULL,
  aut_Address2 varchar(255) default NULL,
  aut_City varchar(50) default NULL,
  aut_State varchar(50) default NULL,
  aut_Zip varchar(50) default NULL,
  aut_Country varchar(50) default NULL,
  aut_Phone varchar(30) default NULL,
  aut_Email varchar(100) default NULL,

  aut_CreditCard varchar(50) default NULL,
  aut_ExpMonth varchar(2) default NULL,
  aut_ExpYear varchar(4) default NULL,

  aut_BankName varchar (50) default NULL,
  aut_Route varchar (30) default NULL,
  aut_Account varchar (30) default NULL,

  aut_DateLastEdited datetime default NULL,
  aut_EditedBy smallint(5) unsigned default '0',

  aut_Serial mediumint(9) NOT NULL default '1',

  PRIMARY KEY  (aut_ID),
  UNIQUE KEY aut_ID (aut_ID)
) TYPE=MyISAM;

CREATE TABLE canvassdata_can (
  can_ID mediumint(9) unsigned NOT NULL auto_increment,
  can_famID mediumint(9) NOT NULL default '0',
  can_Canvasser mediumint(9) NOT NULL default '0',
  can_FYID mediumint(9) default NULL,
  can_date date default NULL,
  can_Positive text,
  can_Critical text,
  can_Insightful text,
  can_Financial text,
  can_Suggestion text,
  can_NotInterested tinyint(1) NOT NULL default '0',
  can_WhyNotInterested text,

  PRIMARY KEY  (can_ID),
  UNIQUE KEY can_ID (can_ID)
) TYPE=MyISAM;

CREATE TABLE deposit_dep (
  dep_ID mediumint(9) unsigned NOT NULL auto_increment,
  dep_Date date default NULL,
  dep_Comment text,
  dep_EnteredBy mediumint(9) unsigned default NULL,
  dep_Closed tinyint(1) NOT NULL default '0',
  dep_Type enum('Bank','CreditCard','BankDraft') NOT NULL default 'Bank',
  PRIMARY KEY  (dep_ID)
) TYPE=MyISAM PACK_KEYS=0;

CREATE TABLE donationfund_fun (
  fun_ID tinyint(3) NOT NULL auto_increment,
  fun_Active enum('true','false') NOT NULL default 'true',
  fun_Name varchar(30) default NULL,
  fun_Description varchar(100) default NULL,
  PRIMARY KEY  (fun_ID),
  UNIQUE KEY fun_ID (fun_ID)
) TYPE=MyISAM;

CREATE TABLE volunteeropportunity_vol (
  vol_ID tinyint(3) NOT NULL auto_increment,
  vol_Active enum('true','false') NOT NULL default 'true',
  vol_Name varchar(30) default NULL,
  vol_Description varchar(100) default NULL,
  PRIMARY KEY  (vol_ID),
  UNIQUE KEY vol_ID (vol_ID)
) TYPE=MyISAM;

CREATE TABLE person2volunteeropp_p2vo (
  p2vo_ID mediumint(9) NOT NULL auto_increment,
  p2vo_per_ID mediumint(9),
  p2vo_vol_ID mediumint(9),
  PRIMARY KEY (p2vo_ID),
  UNIQUE KEY (p2vo_ID)
) TYPE=MyISAM;

CREATE TABLE family_fam (
  fam_ID mediumint(9) unsigned NOT NULL auto_increment,
  fam_Name varchar(50) default NULL,
  fam_Address1 varchar(255) default NULL,
  fam_Address2 varchar(255) default NULL,
  fam_City varchar(50) default NULL,
  fam_State varchar(50) default NULL,
  fam_Zip varchar(50) default NULL,
  fam_Country varchar(50) default NULL,<commit_msg>Create one fund by default to make sure the pledge summary report works.<commit_after>
CREATE TABLE autopayment_aut (
  aut_ID mediumint(9) unsigned NOT NULL auto_increment,
  aut_FamID mediumint(9) unsigned NOT NULL default '0',
  aut_EnableBankDraft tinyint(1) unsigned NOT NULL default '0',
  aut_EnableCreditCard tinyint(1) unsigned NOT NULL default '0',
  aut_NextPayDate date default NULL,
  aut_FYID mediumint(9) NOT NULL default '9',
  aut_Amount decimal(6,2) NOT NULL default '0.00',
  aut_Interval tinyint(3) NOT NULL default '1',
  aut_Fund mediumint(6) NOT NULL default '0',

  aut_FirstName varchar(50) default NULL,
  aut_LastName varchar(50) default NULL,
  aut_Address1 varchar(255) default NULL,
  aut_Address2 varchar(255) default NULL,
  aut_City varchar(50) default NULL,
  aut_State varchar(50) default NULL,
  aut_Zip varchar(50) default NULL,
  aut_Country varchar(50) default NULL,
  aut_Phone varchar(30) default NULL,
  aut_Email varchar(100) default NULL,

  aut_CreditCard varchar(50) default NULL,
  aut_ExpMonth varchar(2) default NULL,
  aut_ExpYear varchar(4) default NULL,

  aut_BankName varchar (50) default NULL,
  aut_Route varchar (30) default NULL,
  aut_Account varchar (30) default NULL,

  aut_DateLastEdited datetime default NULL,
  aut_EditedBy smallint(5) unsigned default '0',

  aut_Serial mediumint(9) NOT NULL default '1',

  PRIMARY KEY  (aut_ID),
  UNIQUE KEY aut_ID (aut_ID)
) TYPE=MyISAM;

CREATE TABLE canvassdata_can (
  can_ID mediumint(9) unsigned NOT NULL auto_increment,
  can_famID mediumint(9) NOT NULL default '0',
  can_Canvasser mediumint(9) NOT NULL default '0',
  can_FYID mediumint(9) default NULL,
  can_date date default NULL,
  can_Positive text,
  can_Critical text,
  can_Insightful text,
  can_Financial text,
  can_Suggestion text,
  can_NotInterested tinyint(1) NOT NULL default '0',
  can_WhyNotInterested text,

  PRIMARY KEY  (can_ID),
  UNIQUE KEY can_ID (can_ID)
) TYPE=MyISAM;

CREATE TABLE deposit_dep (
  dep_ID mediumint(9) unsigned NOT NULL auto_increment,
  dep_Date date default NULL,
  dep_Comment text,
  dep_EnteredBy mediumint(9) unsigned default NULL,
  dep_Closed tinyint(1) NOT NULL default '0',
  dep_Type enum('Bank','CreditCard','BankDraft') NOT NULL default 'Bank',
  PRIMARY KEY  (dep_ID)
) TYPE=MyISAM PACK_KEYS=0;

CREATE TABLE donationfund_fun (
  fun_ID tinyint(3) NOT NULL auto_increment,
  fun_Active enum('true','false') NOT NULL default 'true',
  fun_Name varchar(30) default NULL,
  fun_Description varchar(100) default NULL,
  PRIMARY KEY  (fun_ID),
  UNIQUE KEY fun_ID (fun_ID)
) TYPE=MyISAM;

INSERT INTO donationfund_fun (fun_ID, fun_Active, fun_Name, fun_Description) VALUES (1, 'true', 'Pledges', 'Pledge income for the operating budget');

CREATE TABLE volunteeropportunity_vol (
  vol_ID tinyint(3) NOT NULL auto_increment,
  vol_Active enum('true','false') NOT NULL default 'true',
  vol_Name varchar(30) default NULL,
  vol_Description varchar(100) default NULL,
  PRIMARY KEY  (vol_ID),
  UNIQUE KEY vol_ID (vol_ID)
) TYPE=MyISAM;

CREATE TABLE person2volunteeropp_p2vo (
  p2vo_ID mediumint(9) NOT NULL auto_increment,
  p2vo_per_ID mediumint(9),
  p2vo_vol_ID mediumint(9),
  PRIMARY KEY (p2vo_ID),
  UNIQUE KEY (p2vo_ID)
) TYPE=MyISAM;

CREATE TABLE family_fam (
  fam_ID mediumint(9) unsigned NOT NULL auto_increment,
  fam_Name varchar(50) default NULL,
  fam_Address1 varchar(255) default NULL,
  fam_Address2 varchar(255) default NULL,
  fam_City varchar(50) default NULL,
  fam_State varchar(50) default NULL,
  fam_Zip varchar(50) default NULL,
  fam_Country varchar(50) default NULL,
{'fraction_non_alphanumeric': 0.08269175933846593, 'fraction_numerical': 0.031793555745651556, 'mean_word_length': 5.308453237410072, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3680697', 'n_tokens_mistral': 2577, 'n_tokens_neox': 2414, 'n_words': 742}