-- MySQL dump 9.07
--
-- Host: localhost    Database: MementoPlus_dev
---------------------------------------------------------
-- Server version	4.0.11a-gamma

--
-- Table structure for table 'mplus_assignation'
--

DROP TABLE IF EXISTS mplus_assignation;
CREATE TABLE mplus_assignation (
  user_id int(10) unsigned NOT NULL default '0',
  file_id int(10) unsigned NOT NULL default '0',
  assigned_date bigint(20) NOT NULL default '0',
  PRIMARY KEY  (user_id,file_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_assignation'
--

INSERT INTO mplus_assignation VALUES (2,2,1095948555);
INSERT INTO mplus_assignation VALUES (1,2,1095948555);
INSERT INTO mplus_assignation VALUES (1,8,1096020661);
INSERT INTO mplus_assignation VALUES (2,5,1096027822);
INSERT INTO mplus_assignation VALUES (1,5,1096027822);

--
-- Table structure for table 'mplus_attachment'
--

DROP TABLE IF EXISTS mplus_attachment;
CREATE TABLE mplus_attachment (
  attachment_id int(10) unsigned NOT NULL default '0',
  bug_id int(10) unsigned NOT NULL default '0',
  file_name char(255) NOT NULL default '',
  description char(255) NOT NULL default '',
  file_size bigint(20) unsigned NOT NULL default '0',
  mime_type char(30) NOT NULL default '',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (attachment_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_attachment'
--


--
-- Table structure for table 'mplus_attachment_seq'
--

DROP TABLE IF EXISTS mplus_attachment_seq;
CREATE TABLE mplus_attachment_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_attachment_seq'
--

INSERT INTO mplus_attachment_seq VALUES (4);

--
-- Table structure for table 'mplus_auth_group'
--

DROP TABLE IF EXISTS mplus_auth_group;
CREATE TABLE mplus_auth_group (
  group_id int(10) unsigned NOT NULL default '0',
  group_name varchar(80) NOT NULL default '',
  locked tinyint(1) unsigned NOT NULL default '0',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  last_modified_by int(10) unsigned NOT NULL default '0',
  last_modified_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (group_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_auth_group'
--

INSERT INTO mplus_auth_group VALUES (1,'Admin',1,0,0,0,0);
INSERT INTO mplus_auth_group VALUES (2,'User',1,0,0,0,0);

--
-- Table structure for table 'mplus_auth_group_seq'
--

DROP TABLE IF EXISTS mplus_auth_group_seq;
CREATE TABLE mplus_auth_group_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_auth_group_seq'
--

INSERT INTO mplus_auth_group_seq VALUES (2);

--
-- Table structure for table 'mplus_auth_perm'
--

DROP TABLE IF EXISTS mplus_auth_perm;
CREATE TABLE mplus_auth_perm (
  perm_id int(10) unsigned NOT NULL default '0',
  perm_name varchar(80) NOT NULL default '',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  last_modified_by int(10) unsigned NOT NULL default '0',
  last_modified_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (perm_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_auth_perm'
--

INSERT INTO mplus_auth_perm VALUES (1,'Admin',0,0,0,0);
INSERT INTO mplus_auth_perm VALUES (2,'Editbug',0,0,0,0);

--
-- Table structure for table 'mplus_auth_user'
--

DROP TABLE IF EXISTS mplus_auth_user;
CREATE TABLE mplus_auth_user (
  user_id int(10) unsigned NOT NULL default '0',
  login varchar(40) NOT NULL default '',
  first_name varchar(40) NOT NULL default '',
  last_name varchar(40) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  password varchar(40) NOT NULL default '',
  active tinyint(3) unsigned NOT NULL default '1',
  bug_list_fields text NOT NULL,
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  last_modified_by int(10) unsigned NOT NULL default '0',
  last_modified_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id),
  UNIQUE KEY login (login)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_auth_user'
--

INSERT INTO mplus_auth_user VALUES (1,'david.han-sze-chuen@airliquide.com','System','Admin','david.han-sze-chuen@airliquide.com','172522ec1028ab781d9dfd17eaca4427',1,'',0,0,0,0);
INSERT INTO mplus_auth_user VALUES (2,'beta.testeur@airliquide.com','beta','testeur','beta.testeur@airliquide.com','098f6bcd4621d373cade4e832627b4f6',1,'',1,1095946200,1,1095946200);

--
-- Table structure for table 'mplus_auth_user_seq'
--

DROP TABLE IF EXISTS mplus_auth_user_seq;
CREATE TABLE mplus_auth_user_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_auth_user_seq'
--

INSERT INTO mplus_auth_user_seq VALUES (2);

--
-- Table structure for table 'mplus_bug_dependency'
--

DROP TABLE IF EXISTS mplus_bug_dependency;
CREATE TABLE mplus_bug_dependency (
  bug_id int(10) unsigned NOT NULL default '0',
  depends_on int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (bug_id,depends_on)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_bug_dependency'
--

INSERT INTO mplus_bug_dependency VALUES (1,2);

--
-- Table structure for table 'mplus_bug_vote'
--

DROP TABLE IF EXISTS mplus_bug_vote;
CREATE TABLE mplus_bug_vote (
  user_id int(10) unsigned NOT NULL default '0',
  bug_id int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id,bug_id),
  KEY bug_id (bug_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_bug_vote'
--


--
-- Table structure for table 'mplus_comment'
--

DROP TABLE IF EXISTS mplus_comment;
CREATE TABLE mplus_comment (
  comment_id int(10) unsigned NOT NULL default '0',
  bug_id int(10) unsigned NOT NULL default '0',
  comment_text text NOT NULL,
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (comment_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_comment'
--

INSERT INTO mplus_comment VALUES (1,1,'Status Opened : \n a',1,1095870376);
INSERT INTO mplus_comment VALUES (2,1,'closed : \n close',1,1095929839);
INSERT INTO mplus_comment VALUES (12,3,'Status Opened : \n ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\'',1,1095932440);
INSERT INTO mplus_comment VALUES (13,3,'Status Opened : \n \\n',1,1095932466);
INSERT INTO mplus_comment VALUES (14,3,'Status Opened : \n \\n',1,1095932598);
INSERT INTO mplus_comment VALUES (15,7,'Description de la fiche :\nceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\' ',1,1095940990);
INSERT INTO mplus_comment VALUES (16,4,'Status Opened : \n test',1,1095946234);
INSERT INTO mplus_comment VALUES (17,4,'Status Opened : \n aaa',1,1095946516);
INSERT INTO mplus_comment VALUES (18,1,'Status Opened : \n cool',1,1096018084);
INSERT INTO mplus_comment VALUES (19,1,'closed : \n arar',1,1096018205);
INSERT INTO mplus_comment VALUES (20,1,'closed : \n test 1',1,1096018764);
INSERT INTO mplus_comment VALUES (21,1,'closed : \n test 1',1,1096018824);
INSERT INTO mplus_comment VALUES (22,1,'closed : \n test 2',1,1096018868);
INSERT INTO mplus_comment VALUES (23,8,'Status Opened : \n test',1,1096019021);
INSERT INTO mplus_comment VALUES (24,5,'closed : \n changement d\'état\r\n   et \r\nréaffectation.',1,1096027059);
INSERT INTO mplus_comment VALUES (25,5,'closed : \n aaa',1,1096027603);
INSERT INTO mplus_comment VALUES (26,5,'Status Opened : \n bouge',1,1096027643);
INSERT INTO mplus_comment VALUES (27,5,'closed : \n aaa',1,1096027717);
INSERT INTO mplus_comment VALUES (28,5,'Status Opened : \n é',1,1096027742);
INSERT INTO mplus_comment VALUES (29,5,'closed : \n fermé',1,1096027756);
INSERT INTO mplus_comment VALUES (30,5,'Status Opened : \n azeaze',1,1096027822);
INSERT INTO mplus_comment VALUES (31,1,'etat 3 : \n abc coucou & d  \"  é \' \\n a^ :)',1,1096363978);
INSERT INTO mplus_comment VALUES (32,1,'Status Opened : \n aa',1,1096364089);

--
-- Table structure for table 'mplus_comment_seq'
--

DROP TABLE IF EXISTS mplus_comment_seq;
CREATE TABLE mplus_comment_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_comment_seq'
--

INSERT INTO mplus_comment_seq VALUES (32);

--
-- Table structure for table 'mplus_configuration'
--

DROP TABLE IF EXISTS mplus_configuration;
CREATE TABLE mplus_configuration (
  varname char(40) NOT NULL default '',
  varvalue char(255) NOT NULL default '',
  description char(255) NOT NULL default '',
  vartype char(20) NOT NULL default '',
  PRIMARY KEY  (varname),
  UNIQUE KEY no_duo (varname,varvalue)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_configuration'
--

INSERT INTO mplus_configuration VALUES ('INSTALL_URL','http://etude58/MementoTest/memplus_dev','The base URL of the M+ installation','string');
INSERT INTO mplus_configuration VALUES ('JPGRAPH_PATH','/var/www/html/jpgraph/src/','If not in the include path.  This is the file path on the web server, not a URL.','string');
INSERT INTO mplus_configuration VALUES ('CVS_WEB','http://etude37/cgi-bin/cvsweb.cgi','Location of your cvs web interface (see format_comments() in bug.php)','string');
INSERT INTO mplus_configuration VALUES ('ADMIN_EMAIL','david.han-sze-chuen@airliquide.com','The email address used in correspondence from the file tracker','string');
INSERT INTO mplus_configuration VALUES ('ENCRYPT_PASS','1','Whether to store passwords encrypted.  <b>Warning:</b> Changing this after users have been created will result in their being unable to login.','bool');
INSERT INTO mplus_configuration VALUES ('USE_JPGRAPH','0','Whether to show some reports as images','bool');
INSERT INTO mplus_configuration VALUES ('MASK_EMAIL','1','Should email addresses have the @domainName hidden ?','bool');
INSERT INTO mplus_configuration VALUES ('HIDE_EMAIL','0','Should email addresses be hidden for those not logged in?','bool');
INSERT INTO mplus_configuration VALUES ('USE_SEVERITY_COLOR','1','Should the query list use the severity colors as the row background color (like SourceForge)','bool');
INSERT INTO mplus_configuration VALUES ('EMAIL_IS_LOGIN','1','Whether to use email addresses as logins','bool');
INSERT INTO mplus_configuration VALUES ('STRICT_UPDATING','1','Only the bug reporter, bug owner, managers, and admins can change a bug','bool');
INSERT INTO mplus_configuration VALUES ('NEW_ACCOUNTS_DISABLED','0','Only admins can create new user accounts - newaccount.php is disabled','bool');
INSERT INTO mplus_configuration VALUES ('RECALL_LOGIN','1','Enable use of cookies to store username between logins','bool');
INSERT INTO mplus_configuration VALUES ('SHOW_PROJECT_SUMMARIES','1','Itemize bug stats by project on the home page','bool');
INSERT INTO mplus_configuration VALUES ('FORCE_LOGIN','0','Force users to login before being able to use the bug tracker','bool');
INSERT INTO mplus_configuration VALUES ('PROMOTE_VOTES','0','The number of votes required to promote a bug from Unconfirmed to New (Set to 0 to disable promotions by voting)','string');
INSERT INTO mplus_configuration VALUES ('MAX_USER_VOTES','0','The maximum number of votes a user can cast across all bugs (Set to 0 to have no limit)','string');
INSERT INTO mplus_configuration VALUES ('ATTACHMENT_PATH','attachments','Sub-dir of the INSTALLPATH - Needs to be writeable by the web process','string');
INSERT INTO mplus_configuration VALUES ('THEME','taema','Which set of templates to use','multi');
INSERT INTO mplus_configuration VALUES ('ATTACHMENT_MAX_SIZE','2097152','Maximum size (in bytes) of an attachment. This will not override the settings in php.ini if php.ini has a lower limit.','string');
INSERT INTO mplus_configuration VALUES ('DATE_FORMAT','d/m/Y','See the <a href=\"http://www.php.net/date\" target=\"_new\">date page</a> in the PHP manual for more info','string');
INSERT INTO mplus_configuration VALUES ('TIME_FORMAT','H:i','See the <a href=\"http://www.php.net/date\" target=\"_new\">date page</a> in the PHP manual for more info','string');
INSERT INTO mplus_configuration VALUES ('LANGUAGE','fr','The language file to use for warning and error messages','multi');
INSERT INTO mplus_configuration VALUES ('STYLE','default','The CSS file to use (color scheme)','multi');
INSERT INTO mplus_configuration VALUES ('SEND_MIME_EMAIL','1','Whether to use MIME quoted-printable encoded emails or not','bool');
INSERT INTO mplus_configuration VALUES ('DEFAULT_SESSION_COOKIE_PATH','','Determines to what extent the session applies on the web server. Default value is \"/\". <br>For example, if it is <i>\"/my_site_folder/\"</i>. It means that the session applies to every php script using session in that folder (or subfolder).','string');
INSERT INTO mplus_configuration VALUES ('IS_CLONE','0','Wether this website is a clone of a Memento Plus application. <br>True : this website won\'t accept any modification on any file or project.<br>False : normal use <i>(default)</i>','bool');
INSERT INTO mplus_configuration VALUES ('PUBLICFIELDS_PROJECT_NAME','_PUBLIC','The name of the project which holds the public fields','string');
INSERT INTO mplus_configuration VALUES ('DATE_FORMAT_DETAILED','d/m/Y H:i','The date format used in file edition. <br>See the <a href=\"http://www.php.net/date\" target=\"_new\">date page</a> in the PHP manual for more info','string');
INSERT INTO mplus_configuration VALUES ('PRIMARY_LOGO','images/new_title.bmp','The image at the top left corner of Memento Plus. Visible for all users.','string');
INSERT INTO mplus_configuration VALUES ('ADMIN_LOGO','images/admin_title.bmp','The image at the top left corner of Memento Plus. Visible in the administration pages.','string');
INSERT INTO mplus_configuration VALUES ('KEY_WORD_SEPARATOR',',','This is the key word separator to use in the search form.','string');
INSERT INTO mplus_configuration VALUES ('MAX_FILES_PER_PAGE','10','The max number of files to print per page of files.','string');
INSERT INTO mplus_configuration VALUES ('DEFAULT_TEXT_SIZE','40','The default length of a text box in the file edit form and search form.','string');

--
-- Table structure for table 'mplus_contacts'
--

DROP TABLE IF EXISTS mplus_contacts;
CREATE TABLE mplus_contacts (
  bug_id int(10) unsigned NOT NULL default '0',
  user_id int(10) unsigned NOT NULL default '0',
  subscribed tinyint(4) NOT NULL default '0',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (bug_id,user_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_contacts'
--

INSERT INTO mplus_contacts VALUES (1,2,0,1,1096363028);

--
-- Table structure for table 'mplus_field_conf'
--

DROP TABLE IF EXISTS mplus_field_conf;
CREATE TABLE mplus_field_conf (
  field_conf_id int(10) unsigned NOT NULL auto_increment,
  project_id int(10) unsigned NOT NULL default '0',
  field_type_id int(10) unsigned NOT NULL default '0',
  field_name varchar(128) NOT NULL default '',
  title varchar(255) NOT NULL default '',
  description text NOT NULL,
  edit_order tinyint(3) unsigned NOT NULL default '0',
  list_order tinyint(3) unsigned NOT NULL default '0',
  default_value text NOT NULL,
  properties varchar(255) NOT NULL default '',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  last_modified_by int(10) unsigned NOT NULL default '0',
  last_modified_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (field_conf_id),
  UNIQUE KEY Index_no_redundant_field (project_id,field_name)
) TYPE=MyISAM ROW_FORMAT=FIXED COMMENT='Defines the various fields of a file';

--
-- Dumping data for table 'mplus_field_conf'
--

INSERT INTO mplus_field_conf VALUES (1,1,2,'title','Title','The title of the file.',7,2,'','maxlen=255;read_only=true;internal_system_use=true;highlight_url=false;',1,0,1,1095685355);
INSERT INTO mplus_field_conf VALUES (2,1,2,'description','Description','The description of the file.',8,3,'','maxlen=0;read_only=true;internal_system_use=true;highlight_url=false;',1,0,1,1095436301);
INSERT INTO mplus_field_conf VALUES (3,1,2,'url','URL','a useful link for the file.',11,4,'','maxlen=255;read_only=false;highlight_url=true;internal_system_use=true;',1,0,1,1094482802);
INSERT INTO mplus_field_conf VALUES (4,1,2,'browser_string','Browser string','Some browser info about the submiter of this file.',100,100,'','maxlen=255;read_only=false;internal_system_use=true;highlight_url=false;',1,0,1,1094482667);
INSERT INTO mplus_field_conf VALUES (7,1,3,'status_id','Status','The status of the file.',9,7,'1','read_only=false;unique=true;internal_system_use=true;',1,0,1,1096301068);
INSERT INTO mplus_field_conf VALUES (11,1,3,'assigned_to','Assignation','People who have to work on the file.',10,11,'0','read_only=false;unique=false;internal_system_use=true;',1,0,1,1095669845);
INSERT INTO mplus_field_conf VALUES (18,1,4,'created_date','Date de création','File creation date.',2,13,'','time_type=date;read_only=yes;internal_system_use=true;',1,0,1,0);
INSERT INTO mplus_field_conf VALUES (19,1,4,'last_modified_date','Last modified date','File last modified date.',4,15,'','read_only=true;internal_system_use=true;time_type=date;',1,0,1,1095351346);
INSERT INTO mplus_field_conf VALUES (20,1,4,'closed_date','Closed date','File closing date.',0,20,'','time_type=date;read_only=yes;internal_system_use=true;',1,0,1,0);
INSERT INTO mplus_field_conf VALUES (21,1,0,'bug_id','File #','File number',5,1,'','int_size=10;read_only=true;internal_system_use=true;',1,0,1,1094482683);
INSERT INTO mplus_field_conf VALUES (22,1,3,'created_by','Created by','Name of the creator of the file',1,12,'','read_only=yes;internal_system_use=true;int_size=10;',1,0,1,0);
INSERT INTO mplus_field_conf VALUES (23,1,3,'last_modified_by','Last modified by','Name of the last modifier of the file',3,14,'','read_only=yes;internal_system_use=true;int_size=10;',1,0,1,0);
INSERT INTO mplus_field_conf VALUES (12,1,3,'project_id','Project','The project to which the file belongs.',6,16,'0','read_only=true;unique=false;internal_system_use=true;',1,0,1,1096036021);
INSERT INTO mplus_field_conf VALUES (24,1,2,'field_24','test_string','',100,100,'','maxlen=0;',1,1095933662,1,1095933662);
INSERT INTO mplus_field_conf VALUES (25,1,3,'field_25','test','ersdf',0,0,'48','',1,1096300432,1,1096300432);
INSERT INTO mplus_field_conf VALUES (26,1,3,'field_26','Special comboBox','aazeaze',80,80,'49','read_only=false;unique=false;',1,1096301385,1,1096362128);
INSERT INTO mplus_field_conf VALUES (27,2,0,'field_27','Specific 1','aaaazeaze',90,90,'10','int_size=10;read_only=false;',1,1096365752,1,1096365873);
INSERT INTO mplus_field_conf VALUES (28,3,0,'field_28','Specific 2','azeaze',90,90,'12','int_size=10;',1,1096365800,1,1096365800);

--
-- Table structure for table 'mplus_field_conf_seq'
--

DROP TABLE IF EXISTS mplus_field_conf_seq;
CREATE TABLE mplus_field_conf_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_field_conf_seq'
--

INSERT INTO mplus_field_conf_seq VALUES (28);

--
-- Table structure for table 'mplus_field_type'
--

DROP TABLE IF EXISTS mplus_field_type;
CREATE TABLE mplus_field_type (
  field_type_id int(10) unsigned NOT NULL default '0',
  field_type_title varchar(128) NOT NULL default '',
  field_type_description varchar(255) NOT NULL default '',
  PRIMARY KEY  (field_type_id),
  UNIQUE KEY title (field_type_title)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_field_type'
--

INSERT INTO mplus_field_type VALUES (0,'Integer','Accepts only an integer value.');
INSERT INTO mplus_field_type VALUES (1,'Float','Accepts only an float value.');
INSERT INTO mplus_field_type VALUES (2,'String','Accepts either a length limited or unlimited string');
INSERT INTO mplus_field_type VALUES (3,'Select box','Allows to select one value of a select box');
INSERT INTO mplus_field_type VALUES (4,'Timestamp','Accepts a date with hour');

--
-- Table structure for table 'mplus_file_history'
--

DROP TABLE IF EXISTS mplus_file_history;
CREATE TABLE mplus_file_history (
  bug_id int(10) unsigned NOT NULL default '0',
  changed_field varchar(255) NOT NULL default '',
  old_value text NOT NULL,
  new_value text NOT NULL,
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_file_history'
--

INSERT INTO mplus_file_history VALUES (1,'URL','http://etude58a','http://etude58',1,1096041311);
INSERT INTO mplus_file_history VALUES (1,'test_string','test string z','test string',1,1096041311);
INSERT INTO mplus_file_history VALUES (1,'Assignation','beta testeur <beta.testeur@airliquide.com>','System Admin <david.han-sze-chuen@airliquide.com>',1,1096041311);
INSERT INTO mplus_file_history VALUES (1,'Assignation','System Admin <david.han-sze-chuen@airliquide.com>','System Admin <david.han-sze-chuen@airliquide.com>\nbeta testeur <beta.testeur@airliquide.com>',1,1096041436);
INSERT INTO mplus_file_history VALUES (1,'File_dependencies','','[-] 2',1,1096043861);
INSERT INTO mplus_file_history VALUES (1,'File_dependencies','','add 2',1,1096043932);
INSERT INTO mplus_file_history VALUES (1,'Contact_list','','add 2',1,1096043932);
INSERT INTO mplus_file_history VALUES (1,'Assignation','System Admin <david.han-sze-chuen@airliquide.com>\nbeta testeur <beta.testeur@airliquide.com>','Personne',1,1096044424);
INSERT INTO mplus_file_history VALUES (1,'File_dependencies','','Ajout d\'une dépendance vers la fiche #1',1,1096044424);
INSERT INTO mplus_file_history VALUES (1,'File_dependencies','','Suppression d\'une dépendance vers la fiche #1',1,1096044609);
INSERT INTO mplus_file_history VALUES (1,'Contact_list','','Suppression de contact(s) :\n beta testeur <beta.testeur@airliquide.com>',1,1096044780);
INSERT INTO mplus_file_history VALUES (1,'Contact_list','','Ajout de contact(s) :\n beta testeur <beta.testeur@airliquide.com>',1,1096044796);
INSERT INTO mplus_file_history VALUES (1,'Contact_list','','Suppression de contact(s) :\n beta testeur <beta.testeur@airliquide.com>',1,1096363016);
INSERT INTO mplus_file_history VALUES (1,'Contact_list','','Ajout de contact(s) :\n beta testeur <beta.testeur@airliquide.com>',1,1096363028);
INSERT INTO mplus_file_history VALUES (1,'Status','closed','53',1,1096363978);
INSERT INTO mplus_file_history VALUES (1,'Status','etat 3','1',1,1096364089);

--
-- Table structure for table 'mplus_file_index'
--

DROP TABLE IF EXISTS mplus_file_index;
CREATE TABLE mplus_file_index (
  file_id int(10) unsigned NOT NULL default '0',
  project_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (file_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_file_index'
--

INSERT INTO mplus_file_index VALUES (1,2);
INSERT INTO mplus_file_index VALUES (2,3);
INSERT INTO mplus_file_index VALUES (3,3);
INSERT INTO mplus_file_index VALUES (4,3);
INSERT INTO mplus_file_index VALUES (5,3);
INSERT INTO mplus_file_index VALUES (6,3);
INSERT INTO mplus_file_index VALUES (7,3);
INSERT INTO mplus_file_index VALUES (8,2);

--
-- Table structure for table 'mplus_file_index_seq'
--

DROP TABLE IF EXISTS mplus_file_index_seq;
CREATE TABLE mplus_file_index_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_file_index_seq'
--

INSERT INTO mplus_file_index_seq VALUES (8);

--
-- Table structure for table 'mplus_file_prj_id_2'
--

DROP TABLE IF EXISTS mplus_file_prj_id_2;
CREATE TABLE mplus_file_prj_id_2 (
  bug_id int(10) unsigned NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  description text NOT NULL,
  url varchar(255) NOT NULL default '',
  status_id int(10) unsigned NOT NULL default '1',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  last_modified_by int(10) unsigned NOT NULL default '0',
  last_modified_date bigint(20) unsigned NOT NULL default '0',
  browser_string varchar(255) NOT NULL default '',
  closed_date bigint(20) unsigned NOT NULL default '0',
  field_24 text NOT NULL,
  field_25 int(10) unsigned NOT NULL default '48',
  field_26 int(10) unsigned NOT NULL default '49',
  field_27 int(10) NOT NULL default '10',
  PRIMARY KEY  (bug_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_file_prj_id_2'
--

INSERT INTO mplus_file_prj_id_2 VALUES (1,'titre','desc','http://etude58',1,1,1095868453,1,1096364089,'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)',1096018205,'test string',48,49,10);
INSERT INTO mplus_file_prj_id_2 VALUES (8,'title','desc','http://url',1,1,1096018922,1,1096020661,'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)',0,'whoa !!',48,49,10);

--
-- Table structure for table 'mplus_file_prj_id_3'
--

DROP TABLE IF EXISTS mplus_file_prj_id_3;
CREATE TABLE mplus_file_prj_id_3 (
  bug_id int(10) unsigned NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  description text NOT NULL,
  url varchar(255) NOT NULL default '',
  status_id int(10) unsigned NOT NULL default '1',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  last_modified_by int(10) unsigned NOT NULL default '0',
  last_modified_date bigint(20) unsigned NOT NULL default '0',
  browser_string varchar(255) NOT NULL default '',
  closed_date bigint(20) unsigned NOT NULL default '0',
  field_24 text NOT NULL,
  field_25 int(10) unsigned NOT NULL default '48',
  field_26 int(10) unsigned NOT NULL default '49',
  field_28 int(10) NOT NULL default '12',
  PRIMARY KEY  (bug_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_file_prj_id_3'
--

INSERT INTO mplus_file_prj_id_3 VALUES (2,'titre','desc','',1,1,1095869033,1,1095948573,'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)',0,'aaa',48,49,12);
INSERT INTO mplus_file_prj_id_3 VALUES (3,'titre','afokkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkjoazijdoaizjd','',1,1,1095931361,1,1095932598,'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)',0,'',48,49,12);
INSERT INTO mplus_file_prj_id_3 VALUES (4,'ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\'','ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\' ','http://ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\'',1,1,1095940795,1,1095946516,'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)',0,'ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\' ',48,49,12);
INSERT INTO mplus_file_prj_id_3 VALUES (5,'ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\'','ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\' ','http://taema.com',1,1,1095940921,1,1096027822,'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)',1096027756,'abracourcix',48,49,12);
INSERT INTO mplus_file_prj_id_3 VALUES (6,'ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\'','ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\' ','http://ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\'',1,1,1095940971,1,1095940971,'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)',0,'ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\' ',48,49,12);
INSERT INTO mplus_file_prj_id_3 VALUES (7,'ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\'','ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\' ','http://ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\'',1,1,1095940990,1,1095940990,'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)',0,'ceci est un test :) ;é <b> ;a) \\n )a \" w; \' $^ ;)=> && & | \")é=/ - `\\ \\\' ',48,49,12);

--
-- Table structure for table 'mplus_file_status'
--

DROP TABLE IF EXISTS mplus_file_status;
CREATE TABLE mplus_file_status (
  project_status_id int(10) unsigned NOT NULL default '0',
  file_id int(10) unsigned NOT NULL default '0',
  sv_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (project_status_id,file_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_file_status'
--


--
-- Table structure for table 'mplus_group_perm'
--

DROP TABLE IF EXISTS mplus_group_perm;
CREATE TABLE mplus_group_perm (
  group_id int(10) unsigned NOT NULL default '0',
  perm_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (group_id,perm_id),
  KEY perm_id (perm_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_group_perm'
--

INSERT INTO mplus_group_perm VALUES (1,1);
INSERT INTO mplus_group_perm VALUES (2,2);

--
-- Table structure for table 'mplus_project'
--

DROP TABLE IF EXISTS mplus_project;
CREATE TABLE mplus_project (
  project_id int(10) unsigned NOT NULL default '0',
  project_name varchar(30) NOT NULL default '',
  project_desc text NOT NULL,
  active tinyint(1) NOT NULL default '1',
  sequence tinyint(1) NOT NULL default '1',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  last_modified_by int(10) unsigned NOT NULL default '0',
  last_modified_date bigint(20) unsigned NOT NULL default '0',
  file_table_name varchar(128) NOT NULL default '',
  PRIMARY KEY  (project_id),
  UNIQUE KEY unique_project_name (project_name)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_project'
--

INSERT INTO mplus_project VALUES (1,'_PUBLIC','This is a dummy project. The fields defined in field_conf for this project are the public fields.rnThis project is never accessible from the Create file form, even if \'active = true\'rnYou shouldn\'t modify anything here unless you really know what you do.',0,0,0,0,0,0,'');
INSERT INTO mplus_project VALUES (2,'projet 1','description',1,1,1,1095868387,0,0,'mplus_file_prj_id_2');
INSERT INTO mplus_project VALUES (3,'projet 2','desc',1,0,1,1095869007,0,0,'mplus_file_prj_id_3');

--
-- Table structure for table 'mplus_project_group'
--

DROP TABLE IF EXISTS mplus_project_group;
CREATE TABLE mplus_project_group (
  project_id int(10) unsigned NOT NULL default '0',
  group_id int(10) unsigned NOT NULL default '0',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (project_id,group_id),
  KEY group_id (group_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_project_group'
--


--
-- Table structure for table 'mplus_project_perm'
--

DROP TABLE IF EXISTS mplus_project_perm;
CREATE TABLE mplus_project_perm (
  project_id int(10) unsigned NOT NULL default '0',
  user_id int(10) unsigned NOT NULL default '0',
  perm_id int(10) unsigned NOT NULL default '0',
  KEY user_id (user_id,perm_id),
  KEY project_id (project_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_project_perm'
--

INSERT INTO mplus_project_perm VALUES (1,1,1);

--
-- Table structure for table 'mplus_project_seq'
--

DROP TABLE IF EXISTS mplus_project_seq;
CREATE TABLE mplus_project_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_project_seq'
--

INSERT INTO mplus_project_seq VALUES (3);

--
-- Table structure for table 'mplus_project_status'
--

DROP TABLE IF EXISTS mplus_project_status;
CREATE TABLE mplus_project_status (
  project_status_id int(10) unsigned NOT NULL default '0',
  project_id int(10) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (project_status_id),
  KEY Unique_project_title_per_project (project_id,title)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_project_status'
--


--
-- Table structure for table 'mplus_saved_query'
--

DROP TABLE IF EXISTS mplus_saved_query;
CREATE TABLE mplus_saved_query (
  saved_query_id int(10) unsigned NOT NULL default '0',
  user_id int(10) unsigned NOT NULL default '0',
  saved_query_name varchar(40) NOT NULL default '',
  saved_query_string text NOT NULL,
  PRIMARY KEY  (saved_query_id,user_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_saved_query'
--


--
-- Table structure for table 'mplus_selectbox_option'
--

DROP TABLE IF EXISTS mplus_selectbox_option;
CREATE TABLE mplus_selectbox_option (
  option_name enum('reserved','closed') NOT NULL default 'reserved',
  sv_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (option_name,sv_id)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table 'mplus_selectbox_option'
--

INSERT INTO mplus_selectbox_option VALUES ('closed',46);

--
-- Table structure for table 'mplus_selectbox_value'
--

DROP TABLE IF EXISTS mplus_selectbox_value;
CREATE TABLE mplus_selectbox_value (
  sv_id int(10) unsigned NOT NULL default '0',
  field_conf_id int(10) unsigned NOT NULL default '0',
  sv_value varchar(255) NOT NULL default '',
  sv_order tinyint(4) NOT NULL default '0',
  sv_description text NOT NULL,
  PRIMARY KEY  (sv_id)
) TYPE=MyISAM COMMENT='stores the values of a select box defined in FIELD_CONF';

--
-- Dumping data for table 'mplus_selectbox_value'
--

INSERT INTO mplus_selectbox_value VALUES (1,7,'Status Opened',0,'Fiche ouverte');
INSERT INTO mplus_selectbox_value VALUES (46,7,'closed',1,'closed');
INSERT INTO mplus_selectbox_value VALUES (48,25,'Valeur par défaut',1,'Valeur par défaut');
INSERT INTO mplus_selectbox_value VALUES (49,26,'baobab',1,'*Valeur par défaut*');
INSERT INTO mplus_selectbox_value VALUES (50,26,'pin',2,'arbre a pin');
INSERT INTO mplus_selectbox_value VALUES (52,7,'Etat 2',2,'');
INSERT INTO mplus_selectbox_value VALUES (53,7,'etat 3',3,'');

--
-- Table structure for table 'mplus_selectbox_value_seq'
--

DROP TABLE IF EXISTS mplus_selectbox_value_seq;
CREATE TABLE mplus_selectbox_value_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_selectbox_value_seq'
--

INSERT INTO mplus_selectbox_value_seq VALUES (53);

--
-- Table structure for table 'mplus_user_group'
--

DROP TABLE IF EXISTS mplus_user_group;
CREATE TABLE mplus_user_group (
  user_id int(10) unsigned NOT NULL default '0',
  group_id int(10) unsigned NOT NULL default '0',
  created_by int(10) unsigned NOT NULL default '0',
  created_date bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id,group_id),
  KEY group_id (group_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_user_group'
--

INSERT INTO mplus_user_group VALUES (1,1,0,0);
INSERT INTO mplus_user_group VALUES (1,2,0,0);
INSERT INTO mplus_user_group VALUES (2,2,1,1095946200);

--
-- Table structure for table 'mplus_user_pref'
--

DROP TABLE IF EXISTS mplus_user_pref;
CREATE TABLE mplus_user_pref (
  user_id int(11) NOT NULL default '0',
  email_notices tinyint(1) NOT NULL default '1',
  saved_queries tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mplus_user_pref'
--

INSERT INTO mplus_user_pref VALUES (1,1,1);
INSERT INTO mplus_user_pref VALUES (2,1,1);

