-- phpMyAdmin SQL Dump -- version 2.11.8.1deb5 -- http://www.phpmyadmin.net -- -- Host: mysql.cws.private.unt.edu -- Generation Time: Mar 26, 2009 at 09:25 AM -- Server version: 5.1.32 -- PHP Version: 5.2.6-1+lenny2 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: 'iase_unt_edu' -- -- -------------------------------------------------------- -- -- Table structure for table 'proposals' -- CREATE TABLE proposals ( `Index` int(5) NOT NULL, Title varchar(1000) CHARACTER SET latin1 NOT NULL, Abstract varchar(3500) CHARACTER SET latin1 NOT NULL, `Session` varchar(1) CHARACTER SET latin1 NOT NULL, ProgramDescription varchar(3500) CHARACTER SET latin1 NOT NULL, SurName1 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName1 varchar(75) CHARACTER SET latin1 NOT NULL, LastName1 varchar(75) CHARACTER SET latin1 NOT NULL, Position1 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency1 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress1 varchar(200) CHARACTER SET latin1 NOT NULL, City1 varchar(75) CHARACTER SET latin1 NOT NULL, State1 varchar(75) CHARACTER SET latin1 NOT NULL, Country1 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode1 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber1 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork1 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail1 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone1 varchar(75) CHARACTER SET latin1 NOT NULL, SurName2 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName2 varchar(75) CHARACTER SET latin1 NOT NULL, LastName2 varchar(75) CHARACTER SET latin1 NOT NULL, Position2 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency2 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress2 varchar(200) CHARACTER SET latin1 NOT NULL, City2 varchar(75) CHARACTER SET latin1 NOT NULL, State2 varchar(75) CHARACTER SET latin1 NOT NULL, Country2 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode2 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber2 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork2 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail2 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone2 varchar(75) CHARACTER SET latin1 NOT NULL, SurName3 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName3 varchar(75) CHARACTER SET latin1 NOT NULL, LastName3 varchar(75) CHARACTER SET latin1 NOT NULL, Position3 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency3 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress3 varchar(200) CHARACTER SET latin1 NOT NULL, City3 varchar(75) CHARACTER SET latin1 NOT NULL, State3 varchar(75) CHARACTER SET latin1 NOT NULL, Country3 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode3 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber3 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork3 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail3 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone3 varchar(75) CHARACTER SET latin1 NOT NULL, SpecialNeeds varchar(3000) CHARACTER SET latin1 NOT NULL, SurName4 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName4 varchar(75) CHARACTER SET latin1 NOT NULL, LastName4 varchar(75) CHARACTER SET latin1 NOT NULL, Position4 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency4 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress4 varchar(200) CHARACTER SET latin1 NOT NULL, City4 varchar(75) CHARACTER SET latin1 NOT NULL, State4 varchar(75) CHARACTER SET latin1 NOT NULL, Country4 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode4 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber4 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork4 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail4 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone4 varchar(75) CHARACTER SET latin1 NOT NULL, SurName5 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName5 varchar(75) CHARACTER SET latin1 NOT NULL, LastName5 varchar(75) CHARACTER SET latin1 NOT NULL, Position5 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency5 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress5 varchar(200) CHARACTER SET latin1 NOT NULL, City5 varchar(75) CHARACTER SET latin1 NOT NULL, State5 varchar(75) CHARACTER SET latin1 NOT NULL, Country5 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode5 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber5 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork5 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail5 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone5 varchar(75) CHARACTER SET latin1 NOT NULL, SurName6 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName6 varchar(75) CHARACTER SET latin1 NOT NULL, LastName6 varchar(75) CHARACTER SET latin1 NOT NULL, Position6 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency6 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress6 varchar(200) CHARACTER SET latin1 NOT NULL, City6 varchar(75) CHARACTER SET latin1 NOT NULL, State6 varchar(75) CHARACTER SET latin1 NOT NULL, Country6 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode6 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber6 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork6 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail6 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone6 varchar(75) CHARACTER SET latin1 NOT NULL, SurName7 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName7 varchar(75) CHARACTER SET latin1 NOT NULL, LastName7 varchar(75) CHARACTER SET latin1 NOT NULL, Position7 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency7 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress7 varchar(200) CHARACTER SET latin1 NOT NULL, City7 varchar(75) CHARACTER SET latin1 NOT NULL, State7 varchar(75) CHARACTER SET latin1 NOT NULL, Country7 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode7 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber7 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork7 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail7 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone7 varchar(75) CHARACTER SET latin1 NOT NULL, SurName8 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName8 varchar(75) CHARACTER SET latin1 NOT NULL, LastName8 varchar(75) CHARACTER SET latin1 NOT NULL, Position8 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency8 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress8 varchar(200) CHARACTER SET latin1 NOT NULL, City8 varchar(75) CHARACTER SET latin1 NOT NULL, State8 varchar(75) CHARACTER SET latin1 NOT NULL, Country8 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode8 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber8 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork8 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail8 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone8 varchar(75) CHARACTER SET latin1 NOT NULL, SurName9 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName9 varchar(75) CHARACTER SET latin1 NOT NULL, LastName9 varchar(75) CHARACTER SET latin1 NOT NULL, Position9 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency9 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress9 varchar(200) CHARACTER SET latin1 NOT NULL, City9 varchar(75) CHARACTER SET latin1 NOT NULL, State9 varchar(75) CHARACTER SET latin1 NOT NULL, Country9 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode9 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber9 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork9 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail9 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone9 varchar(75) CHARACTER SET latin1 NOT NULL, SurName10 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName10 varchar(75) CHARACTER SET latin1 NOT NULL, LastName10 varchar(75) CHARACTER SET latin1 NOT NULL, Position10 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency10 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress10 varchar(200) CHARACTER SET latin1 NOT NULL, City10 varchar(75) CHARACTER SET latin1 NOT NULL, State10 varchar(75) CHARACTER SET latin1 NOT NULL, Country10 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode10 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber10 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork10 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail10 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone10 varchar(75) CHARACTER SET latin1 NOT NULL, SurName11 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName11 varchar(75) CHARACTER SET latin1 NOT NULL, LastName11 varchar(75) CHARACTER SET latin1 NOT NULL, Position11 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency11 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress11 varchar(200) CHARACTER SET latin1 NOT NULL, City11 varchar(75) CHARACTER SET latin1 NOT NULL, State11 varchar(75) CHARACTER SET latin1 NOT NULL, Country11 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode11 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber11 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork11 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail11 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone11 varchar(75) CHARACTER SET latin1 NOT NULL, SurName12 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName12 varchar(75) CHARACTER SET latin1 NOT NULL, LastName12 varchar(75) CHARACTER SET latin1 NOT NULL, Position12 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency12 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress12 varchar(200) CHARACTER SET latin1 NOT NULL, City12 varchar(75) CHARACTER SET latin1 NOT NULL, State12 varchar(75) CHARACTER SET latin1 NOT NULL, Country12 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode12 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber12 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork12 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail12 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone12 varchar(75) CHARACTER SET latin1 NOT NULL, SurName13 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName13 varchar(75) CHARACTER SET latin1 NOT NULL, LastName13 varchar(75) CHARACTER SET latin1 NOT NULL, Position13 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency13 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress13 varchar(200) CHARACTER SET latin1 NOT NULL, City13 varchar(75) CHARACTER SET latin1 NOT NULL, State13 varchar(75) CHARACTER SET latin1 NOT NULL, Country13 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode13 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber13 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork13 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail13 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone13 varchar(75) CHARACTER SET latin1 NOT NULL, SurName14 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName14 varchar(75) CHARACTER SET latin1 NOT NULL, LastName14 varchar(75) CHARACTER SET latin1 NOT NULL, Position14 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency14 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress14 varchar(75) CHARACTER SET latin1 NOT NULL, City14 varchar(75) CHARACTER SET latin1 NOT NULL, State14 varchar(75) CHARACTER SET latin1 NOT NULL, Country14 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode14 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber14 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork14 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail14 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone14 varchar(75) CHARACTER SET latin1 NOT NULL, SurName15 varchar(75) CHARACTER SET latin1 NOT NULL, FirstName15 varchar(75) CHARACTER SET latin1 NOT NULL, LastName15 varchar(75) CHARACTER SET latin1 NOT NULL, Position15 varchar(75) CHARACTER SET latin1 NOT NULL, EmployAgency15 varchar(75) CHARACTER SET latin1 NOT NULL, StreetAddress15 varchar(75) CHARACTER SET latin1 NOT NULL, City15 varchar(75) CHARACTER SET latin1 NOT NULL, State15 varchar(75) CHARACTER SET latin1 NOT NULL, Country15 varchar(75) CHARACTER SET latin1 NOT NULL, ZipCode15 varchar(75) CHARACTER SET latin1 NOT NULL, PhoneNumber15 varchar(75) CHARACTER SET latin1 NOT NULL, EmailWork15 varchar(75) CHARACTER SET latin1 NOT NULL, SummerEmail15 varchar(75) CHARACTER SET latin1 NOT NULL, SummerPhone15 varchar(75) CHARACTER SET latin1 NOT NULL, SessionType int(5) NOT NULL, SessionDate int(5) NOT NULL, SessionNumber int(10) NOT NULL, `Table` int(5) NOT NULL, SessionTime varchar(50) CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`Index`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci