home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: InfoMgt
/
InfoMgt.zip
/
mnoteb05.zip
/
mnote.sql
< prev
next >
Wrap
Text File
|
1999-12-23
|
1KB
|
50 lines
## ***********************************************
## Creates mysql table for MultiNote
## Version 1.00
##
## ***********************************************
## 991224: Started.
## ***********************************************
## Select database
## DROP DATABASE IF EXISTS mn;
## CREATE DATABASE mn;
## USE mn;
## Drop tables
DROP TABLE IF EXISTS tMNdb;
DROP TABLE IF EXISTS tMNitem;
## (Re)create the tables
CREATE TABLE tMNdb
(
dbid INT NOT NULL AUTO_INCREMENT,
title VARCHAR(255),
lastactivetab INT,
numrecords INT,
datecreate DATE,
datemodify DATE,
PRIMARY KEY (dbid)
);
CREATE TABLE tMNitem
(
itemid INT NOT NULL AUTO_INCREMENT,
rel_dbid INT,
title VARCHAR(32),
tabid INT,
recordsintab INT,
lastsel INT,
tabpsw VARCHAR(32),
level INT,
colorfore INT,
colorback INT,
font VARCHAR(32),
flags INT,
marked INT,
itemtype INT,
memo LONGBLOB,
PRIMARY KEY (itemid)
);