<?
// init.php
/* initialistation de base de données office            */
/* ---------------------------------------------------- */

include("mysql_func.php");

$MySQL_Host="www.1info.com";
$MySQL_User="httpd";
$MySQL_Passw="httpd";

$lk=connect();
$db="office";

$sql="CREATE TABLE message (
code_msg BIGINT NOT NULL AUTO_INCREMENT,
a_msg  VARCHAR (30) NOT NULL,
date_msg DATE,
mail_msg VARCHAR (50) NOT NULL,
text_msg MEDIUMTEXT NOT NULL,
PRIMARY KEY (code_msg))";

if ($res=send_sql($db, $sql)) {
    echo " Initialisation Office Mengis Raoul V0.1";
    }

?>

$sql= "CREATE TABLE doc (
code_doc BIGINT NOT NULL AUTO_INCREMENT,
group_doc VARCHAR (30) NOT NULL,
intro_doc VARCHAR (255) NOT NULL,
image_doc VARCHAR (60) NOT NULL,
mail_doc VARCHAR (30) NOT NULL,
lang_doc SMALLINT NOT NULL,
count_doc SMALLINT UNSIGNED NOT NULL,
date_doc DATE,
info_doc MEDIUMTEXT NOT NULL,
PRIMARY KEY (code_doc))";

$sql= "CREATE TABLE menu (
        index_menu INT(11) DEFAULT '0' NOT NULL auto_increment,
        menu_menu VARCHAR(50),
        link_menu VARCHAR(50),
        type_menu INT UNSIGNED NOT NULL,
        group_menu TINYINT UNSIGNED NOT NULL,
        level_menu TINYINT UNSIGNED NOT NULL,
        lang_menu TINYINT UNSIGNED NOT NULL,
        rem_menu VARCHAR(50),
        logo_menu VARCHAR(50),
        PRIMARY KEY (index_menu)
)";

$sql="CREATE TABLE contract(
code_contr BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
soc_contr BIGINT NOT NULL,
type_contr SMALLINT NOT NULL,
group_contr TINYINT NOT NULL,
npost_contr SMALLINT NOT NULL,
libele_contr  VARCHAR (256) NOT NULL,
rem_contr VARCHAR (256) NOT NULL,
prix_contr DECIMAL(6,2),
vend_contr VARCHAR (20) NOT NULL,
image_contr VARCHAR (30),
count_contr int NOT NULL,
change_contr int NOT NULL,
debut_contr DATE NOT NULL,
fin_contr DATE NOT NULL,
login_contr VARCHAR(15) NOT NULL,
pass_contr VARCHAR(15) NOT NULL)";

$sql="CREATE TABLE objet(
code_obj BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
contr_obj BIGINT NOT NULL,
type_obj SMALLINT NOT NULL,
npost_obj SMALLINT NOT NULL,
libele_obj  VARCHAR (256) NOT NULL,
rem_obj VARCHAR (256) NOT NULL,
prix_obj DECIMAL(7,2),
image_obj VARCHAR (30),
count_obj INT NOT NULL,
debut_obj DATE NOT NULL,
fin_obj DATE NOT NULL,
login_obj VARCHAR(15) NOT NULL,
pass_obj VARCHAR(15) NOT NULL)";

$sql= "CREATE TABLE facture (
        code_fact INT(11) DEFAULT '0' NOT NULL auto_increment,
        user_fact SMALLINT UNSIGNED,
        date_fact DATE NOT NULL,
        id_fact VARCHAR(50),
        sold_fact DECIMAL(8,2) NOT NULL,
        total_fact DECIMAL(8,2) NOT NULL,
        money_fact CHAR(3) NOT NULL,
        type_fact CHAR(2) NOT NULL,
        moyen_fact VARCHAR(10) NOT NULL,
        libelle_fact VARCHAR(200) NOT NULL,
        PRIMARY KEY (code_fact)
)";

$sql= "CREATE TABLE info (
        code_info INT(11) DEFAULT '0' NOT NULL auto_increment,
        start_info DATE NOT NULL,
        end_info DATE NOT NULL,
        type_info INT NOT NULL,
        group_info TINYINT NOT NULL,
        level_info TINYINT,
        lieu_info VARCHAR(30) NOT NULL,
        libelle_info VARCHAR(200) NOT NULL,
        link_info VARCHAR(50) NOT NULL,
        PRIMARY KEY (code_info)
)";

$sql= "CREATE TABLE panier (
        code_com INT(11) DEFAULT '0' NOT NULL auto_increment,
        id_com VARCHAR(50) NOT NULL,
        art_com VARCHAR(15) NOT NULL,
        qte_com  DECIMAL(8,2) NOT NULL,
        date_com DATE NOT NULL,
        cli_com SMALLINT UNSIGNED NOT NULL,
        PRIMARY KEY (code_com)
)";

$sql= "CREATE TABLE livredor (
   code int(11) DEFAULT '0' NOT NULL auto_increment,
   date varchar(20) NOT NULL,
   nom varchar(50),
   email varchar(50),
   commentaire blob,
   PRIMARY KEY (code)
)";

$sql="CREATE TABLE forum_type (
  ft_id int(255) DEFAULT '0' NOT NULL auto_increment,
  ft_name varchar(255) DEFAULT 'Unknown' NOT NULL,
  ft_desc varchar(255) DEFAULT 'No Description given' NOT NULL,
  PRIMARY KEY (ft_id)
)";

$sql="CREATE TABLE lien (
        code_lien VARCHAR(50) NOT NULL,
        libelle_lien VARCHAR(100) NOT NULL,
        type_lien INT NOT NULL,
        note_lien TINYINT,
        group_lien TINYINT NOT NULL,
        PRIMARY KEY (code_lien)
)";


$sql ="CREATE TABLE article (
code_art VARCHAR(15) NOT NULL PRIMARY KEY,
cfour_art VARCHAR(10) NOT NULL,
nom_art VARCHAR(25) NOT NULL,
text_art VARCHAR(50) NOT NULL,
img_art VARCHAR(50) NOT NULL,
gr_art INT NOT NULL,
date_art DATE,
qte_art DECIMAL(4,2) NOT NULL,
com_art DECIMAL(4,2) NOT NULL,
tot_art DECIMAL(5,2) NOT NULL,
taux_art DECIMAL(2,2) NOT NULL,
marg_art DECIMAL(3,2) NOT NULL,
unit_art TINYINT NOT NULL,
pa_art DECIMAL(8,2) NOT NULL,
pv_art DECIMAL(8,2) NOT NULL
)";

$sql="CREATE TABLE annonce (
code_ann BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
type_ann SMALLINT NOT NULL,
group_ann TINYINT NOT NULL,
libele_ann  VARCHAR (70) NOT NULL,
prix_ann DECIMAL(7,2),
contact_ann VARCHAR (20) NOT NULL,
image_ann VARCHAR (30),
date_ann DATE NOT NULL
)";


$sql="CREATE TABLE art_group (
code_ag VARCHAR(16) NOT NULL PRIMARY KEY,
text_ag VARCHAR(20) NOT NULL,
image_ag VARCHAR(30) NOT NULL)";


$sql="CREATE TABLE four (
code_four  VARCHAR(12) NOT NULL PRIMARY KEY,
titre_four  VARCHAR(15) NOT NULL,
soc_four  VARCHAR(25) NOT NULL,
nom_four  VARCHAR(25) NOT NULL,
rue_four  VARCHAR(25) NOT NULL,
rue1_four  VARCHAR(25) NOT NULL,
npost_four  VARCHAR(10) NOT NULL,
loc_four  VARCHAR(25) NOT NULL,
lieu_four  VARCHAR(25) NOT NULL,
tel_four  VARCHAR(15) NOT NULL,
tel1_four  VARCHAR(15) NOT NULL,
fax_four  VARCHAR(15) NOT NULL,
gsm_four  VARCHAR(15) NOT NULL,
rem_four  VARCHAR(100) NOT NULL,
rel_four  VARCHAR(25) NOT NULL,
mail_four  VARCHAR(25) NOT NULL,
web_four  VARCHAR(25) NOT NULL,
login_four VARCHAR(15) NOT NULL,
pass_four VARCHAR(15) NOT NULL,
sold_four   DECIMAL(8,2) NOT NULL,
tot_four  DECIMAL(8,2) NOT NULL)";


$sql ="CREATE TABLE client (
code_cli SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
titre_cli VARCHAR(15) NOT NULL,
soc_cli VARCHAR(25) NOT NULL,
nom_cli VARCHAR(25) NOT NULL,
pre_cli VARCHAR(25) NOT NULL,
rue_cli VARCHAR(25) NOT NULL,
rue1_cli VARCHAR(25) NOT NULL,
npost_cli VARCHAR(10) NOT NULL,
loc_cli VARCHAR(20) NOT NULL,
lieu_cli VARCHAR(2) NOT NULL,
tel_cli VARCHAR(15) NOT NULL,
tel1_cli VARCHAR(15) NOT NULL,
fax_cli VARCHAR(15) NOT NULL,
gsm_cli VARCHAR(15) NOT NULL,
type_cli SMALLINT UNSIGNED,
date_cli DATE NOT NULL,
bird_cli DATE NOT NULL,
rem_cli VARCHAR(100) NOT NULL,
mail_cli VARCHAR(30) NOT NULL,
web_cli VARCHAR(25) NOT NULL,
sold_cli DECIMAL(8,2) NOT NULL,
tot_cli DECIMAL(8,2) NOT NULL,
money_cli CHAR(3) NOT NULL,
lang_cli CHAR(3) NOT NULL,
pays_cli CHAR(3) NOT NULL,
pass_cli VARCHAR(15) NOT NULL,
session_cli VARCHAR(50) NOT NULL,
)";

#
# Table structure for table 'forum_topic'
#

$sql="CREATE TABLE forum_topic (
  ftp_id int(255) DEFAULT '0' NOT NULL auto_increment,
  ft_id int(255) DEFAULT '0' NOT NULL,
  topic varchar(255) DEFAULT 'NONE' NOT NULL,
  PRIMARY KEY (ftp_id)
)";

$sql="CREATE TABLE forum_data (
  fd_id int(255) DEFAULT '0' NOT NULL auto_increment,
  ftp_id int(255) DEFAULT '0' NOT NULL,
  name varchar(255) DEFAULT 'unknown' NOT NULL,
  msg text DEFAULT '' NOT NULL,
  email varchar(255) DEFAULT 'unknown' NOT NULL,
  fd_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  author enum('Y','N') DEFAULT 'N' NOT NULL,
  PRIMARY KEY (fd_id)
)";


#
# Table structure for table 'forum_type'
#


#
# Creating indexes on tables
#
create index topic_ft on forum_topic (ft_id);

create index data_ftp on forum_data (ftp_id);