MySQL Data Transfer Source Host localhost Source Database arka_armbank

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
/*
MySQL Data Transfer
Source Host: localhost
Source Database: arka_armbanks
Target Host: localhost
Target Database: arka_armbanks
Date: 6/11/2009 6:11:39 AM
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for blogs
-- ----------------------------
DROP TABLE IF EXISTS `blogs`;
CREATE TABLE `blogs` (
`id` tinyint(3) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` tinyint(3) NOT NULL auto_increment,
`id_parent` tinyint(3) NOT NULL default '0',
`category_rus` varchar(150) NOT NULL default '',
`category_eng` varchar(150) default NULL,
`category_arm` varchar(150) default NULL,
`status` tinyint(1) NOT NULL default '0',
`category_order` tinyint(2) NOT NULL default '0',
`url` varchar(150) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`,`id_parent`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;