Subject | Re: |
---|---|
Author | Aurimas Tutinas |
Post date | 2010-07-01T10:15:41Z |
Also i have script file db.script, with such code:
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE NOTE(TITLE CHAR(30) NOT NULL PRIMARY KEY,BODY CHAR(255) NOT NULL,ADDEDBY CHAR(20) NOT NULL)
CREATE MEMORY TABLE USER(USERNAME VARCHAR(100) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,SURNAME VARCHAR(100) NOT NULL,PASSWORD VARCHAR(10) NOT NULL, ADMIN CHAR(30) NOT NULL)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO NOTE VALUES('Labas rytas','Labas rytas, kokia siandien grazi diena, sviecia saule, silta. ','admin')
INSERT INTO USER VALUES('admin','Aurimas','Tutinas','admin','true')
that's is used to create tables in hsql db, that i am using. Can i write such script for firebird db in my app?
[Non-text portions of this message have been removed]
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE NOTE(TITLE CHAR(30) NOT NULL PRIMARY KEY,BODY CHAR(255) NOT NULL,ADDEDBY CHAR(20) NOT NULL)
CREATE MEMORY TABLE USER(USERNAME VARCHAR(100) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,SURNAME VARCHAR(100) NOT NULL,PASSWORD VARCHAR(10) NOT NULL, ADMIN CHAR(30) NOT NULL)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO NOTE VALUES('Labas rytas','Labas rytas, kokia siandien grazi diena, sviecia saule, silta. ','admin')
INSERT INTO USER VALUES('admin','Aurimas','Tutinas','admin','true')
that's is used to create tables in hsql db, that i am using. Can i write such script for firebird db in my app?
[Non-text portions of this message have been removed]