#------------------------------------------
# PHPSurveyor Database Dump of `yogaecom_surv1`
# Date of Dump: 25-May-2006
#------------------------------------------


#------------------------------------------
# Table definition for answers
#------------------------------------------

CREATE TABLE answers (
    qid int(11) DEFAULT '0' NOT NULL,
    code varchar(5) NOT NULL,
    answer text NOT NULL,
    default_value char(1) DEFAULT 'N' NOT NULL,
    sortorder varchar(5)
);


#------------------------------------------
# Table data for answers
#------------------------------------------
INSERT INTO answers VALUES("1","1","Yoga Studio Owner","N","00000");
INSERT INTO answers VALUES("1","2","Yoga Instructor/Trainer","N","00001");
INSERT INTO answers VALUES("1","3","Yoga Student/Hobbist","N","00002");
INSERT INTO answers VALUES("8","3","Yoga videos","N","00002");
INSERT INTO answers VALUES("8","2","Yoga photos on poses","N","00001");
INSERT INTO answers VALUES("2","1","Hatha","N","00000");
INSERT INTO answers VALUES("3","1","Less than 3 months","N","00000");
INSERT INTO answers VALUES("3","2","3 to 6 months","N","00001");
INSERT INTO answers VALUES("3","3","6 months to 1 year","N","00002");
INSERT INTO answers VALUES("3","4","1 to 3 years","N","00003");
INSERT INTO answers VALUES("3","5","3 to 5 years","N","00004");
INSERT INTO answers VALUES("3","6","5 to 10 years","N","00005");
INSERT INTO answers VALUES("3","7","10 to 20 years","N","00006");
INSERT INTO answers VALUES("3","8","more than 20 years","N","00007");
INSERT INTO answers VALUES("5","2","2-3 times per week","N","00001");
INSERT INTO answers VALUES("5","1","Once per week","N","00000");
INSERT INTO answers VALUES("4","3","Less than 1 year","N","00000");
INSERT INTO answers VALUES("4","4","1 to 3 years","N","00001");
INSERT INTO answers VALUES("4","5","3 to 5 years","N","00002");
INSERT INTO answers VALUES("4","6","5 to 10 years","N","00003");
INSERT INTO answers VALUES("4","7","10 to 20 years","N","00004");
INSERT INTO answers VALUES("4","8","more than 20 years","N","00005");
INSERT INTO answers VALUES("5","3","4-5 times per week","N","00002");
INSERT INTO answers VALUES("5","4","Almost everyday","N","00003");
INSERT INTO answers VALUES("5","5","Once every 2 weeks","N","00004");
INSERT INTO answers VALUES("5","6","Once every month","N","00005");
INSERT INTO answers VALUES("5","7","Less than once per month","N","00006");
INSERT INTO answers VALUES("6","1","Less than 10 minutes","N","00000");
INSERT INTO answers VALUES("6","2","10 - 20 minutes","N","00001");
INSERT INTO answers VALUES("6","3","20 - 40 minutes","N","00002");
INSERT INTO answers VALUES("6","4","40 - 60 minutes","N","00003");
INSERT INTO answers VALUES("6","5","more than 1 hour","N","00004");
INSERT INTO answers VALUES("7","1","None","N","00000");
INSERT INTO answers VALUES("7","2","1 to 4","N","00001");
INSERT INTO answers VALUES("7","3","5 to 10","N","00002");
INSERT INTO answers VALUES("7","4","11 to 20","N","00003");
INSERT INTO answers VALUES("7","5","Over 20","N","00004");
INSERT INTO answers VALUES("8","1","Yoga articles and news","N","00000");
INSERT INTO answers VALUES("9","1","Female","N","00000");
INSERT INTO answers VALUES("9","2","Male","N","00001");
INSERT INTO answers VALUES("10","1","Under 13","N","00000");
INSERT INTO answers VALUES("10","2","13 to 18","N","00001");
INSERT INTO answers VALUES("10","3","19 to 24","N","00002");
INSERT INTO answers VALUES("10","4","25 to 35","N","00003");
INSERT INTO answers VALUES("10","6","36 to 45","N","00004");
INSERT INTO answers VALUES("10","7","46 to 55","N","00005");
INSERT INTO answers VALUES("10","8","56 to 65","N","00006");
INSERT INTO answers VALUES("10","9","Over 65","N","00007");
INSERT INTO answers VALUES("13","2","Australia","N","00001");
INSERT INTO answers VALUES("13","1","USA","N","00000");
INSERT INTO answers VALUES("13","3","Canada","N","00002");
INSERT INTO answers VALUES("13","4","United Kingdom","N","00003");
INSERT INTO answers VALUES("13","5","India","N","00004");
INSERT INTO answers VALUES("13","6","Russia","N","00005");
INSERT INTO answers VALUES("13","7","Nigeria","N","00006");
INSERT INTO answers VALUES("13","8","Singapore","N","00007");
INSERT INTO answers VALUES("13","9","Malaysia","N","00008");
INSERT INTO answers VALUES("13","10","Indonesia","N","00009");
INSERT INTO answers VALUES("13","11","Afghanistan","N","00010");
INSERT INTO answers VALUES("13","12","Albania","N","00011");
INSERT INTO answers VALUES("13","13","Algeria","N","00012");
INSERT INTO answers VALUES("13","14","American Samoa","N","00013");
INSERT INTO answers VALUES("13","15","Angola","N","00014");
INSERT INTO answers VALUES("13","16","Anguilla","N","00015");
INSERT INTO answers VALUES("13","17","Antarctica","N","00016");
INSERT INTO answers VALUES("13","18","Antigua","N","00017");
INSERT INTO answers VALUES("13","19","Argentina","N","00018");
INSERT INTO answers VALUES("13","20","Armenia","N","00019");
INSERT INTO answers VALUES("13","21","Aruba","N","00020");
INSERT INTO answers VALUES("13","22","Australia","N","00021");
INSERT INTO answers VALUES("13","23","Austria","N","00022");
INSERT INTO answers VALUES("13","24","Azerbaijan","N","00023");
INSERT INTO answers VALUES("13","25","Bahamas","N","00024");
INSERT INTO answers VALUES("13","26","Bahrain","N","00025");
INSERT INTO answers VALUES("13","27","Bangladesh","N","00026");
INSERT INTO answers VALUES("13","28","Barbados","N","00027");
INSERT INTO answers VALUES("13","29","Barbuda","N","00028");
INSERT INTO answers VALUES("13","30","Belarus","N","00029");
INSERT INTO answers VALUES("13","31","Belgium","N","00030");
INSERT INTO answers VALUES("13","32","Belize","N","00031");
INSERT INTO answers VALUES("13","33","Benin","N","00032");
INSERT INTO answers VALUES("13","34","Bermuda","N","00033");
INSERT INTO answers VALUES("13","35","Bhutan","N","00034");
INSERT INTO answers VALUES("13","36","Bolivia","N","00035");
INSERT INTO answers VALUES("13","37","Bosnia and Herzegovina","N","00036");
INSERT INTO answers VALUES("13","38","Botswana","N","00037");
INSERT INTO answers VALUES("13","39","Brazil","N","00038");
INSERT INTO answers VALUES("13","40","British Virgin Islands","N","00039");
INSERT INTO answers VALUES("13","41","Brunei Darussalm","N","00040");
INSERT INTO answers VALUES("13","42","Bulgaria","N","00041");
INSERT INTO answers VALUES("13","43","Burundi","N","00042");
INSERT INTO answers VALUES("13","44","Cameroon","N","00043");
INSERT INTO answers VALUES("13","45","Canada","N","00044");
INSERT INTO answers VALUES("13","46","Cape Verde","N","00045");
INSERT INTO answers VALUES("13","47","Central African Republic","N","00046");
INSERT INTO answers VALUES("13","48","Chad","N","00047");
INSERT INTO answers VALUES("13","49","Chile","N","00048");
INSERT INTO answers VALUES("13","50","China","N","00049");
INSERT INTO answers VALUES("13","51","Colombia","N","00050");
INSERT INTO answers VALUES("13","52","Comoros and Mayotte","N","00051");
INSERT INTO answers VALUES("13","53","Congo","N","00052");
INSERT INTO answers VALUES("13","54","Cook Islands","N","00053");
INSERT INTO answers VALUES("13","55","Costa Rica","N","00054");
INSERT INTO answers VALUES("13","56","Croatia","N","00055");
INSERT INTO answers VALUES("13","57","Cuba","N","00056");
INSERT INTO answers VALUES("13","58","Cyprus","N","00057");
INSERT INTO answers VALUES("13","59","Czech Republic","N","00058");
INSERT INTO answers VALUES("13","60","Denmark","N","00059");
INSERT INTO answers VALUES("13","61","Djibouti","N","00060");
INSERT INTO answers VALUES("13","62","Ecuador","N","00061");
INSERT INTO answers VALUES("13","63","Egypt","N","00062");
INSERT INTO answers VALUES("13","64","El Salvador","N","00063");
INSERT INTO answers VALUES("13","65","Equatorial Guinea","N","00064");
INSERT INTO answers VALUES("13","66","Estonia","N","00065");
INSERT INTO answers VALUES("13","67","Ethiopia","N","00066");
INSERT INTO answers VALUES("13","68","Falkland Islands","N","00067");
INSERT INTO answers VALUES("13","69","Fiji","N","00068");
INSERT INTO answers VALUES("13","70","Finland","N","00069");
INSERT INTO answers VALUES("13","71","France","N","00070");
INSERT INTO answers VALUES("13","72","French Guiana","N","00071");
INSERT INTO answers VALUES("13","73","Gambia","N","00072");
INSERT INTO answers VALUES("13","74","Georgia","N","00073");
INSERT INTO answers VALUES("13","75","Germany","N","00074");
INSERT INTO answers VALUES("13","76","Ghana","N","00075");
INSERT INTO answers VALUES("13","77","Gibraltar","N","00076");
INSERT INTO answers VALUES("13","78","Greece","N","00077");
INSERT INTO answers VALUES("13","79","Greenland","N","00078");
INSERT INTO answers VALUES("13","80","Guam","N","00079");
INSERT INTO answers VALUES("13","81","Guatemala","N","00080");
INSERT INTO answers VALUES("13","82","Guinea","N","00081");
INSERT INTO answers VALUES("13","83","Guinea-Bissau","N","00082");
INSERT INTO answers VALUES("13","84","Guyana","N","00083");
INSERT INTO answers VALUES("13","85","Haiti","N","00084");
INSERT INTO answers VALUES("13","86","Honduras","N","00085");
INSERT INTO answers VALUES("13","87","Hong Kong","N","00086");
INSERT INTO answers VALUES("13","88","Hungary","N","00087");
INSERT INTO answers VALUES("13","89","Iceland","N","00088");
INSERT INTO answers VALUES("13","90","India","N","00089");
INSERT INTO answers VALUES("13","91","Indonesia","N","00090");
INSERT INTO answers VALUES("13","92","Iran","N","00091");
INSERT INTO answers VALUES("13","93","Iraq","N","00092");
INSERT INTO answers VALUES("13","94","Ireland","N","00093");
INSERT INTO answers VALUES("13","95","Israel","N","00094");
INSERT INTO answers VALUES("13","96","Italy","N","00095");
INSERT INTO answers VALUES("13","97","Japan","N","00096");
INSERT INTO answers VALUES("13","98","Jordan","N","00097");
INSERT INTO answers VALUES("13","99","Kazakhstan","N","00098");
INSERT INTO answers VALUES("13","100","Kenya","N","00099");
INSERT INTO answers VALUES("13","101","Kiribati Republic","N","00100");
INSERT INTO answers VALUES("13","102","Kuwait","N","00101");
INSERT INTO answers VALUES("13","103","Kyrgystan","N","00102");
INSERT INTO answers VALUES("13","104","Latvia","N","00103");
INSERT INTO answers VALUES("13","105","Lebanon","N","00104");
INSERT INTO answers VALUES("13","106","Liberia","N","00105");
INSERT INTO answers VALUES("13","107","Libya","N","00106");
INSERT INTO answers VALUES("13","108","Liechtenstein","N","00107");
INSERT INTO answers VALUES("13","109","Lithuania","N","00108");
INSERT INTO answers VALUES("13","110","Luxembourg","N","00109");
INSERT INTO answers VALUES("13","111","Macao","N","00110");
INSERT INTO answers VALUES("13","112","Macedonia","N","00111");
INSERT INTO answers VALUES("13","113","Madagascar","N","00112");
INSERT INTO answers VALUES("13","114","Malawi","N","00113");
INSERT INTO answers VALUES("13","115","Malaysia","N","00114");
INSERT INTO answers VALUES("13","116","Maldives","N","00115");
INSERT INTO answers VALUES("13","117","Mali","N","00116");
INSERT INTO answers VALUES("13","118","Malta","N","00117");
INSERT INTO answers VALUES("13","119","Marshall Islands","N","00118");
INSERT INTO answers VALUES("13","120","Martinique","N","00119");
INSERT INTO answers VALUES("13","121","Mauritania","N","00120");
INSERT INTO answers VALUES("13","122","Mauritius","N","00121");
INSERT INTO answers VALUES("13","123","Mexico","N","00122");
INSERT INTO answers VALUES("13","124","Micronesia","N","00123");
INSERT INTO answers VALUES("13","125","Moldova","N","00124");
INSERT INTO answers VALUES("13","126","Monaco","N","00125");
INSERT INTO answers VALUES("13","127","Mongolia","N","00126");
INSERT INTO answers VALUES("13","128","Morocco","N","00127");
INSERT INTO answers VALUES("13","129","Mozambique","N","00128");
INSERT INTO answers VALUES("13","130","Myanmar","N","00129");
INSERT INTO answers VALUES("13","131","Namibia","N","00130");
INSERT INTO answers VALUES("13","132","Nauru","N","00131");
INSERT INTO answers VALUES("13","133","Nepal","N","00132");
INSERT INTO answers VALUES("13","134","Netherlands","N","00133");
INSERT INTO answers VALUES("13","135","Netherlands Antilles","N","00134");
INSERT INTO answers VALUES("13","136","New Caledonia","N","00135");
INSERT INTO answers VALUES("13","137","New Zealand","N","00136");
INSERT INTO answers VALUES("13","138","Nicaragua","N","00137");
INSERT INTO answers VALUES("13","139","Niger","N","00138");
INSERT INTO answers VALUES("13","140","Nigeria","N","00139");
INSERT INTO answers VALUES("13","141","Niue","N","00140");
INSERT INTO answers VALUES("13","142","North Mariana Islands","N","00141");
INSERT INTO answers VALUES("13","143","Norway","N","00142");
INSERT INTO answers VALUES("13","144","Oman","N","00143");
INSERT INTO answers VALUES("13","145","Pakistan","N","00144");
INSERT INTO answers VALUES("13","146","Palau","N","00145");
INSERT INTO answers VALUES("13","147","Panama","N","00146");
INSERT INTO answers VALUES("13","148","Papua New Guinea","N","00147");
INSERT INTO answers VALUES("13","149","Paraguay","N","00148");
INSERT INTO answers VALUES("13","150","Ppl Democratic Rep. of Yemen","N","00149");
INSERT INTO answers VALUES("13","151","Peru","N","00150");
INSERT INTO answers VALUES("13","152","Philippines","N","00151");
INSERT INTO answers VALUES("13","153","Poland","N","00152");
INSERT INTO answers VALUES("13","154","Portugal","N","00153");
INSERT INTO answers VALUES("13","155","Qatar","N","00154");
INSERT INTO answers VALUES("13","156","Republic of North Korea","N","00155");
INSERT INTO answers VALUES("13","157","Republic of South Korea","N","00156");
INSERT INTO answers VALUES("13","158","Romania","N","00157");
INSERT INTO answers VALUES("13","159","Russia","N","00158");
INSERT INTO answers VALUES("13","160","Rwanda","N","00159");
INSERT INTO answers VALUES("13","161","San Marino","N","00160");
INSERT INTO answers VALUES("13","162","Sao Tome and Principe","N","00161");
INSERT INTO answers VALUES("13","163","Saudi Arabia","N","00162");
INSERT INTO answers VALUES("13","164","Senegal","N","00163");
INSERT INTO answers VALUES("13","165","Serbia","N","00164");
INSERT INTO answers VALUES("13","166","Seychelles","N","00165");
INSERT INTO answers VALUES("13","167","Sierra Leone","N","00166");
INSERT INTO answers VALUES("13","168","Singapore","N","00167");
INSERT INTO answers VALUES("13","169","Slovakia","N","00168");
INSERT INTO answers VALUES("13","170","Solomon Islands","N","00169");
INSERT INTO answers VALUES("13","171","Somalia","N","00170");
INSERT INTO answers VALUES("13","172","South Africa","N","00171");
INSERT INTO answers VALUES("13","173","Spain","N","00172");
INSERT INTO answers VALUES("13","174","Sri Lanka","N","00173");
INSERT INTO answers VALUES("13","175","St. Helena","N","00174");
INSERT INTO answers VALUES("13","176","St. Pierre and Miquelon","N","00175");
INSERT INTO answers VALUES("13","177","Sudan","N","00176");
INSERT INTO answers VALUES("13","178","Suriname","N","00177");
INSERT INTO answers VALUES("13","179","Swaziland","N","00178");
INSERT INTO answers VALUES("13","180","Sweden","N","00179");
INSERT INTO answers VALUES("13","181","Switzerland","N","00180");
INSERT INTO answers VALUES("13","182","Syrian Arab Republic","N","00181");
INSERT INTO answers VALUES("13","183","Taiwan","N","00182");
INSERT INTO answers VALUES("13","184","Tajikistan","N","00183");
INSERT INTO answers VALUES("13","185","Tanzania","N","00184");
INSERT INTO answers VALUES("13","186","Thailand","N","00185");
INSERT INTO answers VALUES("13","187","Tokelau","N","00186");
INSERT INTO answers VALUES("13","188","Tonga","N","00187");
INSERT INTO answers VALUES("13","189","Trinidad and Tobago","N","00188");
INSERT INTO answers VALUES("13","190","Tunisia","N","00189");
INSERT INTO answers VALUES("13","191","Turkey","N","00190");
INSERT INTO answers VALUES("13","192","Turkmenistan","N","00191");
INSERT INTO answers VALUES("13","193","Tuvalu","N","00192");
INSERT INTO answers VALUES("13","194","Uganda","N","00193");
INSERT INTO answers VALUES("13","195","Ukraine","N","00194");
INSERT INTO answers VALUES("13","196","United Arab Emirates","N","00195");
INSERT INTO answers VALUES("13","197","United Kingdom","N","00196");
INSERT INTO answers VALUES("13","198","Uruguay","N","00197");
INSERT INTO answers VALUES("13","199","USA","N","00198");
INSERT INTO answers VALUES("13","200","Uzbekistan","N","00199");
INSERT INTO answers VALUES("13","201","Vanuatu","N","00200");
INSERT INTO answers VALUES("13","202","Venezuela","N","00201");
INSERT INTO answers VALUES("13","203","Viet Nam","N","00202");
INSERT INTO answers VALUES("13","204","Wallis and Futuna","N","00203");
INSERT INTO answers VALUES("13","205","Western Samoa","N","00204");
INSERT INTO answers VALUES("13","206","Yemen Arab Republic","N","00205");
INSERT INTO answers VALUES("13","207","Zaire","N","00206");
INSERT INTO answers VALUES("13","208","Zambia","N","00207");
INSERT INTO answers VALUES("13","209","Zimbabwe","N","00208");
INSERT INTO answers VALUES("18","1","Dial-Up Line (Slow)","N","00000");
INSERT INTO answers VALUES("18","2","Broadband (Fast)","N","00001");
INSERT INTO answers VALUES("2","3","Ashtanga (Power) ","N","00002");
INSERT INTO answers VALUES("2","4","Iyengar","N","00003");
INSERT INTO answers VALUES("2","2","Vinyasa","N","00001");
INSERT INTO answers VALUES("24","1","PayPal (Click <a href=https://www.paypal.com/row/mrb/pal=YM8VGWGFV5VBA target=_new>Here</a> to apply)","N","00000");
INSERT INTO answers VALUES("24","2","Western Union","N","00001");
INSERT INTO answers VALUES("2","5","Kundalini","N","00004");
INSERT INTO answers VALUES("2","6","Bikram","N","00005");



#------------------------------------------
# Table definition for assessments
#------------------------------------------

CREATE TABLE assessments (
    id int(11) NOT NULL auto_increment,
    sid int(11) DEFAULT '0' NOT NULL,
    scope varchar(5) NOT NULL,
    gid int(11) DEFAULT '0' NOT NULL,
    name text NOT NULL,
    minimum varchar(50) NOT NULL,
    maximum varchar(50) NOT NULL,
    message text NOT NULL,
    link text NOT NULL,
   PRIMARY KEY (id)
);


#------------------------------------------
# Table data for assessments
#------------------------------------------



#------------------------------------------
# Table definition for conditions
#------------------------------------------

CREATE TABLE conditions (
    cid int(11) NOT NULL auto_increment,
    qid int(11) DEFAULT '0' NOT NULL,
    cqid int(11) DEFAULT '0' NOT NULL,
    cfieldname varchar(50) NOT NULL,
    method char(2) NOT NULL,
    value varchar(5) NOT NULL,
   PRIMARY KEY (cid)
);


#------------------------------------------
# Table data for conditions
#------------------------------------------
INSERT INTO conditions VALUES("1","4","1","1X1X1","","2");



#------------------------------------------
# Table definition for groups
#------------------------------------------

CREATE TABLE groups (
    gid int(11) NOT NULL auto_increment,
    sid int(11) DEFAULT '0' NOT NULL,
    group_name varchar(100) NOT NULL,
    description text,
   PRIMARY KEY (gid)
);


#------------------------------------------
# Table data for groups
#------------------------------------------
INSERT INTO groups VALUES("1","1","A) Welcome!","There are a total of 4 sections in this interview. This is part one.");
INSERT INTO groups VALUES("2","1","C) About Yourself","Tell us a little more about yourself so as to help us in the selection process.");
INSERT INTO groups VALUES("3","1","B) Submit a short article","Write a short article on a Yoga topic which you are most familar with. Write in a casual tone as though you are sharing with a group of friends on the internet. The article must be at least 300 words in length. 
\n
\nPlease pay attention to your grammar. We will base our selection largely on the quality of this article and it\'s creativity. Work must be original. DO NOT attempt to copy from other work from the internet. (We have technology to check)");
INSERT INTO groups VALUES("4","1","D) Final Thoughts","");



#------------------------------------------
# Table definition for labels
#------------------------------------------

CREATE TABLE labels (
    lid int(11) DEFAULT '0' NOT NULL,
    code varchar(5) NOT NULL,
    title varchar(50) NOT NULL,
    sortorder varchar(5)
);


#------------------------------------------
# Table data for labels
#------------------------------------------



#------------------------------------------
# Table definition for labelsets
#------------------------------------------

CREATE TABLE labelsets (
    lid int(11) NOT NULL auto_increment,
    label_name varchar(100) NOT NULL,
   PRIMARY KEY (lid)
);


#------------------------------------------
# Table data for labelsets
#------------------------------------------
INSERT INTO labelsets VALUES("1","test");



#------------------------------------------
# Table definition for old_1_200605251238
#------------------------------------------

CREATE TABLE old_1_200605251238 (
    id bigint(11) NOT NULL auto_increment,
    token varchar(10),
    datestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   UNIQUE id (id)
);


#------------------------------------------
# Table data for old_1_200605251238
#------------------------------------------



#------------------------------------------
# Table definition for old_tokens_1_200605251238
#------------------------------------------

CREATE TABLE old_tokens_1_200605251238 (
    tid int(11) NOT NULL auto_increment,
    firstname varchar(40),
    lastname varchar(40),
    email varchar(100),
    token varchar(10),
    sent char(1) DEFAULT 'N',
    completed char(1) DEFAULT 'N',
    attribute_1 varchar(100),
    attribute_2 varchar(100),
    mpid int(11),
   PRIMARY KEY (tid),
   KEY token (token)
);


#------------------------------------------
# Table data for old_tokens_1_200605251238
#------------------------------------------



#------------------------------------------
# Table definition for question_attributes
#------------------------------------------

CREATE TABLE question_attributes (
    qaid int(11) NOT NULL auto_increment,
    qid int(11) DEFAULT '0' NOT NULL,
    attribute varchar(50),
    value varchar(20),
   PRIMARY KEY (qaid)
);


#------------------------------------------
# Table data for question_attributes
#------------------------------------------



#------------------------------------------
# Table definition for questions
#------------------------------------------

CREATE TABLE questions (
    qid int(11) NOT NULL auto_increment,
    sid int(11) DEFAULT '0' NOT NULL,
    gid int(11) DEFAULT '0' NOT NULL,
    type char(1) DEFAULT 'T' NOT NULL,
    title varchar(20) NOT NULL,
    question text NOT NULL,
    preg text,
    help text,
    other char(1) DEFAULT 'N' NOT NULL,
    mandatory char(1),
    lid int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (qid)
);


#------------------------------------------
# Table data for questions
#------------------------------------------
INSERT INTO questions VALUES("1","1","1","M","1","What type of yogi|ni are you?
\n 
\n","","","N","Y","1");
INSERT INTO questions VALUES("2","1","1","M","2","What style of yoga do you practice?","","","Y","Y","1");
INSERT INTO questions VALUES("3","1","1","!","3","How long have you been practicing yoga? 
\n 
\n","","","N","Y","0");
INSERT INTO questions VALUES("4","1","1","!","3a","As a Yoga Instructor/Trainer, how many years have you been teaching? 
\n 
\n 
\n","","","N","Y","0");
INSERT INTO questions VALUES("5","1","1","!","4","How often do you practice yoga? 
\n 
\n","","","N","Y","0");
INSERT INTO questions VALUES("6","1","1","!","5","How long is your usual yoga session?","","","N","Y","1");
INSERT INTO questions VALUES("7","1","1","!","6","How many instructional yoga books, CD/DVDs and videos do you own? ","","","N","Y","1");
INSERT INTO questions VALUES("8","1","1","M","7","What do you search for on the internet about Yoga?
\n 
\n","","","Y","Y","1");
INSERT INTO questions VALUES("9","1","2","L","1","Gender","","","N","Y","0");
INSERT INTO questions VALUES("10","1","2","!","2","Age Group","","","N","Y","0");
INSERT INTO questions VALUES("13","1","2","!","3","Where are you located?","","","N","Y","0");
INSERT INTO questions VALUES("14","1","2","N","4","How many hours can you work online per WEEK? (Estimate total hours in a 7-day week)","","","N","Y","0");
INSERT INTO questions VALUES("15","1","2","T","5","Being a creative write on Yoga, which topics do you think you can contribute most? (Please elaborate below)","","","N","Y","0");
INSERT INTO questions VALUES("16","1","2","Y","6","Do you have access to a digital camera to take photos of Yogi|nis poses? (either of yourself or others)","","","N","Y","0");
INSERT INTO questions VALUES("17","1","2","Y","7","Do you have access to a digital camera which can take short video clips of yoga practices?","","","N","Y","1");
INSERT INTO questions VALUES("18","1","2","L","8","What type of internet connection do you have access to?","","","N","Y","0");
INSERT INTO questions VALUES("19","1","3","S","1","Title or Topic","","","N","Y","0");
INSERT INTO questions VALUES("20","1","3","U","2","Original article of at least 300 words in length. The longer the better.","","","N","Y","1");
INSERT INTO questions VALUES("21","1","4","T","1","Tell us in one or two paragraph why should we assign the creative writing job to you? (You can highlight your strength, knowledge, etc.)","","","N","Y","0");
INSERT INTO questions VALUES("22","1","4","S","2","First Name and Last Name","","","N","Y","0");
INSERT INTO questions VALUES("23","1","4","S","3","Primary Email (Please double check!)","","","N","Y","1");
INSERT INTO questions VALUES("24","1","2","L","4a","How do you like us to pay you?","","","Y","Y","0");



#------------------------------------------
# Table definition for saved
#------------------------------------------

CREATE TABLE saved (
    saved_id int(11) NOT NULL auto_increment,
    scid int(11) DEFAULT '0' NOT NULL,
    datestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    fieldname text NOT NULL,
    value text NOT NULL,
   PRIMARY KEY (saved_id)
);


#------------------------------------------
# Table data for saved
#------------------------------------------



#------------------------------------------
# Table definition for saved_control
#------------------------------------------

CREATE TABLE saved_control (
    scid int(11) NOT NULL auto_increment,
    sid int(11) DEFAULT '0' NOT NULL,
    identifier text NOT NULL,
    access_code text NOT NULL,
    email varchar(200),
    ip text NOT NULL,
    saved_thisstep text NOT NULL,
    status char(1) NOT NULL,
    saved_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (scid)
);


#------------------------------------------
# Table data for saved_control
#------------------------------------------



#------------------------------------------
# Table definition for surveys
#------------------------------------------

CREATE TABLE surveys (
    sid int(11) NOT NULL auto_increment,
    short_title varchar(200) NOT NULL,
    description text,
    admin varchar(50),
    active char(1) DEFAULT 'N' NOT NULL,
    welcome text,
    expires date,
    adminemail varchar(100),
    private char(1),
    faxto varchar(20),
    format char(1),
    template varchar(100) DEFAULT 'default',
    url varchar(255),
    urldescrip varchar(255),
    language varchar(50),
    datestamp char(1) DEFAULT 'N',
    usecookie char(1) DEFAULT 'N',
    notification char(1) DEFAULT '0',
    allowregister char(1) DEFAULT 'N',
    attribute1 varchar(255),
    attribute2 varchar(255),
    email_invite_subj varchar(255),
    email_invite text,
    email_remind_subj varchar(255),
    email_remind text,
    email_register_subj varchar(255),
    email_register text,
    email_confirm_subj varchar(255),
    email_confirm text,
    allowsave char(1) DEFAULT 'Y',
    autonumber_start bigint(11) DEFAULT '0',
    autoredirect char(1) DEFAULT 'N',
    allowprev char(1) DEFAULT 'Y',
   PRIMARY KEY (sid)
);


#------------------------------------------
# Table data for surveys
#------------------------------------------
INSERT INTO surveys VALUES("1","Creative & Passionate Writers Wanted!","<p>We are in the process of developing a revolutionary website for Yogi|nis around the world. 
\n<p>
\nIn an effort to make this website better and closer to what Yogi|nis would like to see, we are seeking people globally to be a part of this venture. 
\n
\n<p>
\nYour role as a creative writer is to contribute regularly to the content of this website and interact with the members socially. 
\n
\n
\n","Christine Dignam","N","This is a part-time online work and you\'ll be paid based on milestones and NOT hourly rate. If you qualify, we\'ll be in contact with you for further negotiation on job schedule and payment. 
\n
\n<p>
\nPlease answer ALL questions below (unless marked OPTIONAL). 
\n
\n<p>
\nGood Luck with your application!
\n
\n<p>
\nHuman Resource Management,<br>
\nYoga-Discipline.com
\n<br>
\n<img src=http://www.yoga-discipline.com/images/yoga-discipline.gif>
\n
\n<br />","0000-00-00","yogaecom@yoga-discipline.com","N","","G","eirenicon","http://www.yoga-discipline.com","Yoga Discipline","english","Y","Y","1","Y","","","Invitation for online interview - Creative Writing Work (Yoga)","Dear {FIRSTNAME},
\n
\nYou have been invited to participate in an interview.
\n
\nThe interview is titled:
\n\\\"{SURVEYNAME}\\\"
\n
\n\\\"{SURVEYDESCRIPTION}\\\"
\n
\nTo participate, please click on the link below.
\n
\nSincerely,
\n
\n{ADMINNAME} ({ADMINEMAIL})
\n
\n----------------------------------------------
\nClick here to perform the interview:
\n{SURVEYURL}","Reminder to participate in interview","Dear {FIRSTNAME},
\n
\nRecently we invited you to participate in an online interview.
\n
\nWe note that you have not yet completed the interview, and wish to remind you that the interviewis still available should you wish to take part.
\n
\nThe interview is titled:
\n\\\"{SURVEYNAME}\\\"
\n
\n\\\"{SURVEYDESCRIPTION}\\\"
\n
\nTo participate, please click on the link below.
\n
\nSincerely,
\n
\n{ADMINNAME} ({ADMINEMAIL})
\n
\n----------------------------------------------
\nClick here to do the interview:
\n{SURVEYURL}","Interview Registration Confirmation","Dear {FIRSTNAME},
\n
\nYou, or someone using your email address, have registered to participate in an online interview titled {SURVEYNAME}.
\n
\nTo complete this interview, click on the following URL:
\n
\n{SURVEYURL}
\n
\nIf you have any questions about this interview, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.","Confirmation of completed interview","Dear {FIRSTNAME},
\n
\nThis email is to confirm that you have completed the interview titled {SURVEYNAME} and your response has been saved. Thank you for participating.
\n
\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.
\n
\nSincerely,
\n
\n{ADMINNAME}","Y","0","Y","Y");



#------------------------------------------
# Table definition for users
#------------------------------------------

CREATE TABLE users (
    user varchar(20) NOT NULL,
    password varchar(20) NOT NULL,
    security varchar(10) NOT NULL
);


#------------------------------------------
# Table data for users
#------------------------------------------
INSERT INTO users VALUES("admin","temp01ye","5");



