- $EXISTS = $sgbd->table_exists("#--pages");
- if(!isset($EXISTS))
- { return "impossible de savoir si la table #--pages existe";
- }
- if($EXISTS)
- { return "la table #--pages existe deja";
- }
- $sql =
- "CREATE TABLE #--pages"
- ."( id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY"
- .", id_parent INT(11) NULL"
- .", title VARCHAR(255) NULL"
- .", content TEXT NULL"
- .", date_creation DATETIME NOT NULL"
- .", user_creation INT(11) NOT NULL"
- .", date_last_update DATETIME NOT NULL"
- .", user_last_update INT(11) NOT NULL"
- .", enabled TINYINT NOT NULL DEFAULT '1'"
- .", position INT(11) NOT NULL DEFAULT '0'"
- .") DEFAULT CHARSET=utf8";
- if(!$sgbd->query($sql))
- { return "imposible de creer la table #--pages";
- }
- if(!$sgbd->query("INSERT INTO #--action_status(action, id_status) VALUES('pages/admin', 1)"))
- { $sgbd->query("DROP TABLE #--pages");
+ $EXISTS = $sgbd->data_exists("pages");
+ if(!isset($EXISTS)){
+ return "impossible de savoir si la table #--pages existe";
+ }
+ if($EXISTS){
+ return "la table #--pages existe deja";
+ }
+ if(!$sgbd->create_data("pages")){
+ return "imposible de creer la table #--pages";
+ }
+ if(!$sgbd->add_data("actions_roles", array("action" => "pages/admin", "id_role" => "1"))){
+ $sgbd->remove_data("pages");