| Revision 7588,
723 bytes
checked in by adir, 11 years ago
(diff) |
|
Ticket #000 - Adicionando a integracao de buscas com Solr na base a ser isnerida na comunidade
|
| Line | |
|---|
| 1 | CREATE SCHEMA PUBLIC AUTHORIZATION DBA |
|---|
| 2 | CREATE CACHED TABLE ITEM(ID CHAR(8),NAME VARCHAR(100),MANU VARCHAR(50),WEIGHT REAL,PRICE REAL,POPULARITY INTEGER,INCLUDES VARCHAR(200),LAST_MODIFIED TIMESTAMP DEFAULT NOW) |
|---|
| 3 | CREATE CACHED TABLE FEATURE(ITEM_ID CHAR(8),DESCRIPTION VARCHAR(200),LAST_MODIFIED TIMESTAMP DEFAULT NOW) |
|---|
| 4 | CREATE CACHED TABLE CATEGORY(ID INTEGER,DESCRIPTION VARCHAR(30),LAST_MODIFIED TIMESTAMP DEFAULT NOW) |
|---|
| 5 | CREATE CACHED TABLE ITEM_CATEGORY(ITEM_ID CHAR(8),CATEGORY_ID INTEGER,LAST_MODIFIED TIMESTAMP DEFAULT NOW) |
|---|
| 6 | SET TABLE ITEM INDEX'15056 0' |
|---|
| 7 | SET TABLE FEATURE INDEX'22424 0' |
|---|
| 8 | SET TABLE CATEGORY INDEX'18856 0' |
|---|
| 9 | SET TABLE ITEM_CATEGORY INDEX'17328 0' |
|---|
| 10 | CREATE USER SA PASSWORD "" |
|---|
| 11 | GRANT DBA TO SA |
|---|
| 12 | SET WRITE_DELAY 20 |
|---|
Note: See
TracBrowser
for help on using the repository browser.
