notes.txt

 <!-- <ol class="lists collection list-group list-group-numbered">
                {{range $i , $Titles := .Titles}}
                <li class="list-group-item">
                    <span>{{$Titles}}-<a href="http://localhost:3000/route{{index $.Urls $i}}" target="_blank">{{index
                            $.Urls $i}}</a></span>
                    <span>
                        <a class="waves-effect waves-teal btn-flat" href="/delete/true/{{$Titles}}">Delete</a>
                        <a class="waves-effect waves-teal btn-flat"
                            href="/addlib/true/{{index $.Libtag }}/{{$Titles}}">Add Library {{index $.Libtag }}</a>
                    </span>
                </li>
                {{end}}
                <li class="list-group-item"><span>
                        <div>Footer</div>
                    </span>
                    <span><a class="waves-effect waves-teal btn-flat" href="/addlib/true/footer">Delete</a></span>
                </li>
            </ol> -->

CREATE TABLE "urls" (
	"id"	INTEGER,
	"urls"	TEXT,
	"titles"	TEXT,
	"lib"	TEXT,
	"libtag"	TEXT,
	"css"	TEXT,
	"csstag"	TEXT,
	"filename"	TEXT,
	PRIMARY KEY("id" AUTOINCREMENT)
);

CREATE TABLE "nav" (
	"id"	INTEGER,
	"a"	TEXT,
	"b"	TEXT,
	"c"	TEXT,
	"d"	TEXT,
	"e"	TEXT,
	"f"	TEXT,
	"g"	TEXT,
	"h"	TEXT,
	"i"	TEXT,
	"j"	TEXT,
	PRIMARY KEY("id" AUTOINCREMENT)
);



CREATE TABLE "library" (
	"id"	INTEGER,
	"lib"	TEXT,
	"tag"	TEXT,
	PRIMARY KEY("id" AUTOINCREMENT)
);
CREATE TABLE `urls`.`urls` ( `id` INT NOT NULL AUTO_INCREMENT , `urls` TEXT NOT NULL , `titles` TEXT NOT NULL , `lib` TEXT NOT NULL , `libtag` TEXT NOT NULL , `css` TEXT NOT NULL , `csstag` TEXT NOT NULL , `filename` TEXT NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

//CREATE TABLE IF NOT EXISTS user (id integer NOT NULL primary KEY AUTOINCREMENT,  sdfa int  NOT NULL,   sfda  bool  NOT NULL );