CREATE TABLE pa_campaigns(
campaignid int NOT NULL CONSTRAINT PK_pa_campaigns1 PRIMARY KEY,
name varchar(100) NULL,
description text NULL,
dateinserted datetime NULL,
deleted tinyint DEFAULT 0 NOT NULL,
disabled tinyint DEFAULT 0 NOT NULL,
signupbanner varchar(250) NULL,
cookielifetime int NOT NULL,
clickapproval tinyint NULL,
saleapproval tinyint NULL,
policy tinyint NULL,
commtype tinyint NOT NULL,
products text NULL)
;
один из. Как я понял, ругается на CONSTRAINT PK_pa_campaigns1, убирал во всех запросах, все равно что нибудь еще не так(
Добавлено через 10 минут
Database SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'я╗┐INSERT INTO wd_g_accounts VALUES ('default1', 'Default account', 'Do not dele' at line 1 SQL: я╗┐INSERT INTO wd_g_accounts VALUES ('default1', 'Default account', 'Do not delete', '2005-02-22 07:14:08', 0);
Because some of the SQL commands failed, the database can be in inconsistent state.It is recomended to delete all database tables that might be created before trying installing database again!
Выдает скрипт при инсталяции.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT PK_pa_merchants1 PRIMARY KEY,
username varchar(30) NOT NULL,
passwo' at line 2
При добавлении вручную...
