# MySQL-Front 3.2  (Build 13.38)


# Host: localhost    Database: magazine
# ------------------------------------------------------
# Server version 4.0.20a-nt

#
# Table structure for table mag_name
#

DROP TABLE IF EXISTS `mag_name`;
CREATE TABLE `mag_name` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table mag_name
#


#
# Table structure for table mag_numbers
#

DROP TABLE IF EXISTS `mag_numbers`;
CREATE TABLE `mag_numbers` (
  `id` int(11) NOT NULL auto_increment,
  `description` varchar(255) NOT NULL default '',
  `mag_id` int(11) NOT NULL default '0',
  `mag_no` int(11) NOT NULL default '0',
  `pages_width` int(4) NOT NULL default '0',
  `pages_height` int(4) NOT NULL default '0',
  `contents_page` int(11) NOT NULL default '2',
  `bg_color` varchar(6) NOT NULL default '',
  `bg_image` int(1) NOT NULL default '0',
  `loader_color` varchar(6) NOT NULL default '',
  `panel_color` varchar(6) NOT NULL default '',
  `button_color` varchar(6) NOT NULL default '',
  `text_color` varchar(6) NOT NULL default '',
  `mag_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table mag_numbers
#


#
# Table structure for table mag_pages
#

DROP TABLE IF EXISTS `mag_pages`;
CREATE TABLE `mag_pages` (
  `id` int(11) NOT NULL auto_increment,
  `mag_no_id` int(11) NOT NULL default '0',
  `file_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table mag_pages
#


#
# Table structure for table page_markers
#

DROP TABLE IF EXISTS `page_markers`;
CREATE TABLE `page_markers` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `mag_id` int(11) NOT NULL default '0',
  `mag_no` int(11) NOT NULL default '0',
  `page_no` int(11) NOT NULL default '0',
  `page_marker` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table page_markers
#


#
# Table structure for table page_notes
#

DROP TABLE IF EXISTS `page_notes`;
CREATE TABLE `page_notes` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `mag_id` int(11) NOT NULL default '0',
  `mag_no` int(11) NOT NULL default '0',
  `page_no` int(11) NOT NULL default '0',
  `page_note` text NOT NULL,
  `note_win` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table page_notes
#


#
# Table structure for table users
#

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(50) NOT NULL default '',
  `password` varchar(16) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table users
#


#
# Table structure for table users_bg
#

DROP TABLE IF EXISTS `users_bg`;
CREATE TABLE `users_bg` (
  `id` int(11) NOT NULL auto_increment,
  `bg_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `mag_name_id` int(11) NOT NULL default '0',
  `mag_no_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table users_bg
#

