create table alhikma_archive (
   archive_id int not null auto_increment,
   archive_title varchar(255),
   archive_title_en varchar(255),
   archive_details blob,
   archive_details_en blob,
   primary key(archive_id)
);

CREATE TABLE alhikma_news (
  news_id int(11) NOT NULL auto_increment,
  news_title varchar(255),
  news_title_en varchar(255),
  news_details blob,
  news_details_en blob,
  PRIMARY KEY  (news_id)
);

CREATE TABLE alhikma_articles (
  art_id int(11) NOT NULL auto_increment,
  art_cat tinyint,
  art_title varchar(255),
  art_title_en varchar(255),
  art_details blob,
  art_details_en blob,
  PRIMARY KEY  (art_id)
);

create table alhikma_pix_lib (
   pic_id int not null auto_increment,
   pic_art int,
   pic_more varchar(255),
   pic_more_en varchar(255),
   primary key(pic_id)
);

CREATE TABLE alhikma_sites (
  site_id int(11) NOT NULL auto_increment,
  site_title varchar(255),
  site_title_en varchar(255),
  site_url varchar(255),
  PRIMARY KEY  (site_id)
);

create table alhikma_wm (
   id char,
   login varchar(255),
   password varchar(255)
) ;

insert into alhikma_wm set id='a',login='school123hikma',password='0School123Hikma0' ;

create table alhikma_students (
	stu_num int,
	stu_name varchar(50),
	stu_pass varchar(20),
	stu_clas tinyint
);