This project is read-only.
[IndexOnly]
[Directory('d:\test11\VEnglishNews\')]
[DBTableName('VEnglishNews')]
[DBAdapter('SQLSERVER2005')]
[DBConnect('Data Source=(local);Initial Catalog=Test;Integrated Security=True')]
Create table VEnglishNews
(
   GroupId    Int Untokenized NULL default 0,
   GroupTitle NVarchar(max) Tokenized Analyzer 'EnglishAnalyzer' NULL default '',
   SiteId     Int Untokenized NULL default 0,
   Site       NVarchar(max) Tokenized Analyzer 'EnglishAnalyzer' NULL default '',
   Title      NVarchar(max) Tokenized Analyzer 'EnglishAnalyzer' NULL default '',
   Content    NVarchar(max) Tokenized Analyzer 'EnglishAnalyzer' NULL default '',
   SearchContent NVarchar(max) Tokenized Analyzer 'EnglishAnalyzer' NULL default '',
   Time       DateTime Untokenized NULL default '1900-1-1',
   URL        NVarchar(max) NULL,
   ImageUrl   NVarchar(max) NULL 
);

This is a sample to create table.
[IndexOnly] is for passive table. For active table, please remove this attribute.
[Directory ('d:\test11\VEnglishNews\')] is the local directory for cache, index files. [DBTableName ('VEnglishNews')] is the name of the table in relational database. [DBAdapter ('SQLSERVER2005')] is the data adapter [DBConnect ('Data Source=(local);Initial Catalog=Test;Integrated Security=True')] is connection string to relational database.

 

Last edited Aug 16, 2011 at 3:49 AM by linkspeed, version 2

Comments

No comments yet.