nativebinary - SqlCreateStatementToAhaWikiFormat

create table Link
(
	src varchar(255) not null comment '시작',
	dst varchar(255) not null comment '대상',
	alias varchar(255) null comment '별명',
	primary key (src, dst)
)
comment '링크';

create table Page
(
	name varchar(255) not null,
	revision int not null,
	time bigint null,
	author text null,
	remoteAddress text null,
	content longtext null,
	comment text null,
	primary key (name, revision)
);

create table CosineSimilarity
(
	name1 varchar(255) not null,
	name2 varchar(255) not null,
	similarity double null,
	primary key (name1, name2),
	constraint fkCosineSimilarityName1
		foreign key (name1) references Page (name),
	constraint fkCosineSimilarityName2
		foreign key (name2) references Page (name)
);

create table TermFrequency
(
	name varchar(255) not null,
	term varchar(255) not null,
	frequency int null,
	primary key (name, term),
	constraint fkTermFrequencyName
		foreign key (name) references Page (name)
);

create table play_evolutions
(
	id int not null
		primary key,
	hash varchar(255) not null,
	applied_at timestamp default CURRENT_TIMESTAMP not null,
	apply_script mediumtext null,
	revert_script mediumtext null,
	state varchar(255) null,
	last_problem mediumtext null
);

create table wiki
(
	name varchar(255) not null,
	version int not null,
	time bigint null,
	author text null,
	ipnr text null,
	text longtext null,
	comment text null,
	readonly int null,
	constraint sqlite_autoindex_wiki_1
		unique (name, version)
);

create index wiki_time_idx
	on wiki (time);

alter table wiki
	add primary key (name, version);