9 - Building the admin database
DB information :
File path for DB :/Library/WebServer/Documents/bd/
Scripts for database 'admin_super' :
Loading : 3_0000_data_admin_super.sql
ERROR mysql_execute_multiplerequest : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 12 for request
CREATE TABLE IF NOT EXISTS `administrateurs` ( `adm_id` varchar(45) NOT NULL default '', `adm_nick` varchar(16) NOT NULL default '', `adm_password` varchar(32) NOT NULL default '', `adm_prenom` varchar(16) default NULL, `adm_nom` varchar(16) default NULL, `adm_email` varchar(255) NOT NULL default '', PRIMARY KEY (`adm_id`), KEY `adm_nick` (`adm_nick`), KEY `iadministrateurs_nick` (`adm_id`,`adm_nick`), KEY `iadministrateurs_2nbcol` (`adm_nick`,`adm_password`) ) TYPE=MyISAM;
Link :Resource id #35
ERROR mysql_execute_multiplerequest : Table 'plici.administrateurs' doesn't exist for request
INSERT INTO `administrateurs` (`adm_id`, `adm_nick`, `adm_password`, `adm_prenom`, `adm_nom`, `adm_email`) VALUES ('6453a38b1a745cf0b5dc3b535c4cec9c', 'mustbechange', 'mustbechange', 'Administrateur', 'SimpliciWeb', '
nicolas.s@simpliciweb.net');
Link :Resource id #35
ERROR mysql_execute_multiplerequest : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 12 for request
CREATE TABLE IF NOT EXISTS `databaseconnect` ( `dbc_sitename` varchar(255) NOT NULL default '', `dbc_dbname` varchar(64) NOT NULL default '', `dbc_dblogin` varchar(40) NOT NULL default '', `dbc_dbpass` varchar(40) NOT NULL, `dbc_inherited_sitename` varchar(255) NOT NULL default '', `dbc_ecommerce` enum('Y','N') NOT NULL default 'Y', `dbc_dbhost` varchar(125) NOT NULL default 'localhost', `dbc_available` enum('Y','N') NOT NULL default 'Y', `dbc_group` varchar(64) default NULL, PRIMARY KEY (`dbc_sitename`) ) TYPE=MyISAM;
Link :Resource id #35
ERROR mysql_execute_multiplerequest : Table 'plici.databaseconnect' doesn't exist for request
INSERT INTO `databaseconnect` (`dbc_sitename`, `dbc_dbname`, `dbc_dblogin`, `dbc_dbpass`, `dbc_inherited_sitename`, `dbc_ecommerce`, `dbc_dbhost`, `dbc_available`, `dbc_group`) VALUES ('local-admin_plici_site', 'super_admin', 'ALIAS', 'ALIAS', 'ALIAS', 'Y', 'localhost', 'Y', NULL), ('admin_plici', 'super_admin', 'ALIAS', 'ALIAS', 'ALIAS', 'Y', 'localhost', 'Y', NULL);
Link :Resource id #35
ERROR mysql_execute_multiplerequest : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 5 for request
CREATE TABLE IF NOT EXISTS `internal_mail` ( `ima_key` varchar(40) NOT NULL default '', `ima_value` text NOT NULL, PRIMARY KEY (`ima_key`) ) TYPE=MyISAM;
Link :Resource id #35
ERROR mysql_execute_multiplerequest : Table 'plici.internal_mail' doesn't exist for request
INSERT INTO `internal_mail` (`ima_key`, `ima_value`) VALUES ('RECIPIENTS', '
stephane.t@simpliciweb.net,nicolas.s@simpliciweb.net'), ('METHOD', 'null');
Link :Resource id #35
ERROR mysql_execute_multiplerequest : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=2' at line 6 for request
CREATE TABLE IF NOT EXISTS `t_bo_group` ( `bgr_id` int(10) unsigned NOT NULL auto_increment, `bgr_title` varchar(32) default NULL, `bgr_desc` varchar(255) default NULL, PRIMARY KEY (`bgr_id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ;
Link :Resource id #35