CREATE TABLE IF NOT EXISTS ap_abs.users (
`id` int(11) NOT NULL auto_increment,
`login` varchar(16) character set cp1251 collate cp1251_general_cs default NULL,
`password` varchar(32) character set cp1251 collate cp1251_general_cs default NULL,
`name` tinytext NOT NULL,
`fullname` tinytext NOT NULL,
`foto` varchar(255),
`email` tinytext NOT NULL,
`icq` int(12) NOT NULL,
`phone` varchar(25) default NULL,
`date_reg` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`activity` varchar(3) NOT NULL,
`levelaccess` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`)
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)INSERT INTO ap_abs.users
(login, password, name, activity, levelaccess) VALUES ('supervisor',
'4f2813e08cb977fafa68a5f0db01322b','Администратор','on',
'3')
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.razdels (
`id` int(10) unsigned NOT NULL auto_increment,
`parent_id` int(10) unsigned default '0',
`name` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`keywords` varchar(255) NOT NULL,
`url_name` varchar(255) NOT NULL,
`content` text NOT NULL,
`searchable_content` text NOT NULL,
`creator` int(11) NOT NULL,
`datetime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`vis` varchar(3) NOT NULL default 'on',
`inner_pages` varchar(3) NOT NULL,
`punkts_in_menu` varchar(3) NOT NULL default 'on',
`no_podrazdel` varchar(3) NOT NULL default 'off',
`turn` int(10) unsigned NOT NULL,
`razdfloat` varchar(3) default 'of',
PRIMARY KEY (`id`)
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.pages (
`id` int(11) unsigned NOT NULL auto_increment,
`razdel_id` int(10) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`chpu` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`keywords` varchar(255) NOT NULL,
`anons` text NOT NULL,
`content` text NOT NULL,
`searchable_content` LONGTEXT NOT NULL,
`createtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`updatetime` timestamp NOT NULL default '0000-00-00 00:00:00',
`creator` int(11) NOT NULL,
`vis` varchar(3) NOT NULL default 'on',
`turn` int(10) unsigned NOT NULL,
`dbs_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `razdel_id` (`razdel_id`)
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.pages_list (
`title` varchar(255) NOT NULL,
`id` int(11) unsigned NOT NULL auto_increment PRIMARY KEY
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.news (
`id` int(11) unsigned NOT NULL auto_increment,
`thema_news` VARCHAR(255) NOT NULL,
`anons_news` VARCHAR(255) NOT NULL,
`anons_pict` VARCHAR(255) NOT NULL,
`content_news` TEXT,
`num_words_in_anons` TINYINT UNSIGNED NOT NULL,
`createtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`updatetime` timestamp NOT NULL default '0000-00-00 00:00:00',
`creator` int(11) NOT NULL,
`vis` varchar(3) NOT NULL default 'on',
`turn` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.tblinfo
(id INT UNSIGNED auto_increment PRIMARY KEY,
tablename VARCHAR(255),
fulltablename TEXT,
url TEXT,
fieldname TEXT,
fieldlist TEXT)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.navigation (
`marker` varchar( 255 ) NOT NULL ,
`lastpoint` varchar( 255 ) NOT NULL ,
`template` varchar( 255 ) NOT NULL ,
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`razd` varchar(3),
PRIMARY KEY ( `id` )
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.shop_groups ( `id` int( 10 ) unsigned NOT NULL auto_increment ,
`parent_id` int( 10 ) unsigned NOT NULL default '0',
`turn` int( 10 ) unsigned NOT NULL ,
`url` varchar( 255 ) NOT NULL ,
`name` varchar( 255 ) NOT NULL ,
`title` varchar( 255 ) NOT NULL ,
`descr` varchar( 255 ) NOT NULL ,
`keywords` varchar( 255 ) NOT NULL ,
`text` text NOT NULL ,
`stext` text NOT NULL ,
`picture` varchar( 255 ) NOT NULL ,
`visible` varchar( 3 ) NOT NULL default 'on',
PRIMARY KEY ( `id` )
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.shop_cards (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`parent_id` int( 10 ) unsigned NOT NULL default '0',
`group_id` INT UNSIGNED NOT NULL,
`articul` VARCHAR(255) NOT NULL,
`vendor` VARCHAR(255) NOT NULL,
`model` VARCHAR(255) NOT NULL,
`descript` TEXT NOT NULL,
`pic1` VARCHAR(255) NOT NULL,
`pic2` VARCHAR(255) NOT NULL,
`pic3` VARCHAR(255) NOT NULL,
`pic4` VARCHAR(255) NOT NULL,
`pic5` VARCHAR(255) NOT NULL, prop0 VARCHAR(255) NOT NULL, prop1 VARCHAR(255) NOT NULL, prop2 VARCHAR(255) NOT NULL,
price1 FLOAT DEFAULT 0,
price2 FLOAT DEFAULT 0,
price3 FLOAT DEFAULT 0,
col INT UNSIGNED DEFAULT 0
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.shop_prop (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 255 ) NOT NULL ,
`descr` TEXT NOT NULL,
`vis` VARCHAR(3),
`backofice` VARCHAR( 3 ) NOT NULL DEFAULT 'off')
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.shop_prop_content (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`prop_id` INT UNSIGNED NOT NULL ,
`tovar_id` INT UNSIGNED NOT NULL ,
`znachenie` TEXT NOT NULL ,
`vis` VARCHAR( 3 ) NOT NULL
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.shop_images (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`tovar_id` INT UNSIGNED NOT NULL ,
`name` VARCHAR( 255 ) NOT NULL ,
`mimetype` VARCHAR( 20 ) NOT NULL ,
`width` INT UNSIGNED NOT NULL ,
`height` INT UNSIGNED NOT NULL ,
`alt` VARCHAR( 255 ) NOT NULL,
`osn` VARCHAR (3) NOT NULL DEFAULT 'off'
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.shop_order_dannye_content (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`zakaz_id` INT UNSIGNED NOT NULL ,
`tovar_id` INT UNSIGNED NOT NULL ,
`col` INT UNSIGNED NOT NULL
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.shop_order_dannye (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`status` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR( 50 ) NOT NULL ,
`phone` VARCHAR( 50 ) NOT NULL ,
`adres` VARCHAR( 255 ) NOT NULL ,
`dostavka` VARCHAR( 255 ) NOT NULL ,
`oplata` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` ))
Access denied for user 'zapchasti'@'localhost' (using password: NO)CREATE TABLE IF NOT EXISTS ap_abs.shop_prop_sprav (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`prop_id` INT UNSIGNED NOT NULL ,
`value` VARCHAR( 50 ) NOT NULL
)
Access denied for user 'zapchasti'@'localhost' (using password: NO)