Skip to content
Permalink
main
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Tour-Guide/schema.sql

Go to file
 
 
Cannot retrieve contributors at this time
6 lines (4 sloc) 349 Bytes
Raw Blame
Open in GitHub Desktop
create table users( id integer primary key AUTOINCREMENT, name text not null, password text not null, admin boolean
not null DEFAULT '0');
create table sch ( empid integer primary key AUTOINCREMENT, name text not null, email text, phone integer,
address text,service integer, travel text, joining_date timestamp DEFAULT CURRENT_TIMESTAMP );