[Firebird-net-provider] database structure

[Pavol S. <st...@ra...>]

hi,

here is database structure...
in ARTICLES table is aprox. 20000 articles each up to 32k long...

Table PROGWORDS is filled by words from articles by program i posted
yesterday... i found there more then 60k of words...

of course there are indexes and generators defined too...

what problems i have with this:
when i download sources (erase directory and then checkout module) i cannot
compile it or i have that PINVOKE problem after runing program... for
example tonight (2/10/2003 23:27) a get this:

clean:

release:

build-dll:
    [mkdir] Creating directory C:\PROJEKTY\Net-Provider\build
      [csc] Compiling 58 files to
C:\PROJEKTY\Net-Provider\build\FirebirdSql.Dat
a.Firebird.dll
c:\PROJEKTY\Net-Provider\source\FbConnection.cs(123,3): warning CS1574: XML
comm
ent on 'FirebirdSql.Data.Firebird.FbConnection.ConnectionTimeout' has cref
attri
bute 'FbConnection.ConnectionString.htm' that could not be found
c:\PROJEKTY\Net-Provider\source\FbStatement.cs(312,6): error CS0117:
'FirebirdSq
l.Data.Firebird.FbConnection' does not contain a definition for 'Charset'
c:\PROJEKTY\Net-Provider\source\FbStatement.cs(313,6): error CS0117:
'FirebirdSq
l.Data.Firebird.FbConnection' does not contain a definition for 'Dialect'


BUILD FAILED
C:\PROJEKTY\Net-Provider\FirebirdNetProvider.build(51,10): External program
retu
rned errors, see build log for details.
Try 'nant -help' for more information

im affraid, that you sometimes commit chanes, that are not compilable :(

p.

CREATE TABLE "ARTICLES"
(
  "ID" INTEGER,
  "VYDANIE" INTEGER,
  "NADNADPIS" VARCHAR(4096) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
  "NADPIS" VARCHAR(4096) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
  "PEREX" VARCHAR(4096) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
  "TEXT" VARCHAR(32765) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
  "KATEGORIA" CHAR(5) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
  "DATUM" DATE
);

CREATE TABLE "PROGWORDS"
(
  "ID" INTEGER NOT NULL,
  "WORD" VARCHAR(40) CHARACTER SET WIN1250 COLLATE PXW_SLOV
);