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)