From 03f5aba50c345c79eeb1f8b4be87cf4b2b27d5f2 Mon Sep 17 00:00:00 2001 From: rsoulliere Date: Mon, 11 Apr 2011 14:24:07 -0400 Subject: [PATCH] Remove reference to program_name and program_code since this is org specific and not generally useful. Pointed out by Damian Katz. --- 1.6/admin/migratingdata_1.6.xml | 6 ++---- 2.0/admin/migratingdata_2.0.xml | 6 ++---- 2 files changed, 4 insertions(+), 8 deletions(-) diff --git a/1.6/admin/migratingdata_1.6.xml b/1.6/admin/migratingdata_1.6.xml index 69bd16b116..94a8132369 100644 --- a/1.6/admin/migratingdata_1.6.xml +++ b/1.6/admin/migratingdata_1.6.xml @@ -477,8 +477,7 @@ SELECT DISTINCT ou.id AS circ_lib, sql CREATE TABLE students ( - student_id int, barcode text, last_name text, first_name text, program_number text, - program_name text, email text, address_type text, street1 text, street2 text, + student_id int, barcode text, last_name text, first_name text, email text, address_type text, street1 text, street2 text, city text, province text, country text, postal_code text, phone text, profile int, ident_type int, home_ou int, claims_returned_count int DEFAULT 0, usrname text, net_access_level int DEFAULT 2, password text @@ -565,8 +564,7 @@ BEGIN; -- Create staging table. CREATE TABLE students ( - student_id int, barcode text, last_name text, first_name text, program_number text, - program_name text, email text, address_type text, street1 text, street2 text, + student_id int, barcode text, last_name text, first_name text, email text, address_type text, street1 text, street2 text, city text, province text, country text, postal_code text, phone text, profile int, ident_type int, home_ou int, claims_returned_count int DEFAULT 0, usrname text, net_access_level int DEFAULT 2, password text diff --git a/2.0/admin/migratingdata_2.0.xml b/2.0/admin/migratingdata_2.0.xml index dac76888e3..40e9324785 100644 --- a/2.0/admin/migratingdata_2.0.xml +++ b/2.0/admin/migratingdata_2.0.xml @@ -472,8 +472,7 @@ SELECT DISTINCT ou.id AS circ_lib, sql CREATE TABLE students ( - student_id int, barcode text, last_name text, first_name text, program_number text, - program_name text, email text, address_type text, street1 text, street2 text, + student_id int, barcode text, last_name text, first_name text, email text, address_type text, street1 text, street2 text, city text, province text, country text, postal_code text, phone text, profile int, ident_type int, home_ou int, claims_returned_count int DEFAULT 0, usrname text, net_access_level int DEFAULT 2, password text @@ -560,8 +559,7 @@ BEGIN; -- Create staging table. CREATE TABLE students ( - student_id int, barcode text, last_name text, first_name text, program_number text, - program_name text, email text, address_type text, street1 text, street2 text, + student_id int, barcode text, last_name text, first_name text, email text, address_type text, street1 text, street2 text, city text, province text, country text, postal_code text, phone text, profile int, ident_type int, home_ou int, claims_returned_count int DEFAULT 0, usrname text, net_access_level int DEFAULT 2, password text -- 2.43.2