Sqler/doc/Sqler.md

http://localhost:4570/sqler/index.html

---

Sqler SqlRun SqlBackup
SqlVersion DataEditor SqlStation DataImport

---

(x.1)SqlRun

(x.x.1)SqlRun����
(x.x.2)SqlRun 

---

SqlBackup (x.2)�����뻹ԭ

(x.x.1)�����뻹ԭ����
(x.x.2)SqlServer�����뻹ԭ
(x.x.3)MySql�����뻹ԭ

---

DbPort (x.3)���뵼������

---

(x.4)SqlVersion

(x.x.1)SqlVersion����
(x.x.2)ģ����� 
(x.x.3)������¼      

---

(x.5)DataEditor

(x.x.1)DataEditor����
(x.x.2)Schema
(x.x.3)DataEditor

---

(x.6)SqlStation

SqlVersion Create table

sql server:

drop TABLE sqler_version;

if object_id(N'sqler_version', N'U') is null CREATE TABLE if not exists sqler_version(

[id] [int] IDENTITY(1,1) NOT NULL,
[module] [nvarchar](100) NULL,
[version] [int] NULL,
[success] [int] NOT NULL,
[result] [nvarchar](100) NULL,
[code] [nvarchar](4000) NULL,
[exec_time] [datetime] NULL,
[remarks] [nvarchar](1000) NULL

)

---

sqlite:

drop TABLE sqler_version;

CREATE TABLE if not exists sqler_version(

[id] INTEGER PRIMARY KEY   autoincrement,
[module] [nvarchar](100) NULL,
[version] [int] NULL,
[success] [int] NOT NULL,
[result] [nvarchar](100) NULL,
[code] [nvarchar](4000) NULL,
[exec_time] [datetime] NULL,
[remarks] [nvarchar](1000) NULL

);

---

mysql:

drop TABLE sqler_version;

CREATE TABLE if not exists sqler_version(

id  int(4) primary key not null auto_increment,
module [nvarchar](100) NULL,
version [int] NULL,
success [int] NOT NULL,
result [nvarchar](100) NULL,
code [nvarchar](4000) NULL,
exec_time [datetime] NULL,
remarks [nvarchar](1000) NULL

);