Advertisement
Guest User

Untitled

a guest
Dec 11th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Delphi 1.22 KB | None | 0 0
  1. SQLDB:=TSQLiteDatabase.Create(ServiceName+'.db');
  2. //SQLDB.ExecSQL('CHARACTER SET utf8 COLLATE utf8_unicode_ci');
  3. SQLDB.ExecSQL('CREATE TABLE `INFO` (version VARCHAR(20) PRIMARY KEY, author VARCHAR(120), version_software VARCHAR(20), name_project VARCHAR(20), date_create VARCHAR(20))');
  4. SQLDB.ExecSQL('CREATE TABLE `PROGRESS` (ID INTEGER PRIMARY KEY, NAME_METHOD VARCHAR(255), ID_METHOD INTEGER)');
  5. SQLDB.ExecSQL('CREATE TABLE `NETWORK` (ID INTEGER PRIMARY KEY, METHOD VARCHAR(120), LINK VARCHAR(255),'+
  6. 'HEADERS TEXT, POST TEXT, PROTOCOL VARCHAR(4), TIMEOUT INTEGER, TIMEOUT_KEEPALIVE INTEGER, MY_UA INTEGER,'+
  7. 'UA VARCHAR(255), MYNETYPE VARCHAR(255), I_VAR_SETTING TEXT, VAR_SETTING TEXT)');
  8. SQLDB.ExecSQL('CREATE TABLE `PROCEDURES` (ID INTEGER PRIMARY KEY, NAME_PROCEDURE VARCHAR(255), MY_VAR TEXT)');
  9. SQLDB.ExecSQL('CREATE TABLE `FUNCTIONS` (ID INTEGER PRIMARY KEY, NAME_FUNCTIONS VARCHAR(255), MY_VAR TEXT)');
  10. SQLDB.ExecSQL('CREATE TABLE `LOGS`  (ID INTEGER PRIMARY KEY, LOG TEXT)');
  11. SQLDB.ExecSQL('INSERT INTO `INFO` (`version`, `author`, `version_software`, `name_project`, `date_create`) VALUES("'+Unit1.VersionSoftware+'", "'+LabeledEdit2.Text+'", "'+Unit1.VersionSoftware+'", "'+ServiceName+'", "'+DT+'")');
  12. FreeAndNil(SQLDB);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement